MySQL not installing on FC6

[cunoodle2]

Here is where I stand..

OS: FRESH install of Unix Fedora Core 6
Kernel Version: Kernel 2.6.18-1/2798.fc6 on an i686
Hardware Information: Brand new Dell SC1435 Server
Software Version: MySQl 5
Control Panel: cPanel

#yum install mysql-server && service mysqld start
Nothing to do
mysqld: unrecognized service

#rpm -qa | grep mysql
libdbi-dbd-mysql-0.8.1a-1.2.2
mysql-connector-odbc-3.51.12-2.2

#ps -ef | grep -i mysql
root 15299 15114 0 16:55 pts/0 00:00:00 grep -i mysql

I don't see the mysql.sock file. What I can do to further troubleshoot this issue?

[Seve]

Hello:
Run
yum list | grep -F mysql
and use yum to install what you need from the list
which should be from either the core or the extras repo

Seve

[cunoodle2]

That produces quite the output...

# yum list | grep -F mysql
** Message: sqlite cache needs updating, reading in metadata
** Message: sqlite cache needs updating, reading in metadata
libdbi-dbd-mysql.i386 0.8.1a-1.2.2 installed
mysql-connector-odbc.i386 3.51.12-2.2 installed
bytefx-data-mysql.i386 1.1.17.1-4.fc6 updates
compat-gda-mysql.i386 1.2.4-1.fc6 extras
dbmail-mysql.i386 2.2.4-4.fc6 extras
freeradius-mysql.i386 1.1.3-1.1 updates
gnokii-smsd-mysql.i386 0.6.14-2.fc6 extras
koffice-kexi-driver-mysql.i386 1.6.2-3.fc6.1 extras
libgda-mysql.i386 1:1.9.100-10.fc6 extras
libpreludedb-mysql.i386 0.9.11.1-2.fc6 extras
lighttpd-mod_mysql_vhost.i386 1.4.15-1.fc6 extras
mod_auth_mysql.i386 1:3.0.0-3.1 core
nagios-plugins-mysql.i386 1.4.8-1.fc6 extras
openpbx-mysql.i386 1.2-3.rc2.svn2282.fc6 extras
pam_mysql.i386 1:0.6.2-4.fc6 extras
pdns-backend-mysql.i386 2.9.21-1.fc6 extras
pyicq-t-mysql.noarch 0.8-1.fc6 extras
qt4-mysql.i386 4.2.3-7.fc6.1 extras
rekall-mysql.i386 2.4.5-5.fc6 extras
ruby-mysql.i386 2.7.1-2.fc6 extras
ser-mysql.i386 0.9.6-9.fc6 extras
showimg-mysql.i386 0.9.5-12.fc6 extras
snort-mysql.i386 2.6.1.1-4.fc6 extras
snort-mysql+flexresp.i386 2.6.1.1-4.fc6 extras
ulogd-mysql.i386 1.24-2.fc6 extras

I installed 'mod_auth_mysql.i386' as I know that one for sure is required but I'm not sure about the rest. Would it hurt to install them all or are there certain ones I should be working with?

[Seve]

Hello:

You should have a lot more mysql rpms showing up?

As root try running

yum clean all
yum clean dbcache
yum clean metadata

then run

yum list | grep -F mysql

Seve

[cunoodle2]

# yum clean all
Loading "installonlyn" plugin
Cleaning up Everything

# yum clean dbcache
Loading "installonlyn" plugin
0 cache files removed

# yum clean metadata
Loading "installonlyn" plugin
0 metadata files removed

# yum list | grep -F mysql
libdbi-dbd-mysql.i386 0.8.1a-1.2.2 installed
mysql-connector-odbc.i386 3.51.12-2.2 installed
bytefx-data-mysql.i386 1.1.17.1-4.fc6 updates
compat-gda-mysql.i386 1.2.4-1.fc6 extras
dbmail-mysql.i386 2.2.4-4.fc6 extras
freeradius-mysql.i386 1.1.3-1.1 updates
gnokii-smsd-mysql.i386 0.6.14-2.fc6 extras
koffice-kexi-driver-mysql.i386 1.6.2-3.fc6.1 extras
libgda-mysql.i386 1:1.9.100-10.fc6 extras
libpreludedb-mysql.i386 0.9.11.1-2.fc6 extras
lighttpd-mod_mysql_vhost.i386 1.4.15-1.fc6 extras
mod_auth_mysql.i386 1:3.0.0-3.1 core
nagios-plugins-mysql.i386 1.4.8-1.fc6 extras
openpbx-mysql.i386 1.2-3.rc2.svn2282.fc6 extras
pam_mysql.i386 1:0.6.2-4.fc6 extras
pdns-backend-mysql.i386 2.9.21-1.fc6 extras
pyicq-t-mysql.noarch 0.8-1.fc6 extras
qt4-mysql.i386 4.2.3-7.fc6.1 extras
rekall-mysql.i386 2.4.5-5.fc6 extras
ruby-mysql.i386 2.7.1-2.fc6 extras
ser-mysql.i386 0.9.6-9.fc6 extras
showimg-mysql.i386 0.9.5-12.fc6 extras
snort-mysql.i386 2.6.1.1-4.fc6 extras
snort-mysql+flexresp.i386 2.6.1.1-4.fc6 extras
ulogd-mysql.i386 1.24-2.fc6 extras

[Seve]

Hello:
Not sure what is wrong / different / changed with you /etc/yum.repos.d/
Here is the output from mine

PHP Code:

# yum list | grep -F mysql
mysql.i386                               5.0.27-1.fc6           installed       
bytefx-data-mysql.i386                   1.1.17.1-4.fc6         updates_f6      
compat-gda-mysql.i386                    1.2.4-1.fc6            extras_f6       
dbmail-mysql.i386                        2.2.4-4.fc6            extras_f6       
freeradius-mysql.i386                    1.1.3-1.1              updates_f6      
gnokii-smsd-mysql.i386                   0.6.14-2.fc6           extras_f6       
koffice-kexi-driver-mysql.i386           1.6.2-3.fc6.1          extras_f6       
libdbi-dbd-mysql.i386                    0.8.1a-1.2.2           fedora_core     
libgda-mysql.i386                        1:1.9.100-10.fc6       extras_f6       
libpreludedb-mysql.i386                  0.9.11.1-2.fc6         extras_f6       
lighttpd-mod_mysql_vhost.i386            1.4.15-1.fc6           extras_f6       
mod_auth_mysql.i386                      1:3.0.0-3.1            fedora_core     
mysql++.i386                             2.2.3-1.fc6.1          extras_f6       
mysql++-devel.i386                       2.2.3-1.fc6.1          extras_f6       
mysql++-manuals.i386                     2.2.3-1.fc6.1          extras_f6       
mysql-administrator.i386                 5.0r11-3.fc6           extras_f6       
mysql-bench.i386                         5.0.27-1.fc6           updates_f6      
mysql-connector-java.i386                1:3.1.12-3.fc6         extras_f6       
mysql-connector-odbc.i386                3.51.12-2.2            fedora_core     
mysql-devel.i386                         5.0.27-1.fc6           updates_f6      
mysql-gui-common.i386                    5.0r11-3.fc6           extras_f6       
mysql-gui-tools.i386                     5.0r11-3.fc6           extras_f6       
mysql-query-browser.i386                 5.0r11-3.fc6           extras_f6       
mysql-server.i386                        5.0.27-1.fc6           updates_f6      
mysql-test.i386                          5.0.27-1.fc6           updates_f6      
mysqlclient10.i386                       3.23.58-9.2.1          fedora_core     
mysqlclient10-devel.i386                 3.23.58-9.2.1          fedora_core     
mysqlclient14.i386                       4.1.14-4.2.1           fedora_core     
mysqlclient14-devel.i386                 4.1.14-4.2.1           fedora_core     
nagios-plugins-mysql.i386                1.4.8-1.fc6            extras_f6       
openpbx-mysql.i386                       1.2-3.rc2.svn2282.fc6  extras_f6       
pam_mysql.i386                           1:0.6.2-4.fc6          extras_f6       
pdns-backend-mysql.i386                  2.9.21-1.fc6           extras_f6       
perl-Class-DBI-mysql.noarch              1.00-2.fc6             extras_f6       
php-mysql.i386                           5.1.6-3.5.fc6          updates_f6      
php-pear-MDB2-Driver-mysql.noarch        1.4.1-1.fc6            extras_f6       
proftpd-mysql.i386                       1.3.0a-3.fc6           extras_f6       
pyicq-t-mysql.noarch                     0.8-1.fc6              extras_f6       
qt4-mysql.i386                           4.2.3-7.fc6.1          extras_f6       
rekall-mysql.i386                        2.4.5-5.fc6            extras_f6       
ruby-mysql.i386                          2.7.1-2.fc6            extras_f6       
ser-mysql.i386                           0.9.6-9.fc6            extras_f6       
showimg-mysql.i386                       0.9.5-12.fc6           extras_f6       
snort-mysql.i386                         2.6.1.1-4.fc6          extras_f6       
snort-mysql+flexresp.i386                2.6.1.1-4.fc6          extras_f6       
ulogd-mysql.i386                         1.24-2.fc6             extras_f6 


My repos are mirrored so, extras_f6=extras ..etc.

Seve

[cunoodle2]

Yes I'm puzzled as well. This was on a totally fresh install of FC6 on a brand new server. Here are a few things at install I did..

1. On this screen..
http://docs.fedoraproject.org/instal...kselection.png
(I selected "Software Development" and "Web Server")

2. Then on this screen...
http://images.howtoforge.com/images/...ith_fc6/15.png
(I selected "MySQL Database")

Upon completion of the O.S. install I did the wget for cpanel and installed it. Other than the apf (firewall) application I've installed nothing at all.

Does anyone have any other ideas on how to further troubleshoot this?

[cunoodle2]

UPDATE: I'm seeing the following error in '/var/log/mysqld.log'

070514 19:58:18 mysqld started
070514 19:58:18 [ERROR] Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists!

070514 19:58:18 [ERROR] Aborting

070514 19:58:18 [Note] /usr/sbin/mysqld: Shutdown complete

[barf]

Well does the user 'mysql' exsit?

Try disabling the firewall it may be blocking port 3306 (i thnk thats the right one).

Next step is read the Mysql documentation it has a good section on troubleshooting start up problems.

phpMyAdmin may of use in finding the problem. Good luck

[cunoodle2]

SOLVED: Thank you SOOO much to all that helped. Here is what I finally did..

First do this...
# grep mysql /etc/passwd

if the user is not there then add a line to that file. I did used this...
mysql:x:101:102:MySQL server:/var/lib/mysql:/sbin/nologin

Then do this...
# grep mysql /etc/group

if the user is not there then add a line to that file. I did used this...
mysql:x:102:

Then add the user...
# adduser -s /sbin/nologin -m -g mysql mysql

Then make sure you set permissions properly..
# chown mysql.mysql /var/lib
# cd /var/lib/mysql
# chown -R mysql.mysql *