<!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>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></DIV></FONT>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Thanks me ;D</DIV></FONT>
<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=infos@madovsky.org
href="mailto:infos@madovsky.org">Madovsky</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, March 04, 2010 10:58
PM</DIV>
<DIV style="FONT: 10pt arial"><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</DIV>
<DIV><BR></DIV></FONT>
<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></BLOCKQUOTE></FONT></BODY></HTML>