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

[Giovanni Maruzzelli]

hehehe, glad you found it...



On Sat, Aug 24, 2019 at 5:07 AM Gulyás Attila <toraritte at 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 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
>
> _________________________________________________________________________
>
> 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 at 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 at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20190824/677850f4/attachment.html>