<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18876">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2>I wrote below, it solved</FONT></DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="FONT: 10pt arial; BACKGROUND: #e4e4e4; font-color: black"><B>From:</B>
<A title=abrownworth@bandwidth.com
href="mailto:abrownworth@bandwidth.com">Anders Brownworth</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> Friday, March 05, 2010 11:54
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [Freeswitch-users] Fw:
freeswitch and postgresql as db core[SOLVED]</DIV>
<DIV><BR></DIV>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
style="BORDER-LEFT: rgb(204,204,204) 1px solid; MARGIN: 0pt 0pt 0pt 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote>
<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: rgb(0,0,0) 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"
dir=ltr>
<DIV
style="FONT: 10pt arial; font-size-adjust: none; font-stretch: normal">-----
Original Message ----- </DIV>
<DIV
style="FONT: 10pt arial; BACKGROUND: rgb(228,228,228); 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: 10pt arial; 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: 10pt arial; font-size-adjust: none; font-stretch: normal"><B>Sent:</B>
Thursday, March 04, 2010 10:58 PM</DIV>
<DIV
style="FONT: 10pt arial; 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: rgb(0,0,0) 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"
dir=ltr>
<DIV
style="FONT: 10pt arial; font-size-adjust: none; font-stretch: normal">-----
Original Message ----- </DIV>
<DIV
style="FONT: 10pt arial; BACKGROUND: rgb(228,228,228); 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: 10pt arial; 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: 10pt arial; font-size-adjust: none; font-stretch: normal"><B>Sent:</B>
Thursday, March 04, 2010 10:55 PM</DIV>
<DIV
style="FONT: 10pt arial; 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>
<P>
<HR>
<P></P>_______________________________________________<BR>FreeSWITCH-users
mailing
list<BR>FreeSWITCH-users@lists.freeswitch.org<BR>http://lists.freeswitch.org/mailman/listinfo/freeswitch-users<BR>UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users<BR>http://www.freeswitch.org<BR></BLOCKQUOTE></BODY></HTML>