mysql-server-5.1.19 path variable error created on upgrade
compilation
David Southwell
david at vizion2000.net
Sun Jun 17 15:22:34 UTC 2007
# uname -a
6.1-RELEASE FreeBSD 6.1-RELEASE #0: Sun May 7 04:15:57 UTC 2006
root at bloom.cse.buffalo.edu:/usr/obj/usr/src/sys/SMP amd64
#
Just upgraded mysql to include:
# pkg_info |grep mysql
mysql-client-5.1.19 Multithreaded SQL database (client)
mysql-server-5.1.19 Multithreaded SQL database (server)
p5-DBD-mysql51-4.005 MySQL 5.1 driver for the Perl5 Database Interface (DBI)
php5-mysql-5.2.3 The mysql shared extension for php
#
Seems we have an oddity here after compiling:
Extract from show variables:
show variables;
+---------------------------------+---------------------------------------+
| Variable_name | Value |
+---------------------------------+---------------------------------------+
| basedir | /usr/local/
| character_sets_dir | /usr/local/share/mysql/charsets/ |
| datadir | /usr2/datadb/ |
| general_log_file | /usr2/datadb/dns1.log |
| language | /usr/local/share/mysql/english/ |
| pid_file | /usr2/datadb//dns1.vizion2000.net.pid |
^^----Why '//'
| plugin_dir | /usr/local/lib/mysql |
| slow_query_log_file | /usr2/datadb/dns1-slow.log |
| socket | /tmp/mysql.sock |
So I thought I would:
(a) RESET the variable
mysql> set pid_file = /usr2/datadb/dns1.vizion2000.net.pid ;
ERROR 1193 (HY000): Unknown system variable 'pid_file'
mysql> set GLOBAL pid_file = /usr2/datadb/dns1.vizion2000.net.pid ;
ERROR 1193 (HY000): Unknown system variable 'pid_file'
mysql> set GLOBAL pid_file = '/usr2/datadb/dns1.vizion2000.net.pid' ;
ERROR 1193 (HY000): Unknown system variable 'pid_file'
mysql> set @@GLOBAL pid_file = '/usr2/datadb/dns1.vizion2000.net.pid' ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use
near 'pid_file = '/usr2/datadb/dns1.vizion2000.net.pid'' at line 1
mysql> set @@GLOBAL.pid_file = '/usr2/datadb/dns1.vizion2000.net.pid' ;
ERROR 1193 (HY000): Unknown system variable 'pid_file'
mysql>
But I cannot seem to get the Syntax right - can someone please point me in the
right direction.
(b) Ask why this might be happening.
It might be worth recording that /usr2/ is a seperate physical device and
emphasize that the base-dir is /usr/local/.
Thanks in advance
David
More information about the freebsd-ports
mailing list