<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=windows-1252" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18876">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2>
<DIV><FONT size=2>forgot debug :</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>2010-03-04 22:42:33.174950 [ERR] switch_odbc.c:313 STATE:
08001 CODE 101 ERROR: [unixODBC]Could not connect to the server;<BR>Could not
connect to remote socket immedaitely</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>2010-03-04 22:42:33.174967 [CRIT] mod_nibblebill.c:210 Cannot
connect to ODBC driver/database freeswitch-pgsql (user: login / pass
pwd)!</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>thx</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>F</FONT></DIV></FONT></DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"
dir=ltr>
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="FONT: 10pt arial; BACKGROUND: #e4e4e4; font-color: black"><B>From:</B>
<A title=infos@madovsky.org href="mailto:infos@madovsky.org">Madovsky</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=freeswitch-users@lists.freeswitch.org
href="mailto:freeswitch-users@lists.freeswitch.org">freeswitch-users@lists.freeswitch.org</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, March 04, 2010 10:55
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> freeswitch and postgresql as db
core</DIV>
<DIV><BR></DIV>
<DIV><FONT size=2>Is there any example of how to use pgsql as db core on wiki
?</FONT></DIV>
<DIV><FONT size=2>I tried to adapt this example</FONT></DIV>
<DIV><FONT size=2><A
href="http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core">http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core</A></FONT></DIV>
<DIV><FONT size=2>for pgsql but no success.</FONT></DIV>
<DIV><FONT size=2>I'm trying to connect to it fhru openvpn.</FONT></DIV>
<DIV><FONT size=2>tcpdump -i tap1 on the destination server doesn't show any
packet exchange.</FONT></DIV>
<DIV><FONT size=2>I set odbc.ini as this :</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>[freeswitch-pgsql]<BR>Driver =
/usr/lib64/psqlodbc.so<BR>SERVER =
10.0.0.1<BR>PORT = 5432<BR>DATABASE =
freeswitch<BR></FONT></DIV>
<DIV><FONT size=2>and set all xml conf where odbc-dsn is as this
:</FONT></DIV>
<DIV><FONT size=2><param name="core-db-dsn"
value="freeswitch-pgsql:login:pwd" /></FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>didn't find anything interesting on google</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Thanks</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Franck</DIV></BLOCKQUOTE></FONT></BODY></HTML>