(RADIATOR) Accounting

[Hugh Irvine]

Hello Javaid -

In your situation, I would use DBI and DBD-Sybase, plus the free 
version of Sybase for Linux (www.sybase.com). This is the best 
approach because MS-SQL is just a rebadged Sybase and the Sybase 
client libraries can connect just fine.

Note that you do not need to log in to the NT server itself, you just 
need to log in to the database. You will find the details for the 
DBSource line in section 23 of the manual, but it looks like this:

	<AuthBy SQL>
		DBSource dbi:sybase:server
		.....
	</AuthBy>

where "server" is defined in the Sybase configuration.

There is another alternative altogether which is to just proxy the 
radius requests from the Linux box to a copy of Radiator running on 
NT. Then you would configure Radiator on NT with ODBC directly using 
DBD-ODBC.

And another possibility is to just run Radiator on NT and configure 
your NAS equipment to send the radius requests directly to it.

regards

Hugh



At 18:07 +0500 01/7/2, <jsajjad at mail.cyberaccess.com.pk> wrote:
>Hi Hugh,
>
>Things are confusing here.How could we logon into a NT machine database
>(having MS SQL databse) directly from Linux radiator only by defining
>hostname and database in DBSource clause.As on first level a NT host
>requires its admin passwd for remote logon and then in second level we
>could then enter into its database. Also i have studied radiator's FAQs
>in which section 13 refers a software named 'OpenLink's Multi-Tier ODBC'
>for connecting MS SQL Server from Linux host- let me know what is it.
>Is there any concept of DSN for Linux ODBC like we use on NT machines
>for external database connectivity? Also let me know kindly that
>Radiator's Accounting is valid for both MS SQL 6.5 and 7.0?
>
>On Mon, 2 Jul 2001, Hugh Irvine wrote:
>>
>>  Hello Javaid -
>>
>>  You will find most Perl modules at
>>
>>	www.cpan.org
>>
>>  and you will need to install DBD, DBD for your database, and the
>>  database client libraries on the Radiator host. The database host
>>  will already have all libraries installed when the database was
>>  installed.
>>
>>  hth
>>
>>  Hugh
>>
>>
>>  At 19:02 +0500 01/7/1, <jsajjad at mail.cyberaccess.com.pk> wrote:
>>  >Hi Hugh,
>>  >
>>  >After configuring DBSource parameters, my radiator gives the error message
>>  >"unknown DBSource in radius.cfg" while starting radiusd. May be my
>>  >installed DBD and DBI modules are not working properly.Would
>>  >you let me know the authentic web site for those perl modules for
>>  >downloading and also let me know whether client libraries should be
>>  >intsalled onto Accounting server (SQL server in our case) or onto the
>>  >Radaiator server.
>>  >
>>  >Regards
>>  >Javaid Sajjad
>>  >
>>  >On Sat, 30 Jun 2001, Hugh Irvine wrote:
>>  >
>>  >>
>>  >>  Hello Javaid -
>>  >>
>>  >>  >Hi every body,
>>  >>  >
>>  >>  >I need to know the procedure for how radiator's Accounting 
>>logs could be
>>  >>  >transfered to another server like MS SQL Server ie i am not 
>>interested in
>>  >>  >saving accounting logs in local database like oracle , mysql 
>>onto the same
>>  >>  >machine on which radiator is installed.So how remote database 
>>server could
>>  >>  >be defined and configured  into radiator.Straightforwardly, 
>>could anybody
>>  >>  >tell me that radiator's accounting logs may be sent to a 
>>separate machine
>>  >>  >having MS SQL Server Database? If possible then pls let me know how .
>>  >>
>>  >>  It is very simple to connect to any type of database on a remote
>>  >>  machine, all you have to do is specify a DBSource line that includes
>>  >>  the remote host.
>>  >>
>>  >>  In any case you will need to install the DBI module together with the
>>  >>  DBD module for your database. You will also need the database client
>>  >>  libraries for the database that you have chosen.
>>  >>
>>  >>  Have a look at sections 6.26 and 23 in the Radiator 2.18.2 
>>reference manual.
>>  >>
>>  >>  regards
>>  >>
>>  >>  Hugh
>>  >>
>>  >>
>>  >
>>  >===
>>  >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: I am travelling this week, so there may be delays in our correspondence.

Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.
===
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.