MYSQL and FR2

[Natr Brazell]

I am looking for a good reference on how to integrate MYSQL and Freeradius.
I've set up the basics and imported the schema's and modified the sql.conf
file and the sites-enabled/default files.  All starting and running fine.
What I don't know about are how (if at all) you can log the rad_recv
messages to sql.  For instance my NAS is sending back the following:

*rad_recv: Accounting-Request packet from host x.x.x.120 port 51637, id=50,
length=95
        Acct-Status-Type = Interim-Update
        Acct-Session-Id = "C2594B9A71DB"
        Acct-Delay-Time = 0
        User-Name = "joe.bobuser"
        NAS-Identifier = "M20"
        Juniper-Interactive-Command = "run start shell "
        NAS-IP-Address = x.x.x.120
*+- entering group preacct {...}
++[preprocess] returns ok
[acct_unique] WARNING: Attribute NAS-Port was not found in request, unique
ID MAY be inconsistent
[acct_unique] Hashing ',Client-IP-Address = x.x.x.120,NAS-IP-Address =
x.x.x.120,Acct-Session-Id = "C2594B9A71DB",User-Name = "joe.bobuser"'
[acct_unique] Acct-Unique-Session-ID = "c8c99ca6ea5c67dc".
++[acct_unique] returns ok
[suffix] No '@' in User-Name = "joe.bobuser", looking up realm NULL
[suffix] No such realm "NULL"
++[suffix] returns noop
++[files] returns noop
+- entering group accounting {...}
[detail]        expand:
/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d ->
/var/log/radius/radacct/x.x.x.120/detail-20100607
[detail] /var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d expands
to /var/log/radius/radacct/x.x.x.120/detail-20100607
[detail]        expand: %t -> Mon Jun  7 11:13:24 2010
++[detail] returns ok
++[unix] returns noop
[radutmp]       expand: /var/log/radius/radutmp -> /var/log/radius/radutmp
[radutmp]       expand: %{User-Name} -> joe.bobuser
  rlm_radutmp: No NAS-Port seen.  Cannot do anything.
  rlm_radumtp: WARNING: checkrad will probably not work!
++[radutmp] returns noop
[sql]   expand: %{User-Name} -> joe.bobuser
[sql] sql_set_user escaped user --> 'joe.bobuser'
[sql]   expand: %{Acct-Input-Gigawords} ->
[sql]   ... expanding second conditional
[sql]   expand: %{Acct-Input-Octets} ->
[sql]   ... expanding second conditional
[sql]   expand: %{Acct-Output-Gigawords} ->
[sql]   ... expanding second conditional
[sql]   expand: %{Acct-Output-Octets} ->
[sql]   ... expanding second conditional
[sql]   expand:            UPDATE radacct           SET
framedipaddress = '%{Framed-IP-Address}',              acctsessiontime     =
'%{Acct-Session-Time}',              acctinputoctets     =
'%{%{Acct-Input-Gigawords}:-0}'  << 32 |
'%{%{Acct-Input-Octets}:-0}',              acctoutputoctets    =
'%{%{Acct-Output-Gigawords}:-0}' << 32 |
'%{%{Acct-Output-Octets}:-0}'           WHERE acctsessionid =
'%{Acct-Session-Id}'           AND username        =
'%{SQL-User-Name}'           AND nasipaddress    = '%{NAS-IP-Address}'
->            UPDATE radacct           SET              framedipaddress =
'',              acctsessiontime     = '',              acctinputoctets
= '0'  << 32 |                                    '0',
acctoutputoctets    = '0' << 32 |
'0'           WHERE acctsessionid = 'C2594B9A71DB'           AND
username        = 'joe.bobuser'           AND nasipaddress    =
[sql]   expand: /var/log/radius/sqltrace.sql -> /var/log/radius/sqltrace.sql
rlm_sql (sql): Reserving sql socket id: 0
rlm_sql_mysql: query:             UPDATE radacct           SET
framedipaddress = '',              acctsessiontime     = '',
acctinputoctets     = '0'  << 32 |
'0',              acctoutputoctets    = '0' << 32
|                                    '0'           WHERE acctsessionid =
'C2594B9A71DB'           AND username        = 'joe.bobuser'           AND
nasipaddress    = 'x.x.x.120'
rlm_sql (sql): Released sql socket id: 0
++[sql] returns ok
[attr_filter.accounting_response]       expand: %{User-Name} -> joe.bobuser
 attr_filter: Matched entry DEFAULT at line 12
++[attr_filter.accounting_response] returns updated
Sending Accounting-Response of id 50 to x.x.x.120 port 51637
Finished request 5.
Cleaning up request 5 ID 50 with timestamp +397
Going to the next request
Ready to process requests.
rad_recv: Accounting-Request packet from host x.x.x.120 port 51637, id=51,
length=84
        Acct-Status-Type = Interim-Update
        Acct-Session-Id = "C2594B9A71DB"
        Acct-Delay-Time = 0
        User-Name = "joe.bobuser"
        NAS-Identifier = "M20"
        Juniper-Interactive-Command = "quit "
        NAS-IP-Address = x.x.x.120


...
As can be seen above the rad_recv: section is sending back a few items that
I am interested in having logged.  For instance the
Juniper-Interactive-Command.

Thanks if you can help or point me in the right direction.

N
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20100607/af665c78/attachment.html>