mysql.sock

[drewshen]

I installed  mysql through ports on freebsd 6.1.  i started the daemon, and mysql starts.  however when i try "mysql" i get
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock'

i looked this up on the mysql page and did find much help.  first i tried

shell> chmod +t /tmp

to protect tmp.  that didnt solve it, so i tried to point my sock file to another directory in /etc/my.cnf.  i got the same error message, even with the new directory.  does anyone know where my problem lies? thanks!

[Momchil Ivanov]

На 2.3.2007 17:55 drewshen пише:

> I installed  mysql through ports on freebsd 6.1.  i started the daemon, and
> mysql starts.  however when i try "mysql" i get
> ERROR 2002 (HY000): Can't connect to local MySQL server through socket
> '/tmp/mysql.sock'
>
> i looked this up on the mysql page and did find much help.  first i tried
>
> shell> chmod +t /tmp
>
> to protect tmp.  that didnt solve it, so i tried to point my sock file to
> another directory in /etc/my.cnf.  i got the same error message, even with
> the new directory.  does anyone know where my problem lies? thanks!

What do you see in your mysql error log file?

--
This correspondence is strictly confidential. Any screening, filtering
and/or production for the purpose of public or otherwise disclosure is
forbidden without written permission by the author signed above. If you are
not the intended recipient, please immediately notify the sender and
permanently delete any copies

PGP KeyID: 0x3118168B
Keyserver: pgp.mit.edu
Key fingerprint BB50 2983 0714 36DC D02E  158A E03D 56DA 3118 168B

[drewshen]

Momchil Ivanov wrote:

На 2.3.2007 17:55 drewshen пише:
> I installed  mysql through ports on freebsd 6.1.  i started the daemon, and
> mysql starts.  however when i try "mysql" i get
> ERROR 2002 (HY000): Can't connect to local MySQL server through socket
> '/tmp/mysql.sock'
>
> i looked this up on the mysql page and did find much help.  first i tried
>
> shell> chmod +t /tmp
>
> to protect tmp.  that didnt solve it, so i tried to point my sock file to
> another directory in /etc/my.cnf.  i got the same error message, even with
> the new directory.  does anyone know where my problem lies? thanks!

"What do you see in your mysql error log file?"

my error log shows no record of the "mysql.sock" error message. my latest record in it was when i restarted mysql.  i tried "ps -ef | grep mysql" and the only result was my search. however when i started mysql it said it was starting.  

--
This correspondence is strictly confidential. Any screening, filtering
and/or production for the purpose of public or otherwise disclosure is
forbidden without written permission by the author signed above. If you are
not the intended recipient, please immediately notify the sender and
permanently delete any copies

PGP KeyID: 0x3118168B
Keyserver: pgp.mit.edu
Key fingerprint BB50 2983 0714 36DC D02E  158A E03D 56DA 3118 168B

 

[Vitali Malicky]

----- Original Message -----
From: "drewshen" <drewsheneman@...>
To: <freebsd-database@...>
Sent: Monday, March 05, 2007 7:04 PM
Subject: Re: mysql.sock





Momchil Ivanov wrote:

>
> На 2.3.2007 17:55 drewshen пише:
>> I installed  mysql through ports on freebsd 6.1.  i started the daemon,
>> and
>> mysql starts.  however when i try "mysql" i get
>> ERROR 2002 (HY000): Can't connect to local MySQL server through socket
>> '/tmp/mysql.sock'
>>
>> i looked this up on the mysql page and did find much help.  first i tried
>>
>> shell> chmod +t /tmp
>>
>> to protect tmp.  that didnt solve it, so i tried to point my sock file to
>> another directory in /etc/my.cnf.  i got the same error message, even
>> with
>> the new directory.  does anyone know where my problem lies? thanks!
>
> "What do you see in your mysql error log file?"
>
> my error log shows no record of the "mysql.sock" error message. my latest
> record in it was when i restarted mysql.  i tried "ps -ef | grep mysql"
> and the only result was my search. however when i started mysql it said it
> was starting.
>

weird...
will you please send your my.cnf here?
also I wouldn't mind to see your build options.

> --
> This correspondence is strictly confidential. Any screening, filtering
> and/or production for the purpose of public or otherwise disclosure is
> forbidden without written permission by the author signed above. If you
> are
> not the intended recipient, please immediately notify the sender and
> permanently delete any copies
>
> PGP KeyID: 0x3118168B
> Keyserver: pgp.mit.edu
> Key fingerprint BB50 2983 0714 36DC D02E  158A E03D 56DA 3118 168B
>
>
>

--
View this message in context:
http://www.nabble.com/mysql.sock-tf3334648.html#a9315636
Sent from the freebsd-database mailing list archive at Nabble.com.

_______________________________________________
freebsd-database@... mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-database
To unsubscribe, send any mail to "freebsd-database-unsubscribe@..."



_______________________________________________
freebsd-database@... mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-database
To unsubscribe, send any mail to "freebsd-database-unsubscribe@..."

[drewshen]

Vitali Malicky wrote:

----- Original Message -----
From: "drewshen" <[e-mail]>
To: <[e-mail]>
Sent: Monday, March 05, 2007 7:04 PM
Subject: Re: mysql.sock





Momchil Ivanov wrote:
>
> На 2.3.2007 17:55 drewshen пише:
>> I installed  mysql through ports on freebsd 6.1.  i started the daemon,
>> and
>> mysql starts.  however when i try "mysql" i get
>> ERROR 2002 (HY000): Can't connect to local MySQL server through socket
>> '/tmp/mysql.sock'
>>
>> i looked this up on the mysql page and did find much help.  first i tried
>>
>> shell> chmod +t /tmp
>>
>> to protect tmp.  that didnt solve it, so i tried to point my sock file to
>> another directory in /etc/my.cnf.  i got the same error message, even
>> with
>> the new directory.  does anyone know where my problem lies? thanks!
>
> "What do you see in your mysql error log file?"
>
> my error log shows no record of the "mysql.sock" error message. my latest
> record in it was when i restarted mysql.  i tried "ps -ef | grep mysql"
> and the only result was my search. however when i started mysql it said it
> was starting.
>

"weird...
will you please send your my.cnf here?
also I wouldn't mind to see your build options."


I created my.cnf in order to try to redirect where mysql.sock was created.  When this did not work I deleted it.  I did not use any customized build options either, I just used the updated ports collection in freebsd 6.1. and did a "make install clean." Is there any way I can allow mysql to create this socket file so it will work properly?


> --
> This correspondence is strictly confidential. Any screening, filtering
> and/or production for the purpose of public or otherwise disclosure is
> forbidden without written permission by the author signed above. If you
> are
> not the intended recipient, please immediately notify the sender and
> permanently delete any copies
>
> PGP KeyID: 0x3118168B
> Keyserver: pgp.mit.edu
> Key fingerprint BB50 2983 0714 36DC D02E  158A E03D 56DA 3118 168B
>
>
>

--
View this message in context:
http://www.nabble.com/mysql.sock-tf3334648.html#a9315636
Sent from the freebsd-database mailing list archive at Nabble.com.

_______________________________________________
[e-mail] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-database
To unsubscribe, send any mail to "[e-mail]"



_______________________________________________
[e-mail] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-database
To unsubscribe, send any mail to "[e-mail]"

[drewshen]

Vitali Malicky wrote:

----- Original Message -----
From: "drewshen" <[e-mail]>
To: <[e-mail]>
Sent: Monday, March 05, 2007 7:04 PM
Subject: Re: mysql.sock





Momchil Ivanov wrote:
>
> На 2.3.2007 17:55 drewshen пише:
>> I installed  mysql through ports on freebsd 6.1.  i started the daemon,
>> and
>> mysql starts.  however when i try "mysql" i get
>> ERROR 2002 (HY000): Can't connect to local MySQL server through socket
>> '/tmp/mysql.sock'
>>
>> i looked this up on the mysql page and did find much help.  first i tried
>>
>> shell> chmod +t /tmp
>>
>> to protect tmp.  that didnt solve it, so i tried to point my sock file to
>> another directory in /etc/my.cnf.  i got the same error message, even
>> with
>> the new directory.  does anyone know where my problem lies? thanks!
>
> "What do you see in your mysql error log file?"
>
> my error log shows no record of the "mysql.sock" error message. my latest
> record in it was when i restarted mysql.  i tried "ps -ef | grep mysql"
> and the only result was my search. however when i started mysql it said it
> was starting.
>

"weird...
will you please send your my.cnf here?
also I wouldn't mind to see your build options."


"I created my.cnf in order to try to redirect where mysql.sock was created.  When this did not work I deleted it.  I did not use any customized build options either, I just used the updated ports collection in freebsd 6.1. and did a "make install clean." Is there any way I can allow mysql to create this socket file so it will work properly?"

I tried mysqld_safe:

# mysqld_safe
Starting mysqld daemon with databases from /var/db/mysql
STOPPING server from pid file /var/db/mysql/hostname.com.pid
070312 10:29:29  mysqld ended

i was running as root when i tried this

i also tried again to set up a different location to create mysql.sock:

i put these lines in my.cnf:

[mysqld]
socket=/usr/local/etc      
 
[client]
socket=/usr/local/etc

and tried to start mysql:

# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/usr/local/etc' (38)
#

i tried mysqld_safe again:

# mysqld_safe
Starting mysqld daemon with databases from /var/db/mysql
rm: /usr/local/etc: is a directory
STOPPING server from pid file /var/db/mysql/hostname.com.pid
070312 10:39:46  mysqld ended


> --
> This correspondence is strictly confidential. Any screening, filtering
> and/or production for the purpose of public or otherwise disclosure is
> forbidden without written permission by the author signed above. If you
> are
> not the intended recipient, please immediately notify the sender and
> permanently delete any copies
>
> PGP KeyID: 0x3118168B
> Keyserver: pgp.mit.edu
> Key fingerprint BB50 2983 0714 36DC D02E  158A E03D 56DA 3118 168B
>
>
>

--
View this message in context:
http://www.nabble.com/mysql.sock-tf3334648.html#a9315636
Sent from the freebsd-database mailing list archive at Nabble.com.

_______________________________________________
[e-mail] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-database
To unsubscribe, send any mail to "[e-mail]"



_______________________________________________
[e-mail] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-database
To unsubscribe, send any mail to "[e-mail]"