From owner-freebsd-ports@FreeBSD.ORG Thu Mar 1 22:21:25 2007 Return-Path: X-Original-To: freebsd-ports@freebsd.org Delivered-To: freebsd-ports@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id D704E16A403 for ; Thu, 1 Mar 2007 22:21:25 +0000 (UTC) (envelope-from drewjenkinsjr@yahoo.com) Received: from web62210.mail.re1.yahoo.com (web62210.mail.re1.yahoo.com [69.147.75.9]) by mx1.freebsd.org (Postfix) with SMTP id 7FAC513C494 for ; Thu, 1 Mar 2007 22:21:25 +0000 (UTC) (envelope-from drewjenkinsjr@yahoo.com) Received: (qmail 64301 invoked by uid 60001); 1 Mar 2007 22:21:21 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID; b=qaXOK+/kkYqH4rpzmhM/hyKu3oj6htp74b5fynzMSFmApr29Vwyu3m7DhWrSll7I3ty+yISL73UnFmQ1hFGCoG4RGBonMwVF76RzBnCn9p0bYmXODB4ECe0LuhHF9KZzUld2Ig1QSmBaU7lGfZ6QN/6CSTFyADbNXLCCchkeBHA=; X-YMail-OSG: a.BtsFgVM1mfFq78uNai35DWv7zfUgtRktIW2o9.BTZECrGinyVKLAurxrVSjRQ9Omowbt4hpGezJjk8PaaKt9nAJDWe.Qwi_9iOXYBDlDOqwoxJi0xgCU0- Received: from [67.46.93.3] by web62210.mail.re1.yahoo.com via HTTP; Thu, 01 Mar 2007 14:21:21 PST X-Mailer: YahooMailRC/368.8 YahooMailWebService/0.6.132.8 Date: Thu, 1 Mar 2007 14:21:21 -0800 (PST) From: Drew Jenkins To: freebsd-ports@freebsd.org MIME-Version: 1.0 Message-ID: <293676.56569.qm@web62210.mail.re1.yahoo.com> Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Subject: Re: Can't Get MySQL Port Up X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 01 Mar 2007 22:21:26 -0000 ----- Original Message ----=0AFrom: Jeremy Chadwick =0A= To: Drew Jenkins =0ACc: freebsd-ports@freebsd.org= =0ASent: Thursday, March 1, 2007 4:53:45 PM=0ASubject: Re: Can't Get MySQL = Port Up=0A=0AFirst up, thank you very much for your detailed analysis and c= omments. Concerning rebuilding the ports, I don't believe this is necessary= because I have the exact same problems on my home server, and I never dele= ted the /usr/local/include dir on my home server.=0A=0A>So chown mysql:mysq= l /etc/my.cnf && chmod 600 /etc/my.cnf.=0A=0AOkay, I did that.=0A=0A=0A>You= 're missing a ton of necessary tables in /var/db/mysql/mysql, which=0A>are = all required for MySQL to run. Authentication tables, host access=0A>table= s, etc..=0A>=0A>The MySQL startup script /usr/local/etc/rc.d/mysql-server i= s supposed to=0A>create all of these tables for you if the /var/db/mysql/my= sql directory=0A>does not exist (otherwise if it does, it assumes all the n= ecessary=0A>tables exist). The script that creates all the necessary table= s is=0A>/usr/local/bin/mysql_install_db and it comes from the MySQL guys. = The=0A>script is also supposed to fix permissions on /var/db/mysql and frie= nds=0A>-- so the fact that your mysql directory was not fixed up means this= =0A>script didn't run at all, or bailed out for some reason.=0A=0ANo, I hav= e a ton of files in said dir.=0A=0A>Before you installed the port, did you = have an existing /var/db/mysql=0A>directory? =0A=0ANo. This is (was) a cle= an build.=0A=0A>If not, then I'm stumped. =0A=0ADon't be. You led me to re= alize the ownership of /var/db/mysql/mysql was wrong :0 Changed it, cracked= it up, and away she went!=0AThanks!=0ADrew=0A=0A=0A=0A=0A=0A=0A =0A_______= ___________________________________________________________________________= __=0A8:00? 8:25? 8:40? Find a flick in no time =0Awith the Yahoo! Search mo= vie showtime shortcut.=0Ahttp://tools.search.yahoo.com/shortcuts/#news