RE: [m0n0wall] RE: access for 24 hours after first login? need help

2005-10-12 Thread maruna
06, 2005 7:50 PM To: 'FreeRadius users mailing list' Subject: RE: [m0n0wall] RE: access for 24 hours after first login? It doesn't work on postgresql v7.4.6 that I tried it on.. however, I used SELECT now() - AcctStartTime FROM radacct WHERE UserName = '%{%k}' LIMIT 1; And its ok Thank you

RE: [m0n0wall] RE: access for 24 hours after first login?

2005-10-06 Thread Jonathan De Graeve
] Verzonden: donderdag 6 oktober 2005 15:51 Aan: FreeRadius users mailing list CC: [EMAIL PROTECTED] Onderwerp: [m0n0wall] RE: access for 24 hours after first login? This is how I do this Use SQLcounter module Put this in sqlcounter.conf (expecting that sqlcounter is already configged

RE: [m0n0wall] RE: access for 24 hours after first login?

2005-10-06 Thread maruna
: Thursday, October 06, 2005 3:09 PM To: Jonathan De Graeve; FreeRadius users mailing list Cc: [EMAIL PROTECTED] Subject: RE: [m0n0wall] RE: access for 24 hours after first login? And here the query in case you don't like seconds ;) SELECT HOUR(SEC_TO_TIME(UNIX_TIMESTAMP() - UNIX_TIMESTAMP

RE: [m0n0wall] RE: access for 24 hours after first login?

2005-10-06 Thread Markus Krause
:[EMAIL PROTECTED] Verzonden: donderdag 6 oktober 2005 15:51 Aan: FreeRadius users mailing list CC: [EMAIL PROTECTED] Onderwerp: [m0n0wall] RE: access for 24 hours after first login? This is how I do this Use SQLcounter module Put this in sqlcounter.conf (expecting that sqlcounter is already