Hello Janet -
What data is contained in the AcctFailedLogFileName file? Did it actually
catch the accounting data? Notice that this will only catch accounting stops
as sessions end, and as the debug shows, Radiator will not retry the
connection for 10 minutes (600 seconds) - did you wait that long to see if it
would re-establish?
regards
Hugh
On Tuesday 13 March 2001 15:58, Janet N. del Mundo wrote:
> 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
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
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.
