(RADIATOR) Converting from Livingston user files to Radmin

[Nacho Paredes]

Hello,

Thanks four your reply Hugh.

buildSQL works great, but convert just deals with Username and Password, and
I need to process check and reply items for each user, so I'll try to do
this part myself.

I've been digging in Radmin code and structure, and I've found out some
issues I would like you to tell me if I am right about them:

I'm starting with a SUBSCRIBERS table where I have the following columns:
User, Password, Check-items and Reply-items
I want to redistribute this information over the Radmin structure, so I'll
do this:

For each row in SUBSCRIBERS
	With User and Password I can populate the USERNAME and PASS_WORD
columns in RADUSERS.
	For each element in Check-items (where an element is something like
Attribute=Value)
		I have to populate de RADCONFIG table, so I will:
		Lookup in RADATTRS: ATTR_ID and VENDOR_ID where
NAME=Attribute
		I've seen that ITEM_TYPE in RADCONFIG is a sequencial number
where (0-9999) means check-item and (10000-) means reply-item
		At this point I can populate ATTR_ID, ITEM_TYPE, NAME,
VENDOR_ID in RADCONFIG, so I just have to set the value of the attribute. I
guess that the IVALUE column means a numeric value and the SVALUE column
means a string value, but is this related to the TYPE column in RADATTRS?
(what does mean that TYPE column?)
	For each element in Reply-items (I'll do the same in the previous
step)
		
This is roughly what I want to do, but I've seen some special cases, for
example, if I have a Framed-IP-Address in the Reply-items of a SUBSCRIBERS
record, I could put it in the STATICADDRESS of RADUSERS instead of putting
it in RADCONFIG. Is this true or am I missing something?

Please, tell me if my guessings are right.

Is in some place documented the Radmin SQL structure and its usage? 

Thanks for your attention.

Regards

-----Original Message-----
From: Hugh Irvine [mailto:hugh at open.com.au] 
Sent: jueves, 05 de mayo de 2005 3:37
To: Nacho Paredes
Cc: radiator at open.com.au
Subject: Re: (RADIATOR) Converting from Livingston user files to Radmin


Hello Nacho -

There is the "buildSQL" utility included with Radiator and the "convert"
utility included with Radmin.

I have in the past used the "buildSQL" utility to load a Livingston user
file (or a password file) into a Radiator database, then used the "convert"
script from Radiator to Radmin. Alternatively you could modify the
"buildSQL" utility to load the data directly into the Radmin database.

regards

Hugh



On 4 May 2005, at 20:41, Nacho Paredes wrote:

> Hi all,
>
> I've got a bunch of Livingston user files that I should convert to 
> Radmin format, and before I start coding a conversion script I would 
> like to know if somebody has made something similar before or there 
> exists any tool or starting point that helps me.
>
> Thanks on advance.
>
> Regards.
>
> --------------------------------------------------------------------
> Ignacio Paredes               |  email: iparedes at eurocomercial.es
> Eurocomercial I&C, S.A.       |  Tel: +34 98 5195703
> Ezcurdia, 194 - Gijon (AS)    |  Fax: +34 98 5132596
> --------------------------------------------------------------------
>
>
> --
> 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.
>
>

NB:

Have you read the reference manual ("doc/ref.html")?
Have you searched the mailing list archive
(www.open.com.au/archives/radiator)?
Have you had a quick look on Google (www.google.com)?
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.