And the point of radgroupcheck entry (apart from overwriting the radcheck entry - radcheck entry gets processed first, than radgruopcheck entry overwrites it) is? Remove that entry and store that value somewhere else - not in radius schema. Create an additional table and store such stuff there. Ivan Kalik Kalik Informatika ISP Dana 16/9/2008, "J M Toms" <jmtoms@gmail.com> piše:
Hi All,
I've been using freeradius 1.1.5 for sometime. I use mysql for storing users and I have enabled sqlcounter module for restricitng monthly access time. Each user is member of a group and group's Max-Monthly-Session is set in radgroupcheck table. I have a script which is invoked from cron every month which calculates remaining time of users and does a insert/update/delete on radcheck so that there will be a record in radcheck if the user has any time left from the prevois month. Attribute is Max-Monthly-Session and value = (remaining + group's Max-Monthly-Session). This way I have implemented a session time carry over system.
Recently I have upgraded freeradius to version 2.1.0. Everything is working well as expected other than sqlcounter. In new version it is ignoring the Max-Monthly-Session from radcheck table. I have installed radius in a new server but the same result. The radius debug output and sql table are available at http://pastebin.ca/1204050
Is there any config item for sqlcounter to process radcheck table?
Thanks, JT