Re: sql and xlat in authorize section

2011-08-26 Thread Sébastien Barbereau
hi thought so at the beginning but I did :) The startup of freeradius shows that the module is loaded (called local-sql.conf): ... Thu Aug 25 16:26:48 2011 : Debug: including configuration file /etc/raddb/modules/files Thu Aug 25 16:26:48 2011 : Debug: including configuration file

Re: sql and xlat in authorize section

2011-08-26 Thread Arran Cudbard-Bell
Here is the module: sql sql_local { database = mysql driver = rlm_sql_${database} server = localhost login = radius password = radius_db = radius-MAB read_groups = no sqltrace = yes

Re: sql and xlat in authorize section

2011-08-26 Thread Sébastien Barbereau
Of course! Didnt instantiate it properly! Thanks! On Fri, Aug 26, 2011 at 9:31 AM, Arran Cudbard-Bell a.cudba...@freeradius.org wrote: Here is the module: sql sql_local { database = mysql driver = rlm_sql_${database} server = localhost login =

sql and xlat in authorize section

2011-08-25 Thread Sébastien Barbereau
Hi, I am trying to do mac authorization as per http://wiki.freeradius.org/Mac-Auth#Mac-Auth+authorisation+by+SSID+SQL In fact my attempt is much simpler as I just have a very simple table containing the mac address of system to accept. My conf looks like that: authorize { ... # newer

Re: sql and xlat in authorize section

2011-08-25 Thread Arran Cudbard-Bell
Means you haven't instantiated your SQL module with the correct instance name. Check that the config block for your SQL is : sql sql_local { } -Arran On 25 Aug 2011, at 16:57, Sébastien Barbereau wrote: Hi, I am trying to do mac authorization as per