Hi, I'm trying to adjust a configuration problem on an old server that uses radiator. Actually I have:
<Handler Called-Station-Id = PPPoE1, Acct-Status-Type=Start> AuthBy auth1 AuthBy auth2 SessionDatabase SDBpppoe_start </Handler> <AuthBy SQL> Identifier auth1 AccountingStartsOnly DBSource dbi:mysql:radius:X.Y.Z.W DBUsername radius DBAuth xxxxxxxx DBSource dbi:mysql:radius:X.Y.Z.K DBUsername radius DBAuth yyyyyyy AuthSelect AcctSQLStatement update SUBSCRIBERS_PPPOE set AUTHCOUNTER=AUTHCOUNTER+1 where USERNAME='%n' </AuthBy> <AuthBy SQL> Identifier auth2 DBSource dbi:mysql:radius:a.b.c.d <- Different db respect to auth1!! DBUsername radius DBAuth xxxxxxxxx AccountingTable ACCOUNTING DateFormat %Y-%m-%d %T AcctColumnDef USERNAME,User-Name AcctColumnDef TIME_STAMP,Timestamp,integer-date 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, char HandleAcctStatusTypes Start,Stop,Alive </AuthBy> Actually auth2 Doesn't write Start request in the Db. It works only for Stop and Alive. Please, someone can help me? Thank you
_______________________________________________ radiator mailing list radiator@open.com.au http://www.open.com.au/mailman/listinfo/radiator