Re: [RADIATOR] [Radiator] Error connecting to readonly RADMIN Mysql DB
On 03/19/2015 02:49 PM, Heikki Vatiainen wrote: 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. This problem was solved off-list, but I thought I'd summarise the cause and fix. The AuthBy RADMIN default LogQuery was still trying to write to the read-only SQL DB. Since the writer was a logger, the SQL error that occurred during logging was not passed to the logger anymore. This is to stop the log messages caused by logging from creating infinite log loops. When LogQuery is configured with empty value, the query is skipped. We are considering options, such as logging to stderr, to help debugging these kinds of cases with logs. Thanks, Heikki -- Heikki Vatiainen h...@open.com.au 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
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 h...@open.com.au 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