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 <jden...@redhat.com>
Looking to carve out IT costs?
www.redhat.com/carveoutcosts/
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html