(RADIATOR) SQL server fallback behaviour

[alexander.deboer at kpn.com]

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.