Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have an Apache VPS server that I'm having some configuration issues with.

I'm using an open source PHP social networking program that needs to be able to write to a data directory that's on the same level as the site itself. The VPS uses Plesk, and I determined that the best way to accomplish this was to modify the PHP template file, which I did, to this:

echo "php_admin_value open_basedir {$OPT['dir']}/:/tmp/:/var/www/vhosts/SERVERNAME/data/\n";

That seemed to work fine, but now, several days later, the website is throwing a fatal exception and I am getting an error in Plesk that SQL can't write to the tmp file -- and I'm wondering if its being caused by the change I made.

Plesk won't load at all now -- there are a series or errors that start with this: SQLSTATE[HY000]: General error: 1 Can't create/write to file '/tmp/#sql_1ddd_0.MYD' (Errcode: 17)

There are also 2 errors in the server error logs: 9:01:48 [Note] /usr/libexec/mysqld: Normal shutdown

postfix/smtpd[30517]: sql_sqlite3 plugin: no result found

Any ideas what could be causing these issues?

share|improve this question
    
No, php open_basedir is not related to mysql issue. ls -lad /tmp? –  ALex_hha Jul 29 '13 at 19:09
    
Thanks - that's good to know. I did ls -lad /tmp and got "drwxrwxrwt 4 root root" –  user2336641 Jul 29 '13 at 19:47
    
try to run mysql from command line # mysqld_safe --datadir=/var/lib/mysql --user=mysql --socket=/var/lib/mysql/mysql.sock --log-error=/var/log/mysqld.log –  ALex_hha Jul 29 '13 at 20:21
    
I tried that and got the message that a sql process already exists. Apparently its a network-wide problem that the hosting company is working on resolving... Thanks so much for your help though! –  user2336641 Jul 29 '13 at 21:36

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.