MySQL patches by Codership

Installation on ubuntu 10.04

Asked by Christopher Gorge A. Marges

Tried to set up two masters (no slave) with mysql/galera. The readme said to unpack the distribution but did not specify any file so we downloaded all the files then tried one which looks like the distribution (see output below).

root@test-master1:~# dpkg -i galera-0.7.6-amd64.deb
(Reading database ... 13803 files and directories currently installed.)
Preparing to replace galera 0.7.6 (using galera-0.7.6-amd64.deb) ...
Unpacking replacement galera ...
Setting up galera (0.7.6) ...

root@test-master1:~# dpkg -i mysql-wsrep-5.1.53-0.7.6-amd64.deb
(Reading database ... 13803 files and directories currently installed.)
Preparing to replace mysql-wsrep 5.1.53-0.7.6 (using mysql-wsrep-5.1.53-0.7.6-am d64.deb) ...
Unpacking replacement mysql-wsrep ...
dpkg: dependency problems prevent configuration of mysql-wsrep:
 mysql-wsrep depends on psmisc; however:
  Package psmisc is not installed.
 mysql-wsrep depends on libdbi-perl; however:
  Package libdbi-perl is not installed.
 mysql-wsrep depends on libdbd-mysql-perl (>= 1.2202); however:
  Package libdbd-mysql-perl is not installed.
 mysql-wsrep depends on mysql-client-5.1 (>= 5.1.47); however:
  Package mysql-client-5.1 is not installed.
dpkg: error processing mysql-wsrep (--install):
 dependency problems - leaving unconfigured
Processing triggers for ureadahead ...
Errors were encountered while processing:
 mysql-wsrep
root@test-master1:~# apt-get install psmisc
Reading package lists... Done
Building dependency tree
Reading state information... Done
You might want to run `apt-get -f install' to correct these:
The following packages have unmet dependencies:
  mysql-wsrep: Depends: libdbi-perl but it is not going to be installed
               Depends: libdbd-mysql-perl (>= 1.2202) but it is not going to be installed
               Depends: mysql-client-5.1 (>= 5.1.47) but it is not going to be installed
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).
root@test-master1:~# apt-get install libdbi-perl
Reading package lists... Done
Building dependency tree
Reading state information... Done
You might want to run `apt-get -f install' to correct these:
The following packages have unmet dependencies:
  libdbi-perl: Depends: libplrpc-perl but it is not going to be installed
  mysql-wsrep: Depends: psmisc but it is not going to be installed
               Depends: libdbd-mysql-perl (>= 1.2202) but it is not going to be installed
               Depends: mysql-client-5.1 (>= 5.1.47) but it is not going to be installed
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).
root@test-master1:~# apt-get install libplrpc-perl
Reading package lists... Done
Building dependency tree
Reading state information... Done
You might want to run `apt-get -f install' to correct these:
The following packages have unmet dependencies:
  libplrpc-perl: Depends: libnet-daemon-perl but it is not going to be installed
  mysql-wsrep: Depends: psmisc but it is not going to be installed
               Depends: libdbi-perl but it is not going to be installed
               Depends: libdbd-mysql-perl (>= 1.2202) but it is not going to be installed
               Depends: mysql-client-5.1 (>= 5.1.47) but it is not going to be installed
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).
root@test-master1:~# apt-get install libnet-daemon-perl
Reading package lists... Done
Building dependency tree
Reading state information... Done
You might want to run `apt-get -f install' to correct these:
The following packages have unmet dependencies:
  mysql-wsrep: Depends: psmisc but it is not going to be installed
               Depends: libdbi-perl but it is not going to be installed
               Depends: libdbd-mysql-perl (>= 1.2202) but it is not going to be installed
               Depends: mysql-client-5.1 (>= 5.1.47) but it is not going to be installed
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).

We were unable to install anything. Please advice on what we missed. Thanks.

Question information

Language:
English Edit question
Status:
Solved
For:
MySQL patches by Codership Edit question
Assignee:
No assignee Edit question
Solved by:
Teemu Ollakka
Solved:
Last query:
Last reply:
Revision history for this message
Teemu Ollakka (teemu-ollakka) said : 		#1

It seems that you are missing backports source from apt sources.list file.

From README-wsrep:

"From 0.7.5 upwards, mysql-wsrep will require psmisc and mysql-client-5.1.47
(or later). MySQL 5.1 packages can be found from backports repositories.
For further information about configuring and using Debian or Ubuntu
backports, see:

* http://backports.debian.org

* https://help.ubuntu.com/community/UbuntuBackports

For example, installation of required packages on Debian Lenny:

$ sudo apt-get install psmisc
$ sudo apt-get -t lenny-backports install mysql-client-5.1

Now you should be able to install mysql-wsrep package:

$ sudo dpkg -i <mysql-wsrep DEB>"

If you are using Debian Lenny, just add the line

deb http://backports.debian.org/debian-backports lenny-backports main contrib non-free

into /etc/apt/sources.list, apt-get update and retry installing mysql-wsrep package.

Revision history for this message
Best Teemu Ollakka (teemu-ollakka) said : 		#2

Somehow missed that this was Ubuntu 10.04. The reason for installation failure is that mysql-client-5.1 package is too old.

To resolve the situation with partially installed mysql-wsrep, do 'dpkg -r mysql-wsrep' or 'dpkg --purge mysql-wsrep'.

Unfortunately it seems that 10.04 backports does not have recent enough mysql-client-5.1 package. Therefore the solutions are either to use demo distribution 'mysql-5.1.53-galera-0.7.6-x86_64.tgz' (see README-demo for further information) or to upgrade to Ubuntu 10.10. I'd recommend using the demo distribution for quick evaluation.

Sorry for the inconvenience.

Revision history for this message
Christopher Gorge A. Marges (gorge) said : 		#3

Thanks Teemu Ollakka, that solved my question.