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