Search found 192 matches

by mister_v
Tue Nov 08, 2016 7:35 pm
Forum: Servers
Topic: Lots of audit messages polluting my logs
Replies: 1
Views: 24561

Lots of audit messages polluting my logs

Hi, I have tons of audit denied messages in my logs and dmesg: [ 528.090461] audit: type=1400 audit(1478343185.933:743): avc: denied { create } for pid=2785 comm="auditd" name="auditd" scontext=user_u:user_r:user_t tcontext=user_u:object_r:initrc_state_t tclass=lnk_file permissiv...
by mister_v
Mon Oct 31, 2016 1:05 pm
Forum: Shell
Topic: screen connect: No such file or directory
Replies: 1
Views: 23100

screen connect: No such file or directory

Hello,

I get the following error:

Code: Select all

# screen
/tmp/screen/S-root/2##7.pts-0.host: connect: No such file or directory

Anyone known how to solve this.
I can't create a new screen session.
by mister_v
Fri Oct 28, 2016 4:21 pm
Forum: MySQL
Topic: How to get history of mysql commands
Replies: 1
Views: 24661

How to get history of mysql commands

Hi,

I noticed how you can get the previous commands in MySQL,
by using the up arrow.

Is there a way to search in the commands?
by mister_v
Wed Sep 07, 2016 5:17 pm
Forum: SQL
Topic: SOLVED: mysql compare case-sensitive
Replies: 2
Views: 23496

Re: mysql compare case-sensitive

Thanks,
that solved it for me.
by mister_v
Sat Aug 27, 2016 2:46 pm
Forum: SQL
Topic: SOLVED: mysql compare case-sensitive
Replies: 2
Views: 23496

SOLVED: mysql compare case-sensitive

The queries are case insensitive.
That is good for most cases.
But now I want a case sensitive search.
For example all names starting with a small 'a'

Code: Select all

SELECT name FROM table WHERE name LIKE 'a%'
by mister_v
Wed Aug 24, 2016 12:27 pm
Forum: SQL
Topic: ERROR 1878 (HY000): Temporary file write failure.
Replies: 2
Views: 22984

ERROR 1878 (HY000): Temporary file write failure.

I'm add a additional index on a table,
but after a few minutes I get the following error message:

Code: Select all

ERROR 1878 (HY000): Temporary file write failure.
And the index is not placed.

I check the partition, but there is still more as enough free space.
by mister_v
Wed Aug 24, 2016 12:19 pm
Forum: SQL
Topic: Solved: See live queries
Replies: 2
Views: 19613

Re: See live queries

Ok thanks

thats works.
by mister_v
Wed Aug 24, 2016 7:08 am
Forum: SQL
Topic: Solved: See live queries
Replies: 2
Views: 19613

Solved: See live queries

Hi,

How can I see all the queries that are currently running on the database?
I use mysql.
I know you can use mysql_slow.log, but that only show the slow running queries and only after.
I want to know the ones that are currently running.
by mister_v
Thu Aug 18, 2016 8:51 pm
Forum: SQL
Topic: Select a month of every year
Replies: 1
Views: 17942

Select a month of every year

Hello,

I'm creating a select-query to get the data of a specific month of every year.
So not just one month, but all the months december of 2006, 2007, 2008, ...

How do I do that?
by mister_v
Fri Jul 29, 2016 12:58 pm
Forum: Shell
Topic: add files to compressed tar-archive
Replies: 2
Views: 20798

Re: add files to compressed tar-archive

Not really what I was looking for,
but it works.

So thanks :-)