(RADIATOR) Question about Radius and SQL

[Hugh Irvine]

Hello Martin -

> Fri Jan 25 17:42:13 2002 32431: ERR: Could not connect to any SQL database.
> Requ est is ignored. Backing off for 10 seconds
> Fri Jan 25 17:42:28 2002 911157: ERR: Execute failed for
> 'Sp_fetchUserPassword ' clouston'': SQL Timeout
> Fri Jan 25 17:42:32 2002 481065: ERR: Execute failed for

The problem shown above is that you can't connect to the database at all.

Also, in the timestamps shown above the number following the year is the 
number of microseconds. It is a six digit number, so the first digit is 
tenths of a second.

Ie: Fri Jan 25 17:42:28 2002 911157: 

the number 911157 is the number of microseconds.

regards

Hugh


On Fri, 25 Jan 2002 18:33, Martin Edge wrote:
> Hey Guys,
>
> Having a few issues, as we are unable to easily find out where the cause of
> the slowdown's we get when a "avalanche" scenario occurs.
>
> (where the amount of requests coming in, is faster than the processing
> power to complete them..)
>
> Is this necessarily an SQL timeout, or could there be other attributing
> factors to these errors:
>
> If so, how would we go about finding these out..
>
> I tried LogMicroseconds in a <Log FILE> routine, and this is the output
> below.. (although I dont see any milliseconds results..)
>
> Thanks for your help,
> Martin
>
>
> ---- snip ----
> Fri Jan 25 17:42:13 2002 32431: ERR: Could not connect to any SQL database.
> Requ est is ignored. Backing off for 10 seconds
> Fri Jan 25 17:42:28 2002 911157: ERR: Execute failed for
> 'Sp_fetchUserPassword ' clouston'': SQL Timeout
> Fri Jan 25 17:42:32 2002 481065: ERR: Execute failed for
> 'Sp_fetchUserPassword ' clouston'': SQL Timeout
> Fri Jan 25 17:42:36 2002 960943: ERR: Could not connect to SQL database
> with DBI ->connect dbi:Sybase:server=notus.izone.net.au;database=nb9901,
> netbeans, beans2 000: timeout at
> /usr/local/lib/perl5/site_perl/5.6.1/Radius/Util.pm line 507.
>
> Fri Jan 25 17:42:36 2002 982364: ERR: Could not connect to any SQL
> database. Req uest is ignored. Backing off for 10 seconds
> Fri Jan 25 17:42:50 2002 371277: ERR: Execute failed for
> 'Sp_fetchUserPassword ' office'': SQL Timeout
> Fri Jan 25 17:42:52 2002 391393: ERR: Could not connect to SQL database
> with DBI ->connect dbi:Sybase:server=notus.izone.net.au;database=nb9901,
> netbeans, beans2 000: timeout at
> /usr/local/lib/perl5/site_perl/5.6.1/Radius/Util.pm line 507.
>
> Fri Jan 25 17:42:52 2002 421577: ERR: Could not connect to any SQL
> database. Req uest is ignored. Backing off for 10 seconds
> Fri Jan 25 17:43:07 2002 361641: ERR: Could not connect to SQL database
> with DBI ->connect dbi:Sybase:server=notus.izone.net.au;database=nb9901,
> netbeans, beans2 000: timeout at
> /usr/local/lib/perl5/site_perl/5.6.1/Radius/Util.pm line 507.
>
> Fri Jan 25 17:43:07 2002 411189: ERR: Could not connect to any SQL
> database. Req uest is ignored. Backing off for 10 seconds
> Fri Jan 25 17:43:21 2002 671671: ERR: Execute failed for
> 'Sp_fetchUserPassword ' simona'': SQL Timeout
> Fri Jan 25 17:43:23 2002 691896: ERR: Could not connect to SQL database
> with DBI ->connect dbi:Sybase:server=notus.izone.net.au;database=nb9901,
> netbeans, beans2 000: timeout at
> /usr/local/lib/perl5/site_perl/5.6.1/Radius/Util.pm line 507.
>
> Fri Jan 25 17:43:23 2002 716376: ERR: Could not connect to any SQL
> database. Req uest is ignored. Backing off for 10 seconds
> Fri Jan 25 17:43:39 2002 561994: ERR: Execute failed for
> 'Sp_fetchUserPassword ' themoodies'': SQL Timeout
> Fri Jan 25 17:43:42 2002 501985: ERR: Execute failed for
> 'Sp_fetchUserPassword ' themoodies'': SQL Timeout
> Fri Jan 25 17:43:45 2002 382053: ERR: Execute failed for
> 'Sp_fetchUserPassword ' clouston'': SQL Timeout
> Fri Jan 25 17:43:47 2002 972065: ERR: Execute failed for
> 'Sp_fetchUserPassword ' clouston'': SQL Timeout
> Fri Jan 25 17:43:50 2002 742074: ERR: Execute failed for
> 'Sp_fetchUserPassword ' themoodies'': SQL Timeout
> Fri Jan 25 17:43:53 2002 321952: ERR: Execute failed for
> 'Sp_fetchUserPassword ' themoodies'': SQL Timeout
> Fri Jan 25 17:43:55 2002 722314: ERR: Execute failed for
> 'Sp_fetchUserPassword ' shields'': SQL Timeout
> Fri Jan 25 17:43:58 2002 32217: ERR: Execute failed for
> 'Sp_fetchUserPassword 's hields'': SQL Timeout
> Fri Jan 25 17:44:00 2002 532429: ERR: Execute failed for
> 'Sp_fetchUserPassword ' blp04395'': SQL Timeout
> Fri Jan 25 17:44:02 2002 832373: ERR: Execute failed for 'Sp_fetchUserPassw
> -----------------------------------------
> Martin Edge
> Technical Services Co-ordinator
> Phoneware Online
> eMail:  <mailto:Martin.Edge at phoneware.net.au> Martin.Edge at phoneware.net.au
> Phone: +613 9640 4140 ext. 193
>
> "In the end, it's speed, price and customer service."
> -----------------------------------------

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