The Planet Forums > Problem starting MySQL

The Planet Forums > System Administration > Web Hosting

OllieMaitland

Feb 25 2006, 03:01 PM

I have got a new RHEL box which I'm trying to get up and running with RPMS, I used the most recent MySQL RPMS from http://rpmfind.net:

CODE

[root@ws-http01 ~]# rpm -qa|grep mysql

mysql-4.1.12-3.RHEL4.1

mysql-5.0.18-2.1

mysql-devel-5.0.18-2.1

php-mysql-5.1.2-4.3

mysql-server-5.0.18-2.1

If I run the following:

CODE

[root@ws-http01 ~]# su - mysql

-bash-3.00$

/usr/bin/mysqld_safe

--defaults-file=/etc/my.cnf

--pid-file=/var/run/mysqld/mysqld.pid

--log-error=/var/log/mysqld.log

> /dev/null 2>&1 &

[1] 14858

-bash-3.00$ su - root

Password:

[root@ws-http01 ~]# ps fax|grep mysqld

14858 pts/0 S 0:00 _ /bin/sh /usr/bin/mysqld_safe --defaults-file=/etc/my.cnf --pid-file=/var/run/mysqld/mysqld.pid --log-error=/var/log/mysqld.log

14887 pts/0 Sl 0:00 | _ /usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usr --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --socket=/var/lib/mysql/mysql.sock

The problem is that when I use the init.d script the .sock file does not get created...if i have a look at the /var/log/messages file i get this:

CODE

Feb 25 15:57:15 ws-http01 kernel: audit(1140901035.025:915): avc: denied { read write } for pid=15110 comm="mysqld" name="ibdata1" dev=cciss/c0d0p1 ino=2306024 scontext=root:system_r:mysqld_t tcontext=root:object_r:var_lib_t tclass=file

CODE

[root@ws-http01 ~]# ls -l /var/lib/|grep mysql

drwxr-xr-x 4 mysql mysql 4096 Feb 25 20:57 mysql

I've been battling with this for a while...any one got any ideas?

OllieMaitland

Feb 25 2006, 05:30 PM

I managed to solve this by removing all the MySQL RPMS, directories and rebooting then reinstalling the RPMS.

Seems to work now

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.