Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 31st May 2013, 06:05
morganew morganew is offline
Junior Member
 
Join Date: Jun 2007
Posts: 9
Thanks: 1
Thanked 0 Times in 0 Posts
Default Updated my Debian, MySQL failed to restart

after many months of smooth operation, I went to update Debian to the final stable version of 6.

I ran aptitude, selected update, looked to see if there were any obvious package problems, none turned up.

during upgrade, mysql failed to restart. I have attempted to get mysql re-instealled but dpkg is failing with a dependency error

Here's the output of my recent apt-get attempt:

Code:
/install_ispconfig# apt-get install mysql-server mysql-client libmysqlclient-dev
Reading package lists... Done
Building dependency tree       
Reading state information... Done
mysql-client is already the newest version.
mysql-server is already the newest version.
The following package was automatically installed and is no longer required:
  libmysqlclient15off
Use 'apt-get autoremove' to remove them.
The following packages will be REMOVED:
  libmysqlclient15-dev
The following NEW packages will be installed:
  libmysqlclient-dev
0 upgraded, 1 newly installed, 1 to remove and 0 not upgraded.
2 not fully installed or removed.
Need to get 3,113 kB of archives.
After this operation, 12.4 MB disk space will be freed.
Do you want to continue [Y/n]? Y
Get:1 http://mirrors.kernel.org/debian/ stable/main libmysqlclient-dev i386 5.1.49-3 [3,113 kB]
Fetched 3,113 kB in 2s (1,207 kB/s)             
(Reading database ... 49083 files and directories currently installed.)
Removing libmysqlclient15-dev ...
Processing triggers for man-db ...
Selecting previously deselected package libmysqlclient-dev.
(Reading database ... 48994 files and directories currently installed.)
Unpacking libmysqlclient-dev (from .../libmysqlclient-dev_5.1.49-3_i386.deb) ...
Processing triggers for man-db ...
Setting up mysql-server-5.1 (5.1.49-3) ...
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.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
Setting up libmysqlclient-dev (5.1.49-3) ...
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)
As you can see it appears to be stopping mysql, then restarting before configuring, therefore it fails.

is apt-get purge the recommended fix?
Reply With Quote
Sponsored Links
  #2  
Old 31st May 2013, 19:28
morganew morganew is offline
Junior Member
 
Join Date: Jun 2007
Posts: 9
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Problem solved.

It turns out that the updated version of mySQL added the flag "skip-bdb" to the mysql config file in /etc/mysql/my.cnf

check your syslog and look for the following error

[ERROR] /usr/sbin/mysqld: unknown option '--skip-bdb'

If you see this error, try the following fix. In your /etc/mysql/my.cnf, comment out the following line:

# Using BerkeleyDB is now discouraged as its support will cease in 5.1.12.
skip-bdb

to read:

# Using BerkeleyDB is now discouraged as its support will cease in 5.1.12.
#skip-bdb

after making this change, I was able to do another apt-get install mysql-server and it all went smoothly.

There may be some reason to NOT comment that switch out, but I was trying to solve the immediate problem. If my "fix" creates some downstream problem I haven't considered, please let me know here.
Reply With Quote
  #3  
Old 7th June 2013, 16:23
tkausl tkausl is offline
Junior Member
 
Join Date: May 2013
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

It looks like it want to disable an feature which isnt implemented lol
BDB is only an engine like INNODB and MyISAM. If u dont need this, this isnt a problem.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
help cant access anything locally or from ip jimmie Installation/Configuration 14 5th March 2013 07:58
ISPConfig 3 - MultiServer Setup - With Dedicated Control Panel - How? SuperJC Installation/Configuration 4 16th October 2012 20:03
Turn off unnecessary services drivespace General 2 18th July 2011 22:32
CPU load locks up box. Apache or MYSQL related. crypted General 61 29th October 2010 22:16
Failed during pvmove, howto: set up software raid 1 on running LVM system sbh77 HOWTO-Related Questions 2 8th October 2010 00:11


All times are GMT +2. The time now is 20:51.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.