LinuxQuestions.org
View the Most Wanted LQ Wiki articles.
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 01-29-2010, 06:37 PM   #1
ineloquucius
LQ Newbie
 
Registered: Jan 2010
Posts: 14

Rep: Reputation: 0
MySQL won't start, and no /etc/init.d/mysql--my stdout and syslog after trying...


On Ubuntu Server 9.10, new install, mysql-server will not install properly. It produces no error on apt-get install. I get the following when running "mysqld" as root:

Code:
100129 19:08:42 [Note] Plugin 'FEDERATED' is disabled.
100129 19:08:43  InnoDB: Started; log sequence number 0 44233
100129 19:08:43 [ERROR] Can't start server : Bind on unix socket: No such file or directory
100129 19:08:43 [ERROR] Do you already have another mysqld server running on socket: /var/run/mysqld/mysqld.sock ?
100129 19:08:43 [ERROR] Aborting

100129 19:08:43  InnoDB: Starting shutdown...
100129 19:08:44  InnoDB: Shutdown completed; log sequence number 0 44233
100129 19:08:44 [Warning] Forcing shutdown of 1 plugins
100129 19:08:44 [Note] mysqld: Shutdown complete

The last syslog message after:
Code:
Jan 29 19:33:46 atlas kernel: [10896.208070] type=1503 audit(1264811626.581:22): operation="open" pid=2160 parent=2142 profile="/usr/sbin/my
sqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"

Any help is appreciated.

Last edited by ineloquucius; 01-29-2010 at 06:38 PM.
 
Old 01-30-2010, 07:46 AM   #2
evo2
Guru
 
Registered: Jan 2009
Location: Japan
Distribution: Debian, SL
Posts: 5,318

Rep: Reputation: 1142Reputation: 1142Reputation: 1142Reputation: 1142Reputation: 1142Reputation: 1142Reputation: 1142Reputation: 1142Reputation: 1142
What files are in /var/run/mysqld/?

Evo2.
 
Old 01-30-2010, 08:05 AM   #3
kbp
Senior Member
 
Registered: Aug 2009
Posts: 3,758

Rep: Reputation: 643Reputation: 643Reputation: 643Reputation: 643Reputation: 643Reputation: 643
Do you have selinux enabled ? If so, can you disable it temporarily to see it the issue is related

cheers
 
Old 01-30-2010, 09:19 AM   #4
prasanta
Member
 
Registered: Mar 2005
Location: India
Distribution: Debian
Posts: 368

Rep: Reputation: 37
I don't think `selinux` is installed by default in Ubuntu. Just do a `ps aux | grep mysql` and check if it is already running. Kill the processes and then try starting it. After installing `mysql` via `apt`, it gets started automatically.

--
Prasanta
 
Old 01-30-2010, 10:01 AM   #5
ineloquucius
LQ Newbie
 
Registered: Jan 2010
Posts: 14

Original Poster
Rep: Reputation: 0
Thanks all for the replies.

Oddly, there is no mysqld/ directory in said location. This confuses me as well. There is also no instance of mysqld running. It looks, in fact, very much as if it were never installed--since there is also no mysql startup script in init.d--except that the mysqld executable obviously exists (per the output shown in the OP).

Also, I've looked into many howto's on installing mysql on Ubu-srv 9.10, and all were business as usual, so I'm led to believe that there are no selinux-like issues, but have been wondering the same thing (about port/service blocking).

<grumble onread=ignore>What I find so frustrating about this sort of thing is what I find frustrating about a great many things Linux--I haven't the faintest notion where to begin looking. Often, simply tailing the syslog leaves me no clues, and if a log file (or error log file, or...) even exists for the application, I'm left with the same. In this case, I've spent hours googling and poring over the documentation, troubleshooting, etc., and...ah, nevermind me...</grumble>

Last edited by ineloquucius; 01-30-2010 at 10:03 AM.
 
Old 01-30-2010, 10:15 AM   #6
prasanta
Member
 
Registered: Mar 2005
Location: India
Distribution: Debian
Posts: 368

Rep: Reputation: 37
Then just install mysql server via apt. You will have the mysql(not mysqld) directory in /var/lib. You can start mysql by `sudo /etc/init.d/mysql start` .

--
Prasanta
 
Old 01-30-2010, 06:28 PM   #7
ineloquucius
LQ Newbie
 
Registered: Jan 2010
Posts: 14

Original Poster
Rep: Reputation: 0
That's what I'm saying: I did use apt-get, and I didn't have a mysql script in init.d
 
Old 01-30-2010, 11:09 PM   #8
evo2
Guru
 
Registered: Jan 2009
Location: Japan
Distribution: Debian, SL
Posts: 5,318

Rep: Reputation: 1142Reputation: 1142Reputation: 1142Reputation: 1142Reputation: 1142Reputation: 1142Reputation: 1142Reputation: 1142Reputation: 1142
Is it really installed properly? What is the output of:
Code:
dpkg -l  '*mysql*'
dpkg --audit
What happens if you do the following?
Code:
apt-get remove --purge mysql-sever5.0
apt-get install mysql-server5.0
(I'm just guessing the exact package name)

Evo2?
 
Old 01-31-2010, 11:24 AM   #9
prasanta
Member
 
Registered: Mar 2005
Location: India
Distribution: Debian
Posts: 368

Rep: Reputation: 37
mysql-server-5.0

--
Prasanta
 
  


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
Fedora 9:No mysql.sock file found. Cannot start mysql smilingbuddha Linux - Software 3 03-21-2009 03:06 AM
I have RHEL 5.0 and MySQL start problem, my MySQL server doesn't start rsatya Linux - Enterprise 4 02-03-2009 12:04 PM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. SpellChainz Linux - Newbie 1 06-23-2007 03:35 PM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 08:44 AM


All times are GMT -5. The time now is 07:29 PM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration