<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
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!</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id="Signature">
<div id="divtagdefaultwrapper" style="font-size:12pt; color:#000000; background-color:#FFFFFF; font-family:Calibri,Arial,Helvetica,sans-serif">
<div style="font-family:Tahoma; font-size:13px">---
<div><span id="ms-rterangepaste-start"></span><span style="font-family:arial,helvetica,sans-serif; font-size:13px; line-height:16.003px">Roberto Ullfig - rullfig@uic.edu</span><br style="font-family:arial,helvetica,sans-serif; font-size:13px; line-height:16.003px">
<span style="font-family:arial,helvetica,sans-serif; font-size:13px; line-height:16.003px">Systems Administrator</span><br style="font-family:arial,helvetica,sans-serif; font-size:13px; line-height:16.003px">
<span style="font-family:arial,helvetica,sans-serif; font-size:13px; line-height:16.003px">Enterprise Architecture and Development | ACCC</span><br style="font-family:arial,helvetica,sans-serif; font-size:13px; line-height:16.003px">
<span style="font-family:arial,helvetica,sans-serif; font-size:13px; line-height:16.003px">University of Illinois - Chicago</span>
<div><span id="ms-rterangepaste-end"></span></div>
</div>
</div>
</div>
</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> radiator <radiator-bounces@lists.open.com.au> on behalf of Heikki Vatiainen <hvn@open.com.au><br>
<b>Sent:</b> Tuesday, December 10, 2019 6:33 AM<br>
<b>To:</b> radiator@lists.open.com.au <radiator@lists.open.com.au><br>
<b>Subject:</b> Re: [RADIATOR] Radiator and AuthLog SQL on Centos 7</font>
<div> </div>
</div>
<div class="BodyFragment"><font size="2"><span style="font-size:11pt;">
<div class="PlainText">On 05/12/2019 20.33, Ullfig, Roberto Alfredo wrote:<br>
> We're converting our servers from Centos 6 to Centos 7. We do some <br>
> logging with:<br>
> <br>
> <AuthLog SQL><br>
> DBSource dbi:mysql...<br>
> <br>
> but the connection keeps failing:<br>
> <br>
> MySQL server has gone away<br>
<br>
MySQL and Radiator's DB connections should work fine with CentOS 7 too. <br>
The message you indicates the DB server, or possibly a firewall between <br>
Radiator and the server, has closed or forced the connection to close. <br>
In this case Radiator should retry opening the connection and running <br>
the query again.<br>
<br>
If it fails even after retries, it will log something like this:<br>
<br>
Tue Dec 10 14:05:25 2019: ERR: Could not connect to any SQL database. <br>
Request is ignored. Backing off for 600 seconds<br>
<br>
I'm not saying what you see is normal, but it might be worth checking if <br>
it successful after it detects the problem.<br>
<br>
I think I've seen the above message in cases where the SQL connection is <br>
seldom uses and the DB server side is keen to remove idle connections. <br>
Sometimes a firewall between Radiator and DB has done something similar.<br>
<br>
> We have the mysql odbc connector installed:<br>
> <br>
> mysql-connector-odbc-5.2.5-8.el7.x86_64<br>
<br>
I think this is not used because you have not configured dbi:odbc:...<br>
Your config snippet indicates it uses DBD::mysql which links directly to <br>
MySQL client libraries and uses SQL native, not ODBC, interface.<br>
<br>
dbi:mysql:... is commonly used, and I think it should be stable and work <br>
well<br>
<br>
> and up to date with mysql/mariadb:<br>
> <br>
> mariadb-5.5.64-1.el7.x86_64<br>
> mariadb-libs-5.5.64-1.el7.x86_64<br>
> <br>
> Any ideas?<br>
<br>
I would check the server side to see if it logs about why it closes <br>
connections. Radiator tries to keep a connection open to DB once it's <br>
established. Therefore there might be a mismatch in what Radiator does <br>
and what the server expects from the connections.<br>
<br>
Thanks,<br>
Heikki<br>
<br>
-- <br>
Heikki Vatiainen <hvn@open.com.au><br>
<br>
Radiator: the most portable, flexible and configurable RADIUS server<br>
anywhere. SQL, proxy, DBM, files, LDAP, TACACS+, PAM, Active Directory,<br>
EAP, TLS, TTLS, PEAP, WiMAX, RSA, Vasco, Yubikey, HOTP, TOTP,<br>
DIAMETER etc. Full source on Unix, Windows, MacOSX, Solaris, VMS, etc.<br>
_______________________________________________<br>
radiator mailing list<br>
radiator@lists.open.com.au<br>
<a href="https://lists.open.com.au/mailman/listinfo/radiator">https://lists.open.com.au/mailman/listinfo/radiator</a><br>
</div>
</span></font></div>
</body>
</html>