SecurityException in Application.cpp:188: Do not have root privileges. Executable not set-uid root

Sometimes, you may encounter with a website showing 500 internal server error and in apache error logs, it shows the following error message.

SecurityException in Application.cpp:188: Do not have root privileges. Executable not set-uid root?

Premature end of script headers: index.php

This error is because of the suphp binary which is missing its sticky/suid permissions. It can be fixed by executing the following command.

# chmod +s /opt/suphp/sbin/suphp

Once permissions are corrected, check the website, it should be working fine now.

Mysql error, Can’t create/write to file ‘/var/tmp1/#sql_e2f_0.MYI’ (Errcode: 2)]

Sometimes you may face the following error

Can’t create/write to file ‘/var/tmp1/#sql_e2f_0.MYI’ (Errcode: 2)]

This is because of big temporary tables created while executing a query due to which the tmp folder is full and unable to write the data there. The solution is to increase the size of tmp directory or change its path.

Try the following:

# mkdir /var/lib/mysql/tmp
# chown mysql:mysql /var/lib/mysql/tmp

Add the following line into the [mysqld] section:

tmpdir = /var/lib/mysql/tmp

 

Restart the service.

# /etc/init.d/mysql restart