Anyone have any ideas on this one? Many thanks.
RobL On Friday 10 February 2006 15:07, Rob Lacey wrote: > Running as root. > > RobL > > On Friday 10 February 2006 14:55, sheeri kritzer wrote: > > Are you running the startup script as root, or is it setuid? > > > > -Sheeri > > > > On 2/10/06, Rob Lacey <[EMAIL PROTECTED]> wrote: > > > Wondering if anyone can shed some light on a problem I am experiencing. > > > > > > I am running MySQL 4.1 on a Red Hat Enterprise Linux ES release 4 > > > (Nahant Update 2) machine. > > > > > > I have been trying to get the default /etc/init.d/mysqld script to > > > restart the server but I keep running into the same problems. The MySQL > > > server itself is running at the moment and has a number of live > > > databases on it. > > > > > > 060209 18:40:43 mysqld started > > > 060209 18:40:43 [Warning] Can't create test > > > file /var/lib/mysql/thirdeye.lower-test > > > /usr/libexec/mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: > > > 13) 060209 18:40:43 [ERROR] Aborting > > > > > > 060209 18:40:43 [Note] /usr/libexec/mysqld: Shutdown complete > > > > > > 060209 18:40:43 mysqld ended > > > > > > I can't see where the thirdeye.lower-test file creation is coming into > > > this at all. Since as far as can see the startup script doesn't seem to > > > call any script to create test databases. Is this part of mysqld_safe? > > > > > > I can also see that /var/lib/mysql is already owned by mysql.mysql with > > > 755 permissions. Indeed the RedHat startup script makes this so. > > > Therefore the permissions error seems extremely odd as they seem fine > > > to me. > > > > > > I can start the server using the following directly on the command > > > line, which is what the startup script ultimately runs anyway. > > > > > > /usr/bin/mysqld_safe --defaults-file=/etc/my.cnf > > > --pid-file= /var/run/mysqld/mysqld.pid > /dev/null 2>&1 & > > > > > > Can anyone give me something further to go on? > > > > > > Many thanks. > > > > > > Rob > > > > > > -- > > > MySQL General Mailing List > > > For list archives: http://lists.mysql.com/mysql > > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]