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

[Madovsky]

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 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/20100305/f18b6b17/attachment-0002.html