Date: Fri, 10 Feb 2012 16:10:53 GMT From: Edward <myself@rdtan.net> To: freebsd-gnats-submit@FreeBSD.org Subject: ports/164962: Importing FreeRadius mysql schema choke on SQL syntax Message-ID: <201202101610.q1AGArQ1087418@red.freebsd.org> Resent-Message-ID: <201202101620.q1AGK78u017075@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>Number: 164962 >Category: ports >Synopsis: Importing FreeRadius mysql schema choke on SQL syntax >Confidential: no >Severity: non-critical >Priority: low >Responsible: freebsd-ports-bugs >State: open >Quarter: >Keywords: >Date-Required: >Class: update >Submitter-Id: current-users >Arrival-Date: Fri Feb 10 16:20:07 UTC 2012 >Closed-Date: >Last-Modified: >Originator: Edward >Release: 9.0 >Organization: >Environment: FreeBSD host.example.com 9.0-RELEASE FreeBSD 9.0-RELEASE #0: Tue Jan 3 07:46:30 UTC 2012 root@farrell.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC amd64 >Description: Hi, While importing freeradius mysql schema at /usr/local/share/doc/freeradius/examples/mysql.sql, got an error # mysql -uradius -p radius < mysql.sql Enter password: ERROR 1064 (42000) at line 123: 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 '(14) NOT NULL, PRIMARY KEY (id) )' at line 6 >How-To-Repeat: mysql -uradius -p radius < /usr/local/share/doc/freeradius/examples/mysql.sql >Fix: This is cause by an syntax error at line 128 of the schema file mysql.sql, removing "(14)" from the line solved the problem. Original erroneous line 128 : date timestamp(14) NOT NULL, Suggested line : date timestamp NOT NULL, Patch attached with submission follows: --- mysql.sql 2012-02-03 10:28:57.000000000 +0800 +++ mysql.sql.backup 2012-02-03 10:07:51.000000000 +0800 @@ -125,7 +125,7 @@ user varchar(64) NOT NULL default '', pass varchar(64) NOT NULL default '', reply varchar(32) NOT NULL default '', - date timestamp NOT NULL, + date timestamp(14) NOT NULL, PRIMARY KEY (id) ) ; >Release-Note: >Audit-Trail: >Unformatted:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?201202101610.q1AGArQ1087418>