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@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@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@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@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@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@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: [EMAIL PROTECTED]
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
