LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Red Hat
User Name
Password
Red Hat This forum is for the discussion of Red Hat Linux.

Notices


Reply
  Search this Thread
Old 03-04-2004, 09:39 AM   #1
ScooterB
Member
 
Registered: Sep 2003
Location: NW Arkansas
Distribution: Linux Redhat 9.0, Fedora Core 2,Debian 3.0, Win 2K, Win95, Win98, WinXp Pro
Posts: 344

Rep: Reputation: 31
Unhappy MySQL Install/Running Problem


Howdy guys & gals. I did a search on all forums for my problem. There are 394 threads on 16 pages for mysql. I did find several folks with the same problem but they had no answers or else they just gave up. I don't have that option. Now to my problem. I am attempting to install Snort as IDS. The instructions from the snort website address installing on RH9. So I downloaded and printed those instructions. I had done a complete install when I installed RH9 so many of the items listed were already there. But, I did not realize at the time that RH9 came with mysql as part of the install. I had downloaded and followed with their instructions on installing mysql. Now I think I may have corrupted what I didn't know I had. My question now is this: Do I need to totally remove anything that has to do with mysql and start fresh? If so, how do I go about doing that? My current issue is the old "can't connect to /tmp/mysql.sock" error. I have searched many forums and most answers reply that it has to do with permissions. I have tried following many of those to fix the problem but still get the same answer. When I try and do the old "/usr/local/mysql/bin/mysql user=mysql &" it starts, runs for about five seconds and then stops. I look in the logs and it goes back to the mysql.sock issue. Can anyone give me any incite on how to fix this issue and how I should proceed from here? Much thanks in advance for any help given.
 
Old 03-07-2004, 02:32 PM   #2
hob
Senior Member
 
Registered: Mar 2004
Location: Wales, UK
Distribution: Debian, Ubuntu
Posts: 1,075

Rep: Reputation: 45
It sounds like a copy of mysql is already running...

The first thing I'd do is confirm this by typing this in a terminal:

netstat -tl

It will list all the servers running.

Did you compile MySQL from source ? if so the rpm database might be a little out of sync with your system, and it would probably be a good idea to uninstall all the mysql bits and set it up again, rather than risk having problems with your IDS database later.
 
Old 03-08-2004, 07:00 AM   #3
ScooterB
Member
 
Registered: Sep 2003
Location: NW Arkansas
Distribution: Linux Redhat 9.0, Fedora Core 2,Debian 3.0, Win 2K, Win95, Win98, WinXp Pro
Posts: 344

Original Poster
Rep: Reputation: 31
Many thanks hob! I believe that you were correct in that it was available to run, but not actually running yet. I had posted a request for assistance in mysql.com's website and they quickly responded. One of their guys has been working with me to fix the problem. I will keep posting here as things develop to possibly help someone else in the future. So far there has been a permission problem with the data directory. We changed that to let user "mysql" have ownership and low and behold, I could start the daemon and it actually ran. I could verify this by doing a ps -ef | grep mysql and it returned various lines (this it had never done before). So that was a major break through. Now we are working on getting the signing in to work correctly. I will repost to this thread when we get past that. Thanks for everyone's help!
 
Old 03-09-2004, 07:18 AM   #4
ScooterB
Member
 
Registered: Sep 2003
Location: NW Arkansas
Distribution: Linux Redhat 9.0, Fedora Core 2,Debian 3.0, Win 2K, Win95, Win98, WinXp Pro
Posts: 344

Original Poster
Rep: Reputation: 31
To bring everyone who cares up to speed, my sole problem was with file permissions. I had to change the file permissions on the data directory to user "mysql" and restart. Lo and behold everything ran perfectly. So if you are having this problem check that all of your file permissions are correct. I would also like to commend mysql.com on their tech support. I have been working with automation and computers for about 26 years and their tech support has been the best by far. I'm not saying this to make everybody rush over there and clobber them with tech support requests; just saying it to once again prove that the open source community is the greatest and has me won over lock, stock and barrel.
 
  


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
Bugzilla - MySQL - perl - DBD::mysql install problem Runningonair Linux - Software 8 10-12-2007 12:42 AM
Mysql Administrator install/running error KunoNoOni Slackware 2 05-24-2005 11:11 AM
Mysql problem, not running? Danielallan Slackware 4 12-08-2003 08:10 AM
MySQL mysql-3.23.56-1.9, rpm install problem jacsmith510 Linux - Newbie 3 09-19-2003 02:02 PM
problem running mysql jumper Linux - Software 0 11-16-2001 10:00 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Red Hat

All times are GMT -5. The time now is 03:04 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