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
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 <infos@madovsky.org> *To:* Madovsky <infos@madovsky.org> *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 <infos@madovsky.org> *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
No, it works without problem ----- 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
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
participants (2)
-
Anders Brownworth
-
Madovsky