From owner-freebsd-database@FreeBSD.ORG Mon Mar 12 15:32:20 2007 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 17DB016A417 for ; Mon, 12 Mar 2007 15:32:20 +0000 (UTC) (envelope-from bounces@nabble.com) Received: from talk.nabble.com (www.nabble.com [72.21.53.35]) by mx1.freebsd.org (Postfix) with ESMTP id D9E8D13C469 for ; Mon, 12 Mar 2007 15:32:19 +0000 (UTC) (envelope-from bounces@nabble.com) Received: from [72.21.53.38] (helo=jubjub.nabble.com) by talk.nabble.com with esmtp (Exim 4.50) id 1HQmVX-00034N-03 for freebsd-database@freebsd.org; Mon, 12 Mar 2007 08:32:19 -0700 Message-ID: <9436795.post@talk.nabble.com> Date: Mon, 12 Mar 2007 08:32:18 -0700 (PDT) From: drewshen To: freebsd-database@freebsd.org In-Reply-To: <9397995.post@talk.nabble.com> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Nabble-From: drewsheneman@gmail.com References: <9273118.post@talk.nabble.com> <200703041906.59868.idiotbg@gmail.com> <9315636.post@talk.nabble.com> <106801c75fd3$7d6d9420$2401010a@zone3000.net> <9397995.post@talk.nabble.com> Subject: Re: mysql.sock X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 12 Mar 2007 15:32:20 -0000 drewshen wrote: >=20 >=20 >=20 > Vitali Malicky wrote: >>=20 >>=20 >> ----- Original Message ----- >> From: "drewshen" >> To: >> Sent: Monday, March 05, 2007 7:04 PM >> Subject: Re: mysql.sock >>=20 >>=20 >>=20 >>=20 >>=20 >> Momchil Ivanov wrote: >>> >>> =D0=9D=D0=B0 2.3.2007 17:55 drewshen =D0=BF=D0=B8=D1=88=D0=B5: >>>> 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. >>> >>=20 >> "weird... >> will you please send your my.cnf here? >> also I wouldn't mind to see your build options." >>=20 >>=20 >> "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 collectio= n >> 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?" >>=20 >> I tried mysqld_safe: >>=20 >> # 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 >>=20 >> i was running as root when i tried this >>=20 >> i also tried again to set up a different location to create mysql.sock: >>=20 >> i put these lines in my.cnf: >>=20 >> [mysqld]=20 >> socket=3D/usr/local/etc =20 >> =20 >> [client] >> socket=3D/usr/local/etc=20 >>=20 >> and tried to start mysql: >>=20 >> # mysql >> ERROR 2002 (HY000): Can't connect to local MySQL server through socket >> '/usr/local/etc' (38) >> #=20 >>=20 >> i tried mysqld_safe again: >>=20 >> # 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 >>=20 >>=20 >>> -- >>> 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 >>> >>> >>> >>=20 >> -- >> 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. >>=20 >> _______________________________________________ >> freebsd-database@freebsd.org mailing list >> http://lists.freebsd.org/mailman/listinfo/freebsd-database >> To unsubscribe, send any mail to >> "freebsd-database-unsubscribe@freebsd.org" >>=20 >>=20 >>=20 >> _______________________________________________ >> freebsd-database@freebsd.org mailing list >> http://lists.freebsd.org/mailman/listinfo/freebsd-database >> To unsubscribe, send any mail to >> "freebsd-database-unsubscribe@freebsd.org" >>=20 >>=20 >=20 >=20 --=20 View this message in context: http://www.nabble.com/mysql.sock-tf3334648.ht= ml#a9436795 Sent from the freebsd-database mailing list archive at Nabble.com.