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 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. 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. > > -- > Ljubomir Ljubojevic > (Love is in the Air) > PL Computers > Serbia, Europe > > StarOS, Mikrotik and CentOS/RHEL/Linux consultant > _______________________________________________ > CentOS mailing list > CentOS at centos.org > http://lists.centos.org/mailman/listinfo/centos >