• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 516
  • Last Modified:

Cannot get Mysql work on Redhat Enterprise 4

Hi experts,

I am running Rehdat enterprise 4 linux and Mysql MySQL-server5.0.19-0
i get the following with
# mysqladmin ping
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!

and when try to start the mysql server
# /etc/init.d/mysql restart
MySQL manager or server PID file could not be found!       [FAILED]
Starting MySQLCouldn't find MySQL manager or server        [FAILED]


it looks like mysql is not running on my server
# ps -ef | grep mysql
root      4177  3931  0 16:21 pts/1    00:00:00 grep mysql

/var/lib/mysql/mysql.sock actually does not exists on my system.

i would appreciate any help on this issue

thanks

0
cakirfatih
Asked:
cakirfatih
  • 5
  • 4
1 Solution
 
m1tk4Commented:
did you remove mysql 4 before installing 5.0.19?

What was your ./configure line when you were building it?
0
 
evangineerXCommented:
Yes, more info needed.  How did you install and configure Mysql?

You might find it useful to do "locate mysql.sock" to make sure it hasn't been created in a different location from what's in your my.cnf file.  

Also, have you looked at the my.cnf file at all and made sure that it has what you need?
0
 
cakirfatihAuthor Commented:
yes i did remove mysql 4 before installing 5.0.19
i used the rpm packages from the mysql website , so i did not have to use ./configure command.

i have installed these packages from the mysql website

           MySQL-client-standard 5.0.19-0.rhel3       
           MySQL-server-standard 5.0.19-0.rhel3       
           MySQL-shared-compat 5.0.19-0.rhel3
           MySQL-shared-standard 5.0.19-0.rhel3

after this i did not make any configurations because i cannot get it worked.

also here is the copy of my.cnf file
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
     
[mysql.server]
user=mysql
basedir=/var/lib
socket=/var/lib/mysql/mysql.sock


[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
0
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 
m1tk4Commented:
I would strongly suggest you to use

mysql-5.0.18-4.el4s1.1.i386

instead of MySQL's RPM. You can get this one from RHN, it's a part of  Red Hat Web Application Stack 1.0 Beta.

0
 
cakirfatihAuthor Commented:
how should i go with a clean uninstall of the current version of Mysql and then
install the version you mention.

i don't wana do it my way, which is using webmin.
is there any other you can recomend.

thanks
0
 
m1tk4Commented:
rpm -e MySQL-client-standard MySQL-server-standard MySQL-shared-compat MySQL-shared-standard

from the command line. This will leave behind some backups of my.cnf and maybe other files, when you run this command it'll tell you something like

my.cnf.backup saved as a backup...

delete all these files manually, then you should be good to go to install the new one. If you see any other output while you are removing the RPMs, post it here.
0
 
cakirfatihAuthor Commented:
i get this message

]# rpm -e MySQL-client-standard MySQL-server-standard MySQL-share d-compat MySQL-shared-standard
error: Failed dependencies:
        libmysqlclient.so.10 is needed by (installed) MyODBC-2.50.39-21.RHEL4.1. i386
        libmysqlclient.so.14 is needed by (installed) cyrus-sasl-sql-2.1.19-5.EL 4.i386
        libmysqlclient.so.14 is needed by (installed) dovecot-0.99.11-2.EL4.1.i3 86

i also have a subscription to redhat network for tech support, i could not find the mysql-5.0.18-4.el4s1.1.i386 there
how can i get this version?
i could not find it on rpmfinder website as well

thanks
0
 
m1tk4Commented:
ok, add those rpms to the list you are removing:

rpm -e MySQL......  MyODBC cyrus-sasl-sql dovecot

If you need them you can reinstall them later once you install the new MySQL.

To get it from RHN, log in into RHN, (rhn.redhat.com), click "Channels" in the red main menu bar, one of the channels listed is named:

 Red Hat Web Application Stack 1.0 Beta (for ES v. 4 x86)

Click that,  in the small menu where it says Details - Errata - Packages click Packages, they should be on the first page.
0
 
cakirfatihAuthor Commented:
that worked,
thanks for your help
0
 
m1tk4Commented:
you're welcome, thanks for the points ;)
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now