MYSQL Install Problem Squeeze

[ahbb]

HI There,

I recently did a dist upgrade from Lenny to Squeeze but now when im install mysql i keep on getting this errors.

Setting up mysql-server-5.1 (5.1.49-3) ...
Stopping MySQL database server: mysqld.
110128 17:10:57 [Note] Plugin 'FEDERATED' is disabled.
110128 17:10:57 InnoDB: Started; log sequence number 0 44233
110128 17:10:57 InnoDB: Starting shutdown...
110128 17:11:03 InnoDB: Shutdown completed; log sequence number 0 44233
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.1 (--configure):
subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
mysql-server depends on mysql-server-5.1; however:
Package mysql-server-5.1 is not configured yet.
dpkg: error processing mysql-server (--configure):
dependency problems - leaving unconfigured
configured to not write apport reports
configured to not write apport reports
Errors were encountered while processing:
mysql-server-5.1
mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)

Any help would be appreciated.

Thanks

Andrew

[Vekseid]

The specific reason should have shown up in your daemon log in /var/log, or in your mysql specific error logs.

If it's not obvious there (typically that sort of thing happens because the log or ibdata files are in the wrong place or the permissions are off), post the relevant log portions.

[ahbb]

Hi,

Here is the error in /var/log/syslog

Jan 29 08:46:32 shells mysqld: 110129 8:46:32 InnoDB: Starting shutdown...
Jan 29 08:46:37 shells mysqld: 110129 8:46:37 InnoDB: Shutdown completed; log sequence number 0 44233
Jan 29 08:46:37 shells mysqld: 110129 8:46:37 [Note] /usr/sbin/mysqld: Shutdown complete
Jan 29 08:46:37 shells mysqld:
Jan 29 08:46:37 shells mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Jan 29 08:46:46 shells /etc/init.d/mysql[3401]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jan 29 08:46:46 shells /etc/init.d/mysql[3401]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Jan 29 08:46:46 shells /etc/init.d/mysql[3401]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Jan 29 08:46:46 shells /etc/init.d/mysql[3401]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jan 29 08:46:46 shells /etc/init.d/mysql[3401]:

Thanks

Andrew

[anthonyclimb]

Hi,

I've exactly the same probleme. Someone has a solution ?

Thank you
Anthony

[mslinux]

Just hit the same problem this morning.
I did :

Code: Select all

# apt-get remove --purge mysql-server
# apt-get install mysql-server

Then adjust some settings. It worked but there might be an elegant solution to this.

ADD:
Just in case it happen to you, another problem came up after reinstalling mysql-server ( 5.1 )

Code: Select all

/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'

I solved the problem by re-granting privileges to the debian-sys-maint user.

Code: Select all

$ cat /etc/mysql/debian.cnf | grep password
$ mysql -u root -p
mysql> GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION

where password is the output from the first command.

[g_delmas]

Hi,
I had the same problem after upgrade to squeeze.
I have a solution:
- rename the /etc/mysql/my.cnf to /etc/mysql/my.cnf.squeeze
- rename the /etc/mysql/my.cnf.dpkg-dist to /etc/mysql/my.cnf
- start the mysql daemon: /etc/init.d/mysql start.

Maybe, my solution will be your solution.

[Mebus]

Hi!

I don't have

/etc/mysql/my.cnf.dpkg-dist

Will

apt-get remove --purge mysql-server

remove my existing MySQL data ?

Mebus

[Mebus]

I only issued

Code: Select all

apt-get install mysql-server-5.1


and now the MySQL server starts.

Mebus

[agentgates]

Hi All,

I am having the same issue but I made an additional mistake. When I've removed the mysql and all the mysql dependencies I noticed the init.d scripts and settings were still there, so I've removed them manually to make sure everything will be installed from scratch. For my greatest surpise the init.d scripts were not reinstalled.

I tried to find it by "apt-file search mysql", I found nothing as /etc/init.d/mysql. I had no clue how to continue so just to be sure I've reinstalled lsb-base as well. Still no init.d script.

Could somebody point me how to find the mentioned file or which package contains it?

Many thanks for any help or suggestion

Kind Regards
Tony

[dilberts_left_nut]

Code: Select all

mail2:~# dpkg -L mysql-server-5.1 | grep init
/etc/init.d
/etc/init.d/mysql
mail2:~#

[agentgates]

Thanks for the help. I've fixed it, now it works.

I never used dpkg for this purpuse, I thought that is what apt-file is for. We always learn.

[dbwalsh]

Re: MYSQL Install Problem Squeeze

Post by Mebus » 2011-05-15 08:19
I only issued

Code: Select all
apt-get install mysql-server-5.1



and now the MySQL server starts.

Mebus

Thanks Mebus, easy simple and fixed my problem

[rogerX]

make sure that your loopback interface is up

[thofmann]

check for loopback-interface with "ifconfig".
In my case the loopback interface was missing, and since mysql is configured as per default to bind to that, it could not start...

just edit /etc/network/interfaces:

add "lo" to the line with auto
in my case
before:
auto eth0
after:
auto lo eth0

and add the line:
iface lo inet loopback

then reboot.

If all went good, and it should then the loopback interface will be up and running as well as mysqld.

Kind regards,
Thomas

[puttyflame]

check for loopback-interface with "ifconfig".
In my case the loopback interface was missing, and since mysql is configured as per default to bind to that, it could not start...

just edit /etc/network/interfaces:

add "lo" to the line with auto
in my case
before:
auto eth0
after:
auto lo eth0

and add the line:
iface lo inet loopback

then reboot.

If all went good, and it should then the loopback interface will be up and running as well as mysqld.

Kind regards,
Thomas

Thank you, this solved my problem =)