Can't start MySQL5.5 on Ubuntu 12.04 - "dpkg: dependency problems"
This appears to be a common problem on 12.04. I've tried everthing in this thread including:
sudo apt-get clean sudo apt-get autoclean sudo apt-get remove --purge mysql-client-5.5 mysql-client-core-5.5 mysql-common mysql-server mysql-server-5.5 mysql-server-core-5.5 sudo apt-get install mysql-server
I still get the same old error. Installing/starting MySql5.5 looks like this:
apt-get install -f mysql-server Reading package lists... Done Building dependency tree Reading state information... Done mysql-server is already the newest version. 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 2 not fully installed or removed. After this operation, 0 B of additional disk space will be used. Do you want to continue [Y/n]? Y Setting up mysql-server-5.5 (5.5.24-0ubuntu0.12.04.1) ... 120907 21:37:15 [Note] Plugin 'FEDERATED' is disabled. 120907 21:37:15 InnoDB: The InnoDB memory heap is disabled 120907 21:37:15 InnoDB: Mutexes and rw_locks use GCC atomic builtins 120907 21:37:15 InnoDB: Compressed tables use zlib 188.8.131.52 120907 21:37:15 InnoDB: Initializing buffer pool, size = 128.0M 120907 21:37:15 InnoDB: Completed initialization of buffer pool 120907 21:37:15 InnoDB: highest supported file format is Barracuda. 120907 21:37:15 InnoDB: Waiting for the background threads to start 120907 21:37:16 InnoDB: 1.1.8 started; log sequence number 154164236 120907 21:37:16 InnoDB: Starting shutdown... 120907 21:37:16 InnoDB: Shutdown completed; log sequence number 154164236 start: Job failed to start invoke-rc.d: initscript mysql, action "start" failed. dpkg: error processing mysql-server-5.5 (--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.5; however: Package mysql-server-5.5 is not configured yet. dpkg: error processing mysql-server (--configure): dependency problems - leaving unconfigured No apport report written because the error message indicates its a followup error from a previous failure. Errors were encountered while processing: mysql-server-5.5 mysql-server
In addition, dpkg-reconfigure mysql-server-5.5 returns /usr/sbin/dpkg-reconfigure: mysql-server-5.5 is broken or not fully installed
The ultimate goal here is installing and configuring Gitorious to work with Redmine but I believe the problem is isolated to Ubuntu 12.04 and MySql5.5
I found solution with this step:
WARNING: the following step will DELETE your existing data! please backup first!!!
$ sudo apt-get --yes autoremove --purge mysql-server-5.5 $ sudo apt-get --yes autoremove --purge mysql-client-5.5 $ sudo apt-get --yes autoremove --purge mysql-common $ sudo rm -rf /var/lib/mysql /etc/mysql ~/.mysql $ sudo deluser mysql $ sudo apt-get autoclean $ sudo apt-get update && sudo apt-get upgrade $ sudo apt-get install mysql-server-5.5 mysql-client-5.5
NOTE: when you get 'dpkg: error...' please run step below:
$ sudo dpkg --configure -a
The fix from the Ubuntu forums:
This is what worked for me, though I was doing an install and not an upgrade, so I didn't care about the existing database.
I removed all the mysql application again, then I went and deleted my /var/lib/mysql directory. Keep in mind, if you have an existing database there, you will lose it. You might want to move it to another location.
After removing that directory, I installed again and it worked perfect. So something in the /var/lib/mysql directory was my problem. See if that works for you.
Had same problem, tried to install with aptitude and discover that error
Setting up mysql-server-5.5 (5.5.41-0ubuntu0.14.04.1) ... /var/lib/dpkg/info/mysql-server-5.5.postinst: line 146: logger: command not found ATTENTION: An error has occured. More info is in the syslog! /var/lib/dpkg/info/mysql-server-5.5.postinst: line 236: logger: command not found dpkg: error processing package mysql-server-5.5 (--configure): subprocess installed post-installation script returned error exit status 127
after installing bsdutils,
apt-get install bsdutils
mysql installation passed normally
Make sure that
auto lo iface lo inet loopback
still exists in your /etc/network/interfaces
Just want to add my 5 cents. It may help someone else.
After hunting for and trying various solutions, without the drastic uninstall and purge, my solution was ridiculously simple.
My disk was full! I can't believe I didn't check that first. Cleared it out and hey presto!
I tried everything above, but it still wouldn't install. I finally got it working with this post: http://www.randomhacks.co.uk/mysql-job-failed-to-start-unable-to-set-root-password-cant-find-file-mysql/
It advises to remove folders similar to what was stated above, and also to run
dpkg --get-selections | grep mysql sudo apt-get remove --purge [everything that came up] sudo apt-get autoremove && sudo apt-get autoclean sudo apt-get install mysql-server
I couldnt solve this problem with purging / manual deletion / anything that mysql / ubuntu forums advised me to do
instead, the solution for me was :
1) increase the memory of the VM that Ubuntu was running on
2) after checking /var/log/mysql/error.log, I found out that a specific file couldnt be created at /tmp :
Can't create/write to file '/tmp/ibeDIRhT' (Errcode: 13) InnoDB: Error: unable to create temporary file; errno: 13
I just chmod(ed) /tmp to allow this.
Lo and behold, next attempt of installing mysql was successful.
just in case anyone ever has this problem, purging isn't always the solution, you should check the log to see what error message you have. That might help
dpkg -i mysql-apt-config_0.2.1-1ubuntu14.04_all.deb apt-get update apt-get install mysql-server
I wasted many hours trying to fix this and in the end it turned out that it just needed full permissions on /tmp directory (i tried 755 and 766 but didn't work, only 777 works), so i ran:
sudo chmod 1777 /tmp
"the number 1 before 777 is called the sticky bit and it adds extra security to the folder, check this for more details about the sticky bit".
sudo dpkg --configure mysql-server-5.5
and mysql server started successfully.
I had this problem many times. I can add an other piece of solution for this jigsaw...
WARNING: the following steps will delete your data! Do a backup first!
You have to:
rm -rf /var/lib/mysql rm -rf /etc/mysql
Verify that, the interface "lo" is up and, the traffic is allowed on "lo" (iptables).
Hope that help someone else !
This error also happened when switching from MySQL to MariaDB (https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1490071).
The MySQL binary data files were not compatible with MariaDB so I switched back to MySQL because I did not have time to mess with mysqldump.
First I had to move MariaDB data away from /var/lib/mysql, then install MySQL and then move my original data from /var/lib/mysql-5.7 (this backup was automatically created before the error) to /var/lib/mysql.