From owner-freebsd-ports@FreeBSD.ORG Tue Feb 27 18:59:51 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 5F5A516A47B for ; Tue, 27 Feb 2007 18:59:51 +0000 (UTC) (envelope-from drewjenkinsjr@yahoo.com) Received: from web62203.mail.re1.yahoo.com (web62203.mail.re1.yahoo.com [69.147.75.2]) by mx1.freebsd.org (Postfix) with SMTP id 1D13B13C48E for ; Tue, 27 Feb 2007 18:59:50 +0000 (UTC) (envelope-from drewjenkinsjr@yahoo.com) Received: (qmail 37482 invoked by uid 60001); 27 Feb 2007 18:59:50 -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=iwCPAmLp6XtnQLPVwdwKwEaQnp1i7ZEXbrIgYs+rL8WasqRXwp/TMgiww1qh+WQ8Ei6HpnmYncLSrFH6+oldlOJq+B9zp7bLw5BQke4UsdYK6y7GzyuWIG5HHIIuUdwva/TOizqlPtOzfgENvHowxeQQxKVdwskRnY+YLrU2dFk=; X-YMail-OSG: ubeMeMQVM1kkcdVLEFxz.KZiMhnlpHegl5_K8k8tUvNjupcZ0Ws9zkzT9JS20kXJnkeHBu_3OJIRNgzcjvc5AdNqanhkSgAFxWsnRuiqiFM_nL9QgRYnSa27eH6JrBw- Received: from [67.46.93.3] by web62203.mail.re1.yahoo.com via HTTP; Tue, 27 Feb 2007 10:59:50 PST X-Mailer: YahooMailRC/368.8 YahooMailWebService/0.6.132.8 Date: Tue, 27 Feb 2007 10:59:50 -0800 (PST) From: Drew Jenkins To: freebsd-ports@freebsd.org MIME-Version: 1.0 Message-ID: <398767.37256.qm@web62203.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: Problem w/ MySQL 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: Tue, 27 Feb 2007 18:59:51 -0000 Hi;=0AThis perhaps should be directed to the MySQL list (*perhaps*), but I = tried posting twice and it never went up. I successfully installed MySQL fr= om port on both my home server and the new production server I'm building. = Then, stupidly, I taught myself that one can delete actual files when delet= ing symlinks :( I wiped out my entire /usr/local/include dir. Since I had a= duplicate on my home server, whatever I couldn't rebuild by simply rebuild= ing the ports, I just tarballed and replaced on the production server. That= worked grand for everything...except MySQL. It started complaining that it= didn't have permissions for file "ibdata1". However, said file doesn't eve= n exist on my home server, so how could it be part of the port buildout?! S= o, I created said file, gave it the appropriate permissions, and now I have= this error:=0A=0A070227 12:32:00 mysqld started=0AInnoDB: Error: auto-ext= ending data file ./ibdata1 is of a different size=0AInnoDB: 0 pages (rounde= d down to MB) than specified in the .cnf file:=0AInnoDB: initial 640 pages,= max 0 (relevant if non-zero) pages!=0AInnoDB: Could not open or create dat= a files.=0AInnoDB: If you tried to add new data files, and it failed here,= =0AInnoDB: you should now edit innodb_data_file_path in my.cnf back=0AInnoD= B: to what it was, and remove the new ibdata files InnoDB created=0AInnoDB:= in this failed attempt. InnoDB only wrote those files full of=0AInnoDB: ze= ros, but did not yet use them in any way. But be careful: do not=0AInnoDB: = remove old data files which contain your precious data!=0A/usr/local/libexe= c/mysqld: Table 'mysql.general_log' doesn't exist=0A070227 12:32:00 [ERROR]= /usr/local/libexec/mysqld: Can't create/write to file '/var/db/mysql/examp= le.com.pid' (Errcode:=0A13)=0A070227 12:32:00 [ERROR] Can't start server: c= an't create PID file: Permission denied=0A070227 12:32:00 mysqld ended=0A= =0A=0ASo, I created said pid file, gave it the appropriate permissions, tri= ed the command again, and it threw the same error _and_ blew up the pid fil= e! Like it didn't even exist...=0A=0AWhat do?=0ATIA,=0ADrew=0A=0A=0A=0A=0A = =0A________________________________________________________________________= ____________=0ABored stiff? Loosen up... =0ADownload and play hundreds of g= ames for free on Yahoo! Games.=0Ahttp://games.yahoo.com/games/front