Installing IUS package :Failed dependencies

Hello Soonho,

Thank you for your question,
it seems like you are attempting to install the RPM manually and not use YUM.

You will need to use YUM as there are multiple requirements that will be pulled in from IUS and Redhat/CentOS's base channels.

Please review the below documentation on how to proceed:

   http://iuscommunity.org/Docs/ClientUsageGuide

Dear Jeffrey;

Thanks for your quick question. I tried to install using "yum".
I use Centos 5.6.

Then, I got the following message.
====
root@ip-173-201-34-240 [~]# yum install php52-mysql-5.2.17-2.ius.el5.i386.rpm
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
addons | 951 B 00:00
base | 1.1 kB 00:00
extras | 2.1 kB 00:00
update | 1.9 kB 00:00
Excluding Packages in global exclude list
Finished
Setting up Install Process
Examining php52-mysql-5.2.17-2.ius.el5.i386.rpm: php52-mysql-5.2.17-2.ius.el5.i386
Nothing to do
root@ip-173-201-34-240 [~]# php -v
PHP 5.2.17 (cli) (built: Nov 1 2011 10:08:44)
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2010 Zend Technologies
========

Then, I tried to check the version of Mysql. I got the following message:
===========
root@ip-173-201-34-240 [~]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5127
Server version: 5.1.56-log MySQL Community Server (GPL)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license
=============
It seems not to change the Mysql. How would I know that the installation is successful?
Thanks for your answer in advance. : )

Best Regards,
Soonho

-----Original Message-----
From: <email address hidden> [mailto:<email address hidden>] On Behalf Of Jeffrey Ness
Sent: Thursday, November 03, 2011 4:26 PM
To: Kim, Soonho (IFPRI)
Subject: Re: [Question #177453]: Installing IUS package :Failed dependencies

Your question #177453 on IUS Community Project changed:
https://answers.launchpad.net/ius/+question/177453

Jeffrey Ness posted a new comment:
Hello Soonho,

Thank you for your question,
it seems like you are attempting to install the RPM manually and not use YUM.

You will need to use YUM as there are multiple requirements that will be pulled in from IUS and Redhat/CentOS's base channels.

Please review the below documentation on how to proceed:

   http://iuscommunity.org/Docs/ClientUsageGuide

--
You received this question notification because you asked the question.

Dear Jeffrey;

Dear Jeffrey;

I tried to install IUS package via YUM.
I got the following message:

root@ip-173-201-34-240 [/]# yum install http://dl.iuscommunity.org/pub/ius/stable/Redhat/5/i386/php52-mysql-5.2.17-2.ius.el5.i386.rpm
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
addons | 951 B 00:00
base | 1.1 kB 00:00
extras | 2.1 kB 00:00
update | 1.9 kB 00:00
Excluding Packages in global exclude list
Finished
Setting up Install Process
No package http://dl.iuscommunity.org/pub/ius/stable/Redhat/5/i386/php52-mysql-5.2.17-2.ius.el5.i386.rpm available.
Nothing to do
root@ip-173-201-34-240 [/]#

I have a quick question on the "YUM".
I keep studying on the Yum and I realized that some repositories might be added into /etc/yum.repos.d/ CentOS-Base.repo
Do I need to add the IUS repository into the the same file to install php52-mysql-5.2.17-2.ius.el5.i386.rpm ?

Best Regards,
Soonho

-----Original Message-----
From: <email address hidden> [mailto:<email address hidden>] On Behalf Of Jeffrey Ness
Sent: Thursday, November 03, 2011 4:26 PM
To: Kim, Soonho (IFPRI)
Subject: Re: [Question #177453]: Installing IUS package :Failed dependencies

Your question #177453 on IUS Community Project changed:
https://answers.launchpad.net/ius/+question/177453

Jeffrey Ness posted a new comment:
Hello Soonho,

Thank you for your question,
it seems like you are attempting to install the RPM manually and not use YUM.

You will need to use YUM as there are multiple requirements that will be pulled in from IUS and Redhat/CentOS's base channels.

Please review the below documentation on how to proceed:

   http://iuscommunity.org/Docs/ClientUsageGuide

--
You received this question notification because you asked the question.

Soonho,

I apologize for the delay.

The results above show the incorrect usage of YUM,
yum does not install based on a filename or url (but by a package name).

  http://docs.fedoraproject.org/en-US/Fedora/14/html/Amateur_Radio_Guide/apas02.html

With that stated the command you should be attempting to run would be:

   yum install php52-mysql

---

Before the package php52-mysql can be resolved however,
you need to have the ius-release and epel-release packages installed:

   http://iuscommunity.org/Docs/ClientUsageGuide#Configuration

This will create a ius.repo file in /etc/yum.repos.d/

Dear Jeffrey;

Thanks for your answer.

Now, I might have better understaning about YUM and IUS, after learning some basic of LINUX. : )

I will try to the configuration of IUS-release packages right now. : )

Best Regards,
Soonho

-----Original Message-----
From: <email address hidden> [mailto:<email address hidden>] On Behalf Of Jeffrey Ness
Sent: Monday, November 07, 2011 8:41 AM
To: Kim, Soonho (IFPRI)
Subject: Re: [Question #177453]: Installing IUS package :Failed dependencies

Your question #177453 on IUS Community Project changed:
https://answers.launchpad.net/ius/+question/177453

Jeffrey Ness posted a new comment:
Soonho,

I apologize for the delay.

The results above show the incorrect usage of YUM, yum does not install based on a filename or url (but by a package name).

  http://docs.fedoraproject.org/en-
US/Fedora/14/html/Amateur_Radio_Guide/apas02.html

With that stated the command you should be attempting to run would be:

   yum install php52-mysql

---

Before the package php52-mysql can be resolved however, you need to have the ius-release and epel-release packages installed:

   http://iuscommunity.org/Docs/ClientUsageGuide#Configuration

This will create a ius.repo file in /etc/yum.repos.d/

--
You received this question notification because you asked the question.

Dear Jeffry;

How are you?
I think I installed ius-release and epel-release packages.
Then, I tried to see what software are available typing yum list | grep -w \.ius\.

I got the following list:

root@ip-173-201-34-240 [~]# yum list | grep -w \.ius\.
 * ius: pancks.sothatswhy.org.uk
python26-elixir.noarch 0.6.1-1.ius.el5 ius
python26-jsonschema.noarch 0.2a-1.ius.el5 ius
python26-lxml.i386 2.0.11-2.ius.el5 ius
python26-lxml-debuginfo.i386 2.0.11-2.ius.el5 ius
python26-memcached.noarch 1.43-5.ius.el5 ius
python26-mysqldb.i386 1.2.3c1-1.ius.el5 ius
python26-mysqldb-debuginfo.i386 1.2.3c1-1.ius.el5 ius
python31.i386 3.1.4-1.ius.el5 ius
python31-debuginfo.i386 3.1.4-1.ius.el5 ius
python31-devel.i386 3.1.4-1.ius.el5 ius
python31-distribute.noarch 0.6.24-1.ius.el5 ius
python31-libs.i386 3.1.4-1.ius.el5 ius
python31-mod_wsgi.i386 3.3-3.ius.el5 ius
python31-mod_wsgi-debuginfo.i386 3.3-3.ius.el5 ius
python31-postgresql.i386 1.0.3-1.ius.el5 ius
python31-postgresql-debuginfo.i386 1.0.3-1.ius.el5 ius
python31-test.i386 3.1.4-1.ius.el5 ius
python31-tools.i386 3.1.4-1.ius.el5 ius
rsyslog4.i386 4.8.0-1.ius.el5 ius
rsyslog4-debuginfo.i386 4.8.0-1.ius.el5 ius
rsyslog4-gnutls.i386 4.8.0-1.ius.el5 ius
rsyslog4-gssapi.i386 4.8.0-1.ius.el5 ius
rsyslog4-mysql.i386 4.8.0-1.ius.el5 ius
rsyslog4-pgsql.i386 4.8.0-1.ius.el5 ius
rsyslog4-relp.i386 4.8.0-1.ius.el5 ius
tkinter31.i386 3.1.4-1.ius.el5 ius
root@ip-173-201-34-240 [~]#

I didn't see any php or mysql package from IUS.

Do you have any idea why there is no php or mysql ?
Thanks for your answer in advance. : )

Best Regards,
Soonho

-----Original Message-----
From: <email address hidden> [mailto:<email address hidden>] On Behalf Of Jeffrey Ness
Sent: Monday, November 07, 2011 8:41 AM
To: Kim, Soonho (IFPRI)
Subject: Re: [Question #177453]: Installing IUS package :Failed dependencies

Your question #177453 on IUS Community Project changed:
https://answers.launchpad.net/ius/+question/177453

Jeffrey Ness posted a new comment:
Soonho,

I apologize for the delay.

The results above show the incorrect usage of YUM, yum does not install based on a filename or url (but by a package name).

  http://docs.fedoraproject.org/en-
US/Fedora/14/html/Amateur_Radio_Guide/apas02.html

With that stated the command you should be attempting to run would be:

   yum install php52-mysql

---

Before the package php52-mysql can be resolved however, you need to have the ius-release and epel-release packages installed:

   http://iuscommunity.org/Docs/ClientUsageGuide#Configuration

This will create a ius.repo file in /etc/yum.repos.d/

--
You received this question notification because you asked the question.

Judging from the above output it would seem you are pulling from the below mirror:

    http://pancks.sothatswhy.org.uk/pub/ius/stable/Redhat/5/x86_64/

You will notice this mirror does in fact have php52 and php53u packages.

Do you by some chance have a exclude set for "php*" in one of your YUM configurations?

   /etc/yum.conf

Dear Jeffrey;

Thanks for your help. You are right. My yum.conf excludes php, mysql, and httpd...
So, I removed them from the yum.conf

So, I am running it again (yum install php52-mysql). It seemed to run. At the end of the running, I got an error message:

===================

root@ip-173-201-34-240 [/etc]# yum install php52-mysql
Loaded plugins: fastestmirror, replace
Loading mirror speeds from cached hostfile
 * epel: dl.fedoraproject.org
 * ius: pancks.sothatswhy.org.uk
addons | 951 B 00:00
base | 1.1 kB 00:00
epel | 3.7 kB 00:00
extras | 2.1 kB 00:00
ius | 2.2 kB 00:00
update | 1.9 kB 00:00
Excluding Packages in global exclude list
Finished
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package php52-mysql.i386 0:5.2.17-2.ius.el5 set to be updated
--> Processing Dependency: php52-common = 5.2.17-2.ius.el5 for package: php52-mysql
--> Processing Dependency: libmysqlclient.so.15 for package: php52-mysql
--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15) for package: php52-mysql
--> Processing Dependency: php52-pdo for package: php52-mysql
--> Running transaction check
---> Package mysql.i386 0:5.0.77-4.el5_6.6 set to be updated
--> Processing Dependency: perl(DBI) for package: mysql
---> Package php52-common.i386 0:5.2.17-2.ius.el5 set to be updated
--> Processing Dependency: php52 = 5.2.17-2.ius.el5 for package: php52-common
---> Package php52-pdo.i386 0:5.2.17-2.ius.el5 set to be updated
--> Running transaction check
---> Package perl-DBI.i386 0:1.52-2.el5 set to be updated
---> Package php52.i386 0:5.2.17-2.ius.el5 set to be updated
--> Processing Dependency: httpd-mmn = 20051115 for package: php52
--> Processing Dependency: php52-cli = 5.2.17-2.ius.el5 for package: php52
--> Running transaction check
---> Package httpd.i386 0:2.2.3-45.el5.centos.1 set to be updated
---> Package php52-cli.i386 0:5.2.17-2.ius.el5 set to be updated
--> Processing Conflict: mysql conflicts MySQL
--> Finished Dependency Resolution
mysql-5.0.77-4.el5_6.6.i386 from update has depsolving problems
  --> mysql conflicts with MySQL-server
Error: mysql conflicts with MySQL-server
 You could try using --skip-broken to work around the problem
 You could try running: package-cleanup --problems
                        package-cleanup --dupes
                        rpm -Va --nofiles --nodigest
The program package-cleanup is found in the yum-utils package.
================
Do you have any idea on how to fix the error (Error: mysql conflicts with MySQL-server)? I might guess that we might use "package-cleanup" command......

Best Regards,
Soonho

-----Original Message-----
From: <email address hidden> [mailto:<email address hidden>] On Behalf Of Jeffrey Ness
Sent: Monday, November 07, 2011 2:11 PM
To: Kim, Soonho (IFPRI)
Subject: Re: [Question #177453]: Installing IUS package :Failed dependencies

Your question #177453 on IUS Community Project changed:
https://answers.launchpad.net/ius/+question/177453

    Status: Open => Answered

Jeffrey Ness proposed the following answer:
Judging from the above output it would seem you are pulling from the below mirror:

    http://pancks.sothatswhy.org.uk/pub/ius/stable/Redhat/5/x86_64/

You will notice this mirror does in fact have php52 and php53u packages.

Do you by some chance have a exclude set for "php*" in one of your YUM configurations?

   /etc/yum.conf

--
If this answers your question, please go to the following page to let us know that it is solved:
https://answers.launchpad.net/ius/+question/177453/+confirm?answer_id=6

If you still need help, you can reply to this email or go to the following page to enter your feedback:
https://answers.launchpad.net/ius/+question/177453

You received this question notification because you asked the question.

So being you are installing a php52 MySQL module libmysqlclient is required (a mysql package providing this lib)
you can see below how YUM is attempting to automatically pull in "mysql":

   --> Processing Dependency: libmysqlclient.so.15 for package: php52-mysql
   --> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15) for package: php52-mysql

However it appears you have a non Redhat mysql package which does not provide this library:

   --> Processing Conflict: mysql conflicts MySQL

I'm not sure where you obtained "MySQL" from, but you can get the package information like below:

   rpm -qi MySQL
   rpm -qi MySQL-server

Since these are not the Redhat packages our PHP packages are built against,
you only option would be to remove the MySQL packages and install the Redhat provided 'mysql' or IUS provided 'mysql50'/'mysql55' packages.

Dear Jeffrey;

I found the command for removing (yum remove packpage name). Then, I removed the package.
Then, I tried to restall IUS (yum install php52-mysql).

Then, I got the following message:
============

root@ip-173-201-34-240 [~]# yum install php52-mysql
Loaded plugins: fastestmirror, replace
Loading mirror speeds from cached hostfile
 * epel: mirrors.solfo.com
 * ius: pancks.sothatswhy.org.uk
addons | 951 B 00:00
base | 1.1 kB 00:00
epel | 3.7 kB 00:00
extras | 2.1 kB 00:00
ius | 2.2 kB 00:00
update | 1.9 kB 00:00
Excluding Packages in global exclude list
Finished
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package php52-mysql.i386 0:5.2.17-2.ius.el5 set to be updated
--> Processing Dependency: php52-common = 5.2.17-2.ius.el5 for package: php52-mysql
--> Processing Dependency: libmysqlclient.so.15 for package: php52-mysql
--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15) for package: php52-mysql
--> Processing Dependency: php52-pdo for package: php52-mysql
--> Running transaction check
---> Package mysql.i386 0:5.0.77-4.el5_6.6 set to be updated
--> Processing Dependency: perl(DBI) for package: mysql
---> Package php52-common.i386 0:5.2.17-2.ius.el5 set to be updated
--> Processing Dependency: php52 = 5.2.17-2.ius.el5 for package: php52-common
---> Package php52-pdo.i386 0:5.2.17-2.ius.el5 set to be updated
--> Running transaction check
---> Package perl-DBI.i386 0:1.52-2.el5 set to be updated
---> Package php52.i386 0:5.2.17-2.ius.el5 set to be updated
--> Processing Dependency: httpd-mmn = 20051115 for package: php52
--> Processing Dependency: php52-cli = 5.2.17-2.ius.el5 for package: php52
--> Running transaction check
---> Package httpd.i386 0:2.2.3-45.el5.centos.1 set to be updated
---> Package php52-cli.i386 0:5.2.17-2.ius.el5 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

========================================================================================================================================================================
 Package Arch Version Repository Size
========================================================================================================================================================================
Installing:
 php52-mysql i386 5.2.17-2.ius.el5 ius 94 k
Installing for dependencies:
 httpd i386 2.2.3-45.el5.centos.1 update 1.2 M
 mysql i386 5.0.77-4.el5_6.6 update 4.8 M
 perl-DBI i386 1.52-2.el5 base 600 k
 php52 i386 5.2.17-2.ius.el5 ius 1.4 M
 php52-cli i386 5.2.17-2.ius.el5 ius 2.6 M
 php52-common i386 5.2.17-2.ius.el5 ius 256 k
 php52-pdo i386 5.2.17-2.ius.el5 ius 75 k

Transaction Summary
========================================================================================================================================================================
Install 8 Package(s)
Upgrade 0 Package(s)

Total size: 11 M
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test

Transaction Check Error:
  file /usr/bin/mysql from install of mysql-5.0.77-4.el5_6.6.i386 conflicts with file from package MySQL-client-5.1.56-0.glibc23.i386
  file /usr/bin/mysql_waitpid from install of mysql-5.0.77-4.el5_6.6.i386 conflicts with file from package MySQL-client-5.1.56-0.glibc23.i386
  file /usr/bin/mysqlaccess from install of mysql-5.0.77-4.el5_6.6.i386 conflicts with file from package MySQL-client-5.1.56-0.glibc23.i386
  file /usr/bin/mysqladmin from install of mysql-5.0.77-4.el5_6.6.i386 conflicts with file from package MySQL-client-5.1.56-0.glibc23.i386
  file /usr/bin/mysqlbinlog from install of mysql-5.0.77-4.el5_6.6.i386 conflicts with file from package MySQL-client-5.1.56-0.glibc23.i386
  file /usr/bin/mysqlcheck from install of mysql-5.0.77-4.el5_6.6.i386 conflicts with file from package MySQL-client-5.1.56-0.glibc23.i386
  file /usr/bin/mysqldump from install of mysql-5.0.77-4.el5_6.6.i386 conflicts with file from package MySQL-client-5.1.56-0.glibc23.i386
  file /usr/bin/mysqlimport from install of mysql-5.0.77-4.el5_6.6.i386 conflicts with file from package MySQL-client-5.1.56-0.glibc23.i386
  file /usr/bin/mysqlshow from install of mysql-5.0.77-4.el5_6.6.i386 conflicts with file from package MySQL-client-5.1.56-0.glibc23.i386
  file /usr/share/man/man1/mysql.1.gz from install of mysql-5.0.77-4.el5_6.6.i386 conflicts with file from package MySQL-client-5.1.56-0.glibc23.i386
  file /usr/share/man/man1/mysql_find_rows.1.gz from install of mysql-5.0.77-4.el5_6.6.i386 conflicts with file from package MySQL-client-5.1.56-0.glibc23.i386
  file /usr/share/man/man1/mysqlaccess.1.gz from install of mysql-5.0.77-4.el5_6.6.i386 conflicts with file from package MySQL-client-5.1.56-0.glibc23.i386
  file /usr/share/man/man1/mysqladmin.1.gz from install of mysql-5.0.77-4.el5_6.6.i386 conflicts with file from package MySQL-client-5.1.56-0.glibc23.i386
  file /usr/share/man/man1/mysqldump.1.gz from install of mysql-5.0.77-4.el5_6.6.i386 conflicts with file from package MySQL-client-5.1.56-0.glibc23.i386
  file /usr/share/man/man1/mysqlshow.1.gz from install of mysql-5.0.77-4.el5_6.6.i386 conflicts with file from package MySQL-client-5.1.56-0.glibc23.i386
  file /usr/bin/mysql_config from install of mysql-5.0.77-4.el5_6.6.i386 conflicts with file from package MySQL-devel-5.1.56-0.glibc23.i386
  file /usr/share/man/man1/mysql_config.1.gz from install of mysql-5.0.77-4.el5_6.6.i386 conflicts with file from package MySQL-devel-5.1.56-0.glibc23.i386

Error Summary
-------------

root@ip-173-201-34-240 [~]# edit /usr/bin/mysql
 php52-mysql i386 5.2.17-2.ius.el5 ius 94 k
Installing for dependencies:
 httpd i386 2.2.3-45.el5.centos.1 update 1.2 M
 mysql i386 5.0.77-4.el5_6.6 update 4.8 M
 perl-DBI i386 1.52-2.el5 base 600 k
 php52 i386 5.2.17-2.ius.el5 ius 1.4 M
 php52-cli i386 5.2.17-2.ius.el5 ius 2.6 M
 php52-common i386 5.2.17-2.ius.el5 ius 256 k
 php52-pdo i386 5.2.17-2.ius.el5 ius 75 k

Transaction Summary
========================================================================================================================================================================
Install 8 Package(s)
Upgrade 0 Package(s)

Total size: 11 M
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test

Transaction Check Error:
  file /usr/bin/mysql from install of mysql-5.0.77-4.el5_6.6.i386 conflicts with file from package MySQL-client-5.1.56-0.glibc23.i386
  file /usr/bin/mysql_waitpid from install of mysql-5.0.77-4.el5_6.6.i386 conflicts with file from package MySQL-client-5.1.56-0.glibc23.i386
  file /usr/bin/mysqlaccess from install of mysql-5.0.77-4.el5_6.6.i386 conflicts with file from package MySQL-client-5.1.56-0.glibc23.i386
  file /usr/bin/mysqladmin from install of mysql-5.0.77-4.el5_6.6.i386 conflicts with file from package MySQL-client-5.1.56-0.glibc23.i386
  file /usr/bin/mysqlbinlog from install of mysql-5.0.77-4.el5_6.6.i386 conflicts with file from package MySQL-client-5.1.56-0.glibc23.i386
  file /usr/bin/mysqlcheck from install of mysql-5.0.77-4.el5_6.6.i386 conflicts with file from package MySQL-client-5.1.56-0.glibc23.i386
  file /usr/bin/mysqldump from install of mysql-5.0.77-4.el5_6.6.i386 conflicts with file from package MySQL-client-5.1.56-0.glibc23.i386
  file /usr/bin/mysqlimport from install of mysql-5.0.77-4.el5_6.6.i386 conflicts with file from package MySQL-client-5.1.56-0.glibc23.i386
  file /usr/bin/mysqlshow from install of mysql-5.0.77-4.el5_6.6.i386 conflicts with file from package MySQL-client-5.1.56-0.glibc23.i386
  file /usr/share/man/man1/mysql.1.gz from install of mysql-5.0.77-4.el5_6.6.i386 conflicts with file from package MySQL-client-5.1.56-0.glibc23.i386
  file /usr/share/man/man1/mysql_find_rows.1.gz from install of mysql-5.0.77-4.el5_6.6.i386 conflicts with file from package MySQL-client-5.1.56-0.glibc23.i386
  file /usr/share/man/man1/mysqlaccess.1.gz from install of mysql-5.0.77-4.el5_6.6.i386 conflicts with file from package MySQL-client-5.1.56-0.glibc23.i386
  file /usr/share/man/man1/mysqladmin.1.gz from install of mysql-5.0.77-4.el5_6.6.i386 conflicts with file from package MySQL-client-5.1.56-0.glibc23.i386
  file /usr/share/man/man1/mysqldump.1.gz from install of mysql-5.0.77-4.el5_6.6.i386 conflicts with file from package MySQL-client-5.1.56-0.glibc23.i386
  file /usr/share/man/man1/mysqlshow.1.gz from install of mysql-5.0.77-4.el5_6.6.i386 conflicts with file from package MySQL-client-5.1.56-0.glibc23.i386
  file /usr/bin/mysql_config from install of mysql-5.0.77-4.el5_6.6.i386 conflicts with file from package MySQL-devel-5.1.56-0.glibc23.i386
  file /usr/share/man/man1/mysql_config.1.gz from install of mysql-5.0.77-4.el5_6.6.i386 conflicts with file from package MySQL-devel-5.1.56-0.glibc23.i386

Error Summary
-------------
I guess that I removed the package but some files are still in the system. I tried to open each file mentioned above. But, it is not human readable. : (

Do you have any idea to fix this error messages?
Thanks so much in advance. : )

Best Regards,
Soonho

-----Original Message-----
From: <email address hidden> [mailto:<email address hidden>] On Behalf Of Jeffrey Ness
Sent: Monday, November 07, 2011 3:56 PM
To: Kim, Soonho (IFPRI)
Subject: Re: [Question #177453]: Installing IUS package :Failed dependencies

Your question #177453 on IUS Community Project changed:
https://answers.launchpad.net/ius/+question/177453

    Status: Open => Answered

Jeffrey Ness proposed the following answer:
So being you are installing a php52 MySQL module libmysqlclient is required (a mysql package providing this lib) you can see below how YUM is attempting to automatically pull in "mysql":

   --> Processing Dependency: libmysqlclient.so.15 for package: php52-mysql
   --> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15) for package: php52-mysql

However it appears you have a non Redhat mysql package which does not provide this library:

   --> Processing Conflict: mysql conflicts MySQL

I'm not sure where you obtained "MySQL" from, but you can get the package information like below:

   rpm -qi MySQL
   rpm -qi MySQL-server

Since these are not the Redhat packages our PHP packages are built against, you only option would be to remove the MySQL packages and install the Redhat provided 'mysql' or IUS provided 'mysql50'/'mysql55' packages.

--
If this answers your question, please go to the following page to let us know that it is solved:
https://answers.launchpad.net/ius/+question/177453/+confirm?answer_id=8

If you still need help, you can reply to this email or go to the following page to enter your feedback:
https://answers.launchpad.net/ius/+question/177453

You received this question notification because you asked the question.

Dear Jeffrey;

I checked the MySQL -server by typing the command which you sent
====================
root@ip-173-201-34-240 [/etc]# rpm -qi Mysql
package Mysql is not installed
root@ip-173-201-34-240 [/etc]# rpm -qi MySQL
package MySQL is not installed
root@ip-173-201-34-240 [/etc]# rpm -qi MySQL-server
Name : MySQL-server Relocations: (not relocatable)
Version : 5.1.56 Vendor: Sun Microsystems, Inc.
Release : 0.glibc23 Build Date: Mon Mar 7 15:00:58 2011
Install Date: Tue Nov 1 10:00:30 2011 Build Host: rpmb-centos-5-32bit
Group : Applications/Databases Source RPM: MySQL-5.1.56-0.glibc23.src.rpm
Size : 113724056 License: Copyright 2000-2008 MySQL AB, 2009 Sun Microsystems, Inc. All rights reserved. Use is subject to license terms. Under GPL license as shown in the Description field.
Signature : (none)
Packager : Sun Microsystems, Inc. Product Engineering Team <email address hidden>
URL : http://www.mysql.com/
Summary : MySQL - a very fast and reliable SQL database server
Description :
The MySQL(TM) software delivers a very fast, multi-threaded, multi-user,
and robust SQL (Structured Query Language) database server. MySQL Server
is intended for mission-critical, heavy-load production systems as well
as for embedding into mass-deployed software. MySQL is a trademark of
Sun Microsystems, Inc.

Copyright 2000-2008 MySQL AB, 2009 Sun Microsystems, Inc. All rights reserved.
Use is subject to license terms.

This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license.

The MySQL web site (http://www.mysql.com/) provides the latest
news and information about the MySQL software. Also please see the
documentation and the manual for more information.

This package includes the MySQL server binary (incl. InnoDB) as well
as related utilities to run and administrate a MySQL server.

If you want to access and work with the database, you have to install
package "MySQL-client" as well!
======================
I use CPANEL, so hosting company might install it for me. : )

Could you kindly tell me how to remove the MYSQL-SERVER (what command)?
Thanks again!!

If I fix this issue, it would become for me to install IUS package succesfully. : )

Best Regards,
Soonho

-----Original Message-----
From: <email address hidden> [mailto:<email address hidden>] On Behalf Of Jeffrey Ness
Sent: Monday, November 07, 2011 3:56 PM
To: Kim, Soonho (IFPRI)
Subject: Re: [Question #177453]: Installing IUS package :Failed dependencies

Your question #177453 on IUS Community Project changed:
https://answers.launchpad.net/ius/+question/177453

    Status: Open => Answered

Jeffrey Ness proposed the following answer:
So being you are installing a php52 MySQL module libmysqlclient is required (a mysql package providing this lib) you can see below how YUM is attempting to automatically pull in "mysql":

   --> Processing Dependency: libmysqlclient.so.15 for package: php52-mysql
   --> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15) for package: php52-mysql

However it appears you have a non Redhat mysql package which does not provide this library:

   --> Processing Conflict: mysql conflicts MySQL

I'm not sure where you obtained "MySQL" from, but you can get the package information like below:

   rpm -qi MySQL
   rpm -qi MySQL-server

Since these are not the Redhat packages our PHP packages are built against, you only option would be to remove the MySQL packages and install the Redhat provided 'mysql' or IUS provided 'mysql50'/'mysql55' packages.

--
If this answers your question, please go to the following page to let us know that it is solved:
https://answers.launchpad.net/ius/+question/177453/+confirm?answer_id=8

If you still need help, you can reply to this email or go to the following page to enter your feedback:
https://answers.launchpad.net/ius/+question/177453

You received this question notification because you asked the question.

Soonho,

Can you please provide the output of the following commands:

$ rpm -qa | grep -i php

$ rpm -qa | grep -i mysql

This would better help us to give you an exact command to run to get everything settled.

Dear BJ;

Here is the information:

root@ip-173-201-34-240 [~]# rpm -qa | grep -i php
root@ip-173-201-34-240 [~]# rpm -qa | grep -i mysql
MySQL-client-5.1.56-0.glibc23
MySQL-devel-5.1.56-0.glibc23
MySQL-shared-5.1.56-0.glibc23
MySQL-test-5.1.56-0.glibc23

If you need any info, please let me know that. : )

Best Regards,
Soonho

-----Original Message-----
From: <email address hidden> [mailto:<email address hidden>] On Behalf Of BJ Dierkes
Sent: Monday, November 07, 2011 4:56 PM
To: Kim, Soonho (IFPRI)
Subject: Re: [Question #177453]: Installing IUS package :Failed dependencies

Your question #177453 on IUS Community Project changed:
https://answers.launchpad.net/ius/+question/177453

    Status: Open => Needs information

BJ Dierkes requested more information:
Soonho,

Can you please provide the output of the following commands:

$ rpm -qa | grep -i php

$ rpm -qa | grep -i mysql

This would better help us to give you an exact command to run to get everything settled.

--
To answer this request for more information, you can either reply to this email or enter your reply at the following page:
https://answers.launchpad.net/ius/+question/177453

You received this question notification because you asked the question.

On Nov 7, 2011, at 4:01 PM, Soonho Kim wrote:

> Here is the information:
>
> root@ip-173-201-34-240 [~]# rpm -qa | grep -i php
> root@ip-173-201-34-240 [~]# rpm -qa | grep -i mysql
> MySQL-client-5.1.56-0.glibc23
> MySQL-devel-5.1.56-0.glibc23
> MySQL-shared-5.1.56-0.glibc23
> MySQL-test-5.1.56-0.glibc23
>

Thats what I thought. You need to remove all of the MySQL sub packages as well.

# rpm -e MySQL-client MySQL-devel MySQL-shared MySQL-test

Then you should be able to install my php52 and mysql51 from IUS:

# yum install php52 php52-mysql mysql51 mysql51-server

There are dozens of additional php52 packages so you may wish to install more than that listed above. But this should get you started.

---
derks

Dear BJ;

Thanks for your quick answer!

I removed all MYSQL packages and install php and mysql from IUS repo.

I got another problem when I run the mysql

See the following message

==============

root@ip-173-201-34-240 [~]# rpm -qa | grep -i php
php52-cli-5.2.17-2.ius.el5
php52-common-5.2.17-2.ius.el5
php52-mysql-5.2.17-2.ius.el5
php52-5.2.17-2.ius.el5
php52-pdo-5.2.17-2.ius.el5
root@ip-173-201-34-240 [~]# rpm -qa | grep -i mysql
mysql51-libs-5.1.59-1.ius.el5
mysql51-server-5.1.59-1.ius.el5
mysqlclient15-5.0.92-1.ius.el5
php52-mysql-5.2.17-2.ius.el5
mysql51-5.1.59-1.ius.el5
perl-DBD-MySQL-3.0007-2.el5
root@ip-173-201-34-240 [~]# yum install php52 php52-mysql mysql51 mysql51-server
Loaded plugins: fastestmirror, replace
Loading mirror speeds from cached hostfile
 * epel: epel.mirror.freedomvoice.com
 * ius: pancks.sothatswhy.org.uk
addons | 951 B 00:00
base | 1.1 kB 00:00
epel | 3.7 kB 00:00
extras | 2.1 kB 00:00
ius | 2.2 kB 00:00
update | 1.9 kB 00:00
Excluding Packages in global exclude list
Finished
Setting up Install Process
Nothing to do
root@ip-173-201-34-240 [~]# /etc/init.d/mysqld start
root@ip-173-201-34-240 [~]# mysql -v
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
===============
I seems to run the mysql but when I check the version, then I got the error " ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)".

Do you have any idea about it?

Best Regards,
Soonho

-----Original Message-----
From: <email address hidden> [mailto:<email address hidden>] On Behalf Of BJ Dierkes
Sent: Monday, November 07, 2011 6:56 PM
To: Kim, Soonho (IFPRI)
Subject: Re: [Question #177453]: Installing IUS package :Failed dependencies

Your question #177453 on IUS Community Project changed:
https://answers.launchpad.net/ius/+question/177453

    Status: Open => Answered

BJ Dierkes proposed the following answer:

On Nov 7, 2011, at 4:01 PM, Soonho Kim wrote:

> Here is the information:
>
> root@ip-173-201-34-240 [~]# rpm -qa | grep -i php
> root@ip-173-201-34-240 [~]# rpm -qa | grep -i mysql
> MySQL-client-5.1.56-0.glibc23
> MySQL-devel-5.1.56-0.glibc23
> MySQL-shared-5.1.56-0.glibc23
> MySQL-test-5.1.56-0.glibc23
>

Thats what I thought. You need to remove all of the MySQL sub packages as well.

# rpm -e MySQL-client MySQL-devel MySQL-shared MySQL-test

Then you should be able to install my php52 and mysql51 from IUS:

# yum install php52 php52-mysql mysql51 mysql51-server

There are dozens of additional php52 packages so you may wish to install more than that listed above. But this should get you started.

---
derks

--
If this answers your question, please go to the following page to let us know that it is solved:
https://answers.launchpad.net/ius/+question/177453/+confirm?answer_id=13

If you still need help, you can reply to this email or go to the following page to enter your feedback:
https://answers.launchpad.net/ius/+question/177453

You received this question notification because you asked the question.

Soonho,

Are you sure MySQL is running?

   /etc/init.d/mysqld status

You may also want to check your mysql logs:

  tail /var/log/mysqld.log

I would also check your socket file:

   ls -l /var/lib/mysql/mysql.sock

Dear Jeffrey;

Thanks for your quick question.

Here is my servers' response based on your comments:

--------------
root@ip-173-201-34-240 [~]#
root@ip-173-201-34-240 [~]# /etc/init.d/mysqld start
root@ip-173-201-34-240 [~]#
root@ip-173-201-34-240 [~]# /etc/init.d/mysqld status
mysqld is stopped
root@ip-173-201-34-240 [~]# tail /var/log/mysqld.log
root@ip-173-201-34-240 [~]# ls -l /var/lib/mysql/mysql.sock
/bin/ls: /var/lib/mysql/mysql.sock: No such file or directory
root@ip-173-201-34-240 [~]#
=============
It seems that the server is not running. I am not sure why the server is not running. I think I installed all packages of mysql from IUS repo. Do I need to remove all and install again?
Thanks so much for your help in advance.

Best Regards,
Soonho

-----Original Message-----
From: <email address hidden> [mailto:<email address hidden>] On Behalf Of Jeffrey Ness
Sent: Tuesday, November 08, 2011 9:36 AM
To: Kim, Soonho (IFPRI)
Subject: Re: [Question #177453]: Installing IUS package :Failed dependencies

Your question #177453 on IUS Community Project changed:
https://answers.launchpad.net/ius/+question/177453

Jeffrey Ness posted a new comment:
Soonho,

Are you sure MySQL is running?

   /etc/init.d/mysqld status

You may also want to check your mysql logs:

  tail /var/log/mysqld.log

I would also check your socket file:

   ls -l /var/lib/mysql/mysql.sock

--
You received this question notification because you asked the question.

Can you please cat our your my.cnf?

      cat /etc/my.cnf

Dear Jeffrey;

Here is the output:

root@ip-173-201-34-240 [~]# cat /etc/my.cnf
[mysqld]
set-variable = max_connections=500
log-slow-queries
safe-show-database

Best Regarfds,
Soonho

-----Original Message-----
From: <email address hidden> [mailto:<email address hidden>] On Behalf Of Jeffrey Ness
Sent: Tuesday, November 08, 2011 11:26 AM
To: Kim, Soonho (IFPRI)
Subject: Re: [Question #177453]: Installing IUS package :Failed dependencies

Your question #177453 on IUS Community Project changed:
https://answers.launchpad.net/ius/+question/177453

Jeffrey Ness posted a new comment:
Can you please cat our your my.cnf?

      cat /etc/my.cnf

--
You received this question notification because you asked the question.

You might want to try this:

# mv /etc/my.cnf /etc/my.cnf.original

# cp -a /etc/my.cnf.rpmnew /etc/my.cnf

That is of course if /etc/my.cnf.rpmnew exists ... this would be the version of my.cnf from our packages (which are known to work for us).

Dear BJ;

Thanks so much for your comments.
I did the commands. Then I tried to catch some info from /etc/my.cnf

==================
rroot@ip-173-201-34-240 [~]# cat /etc/my.cnf
## _______________________________________________________________________
## / Rackspace MySQL 5.1 Terse Configuration File v2.12 \
## | |
## | This is a base configuration file containing the most frequently used |
## | settings with reasonably defined default values for configuring and |
## | tuning MySQL. Note that these settings can likely be further tuned in |
## | order to get optimum performance from MySQL based upon the database |
## | configuration and hardware platform. |
## | |
## | While the settings provided are likely sufficient for most |
## | situations, an exhaustive list of settings (with descriptions) can be |
## | found at: |
## | http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html |
## | |
## | Further configuration file examples (with and without comments) can |
## | be found in /usr/share/doc. |
## | |
## | Take care to only add/remove/change a setting if you are comfortable |
## | doing so! For Rackspace customers, if you have any questions or |
## | concerns, please contact the MySQL Database Services Team. Be aware |
## | that some work performed by this team can involve additional billable |
## \ fees. /
## -----------------------------------------------------------------------
## \ ^__^
## \ (oo)\_______
## (__)\ )\/\
## ||----w |
## || ||
[mysqld]
## General
datadir = /var/lib/mysql
tmpdir = /var/lib/mysqltmp
socket = /var/lib/mysql/mysql.sock
skip-external-locking = 1
skip-name-resolve
open-files-limit = 20000
#sql-mode = TRADITIONAL
#event-scheduler = 1
## Cache
thread-cache-size = 16
table-open-cache = 2048
table-definition-cache = 512
query-cache-size = 32M
query-cache-limit = 1M
## Per-thread Buffers
sort-buffer-size = 1M
read-buffer-size = 1M
read-rnd-buffer-size = 8M
join-buffer-size = 1M
## Temp Tables
tmp-table-size = 64M
max-heap-table-size = 64M
## Networking
back-log = 100
#max-connections = 200
max-connect-errors = 10000
max-allowed-packet = 16M
interactive-timeout = 600
wait-timeout = 600
### Storage Engines
#default-storage-engine = InnoDB
innodb = FORCE
## MyISAM
key-buffer-size = 64M
myisam-sort-buffer-size = 128M
## InnoDB
#innodb-log-group-home-dir = /var/lib/mysql
#innodb-data-home-dir = /var/lib/mysql
#innodb-data-file-path = ibdata1:2000M;ibdata2:10M:autoextend
innodb-buffer-pool-size = 16M
#innodb-additional-mem-pool-size= 20M
#innodb-log-file-size = 100M
innodb_log_files_in_group = 2
innodb-log-buffer-size = 4M
#innodb-flush-method = O_DIRECT
#innodb-file-per-table = 1
#innodb-open-files = 300
#innodb-thread-concurrency = 16
#innodb-support-xa = 0
## Replication
server-id = 1
#log-bin = /var/lib/mysqllogs/bin-log
#relay-log = /var/lib/mysqllogs/relay-log
#expire-logs-days = 14
#read-only = 1
#sync-binlog = 1
#log-slave-updates = 1
#binlog-format = STATEMENT
#auto-increment-offset = 1
#auto-increment-increment = 2
## Logging
#log-output = FILE
#slow-query-log = 1
#slow-query-log-file = /var/lib/mysqllogs/slow-log
#long-query-time = 2
#log-queries-not-using-indexes = 1
[mysqld_safe]
log-error = /var/log/mysqld.log
============================
Now, I tried to start mysql server. I googled for mysqld and realized that mysqld is a server, so I started it by typing /etc/init.d/mysqld start. But, it seems not to work.
So, I tried to type restart
Here is some output
==================
root@ip-173-201-34-240 [/var/log]# /etc/init.d/mysqld restart
Stopping mysqld: [ OK ]
root@ip-173-201-34-240 [/var/log]# mysql -v
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
root@ip-173-201-34-240 [/var/log]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
root@ip-173-201-34-240 [/var/log]#
root@ip-173-201-34-240 [/var/log]#
=====================
Based on that, I think the mysql is still not working.
Did I type another command to start Mysqld?

Thanks so much for your help in advance. : )

Best Regards,
Soonho

________________________________

From: <email address hidden> on behalf of BJ Dierkes
Sent: Tue 11/8/2011 2:20 PM
To: Kim, Soonho (IFPRI)
Subject: Re: [Question #177453]: Installing IUS package :Failed dependencies

Your question #177453 on IUS Community Project changed:
https://answers.launchpad.net/ius/+question/177453

BJ Dierkes posted a new comment:
You might want to try this:

# mv /etc/my.cnf /etc/my.cnf.original

# cp -a /etc/my.cnf.rpmnew /etc/my.cnf

That is of course if /etc/my.cnf.rpmnew exists ... this would be the
version of my.cnf from our packages (which are known to work for us).

--
You received this question notification because you asked the question.

It does seem MySQL is not starting as a restart should show 2 results on screen:

  * MySQL Stopped
  * MySQL Started

Now that you have the correct my.cnf you should have a error log showing the issue,
please run the below commands:

  /etc/init.d/mysqld stop
  /etc/init.d/mysqld start
  tail /var/log/mysqld.log

My gut feeling is telling my your MySQL directories are still owned by the old MYSQL rpms,
and the IUS rpms can not write to that directory.

Dear Jeffrey;

How are you?
I didn't do anything yesterday. But, now the mysqld is working.

==================

root@ip-173-201-34-240 [~]# /etc/init.d/mysqld stop
Stopping mysqld: [ OK ]
root@ip-173-201-34-240 [~]# /etc/init.d/mysqld start
Starting mysqld: [ OK ]
root@ip-173-201-34-240 [~]# mysql -v
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 209
Server version: 5.1.56 MySQL Community Server (GPL)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Reading history-file /root/.mysql_history
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>
=====================

Thanks so much for all of your help. : )

Best Regards,
Soonho

-----Original Message-----
From: <email address hidden> [mailto:<email address hidden>] On Behalf Of Jeffrey Ness
Sent: Wednesday, November 09, 2011 8:46 AM
To: Kim, Soonho (IFPRI)
Subject: Re: [Question #177453]: Installing IUS package :Failed dependencies

Your question #177453 on IUS Community Project changed:
https://answers.launchpad.net/ius/+question/177453

Jeffrey Ness posted a new comment:
It does seem MySQL is not starting as a restart should show 2 results on
screen:

  * MySQL Stopped
  * MySQL Started

Now that you have the correct my.cnf you should have a error log showing the issue, please run the below commands:

  /etc/init.d/mysqld stop
  /etc/init.d/mysqld start
  tail /var/log/mysqld.log

My gut feeling is telling my your MySQL directories are still owned by the old MYSQL rpms, and the IUS rpms can not write to that directory.

--
You received this question notification because you asked the question.

That is very good news.

I'm am glad everything appears to be working for you now.

Jeffrey-

Dear Jeffrey;

How are you?
Sorry for asking the question again.

I realized that mysql was not working, because my hosting server forced re-installing the MYSQL automatically in the morning.
That's why I thought it worked.

Now, I have the same problem, which is that the mysql is not running.
-----------------
root@ip-173-201-34-240 [/]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
root@ip-173-201-34-240 [/]#
-------------------

Here is my log:

--------------------------
root@ip-173-201-34-240 [/]# tail /var/log/mysqld.log
Version: '5.1.56' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
111109 0:11:52 [Warning] 'user' entry '<email address hidden>' ignored in --skip-name-resolve mode.
111109 14:35:02 [Note] /usr/sbin/mysqld: Normal shutdown

111109 14:35:02 [Note] Event Scheduler: Purging the queue. 0 events
111109 14:35:02 InnoDB: Starting shutdown...
111109 14:35:05 InnoDB: Shutdown completed; log sequence number 0 89012
111109 14:35:05 [Note] /usr/sbin/mysqld: Shutdown complete

111109 14:35:05 mysqld_safe mysqld from pid file /var/lib/mysql/ip-173-201-34-240.ip.secureserver.net.pid ended
------------------------

Then, I tried to open the mysql.sock file
=============
root@ip-173-201-34-240 [/]# tail /var/lib/mysql/mysql.sock
tail: cannot open `/var/lib/mysql/mysql.sock' for reading: No such file or directory
================
Then, it seems not to have the file in my system.

Do you have any idea for it?
 Thanks for your help.

Best Regards,
Soonho

-----Original Message-----
From: <email address hidden> [mailto:<email address hidden>] On Behalf Of Jeffrey Ness
Sent: Wednesday, November 09, 2011 10:11 AM
To: Kim, Soonho (IFPRI)
Subject: Re: [Question #177453]: Installing IUS package :Failed dependencies

Your question #177453 on IUS Community Project changed:
https://answers.launchpad.net/ius/+question/177453

    Status: Open => Answered

Jeffrey Ness proposed the following answer:
That is very good news.

I'm am glad everything appears to be working for you now.

Jeffrey-

--
If this answers your question, please go to the following page to let us know that it is solved:
https://answers.launchpad.net/ius/+question/177453/+confirm?answer_id=23

If you still need help, you can reply to this email or go to the following page to enter your feedback:
https://answers.launchpad.net/ius/+question/177453

You received this question notification because you asked the question.

This question was expired because it remained in the 'Open' state without activity for the last 15 days.