LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 05-28-2011, 04:31 PM   #1
The Russian
Member
 
Registered: May 2011
Location: localhost
Distribution: Debian, Ubuntu, Fedora, CentOS, and anything other than KDE.
Posts: 38

Rep: Reputation: Disabled
MySQL Problem


I have a Virtual Private Server, and for some reason, something went wrong, and now mysqld refuses to start. Server info: CentOS x64

When I run this command: tail -f /var/log/mysqld.log
I get this result: 110528 16:14:12 [ERROR] /usr/libexec/mysqld: unknown option '--skip-bdb'
110528 16:14:12 [ERROR] Aborting

I have been working on this since about 6AM and it's now 2:30PM. This community has been really helpful as far as searching on Google for things, but now I need help. I don't know what to do.

It all started after I tried a few times to upgrade PHP, which was successful after a few tries, but I think one of the RPMs had MySQL in it without me knowing. GRRRRRR

When running this command: cat /var/log/mysqld.log
I get this result: http://pastebin.com/bmJkpViS

Last edited by The Russian; 05-28-2011 at 04:35 PM.
 
Old 05-28-2011, 04:44 PM   #2
hyperhead
Member
 
Registered: Mar 2011
Location: UK
Distribution: Slackware-14.2
Posts: 117

Rep: Reputation: 19
Hi

Did you uninistall the previous MySQL ?

If you query the rpm database for MySQL / PHP what do you find?

Code:
rpm -qa | grep mysql

rpm -qa | grep PHP
etc

If you still have the previous versions installed, perhaps you could uninstall the rpms you installed for the upgrade??

Just a thought.
 
1 members found this post helpful.
Old 05-28-2011, 04:47 PM   #3
The Russian
Member
 
Registered: May 2011
Location: localhost
Distribution: Debian, Ubuntu, Fedora, CentOS, and anything other than KDE.
Posts: 38

Original Poster
Rep: Reputation: Disabled
Thank you for the quick reply! I did uninstall the upgrade RPMs, then tried to install MySQL by itself, it installed, but same problem.

BTW, I don't think PHP is the problem, just thought that would be worth mentioning.

Running rpm -qa | grep mysql gave me this below:

mysqlclient15-5.0.90-1.el5.art
mysql-server-5.1.57-1.el5.art
mysql-libs-5.1.57-1.el5.art
mysql-server-5.1.57-1.el5.art
ruby-mysql-2.7-200705221357
mysql-libs-5.1.57-1.el5.art
mysql-5.1.57-1.el5.art
mysql-connector-odbc-3.51.26r1127-1.el5
libdbi-dbd-mysql-0.8.1a-1.2.2
php-mysql-5.3.6-3.el5.art
mysql-5.1.57-1.el5.art
 
Old 05-28-2011, 04:51 PM   #4
Noway2
Senior Member
 
Registered: Jul 2007
Distribution: Gentoo
Posts: 2,125

Rep: Reputation: 781Reputation: 781Reputation: 781Reputation: 781Reputation: 781Reputation: 781Reputation: 781
Edit: it looks like I was responding at the same time, with similar questions:

Quote:
I tried a few times to upgrade PHP, which was successful after a few tries, but I think one of the RPMs had MySQL in it without me knowing.
It looks to me like you have at least an error, but more likely an incompatible version type conflict. The log file is saying that you have an unknown option and you are getting lots of warnings about deprecated commands. I agree that something getting partially installed, probably at a different rev level, is a distinct possibility.

Have you tried uninstalling and then re-installing or even reconfiguring the MySQL package? I would also take a look at any MySQL-PHP, or myadmin type packages that could have a dependency.

You say you were successful upgrading your PHP, after a few tries. What do you mean by after a few tries, what happened that caused you to have to attempt it multiple times? Were you getting a particular error message that might be a clue to the current situation?
 
1 members found this post helpful.
Old 05-28-2011, 04:55 PM   #5
The Russian
Member
 
Registered: May 2011
Location: localhost
Distribution: Debian, Ubuntu, Fedora, CentOS, and anything other than KDE.
Posts: 38

Original Poster
Rep: Reputation: Disabled
Quote:
Originally Posted by Noway2 View Post
Edit: it looks like I was responding at the same time, with similar questions:


It looks to me like you have at least an error, but more likely an incompatible version type conflict. The log file is saying that you have an unknown option and you are getting lots of warnings about deprecated commands. I agree that something getting partially installed, probably at a different rev level, is a distinct possibility.

Have you tried uninstalling and then re-installing or even reconfiguring the MySQL package? I would also take a look at any MySQL-PHP, or myadmin type packages that could have a dependency.

You say you were successful upgrading your PHP, after a few tries. What do you mean by after a few tries, what happened that caused you to have to attempt it multiple times? Were you getting a particular error message that might be a clue to the current situation?
I did try to reinstall the MySQL package, but still the same problem.

PHP: I didn't know how to upgrade PHP via SSH, so I tried a few different commands that I found on various websites, some didn't work, the last one did work.
 
Old 05-28-2011, 05:32 PM   #6
hyperhead
Member
 
Registered: Mar 2011
Location: UK
Distribution: Slackware-14.2
Posts: 117

Rep: Reputation: 19
Can we see those command(s) for upgrading PHP?
 
Old 05-28-2011, 05:37 PM   #7
The Russian
Member
 
Registered: May 2011
Location: localhost
Distribution: Debian, Ubuntu, Fedora, CentOS, and anything other than KDE.
Posts: 38

Original Poster
Rep: Reputation: Disabled
Quote:
Originally Posted by hyperhead View Post
Can we see those command(s) for upgrading PHP?
Uhhhh, I can try, but do you know how many commands I ran in 7 hours?


Here's some I believe. Thank GOODNESS I bookmarked the tutorials.

https://community.openatrium.com/doc...n-en/node/2018

http://www.hosting.com/support/linux...a-linux-server
 
Old 05-28-2011, 06:53 PM   #8
hyperhead
Member
 
Registered: Mar 2011
Location: UK
Distribution: Slackware-14.2
Posts: 117

Rep: Reputation: 19
Ok so you have used third party repositories? Or CentOS repositories?

What is the output of :

Code:
ls /etc/yum.repos.d/
You can also review your commands via history

(Don't dump that in pastebin though)

Last edited by hyperhead; 05-28-2011 at 06:56 PM.
 
Old 05-28-2011, 06:55 PM   #9
The Russian
Member
 
Registered: May 2011
Location: localhost
Distribution: Debian, Ubuntu, Fedora, CentOS, and anything other than KDE.
Posts: 38

Original Poster
Rep: Reputation: Disabled
Quote:
Originally Posted by hyperhead View Post
Ok so you have used third party repositories? Or CentOS repositories?

What is the output of :

Code:
ls /etc/yum.repos.d/
I guess so. I think it was the only way to upgrade PHP. Should I remove atomic and webtatic?

atomic.repo CentOS-Debuginfo.repo CentOS-Vault.repo
CentOS-Base.repo CentOS-Media.repo webtatic.repo
CentOS-Base.repo.rpmnew CentOS-Testing.rep
 
Old 05-28-2011, 06:59 PM   #10
The Russian
Member
 
Registered: May 2011
Location: localhost
Distribution: Debian, Ubuntu, Fedora, CentOS, and anything other than KDE.
Posts: 38

Original Poster
Rep: Reputation: Disabled
OH and I also ran this command:

yum groupinstall "MySQL Database"
 
Old 05-28-2011, 07:02 PM   #11
hyperhead
Member
 
Registered: Mar 2011
Location: UK
Distribution: Slackware-14.2
Posts: 117

Rep: Reputation: 19
From the look of the RPMs you queried earlier you have Atomic Rocket Turtles RPMS hence the art in the package name(s)

Code:
mysql-5.1.57-1.el5.art
The next thing I would try is to restore the versions originally on the distribution, so thats the default packages that came with your version of CentOS.

Replace each version of rpm with .art in it with original.

It might work, its what I would try next, if I was in your position.
 
1 members found this post helpful.
Old 05-28-2011, 07:04 PM   #12
The Russian
Member
 
Registered: May 2011
Location: localhost
Distribution: Debian, Ubuntu, Fedora, CentOS, and anything other than KDE.
Posts: 38

Original Poster
Rep: Reputation: Disabled
Quote:
Originally Posted by hyperhead View Post
From the look of the RPMs you queried earlier you have Atomic Rocket Turtles RPMS hence the art in the package name(s)

Code:
mysql-5.1.57-1.el5.art
The next thing I would try is to restore the versions originally on the distribution, so thats the default packages that came with your version of CentOS.

Replace each version of rpm with .art in it with original.

It might work, its what I would try next, if I was in your position.
How do I do this?
 
Old 05-28-2011, 07:19 PM   #13
The Russian
Member
 
Registered: May 2011
Location: localhost
Distribution: Debian, Ubuntu, Fedora, CentOS, and anything other than KDE.
Posts: 38

Original Poster
Rep: Reputation: Disabled
I have to reimage my server !
 
Old 05-28-2011, 07:25 PM   #14
The Russian
Member
 
Registered: May 2011
Location: localhost
Distribution: Debian, Ubuntu, Fedora, CentOS, and anything other than KDE.
Posts: 38

Original Poster
Rep: Reputation: Disabled
Okay, basically, I jacked up Plesk control panel by trying to remove mysql which removed some Plesk dependencies. So now I am required to do a reimage of my server. Then this mysql error wont happen anymore.

Thanks for the help guys!

/thread
 
Old 05-28-2011, 07:48 PM   #15
hyperhead
Member
 
Registered: Mar 2011
Location: UK
Distribution: Slackware-14.2
Posts: 117

Rep: Reputation: 19
Sorry it didn't work out.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
postfix +Cyrus SASL authentication problem + pam-mysql+mysql database kibirango Slackware 1 12-25-2012 08:47 AM
Problem changing mysql uid,gid: mysql start fails gjatute Linux - Newbie 7 02-25-2010 01:38 AM
Bugzilla - MySQL - perl - DBD::mysql install problem amchargue Linux - Software 3 09-10-2008 12:01 AM
Problem Starting MySQL on Fresh Fedora 8 Install w/ Yum'd MySQL blong4life Linux - Server 2 07-04-2008 07:44 PM
php-mysql dependancy problem after nitemare mysql upgrade. RHEL4 andrewc Red Hat 1 01-03-2006 04:16 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 05:45 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration