Table radacct is empty
Alex M
radiussupport at lrcommunications.net
Thu Mar 23 03:06:44 CET 2006
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.freeradius
.org
[mailto:freeradius-users-bounces+radiussupport=lrcommunications.net at lists.fr
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\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
-
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: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20060322/6cff0929/attachment.obj>
More information about the Freeradius-Users
mailing list