Date: Thu, 14 Jul 2005 15:17:52 -0600 From: Ken Gunderson <kgunders@teamcool.net> To: freebsd-questions@freebsd.org Subject: Re: mysql-4.1.12 errors after portupgrade Message-ID: <20050714151752.4f70d997.kgunders@teamcool.net> In-Reply-To: <20050714234006.GB971@bifteki.lan> References: <20050714110318.439e4ca8.kgunders@teamcool.net> <20050714234006.GB971@bifteki.lan>
next in thread | previous in thread | raw e-mail | index | archive | help
On Thu, 14 Jul 2005 23:40:06 +0000 Tsampros Leonidas <ltsampros@upnet.gr> wrote: > On Thu, Jul 14, 2005 at 11:03:18AM -0600, Ken Gunderson wrote: > > Hello: > > > > This is driving me bonkers! I portupgraded mysql41 to 4.1.12. Now > > mysql won't start from the rc.d/mysql-server.sh, either at startup or > > when I run manually. I didn't change any options in /etc/ > > rc.conf.local. Mysql error logs whine thusly: > > > > [ERROR] Can't find messagefile '/usr/local/share/mysql/english/ > > errmsg.sys' > > > > but the file is indeed present: > > > > kobuk# ll /usr/local/share/mysql/english/errmsg.sys > > -r--r--r-- 1 root wheel 16579 Jul 14 09:51 /usr/local/share/mysql/ > > english/errmsg.sys > > > > To make matters even more interesting, I have an exactly identical > > configuration running on another machine! Only difference is hardware, > > p4 vs p3 and being set thusly in /etc/make.conf. > > > Could you show us the mysql_* section of your /etc/rc.conf.local . > > Also check the last lines of the /usr/local/etc/rc.d/mysql-server.sh > script and check which command is running when you pass the "start" > argument to the script. I've found the exact same problem with yours > on the archives of this list. Here is the link: > > http://lists.freebsd.org/pipermail/freebsd-questions/2004-December/067311.html > Saw that too but don't think it's the same problem. I repeat that this is not a new MySQL install but an upgrade of a working system. And the config is identical to another working system, with exception that cpu p4 vs p3 and fbsd 5.4p3 and 5.4p4, respectively. BUILD_OPTIMIZED=yes was passed during port make but get same results w/ o any flags. Anhow, here's the config. mysql-server.sh is straight out of the ports distribution: . /etc/rc.subr name="mysql" rcvar=`set_rcvar` load_rc_config $name : ${mysql_enable="NO"} : ${mysql_limits="NO"} : ${mysql_dbdir="/var/db/mysql"} : ${mysql_args=""} mysql_user="mysql" mysql_limits_args="-e -U ${mysql_user}" pidfile="${mysql_dbdir}/`/bin/hostname`.pid" command="/usr/local/bin/mysqld_safe" command_args="--defaults-extra-file=${mysql_dbdir}/my.cnf --user= ${mysql_user} --datadir=${mysql_dbdir} --pid-file=${pidfile} ${mysql_args} > /dev/null &" procname="/usr/local/libexec/mysqld" start_precmd="${name}_prestart" mysql_install_db="/usr/local/bin/ mysql_install_db" mysql_install_db_args="--ldata=${mysql_dbdir}" mysql_create_auth_tables() { eval $mysql_install_db $mysql_install_db_args >/dev/null [ $? -eq 0 ] && chown -R ${mysql_user}:${mysql_user} ${mysql_dbdir} } mysql_prestart() { if [ ! -d "${mysql_dbdir}/mysql/." ]; then mysql_create_auth_tables || return 1 fi if checkyesno mysql_limits; then eval `/usr/bin/limits ${mysql_limits_args}` 2>/dev/null else return 0 fi } run_rc_command "$1" /etc/rc.conf.local: mysql_enable="YES" mysql_args="--bind-address=127.0.0.1" but get same results w/o the mysql_args Possible that something with fbsd-p4 borked mysql?? Wouldn't think so else we'd have heard from others.... -- Best regards, Ken Gunderson Q: Because it reverses the logical flow of conversation. A: Why is putting a reply at the top of the message frowned upon?
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20050714151752.4f70d997.kgunders>