Hi Kim,
On Jul 11, 4:05pm, Kim Wilsleff Kristensen wrote:
> Subject: (RADIATOR) accounting
>
> Hi
> Can anyone give me an example of how to log accounting to an
> microsoft SQL-database
Are you running Radiator on NT?
1. Create a database and tables, see the example in goodies/sybaseCreate.sql
2. Create a SQL login and passwrod to access that database
3. Install ODBC
4. Create an ODBC DSN to connect to the databse you made in 1
5. Configure your Radiator something like this:
<Realm DEFAULT>
AuthByPolicy ContinueAlways
# Just save accounting to SQL
<AuthBy SQL>
# Adjust DBSource, DBUsername, DBAuth to suit your DB
DBSource dbi:ODBC:yourdsnname
DBUsername username
DBAuth login
# No authentication
AuthSelect
# You may want to tailor these for your ACCOUNTING table
AccountingTable ACCOUNTING
AcctColumnDef USERNAME,User-Name
AcctColumnDef TIME_STAMP,Timestamp,integer
AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type
AcctColumnDef ACCTDELAYTIME,Acct-Delay-Time,integer
AcctColumnDef ACCTINPUTOCTETS,Acct-Input-Octets,integer
AcctColumnDef ACCTOUTPUTOCTETS,Acct-Output-Octets,integer
AcctColumnDef ACCTSESSIONID,Acct-Session-Id
AcctColumnDef ACCTSESSIONTIME,Acct-Session-Time,integer
AcctColumnDef ACCTTERMINATECAUSE,Acct_Terminate-Cause
AcctColumnDef NASIDENTIFIER,NAS-Identifier
AcctColumnDef NASPORT,NAS-Port,integer
AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
</AuthBy>
# Authenticate from NT (or whatever you like)
<AuthBy NT>
Domain whatever
</AuthBy>
</Realm>
If you want to get to MS-SQL from Unix, check the Radiator FAQ at
http://www.open.com.au/radiator/faq.html
Hope that helps.
Cheers.
--
Mike McCauley [EMAIL PROTECTED]
Open System Consultants Pty. Ltd Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au
Phone +61 3 9598-0985 Fax +61 3 9598-0955
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
NT, Rhapsody
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.