Date: Thu, 1 Mar 2007 08:33:16 -0800 (PST) From: Drew Jenkins <drewjenkinsjr@yahoo.com> To: freebsd-ports@freebsd.org Subject: Re: Can't Get MySQL Port Up Message-ID: <826160.30232.qm@web62206.mail.re1.yahoo.com>
next in thread | raw e-mail | index | archive | help
----- Original Message ----=0AFrom: Jeremy Chadwick <koitsu@FreeBSD.org>=0A= To: Drew Jenkins <drewjenkinsjr@yahoo.com>=0ACc: freebsd-ports@freebsd.org= =0ASent: Thursday, March 1, 2007 11:29:26 AM=0ASubject: Re: Can't Get MySQL= Port Up=0A=0A>The fact that you broke /usr/local/include is probably not a= good=0A>thing either. =0A=0ATo clarify, I broke it in one server but not = the other *and* the problem exists on *both* servers. So I don't believe it= 's a factor.=0A=0A>Have you considered doing something like pkg_info,=0A=0A= That command brings up many ports that are not listed in /var/db/ports/*=0A= =0A>making a list of all the packages you have installed, doing=0A>pkg_dele= te -a -f && rm -fr /var/db/ports/*=0A=0AWill that delete *only* the ports l= isted in /var/db/ports/*, or will that delete *all* the ports listed from p= kg_info?=0A=0A>then reinstalling all of the ports in question?=0A=0ATo be a= bsolutely clear, you mean the ports deleted from /var/db/ports/* only, corr= ect? Easy enough to do.=0A=0A>Are you _building_ MySQL or are you using the= package (pre-compiled=0A>binary package)? What version of MySQL are you c= hoosing to use?=0A=0AI am using the port: 5.1 server.=0A=0A>What exactly is= in your my.cnf? This looks suspicious.=0A=0AUm...dunno. I just ran a find= for "*.cnf" and up popped three files (small, med, large) like this:=0A/us= r/local/share/mysql/my-small.cnf=0AI decided to copy this over to /etc/my.c= nf. I left the defaults. I didn't edit it. I ran mysqld_safe again, but got= the same errors.=0A=0A>There is no such table "general_log" in database "m= ysql" in MySQL=0A>4.0 nor 4.1. errno 13 is Permission denied, by the way. = So how is=0A>this table getting loaded?=0A=0ANo idea. Didn't use any beta.= =0A=0A> 070301 6:58:39 [ERROR] /usr/local/libexec/mysqld: Can't create/wri= te to file '/var/db/mysql/server312.web.vi.pid' (Errcode:=0A> 13)=0A=0AThis= also looks indicative of a permissions problem with your=0A/var/db/mysql d= irectory. The directory should be identical in=0Aownership and permissions= to this:=0A=0Adrwx------ 7 mysql mysql 512 26 Feb 09:46 /var/db= /mysql/=0A=0AStrange. I know I changed that once, but the ownership was wro= ng. Fixed that and the folder contents as well. However, the permissions re= ad:=0A=0Adrwxr-xr-x=0A=0AI don't imagine that matters for these purposes, b= ut it could invite a hack. How do I change that? I'm used to +x or whatever= , but here I need numbers, I guess.=0AAlso, doing that and then running mys= qld_safe gave the same error in the error log plus this:=0A=0A^G/usr/local/= libexec/mysqld: Can't find file: './mysql/general_log.frm' (errno: 13)=0A07= 0301 10:25:13 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/= host.frm' (errno: 13)=0A070301 10:25:13 [ERROR] Fatal error: Can't open and= lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)=0A0= 70301 10:25:13 mysqld ended=0A=0ASo, it didn't look for a pid file (nor di= d it create one), and now it is looking for a host file.=0A=0ATIA,=0ADrew= =0A=0A=0A=0A=0A =0A________________________________________________________= ____________________________=0ANow that's room service! Choose from over 1= 50,000 hotels=0Ain 45,000 destinations on Yahoo! Travel to find your fit.= =0Ahttp://farechase.yahoo.com/promo-generic-14795097
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?826160.30232.qm>