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

5 Mar 2010

      I wrote below, it solved
  ----- Original Message ----- 
  From: Anders Brownworth 
  To: freeswitch-users@lists.freeswitch.org 
  Sent: Friday, March 05, 2010 11:54 AM
  Subject: Re: [Freeswitch-users] Fw: freeswitch and postgresql as db core[SOLVED]

  I suspect your problem is not FreeSWITCH or unixODBC but rather connectivity through your tap1 device. Does this work:

  telnet 10.0.0.1 5432

  -Anders

  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

------------------------------------------------------------------------------

  _______________________________________________
  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