I have an OpenBSD 3.7 webserver. The webserver use PHP and Mysql in
chrooted Apache (1.3.29).
I want to use a Bulletin Board script on webserver called Vbulletin (
http://www.vbulletin.com/ ). This Bulletin Board work but sometimes i
get this error messages :
Error 1 :
--
Database error in vBulletin 3.0.7:
Invalid SQL:
SELECT setting.*, settinggroup.grouptitle
FROM settinggroup AS settinggroup
LEFT JOIN setting AS setting USING(grouptitle)
WHERE settinggroup.displayorder <> 0
ORDER BY settinggroup.displayorder, setting.displayorder
mysql error: Can't create/write to file '/tmp/#sql_4c99_0.MYD' (Errcode: 9)
mysql error number: 1
Date: Wednesday 15th of June 2005 08:58:08 AM
Script: http://bsdforums.wplink.net/admincp/options.php?null=0
Referer: http://bsdforums.wplink.net/admincp/index.php?do=nav
Username: yo2lux
--
Error 2 :
--
Database error in vBulletin 3.0.7:
Invalid SQL:
SELECT *
FROM administrator
WHERE userid = 1
mysql error: Can't find file: './bsdforums/administrator.frm' (errno: 9)
mysql error number: 1017
--
I have a /tmp directory in /var/www with permission 0777. I think mysql
have rights to read and write in /var/www/tmp
Any idea what need to do? Vbulletin want a mysql database inside chroot ?
Thank you very much !