<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;}</style>
</head>
<body fpstyle="1" ocsi="0">
<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>
</body>
</html>