Date: Sun, 17 Jun 2007 08:35:19 -0700 From: David Southwell <david@vizion2000.net> To: ports@freebsd.org Subject: mysql-server-5.1.19 path variable error created on upgrade compilation Message-ID: <200706170835.19465.david@vizion2000.net>
next in thread | raw e-mail | index | archive | help
# uname -a =A06.1-RELEASE FreeBSD 6.1-RELEASE #0: Sun May =A07 04:15:57 UTC 2006 =A0 = =A0=20 root@bloom.cse.buffalo.edu:/usr/obj/usr/src/sys/SMP =A0amd64 # 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 =A0 =A0The mysql shared extension for php # Seems we have an oddity here after compiling: Extract from show variables: show variables; +---------------------------------+---------------------------------------+ | Variable_name =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 | Value =A0 =A0 =A0 =A0= =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 | +---------------------------------+---------------------------------------+ | basedir =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 | /usr/local/ =A0 | character_sets_dir =A0 =A0 =A0 =A0 =A0 =A0 =A0| /usr/local/share/mysql/ch= arsets/ =A0 =A0 =A0| =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 | datadir =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 | /usr2/datadb/ = =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 | | general_log_file =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| /usr2/datadb/dns1.log = =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 | | language =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| /usr/local/shar= e/mysql/english/ =A0 =A0 =A0 | | pid_file =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| /usr2/datadb//d= ns1.vizion2000.net.pid | =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0= =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0^^----Why '//' | plugin_dir =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| /usr/local/lib/my= sql =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| | slow_query_log_file =A0 =A0 =A0 =A0 =A0 =A0 | /usr2/datadb/dns1-slow.log = =A0 =A0 =A0 =A0 =A0 =A0| | socket =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| /tmp/mysql.so= ck =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 | So I thought I would: (a) RESET the variable mysql> set pid_file =3D /usr2/datadb/dns1.vizion2000.net.pid ; ERROR 1193 (HY000): Unknown system variable 'pid_file' mysql> set GLOBAL pid_file =3D /usr2/datadb/dns1.vizion2000.net.pid ; ERROR 1193 (HY000): Unknown system variable 'pid_file' mysql> set GLOBAL pid_file =3D '/usr2/datadb/dns1.vizion2000.net.pid' ; ERROR 1193 (HY000): Unknown system variable 'pid_file' mysql> set @@GLOBAL pid_file =3D '/usr2/datadb/dns1.vizion2000.net.pid' ; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual= =20 that corresponds to your MySQL server version for the right syntax to use=20 near 'pid_file =3D '/usr2/datadb/dns1.vizion2000.net.pid'' at line 1 mysql> set @@GLOBAL.pid_file =3D '/usr2/datadb/dns1.vizion2000.net.pid' ; ERROR 1193 (HY000): Unknown system variable 'pid_file' mysql> =A0 But I cannot seem to get the Syntax right - can someone please point me in = the=20 right direction. (b) Ask why this might be happening. It might be worth recording that /usr2/ is a seperate physical device and=20 emphasize that the base-dir is /usr/local/. Thanks in advance David
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200706170835.19465.david>