Forget about what I wrote. I was under a (mistaken) impression that you had some idea what you were doing. BTW, if you read the whole sql.conf (helps to do that before you start messing with it) you would know what "check and verify query" is. If you went back to the default sql.conf, then you don't need to change anythig (apart from mysql connection details). Do you have "other" specified as nastype in clents.conf? Replace that with the appropriate vendor. Or just delete stale entries once and if you have reliable connection with the NAS it won't be happening again. Ivan Kalik Kalik Informatika ISP Dana 25/9/2007, "Michael Ziemann" <mailinglist@ziemann-perl.de> piše:
Hi!
The Problem is still there.
Alan:
Ok, I put the start and stop records back to radacct table. But it's the same problem... when I delete the entry with the stop time 0000.00.00 00:00:00 the user can login again.
Ivan:
You wrote: If you are sending stop packets to the stop table you need to point the simultaneous use check and verify queries to it as well.
I already inserted to my MySQL-DB: INSERT INTO radgroupcheck (GroupName, Attribute, op, Value) values("dialup", "Simultaneous-Use", ":=", "1");
is this what you meant? -> I don't know what a "check and verify query" is... this is my first radius / mysql project... i would be happy if you could specifiy your answers for beginners :-D
regards
Michael - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html