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