the mystery of the missing mysql.sock file
Take one perfectly functional production server running 5.0.77. It has been up and running under load for quite some time. I am using xtrabackup for backups and suddenly three or four days ago backup stop running. Investigation shows that the socket file '/tmp/mysql.sock' is no longer there. The mysql server itself is still functioning .. you can specify --host=localhost instead of --socket=/tmp/mysql.sock so the mysql client uses tcp/ip instead of the socket file to connect to the server. - Permissions did not change on the /tmp directory..I checked. - There are no errors in the .err log. - No cron jobs clearing out /tmp. - SHOW VARIABLES LIKE '%sock%' displays the proper socket location Any thoughts? I have seen this type of thing occasionally before, but never taken the time to really investigate. I would just restart the server. I will end up having to do so in this case, but I would really like to find out WHY this happened. Is this is bug in the server code? I can't come up with any other explanation. I would love for this to be explainable! thanks, keith -- Chief Training Officer Paragon Consulting Services 850-637-3877
Re: the mystery of the missing mysql.sock file
Presumably someone deleted it :-) You can try an 'lsof -U |grep mysql' to see if any processes still have it open. If the mysqld process still has it open, it's probably not the server. Why do you keep it in /tmp, btw ? My guess would be that someone (or some process) decided it was time to clean /tmp out. On Tue, Dec 15, 2009 at 4:46 PM, Keith Murphy bmur...@paragon-cs.comwrote: Take one perfectly functional production server running 5.0.77. It has been up and running under load for quite some time. I am using xtrabackup for backups and suddenly three or four days ago backup stop running. Investigation shows that the socket file '/tmp/mysql.sock' is no longer there. The mysql server itself is still functioning .. you can specify --host=localhost instead of --socket=/tmp/mysql.sock so the mysql client uses tcp/ip instead of the socket file to connect to the server. - Permissions did not change on the /tmp directory..I checked. - There are no errors in the .err log. - No cron jobs clearing out /tmp. - SHOW VARIABLES LIKE '%sock%' displays the proper socket location Any thoughts? I have seen this type of thing occasionally before, but never taken the time to really investigate. I would just restart the server. I will end up having to do so in this case, but I would really like to find out WHY this happened. Is this is bug in the server code? I can't come up with any other explanation. I would love for this to be explainable! thanks, keith -- Chief Training Officer Paragon Consulting Services 850-637-3877
Re: the mystery of the missing mysql.sock file
Thanks Johan. Yes, it shows the mysqld holding it open. Not suprising really I guess. I did check the cron jobs and the history file searching for something/someone who deleted it, but didn't find anything. Still, that is what it looks like happend. I will move the sock file to /var/run/mysql so it is out of the way. thanks, keith On Tue, Dec 15, 2009 at 11:00 AM, Johan De Meersman vegiv...@tuxera.bewrote: Presumably someone deleted it :-) You can try an 'lsof -U |grep mysql' to see if any processes still have it open. If the mysqld process still has it open, it's probably not the server. Why do you keep it in /tmp, btw ? My guess would be that someone (or some process) decided it was time to clean /tmp out. On Tue, Dec 15, 2009 at 4:46 PM, Keith Murphy bmur...@paragon-cs.comwrote: Take one perfectly functional production server running 5.0.77. It has been up and running under load for quite some time. I am using xtrabackup for backups and suddenly three or four days ago backup stop running. Investigation shows that the socket file '/tmp/mysql.sock' is no longer there. The mysql server itself is still functioning .. you can specify --host=localhost instead of --socket=/tmp/mysql.sock so the mysql client uses tcp/ip instead of the socket file to connect to the server. - Permissions did not change on the /tmp directory..I checked. - There are no errors in the .err log. - No cron jobs clearing out /tmp. - SHOW VARIABLES LIKE '%sock%' displays the proper socket location Any thoughts? I have seen this type of thing occasionally before, but never taken the time to really investigate. I would just restart the server. I will end up having to do so in this case, but I would really like to find out WHY this happened. Is this is bug in the server code? I can't come up with any other explanation. I would love for this to be explainable! thanks, keith -- Chief Training Officer Paragon Consulting Services 850-637-3877 -- Chief Training Officer Paragon Consulting Services 850-637-3877
Re: mysql.sock file exists, but still cannot connect to server
Okay, with the good help I was getting, and looking at the all clues MySQL was giving me, like Table 'mysql.host' doesn't exist and Can't find file: './mysql/host.frm', I concluded that the 4.1.9 installation conflicts with the default 4.0.18 installation. For instance, 4.0.18 expects files in /var/mysql and /usr/libexec, but 4.1.9 wants them in /usr/local/mysql, etc. There isn't a mysql/data directory anywhere at all for 4.0.18. The two seem incompatible (at least, it's beyond me...). So, I backed out my 4.1.9 installation, and was able to get things going again under 4.0.18. I guess I'll have to wait until Apple upgrades MySQL with OS X 10.3.8. Thanks to all! Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql.sock file exists, but still cannot connect to server
I've upgraded to mysql 4.1.9 on Mac OS X 10.3.7, but now things won't start up. In the console I get these messages: The database cluster will be initialized with locale C. creating directory /var/db/RemoteManagement/RMDB/rmdb.data... ok creating directory /var/db/RemoteManagement/RMDB/rmdb.data/base... ok creating directory /var/db/RemoteManagement/RMDB/rmdb.data/global... ok creating directory /var/db/RemoteManagement/RMDB/rmdb.data/pg_xlog... ok creating directory /var/db/RemoteManagement/RMDB/rmdb.data/pg_clog... ok creating template1 database in /var/db/RemoteManagement/RMDB/rmdb.data/base/1... ok creating configuration files... ok initializing pg_shadow... ok enabling unlimited row size for system tables... ok initializing pg_depend... ok creating system views... ok loading pg_description... ok creating conversions... ok setting privileges on built-in objects... ok vacuuming database template1... ok copying template1 to template0... ok Success. You can now start the database server using: /System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/postmaster -D /var/db/RemoteManagement/RMDB/rmdb.data or /System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/pg_ctl -D /var/db/RemoteManagement/RMDB/rmdb.data -l logfile start LOG: database system was shut down at 2005-01-19 12:36:29 PST LOG: checkpoint record is at 0/71524 LOG: redo record is at 0/71524; undo record is at 0/0; shutdown TRUE LOG: next transaction id: 1744; next oid: 16766 LOG: database system is ready ERROR: To use passwords, you have to revoke permissions on pg_shadow so normal users cannot read the passwords. Try 'REVOKE ALL ON pg_shadow FROM PUBLIC'. MySQL seems to be running: 649 ?? S 0:00.02 /System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/postmaster -D /var/db/RemoteManagement/RMDB/rmdb.data When I run MySQLManager, I get this error message: 2005-01-19 12:37:34.328 MySQLInfoTool[667] Initial attempt at db installation failed, probably due to bad hostname; trying again with force option. ERROR: 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 050119 12:37:34 Aborting 050119 12:37:34 /usr/libexec/mysqld: Shutdown Complete When I type mysql at the command line, I get: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) ...yet the file exists: srwxrwxrwx 1 mysql wheel0 19 Jan 12:35 mysql.sock Any ideas about what to do? I've reinstalled the mySQL package, but it didn't change things. Thanks! Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql.sock file exists, but still cannot connect to server
Alex Majora wrote: I've upgraded to mysql 4.1.9 on Mac OS X 10.3.7, but now things won't start up. In the console I get these messages: The database cluster will be initialized with locale C. creating directory /var/db/RemoteManagement/RMDB/rmdb.data... ok creating directory /var/db/RemoteManagement/RMDB/rmdb.data/base... ok creating directory /var/db/RemoteManagement/RMDB/rmdb.data/global... ok creating directory /var/db/RemoteManagement/RMDB/rmdb.data/pg_xlog... ok creating directory /var/db/RemoteManagement/RMDB/rmdb.data/pg_clog... ok creating template1 database in /var/db/RemoteManagement/RMDB/rmdb.data/base/1... ok creating configuration files... ok initializing pg_shadow... ok enabling unlimited row size for system tables... ok initializing pg_depend... ok creating system views... ok loading pg_description... ok creating conversions... ok setting privileges on built-in objects... ok vacuuming database template1... ok copying template1 to template0... ok Success. You can now start the database server using: What is this? These messages do not appear to have come from mysql. There's something you haven't told us. What is RemoteManagement/RMDB? Is this something you run by hand, or something automated? /System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/postmaster -D /var/db/RemoteManagement/RMDB/rmdb.data or /System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/pg_ctl -D /var/db/RemoteManagement/RMDB/rmdb.data -l logfile start LOG: database system was shut down at 2005-01-19 12:36:29 PST LOG: checkpoint record is at 0/71524 LOG: redo record is at 0/71524; undo record is at 0/0; shutdown TRUE LOG: next transaction id: 1744; next oid: 16766 LOG: database system is ready ERROR: To use passwords, you have to revoke permissions on pg_shadow so normal users cannot read the passwords. Try 'REVOKE ALL ON pg_shadow FROM PUBLIC'. Have you tried doing what it says here? MySQL seems to be running: 649 ?? S 0:00.02 /System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/postmaster -D /var/db/RemoteManagement/RMDB/rmdb.data That doesn't appear to be mysql. When I run MySQLManager, I get this error message: 2005-01-19 12:37:34.328 MySQLInfoTool[667] Initial attempt at db installation failed, probably due to bad hostname; trying again with force option. ERROR: 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 That certainly seems to be a message (syntax error) from mysql. 050119 12:37:34 Aborting 050119 12:37:34 /usr/libexec/mysqld: Shutdown Complete Not sure why, but mysqld just shut down. When I type mysql at the command line, I get: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Are you sure mysqld is running? You got a shutdown message right before this. ...yet the file exists: srwxrwxrwx 1 mysql wheel0 19 Jan 12:35 mysql.sock Well, that should mean mysqld is running. Two things: 1) Use ps to make sure there's a mysqld process (ps -aux | grep mysqld). 2) Check the permissions on /tmp (actually, /private/tmp under OS X). Some OS X updates have changed /tmp permissions in the past. Any ideas about what to do? I've reinstalled the mySQL package, but it didn't change things. Thanks! Alex Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql.sock file exists, but still cannot connect to server
Michael Stassen wrote: That doesn't appear to be mysql. Now that I look closely, that must be a database for RMDB. Sorry I got the two confused. Are you sure mysqld is running? You got a shutdown message right before this. Apparently, it's not running, as there is no mysqld process running in the ps -aux listing. However, if I try to start mysqld up again, I get: 050119 14:48:43 Can't start server : Bind on unix socket: Address already in use 050119 14:48:43 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 050119 14:48:43 Aborting 050119 14:48:43 /usr/libexec/mysqld: Shutdown Complete Check the permissions on /tmp drwxrwxrwt 14 root wheel 476 19 Jan 14:43 /private/tmp Don't know if this is what it's supposed to be for /tmp. Thanks for your help! Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql.sock file exists, but still cannot connect to server
The postmaster is a Postgres daemon, and pg_shadow is the user table for postgres. Clint From: Michael Stassen [EMAIL PROTECTED] To: Alex Majora [EMAIL PROTECTED] CC: mysql@lists.mysql.com Subject: Re: mysql.sock file exists, but still cannot connect to server Date: Wed, 19 Jan 2005 17:42:34 -0500 Alex Majora wrote: I've upgraded to mysql 4.1.9 on Mac OS X 10.3.7, but now things won't start up. In the console I get these messages: The database cluster will be initialized with locale C. creating directory /var/db/RemoteManagement/RMDB/rmdb.data... ok creating directory /var/db/RemoteManagement/RMDB/rmdb.data/base... ok creating directory /var/db/RemoteManagement/RMDB/rmdb.data/global... ok creating directory /var/db/RemoteManagement/RMDB/rmdb.data/pg_xlog... ok creating directory /var/db/RemoteManagement/RMDB/rmdb.data/pg_clog... ok creating template1 database in /var/db/RemoteManagement/RMDB/rmdb.data/base/1... ok creating configuration files... ok initializing pg_shadow... ok enabling unlimited row size for system tables... ok initializing pg_depend... ok creating system views... ok loading pg_description... ok creating conversions... ok setting privileges on built-in objects... ok vacuuming database template1... ok copying template1 to template0... ok Success. You can now start the database server using: What is this? These messages do not appear to have come from mysql. There's something you haven't told us. What is RemoteManagement/RMDB? Is this something you run by hand, or something automated? /System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/postmaster -D /var/db/RemoteManagement/RMDB/rmdb.data or /System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/pg_ctl -D /var/db/RemoteManagement/RMDB/rmdb.data -l logfile start LOG: database system was shut down at 2005-01-19 12:36:29 PST LOG: checkpoint record is at 0/71524 LOG: redo record is at 0/71524; undo record is at 0/0; shutdown TRUE LOG: next transaction id: 1744; next oid: 16766 LOG: database system is ready ERROR: To use passwords, you have to revoke permissions on pg_shadow so normal users cannot read the passwords. Try 'REVOKE ALL ON pg_shadow FROM PUBLIC'. Have you tried doing what it says here? MySQL seems to be running: 649 ?? S 0:00.02 /System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/postmaster -D /var/db/RemoteManagement/RMDB/rmdb.data That doesn't appear to be mysql. When I run MySQLManager, I get this error message: 2005-01-19 12:37:34.328 MySQLInfoTool[667] Initial attempt at db installation failed, probably due to bad hostname; trying again with force option. ERROR: 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 That certainly seems to be a message (syntax error) from mysql. 050119 12:37:34 Aborting 050119 12:37:34 /usr/libexec/mysqld: Shutdown Complete Not sure why, but mysqld just shut down. When I type mysql at the command line, I get: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Are you sure mysqld is running? You got a shutdown message right before this. ...yet the file exists: srwxrwxrwx 1 mysql wheel0 19 Jan 12:35 mysql.sock Well, that should mean mysqld is running. Two things: 1) Use ps to make sure there's a mysqld process (ps -aux | grep mysqld). 2) Check the permissions on /tmp (actually, /private/tmp under OS X). Some OS X updates have changed /tmp permissions in the past. Any ideas about what to do? I've reinstalled the mySQL package, but it didn't change things. Thanks! Alex Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql.sock file exists, but still cannot connect to server
Additionally, this is what I get when I try to launch mysqld manually: $ sudo ./bin/mysqld_safe [1] 2058 Starting mysqld daemon with databases from /usr/local/mysql/data STOPPING server from pid file /usr/local/mysql/data/whitestar.alpha.net.pid 050119 17:13:12 mysqld ended Is there a way to have mysqld issue more verbose error messages? Thanks! Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql.sock file exists, but still cannot connect to server
Alex Majora wrote: Michael Stassen wrote: That doesn't appear to be mysql. Now that I look closely, that must be a database for RMDB. Sorry I got the two confused. Are you sure mysqld is running? You got a shutdown message right before this. Apparently, it's not running, as there is no mysqld process running in the ps -aux listing. However, if I try to start mysqld up again, I get: 050119 14:48:43 Can't start server : Bind on unix socket: Address already in use 050119 14:48:43 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 050119 14:48:43 Aborting 050119 14:48:43 /usr/libexec/mysqld: Shutdown Complete As you probably know, mysqld should create /tmp/mysql.sock on startup and destroy it on shutdown. As long as you are certain that mysqld is not running, that would mean that it wasn't shut down properly last time and left the socket file in the way. In that case, removing it manually with sudo rm /tmp/mysql.sock should allow mysqld to start. Check the permissions on /tmp drwxrwxrwt 14 root wheel 476 19 Jan 14:43 /private/tmp That's as it should be. Don't know if this is what it's supposed to be for /tmp. Thanks for your help! Alex Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql.sock file exists, but still cannot connect to server
Details should be in the .err file in the data directory (/usr/local/mysql/data/whitestar.alpha.net.err, in your case). Michael Alex Majora wrote: Additionally, this is what I get when I try to launch mysqld manually: $ sudo ./bin/mysqld_safe [1] 2058 Starting mysqld daemon with databases from /usr/local/mysql/data STOPPING server from pid file /usr/local/mysql/data/whitestar.alpha.net.pid 050119 17:13:12 mysqld ended Is there a way to have mysqld issue more verbose error messages? Thanks! Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql.sock file exists, but still cannot connect to server
On Wednesday, January 19, 2005 9:14 PM Michael Stassen wrote: Details should be in the .err file in the data directory Here's the contents of the file: 050119 17:30:02 mysqld started 050119 17:30:02 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive 050119 17:30:02 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 050119 17:30:02 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 43634. InnoDB: Doing recovery: scanned up to log sequence number 0 43634 050119 17:30:02 InnoDB: Flushing modified pages from the buffer pool... 050119 17:30:02 InnoDB: Started; log sequence number 0 43634 050119 17:30:02 [ERROR] Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 050119 17:30:02 mysqld ended It would seem that the issue about table 'mysql.host' is the problem. Is there a way to create this table outside of mysql? Or does this indicate no schema at all in the DB? Thanks! Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqld ended error (but no /var/lib/mysql/mysql.sock file exists!)
Hi folks, Installed Fedora Core 2 with mysql and then removed the mysql packages via the gui widget. Then installed mysql 4 from scratch. Created a symlink, mysql. added the user 'mysql'. chown'd etc the /usr/local/mysql stuff. the command (as root) /usr/local/mysql# bin/safe_mysqld --user=mysql produces the message Starting mysqld daemon with databases from /var/lib/mysql 040715 16:43:07 mysqld ended I've reproduced this several times. I've searched the archives here and have tried the following things: 0. Rebooted from scratch (yeah, old habits die hard). 1. I open up the services widget in the FC gui. There is no mysqld service even listed in the list. 2. There is no (hostname).err file in /usr/local/mysql/data 3. The /var/log/mysqld.log file says mysqld started Warning: asked for... Can't start server: bind on unix socket - permission denied Do you already have another mysqld server running on socket /var/lib/mysql/mysql.sock? Aborting 4. But I don't have any /var/lib/mysql/mysql.sock file at all. So now I'm stuck. It looks like mysqld is still confused about the old install or is looking for a phantom mysql.sock but I'll be durned if I can find it. -- Whil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqld ended error (but no /var/lib/mysql/mysql.sock file exists!)
mysqld is trying to tell you that it doesn't have permission to create /var/lib/mysql/mysql.sock to accept incoming connections. You either need to have mysql create the sock file in another place (such as /tmp/) or give it write permission to /var/lib/mysql/ -Eric On Thu, 15 Jul 2004 17:05:13 -0500, Whil Hentzen [EMAIL PROTECTED] wrote: Hi folks, Installed Fedora Core 2 with mysql and then removed the mysql packages via the gui widget. Then installed mysql 4 from scratch. Created a symlink, mysql. added the user 'mysql'. chown'd etc the /usr/local/mysql stuff. the command (as root) /usr/local/mysql# bin/safe_mysqld --user=mysql produces the message Starting mysqld daemon with databases from /var/lib/mysql 040715 16:43:07 mysqld ended I've reproduced this several times. I've searched the archives here and have tried the following things: 0. Rebooted from scratch (yeah, old habits die hard). 1. I open up the services widget in the FC gui. There is no mysqld service even listed in the list. 2. There is no (hostname).err file in /usr/local/mysql/data 3. The /var/log/mysqld.log file says mysqld started Warning: asked for... Can't start server: bind on unix socket - permission denied Do you already have another mysqld server running on socket /var/lib/mysql/mysql.sock? Aborting 4. But I don't have any /var/lib/mysql/mysql.sock file at all. So now I'm stuck. It looks like mysqld is still confused about the old install or is looking for a phantom mysql.sock but I'll be durned if I can find it. -- Whil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Missing mysql.sock file
Hello, I must have installed mysql incorrectly because my suse 8.0 server does not have a mysql.sock file at all. I installed mysql 3.23.48 from rpm packages I installed server bench client Max navigator shared and the required perl bench What happened. Can anyone email me a socket file? Thx -- Best Rgds Graham Neal Cozy MK-IV S/N: 874 http://www.cozybuilders.org/ http://www.cozyaircraft.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
when server crashes the temporary file mysql.sock file in the directory /var/lib/mysql is locked and cannot be deleted
We are using linux as out operating system in HP printers. Now one day the mysql server crashed and was not able to restart As the temporary socket file mysql.sock was not getting deleted and which prevented the server from getting restarted. However after a restart of the machine this file gets automatically cleaned up. However the restart is undesirable in embedded linux. Is there any means to delete the mysql.sock file in the same session. Thanks and Regards, Prakash Karanth Systems Engineer Embedded and Internet Access Soln Wipro Technologies, Tower 6, 3rd Floor, Electronic City-2. Bangalore -561229 Ph:080-8520408 -x6320 -- ___ Get your free email from http://mail.indiainfo.com Powered by Outblaze - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql installation error... mysql.sock file not found
Hi, I have redhat linux 7.1 server and I have downloaded the binary version of mysql 3.23.52 and I have installed the same version on other servers and it was all fine but on this server I am getting the following error [root@abacusweb mysql]# bin/safe_mysqld [1] 21278 [root@abacusweb mysql]# Starting mysqld daemon with databases from /var/lib/mysq l 020910 19:12:53 mysqld ended and I can not see the file mysql.sock in /varlib/mysql area but it has all the tables etc that are needed. And I followed the README and all the docs and did all the steps one by one.. and also I don't know how to run mysqlbug program?? How can direct mysqlbug program to a file so that I can send that file as an attachment to this mailing list?? Please help me.. seems like I am stuck here... I created mysql user and the group and I changed all the permissions according to the document Thanks Anand _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql.sock file does not get created
vigneshvg, Saturday, May 04, 2002, 8:59:40 AM, you wrote: vDescription: v I try to run the mysqld script to start the MySQL server. It starts, then immediately I get a message saying it has ended. v [root@localhost init.d]# ./mysql.server start v [root@localhost init.d]# Starting mysqld daemon with databases from /var/lib/mysql/mysql v 020504 11:22:19 mysqld ended v This does not create the mysql.sock file. v This error logs tell me that -- v 020503 14:24:19 mysqld started v 020503 14:24:20 Can't start server : Bind on unix socket: Permission denied v 020503 14:24:20 Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ? v 020503 14:24:20 Aborting v I dont have another MySQL server running. What am I supposed to do now ? Looks like MySQL doesn't have permissions on the MySQL data dir (/var/lib/mysql). So, you should change permission on that dir and start mysqld again. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql.sock file does not get created
Description: I try to run the mysqld script to start the MySQL server. It starts, then immediately I get a message saying it has ended. [root@localhost init.d]# ./mysql.server start [root@localhost init.d]# Starting mysqld daemon with databases from /var/lib/mysql/mysql 020504 11:22:19 mysqld ended This does not create the mysql.sock file. This error logs tell me that -- 020503 14:24:19 mysqld started 020503 14:24:20 Can't start server : Bind on unix socket: Permission denied 020503 14:24:20 Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ? 020503 14:24:20 Aborting I dont have another MySQL server running. What am I supposed to do now ? How-To-Repeat: I dont know. I think this is something wrong here (or) maybe it isnt. Fix: Submitter-Id: submitter ID Originator:root Organization: MySQL support: email support Synopsis: .sock file is not created Severity: serious Priority: medium Category: mysql Class: support Release: mysql-3.23.22-beta (Source distribution) Environment: System: Linux localhost.localdomain 2.2.16-22 #1 Tue Aug 22 16:49:06 EDT 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686' CXX='c++' CXXFLAGS='-O2 -march=i386 -mcpu=i686' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 14 May 1 21:34 /lib/libc.so.6 - libc-2.1.92.so -rwxr-xr-x1 root root 4776568 Aug 31 2000 /lib/libc-2.1.92.so Configure command: ./configure i386-redhat-linux --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --includedir=/usr/include --libdir=/usr/lib --libexecdir=/usr/libexec --localstatedir=/var --sharedstatedir=/usr/com --mandir=/usr/share/man --infodir=/usr/share/info --without-debug --without-readline --enable-shared --with-extra-charsets=complex --without-bench --localstatedir=/var/lib/mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --enable-assembler --with-mysqld-user=mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Regarding mysql.sock file
Hello all, I am working with the replication of mysql with selected db. While i was trying to do that suddenly slave machine's mysql.sock file was deleted. So i am not able to enter into mysql. May i know whether there is any other way to get it(mysql.sock) back as i restarted mysql quite ample number of times. Or reinstalling is the only way for getting the file back. Thank you. -- Regards, Charitha. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql.sock file
At 05:48 PM 05/22/2001, Angerer, Chad wrote: Dennis, do a find / -name mysql.sock 2/dev/null to find exactly where mysql puts this file.. My rpm install put it in /var/lib/mysql/mysql.sock Find where your mysql.sock file is and make a symbolic on it pointing to /tmp/mysql.sock ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock Also check your file permissions. Make sure the mysqld user has access to this directory. Yes, we've done that, but because the tmp directory may get scrubbed on shutdown or boot, it has to be done on each boot. I wondered if I could find out whethers its still SUPPOSED to be there, at which point permissions would be something to consider. thanks, Dennis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql.sock file
At 04:47 PM 05/23/2001, Angerer, Chad wrote: Well.. not sure if this is right but if you start up the mysqld server on startup the mysql.sock should be created in that directory always, so the symbolic link will always point to the same place. Otherwise.. I believe the directory will be in your my.cnf file.. and you can change that to point to the correct path. I hope I am moving along the right path here. Ah, does anyone know what the setting in my.cnf would be? That would be ideal. Dennis -C -Original Message- From: Dennis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 23, 2001 3:37 PM To: Angerer, Chad; [EMAIL PROTECTED] Subject: RE: mysql.sock file At 05:48 PM 05/22/2001, Angerer, Chad wrote: Dennis, do a find / -name mysql.sock 2/dev/null to find exactly where mysql puts this file.. My rpm install put it in /var/lib/mysql/mysql.sock Find where your mysql.sock file is and make a symbolic on it pointing to /tmp/mysql.sock ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock Also check your file permissions. Make sure the mysqld user has access to this directory. Yes, we've done that, but because the tmp directory may get scrubbed on shutdown or boot, it has to be done on each boot. I wondered if I could find out whethers its still SUPPOSED to be there, at which point permissions would be something to consider. thanks, Dennis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql.sock file
We have a client program that fails trying to access tmp/mysql.sock on open. It seems that newer servers either dont create the tmp file or store it somewhere else. What can be done to make the existing binary work with both older and newer servers? Is there a my.cnf setting? And also, why has this become an issue? Can it be a build issue with the server? Or is this file being scrubbed by some startup routine (Debian is well-known to do damage upon start up this way)? thanks. Dennis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql.sock file
Dennis, do a find / -name mysql.sock 2/dev/null to find exactly where mysql puts this file.. My rpm install put it in /var/lib/mysql/mysql.sock Find where your mysql.sock file is and make a symbolic on it pointing to /tmp/mysql.sock ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock Also check your file permissions. Make sure the mysqld user has access to this directory. Chad -Original Message- From: Dennis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 22, 2001 3:56 PM To: [EMAIL PROTECTED] Subject: mysql.sock file We have a client program that fails trying to access tmp/mysql.sock on open. It seems that newer servers either dont create the tmp file or store it somewhere else. What can be done to make the existing binary work with both older and newer servers? Is there a my.cnf setting? And also, why has this become an issue? Can it be a build issue with the server? Or is this file being scrubbed by some startup routine (Debian is well-known to do damage upon start up this way)? thanks. Dennis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql.sock file
I faced the same problem and I solved it by creating a link under tmp called mysqld.sock pointing to my mysql.sock let me know if it helped Siomara From: Dennis [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: mysql.sock file Date: Tue, 22 May 2001 16:56:19 -0400 We have a client program that fails trying to access tmp/mysql.sock on open. It seems that newer servers either dont create the tmp file or store it somewhere else. What can be done to make the existing binary work with both older and newer servers? Is there a my.cnf setting? And also, why has this become an issue? Can it be a build issue with the server? Or is this file being scrubbed by some startup routine (Debian is well-known to do damage upon start up this way)? thanks. Dennis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php