(RADIATOR) Radiator 3.9, Optigold, MySQL

[Bobby Brown, Jr.]

Optigold is telling me there is no actual structure they require, but rather
I just need to modify my events so that they update the existing tables that
already exist within Radiator.  The following is a list of fields that they
had me updating before they realized the tables had changed:

RADUSERS
.....ADDEDDATE
.....BADLOGINS
.....EMAIL
.....FULLNAME
.....MAXLOGINS
.....PASS_WORD
.....USERNAME
.....VALIDFROM
.....VALIDTO

I'm assuming all I have to do to create a new user is to make a new enty in
my SUBSCRIBERS table.  This isn't a problem with OptiGold, but I do have a
few questions.  In the SUBSCRIBERS table there are 6 fields.  Some of them I
understand and some I do not.

The USERNAME and PASSWORD fields are straight forward and easy, but the
ENCRYPTEDPASSWORD field is puzzling me as to how to generate it from
optigold.  The command I use to send the username and password are a simple
"INSERT INTO SUSCRIBERS (USERNAME, PASSWORD) VALUES (username,password)",
but how do i send something to be encrypted?

What exactly are the CHECKATTR and REPLYATTR fields for, and should they
always be the same?

What is TIMELEFT and how do I calculate it?

The only other issue I will have is how to set my MAXLOGINS.  Without
setting this field how can I suspend a customer.  From what Optigold told me
I could just set my MAXLOGINS to 0 to have them suspended.  This could be
very useful if i set it up so my customers can login more than once.  What
other solutions are there?

Bobby Brown, Jr.
bobby at ssinternet.com

----- 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


--
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.