'; 'radiator@open.com.au'
Asunto: RE: [RADIATOR] SQL Timeout
There is also other post about the same issue :
http://www.open.com.au/pipermail/radiator/2011-April/017237.html
-Mensaje original-
De: Ricardo Martinez [mailto:rmarti...@redvoiss.net] Enviado el: lunes, 19
de noviembre de 2012 18:36
: [RADIATOR] SQL Timeout
There is also other post about the same issue :
http://www.open.com.au/pipermail/radiator/2011-April/017237.html
-Mensaje original-
De: Ricardo Martinez [mailto:rmarti...@redvoiss.net] Enviado el: lunes, 19
de noviembre de 2012 18:36
Para: 'Heikki
is.
Thanks,
Heikki
Regards,
Ricardo.-
-Mensaje original-
De: Ricardo Martinez [mailto:rmarti...@redvoiss.net]
Enviado el: lunes, 19 de noviembre de 2012 18:50
Para: 'Heikki Vatiainen'; 'radiator@open.com.au'
Asunto: RE: [RADIATOR] SQL Timeout
There is also other post about
Hello,
I’m trying to Backoff an SQL query to my database whenever a timeout
happened. I have the next configuration in my radius_auth.cfg :
Handler NAS-IP-Address = 10.0.0.82, Service-Type = SIP-Caller-AVPs
RewriteUsername s/^([^@]+).*/$1/
AuthBy GROUP
looks like your first AuthBy SQL is answering accept. is this maybe
because you don't have any 'check' options at all? Then if accept,
never process the AuthBy FILE because of ContunueWhileIgnore.
For example, maybe you need at least one check option:
AuthColumnDef 1, Encrypted-Password,
...@vianet.ca]
*Enviado el:* lunes, 19 de noviembre de 2012 16:28
*Para:* Ricardo Martinez
*CC:* radiator@open.com.au
*Asunto:* Re: [RADIATOR] SQL Timeout
looks like your first AuthBy SQL is answering accept. is this maybe
because you don't have any 'check' options at all? Then if accept, never
process
I miss the change : ContinueWhileIgnore for ContinueWhileReject
*De:* Michael [mailto:ri...@vianet.ca]
*Enviado el:* lunes, 19 de noviembre de 2012 16:28
*Para:* Ricardo Martinez
*CC:* radiator@open.com.au
*Asunto:* Re: [RADIATOR] SQL Timeout
looks like your first AuthBy SQL is answering
Martinez
*CC:* radiator@open.com.au mailto:radiator@open.com.au
*Asunto:* Re: [RADIATOR] SQL Timeout
looks like your first AuthBy SQL is answering accept. is this maybe
because you don't have any 'check' options at all? Then if accept,
never process the AuthBy FILE because
I’m doing 3 or even 4 querys for each one and keeps connecting to the mySQL
server and not doing the BackOff.
The Timeout parameter seems to be very clear about the behavior :
*5.31.4 Timeout*
This optional parameter specifies a timeout interval in seconds that
Radiator will wait
for when
On 11/19/2012 10:47 PM, Ricardo Martinez wrote:
Question : When it says “…Radiator will wait for when trying to contact
the SQL server…” this means that a */select/* is a CONTACT???
Hello Ricardo,
there is a contact before the select. The contact succeeds but the
subsequent query (DELYREQ)
de noviembre de 2012 18:21
Para: radiator@open.com.au
Asunto: Re: [RADIATOR] SQL Timeout
On 11/19/2012 10:47 PM, Ricardo Martinez wrote:
Question : When it says .Radiator will wait for when trying to
contact the SQL server. this means that a */select/* is a CONTACT???
Hello Ricardo
'
Asunto: RE: [RADIATOR] SQL Timeout
Is there another more safe way to do the BackOff. What I'm trying to do
is when a SQLquery is Timeout by Radiator mark the server as down and do
the next AuthBy Clause.
I saw a pair of question about the same issue near 2002 :
http://www.open.com.au/pipermail
Hello Griff -
The first thing to check is the MySQL logs to see what is happening
with the database.
Then you should probably turn on LogMicroseconds (requires Time-HiRes
from CPAN) to see how long the queries are taking and what is happening
when the problem occurs. It sounds like there
Hello,
I've noticed that about every 3 hours, I get an error message in my
logfile:
Tue Oct 22 02:03:03 2002: ERR: do failed for 'insert into dialupusage
(username, session_id, router_ip, date, session_time, ip_address,
phone)
values
('level3', '123410-22',
Message-
From: Hugh Irvine [mailto:hugh;open.com.au]
Sent: 21 October 2002 02:51
To: Chris Cronje
Cc: [EMAIL PROTECTED]
Subject: Re: (RADIATOR) SQL Timeout vs SQL Could not Connect
Hello Chris -
Could you please clarify what you mean by shuts down immediately?
And could you also please send me
easier to check: use
"top" on Unix or else Task Manager in NT.
Dave
-Original Message-
From: Janet N. del Mundo [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 5:16 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: (RADIATOR) SQL Timeout when purging ACCOUN
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
Hi Hugh,
The missedaccounting file contained just the accounting stop records.
Yes, I waited for about 30 mins. and authentication requests started to
be rejected. That's when I had to restart Radiator. What can I do to
not interrupt the users authentication? Would it make any difference if
Hello Janet -
On Wednesday 14 March 2001 09:15, Janet N. del Mundo wrote:
Hi Hugh,
The missedaccounting file contained just the accounting stop records.
Yes, I waited for about 30 mins. and authentication requests started to
be rejected. That's when I had to restart Radiator. What can I
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
Hi,
I have just started evaluating radiator and am using its demo version
at the mement and my users database is created on Remote Oracle
database...am facing two problems..firstly i'm getting sql timeout and
secondly the radius process just dies out after every request and i have
to restart
Hello Faez -
On Fri, 24 Nov 2000, Faez Itrat wrote:
Hi,
I have just started evaluating radiator and am using its demo version
at the mement and my users database is created on Remote Oracle
database...am facing two problems..firstly i'm getting sql timeout and
secondly the radius process
Title: RE: (RADIATOR) SQL Timeout
Hello Hugh,
Many thanks for the given information...
The questions below can be useful to go a bit further and solve this Problem:
What are the exact conditions, when the Radioator sends TimeOut Error Message?
How does the Radioator communicate
Hello Emin -
On Thu, 29 Jun 2000, Emin TAHRALI wrote:
Hello Hugh,
Many thanks for the given information...
The questions below can be useful to go a bit further and solve this
Problem:
What are the exact conditions, when the Radioator sends TimeOut Error
Message?
When there is
Title: SQL Timeout SNMP Query
Hi,
We are using two radiators working simultaneously, and AuthBy SQL authentication.
We have some troubles with SQL Timeout Problem.
The Error Logs are as below:
1. Error Log of 1st Radiator
Sun Jun 25 13:31:13 2000: ERR: do failed for 'delete from
Hello Emin -
On Wed, 28 Jun 2000, Emin TAHRALI wrote:
Hi,
We are using two radiators working simultaneously, and AuthBy SQL
authentication.
We have some troubles with SQL Timeout Problem.
The Error Logs are as below:
1. Error Log of 1st Radiator
Sun Jun 25 13:31:13 2000: ERR: do
Title: SQL Timeout!
Hi all,
I am facing the SQL Timeout problem. We user Oracle 8i as the DB , Radiator 2.15.
Hugh can you send me the conditions that Radiator sends SQL Tiemout message.
Also I need a debug patch that will give me a level 5 trace that will be activated when the SQL
Hello Beth -
On Tue, 02 May 2000, Beth Morgan wrote:
Hi all,
We are running Radiator 2.15, using mysqld Ver 3.22.29 for
freebsdelf3.3. Every week or so I am having to reboot the machine when
it stops wanting to authenticate because of a SQL timeout. Here's what
the log says:
Hi all,
We are running Radiator 2.15, using mysqld Ver 3.22.29 for
freebsdelf3.3. Every week or so I am having to reboot the machine when
it stops wanting to authenticate because of a SQL timeout. Here's what
the log says:
--
Mon May 1 16:15:18 2000: ERR: do failed for 'insert into
Hello Andrew -
On Wed, 29 Dec 1999, Andrew Kaplan wrote:
I am still plagued with Radiator failing to authenticate. We had problems
today. The log shows a bunch of SQL timeout errors at the same time. Any
idea as to what is the problem.
If you are trying to authenticate from SQL and the
On Tue, Dec 28, 1999 at 05:50:44PM -0500, Andrew Kaplan wrote:
I am still plagued with Radiator failing to authenticate. We had problems
today. The log shows a bunch of SQL timeout errors at the same time. Any
idea as to what is the problem.
If it's a regular problem, perhaps leave
31 matches
Mail list logo