<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title></title>
<style type="text/css">
<!--
body{margin-left:10px;margin-right:10px;margin-top:10px;margin-bottom:10px;}
-->
</style>
</head>
<body marginleft="10" marginright="10" margintop="10" marginbottom="10">
<div align="left" style="text-align:left;"><font face="Arial" size="+0" color="#000000" style="font-family:Arial;font-size:12pt;color:#000000;"><b>I have a problem that I cannot figure out. </b></font></div>
<div align="left" style="text-align:left;"><font face="Arial" size="+0" color="#000000" style="font-family:Arial;font-size:12pt;color:#000000;"><b> </b></font></div>
<div align="left" style="text-align:left;"><font face="Arial" size="+0" color="#000000" style="font-family:Arial;font-size:12pt;color:#000000;"><b>I have installed RedHat, CentOS, Fedora 20 & 21 and FR 2.x.x and the new version 3.x.x, all of which in VM Workstation. I have internet access inside each of the VM's, inbound and outbound.</b></font></div>
<br />
<div align="left" style="text-align:left;"><font face="Arial" size="+0" color="#000000" style="font-family:Arial;font-size:12pt;color:#000000;"><b>Installed the Easysoft UnixODBC driver and the generic driver. Can connect through ISQL and pull data manually.</b></font></div>
<br />
<div align="left" style="text-align:left;"><font face="Arial" size="+0" color="#000000" style="font-family:Arial;font-size:12pt;color:#000000;"><b>The issue is only when RADIUSD -X is running that it will not make a connection to the SQL database. Same error on every single VM machine and they are all manually connectable through ISQL.</b></font></div>
<br />
<div align="left" style="text-align:left;"><font face="Arial" size="+0" color="#000000" style="font-family:Arial;font-size:12pt;color:#000000;"><b>The configuration message says that the config is ok when I run the check on it.</b></font></div>
<br />
<div align="left" style="text-align:left;"><font face="Arial" size="+0" color="#000000" style="font-family:Arial;font-size:12pt;color:#000000;"><b>Have Wireshark running and does not show any traffic from the RADIUSD server, but if I open up a browser in any of the Linux, shows traffic..</b></font></div>
<br />
<div align="left" style="text-align:left;"><font face="Arial" size="+0" color="#000000" style="font-family:Arial;font-size:12pt;color:#000000;"><b>rlm_sql (sql): Driver rlm_sql_unixodbc (module rlm_sql_unixodbc) loaded and linked</b></font></div>
<div align="left" style="text-align:left;"><font face="Arial" size="+0" color="#000000" style="font-family:Arial;font-size:12pt;color:#000000;"><b>rlm_sql (sql): Attempting to connect to database "gensql"</b></font></div>
<div align="left" style="text-align:left;"><font face="Arial" size="+0" color="#000000" style="font-family:Arial;font-size:12pt;color:#000000;"><b>rlm_sql (sql): Initialising connection pool</b></font></div>
<div align="left" style="text-align:left;"><font face="Arial" size="+0" color="#000000" style="font-family:Arial;font-size:12pt;color:#000000;"><b> pool {</b></font></div>
<div align="left" style="text-align:left;"><font face="Arial" size="+0" color="#000000" style="font-family:Arial;font-size:12pt;color:#000000;"><b> start = 5</b></font></div>
<div align="left" style="text-align:left;"><font face="Arial" size="+0" color="#000000" style="font-family:Arial;font-size:12pt;color:#000000;"><b> min = 4</b></font></div>
<div align="left" style="text-align:left;"><font face="Arial" size="+0" color="#000000" style="font-family:Arial;font-size:12pt;color:#000000;"><b> max = 10</b></font></div>
<div align="left" style="text-align:left;"><font face="Arial" size="+0" color="#000000" style="font-family:Arial;font-size:12pt;color:#000000;"><b> spare = 3</b></font></div>
<div align="left" style="text-align:left;"><font face="Arial" size="+0" color="#000000" style="font-family:Arial;font-size:12pt;color:#000000;"><b> uses = 0</b></font></div>
<div align="left" style="text-align:left;"><font face="Arial" size="+0" color="#000000" style="font-family:Arial;font-size:12pt;color:#000000;"><b> lifetime = 0</b></font></div>
<div align="left" style="text-align:left;"><font face="Arial" size="+0" color="#000000" style="font-family:Arial;font-size:12pt;color:#000000;"><b> cleanup_delay = 5</b></font></div>
<div align="left" style="text-align:left;"><font face="Arial" size="+0" color="#000000" style="font-family:Arial;font-size:12pt;color:#000000;"><b> idle_timeout = 60</b></font></div>
<div align="left" style="text-align:left;"><font face="Arial" size="+0" color="#000000" style="font-family:Arial;font-size:12pt;color:#000000;"><b> spread = no</b></font></div>
<div align="left" style="text-align:left;"><font face="Arial" size="+0" color="#000000" style="font-family:Arial;font-size:12pt;color:#000000;"><b> }</b></font></div>
<div align="left" style="text-align:left;"><font face="Arial" size="+0" color="#000000" style="font-family:Arial;font-size:12pt;color:#000000;"><b>rlm_sql (sql): Opening additional connection (0)</b></font></div>
<div align="left" style="text-align:left;"><font face="Arial" size="+0" color="#000000" style="font-family:Arial;font-size:12pt;color:#000000;"><b>rlm_sql_unixodbc: Connection failed</b></font></div>
<div align="left" style="text-align:left;"><font face="Arial" size="+0" color="#000000" style="font-family:Arial;font-size:12pt;color:#000000;"><b>rlm_sql_unixodbc: Socket destructor called, closing socket</b></font></div>
<div align="left" style="text-align:left;"><font face="Arial" size="+0" color="#000000" style="font-family:Arial;font-size:12pt;color:#000000;"><b>rlm_sql (sql): Opening connection failed (0)</b></font></div>
<div align="left" style="text-align:left;"><font face="Arial" size="+0" color="#000000" style="font-family:Arial;font-size:12pt;color:#000000;"><b>rlm_sql (sql): Removing connection pool</b></font></div>
<div align="left" style="text-align:left;"><font face="Arial" size="+0" color="#000000" style="font-family:Arial;font-size:12pt;color:#000000;"><b>/etc/raddb/mods-enabled/sql[47]: Instantiation failed for module "sql"</b></font></div>
<div align="left" style="text-align:left;"><font face="Arial" size="+0" color="#000000" style="font-family:Arial;font-size:12pt;color:#000000;"><b>[root@2nCSSw9999 ~]# </b></font></div>
<br />
<div align="left" style="text-align:left;"><font face="Arial" size="+0" color="#000000" style="font-family:Arial;font-size:12pt;color:#000000;"><b>----------------------------------------------------------------------</b></font></div>
<br />
<div align="left" style="text-align:left;"><font face="Arial" size="+0" color="#000000" style="font-family:Arial;font-size:12pt;color:#000000;"><b>}</b></font></div>
<div align="left" style="text-align:left;"><font face="Arial" size="+0" color="#000000" style="font-family:Arial;font-size:12pt;color:#000000;"><b>Configuration appears to be OK.</b></font></div>
<br />
<br />
<br />
<br />
<br />
<br />
</body>
</html>