Upgrade problems

[Guest seanbracken]

Hi,

 

All of the update sources seem to be installed into rpg. All of my MySQL databases are intact and I have backed them up to a CD. This is what I'm getting now when I try to install or run MySQL.

 

[root@topup sean]# urpmi mysql

The package(s) are already installed

The following package names were assumed: MySQL

[root@topup sean]# mysqld

051218 22:00:42 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

 

051218 22:00:42 [ERROR] Aborting

 

051218 22:00:42 [Note] mysqld: Shutdown complete

 

I've been at this for about 36 hours without a break and I think that I should grab some sleep before I do any more damage.

 

I really appreciate your help. I'll make a cup of coffee and come back to you in a few minutes. After that I'll hit the sack

 

Regards,

 

Sean

PS What time zone are you in?

Edited December 18, 2005 by seanbracken

[michaelcole]

I tried this at the command prompt..

 

I tried to run rpmi and when it found the lock file it told me where it was.. So i dont remember where it was but you could try that..

[ianw1974]

To start mysql, you should normally run this:

 

service mysql start

 

although it could be:

 

service mysqld start

 

depending on what it's called on the service list. You can do this to find out:

 

chkconfig --list | grep mysql

 

and it will list anything that matches mysql. Then you can check whether it's mysql or mysqld.

 

Although if it fails to start because of the service being disabled. You will have to type this:

 

chkconfig mysql on

 

and then issue the service start command. My timezone is GMT+1 as I'm in Poland :P

[Guest seanbracken]

Hi,

 

I have MySQL working now. It's not starting at boot for some reason so I have to start it manually. Another odd thing, I have to run setup.sh for Webmin after every boot. However the pressure is off now that MySQL and FreeRadius are working.

 

Thanks for all the help.

 

Regards,

 

Sean

[ianw1974]

Hi Sean,

 

Please run the following again:

 

chkconfig --list | grep mysql

 

if it says "off" to everything, this will be why it's not starting at bootup. So to get it to start at boot, type:

 

chkconfig mysql on

 

this will start it, and get you back to normal!

[ianw1974]

and do the same thing for webmin as well:

 

chkconfig webmin on