From owner-freebsd-database@FreeBSD.ORG Fri May 14 10:32:42 2004 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 3772216A4CE for ; Fri, 14 May 2004 10:32:42 -0700 (PDT) Received: from tomts13-srv.bellnexxia.net (tomts13.bellnexxia.net [209.226.175.34]) by mx1.FreeBSD.org (Postfix) with ESMTP id 9CD9E43D58 for ; Fri, 14 May 2004 10:32:39 -0700 (PDT) (envelope-from phil@rootnet.ca) Received: from rnsd ([64.228.32.93]) by tomts13-srv.bellnexxia.net (InterMail vM.5.01.06.05 201-253-122-130-105-20030824) with ESMTP id <20040514173236.TXTB20937.tomts13-srv.bellnexxia.net@rnsd> for ; Fri, 14 May 2004 13:32:36 -0400 From: "Philip" To: Date: Fri, 14 May 2004 13:32:34 -0400 Organization: root Networks Canada MIME-Version: 1.0 X-Mailer: Microsoft Office Outlook, Build 11.0.5510 Thread-Index: AcQ50yGnWYol8jQ9TaaLdP0b64mVGAABVTsQAAAwA1A= X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2096 In-Reply-To: Message-Id: <20040514173236.TXTB20937.tomts13-srv.bellnexxia.net@rnsd> Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Content-Filtered-By: Mailman/MimeDel 2.1.1 Subject: RE: Mysql: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: phil@rootnet.ca List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 14 May 2004 17:32:42 -0000 _____ From: Philip [mailto:phil@rootnet.ca] Sent: May 14, 2004 12:48 PM To: 'freebsd-database@freebsd.org' Subject: Mysql: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' I am running FreeBSD 5.1-RELEASE-p16 This is a new server install. I have installed freebsd freshly and correctly. I cvsup'ed and compiled new kernel with new sources. I have the ports collection installed. SO i wanted to intall the ports version of mysql. I am having serious issues with this ( i think it may be my hardware firewall - not sure ) this is what i did and what happened: i installed mysql 5 Following the instructions: | > cd /usr/ports/databases/mysql5---versionnum | > make install clean and then again for mysql-client At this time i think its ready to be played with (am i wrong?) so i try to start mysql ( i try safe start [safe_mysqld] and regular start) I try connecting as mysql user | > /usr/local/bin/safe_mysqld --user=mysql & [1] 52346 |> Starting mysqld daemon with databases from /var/db/mysql Abort trap 040514 02:37:50 mysqld ended This is the problem: i can NOT connect to mysql! So at this time, i think its a issue with the version of 'bsd and the version of ' sql im using. so i pkg_delete it and install version 4 and then 3.23 respectively. no luck, same prob. i run mysql_install_db for some help and try to connect regularly and This is what happens:: | > ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' i then went into my.cnf and commented out the port number 3306 after figuring that this is the port that mysql connects to and its being blocked for some reason. no luck again. I then look at my /var/log/messages to see why mysql wont start and if its sending any kernel mesg's this is what i get kernel: pid 27201 (mysqld), uid 10**: exited on signal 6 (which is a sigabort) WHY is this happening? Please help me, i have been working on this for the past couple of days. Thank you for all your time and patience. and regarding the firewall that is on freebsd | > ipfw show | ipfw: getsockopt(IP_FW_GET): Protocol not available hmm mysql_(client and server) 3.23.58_2 is sitting on the server as we speak All i want is to have a working mysql. Why isnt' there any good documentation for FreeBSD and mysql? if anyone knows of any? Thanks again Any other question please feel free to ask.. thanks