(RADIATOR) Acct on remote PostgreSQL

deden purnamahadi Wed, 29 Oct 2003 01:30:59 -0800

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/^([EMAIL PROTECTED]).*/$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 [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

(RADIATOR) Acct on remote PostgreSQL

Reply via email to