[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