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 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: How-To-Repeat: mysql -uradius -p radius < /usr/local/share/doc/freeradius/examples/mysql.sql
State Changed From-To: open->feedback Fix Synopsis.
Responsible Changed From-To: freebsd-ports-bugs->zi Over to maintainer.
zi 2012-02-19 14:01:01 UTC FreeBSD ports repository Added files: net/freeradius/files patch-doc__examples__mysql.sql Log: - Remove warning when importing MySQL example script - Do not bump PORTREVISION PR: ports/164962 Submitted by: Edward <myself@rdtan.net> Revision Changes Path 1.1 +11 -0 ports/net/freeradius/files/patch-doc__examples__mysql.sql (new) _______________________________________________ cvs-all@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/cvs-all To unsubscribe, send any mail to "cvs-all-unsubscribe@freebsd.org"
State Changed From-To: feedback->closed Committed. Thanks!