Hi,
I've just tried to upgrade MySQL to version 3.23.53 (binary version from www.mysql.com) and found some strange things. I previously used 3.23.47 and when I first tried to start the new version I got this error message: Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists! The mysql user was fine and it worked with the 3.23.47, so I searched in the newsgroups and mailing lists archives for the same error message to see if someone had a similar problem, but couldn't found anything. I straced mysqld and found this: .... (many lines removed) read(4, "#\n# /etc/nsswitch.conf\n#\n# An ex"..., 4096) = 1108 read(4, "", 4096) = 0 close(4) = 0 munmap(0x20366000, 4096) = 0 open("/home/serg/binaries/Glibc/etc/ld.so.cache", O_RDONLY) = -1 ENOENT (No such file or directory) open("/home/serg/binaries/Glibc/lib/libnss_compat.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) stat64(0x5fffec94, 0x5fffed0c) = -1 ENOENT (No such file or directory) write(2, "Fatal error: Can\'t change to run"..., 87Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists!) = 87 time(NULL) = 1034683888 write(2, "021015 14:11:28 ", 17021015 14:11:28 ) = 17 write(2, "Aborting\n", 9Aborting) = 9 write(2, "\n", 1) = 1 unlink("/var/mysql/_____.pid") = -1 ENOENT (No such file or directory) time(NULL) = 1034683888 write(2, "021015 14:11:28 ", 17021015 14:11:28 ) = 17 write(2, "./mysqld: Shutdown Complete\n", 28./mysqld: Shutdown Complete) = 28 write(2, "\n", 1) = 1 _exit(1) I made the /home/serg/binaries/Glibc path on my machine and linked etc and lib in that path to /etc and /lib and as a result, mysqld started normally. As far as I know, the statically compiled glibc (that you guys at MySQL are using when making binary distributions) should be compiled with --enable-static-nss option. It seems to me that the strace output above shows that the mysqld binary is trying to dynamically load nss_compat? Regards, -- Predrag Malicevic BLIC.NET ISP +387-51-218-101 http://www.blic.net/ --------------------------------------------------------------------- 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