Table radacct is empty

Alex M radiussupport at lrcommunications.net
Thu Mar 23 19:47:51 CET 2006


I dono, maybe it is some error in 1.1.1 ? Im still runnin 1.1.0 and didn’t
have any problems like this yet

-----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: Thursday, March 23, 2006 12:29 PM
To: freeradius-users at lists.freeradius.org
Subject: Re: Table radacct is empty

freeradius-users-request at lists.freeradius.org a écrit :

>Send Freeradius-Users mailing list submissions to
>	freeradius-users at lists.freeradius.org
>
>To subscribe or unsubscribe via the World Wide Web, visit
>	http://lists.freeradius.org/mailman/listinfo/freeradius-users
>or, via email, send a message with subject or body 'help' to
>	freeradius-users-request at lists.freeradius.org
>
>You can reach the person managing the list at
>	freeradius-users-owner at lists.freeradius.org
>
>When replying, please edit your Subject line so it is more specific
>than "Re: Contents of Freeradius-Users digest..."
>
>
>Today's Topics:
>
>   1. RE: Table radacct is empty (Vincent MARGUERIE)
>   2. RE: Table radacct is empty (Alex M)
>
>
>----------------------------------------------------------------------
>
>Message: 1
>Date: Thu, 23 Mar 2006 01:57:27 +0100
>From: Vincent MARGUERIE <vi.marguerie at wanadoo.fr>
>Subject: RE: Table radacct is empty
>To: freeradius <freeradius-users at lists.freeradius.org>
>Message-ID: <4421F277.7080907 at wanadoo.fr>
>Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
>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.freeradiu
s
>.org
>[mailto:freeradius-users-bounces+radiussupport=lrcommunications.net at lists.f
r
>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
>
>
>
>
>------------------------------
>
>Message: 2
>Date: Wed, 22 Mar 2006 21:06:44 -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: <003401c64e1e$6f35a590$6500a8c0 at Alexm>
>Content-Type: text/plain; charset="us-ascii"
>
>Well, it seams that u have everything.... and if radius starts properly
that
>should work.. I'm attaching file that works, try it first and then do all
>the adjustments u need. It set to do ONLY authentication and accounting....
>it's for v1.1.0
>
>
>-----Original Message-----
>From:
>freeradius-users-bounces+radiussupport=lrcommunications.net at lists.freeradiu
s
>.org
>[mailto:freeradius-users-bounces+radiussupport=lrcommunications.net at lists.f
r
>eeradius.org] On Behalf Of Vincent MARGUERIE
>Sent: Wednesday, March 22, 2006 7:57 PM
>To: freeradius
>Subject: RE: Table radacct is empty
>
>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\00
0
>\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.freeradiu
s
>.org
>[mailto:freeradius-users-bounces+radiussupport=lrcommunications.net at lists.f
r
>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
>
>
>- 
>List info/subscribe/unsubscribe? See
>http://www.freeradius.org/list/users.html
>-------------- next part --------------
>A non-text attachment was scrubbed...
>Name: radiusd.conf
>Type: application/octet-stream
>Size: 64618 bytes
>Desc: not available
>Url :
https://list.xs4all.nl/pipermail/freeradius-users/attachments/20060322/6cff0
929/radiusd.obj
>
>------------------------------
>
>- 
>List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
>
>
>End of Freeradius-Users Digest, Vol 11, Issue 93
>************************************************
>---------------------------------------------------------------------------
------------
>Wanadoo vous informe que cet  e-mail a ete controle par l'anti-virus mail. 
>Aucun virus connu a ce jour par nos services n'a ete detecte.
>
>
>
>
>  
>
Thanks a lot for your radiusd.conf file but it still doesn't work and I 
have no idea about it. There's nothing that put me on the way in the log 
(see attached file). Any sql request seems to be done to radacct 
table....only to radpostauth

It makes me crazy !!!

Remain that I use freeradius 1.1.1

Regards,
Vincent





More information about the Freeradius-Users mailing list