(RADIATOR) SQL server fallback behaviour

[Hugh Irvine]

Hello Alexander -

Thanks for sending the configuration and log files.

The Timeout parameter should specify the length of time to wait for a 
response.

I have copied this mail to Mike for his comments.

regards

Hugh


On Tuesday, July 30, 2002, at 01:02 AM, alexander.deboer at kpn.com wrote:

> Dear all,
>
> Using Radiator in a high-availability environment, I encounter a 
> somewhat
> random delay time before Radiator proceeds after a SQL-server failure.
>
> I'm using Radiator-3.1 with two SQL databases: if the Master DB fails,
> Radiator falls back to the Slave DB.
>
> The trace 4 logging below is produced using radpwtst after disabling the
> connection between Radiator and the primairy database server.
>
> After failing the "select" query, Radiator waits most of time 46 seconds
> (sometimes it takes even longer) before checking the SQL connection and
> falling back to the secondary database server.
>
> What is the origin of this delay time (46 seconds)? Can I shorten it? Is
> anybody familiar with this behaviour?
>
> Thanks in advance,
>
> Alexander de Boer
>
>
> <AuthBy SQL>
> 	Identifier sqlAuth
>
> 	#master database
> 	DBSource dbi:mysql:radiusaccess:x.x.x.x:3306
> 	DBUsername ***
> 	DBAuth ***
> 	Timeout 10
>
> 	#slave database
> 	DBSource dbi:mysql:radiusaccess:y.y.y.y:3306
> 	DBUsername ***
> 	DBAuth ***
> 	Timeout 10
> 	
> 	AuthSelect select Tele_password, concat("Framed-IP-Address = ",
> Tele_ipaddress) as Tele_ipaddress from tblTeleAccess where
> ((Tele_username='%u') AND (Tele_active='1'))	
>
> 	AuthColumnDef 0, User-Password, check
> 	AuthColumnDef 1, GENERIC, reply
> 	
> 	#Radiator will never look for a DEFAULT user
> 	NoDefault
> 	
> 	#The AuthBy SQL clause sends default an Accounting Response, no
> logging
>
> </AuthBy>
>
>
> <Handler Realm=service1>
>
>     	AuthBy sqlAuth
> 	
> #	AuthLog myAuthlogger
> #	PasswordLogFileName %L/Password-AAA01.log
>
> 	AcctLogFileName %L/Acct-AAA01-%Y-%m-%d.log
> 	AcctLogFileFormat %o, %{User-Name}, %{Framed-IP-Address}, \
> 		%{NAS-Identifier}, %{Acct-Status-Type}, %{Acct-Session-Time}
>
> </Handler>
>
>
>
> Trace 4 logging:
>
> *** Received from 127.0.0.1 port 1153 ....
> Code:       Access-Request
> Identifier: 208
> Authentic:  1234567890123456
> Attributes:
> 	User-Name = "h6-1 at service1"
> 	Service-Type = Framed
> 	NAS-IP-Address = 203.63.154.1
> 	NAS-Port = 1234
> 	Called-Station-Id = "123456789"
> 	Calling-Station-Id = "987654321"
> 	NAS-Port-Type = Async
> 	User-Password =
> "<152><234>=<207><203>>e<246><188>8<9><160><216>}x<153>"
>
> Fri Jul 26 15:47:43 2002: DEBUG: Handling request with Handler
> 'Realm=service1'
> Fri Jul 26 15:47:43 2002: DEBUG:  Deleting session for h6-1 at service1,
> 203.63.154.1, 1234
> Fri Jul 26 15:47:43 2002: DEBUG: Handling with Radius::AuthSQL
> Fri Jul 26 15:47:43 2002: DEBUG: Handling with Radius::AuthSQL: sqlAuth
> Fri Jul 26 15:47:43 2002: DEBUG: Query is: select Tele_password,
> concat("Framed-IP-Address = ", Tele_ipaddress) as Tele_ipaddress from
> tblTeleAccess where ((Tele_username='h6-1 at service1') AND 
> (Tele_active='1'))
>
> Fri Jul 26 15:48:29 2002: ERR: Execute failed for 'select Tele_password,
> concat("Framed-IP-Address = ", Tele_ipaddress) as Tele_ipaddress from
> tblTeleAccess where ((Tele_username='h6-1 at service1') AND
> (Tele_active='1'))': MySQL server has gone away
> Fri Jul 26 15:48:52 2002: ERR: Could not connect to SQL database with
> DBI->connect dbi:mysql:radiusaccess:x.x.x.x:3306, ***, ***:  Can't 
> connect
> to MySQL server on 192.168.87.11 (10065)
> Fri Jul 26 15:48:52 2002: DEBUG: Radius::AuthSQL looks for match with
> h6-1 at service1
> Fri Jul 26 15:48:52 2002: DEBUG: Radius::AuthSQL ACCEPT:
> Fri Jul 26 15:48:52 2002: DEBUG: Access accepted for h6-1 at service1
> Fri Jul 26 15:48:52 2002: DEBUG: Packet dump:
> *** Sending to 127.0.0.1 port 1153 ....
> Code:       Access-Accept
> Identifier: 208
> Authentic:  1234567890123456
> Attributes:
> 	Framed-IP-Address = 10.125.91.63
>
> ----------------------------------------------------------------
> dr. ir. Alexander P. de Boer
> KPN Royal Dutch Telecom
> Room L C7, P.O.Box 421, 2260 AK Leidschendam
> The Netherlands
>
> tel.: +31 70 4461788 (mobiel)  / fax.: +31 70 4463166
> e-mail: Alexander.deBoer at kpn.com
>
>
> ===
> 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.
>

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