Re: Err 2002 socks suck noway to start
Blank does not mean bad try to connect with mysql client if not try #netstat -nvatp |grep mysql if you see nothing #locate .err You shold find some file lie .err #tail /path/to/that_file.err aslo you may try #cat /var/log/messages |grep mysql Peter Zyumbilev Project Manager Mansion Productions Inc. AIM: peterZmansion YMS: peterZmansion MSN: [EMAIL PROTECTED] Skype: peterZmansion ICQ: 108984925 support: http://support.hostmansion.com (24/7) email: [EMAIL PROTECTED] web: www.mansionproductions.com MPA2 - Mansion Production Automation Program MPA3 - Next Generation Automation Program CSS - Content Sale System MTS - Mansion Ticket System Hostmansion.com - Highest Quality Web Hosting The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you are not the intended recipient of this message you are hereby notified that any use, review, retransmission, dissemination, distribution, reproduction or any action taken in reliance upon this message is prohibited. If you received this in error, please contact the sender and delete the material from any computer. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of the company. - Original Message - From: pourave To: Peter ; [EMAIL PROTECTED] Sent: Monday, June 07, 2004 1:38 AM Subject: Re: Err 2002 socks suck noway to start [EMAIL PROTECTED] [/tmp]# locate mysql.server /usr/share/mysql/mysql.server [EMAIL PROTECTED] [/tmp]# /usr/share/mysql/mysql.server start [EMAIL PROTECTED] [/tmp]# it seems nothing ... should I have to see in some log file ? Thanks. - Original Message - # locate mysql.server # /path/to/mysql.server start what error it gives ? Peter Zyumbilev --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.693 / Virus Database: 454 - Release Date: 01/06/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Err 2002 socks suck noway to start
[EMAIL PROTECTED] [/tmp]# locate mysql.server /usr/share/mysql/mysql.server [EMAIL PROTECTED] [/tmp]# /usr/share/mysql/mysql.server start [EMAIL PROTECTED] [/tmp]# it seems nothing ... should I have to see in some log file ? Thanks. - Original Message - # locate mysql.server # /path/to/mysql.server start what error it gives ? Peter Zyumbilev --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.693 / Virus Database: 454 - Release Date: 01/06/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Err 2002 socks suck noway to start
# locate mysql.server # /path/to/mysql.server start what error it gives ? Peter Zyumbilev Project Manager Mansion Productions Inc. AIM: peterZmansion YMS: peterZmansion MSN: [EMAIL PROTECTED] Skype: peterZmansion ICQ: 108984925 support: http://support.hostmansion.com (24/7) email: [EMAIL PROTECTED] web: www.mansionproductions.com MPA2 - Mansion Production Automation Program MPA3 - Next Generation Automation Program CSS - Content Sale System MTS - Mansion Ticket System Hostmansion.com - Highest Quality Web Hosting The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you are not the intended recipient of this message you are hereby notified that any use, review, retransmission, dissemination, distribution, reproduction or any action taken in reliance upon this message is prohibited. If you received this in error, please contact the sender and delete the material from any computer. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of the company. - Original Message - From: pourave To: Steve Buehler ; [EMAIL PROTECTED] Sent: Sunday, June 06, 2004 6:11 PM Subject: Re: Err 2002 socks suck noway to start Noway :( [EMAIL PROTECTED] [/etc]# vi my.cnf [EMAIL PROTECTED] [/etc]# service mysql start [EMAIL PROTECTED] [/etc]# mysql ERROR 2002: Can't connect to local MySQL server through socket '/usr/local/lib/mysql.sock' (2) [EMAIL PROTECTED] [/etc]# vi my.cnf [EMAIL PROTECTED] [/etc]# service mysql start [EMAIL PROTECTED] [/etc]# mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/tmp/mysql.sock' (2) Thanks --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.693 / Virus Database: 454 - Release Date: 31/05/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Err 2002 socks suck noway to start
Noway :( [EMAIL PROTECTED] [/etc]# vi my.cnf [EMAIL PROTECTED] [/etc]# service mysql start [EMAIL PROTECTED] [/etc]# mysql ERROR 2002: Can't connect to local MySQL server through socket '/usr/local/lib/mysql.sock' (2) [EMAIL PROTECTED] [/etc]# vi my.cnf [EMAIL PROTECTED] [/etc]# service mysql start [EMAIL PROTECTED] [/etc]# mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/tmp/mysql.sock' (2) Thanks --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.693 / Virus Database: 454 - Release Date: 31/05/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Err 2002 socks suck noway to start
Thansk for your suggestion Steve, see what I have. I don't know why by default server wants a sock in /var/lib/mysql and why it doesnt exists anymore ? How to create a new one ? A search [EMAIL PROTECTED] [~]# find / -name mysql.sock /var/tmp/mysql.sock /tmp/mysql.sock /usr/local/lib/mysql.sock I try to force sock in tmp dir [EMAIL PROTECTED] [~]# tail /etc/my.cnf [client] socket=/tmp/mysql.sock [mysqld] set-variable = max_connections=500 socket=/tmp/mysql.sock [EMAIL PROTECTED] [~]# mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) [EMAIL PROTECTED] [~]# tail ~/.my.cnf [client] user=root pass=** [mysqladmin] password=** user=root and now # is a comment, without any directive [EMAIL PROTECTED] [~]# tail /etc/my.cnf #[client] #socket=/tmp/mysql.sock [mysqld] set-variable = max_connections=500 #socket=/tmp/mysql.sock [EMAIL PROTECTED] [~]# mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) You advise me to test the other socks ? Thanks --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.693 / Virus Database: 454 - Release Date: 31/05/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Err 2002 socks suck noway to start
> Okay. What does the MySQL error log say. Anything? Do you know where can I find it ? Dates are old 031222 ! ... [EMAIL PROTECTED] [/var/log]# tail mysqld.log /usr/sbin/mysqld: ready for connections. Version: '4.0.15-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 031222 12:57:02 /usr/sbin/mysqld: Normal shutdown 031222 12:57:02 InnoDB: Starting shutdown... 031222 12:57:04 InnoDB: Shutdown completed 031222 12:57:04 /usr/sbin/mysqld: Shutdown Complete 031222 12:57:04 mysqld ended [EMAIL PROTECTED] [/var/log]# head mysqld.log 031202 22:05:39 mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 031202 22:05:39 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 031202 22:05:39 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 031202 22:05:40 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB [EMAIL PROTECTED] [/var/log]# Thanks. David D --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.693 / Virus Database: 454 - Release Date: 31/05/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Err 2002 socks suck noway to start
At 20:05 +0200 6/5/04, pourave wrote: > At 19:21 +0200 6/5/04, pourave wrote: >Hi, > >I am on a redhat, i read a lot of doc on the problem I hav but noway to >advance, mysql won't start and won't tell anything : mysql is a client program. The server is named mysqld. I know under redhat a script call service is used to start mysql service : #service mysql start same as # /etc/rc.d/init.d/mysql start Okay. What does the MySQL error log say. Anything? Nothing : [EMAIL PROTECTED] [/var/log]# ps auxw | grep mysql root 6212 0.0 0.1 3776 568 pts/0S12:59 0:00 grep mysql Mysql used to start automaticaly [EMAIL PROTECTED] [/var/log]# /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/leya .pid >/dev/null 2>&1 & [1] 6301 [EMAIL PROTECTED] [/var/log]# ps auxw | grep mysql root 6335 0.0 0.1 3776 568 pts/0S13:02 0:00 grep mysql [1]+ Done /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/leya .pid >/dev/null 2>&1 and been stopped :( --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.693 / Virus Database: 454 - Release Date: 31/05/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Err 2002 socks suck noway to start
> At 19:21 +0200 6/5/04, pourave wrote: > >Hi, > > > >I am on a redhat, i read a lot of doc on the problem I hav but noway to > >advance, mysql won't start and won't tell anything : > > mysql is a client program. > The server is named mysqld. I know under redhat a script call service is used to start mysql service : #service mysql start same as # /etc/rc.d/init.d/mysql start Nothing : [EMAIL PROTECTED] [/var/log]# ps auxw | grep mysql root 6212 0.0 0.1 3776 568 pts/0S12:59 0:00 grep mysql Mysql used to start automaticaly [EMAIL PROTECTED] [/var/log]# /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/leya .pid >/dev/null 2>&1 & [1] 6301 [EMAIL PROTECTED] [/var/log]# ps auxw | grep mysql root 6335 0.0 0.1 3776 568 pts/0S13:02 0:00 grep mysql [1]+ Done /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/leya .pid >/dev/null 2>&1 and been stopped :( --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.693 / Virus Database: 454 - Release Date: 31/05/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Err 2002 socks suck noway to start
At 19:21 +0200 6/5/04, pourave wrote: Hi, I am on a redhat, i read a lot of doc on the problem I hav but noway to advance, mysql won't start and won't tell anything : mysql is a client program. The server is named mysqld. [EMAIL PROTECTED] [~]# service mysql start [EMAIL PROTECTED] [~]# mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) [EMAIL PROTECTED] [~]# ls -ls /tmp total 48 8 drwxrwxrwt3 root root 8192 Jun 5 11:55 ./ 4 drwxr-xr-x 20 root root 4096 Jun 5 11:01 ../ 4 drwxrwxrwx2 bin bin 4096 Jun 5 11:02 .iroha_unix/ 0 srwxrwxrwx1 mysqlmysql 0 Jun 5 11:55 mysql.sock= ... [EMAIL PROTECTED] [/tmp]# rpm -qa | grep MySQL MySQL-server-4.0.18-0 perl-DBD-MySQL-2.1021-3 MySQL-client-4.0.18-0 MySQL-embedded-4.0.18-0 MySQL-devel-4.0.18-0 MySQL-shared-4.0.18-0 -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Err 2002 socks suck noway to start
Hi, I am on a redhat, i read a lot of doc on the problem I hav but noway to advance, mysql won't start and won't tell anything : [EMAIL PROTECTED] [~]# service mysql start [EMAIL PROTECTED] [~]# mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) [EMAIL PROTECTED] [~]# ls -ls /tmp total 48 8 drwxrwxrwt3 root root 8192 Jun 5 11:55 ./ 4 drwxr-xr-x 20 root root 4096 Jun 5 11:01 ../ 4 drwxrwxrwx2 bin bin 4096 Jun 5 11:02 .iroha_unix/ 0 srwxrwxrwx1 mysqlmysql 0 Jun 5 11:55 mysql.sock= ... [EMAIL PROTECTED] [/tmp]# rpm -qa | grep MySQL MySQL-server-4.0.18-0 perl-DBD-MySQL-2.1021-3 MySQL-client-4.0.18-0 MySQL-embedded-4.0.18-0 MySQL-devel-4.0.18-0 MySQL-shared-4.0.18-0 Thanks. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.693 / Virus Database: 454 - Release Date: 31/05/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]