From owner-freebsd-ports@FreeBSD.ORG Sun Jun 17 15:22:33 2007 Return-Path: X-Original-To: ports@freebsd.org Delivered-To: freebsd-ports@FreeBSD.ORG Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id E866916A480 for ; Sun, 17 Jun 2007 15:22:33 +0000 (UTC) (envelope-from david@vizion2000.net) Received: from dns1.vizion2000.net (77-99-36-42.cable.ubr04.chap.blueyonder.co.uk [77.99.36.42]) by mx1.freebsd.org (Postfix) with ESMTP id A132313C44B for ; Sun, 17 Jun 2007 15:22:33 +0000 (UTC) (envelope-from david@vizion2000.net) Received: by dns1.vizion2000.net (Postfix, from userid 1007) id A74781CC28; Sun, 17 Jun 2007 08:35:19 -0700 (PDT) From: David Southwell Organization: Voice and Vision To: ports@freebsd.org Date: Sun, 17 Jun 2007 08:35:19 -0700 User-Agent: KMail/1.9.6 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200706170835.19465.david@vizion2000.net> Cc: Subject: mysql-server-5.1.19 path variable error created on upgrade compilation X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 17 Jun 2007 15:22:34 -0000 # 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