Hi Roberto, I run few very busy RADIUS servers, and all use MySQL/MariaDB with RADIATOR DB connector on Centos 7 without any issue.
Regards, Dubravko On 12/10/19 2:36 PM, Ullfig, Roberto Alfredo wrote: > Ah yes, I also suspect an issue with a seldom used connection being > closed by the mysql server. The radiator server is to be put into > production in January so I'm expecting the issue to go away once it gets > a full load of authentication requests. Thanks! > > --- > Roberto Ullfig - [email protected] > Systems Administrator > Enterprise Architecture and Development | ACCC > University of Illinois - Chicago > ------------------------------------------------------------------------ > *From:* radiator <[email protected]> on behalf of > Heikki Vatiainen <[email protected]> > *Sent:* Tuesday, December 10, 2019 6:33 AM > *To:* [email protected] <[email protected]> > *Subject:* Re: [RADIATOR] Radiator and AuthLog SQL on Centos 7 > > On 05/12/2019 20.33, Ullfig, Roberto Alfredo wrote: >> We're converting our servers from Centos 6 to Centos 7. We do some >> logging with: >> >> <AuthLog SQL> >> DBSource dbi:mysql... >> >> but the connection keeps failing: >> >> MySQL server has gone away > > MySQL and Radiator's DB connections should work fine with CentOS 7 too. > The message you indicates the DB server, or possibly a firewall between > Radiator and the server, has closed or forced the connection to close. > In this case Radiator should retry opening the connection and running > the query again. > > If it fails even after retries, it will log something like this: > > Tue Dec 10 14:05:25 2019: ERR: Could not connect to any SQL database. > Request is ignored. Backing off for 600 seconds > > I'm not saying what you see is normal, but it might be worth checking if > it successful after it detects the problem. > > I think I've seen the above message in cases where the SQL connection is > seldom uses and the DB server side is keen to remove idle connections. > Sometimes a firewall between Radiator and DB has done something similar. > >> We have the mysql odbc connector installed: >> >> mysql-connector-odbc-5.2.5-8.el7.x86_64 > > I think this is not used because you have not configured dbi:odbc:... > Your config snippet indicates it uses DBD::mysql which links directly to > MySQL client libraries and uses SQL native, not ODBC, interface. > > dbi:mysql:... is commonly used, and I think it should be stable and work > well > >> and up to date with mysql/mariadb: >> >> mariadb-5.5.64-1.el7.x86_64 >> mariadb-libs-5.5.64-1.el7.x86_64 >> >> Any ideas? > > I would check the server side to see if it logs about why it closes > connections. Radiator tries to keep a connection open to DB once it's > established. Therefore there might be a mismatch in what Radiator does > and what the server expects from the connections. > > Thanks, > Heikki > > -- > Heikki Vatiainen <[email protected]> > > Radiator: the most portable, flexible and configurable RADIUS server > anywhere. SQL, proxy, DBM, files, LDAP, TACACS+, PAM, Active Directory, > EAP, TLS, TTLS, PEAP, WiMAX, RSA, Vasco, Yubikey, HOTP, TOTP, > DIAMETER etc. Full source on Unix, Windows, MacOSX, Solaris, VMS, etc. > _______________________________________________ > radiator mailing list > [email protected] > https://lists.open.com.au/mailman/listinfo/radiator > > _______________________________________________ > radiator mailing list > [email protected] > https://lists.open.com.au/mailman/listinfo/radiator > -- Dubravko Penezic Information Systems and Applications Department SRCE - University of Zagreb University Computing Centre, www.srce.unizg.hr [email protected], tel: +385 1 616 5555, fax: +385 1 616 5559 _______________________________________________ radiator mailing list [email protected] https://lists.open.com.au/mailman/listinfo/radiator
