From owner-freebsd-database@FreeBSD.ORG Fri May 14 09:48:14 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 59D9F16A4CE for ; Fri, 14 May 2004 09:48:14 -0700 (PDT) Received: from tomts10-srv.bellnexxia.net (tomts10.bellnexxia.net [209.226.175.54]) by mx1.FreeBSD.org (Postfix) with ESMTP id 2E1EA43D5A for ; Fri, 14 May 2004 09:48:11 -0700 (PDT) (envelope-from phil@rootnet.ca) Received: from rnsd ([64.228.32.93]) by tomts10-srv.bellnexxia.net (InterMail vM.5.01.06.05 201-253-122-130-105-20030824) with ESMTP id <20040514164808.EUXQ27206.tomts10-srv.bellnexxia.net@rnsd> for ; Fri, 14 May 2004 12:48:08 -0400 From: "Philip" To: Date: Fri, 14 May 2004 12:48:03 -0400 Organization: root Networks Canada MIME-Version: 1.0 X-Mailer: Microsoft Office Outlook, Build 11.0.5510 Thread-Index: AcQ50yGnWYol8jQ9TaaLdP0b64mVGA== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2096 Message-Id: <20040514164808.EUXQ27206.tomts10-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: 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 16:48:14 -0000 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) | > /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 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 From owner-freebsd-database@FreeBSD.ORG Fri May 14 10:01: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 F031416A4CE for ; Fri, 14 May 2004 10:01:42 -0700 (PDT) Received: from mail.day-light.net (day-light.net [64.37.72.2]) by mx1.FreeBSD.org (Postfix) with ESMTP id 90CCA43D1F for ; Fri, 14 May 2004 10:01:42 -0700 (PDT) (envelope-from john@day-light.com) Received: from w1 (gabriel.day-light.net [69.27.46.22]) by mail.day-light.net (Postfix) with SMTP id CE1BA35299; Fri, 14 May 2004 12:01:41 -0500 (CDT) From: "John Brooks" To: , Date: Fri, 14 May 2004 12:01:42 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 Importance: Normal In-Reply-To: <20040514164808.EUXQ27206.tomts10-srv.bellnexxia.net@rnsd> Subject: RE: Mysql: ERROR 2002: Can't connect to local MySQL server throughsocket '/tmp/mysql.sock' X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: john@day-light.com 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:01:43 -0000 try starting the daemon with the correct user of mysql (uid 88) -- John Brooks john@day-light.com ... > kernel: pid 27201 (mysqld), uid 10**: exited on signal 6 From owner-freebsd-database@FreeBSD.ORG Fri May 14 10:27:43 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 98C6C16A4CE for ; Fri, 14 May 2004 10:27:43 -0700 (PDT) Received: from tomts36-srv.bellnexxia.net (tomts36-srv.bellnexxia.net [209.226.175.93]) by mx1.FreeBSD.org (Postfix) with ESMTP id 4C43643D31 for ; Fri, 14 May 2004 10:27:41 -0700 (PDT) (envelope-from phil@rootnet.ca) Received: from rnsd ([64.228.32.93]) by tomts36-srv.bellnexxia.net (InterMail vM.5.01.06.05 201-253-122-130-105-20030824) with ESMTP id <20040514172738.XMB11251.tomts36-srv.bellnexxia.net@rnsd> for ; Fri, 14 May 2004 13:27:38 -0400 From: "Philip" To: Date: Fri, 14 May 2004 13:27:36 -0400 Organization: root Networks Canada MIME-Version: 1.0 X-Mailer: Microsoft Office Outlook, Build 11.0.5510 Thread-Index: AcQ50yGnWYol8jQ9TaaLdP0b64mVGAABVTsQ X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2096 In-Reply-To: Message-Id: <20040514172738.XMB11251.tomts36-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:27:43 -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) | > /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 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 From owner-freebsd-database@FreeBSD.ORG Fri May 14 10:49:30 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 0A12316A4CE for ; Fri, 14 May 2004 10:49:30 -0700 (PDT) Received: from mail.day-light.net (day-light.net [64.37.72.2]) by mx1.FreeBSD.org (Postfix) with ESMTP id 8DEC643D4C for ; Fri, 14 May 2004 10:49:29 -0700 (PDT) (envelope-from john@day-light.com) Received: from w1 (gabriel.day-light.net [69.27.46.22]) by mail.day-light.net (Postfix) with SMTP id A94DA3529B; Fri, 14 May 2004 12:49:28 -0500 (CDT) From: "John Brooks" To: , Date: Fri, 14 May 2004 12:49:29 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 Importance: Normal In-Reply-To: <20040514172738.XMB11251.tomts36-srv.bellnexxia.net@rnsd> Subject: RE: Mysql: ERROR 2002: Can't connect to local MySQL server throughsocket '/tmp/mysql.sock' X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: john@day-light.com 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:49:30 -0000 seems like your problem is that mysqld will not start, in order to start it must be able to read the files that make up your databases. the directories that hold these files can only be read by the user 'mysql' (look at the directory permissions). mysql uid is normally '88'. you may have other problems also, but until you fix this they cannot be addressed hint: look at the start up script in /usr/local/etc/rc.d to see how to start the daemon as the user 'mysql', (file name should be something like 'mysql-server.sh') -- John Brooks john@day-light.com ... kernel: pid 27201 (mysqld), uid 10**: exited on signal 6 (which is a sigabort) ...