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

[Gulyás Attila]

Found the solution in the Debian 9 installation guide
(https://freeswitch.org/confluence/display/FREESWITCH/Debian+9+Stretch)
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
pre_load_modules.conf.xml
<configuration name="pre_load_modules.conf" description="Modules">
  <modules>
    <!-- Databases -->
    <!-- <load module="mod_mariadb"/> -->
    <load module="mod_pgsql"/>
  </modules>
</configuration>

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=1.2.3.4 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 1.2.3.4 5432` and it is.
>
> Thank you for any suggestions!
>
> Appreciatively,
> Attila