(RADIATOR) problems with user file

[james edwards]

LogDir /var/log/radius

# Set this to the database directory. It should contain these files:
# users           The user database
# dictionary      The dictionary for your NAS
DbDir /etc/radiator

Trace 4


RewriteUsername s/^([^\@]+).*/$1/s
RewriteUsername s/[A-Z]/lc($1)/e

<Client 65.19.1.16>
        IdenticalClients 65.19.13.4 65.19.10.10 65.19.16.4 65.19.14.4
65.19.12.5 65.19.47.4 65.19.2.3 65.19.18.4 65.19.15.4 65.19.11.6
65.19.43.4 65.19.32.2 65.19.0.110 216.126.128.8 216.126.128.9 216.126.128.10
216.126.128.11 216.126.128.164 216.126.128.165 216.126.136
.243 66.19.192.194 65.19.5.10 65.19.2.3 65.19.4.14 65.19.11.7 65.19.12.6
65.19.14.5 65.19.43.5 65.19.47.5
        Secret   xxxx
        NasType unknown
        AcctLogFileName %L/%N/detail

</Client>






# For testing: this allows us to honour requests from radpwtst
# on the same host.
<Client localhost>
        Secret abc
        DupInterval 10
</Client>

# This clause handles all users from all realms by looking them up
# in the users file at /usr/local/etc/raddb/users

<Realm DEFAULT>
#       RewriteUsername s/^([a-zA-Z0-9_]+).*/$1/
        AcctLogFileName %L/%N/detail
        RejectHasReason

        <AuthBy SQL>
        DefaultSimultaneousUse 1
        RejectEmptyPassword
        IgnoreAuthentication
        DBSource        dbi:mysql:radius:198.59.109.19
        DBUsername      xxxx
        DBAuth          xxxxx
        AuthSelect
        AccountingTable  ACCOUNTING2
        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
        AcctColumnDef    CALLING_ID,Calling-Station-Id
        </AuthBy>

        <AuthBy FILE>
        DefaultSimultaneousUse 1
                # The filename defaults to %D/users
        </AuthBy>
        # Log accounting to the detail file in LogDir
</Realm>

<AuthBy SYSTEM>
        DefaultSimultaneousUse 1
        Identifier System
        # The filename defaults to %D/users
</AuthBy>



<SessionDatabase SQL>
        DBSource        dbi:mysql:radius:198.59.109.19
        DBUsername      xxxx
        DBAuth          xxxxx
        AddQuery        insert into RADONLINE (USERNAME, NASIDENTIFIER,
NASPORT,\
        ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, NASPORTTYPE, \
        SERVICETYPE, CONNECT_SPEED, CALLED_ID, CALLING_ID\
        ) values ('%u', '%N', 0%{NAS-Port},'%{Acct-Session-Id}',\
        %{Timestamp}, '%{Framed-IP-Address}', '%{NAS-Port-Type}', \
        '%{Service-Type}','%{USR-Connect-Speed}','%{Called-Station-Id}', \
        '%{Calling-Station-Id}')
</SessionDatabase>

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