From owner-freebsd-database@FreeBSD.ORG Mon Mar 27 06:13:23 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org 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 AD3E716A420 for ; Mon, 27 Mar 2006 06:13:23 +0000 (UTC) (envelope-from peptide1@gmail.com) Received: from pproxy.gmail.com (pproxy.gmail.com [64.233.166.177]) by mx1.FreeBSD.org (Postfix) with ESMTP id 3D99243D4C for ; Mon, 27 Mar 2006 06:13:23 +0000 (GMT) (envelope-from peptide1@gmail.com) Received: by pproxy.gmail.com with SMTP id m51so1087195pye for ; Sun, 26 Mar 2006 22:13:22 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=h70jN6JdInYBC4jnHoEM+tegPoidwWgE2j8ZAfbo83w5VJqFw3JPRRUvOPda44mXTgzZXSWIgTRHtPFaHUJ4VGnspaGYEFpxSlB+rmEb9wuIIxo6YOBnfzwT9bMzSHUbLA1m7oWi62+RQFywuMXGWEJ2g8Ydbc5xxGhFULcFruo= Received: by 10.65.228.1 with SMTP id f1mr2115894qbr; Sun, 26 Mar 2006 22:13:22 -0800 (PST) Received: by 10.65.147.9 with HTTP; Sun, 26 Mar 2006 22:13:22 -0800 (PST) Message-ID: <4b4e1af10603262213g11b0943g1455e9ddb2a4e095@mail.gmail.com> Date: Sun, 26 Mar 2006 22:13:22 -0800 From: "peptide one" To: freebsd-database@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Subject: mysql can't connect 2002 & socket error 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, 27 Mar 2006 06:13:23 -0000 Hello all, I've been scanning these mail lists for a solution and have tried many things, but am still not able to start the MySQL 5.0 database on my FreeBSD 5.4 server. I've been working on this for two days and have never had so many problems getting a database to start. The first thing I did after installation was copy the /support-files/my- medium.cnf to /etc/my.cnf and enter the appropriate information. I also created a "dummy" /tmp/mysql.sock file and configured permissions. I try starting the server as user "mysql" and it fails. Trying to su or login as mysql fails with a 'miscofiguration' error. All this has happened after I've deinstalled and cleaned two previous installations. This is getting to be much more work than it should be. Can anyone help? It would certainly be appreciated. Thanks in advance. From owner-freebsd-database@FreeBSD.ORG Mon Mar 27 06:38:21 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org 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 59EC016A41F for ; Mon, 27 Mar 2006 06:38:21 +0000 (UTC) (envelope-from glenn@mail.more.net) Received: from libby.lpmo.org (libby.lpmo.org [216.106.2.138]) by mx1.FreeBSD.org (Postfix) with ESMTP id 0E9D243D45 for ; Mon, 27 Mar 2006 06:38:20 +0000 (GMT) (envelope-from glenn@mail.more.net) Received: from gkar.earthdome.org (galen.earthdome.org [206.152.117.245]) by libby.lpmo.org (Postfix) with ESMTP id 8A9632841B for ; Mon, 27 Mar 2006 00:37:23 -0600 (CST) Received: by gkar.earthdome.org (Postfix, from userid 503) id 7A47F56DEA9; Mon, 27 Mar 2006 00:37:21 -0600 (CST) Date: Mon, 27 Mar 2006 00:37:21 -0600 From: Glenn Nielsen To: freebsd-database@freebsd.org Message-ID: <20060327063721.GA17259@gkar.earthdome.org> References: <4b4e1af10603262213g11b0943g1455e9ddb2a4e095@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4b4e1af10603262213g11b0943g1455e9ddb2a4e095@mail.gmail.com> User-Agent: Mutt/1.4.2.1i Subject: Re: mysql can't connect 2002 & socket error 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, 27 Mar 2006 06:38:21 -0000 On Sun, Mar 26, 2006 at 10:13:22PM -0800, peptide one wrote: > Hello all, > > I've been scanning these mail lists for a solution and have tried many > things, but am still not able to start the MySQL 5.0 database on my FreeBSD > 5.4 server. I've been working on this for two days and have never had so > many problems getting a database to start. > > The first thing I did after installation was copy the /support-files/my- > medium.cnf > to > /etc/my.cnf > and enter the appropriate information. You don't need a my.cnf file to start mysql. Only if you need to override the defaults. Then you would put it in /var/db/mysql/my.cnf. > I also created a "dummy" /tmp/mysql.sock file and configured permissions. > I try starting the server as user "mysql" and it fails. Trying to su or > login as mysql fails with a 'miscofiguration' error. mysql creates this unix socket when it starts up. > All this has happened after I've deinstalled and cleaned two previous > installations. > > This is getting to be much more work than it should be. > > Can anyone help? It would certainly be appreciated. I can think of two simple things which would prevent the mysql db from starting. After a new install of mysql you must run mysql_install_db to setup the default database tables. Second you have to make sure you have the appropriate entries in your /etc/rc.conf file which tells FreeBSD whether and how it should start mysql. See the /usr/local/etc/rc.d/mysql-server.sh start script. The start script won't start mysql unless /etc/rc.conf is configured for it. This is based on my experience with MySQL 4.1, I would expect it would be the same for MySQL 5. Regards, Glenn ---------------------------------------------------------------------- Glenn Nielsen glenn@more.net | /* Spelin donut madder | MOREnet System Programming | * if iz ina coment. | Missouri Research and Education Network | */ | ----------------------------------------------------------------------