RE: Table radacct is empty

23 Mar 2006


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

-----Original Message-----
From:
freeradius-users-bounces+radiussupport=lrcommunications.net@lists.freeradius
.org
[mailto:freeradius-users-bounces+radiussupport=lrcommunications.net@lists.fr
eeradius.org] On Behalf Of Vincent MARGUERIE
Sent: Thursday, March 23, 2006 12:29 PM
To: freeradius-users@lists.freeradius.org
Subject: Re: Table radacct is empty

freeradius-users-request@lists.freeradius.org a écrit :
...
Send Freeradius-Users mailing list submissions to
  freeradius-users@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@lists.freeradius.org
You can reach the person managing the list at
  freeradius-users-owner@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@wanadoo.fr>
Subject: RE: Table radacct is empty
To: freeradius <freeradius-users@lists.freeradius.org>
Message-ID: <4421F277.7080907@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@lrcommunications.net>
Subject: RE: Table radacct is empty
To: "'FreeRadius users mailing list'"
  <freeradius-users@lists.freeradius.org>
Message-ID: <001c01c64dbb$4dc706f0$e102fe0a@Alexm>
Content-Type: text/plain;	charset="us-ascii"
Did u authorize SQL in accounting section?
-----Original Message-----
From:
freeradius-users-bounces+radiussupport=lrcommunications.net@lists.freeradiu
s
.org
[mailto:freeradius-users-bounces+radiussupport=lrcommunications.net@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@lrcommunications.net>
Subject: RE: Table radacct is empty
To: "'FreeRadius users mailing list'"
  <freeradius-users@lists.freeradius.org>
Message-ID: <003401c64e1e$6f35a590$6500a8c0@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@lists.freeradiu
s
.org
[mailto:freeradius-users-bounces+radiussupport=lrcommunications.net@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@lrcommunications.net>
Subject: RE: Table radacct is empty
To: "'FreeRadius users mailing list'"
  <freeradius-users@lists.freeradius.org>
Message-ID: <001c01c64dbb$4dc706f0$e102fe0a@Alexm>
Content-Type: text/plain;	charset="us-ascii"
Did u authorize SQL in accounting section?
-----Original Message-----
From:
freeradius-users-bounces+radiussupport=lrcommunications.net@lists.freeradiu
s
.org
[mailto:freeradius-users-bounces+radiussupport=lrcommunications.net@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