MYSQL Install Problem Squeeze

Help with issues regarding installation of Debian

MYSQL Install Problem Squeeze

Postby ahbb » 2011-01-28 15:14

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
ahbb
 
Posts: 15
Joined: 2009-04-13 14:48
Location: South Africa

Re: MYSQL Install Problem Squeeze

Postby Vekseid » 2011-01-29 05:22

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
Vekseid
 
Posts: 8
Joined: 2010-05-20 03:27

Re: MYSQL Install Problem Squeeze

Postby ahbb » 2011-01-29 06:48

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
ahbb
 
Posts: 15
Joined: 2009-04-13 14:48
Location: South Africa

Re: MYSQL Install Problem Squeeze

Postby anthonyclimb » 2011-02-14 16:07

Hi,

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

Thank you
Anthony
anthonyclimb
 
Posts: 1
Joined: 2011-02-14 16:02

Re: MYSQL Install Problem Squeeze

Postby mslinux » 2011-02-16 05:58

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
║▌║│█║▌│█│║▌║█║▌│█│║▌║│
User avatar
mslinux
 
Posts: 942
Joined: 2010-12-24 05:14

Re: MYSQL Install Problem Squeeze

Postby g_delmas » 2011-02-21 14:34

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.
g_delmas
 
Posts: 1
Joined: 2011-02-21 14:29

Re: MYSQL Install Problem Squeeze

Postby Mebus » 2011-05-14 22:08

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

Postby Mebus » 2011-05-14 22:19

I only issued

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


and now the MySQL server starts.

Mebus
Mebus
 
Posts: 2
Joined: 2009-05-08 14:30

Re: MYSQL Install Problem Squeeze

Postby agentgates » 2011-11-03 20:16

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
agentgates
 
Posts: 2
Joined: 2011-11-03 19:47

Re: MYSQL Install Problem Squeeze

Postby dilberts_left_nut » 2011-11-03 22:39

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...
User avatar
dilberts_left_nut
 
Posts: 3208
Joined: 2009-10-05 07:54
Location: enzed

Re: MYSQL Install Problem Squeeze

Postby agentgates » 2011-11-04 03:08

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. :)
agentgates
 
Posts: 2
Joined: 2011-11-03 19:47

Re: MYSQL Install Problem Squeeze

Postby dbwalsh » 2012-01-05 08:02

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
dbwalsh
 
Posts: 1
Joined: 2012-01-05 07:59

Re: MYSQL Install Problem Squeeze

Postby rogerX » 2012-05-18 01:41

make sure that your loopback interface is up
rogerX
 
Posts: 1
Joined: 2012-05-18 01:39

Re: MYSQL Install Problem Squeeze

Postby thofmann » 2012-07-27 13:06

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
thofmann
 
Posts: 1
Joined: 2012-07-27 12:47

Re: MYSQL Install Problem Squeeze

Postby puttyflame » 2012-09-29 20:55

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 =)
puttyflame
 
Posts: 1
Joined: 2012-09-29 20:44

Next

Return to Installation

Who is online

Users browsing this forum: No registered users and 11 guests

fashionable