On 07/07/2009 04:54 PM, Jeanette Lee wrote:

Hi,

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 radpostauth.

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 of (14). see: http://dev.mysql.com/doc/refman/5.0/en/timestamp.html 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@redhat.com> Looking to carve out IT costs? www.redhat.com/carveoutcosts/