On 02/13/2014 08:17 PM, Clint Dilks wrote:

Hi,

Have you verified that permissions on /tmp appear correct ?

An example from one of my systems

# ls -lsahd /tmp 4.0K drwxrwxrwt. 3 root root 4.0K Feb 14 07:01 /tm

So permissions 1777

Already checked.

[root@chiron ~]# ls -lsahd /tmp 4.0K drwxrwxrwt. 17 root root 4.0K Feb 13 20:55 /tmp

Perhaps test creating a file in /tmp as root and as a non root user and let us know the results that way we may be able to help further.

There is enough space, and I successfully created files as root, mysql and plnet user (domain owner).

[root@chiron ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/vg_chiron-LV_CHIRON_ROOT 25G 15G 8.3G 65% / tmpfs 1.3G 676K 1.3G 1% /dev/shm /dev/md0 485M 197M 263M 43% /boot /dev/mapper/vg_chiron-LG_CHIRON_EXTRA 1.8T 1.6T 143G 92% /extra

On Fri, Feb 14, 2014 at 8:06 AM, Ljubomir Ljubojevic centos@plnet.rswrote:

...

Hi.

I have a strange problem.

I installed cacti, and set it up.

When I click on the Plugins Management, I noticed Error "FATAL: Database or Table does not exist"

Further testing revealed that at the moment MySQL can not create temporary files in /tmp. It is same for ANY database!

SELinux is disabled. I logged to mysql as root and error is same.

Command used is: CREATE TEMPORARY TABLE IF NOT EXISTS plugin_temp_table LIKE bak_menu;

Error is: ERROR 1004 (HY000): Can't create file '/tmp/#sql21f8_f3_0.frm' (errno: 9)

What could be the problem, any idea how to proceed?

I do not think I edited any MySQL setting.

I forgot to mention that I use Virtualmin GPL for ~10 domains, but up until now I have not seen any problems.

On 02/13/2014 08:49 PM, Les Mikesell wrote:

On Thu, Feb 13, 2014 at 1:06 PM, Ljubomir Ljubojevic centos@plnet.rs wrote:

...

I have a strange problem.

I installed cacti, and set it up.

When I click on the Plugins Management, I noticed Error "FATAL: Database or Table does not exist"

Further testing revealed that at the moment MySQL can not create temporary files in /tmp. It is same for ANY database!

SELinux is disabled. I logged to mysql as root and error is same.

Command used is: CREATE TEMPORARY TABLE IF NOT EXISTS plugin_temp_table LIKE bak_menu;

Error is: ERROR 1004 (HY000): Can't create file '/tmp/#sql21f8_f3_0.frm' (errno: 9)

What could be the problem, any idea how to proceed?

http://bugs.mysql.com/bug.php?id=60574 The error may be on the source of the copy (bak_menu.frm) not in tmp.

This is interesting.

I tested on cacti database and on 2 Joomla databases with same results. But there might be something there.

Database changed mysql> CREATE TEMPORARY TABLE IF NOT EXISTS plugin_temp_table LIKE jos_menu; ERROR 1004 (HY000): Can't create file '/tmp/#sql21f8_f3_1.frm' (errno: 9) mysql> CREATE TEMPORARY TABLE barney (SELECT * FROM jos_menu WHERE 1=0); Query OK, 0 rows affected (0.01 sec) Records: 0 Duplicates: 0 Warnings: 0

mysql> CREATE TEMPORARY TABLE IF NOT EXISTS plugintest LIKE jos_menu; ERROR 1004 (HY000): Can't create file '/tmp/#sql21f8_f3_3.frm' (errno: 9) mysql> CREATE TEMPORARY TABLE IF NOT EXISTS barney LIKE jos_menu; Query OK, 0 rows affected, 1 warning (0.00 sec)

Changed name of table to create produced result, but with warning.

On 02/13/2014 09:21 PM, Ljubomir Ljubojevic wrote:

On 02/13/2014 09:18 PM, Ljubomir Ljubojevic wrote:

...

On 02/13/2014 08:49 PM, Les Mikesell wrote:

...

On Thu, Feb 13, 2014 at 1:06 PM, Ljubomir Ljubojevic centos@plnet.rs wrote:

...

I have a strange problem.

I installed cacti, and set it up.

When I click on the Plugins Management, I noticed Error "FATAL: Database or Table does not exist"

Further testing revealed that at the moment MySQL can not create temporary files in /tmp. It is same for ANY database!

SELinux is disabled. I logged to mysql as root and error is same.

Command used is: CREATE TEMPORARY TABLE IF NOT EXISTS plugin_temp_table LIKE bak_menu;

Error is: ERROR 1004 (HY000): Can't create file '/tmp/#sql21f8_f3_0.frm' (errno: 9)

What could be the problem, any idea how to proceed?

http://bugs.mysql.com/bug.php?id=60574 The error may be on the source of the copy (bak_menu.frm) not in tmp.

This is interesting.

I tested on cacti database and on 2 Joomla databases with same results. But there might be something there.

Database changed mysql> CREATE TEMPORARY TABLE IF NOT EXISTS plugin_temp_table LIKE jos_menu; ERROR 1004 (HY000): Can't create file '/tmp/#sql21f8_f3_1.frm' (errno: 9) mysql> CREATE TEMPORARY TABLE barney (SELECT * FROM jos_menu WHERE 1=0); Query OK, 0 rows affected (0.01 sec) Records: 0 Duplicates: 0 Warnings: 0

mysql> CREATE TEMPORARY TABLE IF NOT EXISTS plugintest LIKE jos_menu; ERROR 1004 (HY000): Can't create file '/tmp/#sql21f8_f3_3.frm' (errno: 9) mysql> CREATE TEMPORARY TABLE IF NOT EXISTS barney LIKE jos_menu; Query OK, 0 rows affected, 1 warning (0.00 sec)

Changed name of table to create produced result, but with warning.

It looks like "IF NOT EXISTS" might be creating problems.

Nope, that is not it, seams "LIKE" is the problem.