SOLVED Can't connect to DB

Status
Not open for further replies.

kaz

New Member
Feb 25, 2019
12
2
3
53
Hello

I have a weird situation my FusionPBX was working fine last night but this morning I noticed no sip peers were registered, on checking logs I have discovered that
the db is not connecting.

I observe the following:

2019-08-14 12:29:41.776541 [ERR] switch_core_db.c:223 SQL ERR [unable to open database file]
2019-08-14 12:29:41.776561 [CRIT] switch_core_sqldb.c:622 Failure to connect to CORE_DB pgsql://hostaddr=xxx.xxx.xxx.xxx port=5432 dbname=fusionpbx user=xxxxxx password=xxxxxxxxxxxxxxxxxxxxxx options=''!

xxxx's used for security reasons

Nothing has changed on my system since last night so not sure what has gone wrong, hoping someone can help me understand why freeswitch can connect to db in postgres.

Thanks
Kaz.
 

kaz

New Member
Feb 25, 2019
12
2
3
53
Yes Postgres is running

● postgresql.service - PostgreSQL RDBMS
Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled)
Active: active (exited) since Wed 2019-08-14 12:29:39 NZST; 2h 25min ago
Process: 890 ExecStart=/bin/true (code=exited, status=0/SUCCESS)
Main PID: 890 (code=exited, status=0/SUCCESS)
Tasks: 0 (limit: 4915)
CGroup: /system.slice/postgresql.service

Aug 14 12:29:39 xxxxx.xx.xx.xx systemd[1]: Starting PostgreSQL RDBMS...
Aug 14 12:29:39 xxxx.xx.xx.xx systemd[1]: Started PostgreSQL RDBMS.
 

marko

New Member
Aug 15, 2019
7
0
1
I have this problem too after a debian upgrade on Wednesday. I'm on Debian 9 and my freeswitch version is
FreeSWITCH version: 1.10.0-release-11-7a921c608b~64bit (-release-11-7a921c608b 64bit)

I can connect to the database from the command line using
# psql -h 127.0.0.1 -U fusionpbx fusionpbx
and the xxxxxx password from the error message in the log.

This is only thread that comes up in a search with this problem, though there is another one on this board talking about 1.10 needing buster.
 

markjcrane

Active Member
Staff member
Jul 22, 2018
447
162
43
49
If you are using FreeSWITCH 1.10.x they made changes to how lua works and we had to make changes to the code.
If you upgrade to latest 4.4 or Master branch then Lua will work better with the database.
 

marko

New Member
Aug 15, 2019
7
0
1
I am wondering why 1.10 was installed into debian 9 when it is not compatible. I do have backports enabled to allow installation of bacula, do you think this is why 1.10 was installed? I will be upgrading to Deb 10 buster, do you think freeswitch 1.10 will work from it's current state after the upgrade or reinstall required? thanks
 

kaz

New Member
Feb 25, 2019
12
2
3
53
If you are using FreeSWITCH 1.10.x they made changes to how lua works and we had to make changes to the code.
If you upgrade to latest 4.4 or Master branch then Lua will work better with the database.

Already on 4.4

System Information Version4.4.7Git InformationBranch: 4.4
Commit: 455b498c03136e92ad469044ad3efe2bc674831d
Origin: https://github.com/fusionpbx/fusionpbx
Status: Your branch is behind 'origin/4.4' by 44 commits, and can be fast-forwarded. +34 days ago
Project Path/var/www/fusionpbxSwitch Version1.10.0 (64bit)


makes no difference still getting connection errors with lua scripts
 

kaz

New Member
Feb 25, 2019
12
2
3
53
I have this problem too after a debian upgrade on Wednesday. I'm on Debian 9 and my freeswitch version is
FreeSWITCH version: 1.10.0-release-11-7a921c608b~64bit (-release-11-7a921c608b 64bit)

I can connect to the database from the command line using
# psql -h 127.0.0.1 -U fusionpbx fusionpbx
and the xxxxxx password from the error message in the log.

This is only thread that comes up in a search with this problem, though there is another one on this board talking about 1.10 needing buster.

Like you can also do the same

I can connect to the database from the command line using # psql -h 127.0.0.1 -U fusionpbx fusionpbx and the xxxxxx password from the error message in the log.
 

Minister

New Member
Aug 27, 2019
5
4
1
24
Think
Hello

I have a weird situation my FusionPBX was working fine last night but this morning I noticed no sip peers were registered, on checking logs I have discovered that
the db is not connecting.

I observe the following:

2019-08-14 12:29:41.776541 [ERR] switch_core_db.c:223 SQL ERR [unable to open database file]
2019-08-14 12:29:41.776561 [CRIT] switch_core_sqldb.c:622 Failure to connect to CORE_DB pgsql://hostaddr=xxx.xxx.xxx.xxx port=5432 dbname=fusionpbx user=xxxxxx password=xxxxxxxxxxxxxxxxxxxxxx options=''!

xxxx's used for security reasons

Nothing has changed on my system since last night so not sure what has gone wrong, hoping someone can help me understand why freeswitch can connect to db in postgres.

Thanks
Kaz.

While got the same error on Debian 9 (Stretch) on Freeswitch upgrading from 1.8 to 1.10, I could, Thank God, get my FusionPBX (Freeswitch) up again.

Think that this could help: https://freeswitch.org/confluence/display/FREESWITCH/Debian+9+Stretch

According to above mentioned, at /etc/freeswitch/autoload_configs/ must be placed a new file "pre_load_modules.conf.xml" with contents like:

XML:
<configuration name="pre_load_modules.conf" description="Modules">
  <modules>
    <!-- Databases -->
    <!-- <load module="mod_mariadb"/> -->
    <load module="mod_pgsql"/>
  </modules>
</configuration>


For FusionPBX, also might have sense check the user and group for running the Freeswitch: /etc/systemd/system/multi-user.target.wants/freeswitch.service

both user and group must be "www-data" not "freeswitch".
 
Last edited:
  • Like
Reactions: Dan and smn

kaz

New Member
Feb 25, 2019
12
2
3
53
Hi

Did all of the below still get the error

2019-08-29 09:11:55.906629 [DEBUG] mod_event_socket.c:2952 Socket up listening on 127.0.0.1:8021
2019-08-29 09:11:55.909333 [ERR] switch_core_db.c:223 SQL ERR [unable to open database file]
2019-08-29 09:11:55.909370 [CRIT] switch_core_sqldb.c:622 Failure to connect to CORE_DB pgsql://hostaddr=127.0.0.1 port=5432 dbname=fusionpbx user=fusionpbx password=xxxxxxxxxxxxxxxxxxxxxxxxxx options=''!
2019-08-29 09:11:55.909375 [ERR] freeswitch_lua.cpp:374 Connection failed. DBH NOT Connected.
2019-08-29 09:11:55.909537 [ERR] mod_lua.cpp:202 ...eeswitch/scripts/resources/functions/database/native.lua:27: assertion failed!


Think


While got the same error on Debian 9 (Stretch) on Freeswitch upgrading from 1.8 to 1.10, I could, Thank God, get my FusionPBX (Freeswitch) up again.

Think that this could help: https://freeswitch.org/confluence/display/FREESWITCH/Debian+9+Stretch

According to above mentioned, at /etc/freeswitch/autoload_configs/ must be placed a new file "pre_load_modules.conf.xml" with contents like:

XML:
<configuration name="pre_load_modules.conf" description="Modules">
  <modules>
    <!-- Databases -->
    <!-- <load module="mod_mariadb"/> -->
    <load module="mod_pgsql"/>
  </modules>
</configuration>


For FusionPBX, also might have sense check the user and group for running the Freeswitch: /etc/systemd/system/multi-user.target.wants/freeswitch.service

both user and group must be "www-data" not "freeswitch".
 

kaz

New Member
Feb 25, 2019
12
2
3
53
Hello, kaz! Could you put here the output of command: systemctl status freeswitch


● freeswitch.service - freeswitch
Loaded: loaded (/lib/systemd/system/freeswitch.service; enabled; vendor preset: enabled)
Active: active (running) since Thu 2019-08-29 11:29:48 NZST; 21h ago
Process: 917 ExecStart=/usr/bin/freeswitch -u www-data -g www-data -ncwait $DAEMON_OPTS (code=exited, status=0/SUCCESS)
Process: 913 ExecStartPre=/bin/chown -R www-data:www-data /var/run/freeswitch/ (code=exited, status=0/SUCCESS)
Process: 910 ExecStartPre=/bin/mkdir -p /var/run/freeswitch/ (code=exited, status=0/SUCCESS)
Main PID: 919 (freeswitch)
Tasks: 17 (limit: 4915)
CGroup: /system.slice/freeswitch.service
└─919 /usr/bin/freeswitch -u www-data -g www-data -ncwait -nonat -ncwait -u www-data -g www-data -run /var/run/freeswitch

Aug 29 11:29:46 trunk.xx.xxx.xx systemd[1]: Starting freeswitch...
Aug 29 11:29:46 trunk.xx.xxx.xx freeswitch[917]: 919 Backgrounding.
Aug 29 11:29:48 trunk.xx.xxx.xx freeswitch[917]: FreeSWITCH[917] Waiting for background process pid:919 to be ready.....
Aug 29 11:29:48 trunk.xx.xxx.xx freeswitch[917]: FreeSWITCH[917] System Ready pid:919
Aug 29 11:29:48 trunk.xx.xxx.xx systemd[1]: Started freeswitch.
 

Minister

New Member
Aug 27, 2019
5
4
1
24
● freeswitch.service - freeswitch
Loaded: loaded (/lib/systemd/system/freeswitch.service; enabled; vendor preset: enabled)
Active: active (running) since Thu 2019-08-29 11:29:48 NZST; 21h ago
Process: 917 ExecStart=/usr/bin/freeswitch -u www-data -g www-data -ncwait $DAEMON_OPTS (code=exited, status=0/SUCCESS)
Process: 913 ExecStartPre=/bin/chown -R www-data:www-data /var/run/freeswitch/ (code=exited, status=0/SUCCESS)
Process: 910 ExecStartPre=/bin/mkdir -p /var/run/freeswitch/ (code=exited, status=0/SUCCESS)
Main PID: 919 (freeswitch)
Tasks: 17 (limit: 4915)
CGroup: /system.slice/freeswitch.service
└─919 /usr/bin/freeswitch -u www-data -g www-data -ncwait -nonat -ncwait -u www-data -g www-data -run /var/run/freeswitch

Aug 29 11:29:46 trunk.xx.xxx.xx systemd[1]: Starting freeswitch...
Aug 29 11:29:46 trunk.xx.xxx.xx freeswitch[917]: 919 Backgrounding.
Aug 29 11:29:48 trunk.xx.xxx.xx freeswitch[917]: FreeSWITCH[917] Waiting for background process pid:919 to be ready.....
Aug 29 11:29:48 trunk.xx.xxx.xx freeswitch[917]: FreeSWITCH[917] System Ready pid:919
Aug 29 11:29:48 trunk.xx.xxx.xx systemd[1]: Started freeswitch.
Hello, kaz!

Also please put here the ouptut of the command
Bash:
apt list --installed | grep freeswitch

And the other one:
Code:
cat /etc/systemd/system/multi-user.target.wants/freeswitch.service

And one more:
Bash:
ls -l /etc/freeswitch/autoload_configs/
 
Last edited:

kaz

New Member
Feb 25, 2019
12
2
3
53
Hello, kaz!

Also please put here the ouptut of the command
Bash:
apt list --installed | grep freeswitch

And the other one:
Code:
cat /etc/systemd/system/multi-user.target.wants/freeswitch.service

And one more:
Bash:
ls -l /etc/freeswitch/autoload_configs/


WARNING: apt does not have a stable CLI interface. Use with caution in scripts.

freeswitch/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-conf-vanilla/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-dbg/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-doc/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-lang/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-lang-en/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-meta-bare/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-meta-codecs/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-meta-mod-say/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-amr/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-amrwb/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-b64/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-bv/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-callcenter/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-cdr-csv/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-cidlookup/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-codec2/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-commands/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-conference/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-console/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-dahdi-codec/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-db/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-dialplan-xml/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-directory/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-distributor/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-dptools/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-enum/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-esf/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-esl/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-event-socket/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-expr/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-fifo/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-flite/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-fsv/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-g723-1/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-g729/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-h26x/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-hash/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-httapi/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-imagick/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-isac/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-json-cdr/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-local-stream/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-logfile/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-loopback/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-lua/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-memcache/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-mp4v/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-native-file/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-opus/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-png/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-rtc/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-say-de/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-say-en/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-say-es/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-say-fa/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-say-fr/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-say-he/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-say-hr/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-say-hu/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-say-it/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-say-ja/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-say-nl/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-say-pl/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-say-pt/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-say-ru/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-say-th/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-say-zh/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-shout/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-silk/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-sms/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-sms-dbg/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-sndfile/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-sofia/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-sofia-dbg/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-spandsp/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-theora/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-tone-stream/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-tts-commandline/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-valet-parking/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-verto/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-xml-cdr/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-sounds-en-us-callie/stable,now 1.0.52-1 all [installed]
freeswitch-timezones/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
libfreeswitch1/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]




;;;;; Author: Travis Cross <tc@traviscross.com>

[Unit]
Description=freeswitch
After=syslog.target network.target local-fs.target postgresql.service

[Service]
; service
Type=forking
PIDFile=/run/freeswitch/freeswitch.pid
Environment="DAEMON_OPTS=-nonat"
EnvironmentFile=-/etc/default/freeswitch
ExecStartPre=/bin/mkdir -p /var/run/freeswitch/
ExecStartPre=/bin/chown -R www-data:www-data /var/run/freeswitch/
ExecStart=/usr/bin/freeswitch -u www-data -g www-data -ncwait $DAEMON_OPTS
TimeoutSec=45s
Restart=always
; exec
User=root
Group=daemon
LimitCORE=infinity
LimitNOFILE=100000
LimitNPROC=60000
LimitSTACK=250000
LimitRTPRIO=infinity
LimitRTTIME=infinity
IOSchedulingClass=realtime
IOSchedulingPriority=2
CPUSchedulingPolicy=rr
CPUSchedulingPriority=89
UMask=0007

; alternatives which you can enforce by placing a unit drop-in into
; /etc/systemd/system/freeswitch.service.d/*.conf:
;
; User=freeswitch
; Group=freeswitch
; ExecStart=
; ExecStart=/usr/bin/freeswitch -ncwait -nonat -rp
;
; empty ExecStart is required to flush the list.
;
; if your filesystem supports extended attributes, execute
; setcap 'cap_net_bind_service,cap_sys_nice=+ep' /usr/bin/freeswitch
; this will also allow socket binding on low ports
;
; otherwise, remove the -rp option from ExecStart and
; add these lines to give real-time priority to the process:
;
; PermissionsStartOnly=true
; ExecStartPost=/bin/chrt -f -p 1 $MAINPID
;
; execute "systemctl daemon-reload" after editing the unit files.

[Install]
WantedBy=multi-user.target








-rw-r--r-- 1 www-data www-data 268 Jul 22 18:23 abstraction.conf.xml
-rw-r--r-- 1 www-data www-data 422 Jul 22 18:23 alsa.conf.xml
-rw-r--r-- 1 www-data www-data 359 Jul 22 18:23 blacklist.conf.xml
-rw-r--r-- 1 www-data www-data 775 Jul 22 18:23 callcenter.conf
-rw-r--r-- 1 www-data www-data 470 Jul 22 18:23 cdr_mongodb.conf.xml
-rw-r--r-- 1 www-data www-data 2662 Jul 22 18:23 cdr_pg_csv.conf.xml
-rw-r--r-- 1 www-data www-data 999 Jul 22 18:23 cdr_sqlite.conf.xml
-rw-r--r-- 1 www-data www-data 295 Jul 22 18:23 cepstral.conf.xml
-rw-r--r-- 1 www-data www-data 1685 Jul 22 18:23 cidlookup.conf.xml
-rw-r--r-- 1 www-data www-data 14856 Jul 22 18:23 conference.conf
-rw-r--r-- 1 www-data www-data 15057 Jul 22 18:23 conference_layouts.conf.xml
-rw-r--r-- 1 www-data www-data 2477 Jul 22 18:23 console.conf.xml
-rw-r--r-- 1 www-data www-data 147 Jul 22 18:23 curl.conf.xml
-rw-r--r-- 1 www-data www-data 164 Jul 22 18:23 db.conf.xml
-rw-r--r-- 1 www-data www-data 380 Jul 22 18:23 dialplan_directory.conf.xml
-rw-r--r-- 1 www-data www-data 265 Jul 22 18:23 dingaling.conf.xml
-rw-r--r-- 1 www-data www-data 803 Jul 22 18:23 directory.conf.xml
-rw-r--r-- 1 www-data www-data 460 Jul 22 18:23 distributor.conf.xml
-rw-r--r-- 1 www-data www-data 1426 Jul 22 18:23 easyroute.conf.xml
-rw-r--r-- 1 www-data www-data 504 Jul 22 18:23 enum.conf.xml
-rw-r--r-- 1 www-data www-data 1210 Jul 22 18:23 erlang_event.conf.xml
-rw-r--r-- 1 www-data www-data 593 Jul 22 18:23 event_multicast.conf.xml
-rw-r--r-- 1 www-data www-data 350 Jul 22 18:23 event_socket.conf.xml
-rw-r--r-- 1 www-data www-data 433 Jul 22 18:23 fax.conf.xml
-rw-r--r-- 1 www-data www-data 423 Jul 22 18:23 fifo.conf.xml
-rw-r--r-- 1 www-data www-data 18454 Jul 22 18:23 freetdm.conf.xml
-rw-r--r-- 1 www-data www-data 260 Jul 22 18:23 hash.conf.xml
-rw-r--r-- 1 www-data www-data 5346 Jul 22 18:23 httapi.conf.xml
-rw-r--r-- 1 www-data www-data 1731 Jul 22 18:23 http_cache.conf.xml
-rw-r--r-- 1 www-data www-data 155 Jul 22 18:23 ivr.conf.xml
-rw-r--r-- 1 www-data www-data 706 Jul 22 18:23 java.conf.xml
-rw-r--r-- 1 www-data www-data 2724 Jul 22 18:23 json_cdr.conf.xml
-rw-r--r-- 1 www-data www-data 3548 Jul 22 18:23 lcr.conf.xml
-rw-r--r-- 1 www-data www-data 1595 Jul 22 18:23 local_stream.conf
-rw-r--r-- 1 www-data www-data 1133 Jul 22 18:23 logfile.conf.xml
-rw-r--r-- 1 www-data www-data 2559 Jul 22 18:23 lua.conf.xml
-rw-r--r-- 1 www-data www-data 254 Jul 22 18:23 memcache.conf.xml
-rw-r--r-- 1 www-data www-data 1919 Aug 30 10:39 modules.conf.xml
-rw-r--r-- 1 www-data www-data 635 Jul 22 18:23 mongo.conf.xml
-rw-r--r-- 1 www-data www-data 2118 Jul 22 18:23 nibblebill.conf.xml
-rw-r--r-- 1 www-data www-data 698 Jul 22 18:23 opal.conf.xml
-rw-r--r-- 1 www-data www-data 1794 Jul 22 18:23 opus.conf.xml
-rw-r--r-- 1 www-data www-data 2108 Jul 22 18:23 osp.conf.xml
-rw-r--r-- 1 www-data www-data 583 Jul 22 18:23 perl.conf.xml
-rw-r--r-- 1 www-data www-data 534 Jul 22 18:23 pocketsphinx.conf.xml
-rw-r--r-- 1 www-data www-data 8818 Jul 22 18:23 portaudio.conf.xml
-rw-r--r-- 1 www-data www-data 110 Jul 22 18:23 post_load_modules.conf.xml
-rw-r--r-- 1 www-data www-data 196 Jul 22 18:23 presence_map.conf.xml
-rw-r--r-- 1 www-data www-data 574 Jul 22 18:23 python.conf.xml
-rw-r--r-- 1 www-data www-data 239 Jul 22 18:23 redis.conf.xml
-rw-r--r-- 1 www-data www-data 296 Jul 22 18:23 rss.conf.xml
-rw-r--r-- 1 www-data www-data 662 Jul 22 18:23 rtmp.conf.xml
-rw-r--r-- 1 www-data www-data 1453 Jul 22 18:23 sangoma_codec.conf.xml
-rw-r--r-- 1 www-data www-data 305 Jul 22 18:23 shout.conf.xml
-rw-r--r-- 1 www-data www-data 178 Jul 22 18:23 skinny.conf.xml
-rw-r--r-- 1 www-data www-data 488 Jul 22 18:23 smpp.conf.xml
-rw-r--r-- 1 www-data www-data 596 Jul 22 18:23 sofia.conf.xml
-rw-r--r-- 1 www-data www-data 3935 Jul 22 18:23 spandsp.conf.xml
-rw-r--r-- 1 www-data www-data 319 Jul 22 18:23 spidermonkey.conf.xml
-rw-r--r-- 1 www-data www-data 6934 Jul 22 18:23 switch.conf.xml
-rw-r--r-- 1 www-data www-data 745 Jul 22 18:23 syslog.conf.xml
-rw-r--r-- 1 www-data www-data 29447 Jul 22 18:23 timezones.conf.xml
-rw-r--r-- 1 www-data www-data 551 Jul 22 18:23 tts_commandline.conf.xml
-rw-r--r-- 1 www-data www-data 914 Jul 22 18:23 unicall.conf.xml
-rw-r--r-- 1 www-data www-data 899 Jul 22 18:23 unimrcp.conf.xml
-rw-r--r-- 1 www-data www-data 607 Jul 22 18:23 v8.conf.xml
-rw-r--r-- 1 www-data www-data 1334 Jul 22 18:23 verto.conf.xml
-rw-r--r-- 1 www-data www-data 3444 Jul 22 18:23 voicemail.conf.xml
-rw-r--r-- 1 www-data www-data 7906 Jul 22 18:23 voicemail_ivr.conf.xml
-rw-r--r-- 1 www-data www-data 4007 Jul 22 18:23 xml_cdr.conf.xml
-rw-r--r-- 1 www-data www-data 2890 Jul 22 18:23 xml_curl.conf.xml
-rw-r--r-- 1 www-data www-data 451 Jul 22 18:23 xml_rpc.conf.xml
-rw-r--r-- 1 www-data www-data 203 Jul 22 18:23 zeroconf.conf.xml
 

Minister

New Member
Aug 27, 2019
5
4
1
24
WARNING: apt does not have a stable CLI interface. Use with caution in scripts.

freeswitch/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-conf-vanilla/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-dbg/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-doc/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-lang/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-lang-en/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-meta-bare/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-meta-codecs/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-meta-mod-say/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-amr/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-amrwb/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-b64/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-bv/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-callcenter/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-cdr-csv/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-cidlookup/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-codec2/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-commands/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-conference/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-console/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-dahdi-codec/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-db/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-dialplan-xml/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-directory/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-distributor/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-dptools/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-enum/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-esf/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-esl/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-event-socket/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-expr/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-fifo/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-flite/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-fsv/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-g723-1/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-g729/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-h26x/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-hash/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-httapi/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-imagick/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-isac/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-json-cdr/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-local-stream/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-logfile/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-loopback/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-lua/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-memcache/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-mp4v/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-native-file/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-opus/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-png/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-rtc/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-say-de/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-say-en/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-say-es/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-say-fa/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-say-fr/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-say-he/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-say-hr/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-say-hu/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-say-it/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-say-ja/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-say-nl/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-say-pl/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-say-pt/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-say-ru/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-say-th/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-say-zh/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-shout/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-silk/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-sms/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-sms-dbg/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-sndfile/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-sofia/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-sofia-dbg/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-spandsp/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-theora/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
freeswitch-mod-tone-stream/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-tts-commandline/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-valet-parking/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-verto/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-mod-xml-cdr/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed]
freeswitch-sounds-en-us-callie/stable,now 1.0.52-1 all [installed]
freeswitch-timezones/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]
libfreeswitch1/stable,now 1.10.1~release~12~f9990221e6~stretch-1~stretch+1 amd64 [installed,automatic]




;;;;; Author: Travis Cross <tc@traviscross.com>

[Unit]
Description=freeswitch
After=syslog.target network.target local-fs.target postgresql.service

[Service]
; service
Type=forking
PIDFile=/run/freeswitch/freeswitch.pid
Environment="DAEMON_OPTS=-nonat"
EnvironmentFile=-/etc/default/freeswitch
ExecStartPre=/bin/mkdir -p /var/run/freeswitch/
ExecStartPre=/bin/chown -R www-data:www-data /var/run/freeswitch/
ExecStart=/usr/bin/freeswitch -u www-data -g www-data -ncwait $DAEMON_OPTS
TimeoutSec=45s
Restart=always
; exec
User=root
Group=daemon
LimitCORE=infinity
LimitNOFILE=100000
LimitNPROC=60000
LimitSTACK=250000
LimitRTPRIO=infinity
LimitRTTIME=infinity
IOSchedulingClass=realtime
IOSchedulingPriority=2
CPUSchedulingPolicy=rr
CPUSchedulingPriority=89
UMask=0007

; alternatives which you can enforce by placing a unit drop-in into
; /etc/systemd/system/freeswitch.service.d/*.conf:
;
; User=freeswitch
; Group=freeswitch
; ExecStart=
; ExecStart=/usr/bin/freeswitch -ncwait -nonat -rp
;
; empty ExecStart is required to flush the list.
;
; if your filesystem supports extended attributes, execute
; setcap 'cap_net_bind_service,cap_sys_nice=+ep' /usr/bin/freeswitch
; this will also allow socket binding on low ports
;
; otherwise, remove the -rp option from ExecStart and
; add these lines to give real-time priority to the process:
;
; PermissionsStartOnly=true
; ExecStartPost=/bin/chrt -f -p 1 $MAINPID
;
; execute "systemctl daemon-reload" after editing the unit files.

[Install]
WantedBy=multi-user.target








-rw-r--r-- 1 www-data www-data 268 Jul 22 18:23 abstraction.conf.xml
-rw-r--r-- 1 www-data www-data 422 Jul 22 18:23 alsa.conf.xml
-rw-r--r-- 1 www-data www-data 359 Jul 22 18:23 blacklist.conf.xml
-rw-r--r-- 1 www-data www-data 775 Jul 22 18:23 callcenter.conf
-rw-r--r-- 1 www-data www-data 470 Jul 22 18:23 cdr_mongodb.conf.xml
-rw-r--r-- 1 www-data www-data 2662 Jul 22 18:23 cdr_pg_csv.conf.xml
-rw-r--r-- 1 www-data www-data 999 Jul 22 18:23 cdr_sqlite.conf.xml
-rw-r--r-- 1 www-data www-data 295 Jul 22 18:23 cepstral.conf.xml
-rw-r--r-- 1 www-data www-data 1685 Jul 22 18:23 cidlookup.conf.xml
-rw-r--r-- 1 www-data www-data 14856 Jul 22 18:23 conference.conf
-rw-r--r-- 1 www-data www-data 15057 Jul 22 18:23 conference_layouts.conf.xml
-rw-r--r-- 1 www-data www-data 2477 Jul 22 18:23 console.conf.xml
-rw-r--r-- 1 www-data www-data 147 Jul 22 18:23 curl.conf.xml
-rw-r--r-- 1 www-data www-data 164 Jul 22 18:23 db.conf.xml
-rw-r--r-- 1 www-data www-data 380 Jul 22 18:23 dialplan_directory.conf.xml
-rw-r--r-- 1 www-data www-data 265 Jul 22 18:23 dingaling.conf.xml
-rw-r--r-- 1 www-data www-data 803 Jul 22 18:23 directory.conf.xml
-rw-r--r-- 1 www-data www-data 460 Jul 22 18:23 distributor.conf.xml
-rw-r--r-- 1 www-data www-data 1426 Jul 22 18:23 easyroute.conf.xml
-rw-r--r-- 1 www-data www-data 504 Jul 22 18:23 enum.conf.xml
-rw-r--r-- 1 www-data www-data 1210 Jul 22 18:23 erlang_event.conf.xml
-rw-r--r-- 1 www-data www-data 593 Jul 22 18:23 event_multicast.conf.xml
-rw-r--r-- 1 www-data www-data 350 Jul 22 18:23 event_socket.conf.xml
-rw-r--r-- 1 www-data www-data 433 Jul 22 18:23 fax.conf.xml
-rw-r--r-- 1 www-data www-data 423 Jul 22 18:23 fifo.conf.xml
-rw-r--r-- 1 www-data www-data 18454 Jul 22 18:23 freetdm.conf.xml
-rw-r--r-- 1 www-data www-data 260 Jul 22 18:23 hash.conf.xml
-rw-r--r-- 1 www-data www-data 5346 Jul 22 18:23 httapi.conf.xml
-rw-r--r-- 1 www-data www-data 1731 Jul 22 18:23 http_cache.conf.xml
-rw-r--r-- 1 www-data www-data 155 Jul 22 18:23 ivr.conf.xml
-rw-r--r-- 1 www-data www-data 706 Jul 22 18:23 java.conf.xml
-rw-r--r-- 1 www-data www-data 2724 Jul 22 18:23 json_cdr.conf.xml
-rw-r--r-- 1 www-data www-data 3548 Jul 22 18:23 lcr.conf.xml
-rw-r--r-- 1 www-data www-data 1595 Jul 22 18:23 local_stream.conf
-rw-r--r-- 1 www-data www-data 1133 Jul 22 18:23 logfile.conf.xml
-rw-r--r-- 1 www-data www-data 2559 Jul 22 18:23 lua.conf.xml
-rw-r--r-- 1 www-data www-data 254 Jul 22 18:23 memcache.conf.xml
-rw-r--r-- 1 www-data www-data 1919 Aug 30 10:39 modules.conf.xml
-rw-r--r-- 1 www-data www-data 635 Jul 22 18:23 mongo.conf.xml
-rw-r--r-- 1 www-data www-data 2118 Jul 22 18:23 nibblebill.conf.xml
-rw-r--r-- 1 www-data www-data 698 Jul 22 18:23 opal.conf.xml
-rw-r--r-- 1 www-data www-data 1794 Jul 22 18:23 opus.conf.xml
-rw-r--r-- 1 www-data www-data 2108 Jul 22 18:23 osp.conf.xml
-rw-r--r-- 1 www-data www-data 583 Jul 22 18:23 perl.conf.xml
-rw-r--r-- 1 www-data www-data 534 Jul 22 18:23 pocketsphinx.conf.xml
-rw-r--r-- 1 www-data www-data 8818 Jul 22 18:23 portaudio.conf.xml
-rw-r--r-- 1 www-data www-data 110 Jul 22 18:23 post_load_modules.conf.xml
-rw-r--r-- 1 www-data www-data 196 Jul 22 18:23 presence_map.conf.xml
-rw-r--r-- 1 www-data www-data 574 Jul 22 18:23 python.conf.xml
-rw-r--r-- 1 www-data www-data 239 Jul 22 18:23 redis.conf.xml
-rw-r--r-- 1 www-data www-data 296 Jul 22 18:23 rss.conf.xml
-rw-r--r-- 1 www-data www-data 662 Jul 22 18:23 rtmp.conf.xml
-rw-r--r-- 1 www-data www-data 1453 Jul 22 18:23 sangoma_codec.conf.xml
-rw-r--r-- 1 www-data www-data 305 Jul 22 18:23 shout.conf.xml
-rw-r--r-- 1 www-data www-data 178 Jul 22 18:23 skinny.conf.xml
-rw-r--r-- 1 www-data www-data 488 Jul 22 18:23 smpp.conf.xml
-rw-r--r-- 1 www-data www-data 596 Jul 22 18:23 sofia.conf.xml
-rw-r--r-- 1 www-data www-data 3935 Jul 22 18:23 spandsp.conf.xml
-rw-r--r-- 1 www-data www-data 319 Jul 22 18:23 spidermonkey.conf.xml
-rw-r--r-- 1 www-data www-data 6934 Jul 22 18:23 switch.conf.xml
-rw-r--r-- 1 www-data www-data 745 Jul 22 18:23 syslog.conf.xml
-rw-r--r-- 1 www-data www-data 29447 Jul 22 18:23 timezones.conf.xml
-rw-r--r-- 1 www-data www-data 551 Jul 22 18:23 tts_commandline.conf.xml
-rw-r--r-- 1 www-data www-data 914 Jul 22 18:23 unicall.conf.xml
-rw-r--r-- 1 www-data www-data 899 Jul 22 18:23 unimrcp.conf.xml
-rw-r--r-- 1 www-data www-data 607 Jul 22 18:23 v8.conf.xml
-rw-r--r-- 1 www-data www-data 1334 Jul 22 18:23 verto.conf.xml
-rw-r--r-- 1 www-data www-data 3444 Jul 22 18:23 voicemail.conf.xml
-rw-r--r-- 1 www-data www-data 7906 Jul 22 18:23 voicemail_ivr.conf.xml
-rw-r--r-- 1 www-data www-data 4007 Jul 22 18:23 xml_cdr.conf.xml
-rw-r--r-- 1 www-data www-data 2890 Jul 22 18:23 xml_curl.conf.xml
-rw-r--r-- 1 www-data www-data 451 Jul 22 18:23 xml_rpc.conf.xml
-rw-r--r-- 1 www-data www-data 203 Jul 22 18:23 zeroconf.conf.xml

Seems like you don't have freeswitch-mod-pgsql installed. Please install it:
Bash:
apt install freeswitch-mod-pgsql

also, seems like you don't have a special file named pre_load_modules.conf.xml that mentioned at link from my first message at this thread:
https://freeswitch.org/confluence/display/FREESWITCH/Debian+9+Stretch

please create it:

Bash:
echo '<configuration name="pre_load_modules.conf" description="Modules">
  <modules>
    <!-- Databases -->
    <!-- <load module="mod_mariadb"/> -->
    <load module="mod_pgsql"/>
  </modules>
</configuration>' > /etc/freeswitch/autoload_configs/pre_load_modules.conf.xml

then set the file owner and group:

Bash:
chown www-data:www-data /etc/freeswitch/autoload_configs/pre_load_modules.conf.xml

and restart the freeswitch

Bash:
systemctl restart freeswitch

or reboot the system
 
Last edited:

kaz

New Member
Feb 25, 2019
12
2
3
53
Hi installed

apt install freeswitch-mod-pgsql

rebooted

no change

2019-08-30 17:42:01.100146 [ERR] switch_core_db.c:223 SQL ERR [unable to open database file]
2019-08-30 17:42:01.100146 [CRIT] switch_core_sqldb.c:622 Failure to connect to CORE_DB pgsql://hostaddr=127.0.0.1 port=5432 dbname=fusionpbx user=fusionpbx password=xxxxxxxxxxxxxxxx options=''!
2019-08-30 17:42:01.100146 [ERR] freeswitch_lua.cpp:374 Connection failed. DBH NOT Connected.
 

Minister

New Member
Aug 27, 2019
5
4
1
24
Hi installed

apt install freeswitch-mod-pgsql

rebooted

no change

2019-08-30 17:42:01.100146 [ERR] switch_core_db.c:223 SQL ERR [unable to open database file]
2019-08-30 17:42:01.100146 [CRIT] switch_core_sqldb.c:622 Failure to connect to CORE_DB pgsql://hostaddr=127.0.0.1 port=5432 dbname=fusionpbx user=fusionpbx password=xxxxxxxxxxxxxxxx options=''!
2019-08-30 17:42:01.100146 [ERR] freeswitch_lua.cpp:374 Connection failed. DBH NOT Connected.

Excuse me, but I made a typo mistake at my previous message (now corrected there as well), so please run as per follows:

Bash:
echo '<configuration name="pre_load_modules.conf" description="Modules">
  <modules>
    <!-- Databases -->
    <!-- <load module="mod_mariadb"/> -->
    <load module="mod_pgsql"/>
  </modules>
</configuration>' > /etc/freeswitch/autoload_configs/pre_load_modules.conf.xml

then set the file owner and group:

Bash:
chown www-data:www-data /etc/freeswitch/autoload_configs/pre_load_modules.conf.xml

and remove the file with incorrect name that previously was created
Bash:
rm /etc/freeswitch/autoload_configs/pre_load_modules1.conf.xml

then reboot
 
Last edited:

kaz

New Member
Feb 25, 2019
12
2
3
53
Thank you so so much for your help it worked database accessible and system working again. I still dont understand what broke on it on 14th August 2019 I can only assume some automatic upgrade broke it
 
Status
Not open for further replies.