On Fri, Mar 5, 2010 at 11:45 AM, Madovsky <infos@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

To: Madovsky

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

To: freeswitch-users@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@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org