Re: [RADIATOR] [Radiator] Error connecting to readonly RADMIN Mysql DB
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
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