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