accounting on msql

[Alan Buxey]

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