Scheduled Maintenance: We are aware of an issue with Google, AOL, and Yahoo services as email providers which are blocking new registrations. We are trying to fix the issue and we have several internal and external support tickets in process to resolve the issue. Please see: viewtopic.php?t=158230

 

 

 

MYSQL Install Problem Squeeze

Ask for help with issues regarding the Installations of the Debian O/S.
Post Reply
Message
Author
ahbb
Posts: 15
Joined: 2009-04-13 14:48
Location: South Africa

MYSQL Install Problem Squeeze

#1 Post by 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
Posts: 8
Joined: 2010-05-20 03:27
Contact:

Re: MYSQL Install Problem Squeeze

#2 Post by 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.
Blog-like-thing: Tuning servers for forums

ahbb
Posts: 15
Joined: 2009-04-13 14:48
Location: South Africa

Re: MYSQL Install Problem Squeeze

#3 Post by 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
Posts: 1
Joined: 2011-02-14 16:02

Re: MYSQL Install Problem Squeeze

#4 Post by anthonyclimb »

Hi,

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

Thank you
Anthony

User avatar
mslinux
Posts: 942
Joined: 2010-12-24 05:14

Re: MYSQL Install Problem Squeeze

#5 Post by 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.
MsLinux-

forums.debian.net - where facepalm is the default answer :D

© 2012
║▌║│█║▌│█│║▌║█║▌│█│║▌║│

g_delmas
Posts: 1
Joined: 2011-02-21 14:29

Re: MYSQL Install Problem Squeeze

#6 Post by 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
Posts: 2
Joined: 2009-05-08 14:30

Re: MYSQL Install Problem Squeeze

#7 Post by 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
Posts: 2
Joined: 2009-05-08 14:30

Re: MYSQL Install Problem Squeeze

#8 Post by Mebus »

I only issued

Code: Select all

apt-get install mysql-server-5.1
and now the MySQL server starts.

Mebus

agentgates
Posts: 2
Joined: 2011-11-03 19:47

Re: MYSQL Install Problem Squeeze

#9 Post by 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

User avatar
dilberts_left_nut
Administrator
Administrator
Posts: 5346
Joined: 2009-10-05 07:54
Location: enzed
Has thanked: 12 times
Been thanked: 66 times

Re: MYSQL Install Problem Squeeze

#10 Post by dilberts_left_nut »

Code: Select all

mail2:~# dpkg -L mysql-server-5.1 | grep init
/etc/init.d
/etc/init.d/mysql
mail2:~#
AdrianTM wrote:There's no hacker in my grandma...

agentgates
Posts: 2
Joined: 2011-11-03 19:47

Re: MYSQL Install Problem Squeeze

#11 Post by 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
Posts: 1
Joined: 2012-01-05 07:59

Re: MYSQL Install Problem Squeeze

#12 Post by 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
Posts: 1
Joined: 2012-05-18 01:39

Re: MYSQL Install Problem Squeeze

#13 Post by rogerX »

make sure that your loopback interface is up

thofmann
Posts: 1
Joined: 2012-07-27 12:47

Re: MYSQL Install Problem Squeeze

#14 Post by 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
Posts: 1
Joined: 2012-09-29 20:44

Re: MYSQL Install Problem Squeeze

#15 Post by puttyflame »

thofmann wrote: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 =)

mrunkel
Posts: 1
Joined: 2012-11-07 13:47

Re: MYSQL Install Problem Squeeze

#16 Post by mrunkel »

I had this issue. In my case it was because skip-bdb was in my my.cnf and I kept my custom my.cnf instead of installing the distributed version.

Removing it allows the server to start.

Berkeley DB is no longer in 5.1x, so the option doesn't apply any more, but why the mysql developers halt startup upon seeing this now deprecated option instead of just logging and ignoring is beyond me.

User avatar
DerekM
Posts: 37
Joined: 2012-10-20 04:03

Re: MYSQL Install Problem Squeeze

#17 Post by DerekM »

There was a glick found from install mythtv backend and frontend causing the same errors.. The solution was to do this

edit /etc/mysql/my.cnf

and look for the line

bind address = 127.0.0.1

and comment that line out

#bind address =127.0.0.1
Reboot
I hope this applies to you as well...

Post Reply