Re: (RADIATOR) Question about Radius and SQL

2002-01-25 Thread 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  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:   [EMAIL PROTECTED]
> 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 a

(RADIATOR) Question about Radius and SQL

2002-01-24 Thread Martin Edge 



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  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. Request is 
ignored. Backing off for 10 secondsFri Jan 25 17:42:28 2002 911157: ERR: 
Execute failed for 'Sp_fetchUserPassword 'clouston'': SQL TimeoutFri Jan 
25 17:42:32 2002 481065: ERR: Execute failed for 'Sp_fetchUserPassword 
'clouston'': SQL TimeoutFri 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, beans2000: 
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. Request is 
ignored. Backing off for 10 secondsFri Jan 25 17:42:50 2002 371277: ERR: 
Execute failed for 'Sp_fetchUserPassword 'office'': SQL TimeoutFri 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, beans2000: 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. Request is 
ignored. Backing off for 10 secondsFri 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, beans2000: 
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. Request is 
ignored. Backing off for 10 secondsFri Jan 25 17:43:21 2002 671671: ERR: 
Execute failed for 'Sp_fetchUserPassword 'simona'': SQL TimeoutFri 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, beans2000: 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. Request is 
ignored. Backing off for 10 secondsFri Jan 25 17:43:39 2002 561994: ERR: 
Execute failed for 'Sp_fetchUserPassword 'themoodies'': SQL TimeoutFri 
Jan 25 17:43:42 2002 501985: ERR: Execute failed for 'Sp_fetchUserPassword 
'themoodies'': SQL TimeoutFri Jan 25 17:43:45 2002 382053: ERR: Execute 
failed for 'Sp_fetchUserPassword 'clouston'': SQL TimeoutFri Jan 25 
17:43:47 2002 972065: ERR: Execute failed for 'Sp_fetchUserPassword 
'clouston'': SQL TimeoutFri Jan 25 17:43:50 2002 742074: ERR: Execute 
failed for 'Sp_fetchUserPassword 'themoodies'': SQL TimeoutFri Jan 25 
17:43:53 2002 321952: ERR: Execute failed for 'Sp_fetchUserPassword 
'themoodies'': SQL TimeoutFri Jan 25 17:43:55 2002 722314: ERR: Execute 
failed for 'Sp_fetchUserPassword 'shields'': SQL TimeoutFri Jan 25 
17:43:58 2002 32217: ERR: Execute failed for 'Sp_fetchUserPassword 
'shields'': SQL TimeoutFri Jan 25 17:44:00 2002 532429: ERR: Execute 
failed for 'Sp_fetchUserPassword 'blp04395'': SQL TimeoutFri Jan 25 
17:44:02 2002 832373: ERR: Execute failed for 
'Sp_fetchUserPassw

-Martin Edge
Technical Services Co-ordinator
Phoneware Online
eMail: [EMAIL PROTECTED]
Phone: +613 9640 4140 ext. 193
 
"In the end, it's speed, price and customer 
service."
-