Search Again: Re: OptiGold ==> MySQL ==> VOP-Radius From: Phillip Blancher - Digital Networks Date: Tuesday, February 3, 2004 Time: 9:27:58 am The SQL Hooks are done, thank you all. I guess what I am looking for updating MySQL is this. We have 4 dial-up packages, 4 residental ADSL packages and 4 business ADSL packages for service. Client A signs up for Dialup package one, but changes his mind after 3 weeks and wants to go up in package. I need an event to change MySQL to update the tables so VOP Radius can know what to do. Which even do I use? I thought of using a generic to do what I need, but I can only associate one plan to an event, and only have 4 generic events. Thanks, Phil ----- Original Message ----- From: "ISP List" <isp-list@tulsaconnect.com> To: "Optigold ISP List" <isp-list@optigold.com> Sent: Monday, February 02, 2004 6:45 PM Subject: Re: [Optigold ISP] OptiGold ==> MySQL ==> VOP-Radius > > >1) I have been programming the new server events, for inserting data to > >MySQL. The table that tracks usage (onlineusers) is written to by VOP-Radius > >(according to the Sysadmin here) and I need to know how to pull the data > >into Opti-Gold for Accounting to charge users who are on timed-accounts. > > Maint & Prefs -> General Prefs -> Usage -> SQL Hooks > > >2) In setting up plans, I added a server action for updating the > >authentication table in MySQL for the new plan. When I added the server > >action it stated it would be an old-style server action. When I go into > >Billing Info in OG and change someone's package, how do I get OG to trigger > >the server events to modify MySQL. Am I doing this Bass-Ackwards or am I on > >the right track. > > You should use only New-style server actions. Other than that, you are on > the right track. > > > --------------------------------------- > Mike Bacher / mike@sparklogic.com > SparkLogic Development / ISP Consulting > Use OptiGold ISP? Check out OptiSkin! > http://www.sparklogic.com/optiskin/ > --------------------------------------- > > > --------------------------------------------------- > To subscribe, unsubscribe or to search list archive > please visit http://www.optigold.com/lists/isp.html > --------------------------------------------------- > --------------------------------------------------- To subscribe, unsubscribe or to search list archive please visit http://www.optigold.com/lists/isp.html ---------------------------------------------------

Messages In This Thread: OptiGold ==> MySQL ==> VOP-Radius by Phillip Blancher - Digital Networks on Feb 2, 2004 at 11:29:53 am Re: OptiGold ==> MySQL ==> VOP-Radius by WMOL Admin on Feb 2, 2004 at 3:23:59 pm Re: OptiGold ==> MySQL ==> VOP-Radius by Shawn Hogan on Feb 2, 2004 at 3:31:35 pm Re: OptiGold ==> MySQL ==> VOP-Radius by ISP List on Feb 2, 2004 at 3:45:45 pm Re: OptiGold ==> MySQL ==> VOP-Radius by Phillip Blancher - Digital Networks on Feb 3, 2004 at 9:27:58 am Re: OptiGold ==> MySQL ==> VOP-Radius by Sean Cook on Feb 3, 2004 at 10:30:17 am Re: OptiGold ==> MySQL ==> VOP-Radius by Shawn Hogan on Feb 3, 2004 at 11:11:09 am Re: OptiGold ==> MySQL ==> VOP-Radius by Phillip Blancher - Digital Networks on Feb 3, 2004 at 11:21:46 am Re: OptiGold ==> MySQL ==> VOP-Radius by Shawn Hogan on Feb 3, 2004 at 11:30:30 am Re: OptiGold ==> MySQL ==> VOP-Radius by Phillip Blancher - Digital Networks on Feb 3, 2004 at 11:44:16 am Re: OptiGold ==> MySQL ==> VOP-Radius by Shawn Hogan on Feb 3, 2004 at 11:49:55 am