----- 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