FS#2140 - Mysql permissions issue (doesn't allow mysql to start)

Attached to Project: Arch Linux
Opened by Ian Jones (Ian_J) - Saturday, 05 February 2005, 01:49 GMT
Last edited by arjan timmerman (blaasvis) - Sunday, 06 February 2005, 14:18 GMT
Task Type Bug Report
Category Packages: Current
Status Closed
Assigned To No-one
Architecture not specified
Severity Medium
Priority Normal
Reported Version 0.7 Wombat
Due in Version Undecided
Due Date Undecided
Percent Complete 0%
Votes 0
Private No

Details

Package installed as normal, starting mysql by running /etc/rc.d/mysql said the server started ok but in fact it didn't start at all. Took me 2 hours to figure out that is was a permissions issue / writing the logs to the wrong place.
The package seems to want to write some logs to /var/lib/mysql namely <host>.err where I eventually found a log of the problem rather than where I'd have expected it to be /var/log/mysql (just a blank error log). I resolved it by chmoding mysql.mysql /var/lib/mysql. Not sure this was the best thing but it allowed myqsl to start.
This task depends upon

Closed by  Judd Vinet (judd)
Monday, 07 February 2005, 17:37 GMT
Reason for closing:  Not a bug
Comment by arjan timmerman (blaasvis) - Sunday, 06 February 2005, 14:02 GMT
well, did you copy your old mysql database dir to this system ?
Comment by Judd Vinet (judd) - Monday, 07 February 2005, 17:36 GMT
The mysql rc.d startup script should create /var/lib/mysql for you and set the correct permissions. Did you install the DB this way or create/copy it yourself?

Loading...