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
Michael Ziemann wrote:
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.
And what do you see when you run the server in debugging mode? Did you read ALL of sql.conf, and configure everything needed for simultaneous-use checking? Did you read radiusd.conf? Alan DeKok.
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
participants (3)
-
Alan DeKok -
Michael Ziemann -
tnt@kalik.co.yu