I suspect your problem is not FreeSWITCH or unixODBC but rather connectivity through your tap1 device. Does this work:<br><br>telnet 10.0.0.1 5432<br><br>-Anders<br><br><div class="gmail_quote">On Fri, Mar 5, 2010 at 11:45 AM, Madovsky <span dir="ltr"><<a href="mailto:infos@madovsky.org">infos@madovsky.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div bgcolor="#ffffff">
<div><font size="2">I sent An email last night but didn't work,</font></div>
<div><font size="2">so I retry it now...</font></div>
<div><br></div>
<div><font size="2">to make PostgreSQL 8.4.2 works with ODBC 2.2.12 (tested from
fedora 10 update rpm and Postgresql source)</font></div>
<div><font size="2"></font> </div>
<div><font size="2">odbcinst.ini</font></div>
<div><font size="2"></font> </div>
<div><font size="2">[PostgreSQL]<br>Description = ODBC for
PostgreSQL<br>Driver =
/usr/lib64/psqlodbc.so<br>Setup
= /usr/lib64/libodbcpsqlS.so<br>FileUsage =
1<br></font></div>
<div><font size="2"></font><font size="2">odbc.ini</font></div>
<div><font size="2"></font> </div>
<div><font size="2">[ODBC Data Sources]<br>freeswitch-pgsql = ODBC for
PostgreSQL</font></div>
<div><font size="2"></font> </div>
<div><font size="2">[freeswitch-pgsql]<br>Description = ODBC for
PostgreSQL<br>Driver =
/usr/lib64/psqlodbc.so<br>Servername = 10.0.0.1<br>UserName =
login<br>Password = pwd<br>Port = 5432<br>Database =
dbdb<br></font></div>
<div><font size="2"></font> </div>
<div><font size="2">Thanks me ;D</font></div>
<blockquote style="border-left: 2px solid rgb(0, 0, 0); padding-left: 5px; padding-right: 0px; margin-left: 5px; margin-right: 0px;" dir="ltr">
<div style="font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;">----- Original Message ----- </div>
<div style="background: rgb(228, 228, 228) none repeat scroll 0% 0%; font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous;">
<b>From:</b>
<a title="infos@madovsky.org" href="mailto:infos@madovsky.org" target="_blank">Madovsky</a>
</div>
<div style="font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"><b>To:</b> <a title="infos@madovsky.org" href="mailto:infos@madovsky.org" target="_blank">Madovsky</a> </div>
<div style="font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"><b>Sent:</b> Thursday, March 04, 2010 10:58
PM</div>
<div style="font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"><b>Subject:</b> Re: freeswitch and postgresql as
db core</div>
<div><br></div>
<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>
<div><br></div>
<blockquote style="border-left: 2px solid rgb(0, 0, 0); padding-left: 5px; padding-right: 0px; margin-left: 5px; margin-right: 0px;" dir="ltr">
<div style="font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;">----- Original Message ----- </div>
<div style="background: rgb(228, 228, 228) none repeat scroll 0% 0%; font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous;">
<b>From:</b>
<a title="infos@madovsky.org" href="mailto:infos@madovsky.org" target="_blank">Madovsky</a>
</div>
<div style="font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"><b>To:</b> <a title="freeswitch-users@lists.freeswitch.org" href="mailto:freeswitch-users@lists.freeswitch.org" target="_blank">freeswitch-users@lists.freeswitch.org</a>
</div>
<div style="font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"><b>Sent:</b> Thursday, March 04, 2010 10:55
PM</div>
<div style="font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"><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" target="_blank">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</font></div></blockquote></blockquote></div>
<br>_______________________________________________<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br></blockquote></div><br>