Re: [RADIATOR] [Radiator] Error connecting to readonly RADMIN Mysql DB

2015-03-19 Thread Heikki Vatiainen
On 03/19/2015 12:18 PM, Laurent Duru wrote:

> Thu Mar 19 11:11:11 2015: ERR: Execute failed for 'select PASS_WORD,
> STATICADDRESS, TIMELEFT, MAXLOGINS, SERVICENAME, BADLOGINS, VALIDFROM,
> VALIDTO from RADUSERS where USERNAME=‘X'': Can't call method
> "prepare" on an undefined value at /usr/lib/perl5/Radius/SqlDb.pm line 287.

I have not seen this before. Can you reply with your configuration. I'd
like to see what kind of configuration triggers this problem.

I'd say using read-only database should work. The configuration would
also help understanding what your requirements are.

Thanks,
Heikki

-- 
Heikki Vatiainen 

Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS,
TTLS, PEAP, TNC, WiMAX, RSA, Vasco, Yubikey, MOTP, HOTP, TOTP,
DIAMETER etc. Full source on Unix, Windows, MacOSX, Solaris, VMS,
NetWare etc.
___
radiator mailing list
radiator@open.com.au
http://www.open.com.au/mailman/listinfo/radiator


[RADIATOR] [Radiator] Error connecting to readonly RADMIN Mysql DB

2015-03-19 Thread Laurent Duru
Hello,

My configuration as is :

Blue server : Radiator + Radmin + Mysql Master
Red Server : Mysql Slave

There is a Master-Slave Replication between blue and red, I need to avoid 
Radiator writes on Red.

In my Radiator config I use a Read/Write account to connect to Blue and a Read 
Only account to connect to red.

When Blue Mysql is down, requests failover to Red server but I get this error 
message :


Thu Mar 19 11:11:11 2015: ERR: Execute failed for 'select PASS_WORD, 
STATICADDRESS, TIMELEFT, MAXLOGINS, SERVICENAME, BADLOGINS, VALIDFROM, VALIDTO 
from RADUSERS where USERNAME=‘X'': Can't call method "prepare" on an 
undefined value at /usr/lib/perl5/Radius/SqlDb.pm line 287.

When I use Read/Write account for Red there is no error …

Is this configuration feasable ?
Have you encountered this error ?

Thanks a lot for your help,

Laurent
___
radiator mailing list
radiator@open.com.au
http://www.open.com.au/mailman/listinfo/radiator