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