FR3 and MySQL

[Fernando Pizarro]

El 07/07/15 a las 14:36, Andrés Gómez escribió:
> Hi everybody!!
>
> Today I'm testing FR3 in order to migrate some simple FR2 servers.
> In old servers is running a simple configuration usng mysql to match
> username/password with a simple web auth (captive portal).
>
> I installed FR3, then I actived sql mod:
>
> cd mods-enabled
> ln -s ../mods-available/sql
>
> then I configured the sql connection:
>
> sql {
>          driver = "rlm_sql_mysql"
>          server = "localhost"
>          port = 3306
>          login = "MYUSER"
>          password = "MYPASSWORD"
>          radius_db = "radius"
>          acct_table1 = "radacct"
>          acct_table2 = "radacct"
>          postauth_table = "radpostauth"
>          authcheck_table = "radcheck"
>          groupcheck_table = "radgroupcheck"
>          authreply_table = "radreply"
>          groupreply_table = "radgroupreply"
>          usergroup_table = "radusergroup"
>          delete_stale_sessions = yes
> ...
> }
>
> I'm using the same schema that I used to use in FR2.
>
> I created and user in radcheck table, and It works, but I cant write
> accounting data. There is this error:
>
>
> Tue Jul  7 07:23:06 2015 : Auth: (0) Login OK: [andres/andres] (from client
> todos port 0)
> Tue Jul  7 07:23:06 2015 : Error: rlm_sql (sql): Unknown column 'username'
> in 'field list'
> Tue Jul  7 07:23:06 2015 : Error: rlm_sql_mysql: Cannot store result
> Tue Jul  7 07:23:06 2015 : Error: rlm_sql_mysql: MySQL error 'Unknown
> column 'username' in 'field list''
> Tue Jul  7 07:23:27 2015 : Error: rlm_sql (sql): Unknown column
> 'acctupdatetime' in 'field list'
> Tue Jul  7 07:23:27 2015 : Error: rlm_sql_mysql: Cannot store result
> Tue Jul  7 07:23:27 2015 : Error: rlm_sql_mysql: MySQL error 'Unknown
> column 'acctupdatetime' in 'field list''
> Tue Jul  7 07:23:27 2015 : Error: rlm_sql (sql): Unknown column
> 'acctupdatetime' in 'field list'
> Tue Jul  7 07:23:27 2015 : Error: rlm_sql_mysql: Cannot store result
> Tue Jul  7 07:23:27 2015 : Error: rlm_sql_mysql: MySQL error 'Unknown
> column 'acctupdatetime' in 'field list''
> Tue Jul  7 07:23:41 2015 : Error: rlm_sql (sql): Unknown column
> 'acctupdatetime' in 'field list'
> Tue Jul  7 07:23:41 2015 : Error: rlm_sql_mysql: Cannot store result
> Tue Jul  7 07:23:41 2015 : Error: rlm_sql_mysql: MySQL error 'Unknown
> column 'acctupdatetime' in 'field list''
> Tue Jul  7 07:23:41 2015 : Error: rlm_sql (sql): Unknown column
> 'acctupdatetime' in 'field list'
> Tue Jul  7 07:23:41 2015 : Error: rlm_sql_mysql: Cannot store result
> Tue Jul  7 07:23:41 2015 : Error: rlm_sql_mysql: MySQL error 'Unknown
> column 'acctupdatetime' in 'field list''
> Tue Jul  7 07:23:41 2015 : Info: rlm_sql (sql): Closing connection (0),
> from 1 unused connections
> Tue Jul  7 07:23:47 2015 : Error: rlm_sql (sql): Unknown column
> 'acctupdatetime' in 'field list'
> Tue Jul  7 07:23:47 2015 : Error: rlm_sql_mysql: Cannot store result
> Tue Jul  7 07:23:47 2015 : Error: rlm_sql_mysql: MySQL error 'Unknown
> column 'acctupdatetime' in 'field list''
>
> What am I missing?
>
> Thanks a lot!!
>
>
Hi!

Don't use FreeRADIUS v2 schema, username and acctupdatetime columns 
doesn't work.

In mods-config/sql/main there is a folder with schema.sql, setup.sql 
(old admin.sql in v2) and queries.conf files for MySQL databases.

Regards.