accounting on msql

[omega bk]

hi,

just want to manage accounting on mysql

so i coyed the schema.sql in /etc/freeradius,
did mysql -u root -p accounting < schema.sql

and i got this.

*ERROR 1064 (42000) at line 17: 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 '[radacct] (
    [RadAcctId] [numeric](21, 0) IDENTITY (1, 1) NOT NULL ,
    [AcctSessi' at line 1*

i compare the schema.sql  to one at
http://wiki.freeradius.org/MS-SQL_DDL_script , nothing changed.

somebody as a clue?

thanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20100315/aad46ce7/attachment.html>