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:


    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

        # 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

    # Authenticate from NT (or whatever you like)
    <AuthBy NT>
        Domain whatever

If you want to get to MS-SQL from Unix, check the Radiator FAQ at

Hope that helps.


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.

Reply via email to