Incorrect MySQL schema?

[John Dennis]

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 at redhat.com>

Looking to carve out IT costs?
www.redhat.com/carveoutcosts/