LinuxQuestions.org
Register a domain and help support LQ
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 11-10-2003, 07:14 PM   #1
emetib
Member
 
Registered: Feb 2003
Posts: 482

Rep: Reputation: 33
mysql.sock: missing won't start


ok, i'm really starting to get frustrated with this. (great opening line, ha?)

this is my dilemma, i don't have a /var/lib/mysql/mysql.sock. i don't know if mysql will create on on it's own or not. yet when ever i try and start the thing up, it doesn't make that file.

mdk 9.1
mysql 4.0.11a-5.1mdk

i'll see if i can get all of the error messages for you here, if you need any others please ask.

first, trying to check the version.
cerberus/home/chad $ mysqladmin -h cerberus.cc version
mysqladmin: connect to server at 'cerberus.cc' failed
error: 'Can't connect to MySQL server on 'cerberus.cc' (110)'
Check that mysqld is running on cerberus.cc and that the port is 3306.
You can check this by doing 'telnet cerberus.cc 3306'

ok, now to see is the port is open.
telnet cerberus.cc 3306
Trying 65.103.35.246...
telnet: Unable to connect to remote host: Connection timed out

now to see if the port is open in the firewall.
Starting nmap V. 3.00 ( www.insecure.org/nmap/ )
Interesting ports on (10.0.0.3):
(The 1588 ports scanned but not shown below are in state: filtered)
Port State Service
3306/tcp closed mysql
i don't know how to keep this thing open, if that is my problem, that would be an easy answer. oh, shorewall is the firewall. i had to scan from inside my network to get any thing here.

starting the server
17:48:43
cerberus/home/chad # /etc/init.d/mysql start
Starting MySQL Server [ OK ]
17:48:45
cerberus/home/chad # /etc/init.d/mysql status
mysqld is stopped
as you can see by the times, it's shutting down right away

i'm not sure if anything else is needed. i've gone through the manual, clicking on everything that could be relavent, yet to no avail. i've looked through 10 pages of google. i don't think that i'm entering the wrong search criteria, but if someone has a suggestion, i will give it a shot.

thanks.
 
Old 11-10-2003, 07:49 PM   #2
mcleodnine
Senior Member
 
Registered: May 2001
Location: Left Coast - Canada
Distribution: s l a c k w a r e
Posts: 2,731

Rep: Reputation: 45
You'll need to initialze your setup with the mysql setup scripts (usually path/to/install/scripts, it's in /usr/bin/mysql_install_db on my slack rig). This sets up the base permissions tables. You'll need to set some passwords as well. It's in the MySQL documentation and is required reading if you want to admin a mysql db.
 
Old 11-10-2003, 10:22 PM   #3
emetib
Member
 
Registered: Feb 2003
Posts: 482

Original Poster
Rep: Reputation: 33
i did all of the mysql_install, mysql_install_db, and it's still not coming up as running. it's all ways asking for the mysql.sock file and the hostname.err file. i have the hostname.err file, but no .sock file.

i've been fighting with this for over a week. maybe i should just stick with the postgresql. that's functioning as is, i just have to tweak it some for the apps that i want to use it with.

thank you though. i appreciate your time.
 
Old 11-11-2003, 01:05 AM   #4
Cerbere
Member
 
Registered: Dec 2002
Location: California
Distribution: Slackware & LFS
Posts: 799

Rep: Reputation: 33
Doesn't anyone use the search feature of this forum?

The cause of this problem is usually running mysql_install_db as root. the correct way is to su to user mysql first, then run mysql_install_db. Try doing the following:

chown -R mysql.mysql /var/lib/mysql

If that doesn't work, then try searching for keywords like 'mysql', 'sock', etc.

Enjoy!
--- Cerbere
 
  


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
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock welery Linux - Software 19 03-06-2014 08:19 AM
Problems with MySQL on SuSE: Can't Connect (/var/lib/mysql/mysql.sock) neocookie Linux - Software 8 02-08-2008 12:48 AM
mysql.sock missing? bai_design Slackware 4 10-15-2003 10:11 AM
mysql.sock file missing cheng Linux - Software 4 08-28-2002 11:42 PM
mysql.sock missing niehls Linux - Software 1 06-13-2002 06:18 PM


All times are GMT -5. The time now is 06:49 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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration