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 !

Reply via email to