[RADIATOR] when accounting server reject the connection?
Alfred Alinazar
alfred at kccg.com
Sun Jan 25 07:04:09 CST 2009
Dear All,
I have 2 radius radiator.
Both of the configuration are the same.
And here is the configuration for the handler:
------------------------------- start config ---------
<Handler NAS-Port-Type=xDSL|Ethernet>
MaxSessions 1
AuthByPolicy ContinueWhileReject
<AuthBy SQL>
NoDefault
Identifier ASQL_DSL_encrypt_DSL
DBSource dbi:ODBC:radiusodbc
DBUsername ****
DBAuth ****
AuthSelect select radpassword,timeleft,AddToReply from
vw_pospauth where username='%n' and servicetype='DSL'
AuthColumnDef 0,Encrypted-Password,check
AuthColumnDef 1,Session-Timeout,reply
AuthColumnDef 2,GENERIC,reply
AccountingStopsOnly
AccountingTable PospAccountingTable2
AcctColumnDef USERNAME,User-Name
AcctColumnDef logofftime,Timestamp,integer-date
AcctColumnDef logofftime_stamp,Timestamp
AcctColumnDef Acctsessiontime,Acct-Session-Time,integer
AcctColumnDef AcctDelayTime,Acct-Delay-Time,integer
AcctColumnDef AcctTerminateCause,Acct-Terminate-Cause
AcctColumnDef EventTimeStamp,Event-Timestamp,integer
AcctColumnDef NASIDENTIFIER,NAS-Identifier
AcctColumnDef AcctSessionID,Acct-Session-Id
AcctColumnDef NASIPAddress,NAS-IP-Address
AcctColumnDef PPPoEDescription,Unisphere-Pppoe-Description
AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
AcctColumnDef
IngressPolicyName,Unisphere-Ingress-Policy-Name
AcctColumnDef EgressPolicyName,Unisphere-Egress-Policy-Name
AcctColumnDef CallingStationID,Calling-Station-Id
AcctColumnDef
AcctInputGigawords,Acct-Input-Gigawords,integer
AcctColumnDef AcctInputOctets,Acct-Input-Octets,integer
AcctColumnDef
AcctOutputGigawords,Acct-Output-Gigawords,integer
AcctColumnDef AcctOutputOctets,Acct-Output-Octets,integer
AcctColumnDef
UnisphereInputGigapkts,Unisphere-Input-Gigapkts,integer
AcctColumnDef
AcctOutputPackets,Acct-Output-Packets,integer
AcctColumnDef NASPortType,NAS-Port-Type
AcctColumnDef NASPORT,NAS-Port,integer
AcctColumnDef NASPortID,NAS-Port-Id
AcctColumnDef SERVER,'rd02'
</AuthBy>
</Handler>
------------------------------- end config
However, I'm using the server1 as primary authentication and secondary
accounting.
The server2 is for primary accounting and secondary authentication.
A few day ago, the server2 was unable to connect to the SQL server due to
virus attack.
It gave an error:
---------------------
Jan 19 15:05:02 2009: ERR: Could not connect to SQL database with
DBI->connect dbiDBC:radiusodbc, a3_00, a3_00: [Microsoft][ODBC SQL Server
Driver][TCP/IP Sockets]SQL Server does not exist or access denied.
(SQL-08001)
----------------------
Because of that, all users authenticated is not appear on radonline table.
How to prevent this to be happening in the future?
Thanks in advance for your help.
Regards,
-Alfred-
More information about the radiator
mailing list