Ed Morrison edward.morrison@gmail.com wrote:
mouss wrote:
anything in /var/log/mysqld.log?
nothing:
[root@ftp ~]# cat /var/log/mysqld.log
[root@ftp ~]#
Speaking of mysqld.log, check the ownership and permissions. I vaguely remember chasing a similar problem only to find out that it was being caused by the log file not having the right permissions and ownership. For mysqld.log the should be:
-rw-r----- 1 mysql mysql 249 Jan 18 16:50 mysqld.log
It also looks like you have multiple versions of mysqlclient plus the mysql rpm (which is the standard client):
[root@ftp ~]# rpm -qa mysql*
mysqlclient14-4.1.22-1.el4s1.1 <--First client mysqlclient10-devel-3.23.58-9.2.c4 mysql-5.0.54-1.el4.centos <-- The centos client mysqlclient10-3.23.58-4.RHEL4.1 <-- Another one mysql-server-5.0.54-1.el4.centos mysqlclient10-3.23.58-9.2.c4 <-- and still another mysql-libs-5.0.54-1.el4.centos
which could explain why installing the server didn't work. You should only have:
# rpm -qa | grep mysql mysql-5.0.22-2.2.el5_1.1 php-mysql-5.1.6-15.el5 mysql-devel-5.0.22-2.2.el5_1.1 mysql-server-5.0.22-2.2.el5_1.1
Cheers, Dave
David G. Miller wrote:
which could explain why installing the server didn't work. You should only have:
# rpm -qa | grep mysql mysql-5.0.22-2.2.el5_1.1 php-mysql-5.1.6-15.el5 mysql-devel-5.0.22-2.2.el5_1.1 mysql-server-5.0.22-2.2.el5_1.1
Mysqld.log appears to be fine:
[root@ftp ~]# ls -al /var/log/mysqld.log -rw-r----- 1 mysql mysql 1025 Feb 15 07:53 /var/log/mysqld.log [root@ftp ~]#
Interestingly enough, when I remove all mysql components via and reinstall the basic components you have listed, yum add mysqlclient as a dependency:
[root@ftp ~]# yum -y install mysql mysql-server mysql-devel php-mysql Setting up Install Process Setting up repositories dag 100% |=========================| 1.1 kB 00:00 update 100% |=========================| 951 B 00:00 base 100% |=========================| 1.1 kB 00:00 centosplus 100% |=========================| 951 B 00:00 addons 100% |=========================| 951 B 00:00 extras 100% |=========================| 1.1 kB 00:00 Reading repository metadata in from local files primary.xml.gz 100% |=========================| 1.8 MB 00:03 dag : ################################################## 8091/8091 primary.xml.gz 100% |=========================| 83 kB 00:01 update : ################################################## 274/274 primary.xml.gz 100% |=========================| 548 kB 00:01 base : ################################################## 1788/1788 primary.xml.gz 100% |=========================| 70 kB 00:00 centosplus: ################################################## 217/217 primary.xml.gz 100% |=========================| 157 B 00:00 primary.xml.gz 100% |=========================| 38 kB 00:00 extras : ################################################## 148/148 Excluding Packages from CentOS-4 - Updates Finished Excluding Packages from CentOS-4 - Base Finished Reducing CentOS-4 - Plus to included packages only Finished Excluding Packages from CentOS-4 - Addons Finished Excluding Packages from CentOS-4 - Extras Finished Parsing package install arguments Resolving Dependencies --> Populating transaction set with selected packages. Please wait. ---> Downloading header for mysql-server to pack into transaction set. mysql-server-5.0.54-1.el4 100% |=========================| 38 kB 00:00 ---> Package mysql-server.x86_64 0:5.0.54-1.el4.centos set to be updated ---> Downloading header for mysql-devel to pack into transaction set. mysql-devel-5.0.54-1.el4. 100% |=========================| 34 kB 00:00 ---> Package mysql-devel.x86_64 0:5.0.54-1.el4.centos set to be updated ---> Downloading header for mysql to pack into transaction set. mysql-5.0.54-1.el4.centos 100% |=========================| 30 kB 00:00 ---> Package mysql.x86_64 0:5.0.54-1.el4.centos set to be updated ---> Downloading header for php-mysql to pack into transaction set. php-mysql-5.1.6-3.el4s1.8 100% |=========================| 17 kB 00:00 ---> Package php-mysql.x86_64 0:5.1.6-3.el4s1.8 set to be updated --> Running transaction check --> Processing Dependency: libmysqlclient.so.15()(64bit) for package: mysql --> Processing Dependency: libmysqlclient.so.15()(64bit) for package: php-mysql --> Processing Dependency: perl-DBD-MySQL for package: mysql-server --> Processing Dependency: libmysqlclient.so.15()(64bit) for package: mysql-server --> Processing Dependency: libmysqlclient_r.so.15(libmysqlclient_15)(64bit) for package: mysql-server --> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15)(64bit) for package: mysql-server --> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15)(64bit) for package: php-mysql --> Processing Dependency: libmysqlclient_r.so.15()(64bit) for package: mysql-server --> Processing Dependency: mysql-libs = 5.0.54-1.el4.centos for package: mysql --> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15)(64bit) for package: mysql --> Restarting Dependency Resolution with new changes. --> Populating transaction set with selected packages. Please wait. ---> Downloading header for perl-DBD-MySQL to pack into transaction set. perl-DBD-MySQL-2.9004-3.1 100% |=========================| 5.5 kB 00:00 ---> Package perl-DBD-MySQL.x86_64 0:2.9004-3.1.centos4 set to be updated ---> Downloading header for mysql-libs to pack into transaction set. mysql-libs-5.0.54-1.el4.c 100% |=========================| 35 kB 00:00 ---> Package mysql-libs.x86_64 0:5.0.54-1.el4.centos set to be updated --> Running transaction check --> Processing Dependency: libmysqlclient.so.14()(64bit) for package: perl-DBD-MySQL --> Restarting Dependency Resolution with new changes. --> Populating transaction set with selected packages. Please wait. ---> Downloading header for mysqlclient14 to pack into transaction set. mysqlclient14-4.1.22-1.el 100% |=========================| 4.8 kB 00:00 ---> Package mysqlclient14.x86_64 0:4.1.22-1.el4s1.1 set to be updated --> Running transaction check
Dependencies Resolved
============================================================================= Package Arch Version Repository Size ============================================================================= Installing: mysql x86_64 5.0.54-1.el4.centos centosplus 2.9 M mysql-devel x86_64 5.0.54-1.el4.centos centosplus 2.9 M mysql-server x86_64 5.0.54-1.el4.centos centosplus 10 M php-mysql x86_64 5.1.6-3.el4s1.8 centosplus 85 k Installing for dependencies: mysql-libs x86_64 5.0.54-1.el4.centos centosplus 1.8 M mysqlclient14 x86_64 4.1.22-1.el4s1.1 centosplus 1.2 M perl-DBD-MySQL x86_64 2.9004-3.1.centos4 base 112 k
Transaction Summary ============================================================================= Install 7 Package(s) Update 0 Package(s) Remove 0 Package(s) Total download size: 19 M Downloading Packages: (1/7): perl-DBD-MySQL-2.9 100% |=========================| 112 kB 00:00 (2/7): php-mysql-5.1.6-3. 100% |=========================| 85 kB 00:00 (3/7): mysql-libs-5.0.54- 100% |=========================| 1.8 MB 00:00 (4/7): mysql-server-5.0.5 100% |=========================| 10 MB 00:03 (5/7): mysql-devel-5.0.54 100% |=========================| 2.9 MB 00:01 (6/7): mysql-5.0.54-1.el4 100% |=========================| 2.9 MB 00:01 (7/7): mysqlclient14-4.1. 100% |=========================| 1.2 MB 00:00 Running Transaction Test Finished Transaction Test Transaction Test Succeeded Running Transaction Installing: mysql-libs ######################### [1/7] Installing: mysql ######################### [2/7] Installing: mysqlclient14 ######################### [3/7] Installing: php-mysql ######################### [4/7] Installing: perl-DBD-MySQL ######################### [5/7] Installing: mysql-server ######################### [6/7] Installing: mysql-devel ######################### [7/7]
Installed: mysql.x86_64 0:5.0.54-1.el4.centos mysql-devel.x86_64 0:5.0.54-1.el4.centos mysql-server.x86_64 0:5.0.54-1.el4.centos php-mysql.x86_64 0:5.1.6-3.el4s1.8 Dependency Installed: mysql-libs.x86_64 0:5.0.54-1.el4.centos mysqlclient14.x86_64 0:4.1.22-1.el4s1.1 perl-DBD-MySQL.x86_64 0:2.9004-3.1.centos4 Complete!
[root@ftp ~]# service mysqld start Timeout error occurred trying to start MySQL Daemon. Starting MySQL: [FAILED] [root@ftp ~]#
-
David G. Miller -
Ed Morrison