<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" id="owaParaStyle">
<!--
p
{margin-top:0;
margin-bottom:0}
-->
P {margin-top:0;margin-bottom:0;}</style>
</head>
<body fpstyle="1" ocsi="0">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">Of course after playing with this for 2 days I find the solution right after I post to the list.<br>
<br>
It was a tds_version issue. For whatever reason FreeTDS configured with versions 7.1 and 7.2 don't connect from OpenSIPS, but they do from isql. 4.2, 7.3 and 7.4 work fine from both. In my case it's to a MS SQL Server 2014 so 7.4
<a href="http://www.freetds.org/userguide/choosingtdsprotocol.htm">appropriate</a>. The default tds_version is 8.0, an alias for 7.1, so that's why the default didn't work.<br>
<br>
<br>
<br>
- Jeff<br>
<br>
<br>
<div style="font-family: Times New Roman; color: #000000; font-size: 16px">
<hr tabindex="-1">
<div id="divRpF75900" style="direction: ltr;"><font color="#000000" size="2" face="Tahoma"><b>From:</b> Users [users-bounces@lists.opensips.org] on behalf of Jeff Pyle<br>
<b>Sent:</b> Friday, March 31, 2017 09:29<br>
<b>To:</b> users@lists.opensips.org<br>
<b>Subject:</b> [OpenSIPS-Users] unixodbc connection problem - gnutls /dev/urandom error<br>
</font><br>
</div>
<div></div>
<div>
<div style="direction:ltr; font-family:Tahoma; color:#000000; font-size:10pt">Hello,<br>
<br>
I'm trying to connect OpenSIPS 2.2.3 to a MS SQL database for avpops through unixodbc + freetds on Debian 8. I see the following OpenSIPS errors:<br>
<br>
DBG:db_unixodbc:db_unixodbc_new_connection: opening connection: unixodbc://xxxx:xxxx@localhost/SQLMaster<br>
ERROR:db_unixodbc:db_unixodbc_new_connection: failed to connect<br>
ERROR:db_unixodbc:db_unixodbc_extract_error: unixodbc:SQLDriverConnect=08001:1:0:[unixODBC][FreeTDS][SQL Server]Unable to connect to data source<br>
ERROR:db_unixodbc:db_unixodbc_extract_error: unixodbc:SQLDriverConnect=01000:2:20002:[unixODBC][FreeTDS][SQL Server]Adaptive Server connection failed<br>
<br>
This only occurs within OpenSIPS. Testing on isql with the same credentials and DSN works fine.<br>
<br>
FreeTDS gives the following logs:<br>
<br>
login.c:1057:detected flag 0<br>
net.c:1259:GNUTLS: level 5:<br>
REC[0x21569b0]: Allocating epoch #0<br>
net.c:1259:GNUTLS: level 3:<br>
ASSERT: gnutls_constate.c:586<br>
net.c:1259:GNUTLS: level 5:<br>
REC[0x21569b0]: Allocating epoch #1<br>
net.c:1259:GNUTLS: level 2:<br>
Failed to read /dev/urandom: Bad file descriptor<br>
net.c:1259:GNUTLS: level 3:<br>
ASSERT: rnd.c:174<br>
net.c:1259:GNUTLS: level 3:<br>
ASSERT: rnd.c:291<br>
...and so on.<br>
<br>
/dev/urandom is present, has crw-rw-rw- permissions, and works properly according to rngtest from rng-tools.<br>
<br>
I've seen some posts indicating this may be a gnutls bug and recompiling freetds with openssl is required. I tried that - no change.<br>
<br>
Since this only occurs within OpenSIPS I thought I'd pose the question here. Any insight is greatly appreciated.<br>
<br>
<br>
<br>
- Jeff<br>
<br>
</div>
</div>
</div>
</div>
</body>
</html>