First of all, I'm moving this to ports@, therefore cross-posting. If
replying to this, post only to [EMAIL PROTECTED]
Matthew Peltzer wrote:
I just recently installed OpenBSD 3.9 and installed mysql client &
sever via pkg_add. I also added the following lines to rc.local:
if [ X"${mysqld_flags}" != X"NO" ]; then
if [ -x /usr/local/bin/mysqld_safe ]; then
echo -n ' mysqld'; /usr/local/bin/mysqld_safe
${mysqld_flags} &
fi
fi
and this one to rc.conf.local:
mysql_flags=
I've since noticed (initiated by phpMyAdmin reporting there were no
databases installed, not even the default ones) that there are two
mysql process running:
ps -ax | grep mysql
17392 ?? I 0:01.63 /usr/local/libexec/mysqld
--basedir=/usr/local --datadir=/var/mysql --user=_mysql --pid-f
13452 C0- I 0:00.14 /bin/sh /usr/local/bin/mysqld_safe
I had a similar setup on OpenBSD 3.8 some time ago, but did not have
this issue. Is this simply a difference between the two versions?
Can I remove the lines from rc.*local? Where does that first mysqld
process get started from?
mysqld_safe is a script that starts the mysql daemon and restarts it if
it crashes or so, so all is well.
$ pgrep -fl mysql
1544 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/mysql
--user=_mysql --pid-file=/var/mysql/birger.internal.beard.se.pid
--open-files-limit=8192 --socket=/var/www/var/run/mysql/mysql.sock
12262 /bin/sh /usr/local/bin/mysqld_safe
