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@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

_________________________________________________________________________

The FreeSWITCH project is sponsored by SignalWire https://signalwire.com
Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services.
Build your next product on our scalable cloud platform.

Join our online community to chat in real time https://signalwire.community

Professional FreeSWITCH Services
sales@freeswitch.com
https://freeswitch.com

Official FreeSWITCH Sites
https://freeswitch.com/oss
https://freeswitch.org/confluence
https://cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
https://freeswitch.com