<div dir="ltr"><div class="gmail_default" style="">Hello everybody,<br>How can i connect to postgres database from lua through freeswitch.dbh ? <br><br><div class="gmail_default" style="">I tried</div><div class="gmail_default" style="">local dbh = freeswitch.dbh("pgsql://hostaddr=127.0.0.1 dbname=some_db user=uname password='passwd'") -- returns nil</div><div class="gmail_default" style="">local dbh = freeswitch.dbh("odbc://some_db:uname:passwd") -- returns nil too</div><div class="gmail_default" style=""><br></div><div class="gmail_default" style="">Also I set up ODBS with PostgreSQL driver. If I run this command in console:</div><div class="gmail_default" style=""><br></div><div class="gmail_default" style=""><span class="" style="white-space:pre"> </span>isql some_db uname passwd</div><div class="gmail_default" style=""><br></div><div class="gmail_default" style="">then I can successfully connect to my database. What am i doing wrong? Also I tried to link odbc*.ini files for freeswitch:</div><div class="gmail_default" style=""><br></div><div class="gmail_default" style=""><span class="" style="white-space:pre"> </span>mkdir /usr/local/freeswitch/etc</div><div class="gmail_default" style=""><span class="" style="white-space:pre"> </span>ln -s /etc/odbcinst.ini /usr/local/freeswitch/etc/odbcinst.ini</div><div class="gmail_default" style=""><span class="" style="white-space:pre"> </span>ln -s /etc/odbc.ini /usr/local/freeswitch/etc/odbc.ini</div><div class="gmail_default" style=""><br></div><div class="gmail_default" style="">but it doesn't help too. Thanks in advance.</div></div><div><br></div>-- <br><div class="gmail_signature"><div dir="ltr"><div><div><br>Arthur</div></div></div></div>
</div>