lua freeswitch.Dbh "ERR [unable to open database file]"
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
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
hehehe, glad you found it... On Sat, Aug 24, 2019 at 5:07 AM Gulyás Attila <toraritte@gmail.com> wrote:
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
-- Sincerely, Giovanni Maruzzelli OpenTelecom.IT cell: +39 347 266 56 18
participants (2)
-
Giovanni Maruzzelli
-
Gulyás Attila