[Freeswitch-users] freeswitch and postgresql as db core

[Madovsky]

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 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20100304/80e4b693/attachment-0002.html