re: updating session-timeout attribute in MySql db through Radius
Hello! I'm working on a prepaid public internet access system. And I would like to be able to update the value of the Session-Timeout attribute in the MySQL database through freeRadius, as opposed to just a direct SQL statement to the MySQL server. The reason for wanting to do this is so that if a user only used half of their allotted time, then they would be able to login at another time and still have the other half of their time (stored by the Session-Timeout attribute). Is this possible? Many thanks in advance for any help, Simon. _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: updating session-timeout attribute in MySql db through Radius
That`s simple: Add another SQL module, that You would use in accounting section. The query on accounting stop would update the Session-Timeout appropriately. Comment out other queries in this added module. All info is in sql.conf - copy that file, modify queries, and include in radiusd.conf that modified file. I haven`t tried it - maybe You don`t need to add another module, just add another query after semicolon. Greetings Marcin Mak - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
