From owner-freebsd-questions@FreeBSD.ORG Thu Jul 14 21:17:55 2005 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id A75BA16A41C for ; Thu, 14 Jul 2005 21:17:55 +0000 (GMT) (envelope-from kgunders@teamcool.net) Received: from koyukuk.teamcool.net (koyukuk.teamcool.net [209.161.34.19]) by mx1.FreeBSD.org (Postfix) with ESMTP id 1AA0943D45 for ; Thu, 14 Jul 2005 21:17:54 +0000 (GMT) (envelope-from kgunders@teamcool.net) Received: from koyukuk.teamcool.net (localhost [127.0.0.1]) by koyukuk.teamcool.net (TeamCool Rocks) with ESMTP id 0C51511EB6 for ; Thu, 14 Jul 2005 15:17:54 -0600 (MDT) Received: from cochise.teamcool.net (unknown [192.168.1.57]) by koyukuk.teamcool.net (TeamCool Rocks) with ESMTP id B4B8911EA3 for ; Thu, 14 Jul 2005 15:17:53 -0600 (MDT) Date: Thu, 14 Jul 2005 15:17:52 -0600 From: Ken Gunderson To: freebsd-questions@freebsd.org Message-Id: <20050714151752.4f70d997.kgunders@teamcool.net> In-Reply-To: <20050714234006.GB971@bifteki.lan> References: <20050714110318.439e4ca8.kgunders@teamcool.net> <20050714234006.GB971@bifteki.lan> Organization: Teamcool Networks X-Mailer: Sylpheed version 1.9.12 (GTK+ 2.6.7; i386-portbld-freebsd5.4) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV using ClamSMTP Subject: Re: mysql-4.1.12 errors after portupgrade X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 14 Jul 2005 21:17:55 -0000 On Thu, 14 Jul 2005 23:40:06 +0000 Tsampros Leonidas 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?