This article describes how to handle potential RPM dependency problems.It covers MySQL Cluster, MySQL Replication, and MySQL Galera, see below.
On some platforms when using RPM-based install (Redhat/Centos/Fedora/OLN) you may run into problems to install the necessary files to display the web interface. The RPM dependency problem manifests itself during the installation of php-mysql, and you will not be able to see any useful information in the Web UI. You may run into this:
Transaction Check Error:
file /usr/share/man/man1/mysql_config.1.gz from install of mysql-5.0.77-4.el5_6.6.x86_64 conflicts with file from package MySQL-xxxxx
file /usr/bin/msql2mysql from install of mysql-5.0.77-4.el5_6.6.x86_64 conflicts with file from package MySQL-xxxxx
or
php-mysql-5.1.6-27.el5_5.3.x86_64 from rhel-x86_64-server-5 has depsolving problems --> Missing Dependency: libmysqlclient.so.15()(64bit) is needed by package php-mysql-5.1.6-27.el5_5.3.x86_64 (rhel-x86_64-server-5) php-mysql-5.1.6-27.el5_5.3.x86_64 from rhel-x86_64-server-5 has depsolving problems --> Missing Dependency: libmysqlclient.so.15(libmysqlclient_15)(64bit) is needed by package php-mysql-5.1.6-27.el5_5.3.x86_64 (rhel-x86_64-server-5) Error: Missing Dependency: libmysqlclient.so.15()(64bit) is needed by package php-mysql-5.1.6-27.el5_5.3.x86_64 (rhel-x86_64-server-5) Error: Missing Dependency: libmysqlclient.so.15(libmysqlclient_15)(64bit) is needed by package php-mysql-5.1.6-27.el5_5.3.x86_64 (rhel-x86_64-server-5)
We will try to fix it in the deploy.sh, but there may be issues still.
MySQL Cluster
After deploy.sh have finished do (on your clustercontrol server):
sudo rpm -e MySQL-Cluster-gpl-shared
sudo rpm -e MySQL-shared
sudo rpm -i mysqlcluster-7x-rpm/cluster/repo/MySQL-Cluster-gpl-shared-compat-7.1.15a-1.rhel5.x86_64.rpm
sudo yum -y install httpd php php-mysql php-gd rrdtool.x86_64
sudo /etc/init.d/httpd restart
Refresh the web browser or point it to http://<clustercontrolserver>/cmon.
MySQL Replication
After deploy.sh have finished do (on your clustercontrol server):
sudo rpm -i s9s-mysql-55-rpm/mysql/repo/MySQL-shared-compat-5.5.16-1.rhel5.x86_64.rpm
sudo yum -y install httpd php php-mysql php-gd rrdtool.x86_64
sudo /etc/init.d/httpd restart
Refresh the web browser or point it to http://<clustercontrolserver>/cmon
MySQL Galera
Let us know if there is a problem with this as we have not experienced any yet.
Comments
6 comments
Hi,
I had a problem on clean OS, CentOS 6.4 x64:
Description: By default, deploy.sh script deletes all mysql* packages, incuding the default mysql libs package ("mysql-libs"). During the deployment, Percona-Server-shared-55 is installed, but at the end, when issuing "yum install php php-mysql rrdtool" , there is error message since php requires "Percona-Server-shared-51" for some reason (Percona repo overrides CentOS Base repo for this lib), and Percona-Server-shared-55 is already installed, so there is a conflict.
My way to solve this is the following:
On management node only:
Install IUS repo and install mysqllibs16 from IUS:
nano ~/mysql/scripts/install/uninstall-rpm.sh and comment the following lines:
#remote_cmd2 $host "yum -y remove redland"
#remote_cmd2 $host "yum -y remove mysql-libs"
#remote_cmd2 $host "yum -y remove postfix"
#remote_cmd2 $host "yum -y remove sysbench"
#list=
remote\_getreply $host "rpm -qa | grep -i mysql"#if [ -n "$list" ]; then
remote_cmd $host "rpm -e $list"
#fi
#list=
remote\_getreply $host "rpm -qa | grep -i percona"#if [ -n "$list" ]; then
remote_cmd $host "rpm -e $list"
#fi
If needed, make shure to remove the unneeded packages from cluster node yourself, instead of letting deploy.sh script do it for you:
So, on all cluster nodes (we suppose you have a clean OS install)
Then start the usual deplyment process from management node
Best,
Andrija
First I want to apologize for my English I have a big problem which I describe below.
I recently installed centO6.5 without any problem, even Realise a configuration of a cluster successfully by the mysqlcluster intalacion x86_64 7.3.6 package, I have configured four machines where 1 is dedicated as the Management node that manages the MySQL Cluster, 2 configured as group nodes where the data tables and SQL where the MySQL server is connected to Cluster and where queries are made to the existing database runs saved ie these two nodes has both functions and finally have a machine that its only function is the SQL node.
I'm not sure that is necessary to put the configuration file and the cluster my.cnf, but Annex hoping my question is clearer and I can help.
MY.CNF (FILE)
[mysqld]
datadir=/usr/local/mysql/data
socket=/var/lib/mysql/mysql.sock
user=mysql
symbolic-links=0
ndbcluster
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[mysql_cluster]
ndb-connectstring=192.168.1.80
configuration file
[ndbd default]
NoOfReplicas=2
DataMemory=512M
IndexMemory=54M
[ndb_mgmd]
hostname=192.16.1.X
[ndbd]
hostname=192.168.10.X1
[ndbd]
hostname=192.168.10.X2
[mysqld]
hostname=192.168.10.X1
[mysqld]
hostname=192.168.10.X2
[mysqld]
hostname=192.168.10.X3
my problem is that when I want to connect the database created in mysql cluster with a web application they do not allow me to do the necessary connection, I tried installing php-mysql library with the command:
yum install httpd php php-mysql
But this did not help, however many problems GROUNDED genre in the cluster, I hope I can help and I've read everything about it and found nothing works for me.
Thanks for taking the time to read this and hope you can help me
hhhle12
i have installed mysql with galera and had problems on CentOS with apache since the galera packages for mysql will enter in conflict with mysql shared libraries such as libmysqlclient, for those who have the same problem when starting your apache server with php that is looking for libmysqlclient you can accomplish by downloading MySQL shared client libraries from http://rpm.pbone.net/index.php3/stat/4/idpl/26368311/dir/redhat_el_6/com/MySQL-shared-compat-5.6.19-1.el6.x86_64.rpm.html make sure you choose the correct version of your mysql and if 32 or 64 bit version once you download you can install via command rpm -i MySQL-shared-compat-5.5.39-2.el6.x86_64.rpm once it is installed restart your apache server, with command: service httpd restart and it should disapear the errors.
Hi Pedro,
Thanks for the information.
Which Galera vendor (codership, percona, mariadb) did you use and what MySQL version (5.5 or 5.6) and which Centos version are you using?
Best regards
Johan
Hi Johan i use codership , mysql 5.6 and centOS 6.4 in one server and 6.5 on the other server, All is working well and checked replication on the database on both servers.
Hi Pedro, Thanks for sharing this information. This issue has been teasing me for a couple of months but this post solves this problem. Thank you very much.
Please sign in to leave a comment.