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
that'd be the Microsoft SQL you've tried using (mssql) > i compare the schema.sql to one at > http://wiki.freeradius.org/MS-SQL_DDL_script , nothing changed. I repeat...that'd be mssql you've just tried using, NOT MySQL. if you want to use MySQL, then please use the MySQL schema, the MySQL commands and please follow the MySQL documentation. not sure where your schema woudl by lying around on you OS... but you can easily grab it from the source - its in the radd/sql/mysql/ directory and has the following line near the top # Database schema for MySQL rlm_sql module # ..then simply use the dialup.conf etc (basically, configure sql.conf and add/uncomment the relevant lines in the default and inner-tunnel virtual servers) alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
