mysql-4.1.12 errors after portupgrade
Ken Gunderson
kgunders at teamcool.net
Thu Jul 14 21:17:55 GMT 2005
On Thu, 14 Jul 2005 23:40:06 +0000
Tsampros Leonidas <ltsampros at 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?
More information about the freebsd-questions
mailing list