Incorrect MySQL schema?
jdennis at redhat.com
Tue Jul 7 23:46:54 CEST 2009
On 07/07/2009 04:54 PM, Jeanette Lee wrote:
> I have just installed 2.1.6-2 on a Centos 5.3 machine with MySQL 6.0.11.
> When I run the schema.sql to create the radius database tables I get an
> error on the last table, radpostauth about a syntax error:
> # mysql -u root -p radius </etc/raddb/sql/mysql/schema.sql
> Enter password:
> ERROR 1064 (42000) at line 127: 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),
> KEY username (username(32))
> )' at line 6
> If I log in and check the database, all of the tables are created except
> I've googled and read FAQs and everything I could think of, but I can't
> seem to figure this out or find a post from someone who had the same
> problem. Can anyone suggest anything?
The error message is pretty clear, it does not like the length parameter
timestamps are no longer 14 chars long, there is no need to specify the
length, it's implicit (although I imagine a value of 19 might work.
Try removing the (14)
John Dennis <jdennis at redhat.com>
Looking to carve out IT costs?
More information about the Freeradius-Users