On Sat, 16 Nov 2002, Phil Lavigna wrote: > > Hi Stew, > > > This one's odd. One the rs6000 it runs fine. On the powerbook the > > permissions were apparently wrong on the mysql data files. Doing: > > > > chown mysql /var/lib/mysql/mysql/* > > > > Allows it to run now. > > > > The were owned by root, rather than mysql. > > > > Perhaps some sequence of updates that didn't happen quite as expected? > > > > uid for mysql on the bad system is: > > > > [root@powerbook root]# grep mysql /etc/passwd > > mysql:x:75:75:system user for MySQL:/var/lib/lib/mysql:/bin/bash > > > > On the good system: > > > > [root@rs6000 root]# grep mysql /etc/passwd > > mysql:x:415:415:MySQL server:/var/lib/mysql:/bin/bash > > > > Comment is also different. > > Yep, that fixed it on my PowerBook. Here's what it says now: > > [root@localhost phil8]# grep mysql /etc/passwd > mysql:x:70:70:system user for MySQL:/var/lib/lib/mysql:/bin/bash > > Thanks a lot. KDE RC3 is downloading now! > >
Looking at it again, I see /var/lib/mysql/mysql/ on the working system is older than the package install or build, so the old files/permissions were preserved on an update, but apparently broken on a clean install. Just tried a clean install on x86 also, and it too is broken :(. Downloaded: 10,160,249 bytes in 4 files installing /var/cache/urpmi/rpms/MySQL-3.23.53-2mdk.i586.rpm /var/cache/urpmi/rpms/perl-CGI-2.810-3mdk.noarch.rpm /var/cache/urpmi/rpms/MySQL-client-3.23.53-2mdk.i586.rpm /var/cache/urpmi/rpms/libmysql10-3.23.53-2mdk.i586.rpm Preparing... ################################################## 1:perl-CGI ################################################## 2:libmysql10 ################################################## 3:MySQL-client ################################################## 4:MySQL warning: user mysql does not exist - using root warning: group mysql does not exist - using root warning: user mysql does not exist - using root warning: group mysql does not exist - using root warning: user mysql does not exist - using root warning: group mysql does not exist - using root ################################################## 021117 6:07:29 /usr/sbin/mysqld: Shutdown Complete [root@larry root]# /etc/rc.d/init.d/mysql start Starting MySQL Server [ OK ] No mysqld running. [root@larry root]# cat /var/lib/mysql/larry.linuxcontrol.org.err 021117 06:11:23 mysqld started Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists! 021117 6:11:23 Aborting 021117 6:11:23 /usr/sbin/mysqld: Shutdown Complete 021117 06:11:23 mysqld ended And as the errors say there's no mysql user, so I guess ppc isn't unique in mysql issues. Stew Benedict -- MandrakeSoft PPC FAQ: http://www.linux-mandrake.com/en/ppcFAQ.php3 IRC: irc.openproject.net #cooker-ppc Archives: http://marc.theaimsgroup.com/?l=mandrake-cooker-ppc&r=1&w=2
