(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