Need Help - Radiator/MySQL & Optigold

Re: Need Help - Radiator/MySQL & Optigold

From:

Date:

Time:

Not to be rude or anything to any of these "how do I..." but this list is
for requests and problems with Optigold, not radiator (they have their own
list). I've been tempted to post replies, but find it a little strange for
someone that wants to run an ISP doesn't have basic skills of using sql
queries to modify a database. Maybe you should solicit the services of
contracted help (I'm available) or do a little research or their own. If you
have the manual for OG, Mysql, and Radiator, that should be sufficient to
answer any of these questions. (IAS in win2k is not a very good idea imho).

No insult intended.

Zack

Systems Admin

ZTJ Limited

Zack@ztjlimited.com

_____

From: isp-list@optigold.com [mailto:isp-list@optigold.com] On Behalf Of
ISD-Mail
Sent: Tuesday, August 03, 2004 5:16 AM
To: 'Optigold ISP List'
Subject: RE: [Optigold ISP] Need Help - Radiator/MySQL & Optigold

Does anyone help me how to integrate iptigold ISP to the Radius or IAS with
W2K server?

_____

From: isp-list@optigold.com [mailto:isp-list@optigold.com] On Behalf Of
Bobby Brown, Jr.
Sent: Monday, August 02, 2004 10:27 PM
To: Optigold ISP List
Subject: Re: [Optigold ISP] Need Help - Radiator/MySQL & Optigold

Does anyone have a layout for the structure of the SQL database? I can make
Radiator use whatever tables I wante, but I need the proper layout that
Optigold needs. A *.sql file would be wonderful, but a simple text layout
would be great.

Bobby Brown, Jr.

----- Original Message -----

From: Bobby Brown, <mailto:bobby@ssinternet.com> Jr.

To: isp-list@optigold.com

Sent: Friday, July 30, 2004 1:07 PM

Subject: [Optigold ISP] Need Help - Radiator/MySQL & Optigold

I have looked all over the place and haven't found much help besides the
guys at DP that have been really helpful on this matter.

We are a new ISP and are needing to setup a completely fresh
Radiator/MySQL/OptiGold system. Shawn has helped us get OG ready, and we
have Radiator authenticating from a MySQL database. Our problem is that we
used the default configuration and database for a generic MySQL/Radiator
setup, and all the tables in the DB are different then what i've been told
to look for.

The DB has no RADUSERS table at all, but instead has a SUBSCRIBERS table
with completely different fields.

Has anyone successfully setup a OG/RADv.3.9 system yet, and if so did you
modify the events in OG or did you modify the tables and settings in
Radiator?

Bobby Brown, Jr.
bobby@ssinternet.com

Sales:
888/4-DPOINT

Support:
858/452-3696