Re: Status X User

2009-10-23 Thread Sergio Belkin
2009/10/23 Alexander Clouter : > Sergio Belkin wrote: >> >> Is there a way to get the las time that user got Accept-Accept and >> Accept-Reject, of course I can parse log files but I wonder if there a >> radius tool that can do it. >> > -> SQL > > SELECT * FROM postauth WHERE user_name = '' AND p

Re: Status X User

2009-10-23 Thread Alexander Clouter
Sergio Belkin wrote: > > Is there a way to get the las time that user got Accept-Accept and > Accept-Reject, of course I can parse log files but I wonder if there a > radius tool that can do it. > -> SQL SELECT * FROM postauth WHERE user_name = '' AND packet_type = 'Access-Reject' ORDER BY ti

Status X User

2009-10-23 Thread Sergio Belkin
Hi, Is there a way to get the las time that user got Accept-Accept and Accept-Reject, of course I can parse log files but I wonder if there a radius tool that can do it. Thanks in advance -- -- Open Kairos http://www.openkairos.com Watch More TV http://sebelk.blogspot.com Sergio Belkin - - List

RE: radacct and db handles

2009-10-23 Thread Ademir Klauck
Hi Ivan, I run Server with "radiusd -X > log" and could'n found the same error in log. The only sql fail I found is a Msg reply field: [sql] expand: SELECT id, username, attribute, value, op FROM radrepl y WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT

Re: cannot upgrade 2.1.6 to 2.1.7

2009-10-23 Thread Craig Campbell
o! India Homepage. Click here. -- - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Information from ESET Smart Security, version of virus signature database 4535 (20091023) __ The message was c

Re: FreeRADIUS + Postgresql dies unexpectedly

2009-10-23 Thread Duarte Fonseca
Hi Alan, Thanks for the advice, I've tried the same test with radiusd -f and here are the results Some runs just produce this: # radiusd -f Segmentation fault Others produce a more verbose output, hope it helps: # radiusd -f *** glibc detected *** radiusd: double free or corruption (fasttop):

Re: radacct and db handles

2009-10-23 Thread Alan Buxey
Hi, > I checked my radius db and radacct table and there are many indexed and > nothing I could found is the problem. It only append when I enable radius > accounting in SQL. indexing speeds up queries but slows down inserts/updates. if you do live inserts/updates of accouting records into mysql