Mysql-server-5.0 installation failed during configuration

makuyl · 08-26-2008, 09:17 AM

Does the mysql user have write permissions to the database dir datadir = ??? in /etc/mysql/my.cnf? and the /var/run/mysqld socket dir?
Do you get any errors in /var/log/syslog, /var/log/auth.log or /var/log/mysql.log?
mysql binds by default to localhost, check with ifconfig if you have the loopback lo up.
What exactly did you say you installed in the first post? sql for mediawiki? What changes did that make to your system?

Lokathor · 08-26-2008, 05:12 PM

No, I hadn't considered just giving up on sound, nor will I. Additionally, I'm not going to just buy a new sound card if I can fix MySql, since the past 2 stable versions of Debian haven't worked properly with either of my sound cards anyways (I've got an onboard and a PCI). As to the mixed system issue, I already checked and upgraded the version on every single package that mysql-server-5.0 requires, like you said, and it's still not working. I've also used a mixed Debian system for years with nary a problem until this. If you recall what I said before, The problem started before I ever tried to install to the very newest version of MySql 5.0.

As to your question makuyl:

Code:

mgarsenal:/home/daniel# ls -al /var/lib/mysql
total 36944
drwxr-xr-x  4 mysql mysql     4096 2008-08-25 19:16 .
mgarsenal:/home/daniel# ls -al /var/run/mysqld/
total 8
drwxr-xr-x  2 mysql root 4096 2008-08-25 19:16 .

/var/log/mysql.log is empty both before and after an attempt to start mysql. /var/log/mysql.log didn't gain anything about sql. The third file, /var/log/syslog, had this to say on the subject:

Code:

Aug 26 13:39:01 mgarsenal /USR/SBIN/CRON[16683]: (root) CMD (  [ -x /usr/lib/php5/maxlifetime ] && [ -d /var/lib/php5 ] && find /var/lib/php5/ -type f -cmin +$(/usr/lib/php5/maxlifetime) -print0 | xargs -n 200 -r -0 rm)
Aug 26 13:42:29 mgarsenal mysqld_safe[16887]: started
Aug 26 13:42:30 mgarsenal mysqld[16891]: 080826 13:42:30  InnoDB: Started; log sequence number 0 62768240
Aug 26 13:42:30 mgarsenal mysqld[16891]: 080826 13:42:30 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mysql/host.frm'
Aug 26 13:42:30 mgarsenal mysqld[16891]: 080826 13:42:30 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mysql/host.frm'
Aug 26 13:42:30 mgarsenal mysqld[16891]: 080826 13:42:30 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect information in file: './mysql/host.frm'
Aug 26 13:42:30 mgarsenal mysqld_safe[16914]: ended
Aug 26 13:42:43 mgarsenal /etc/init.d/mysql[17056]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Aug 26 13:42:43 mgarsenal /etc/init.d/mysql[17056]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Aug 26 13:42:43 mgarsenal /etc/init.d/mysql[17056]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Aug 26 13:42:43 mgarsenal /etc/init.d/mysql[17056]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Aug 26 13:42:43 mgarsenal /etc/init.d/mysql[17056]:

There is a /var/lib/mysql/mysql/host.frm file, but that's a binary file when I try to view it, so I'm not sure how it expects me to fix it.

ifconfig reports:

Code:

lo        Link encap:Local Loopback  
          inet addr:127.0.0.1  Mask:255.0.0.0
          inet6 addr: ::1/128 Scope:Host
          UP LOOPBACK RUNNING  MTU:16436  Metric:1
          RX packets:420 errors:0 dropped:0 overruns:0 frame:0
          TX packets:420 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0 
          RX bytes:24456 (23.8 KiB)  TX bytes:24456 (23.8 KiB)

Which looks right.

And yes, the sql install is for mediawiki to run. I had mysql-server-5.0 version 5.0.1etch12 (I think that version), something with etch in the minor version number. The version now installed but unconfigured is 5.0.51a-12. However, as I've said, even before trying to move to the newest testing version MySql had crapped out on me (which is what made me think I should upgrade in the first place).

makuyl · 08-27-2008, 01:45 PM

You could back up your data and see if rebuilding the database with "mysql_install_db" helps, while that would look like a database corruption, or try with just "mysql_fix_permissions".

new_way · 09-09-2008, 09:00 AM

solution: Though not a very clean solution but it worked for me.

1. Disable innodb by default. edit /etc/mysql/my.cnf file
and uncomment the line
#skip-innodb

or

2. let the following three files be present in the /var/lib/mysql folder

ibdata1
ib_logfile0
ib_logfile0

before running apt-get install mysql-server-5.0

new_way

Jongi · 09-21-2008, 09:31 AM

I am having problems installing mysql-server as well.

Code:

[root:~#] cat /etc/apt/sources.list | grep -v \#
deb ftp://ftp.is.co.za/linux/distributions/debian/security.debian.org/ testing/updates main contrib non-free
deb ftp://ftp.is.co.za/linux/distributions/debian/ftp.us.debian.org/ testing contrib main non-free
deb http://ftp.leg.uct.ac.za/pub/linux/debian-multimedia/ testing main
deb http://getswiftfox.com/builds/debian unstable non-free
deb http://maledivenhilfe.com/debian ./
deb http://download.tuxfamily.org/osrdebian unstable compiz-fusion-git
deb http://download.virtualbox.org/virtualbox/debian lenny non-free
[root:~#] dpkg -l | grep mysql
[root:~#]

And when I run aptitude install mysql-server

Code:

dpkg: dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-5.0; however:
  Package mysql-server-5.0 is not configured yet.
dpkg: error processing mysql-server (--configure):
 dependency problems - leaving unconfigured
Processing triggers for menu ...
Errors were encountered while processing:
 mysql-server-5.0
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
A package failed to install.  Trying to recover:
Setting up mysql-server-5.0 (5.0.51a-15) ...
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.0 (--configure):
 subprocess post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-5.0; however:
  Package mysql-server-5.0 is not configured yet.
dpkg: error processing mysql-server (--configure):
 dependency problems - leaving unconfigured
Errors were encountered while processing:
 mysql-server-5.0
 mysql-server
Reading package lists... Done

Jongi · 09-22-2008, 01:55 PM

Look to see whether the loopback interface is defined in /etc/network/interfaces

Code:

[root:~#] cat /etc/network/interfaces
# Used by ifup(8) and ifdown(8). See the interfaces(5) manpage or
# /usr/share/doc/ifupdown/examples for more information.

#The loopback network interface
auto lo
iface lo inet loopback

or alternatively try commenting the line bind-address = 127.0.0.1 in /etc/mysql/my.cnf