(RADIATOR) AuthBy SQL failover

[Hugh Irvine]

Hello Arthur -

There appears to be something amiss with your configuration file, as  
the debug shows this:

ERR: Could not connect to SQL database with DBI->connect  
dbi:mysql:emm:emm2, , :  Access denied for user 'root'@'emm2' (using  
password: NO)

The second connection is going to "emm2", not "emm3".

I think you will need to check what is really going on.

I also think you should set up a test environment so you can verify  
your failover configuration and operation.

regards

Hugh


On 27 Feb 2007, at 21:11, Arthur Konovalov wrote:

> Hi!
>
> Small question about failover to backup SQL if primary server is down.
> I have two identical SQL servers named emm1 (primary) and emm3  
> (backup).
> Radiator running on server emm2.
> Today happend primary server fail, but Radiator fails switch to  
> another server too.
>
> My config:
>    <AuthBy SQL>
>    DBSource    dbi:mysql:emm:emm1
>    DBSource    dbi:mysql:emm:emm3
>    DBUsername    user
>    DBAuth        pass
>    AuthSelect
>    AccountingTable    imst
>
> And logfile:
> Tue Feb 27 09:17:00 2007: ERR: Could not connect to SQL database  
> with DBI->connect dbi:mysql:emm:emm1, user, pass: Tue Feb 27  
> 09:17:00 2007: ERR: Could not connect to SQL database with DBI- 
> >connect dbi:mysql:emm:emm2, , :  Access denied for user  
> 'root'@'emm2' (using password: NO)
> Tue Feb 27 09:17:00 2007: ERR: Could not connect to any SQL  
> database. Request is ignored. Backing off for 600 seconds
>
> I have heavy accounting traffic and can't make any tests. So, my  
> question:
> Is there mandatory  DBUsername and DBAuth for each DBSource even if  
> they same?
> Like this:
>    DBSource    dbi:mysql:emm:emm1
>    DBUsername    user
>    DBAuth        pass
>    DBSource    dbi:mysql:emm:emm3
>    DBUsername    user
>    DBAuth        pass
> Regards,
> AK
>
>
> --
> 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.



NB:

Have you read the reference manual ("doc/ref.html")?
Have you searched the mailing list archive (www.open.com.au/archives/ 
radiator)?
Have you had a quick look on Google (www.google.com)?
Have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
Includes support for reliable RADIUS transport (RadSec),
and DIAMETER translation agent.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.


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