Table radacct is empty

[Vincent MARGUERIE]

Hi,

Yes, SQL is ok to query in accounting section. Here is a part of my radiusd.conf :

#  The rlm_sql_log module appends the SQL queries in a log
        #  file which is read later by the radsqlrelay program.
        #
        #  This module only performs the dynamic expansion of the
        #  variables found in the SQL statements. No operation is
        #  executed on the database server. (this could be done
        #  later by an external program) That means the module is
        #  useful only with non-"SELECT" statements.
        #
        #  See rlm_sql_log(5) manpage.
        #
        sql_log {
                path = ${radacctdir}/sql-relay
                acct_table = "radacct"
                postauth_table = "radpostauth"

                Start = "INSERT INTO ${acct_table} (AcctSessionId, UserName, \
                 NASIPAddress, FramedIPAddress, AcctStartTime, AcctStopTime, \
                 AcctSessionTime, AcctTerminateCause) VALUES                 \
                 ('%{Acct-Session-Id}', '%{User-Name}', '%{NAS-IP-Address}', \
                 '%{Framed-IP-Address}', '%S', '0', '0', '');"
                Stop = "INSERT INTO ${acct_table} (AcctSessionId, UserName,  \
                 NASIPAddress, FramedIPAddress, AcctStartTime, AcctStopTime, \
                 AcctSessionTime, AcctTerminateCause) VALUES                 \
                 ('%{Acct-Session-Id}', '%{User-Name}', '%{NAS-IP-Address}', \
                 '%{Framed-IP-Address}', '0', '%S', '%{Acct-Session-Time}',  \
                 '%{Acct-Terminate-Cause}');"
                Alive = "INSERT INTO ${acct_table} (AcctSessionId, UserName, \
                 NASIPAddress, FramedIPAddress, AcctStartTime, AcctStopTime, \
                 AcctSessionTime, AcctTerminateCause) VALUES                 \
                 ('%{Acct-Session-Id}', '%{User-Name}', '%{NAS-IP-Address}', \
                 '%{Framed-IP-Address}', '0', '0', '%{Acct-Session-Time}','');"

                Post-Auth = "INSERT INTO ${postauth_table}                   \
                 (user, pass, reply, date) VALUES                            \
                 ('%{User-Name}', '%{User-Password:-Chap-Password}',         \
                 '%{reply:Packet-Type}', '%S');"
        }

......
......
$INCLUDE  ${confdir}/sql.conf
......
......
authorize {

	sql
...
...
accounting {
	sql
	sql_log
....
....
session
	sql
....
....
post-auth {
	sql
	sql_log
....
....


Moreover, the information are written in a file (sql-relay) which (is I have understand correctly) is used by the radsqlrelay binary to put the information in database.

The fact is that for the post-auth part, it works bacause i get all the information of the post authorisation in the "radpostauth" table. But in this sql-relay file, there's only information about post-auth...nothing about accounting !!

The strange thing is that there's some informations about accounting in others file "auth-detail" and "reply-detail", but not in sql format.

some lines of the files :

"sql-relay"

INSERT INTO radpostauth                                  (user, pass, reply, date) VALUES                                        ('joseph', 'Chap-Password',                     'Access-Accept', '2006-03-21 15:28:48');

-----------------

"reply-detail"

Packet-Type = Access-Accept
Wed Mar 22 18:04:18 2006
        Framed-Protocol = PPP
        Framed-IP-Address = 255.255.255.254
        Framed-IP-Netmask = 255.255.255.0
        Framed-MTU = 10000
        Framed-Compression = Van-Jacobson-TCP-IP
        Service-Type = Login-User
        Session-Timeout = 1000
        Idle-Timeout = 500
        Port-Limit = 10
        Reply-Message = "Bye Mr Joseph !"
        MS-MPPE-Recv-Key = 0x315cddbc0724d537fdb446a4fc50756d12cc3b005e452caeafe6e867a8a273da
        MS-MPPE-Send-Key = 0x99246dc1071a72f26b069f36cf13c4c865705471f3dbd0dfa1515615affd3004
        EAP-Message = 0x03090004
        Message-Authenticator = 0x00000000000000000000000000000000
        User-Name = "joseph"

------------------

"auth-detail"

Packet-Type = Access-Request
Wed Mar 22 17:46:52 2006
        User-Name = "joseph"
        Framed-MTU = 1400
        NAS-Port-Type = Wireless-802.11
        NAS-Port = 0
        NAS-Identifier = "default\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000\000"
        Calling-Station-Id = "00-12-f0-4f-19-26"
        EAP-Message = 0x0201000b016a6f73657068
        NAS-IP-Address = 192.168.0.50
        Message-Authenticator = 0x3796599b7cebc6895c6a57f7444cccfc
        Client-IP-Address = 192.168.0.50
-------------------
Best regards,
Vincent


------------------------------

Message: 3
Date: Wed, 22 Mar 2006 09:17:08 -0500
From: "Alex M" <radiussupport at lrcommunications.net>
Subject: RE: Table radacct is empty
To: "'FreeRadius users mailing list'"
	<freeradius-users at lists.freeradius.org>
Message-ID: <001c01c64dbb$4dc706f0$e102fe0a at Alexm>
Content-Type: text/plain;	charset="us-ascii"

Did u authorize SQL in accounting section?




-----Original Message-----
From:
freeradius-users-bounces+radiussupport=lrcommunications.net at lists.freeradius
.org
[mailto:freeradius-users-bounces+radiussupport=lrcommunications.net at lists.fr
eeradius.org] On Behalf Of Vincent MARGUERIE
Sent: Wednesday, March 22, 2006 4:14 AM
To: freeradius
Subject: Table radacct is empty

Hi,

I've installed freeradius 1.1.1 on a Debian Sarge distribution, and the 
connection works fine with my wireless windows XP client but I have a 
problem to get information into radacct table in my mysql database.

Does anyone get solution for this ?

Rq : I use a Dlink-DWL-2000AP+  as Acces Point

Regards,
Vincent
- 
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html