(RADIATOR) Acct on remote PostgreSQL

[deden purnamahadi]

Dear all,

Here is my radiator.cfg

---------------------------

Foreground
LogStdout
LogDir          /usr/local/src/Radiator-3.7/log
DbDir           .
#DbDir          /usr/local/srd/Radiator-3.7/raddb
Trace           4

# You will probably want to add other Clients to suit your site.
<Client DEFAULT>
        Secret  mysecret
        DupInterval 0
</Client>

<Realm DEFAULT>
        RewriteUsername s/^([^@]+).*/$1/
#       AcctLogFileName %L/details

        <AuthBy LDAP2>
#               NoDefault
                Version         3
                Host            mail
                Port            389
                AuthDN          cn=root,o=adadeh,c=IX
                AuthPassword    secret
                BaseDN          o=adadeh,c=IX
                UsernameAttr    uid
                PasswordAttr    userPassword
                AddToReply
                        Framed-Protocol = PPP,\
                        Framed-IP-Netmask = 255.255.255.255,\
                        Framed-Routing = None,\
                        Framed-MTU = 1500,\
                        Framed-Compression = Van-Jacobson-TCP-IP
                </AuthBy>


        <AuthBy SQL>
#do the accounting but not authentication
        AuthSelect
        DBSource        dbi:Pg:dbname=radiator;host=192.168.0.193
        DBUsername      post
        DBAuth          post
        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   frameipaddress,Framed-IP-Address

        # You can arrange to log accounting to a file if the
        # SQL insert fails with AcctFailedLogFileName
        # That way you could recover from a broken SQL
        # server

        AcctFailedLogFileName %D/missedaccounting

      </AuthBy>

</Realm>


--------------


I've add radiator host in pg_hba.conf.

There's no error when I start radiusd, but there's no entry on user logged 
on in 'accounting' table.

Anyone can help ??



Warmest regards


ddn

_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE* 
http://join.msn.com/?page=features/junkmail

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