Re: [Cooker-PPC] Problem with MySQL, FTP wizard, Netatalk Webminmodule
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
Re: [Cooker-PPC] Problem with MySQL, FTP wizard, Netatalk Webminmodule
On Thu, 14 Nov 2002, Phil Lavigna wrote: > > Hi, > > After updating a PowerBook with today's Cooker PPC files from ftp.ciril.fr, > I noticed three problems: > > 1) MySQL doesn't start -- MySQL-3.23.53-2mdk > > The message from /var/lib/mysql/localhost.localdomain.err: > 021114 10:09:06 mysqld started > 021114 10:09:06 /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: > 13) > 021114 10:09:06 /usr/sbin/mysqld: Normal shutdown > 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. > 2) The FTP server wizard won't start -- drakxtools-1.1.11-3mdk, > drakwizard-1.0-3mdk > > The console message is: > Can't locate /usr/share/wizards/ftp_wizard/scripts/ProFtpconf.pm in @INC (@INC > contains: /usr/lib/libDrakX /usr/lib/perl5/5.8.0/ppc-linux-thread-multi > /usr/lib/perl5/5.8.0 /usr/lib/perl5/site_perl/5.8.0/ppc-linux-thread-multi > /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl/5.6.1 > /usr/lib/perl5/site_perl > /usr/lib/perl5/vendor_perl/5.8.0/ppc-linux-thread-multi > /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl .) at > /usr/sbin/drakwizard line 131. > Looked at this in more detail. It's a no-arch package, so my build isn't even what's getting disributed. the file is in the tarball but never gets installed. I'll mail the maintainer and see if he's aware of the issue. > -- > > 3) The Netatalk Webmin module expects the configuration files in /etc/atalk, > but it should be /etc/netatalk > Patched this, also got rid of the non-functional "interfaces" icon. 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
Re: [Cooker-PPC] Problem with MySQL, FTP wizard, Netatalk Webminmodule
On Thu, 14 Nov 2002, Phil Lavigna wrote: > > Hi, > > After updating a PowerBook with today's Cooker PPC files from ftp.ciril.fr, > I noticed three problems: > > 1) MySQL doesn't start -- MySQL-3.23.53-2mdk > > The message from /var/lib/mysql/localhost.localdomain.err: > 021114 10:09:06 mysqld started > 021114 10:09:06 /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: > 13) > 021114 10:09:06 /usr/sbin/mysqld: Normal shutdown > > mysqld got signal 11; > This could be because you hit a bug. It is also possible that this binary > or one of the libraries it was linked agaist is corrupt, improperly built, > or misconfigured. This error can also be caused by malfunctioning hardware. > We will try our best to scrape up some info that will hopefully help diagnose > the problem, but since we have already crashed, something is definitely wrong > and this may fail > > key_buffer_size=8388600 > record_buffer=131072 > sort_buffer=2097144 > max_used_connections=0 > max_connections=100 > threads_connected=0 > It is possible that mysqld could use up to > key_buffer_size + (record_buffer + sort_buffer)*max_connections = 225791 K > bytes of memory > Hope that's ok, if not, decrease some variables in the equation > > 021114 10:09:06 mysqld ended > > -- > > 2) The FTP server wizard won't start -- drakxtools-1.1.11-3mdk, > drakwizard-1.0-3mdk > > The console message is: > Can't locate /usr/share/wizards/ftp_wizard/scripts/ProFtpconf.pm in @INC (@INC > contains: /usr/lib/libDrakX /usr/lib/perl5/5.8.0/ppc-linux-thread-multi > /usr/lib/perl5/5.8.0 /usr/lib/perl5/site_perl/5.8.0/ppc-linux-thread-multi > /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl/5.6.1 > /usr/lib/perl5/site_perl > /usr/lib/perl5/vendor_perl/5.8.0/ppc-linux-thread-multi > /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl .) at > /usr/sbin/drakwizard line 131. > > -- > > 3) The Netatalk Webmin module expects the configuration files in /etc/atalk, > but it should be /etc/netatalk > > -- > > Stew -- Should I be reporting this stuff to the Cooker list? > Posting here is OK. I think the FTP wizard thing has been broke a while. I'll check out x86 again. Some packages there's little I can do to fix them, as I'm not allowed to modify them. I can patch webmin (maybe), and I'll check out MySQL. I saw someone on cooker a couple of days ago reporting it broken, but I forget the details now. 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