(RADIATOR) Cannot Connect

michael ellidave l dividina davevill at cdo.philcom.com.ph
Tue Sep 18 21:31:37 CDT 2001


Sir,

   I already configured my ODBC and tried to test the connectivity between my radiator and ms sql server. And i still have the following error messages.


Wed Sep 19 10:12:25 2001: ERR: Could not connect to SQL database with DBI->connect dbi:ODBC:SQL Server:radius, radius, raid:  [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (SQL-IM002)(DBD: db_login/SQLConnect err=-1)
Wed Sep 19 10:12:25 2001: ERR: Could not connect to any SQL database. Request is ignored. Backing off for 600 seconds



here's my configuration file:



# You will probably want to change this to suit your site.
<Client DEFAULT>
	Secret	mysecret
	DupInterval 0
</Client>

# You can put client details in a database table
# and get their details from there with something like this:
<ClientListSQL>
	DBSource	dbi:ODBC:MQIS:radius
	DBUsername	radius	
	DBAuth		raid
</ClientListSQL>

# This will authenticate users from SUBSCRIBERS
<Realm DEFAULT>
    <AuthBy SQL>

	# Adjust DBSource, DBUsername, DBAuth to suit your DB

	DBSource	dbi:ODBC:MQIS:radius
	DBUsername	radius
	DBAuth		raid

	# You may want to tailor these for your ACCOUNTING table
	# You can add your own columns to store whatever you like
	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	FRAMEDIPADDRESS,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>

, , 001029200011 ,
e-mail: davevill at cdo.philcom.com.ph


--
Do you VisualMail?

Grab a copy of the best WebMailer right now!

http://www.mintersoft.com/visualmail


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


More information about the radiator mailing list