Re: mysql-server broken
This is the quick fix: edit /etc/mysql/my.cnf remove the line about network listening and then resave the file. start up mysqld as normal - it should work! Apparently a fixed version will appear very shortly. Matthew On 16 Dec 2000 00:54:37 -0500, Jens Gecius said: Hi folks! This time I really need help on short term. After my last dist-upgrade tonight mysql-server is broken. It always gets an error in the postinst script. I tried to get it manually to work, I tried to dpkg -i the old version (my current version is -8), didn't work. I don't know what to do, I need the server and I'm about to leave for a couple days, so, if anybody has an idea, please... -- Tschoe,Get my gpg-public-key here Jens http://gecius.de/gpg-key.txt -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED] -- Using intelligent power: RISC OS, Be OS, Debian Linux Enjoying computing.
Re: mysql-server broken
Jens Gecius [EMAIL PROTECTED] writes: Hi folks! This time I really need help on short term. After my last dist-upgrade tonight mysql-server is broken. It always gets an error in the postinst script. I tried to get it manually to work, I tried to dpkg -i the old version (my current version is -8), didn't work. I found out, that mysqld is always seg-faulting. Even if I downgrade via dpkg to 3.23.28-1 (this happened after upgrade to -7, actually, not -8 of my original post) it is segfaulting. Because even older versions are seg-faulting, I tried to downgrade all mysql-related packages, but even then it is seg-faulting. I don't know by which package this was caused (everything else at that dist-upgrade went well). If you like, you can take a look at the strace-output here: http://gecius.de/mysqld-3.23.28-gamma.strace I have NO clue, what to do and which package caused this :-( Any Ideas? -- Tschoe,Get my gpg-public-key here Jens http://gecius.de/gpg-key.txt
Re: mysql-server broken
On 16/12/2000 at 10:01 -0500, Jens Gecius wrote: I found out, that mysqld is always seg-faulting. Even if I downgrade via dpkg to 3.23.28-1 (this happened after upgrade to -7, actually, snip... package this was caused (everything else at that dist-upgrade went well). This is a known bug. There are two ways to solve it: - Up/Downgrade to mysql-server 3.23.28-6 (which is working) or - Edit /etc/mysql/my.cnf and comment this line: skip-networking ...it shouldn't segfault now... Regards, sena... -- [EMAIL PROTECTED], http://decoy.ath.cx/~sena/ gpg fingerprint: F20B 12A8 A8F6 FD1F 9B1D BA62 C424 8E73 DD2E 47C8
Re: mysql-server broken
On 16/12/2000 at 17:02 +, sena wrote: This is a known bug. There are two ways to solve it: - Up/Downgrade to mysql-server 3.23.28-6 (which is working) or - Edit /etc/mysql/my.cnf and comment this line: skip-networking ...it shouldn't segfault now... Oops.. :) I checked now... 3.23.28-6 is not working after all... But if you comment the skip-networking line it shouldn't segfault... Regards, sena... -- [EMAIL PROTECTED], http://decoy.ath.cx/~sena/ gpg fingerprint: F20B 12A8 A8F6 FD1F 9B1D BA62 C424 8E73 DD2E 47C8
Re: mysql-server broken
sena [EMAIL PROTECTED] writes: This is a known bug. There are two ways to solve it: - Up/Downgrade to mysql-server 3.23.28-6 (which is working) or - Edit /etc/mysql/my.cnf and comment this line: skip-networking ...it shouldn't segfault now... Oops.. :) I checked now... 3.23.28-6 is not working after all... But if you comment the skip-networking line it shouldn't segfault... Thanks, but it is still seg-faulting. :-( Actually, the postinst doesn't go through and even calling mysqld --skip-grant does seg-fault. And I was wondering why it was working before, but no longer since upgrade to -7. Anything else to consider on my side? (like, libdb2 or so) -- Tschoe,Get my gpg-public-key here Jens http://gecius.de/gpg-key.txt
Re: mysql-server broken
Actually, the postinst doesn't go through and I ran into that on my laptop. I found that purging the package (make sure you don't have it set to kill your databases!) and a clean reinstall it would install perfectly. Not a slick solution, but a working one... -- Regards,| Need some help with Debian GNU/Linux? . | Randy | Look no further than http://debianhelp.org ([EMAIL PROTECTED]) |
Re: mysql-server broken
Randy Edwards [EMAIL PROTECTED] writes: Actually, the postinst doesn't go through and I ran into that on my laptop. I found that purging the package (make sure you don't have it set to kill your databases!) and a clean reinstall it would install perfectly. Not a slick solution, but a working one... Tried that, too. Still segfaulting and postinst doesn't work. Which package did you purge? All with mysql in it or just mysql-server? (just tried mysql-server only). -- Tschoe,Get my gpg-public-key here Jens http://gecius.de/gpg-key.txt
Re: mysql-server broken
Jens Gecius [EMAIL PROTECTED] writes: Randy Edwards [EMAIL PROTECTED] writes: Actually, the postinst doesn't go through and I ran into that on my laptop. I found that purging the package (make sure you don't have it set to kill your databases!) and a clean reinstall it would install perfectly. Not a slick solution, but a working one... Tried that, too. Still segfaulting and postinst doesn't work. Which package did you purge? All with mysql in it or just mysql-server? (just tried mysql-server only). Finally, I got it working. Reinstalled all mysql-packages (yes, all), postinst still failed. I then ran mysql_install_db after I manually created the /var/lib/mysql/mysql with perm mysql.mysql. THEN I was able to run mysql again (puhh). Oh, and before that, I had to comment skip-network in /etc/mysql/my.conf. Thanks for your help! -- Tschoe,Get my gpg-public-key here Jens http://gecius.de/gpg-key.txt
Re: mysql-server broken
Tried that, too. Still segfaulting and postinst doesn't work. Sorry, I forgot to mention my entire procedure. Here's exactly what I did: 1) I purged mysql-server. 2) This of course, left my /var/lib/mysql subdirectory intact. I then moved /var/lib/mysql to something like /var/lib/mysql.good. 3) I did a reinstall of mysql-server and it went smoothly. 4) I then shut down mysql killed the new /var/lib/mysql subdir and moved the good subdirectory back to being /var/lib/mysql. 5) After restarting the server, all ran well. -- Regards, | Seeing Bill Gates in TV ads whining about the court verdict, .| perhaps we should recall Woodrow Wilson's warning of 1912: If Randy| there are men in this country big enough to own the government | of the United States, they are going to own it.
mysql-server broken
Hi folks! This time I really need help on short term. After my last dist-upgrade tonight mysql-server is broken. It always gets an error in the postinst script. I tried to get it manually to work, I tried to dpkg -i the old version (my current version is -8), didn't work. I don't know what to do, I need the server and I'm about to leave for a couple days, so, if anybody has an idea, please... -- Tschoe,Get my gpg-public-key here Jens http://gecius.de/gpg-key.txt