[Freeswitch-users] Lua FreeSWITCH 1.6 dbh and PostgreSQL

[Marcel Haldemann]

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 at lists.freeswitch.org [mailto:freeswitch-users-bounces at lists.freeswitch.org] Im Auftrag von Artur Mega
Gesendet: Dienstag, 26. Januar 2016 09:04
An: FreeSWITCH Users Help <freeswitch-users at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20160126/f2a35897/attachment-0001.html