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, [EMAIL PROTECTED] 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@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.
>
===
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.
