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 at 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 at 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 at plnet.rs>wrote: > >> 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. -- Ljubomir Ljubojevic (Love is in the Air) PL Computers Serbia, Europe StarOS, Mikrotik and CentOS/RHEL/Linux consultant