Hello freeradius-users-request, furlfo> Message: 2 furlfo> From: "apellido jr., wilfredo p." <[EMAIL PROTECTED]> furlfo> To: <[EMAIL PROTECTED]> furlfo> Subject: Simultaneous Login Problem furlfo> This is a multi-part message in MIME format.
furlfo> ------=_NextPart_000_001C_01C472A4.A80947C0 furlfo> Content-Type: text/plain; furlfo> charset="iso-8859-1" furlfo> Content-Transfer-Encoding: quoted-printable furlfo> Hello, im using freeradius-1.0.0-pre3 and postgresql as database = furlfo> backend. I got this error when implemeting Simultaneous Use. Just = furlfo> reading docs( Simultaneous Use) and here's my radgroupcheck... Postgresql Provide You Huge functionality. I don't use Simultaneous Use. I create table in PostrgreSQL database, CREATE TABLE radius.online_users ( session_id varchar(32), unique_id varchar(32), username varchar(32), realm varchar(30), nasipaddress inet, nasportid int4, nasporttype varchar(32), starttime timestamptz, sessiontime int8, acctinputoctets int8, acctoutputoctets int8, calledstationid varchar(50), callingstationid varchar(50), servicetype varchar(32), ipaddress inet, status varchar(32) ) WITH OIDS; Create 2 triggers: CREATE TRIGGER on_insert_radacct AFTER INSERT ON radius.radacct FOR EACH ROW EXECUTE PROCEDURE radius.on_insert_radacct(); CREATE TRIGGER on_update_radacct AFTER UPDATE ON radius.radacct FOR EACH ROW EXECUTE PROCEDURE radius.insert_dialup_cdr(); In that trigger functiuns we, among other things, inserts or delete records from radius.online_users. When new user logs in, radius autorize them, then acccording to Exec-Programm-Wait attribute in radgroupreply table, executing script that calls the storedproc radius.dialupduration(varchar), storedproc checks users ballance and generate Value of Session-Timeout attribute. Ibidem we checks quantity of online users and set value to 0 if online_users >= Max users. May be it is not a very good idea, but it works! -- Best regards, Andrew Motovilov mailto:[EMAIL PROTECTED] - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
