Date: Thu, 1 Mar 2007 05:56:27 -0800 (PST) From: Drew Jenkins <drewjenkinsjr@yahoo.com> To: freebsd-ports@freebsd.org Subject: Can't Get MySQL Port Up Message-ID: <195419.94288.qm@web62215.mail.re1.yahoo.com>
next in thread | raw e-mail | index | archive | help
Hi;=0AI am about ready to give up on this port and try the source code...bu=
t I'd really like to work with the port! I built out mysql51-server on both=
my experimental and new production server. I thought I had them both worki=
ng, but maybe my mind's playing tricks on me. I accidentally deleted /usr/l=
ocal/include on my new production server (that I'm still building). I rebui=
lt it successfully by rebuilding all the ports and filling in the blanks wi=
th a tarball of the same dir on my experimental server, which I had built w=
ith the same commands. I have been getting all sorts of errors trying to ru=
n either "mysql" or "/usr/local/bin/mysqld_safe &", the latter giving more =
feedback and the former complaining about a socket binding problem (" Can't=
connect to local MySQL server through socket '/tmp/mysql.sock'"). However,=
when I went to try the same commands on my experimental server, much to my=
surprise I got the exact same errors! The only thing I did to that server =
was run a tar -cvf
command on /usr/local/include and all that would have done is walk the dir=
ectory and read it, so what's causing this problem? Is this port buggy? Bel=
ow is a snip from the error log:=0A=0A070301 06:58:39 mysqld started=0AInn=
oDB: Error: auto-extending data file ./ibdata1 is of a different size=0AInn=
oDB: 0 pages (rounded down to MB) than specified in the .cnf file:=0AInnoDB=
: initial 640 pages, max 0 (relevant if non-zero) pages!=0AInnoDB: Could no=
t open or create data 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=0AInnoDB: to what it was, and remove the new ibdata files InnoD=
B created=0AInnoDB: in this failed attempt. InnoDB only wrote those files f=
ull of=0AInnoDB: zeros, 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^G/usr/local/libexec/mysqld: Can't find file: './mysql/general_log.frm' =
(errno: 13)=0A070301 6:58:39 [ERROR] /usr/local/libexec/mysqld: Can't crea=
te/write to file '/var/db/mysql/server312.web.vi.pid' (Errcode:=0A13)=0A070=
301 6:58:39 [ERROR] Can't start server: can't create PID file: Permission =
denied=0A070301 06:58:39 mysqld ended=0A=0ATIA,=0ADrew=0A=0A=0A=0A=0A =0A_=
___________________________________________________________________________=
________=0A8:00? 8:25? 8:40? Find a flick in no time =0Awith the Yahoo! Sea=
rch movie showtime shortcut.=0Ahttp://tools.search.yahoo.com/shortcuts/#new=
s
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?195419.94288.qm>