* This is the VOP Radius mailing list * Uh, hmm..err..which part? Trigger syntax is often database specific...I run postgresql.
If you disable UsersOnline, you can no longer do timebanking. If you leave it on, you have the problem with lost STOP records and orphans. a) One trigger has to handle the timebanking. b) Another trigger has to add and delete Users from the session table based upon START and STOP records. VOP won't write interim updates to ODBC. I wish they would because I would take them, update the session table and then throw them away. c) The other trigger has to take failed authentications (often denote by a zero duration STOP record) and then delete from the session table if the originating phone number is the same...the user will dial again and get on. d) Finally, I clear out the session table upon any new entry into it (as good as a cron) whereby the session duration is older than the session limit It's all very annoying. I don't recommend that you do any of this. > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Erik Tijburg > Sent: Tuesday, March 11, 2003 12:24 AM > To: [EMAIL PROTECTED] > Subject: [VOP RADIUS] web-based disconnect > > > * This is the VOP Radius mailing list * > Can you share your DB code? > > Erik L. M. Tijburg > Sr. Engineer > RedMoon Inc. > ISP Support Services > > 6810 Main Street > Frisco TX. 75034 > (972) 731-0696 Ext 604 > > [EMAIL PROTECTED] > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > On Behalf Of Eric Dean > Sent: Monday, March 10, 2003 11:14 PM > To: [EMAIL PROTECTED] > Subject: [VOP RADIUS] web-based disconnect > > > * This is the VOP Radius mailing list * > You may also want to add a function that deletes users after the > session-limit as well as deletes user that authenticate attempt from a > phone number already listed in the UsersOnline table. > > I wound up doing everything with database triggers and views to replace > the UsersOnline function..however, I also had to manually do timebanking > as well. > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] Behalf Of Ron Fitzgerald > > Sent: Monday, March 10, 2003 10:09 PM > > To: [EMAIL PROTECTED] > > Subject: [VOP RADIUS] web-based disconnect > > > > > > * This is the VOP Radius mailing list * > > > > I agree and I use it everyday, but I also need a web-based module with > > > the same functionality as the snap in to use from the web. All > > functions are there except the 'disconnecting of users' or 'kicking'. > > > > Thanks again. > > Ron Fitzgerald > > > > ----- Original Message ----- > > From: "John Blue" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Monday, March 10, 2003 10:09 PM > > Subject: [VOP RADIUS] web-based disconnect > > > > > > > > > > * This is the VOP Radius mailing list * > > > > > > RF> I asked someone why he needed a tarnished 1972 penny once....He > > > RF> answered "do you have it or not?" > > > > > > Yeah. See, the point of the VPPRS snapin is so that you can look in > > > > on what the RADIUS server is doing and if need be .. you know .. > > > actually 'disconnect' a user or two. > > > > > > :) > > > > > > John Blue > > > > > > > > > ** > > > To leave this list, send an email to [EMAIL PROTECTED] > > > and put the word "LEAVE" in the BODY of the email. > > > > > > > > > > > > ** > > To leave this list, send an email to [EMAIL PROTECTED] and > > put the word "LEAVE" in the BODY of the email. > > > > > ** > To leave this list, send an email to [EMAIL PROTECTED] and > put the word "LEAVE" in the BODY of the email. > > > ** > To leave this list, send an email to [EMAIL PROTECTED] > and put the word "LEAVE" in the BODY of the email. > ** To leave this list, send an email to [EMAIL PROTECTED] and put the word "LEAVE" in the BODY of the email.
