Works for me in 1.4-1.7:

local dbh = freeswitch.Dbh("odbc://dbname:user:password") -- connect to ODBC database

maybe the big D in Dbh ?

Von: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] Im Auftrag von Artur Mega
Gesendet: Dienstag, 26. Januar 2016 09:04
An: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org>
Betreff: [Freeswitch-users] Lua FreeSWITCH 1.6 dbh and PostgreSQL

Hello everybody,
How can i connect to postgres database from lua through freeswitch.dbh ? 

I tried

local dbh = freeswitch.dbh("pgsql://hostaddr=127.0.0.1 dbname=some_db user=uname password='passwd'") -- returns nil

local dbh = freeswitch.dbh("odbc://some_db:uname:passwd") -- returns nil too

Also I set up ODBS with PostgreSQL driver. If I run this command in console:

            isql some_db uname passwd

then I can successfully connect to my database. What am i doing wrong? Also I tried to link odbc*.ini files for freeswitch:

            mkdir /usr/local/freeswitch/etc

            ln -s /etc/odbcinst.ini /usr/local/freeswitch/etc/odbcinst.ini

            ln -s /etc/odbc.ini /usr/local/freeswitch/etc/odbc.ini

but it doesn't help too. Thanks in advance.

--

Arthur