[Freeswitch-users] lua freeswitch.Dbh "ERR [unable to open database file]"

Gulyás Attila toraritte at gmail.com
Sat Aug 24 03:06:39 UTC 2019

Found the solution in the Debian 9 installation guide
while I was rebuilding a new VM. Basically I inadvertently upgraded
FreeSWITCH 1.8 to 1.10, and needed to load `mod_pgsql` (see the
excerpt below).

1.10 incompatible change
because now Fs1.10 packages are installed even if you still use the
1.8 repo, you better aware of an incompatible change:
pgsql is no more in core, but in aptly named mod_pgsql.
You MUST NOT load mod_pgsql in modules.conf.xml (do not work), but in
a special additional xml file, in same "autoload_configs" directory.

Filename: pre_load_modules.conf.xml
<configuration name="pre_load_modules.conf" description="Modules">
    <!-- Databases -->
    <!-- <load module="mod_mariadb"/> -->
    <load module="mod_pgsql"/>

On Fri, Aug 23, 2019 at 3:49 AM Gulyás Attila <toraritte at gmail.com> wrote:
> Hi,
> When I try to connect to a remote PostgreSQL server, I get
>     2019-08-23 10:19:05.793364 [ERR] switch_core_db.c:223 SQL ERR [unable to open database file]
> when using the Lua API
>    freeswitch.Dbh("pgsql://hostaddr= dbname=mydb user=postgres password=postgres options='-c client_min_messages=NOTICE' application_name='freeswitch'")
> (as recommended in the docs at: https://freeswitch.org/confluence/display/FREESWITCH/FreeSWITCH+Databases )
> It has been working flawlessly, even across FreeSWITCH service restarts, then I foolishly did a `sudo apt update && sudo apt upgrade` on Debian 9, and that was it.
> Would you recommend some steps on how I could troubleshoot this further? The error message is too generic.
> What I did so far:
> 0. Server reboot, call to server connects, Lua script works as intended, but fails at the DB part.
> 1. Checked the database on the remote server, it works fine.
> 2. Checked whether port is still open on remote server from the freeswitch server with `nc -zv 5432` and it is.
> Thank you for any suggestions!
> Appreciatively,
> Attila

More information about the FreeSWITCH-users mailing list