I'm encountering a situation with MySQL that's really driving me crazy and I have been unable to locate a solution. I'm hoping that someone on the mailing list can provide some guidance...
I'm attempting to use a piece of php software (phpBB) which is talking to a dedicated MySQL server via TCP. The MySQL install is the Mandrake 8.2 default (3.23.47). Okay, here's the error I receive using their debug mode... Couldn't obtain forum list DEBUG MODE SQL Error : 1 Can't create/write to file '/root/tmp/#sql1f77_259_0.MYI' (Errcode: 13) SELECT f.* FROM phpbb_forums f, phpbb_categories c WHERE c.cat_id = f.cat_id ORDER BY c.cat_order ASC, f.forum_order ASC Line : 166 File : /var/www/html/phpBB2/admin/admin_forumauth.php Now, before ANYONE mentions rebuilding/repairing/re-installing, etc. as I've seen in posts on the phpBB site, here's the deal... 1. I have done all of the above; 2. Upon closer examination, I find that what is happening is that MySQL wants to write to /root and /root/tmp directories. Problem is, the permissions of the directories are set to root:root. Since MySQL isn't running as root, it is unable to write to those directories. It seemed an easy solution: chown /root to root:mysql -- and the same for /root/tmp -- then chmod the directories to 770. Woo Hoo, works! (temporarily - please drop the drumsticks at this point...) Seems that at unknown times of the day, RH/Mandrake comes through and cleans up any crap one might create - including changing the ownership of /root. Lo and behold, I come back to the development system and find that I can no longer access - again - since the system reset the permissions! Obviously, it is a bad idea to run MySQL as root. At the same time, one can't really (shouldn't?) change the /root ownership/permissions... Needless to say, each time I reset permissions on the directories, all works according to the plan. Each time the permissions are reset, the system churns out vomitus, like after eating stale nachos and cigarette butts. I've been told (we've all heard that before) that I should be looking at my.cfg - however, I can't find this file to save my life (does it really exist???) Needless to say, suggestions are more than welcome. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
