(RADIATOR) AuthBy SQL failover

[Hugh Irvine]

Hello Arthur -

I suggest you install DBI-Shell and use that for your testing to the  
two database hosts.

DBI-Shell uses the same mechanics as Radiator to connect to the  
database so you should be able to see what is happening.

regards

Hugh


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

> Hugh Irvine wrote:
>>
>> 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".
>>
>
> Shame me, I slightly  edited those lines (to hide user names,  
> server names and passwords) and typo occurs. Really emm3 presents  
> in logfile:
>
> Tue Feb 27 09:17:00 2007: ERR: Could not connect to SQL database  
> with DBI->connect dbi:mysql:emm:emm3, , :  Access denied for user  
> 'root'@'emmftp2' (using password: NO)
>
> So my question about DBUsername and DBAuth for each DBSource  
> remains. Unfortunately  I haven't possibilities to build any test  
> environment right now.
>
> Regards,
> Arthur



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.