Hi everyone,
Radiator still times out connecting to the SQL server when we do a month
end purge of old accounting data and our users are unable to
authenticate. I thought by using the 'AcctFailedLogFileName' feature,
the accounting data would default to this flat file and not interrupt
user authentication. However, we just did a purge of old data and I had
to restart Radiator when the purge process was done. What can I do to
avoid this problem?
log file:
---------
Mon Mar 12 07:40:12 2001: ERR: Could not connect to SQL database with
DBI->connect dbi:ODBC:xxxx, xxxxx, xxxxx: [OpenLink][ODBC]exceeded
maximum number of allowed connections (SQL-08004)
[OpenLink][ODBC]Connection rejected by data source (SQL-08004)
[OpenLink][ODBC]exceeded maximum number of allowed connections
(SQL-08004)
[OpenLink][ODBC]Connection rejected by data source (SQL-08004)(DBD:
db_login/SQLConnect err=-1)
Mon Mar 12 07:40:12 2001: ERR: Could not connect to any SQL database.
Request is ignored. Backing off for 600 sec
onds
config file:
------------
<AuthBy SQL>
Identifier SQL
DBSource dbi:ODBC:xxxxx
DBUsername xxxxx
DBAuth xxxxx
AuthSelect select Password, Expiration, SimUse, \
IdleTime, SessionTime, StaticIP \
from USERS where IDENTIFIER = '%n' AND STATUS != 'C'
AuthColumnDef 1, Expiration, check
AuthColumnDef 2, Simultaneous-Use, check
AuthColumnDef 3, Idle-Timeout, reply
AuthColumnDef 4, Session-Timeout, reply
AuthColumnDef 5, Framed-IP-Address, reply
AccountingTable ACCOUNTING
AcctColumnDef IDENTIFIER,User-Name
AcctColumnDef TIME_STAMP,Timestamp,formatted-date,'%m-%d-%Y
%H:%M:%S'
AcctColumnDef DURATION,Acct-Session-Time,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 ACCTTERMINATECAUSE,Acct-Terminate-Cause
# AcctColumnDef NASIDENTIFIER,NAS-Identifier
AcctColumnDef NASIDENTIFIER,NAS-IP-Address
AcctColumnDef NASPORT,NAS-Port,integer
AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
AcctColumnDef CONNECTSPEED,Connect-Info
AcctColumnDef CONNECTSPEED,USR-Connect-Speed
AcctColumnDef CALLERID,Calling-Station-Id
AcctColumnDef POPID,Called-Station-Id
# 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
AcctLogFileFormat %{User-Name};%m-%d-%Y
%H:%M:%S;%{Acct-Session-Time};%{Acct-Status-Type};\
%{Acct-Delay-Time};%{Acct-Session-Id};%{Acct-Terminate-Cause};\
%{NAS-IP-Address};%{NAS-Port};%{Framed-IP-Address};%{Connect-Info};\
%{USR-Connect-Speed};%{Calling-Station-Id};%{Called-Station-Id}
AcctFailedLogFileName %D/missedaccounting.%y%m%d
</AuthBy>
Thank you,
Janet
--
_____________________________________________________
Janet del Mundo
Internet Administrator, Startec Global Communications
135 Chalan Santo Papa Agana, Guam 96910
Email: [EMAIL PROTECTED]
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
