FR3 and MySQL

7 Jul 2015

      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!!

-- 
*C. Andrés Gómez R.*