(RADIATOR) Radiator 3.9, Optigold, MySQL

[Bobby Brown, Jr.]

Can I just substitute my Radusers table for my Subscribers table?

And then will I have to modify alot in my .cfg file?

I am a complete newbie in the Radius world, so if these questions seem
stupid please forgive me

Bobby
----- Original Message ----- 
From: "Hugh Irvine" <hugh at open.com.au>
To: "Bobby Brown, Jr." <bobby at ssinternet.com>
Cc: <radiator at open.com.au>
Sent: Friday, July 30, 2004 8:08 PM
Subject: Re: (RADIATOR) Radiator 3.9, Optigold, MySQL



Hello Bobby -

You should create your database according to the schema that Optigold
expects, then configure your Radiator configuration file accordingly.
The AuthBy SQL clause can be set up to query and write accounting
information to any SQL table.

I am not familiar with the Optigold table layout so you should check
with them to get the table definitions.

BTW - we would be keen to receive a copy of this so we could include
the relevant scripts and so on with Radiator.

regards

Hugh


On 31 Jul 2004, at 02:15, Bobby Brown, Jr. wrote:

> I am a complete newbie to the Radius world and am trying to setup
> Radiator with a MySQL database to work with Optigold. I have got
> Radiator and MySQL running on a linux box and authenticating properly
> with the "radpwtst" script, but I've run into a severe problem.
>
> When I created the databse I used the mysqlcreate.sql file from the
> goodies directory and then started with the sql.cfg file for my
> configuration file. It created a basic Radius database that is
> completely different then what i expected. I have a table called
> SUBSCRIBERS that i'm assuming all my dial-up customers will be placed
> into, but my problem is that Optigold has given me all these sql
> events that point to a table called RADUSERS. They are telling me the
> datamodel has changed for the sql database and i'm kinda stuck.
>
> Have I setup my database wrong, and if so how do i set it up?
>
> If it is setup wrong then where do I put all my data?
>
> What data do I put in the DB?
>
> Where do I show my MAXLOGIN at?
>
> Bobby Brown, Jr.
> bobby at ssinternet.com
>

NB: have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.



--
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.