Thanks for you reply, but I don't understand just one
thing, I have a lot of logs in the directory
/usr/local/var/log/radius/radacct/192.168.2.253/
In this directory I have logs auth-detail-<something>
and reply-detail-<something>. This isn't accounting
information??
Regards,
André Zenun
Thor Spruyt <[EMAIL PROTECTED]> wrote:
1) Please send your mails as PLAIN TEXT!!!
2) You don't have anything in radacct because the NAS
didn't send any
accounting packets (according to your debugging
output)
3) Regarding the 'unknown attribute' error message:
copy the queries as they
appear in the debugging output and paste them at your
mysql prompt
--
Regards,
Thor Spruyt
E: [EMAIL PROTECTED]
W: www.thor-spruyt.com
M: +32 (0)475 67 22 65
Bestel nu uw exemplaar van Operationele verkoop
(Walter Spruyt - Liesbeth
Huysmans) via www.salesguide.be
Ontdek de Telenet Hotspot service op
www.telenet.be/hotspots
----- Original Message -----
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, November 24, 2004 3:14 PM
Subject: radacct table empty
Hello folks, I have done tests and more tests here to
log the accounting
logs in the mysql. I ahev search in the web and found
some tips in how to do
this, but I still does't have success.
In my radiusd.conf in the section regarding accounting
I have this:
accounting {
sql
}
And in the sql.conf file I have this:
sql {
driver = "rlm_sql_mysql"
login = "root"
password = ""
radius_db = "radius"
acct_table1 = "radacct"
acct_table2 = "radacct"
postauth_table = "radpostauth"
authcheck_table = "radcheck"
authreply_table = "radreply"
groupcheck_table = "radgroupcheck"
groupreply_table = "radgroupreply"
usergroup_table = "usergroup"
etc....
}
basically I have the default sql.conf file that was
generated by freeradius
at the compilation.
When I run the radius in debug mode I have the
following output when my user
authenticate.
rad_recv: Access-Request packet from host
192.168.2.253:8314, id=26,
length=66
User-Name = "00045700A43B"
User-Password = "default"
NAS-IP-Address = 192.168.2.253
Service-Type = 0x38
NAS-Identifier = "192"
Processing the authorize section of radiusd.conf
modcall: entering group authorize for request 2
modcall[authorize]: module "preprocess" returns ok for
request 2
rlm_realm: No '@' in User-Name = "00045700A43B",
looking up realm NULL
rlm_realm: No such realm "NULL"
modcall[authorize]: module "suffix" returns noop for
request 2
radius_xlat: '00045700A43B'
rlm_sql (sql): sql_set_user escaped user -->
'00045700A43B'
radius_xlat:& nbsp; 'SELECT
id,UserName,Attribute,Value,op FROM radcheck
WHERE Username = '00045700A43B' ORDER BY id'
rlm_sql (sql): Reserving sql socket id: 1
rlm_sql_mysql: query: SELECT
id,UserName,Attribute,Value,op FROM radcheck
WHERE Username = '00045700A43B' ORDER BY id
radius_xlat: 'SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op
FROM radgroupcheck,usergroup WHERE usergroup.Username
= '00045700A43B' AND
usergroup.GroupName = radgroupcheck.GroupName ORDER BY
radgroupcheck.id'
rlm_sql_mysql: query: SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op
FROM radgroupcheck,usergroup WHERE usergroup.Username
= '00045700A43B' AND
usergroup.GroupName = radgroupcheck.GroupName ORDER BY
radgroupcheck.id
radius_xlat: 'SELECT id,UserName,Attribute,Value,op
FROM radreply WHERE
Username = '00045700A43B' ORDER BY id'
rlm_sql_mysql: query: SELECT
id,UserName,Attribute,Value,op FROM radreply
WHERE Username = '00045700A43B' ORDER BY id
radius_xlat: 'SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op
FROM radgroupreply,usergroup WHERE usergroup.Username
= '00045700A43B' AND
usergroup.GroupName = radgroupreply.GroupName ORDER BY
radgroupreply.id'
rlm_sql_mysql: query: SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op
FROM radgroupreply,usergroup WHERE usergroup.Username
= '00045700A43B' AND
usergroup.GroupName = radgroupreply.GroupName ORDER BY
radgroupreply.id
rlm_sql: unknown attribute
rlm_sql (sql): Error getting data from database
rlm_sql (sql): Released sql socket id: 1
modcall[authorize]: module "sql" returns ok for
request 2
modcall: group authorize returns ok for request 2
rad_check_password: Found Auth-Type Local
auth: type Local
auth: user supplied User-Password matches local
User-Password
radius_xlat: ''
Login OK: [00045700A43B/default] (from client 192 port
0)
Sending Access-Accept of id 26 to 192.168.2.253:8314
Reply-Message := ""
State = 0x313032
Finished request 2
Going to the next request
--- Walking the entire request list ---
Waking up in 6 seconds...
--- Walking the entire request list ---
Cleaning up request 2 ID 26 with timestamp 41a4b27a
Nothing to do. Sleeping until we see a request.
I see that I have basically 2 problems, one is that I
just see SELECT querys
to the mysql and the other is that I have this:
rlm_sql: unknown attribute
rlm_sql (sql): Error getting data from database
Please, if some one could help me to do this I will
appreciate.
Thanks a lot!
André Zenun
Yahoo! Acesso Grátis - Internet rápida e grátis.
Instale o discador agora!
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
_______________________________________________________
Yahoo! Acesso Grátis - Internet rápida e grátis. Instale o discador agora!
http://br.acesso.yahoo.com/
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
