Bug 164962 - [PATCH] net/freeradius Importing FreeRadius mysql schema choke on SQL syntax
Summary: [PATCH] net/freeradius Importing FreeRadius mysql schema choke on SQL syntax
Status: Closed FIXED
Alias: None
Product: Ports & Packages
Classification: Unclassified
Component: Individual Port(s) (show other bugs)
Version: Latest
Hardware: Any Any
: Normal Affects Only Me
Assignee: Ryan Steinmetz
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-02-10 16:20 UTC by Edward
Modified: 2012-02-19 14:10 UTC (History)
0 users

See Also:


Attachments
file.diff (341 bytes, patch)
2012-02-10 16:20 UTC, Edward
no flags Details | Diff

Note You need to log in before you can comment on or make changes to this bug.
Description Edward 2012-02-10 16:20:07 UTC
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
Comment 1 Michael Scheidell freebsd_committer freebsd_triage 2012-02-15 02:45:05 UTC
State Changed
From-To: open->feedback

Fix Synopsis.
Comment 2 Mark Linimon freebsd_committer freebsd_triage 2012-02-18 00:45:12 UTC
Responsible Changed
From-To: freebsd-ports-bugs->zi

Over to maintainer.
Comment 3 dfilter service freebsd_committer freebsd_triage 2012-02-19 14:01:10 UTC
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"
Comment 4 Ryan Steinmetz freebsd_committer freebsd_triage 2012-02-19 14:01:21 UTC
State Changed
From-To: feedback->closed

Committed. Thanks!