Search Again: Re: OptiGold ==> MySQL ==> VOP-Radius From: Shawn Hogan Date: Monday, February 2, 2004 Time: 3:31:35 pm Phillip Blancher - Digital Networks wrote: > I have been vested with writing all of the SQL statements for our install of > Opti-Gold to write certain information to MySQL. This is so VOP-Radius can > pull from MySQL an authenticate, and track usage. > > I have a couple of questions: > > 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. The SQL based usage pulling can be defined under Maintenance & Preferences -> General Preferences -> 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. All events should be done as new style events... and they are all defined (including billing cycle events) under Maintenance & Preferences -> Server Events Setup -> New Style Events - Shawn ---------------------------------- Shawn D. Hogan President, Digital Point Solutions http://www.digitalpoint.com (858) 452-3696 --------------------------------------------------- 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