[Freeswitch-users] Fw: freeswitch and postgresql as db core [SOLVED]

[Anders Brownworth]

I suspect your problem is not FreeSWITCH or unixODBC but rather connectivity
through your tap1 device. Does this work:

telnet 10.0.0.1 5432

-Anders

On Fri, Mar 5, 2010 at 11:45 AM, Madovsky <infos at madovsky.org> wrote:

>  I sent An email last night but didn't work,
> so I retry it now...
>
> to make PostgreSQL 8.4.2 works with ODBC 2.2.12 (tested from fedora 10
> update rpm and Postgresql source)
>
> odbcinst.ini
>
> [PostgreSQL]
> Description     = ODBC for PostgreSQL
> Driver          = /usr/lib64/psqlodbc.so
> Setup           = /usr/lib64/libodbcpsqlS.so
> FileUsage       = 1
> odbc.ini
>
> [ODBC Data Sources]
> freeswitch-pgsql = ODBC for PostgreSQL
>
> [freeswitch-pgsql]
> Description = ODBC for PostgreSQL
> Driver   = /usr/lib64/psqlodbc.so
> Servername   = 10.0.0.1
> UserName = login
> Password = pwd
> Port     = 5432
> Database = dbdb
>
> Thanks me ;D
>
> ----- Original Message -----
> *From:* Madovsky <infos at madovsky.org>
> *To:* Madovsky <infos at madovsky.org>
> *Sent:* Thursday, March 04, 2010 10:58 PM
> *Subject:* Re: freeswitch and postgresql as db core
>
> forgot debug :
>
> 2010-03-04 22:42:33.174950 [ERR] switch_odbc.c:313 STATE: 08001 CODE 101
> ERROR: [unixODBC]Could not connect to the server;
> Could not connect to remote socket immedaitely
>
> 2010-03-04 22:42:33.174967 [CRIT] mod_nibblebill.c:210 Cannot connect to
> ODBC driver/database freeswitch-pgsql (user: login / pass pwd)!
>
> thx
>
> F
>
>  ----- Original Message -----
> *From:* Madovsky <infos at madovsky.org>
> *To:* freeswitch-users at lists.freeswitch.org
> *Sent:* Thursday, March 04, 2010 10:55 PM
> *Subject:* freeswitch and postgresql as db core
>
> Is there any example of how to use pgsql as db core on wiki ?
> I tried to adapt this example
> http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core
> for pgsql but no success.
> I'm trying to connect to it fhru openvpn.
> tcpdump -i tap1 on the destination server doesn't show any packet exchange.
> I set odbc.ini as this :
>
> [freeswitch-pgsql]
> Driver   = /usr/lib64/psqlodbc.so
> SERVER   = 10.0.0.1
> PORT     = 5432
> DATABASE = freeswitch
> and set all xml conf where odbc-dsn is as this :
> <param name="core-db-dsn" value="freeswitch-pgsql:login:pwd" />
>
> didn't find anything interesting on google
>
> Thanks
>
> Franck
>
>
> _______________________________________________
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20100305/5aed3e6a/attachment-0002.html