pkg/38111: mysqld use fixed pidfile /var/mysql/xxx.pid

[water%infor-trans.com@localhost]

>Number:         38111
>Category:       pkg
>Synopsis:       mysqld use fixed pidfile /var/mysql/xxx.pid
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    pkg-manager
>State:          open
>Class:          sw-bug
>Submitter-Id:   net
>Arrival-Date:   Wed Feb 27 16:45:00 +0000 2008
>Originator:     Water He
>Release:        4.0_STABLE
>Organization:
ITI
>Environment:
NetBSD s1 4.0_STABLE NetBSD 4.0_STABLE (a64nb4) #0: Mon Feb 11 20:32:27 CST 2008
  water@s1:/usr/world/a64o4/sys/arch/amd64/compile/a64nb4 amd64
>Description:
# in /etc/rc.conf
mysqld=YES mysqld_datadir="/opt/mysql"

I want /opt/mysql/s0.pid, but mysqld still use /var/mysql/s0.pid as pid file.


>How-To-Repeat:
set mysqld_datadir="/opt/mysql" in /etc/rc.conf
>Fix:
re-do
pidfile="${mysqld_datadir}/`/bin/hostname`.pid"

in /etc/rc.d/mysqld, line 83 (after load_rc_config $name)