SOLVED Freeswitch gpg key not installing (fusionpbx auto install script)

Status
Not open for further replies.

meshtask

New Member
Jul 17, 2019
17
2
3
Hi
I installed FusionPBX latest version just a few days ago and it installed flawlessly.
I am trying to install it on a new server with Debian 11, and FusionPBX installs correctly but freeswitch installation fails.
I use auto install script of FusionPBX. In logs I have found that freeswitch gpg key installation fails.

I have tried using:
wget -O - https://files.freeswitch.org/repo/deb/debian/freeswitch_archive_g0.pub | sudo apt-key add -
and
curl https://files.freeswitch.org/repo/deb/debian/freeswitch_archive_g0.pub | add-key add -

but no luck. In logs it says User/Password Authetication failed.

Can anyone explain please why this is hapenning? I have tried it multiple times.
 

Attachments

  • FusionPBX-Freeswitch.PNG
    FusionPBX-Freeswitch.PNG
    13 KB · Views: 26

flagman

Member
Dec 1, 2020
30
2
8
40
You have to register a free account at signalwire website and get the token. This is a recent change made by signalwire.
 

meshtask

New Member
Jul 17, 2019
17
2
3
Hi
Added the key successfully, but now more issues.
auto install script of FusionPBX have following sources for apt:

deb http://files.freeswitch.org/repo/deb/freeswitch-1.6/ jessie main
deb http://files.freeswitch.org/repo/deb/debian-unstable/ jessie main


after adding the key by using token,when "apt update" is run, following errors encountered. (Debian 11 64 bit)

E: Failed to fetch http://files.freeswitch.org/repo/deb/freeswitch-1.6/dists/jessie/InRelease 401 Unauthorized [IP: 190.102.98.174 443]
E: The repository 'http://files.freeswitch.org/repo/deb/freeswitch-1.6 jessie InRelease' is not signed.
N: Updating from such a repository can't be done securely, and is therefore disabled by default.
N: See apt-secure(8) manpage for repository creation and user configuration details.
E: Failed to fetch http://files.freeswitch.org/repo/deb/debian-unstable/dists/jessie/InRelease 401 Unauthorized [IP: 190.102.98.174 443]
E: The repository 'http://files.freeswitch.org/repo/deb/debian-unstable jessie InRelease' is not signed.
N: Updating from such a repository can't be done securely, and is therefore disabled by default.
N: See apt-secure(8) manpage for repository creation and user configuration details.

It says Unauthorized IP.
 

agile

New Member
Oct 21, 2020
27
2
3
42
Hi All
I have got the same problem, i have installed the key from signalwire still when I login and go to status sip status I can't see any profiles
View and manage the status of system profiles and gateways.

sofia status
NameTypeDataStateAction
String could not be parsed as XML


sip status.PNG

Also installation shows error on postgress db
root@ip-10-10-1-4:/usr/src/fusionpbx-install.sh/debian# tail -10 /var/log/postgresql/postgresql-11-main.log
2022-03-21 18:09:41.928 UTC [23375] fusionpbx@fusionpbx ERROR: view "view_groups" does not exist
2022-03-21 18:09:41.928 UTC [23375] fusionpbx@fusionpbx STATEMENT: DROP VIEW view_groups;
2022-03-21 18:09:44.153 UTC [23548] fusionpbx@fusionpbx ERROR: view "view_users" does not exist
2022-03-21 18:09:44.153 UTC [23548] fusionpbx@fusionpbx STATEMENT: DROP VIEW view_users;
2022-03-21 18:09:46.914 UTC [23663] fusionpbx@fusionpbx ERROR: column "device_profile_uuid" does not exist at character 35
2022-03-21 18:09:46.914 UTC [23663] fusionpbx@fusionpbx STATEMENT: select * from v_device_keys where device_profile_uuid is not null
2022-03-21 18:09:46.925 UTC [23665] fusionpbx@fusionpbx ERROR: column "device_profile_uuid" does not exist at character 39
2022-03-21 18:09:46.925 UTC [23665] fusionpbx@fusionpbx STATEMENT: select * from v_device_settings where device_profile_uuid is not null
2022-03-21 18:09:47.632 UTC [23761] fusionpbx@fusionpbx ERROR: invalid input syntax for type boolean: "" at character 69
2022-03-21 18:09:47.632 UTC [23761] fusionpbx@fusionpbx STATEMENT: update v_domains set domain_enabled = 'true' where domain_enabled = '' or domain_enabled is null


When I login to fs_cli and give command reloadacl I get this error
2022-03-21 18:36:02.279663 [NOTICE] switch_core.c:1549 Adding 10.10.1.4/255.255.255.240 (allow) to list localnet.auto
2022-03-21 18:36:02.279663 [ERR] switch_core_db.c:241 SQL ERR [unable to open database file]
2022-03-21 18:36:02.279663 [CRIT] switch_core_sqldb.c:646 Failure to connect to CORE_DB pgsql://hostaddr=127.0.0.1 port=5432 dbname=fusionpbx user=fusionpbx password=SecureDBPassword options=''!
2022-03-21 18:36:02.279663 [ERR] freeswitch_lua.cpp:374 Connection failed. DBH NOT Connected.
2022-03-21 18:36:02.279663 [ERR] mod_lua.cpp:202 ...eeswitch/scripts/resources/functions/database/native.lua:27: assertion failed!
stack traceback:
[C]: in function 'assert'
...eeswitch/scripts/resources/functions/database/native.lua:27: in function 'new'
...hare/freeswitch/scripts/resources/functions/database.lua:87: in function <...hare/freeswitch/scripts/resources/functions/database.lua:86>
(...tail calls...)
...xml_handler/resources/scripts/configuration/acl.conf.lua:55: in main chunk
[C]: in function 'dofile'
/usr/share/freeswitch/scripts/app/xml_handler/index.lua:95: in main chunk
/usr/share/freeswitch/scripts/app.lua:48: in main chunk
2022-03-21 18:36:02.279663 [ERR] mod_lua.cpp:270 LUA script parse/execute error!
2022-03-21 18:36:02.279663 [INFO] mod_enum.c:884 ENUM Reloaded
2022-03-21 18:36:02.279663 [INFO] switch_time.c:1430 Timezone reloaded 530 definitions
freeswitch@ip-10-10-1-4>

I will appreciate if someone can advise.
 

meshtask

New Member
Jul 17, 2019
17
2
3
Hi All
I have got the same problem, i have installed the key from signalwire still when I login and go to status sip status I can't see any profiles
View and manage the status of system profiles and gateways.

sofia status
NameTypeDataStateAction
String could not be parsed as XML


View attachment 2823

Also installation shows error on postgress db
root@ip-10-10-1-4:/usr/src/fusionpbx-install.sh/debian# tail -10 /var/log/postgresql/postgresql-11-main.log
2022-03-21 18:09:41.928 UTC [23375] fusionpbx@fusionpbx ERROR: view "view_groups" does not exist
2022-03-21 18:09:41.928 UTC [23375] fusionpbx@fusionpbx STATEMENT: DROP VIEW view_groups;
2022-03-21 18:09:44.153 UTC [23548] fusionpbx@fusionpbx ERROR: view "view_users" does not exist
2022-03-21 18:09:44.153 UTC [23548] fusionpbx@fusionpbx STATEMENT: DROP VIEW view_users;
2022-03-21 18:09:46.914 UTC [23663] fusionpbx@fusionpbx ERROR: column "device_profile_uuid" does not exist at character 35
2022-03-21 18:09:46.914 UTC [23663] fusionpbx@fusionpbx STATEMENT: select * from v_device_keys where device_profile_uuid is not null
2022-03-21 18:09:46.925 UTC [23665] fusionpbx@fusionpbx ERROR: column "device_profile_uuid" does not exist at character 39
2022-03-21 18:09:46.925 UTC [23665] fusionpbx@fusionpbx STATEMENT: select * from v_device_settings where device_profile_uuid is not null
2022-03-21 18:09:47.632 UTC [23761] fusionpbx@fusionpbx ERROR: invalid input syntax for type boolean: "" at character 69
2022-03-21 18:09:47.632 UTC [23761] fusionpbx@fusionpbx STATEMENT: update v_domains set domain_enabled = 'true' where domain_enabled = '' or domain_enabled is null


When I login to fs_cli and give command reloadacl I get this error
2022-03-21 18:36:02.279663 [NOTICE] switch_core.c:1549 Adding 10.10.1.4/255.255.255.240 (allow) to list localnet.auto
2022-03-21 18:36:02.279663 [ERR] switch_core_db.c:241 SQL ERR [unable to open database file]
2022-03-21 18:36:02.279663 [CRIT] switch_core_sqldb.c:646 Failure to connect to CORE_DB pgsql://hostaddr=127.0.0.1 port=5432 dbname=fusionpbx user=fusionpbx password=SecureDBPassword options=''!
2022-03-21 18:36:02.279663 [ERR] freeswitch_lua.cpp:374 Connection failed. DBH NOT Connected.
2022-03-21 18:36:02.279663 [ERR] mod_lua.cpp:202 ...eeswitch/scripts/resources/functions/database/native.lua:27: assertion failed!
stack traceback:
[C]: in function 'assert'
...eeswitch/scripts/resources/functions/database/native.lua:27: in function 'new'
...hare/freeswitch/scripts/resources/functions/database.lua:87: in function <...hare/freeswitch/scripts/resources/functions/database.lua:86>
(...tail calls...)
...xml_handler/resources/scripts/configuration/acl.conf.lua:55: in main chunk
[C]: in function 'dofile'
/usr/share/freeswitch/scripts/app/xml_handler/index.lua:95: in main chunk
/usr/share/freeswitch/scripts/app.lua:48: in main chunk
2022-03-21 18:36:02.279663 [ERR] mod_lua.cpp:270 LUA script parse/execute error!
2022-03-21 18:36:02.279663 [INFO] mod_enum.c:884 ENUM Reloaded
2022-03-21 18:36:02.279663 [INFO] switch_time.c:1430 Timezone reloaded 530 definitions
freeswitch@ip-10-10-1-4>

I will appreciate if someone can advise.
I encountered this same issue after the token issue was solved . But kept watching FusionPBX github repository. This issue including token issue was solved within hours. I simple spun a new Debian 11 instance and ran the installation script again. It installed flawlessly. Token authentication was also not required at all. All was automatically done by the updated script.
 

meshtask

New Member
Jul 17, 2019
17
2
3
When i installed it yesterday,it was working. Now again in installation logs o see following error.

mod_pgsql.c:740:8: error: ‘PGRES_PIPELINE_SYNC’ undeclared (first use in this function) 740 | case PGRES_PIPELINE_SYNC:
 

Attachments

  • dbfpbx.PNG
    dbfpbx.PNG
    8.6 KB · Views: 12
Status
Not open for further replies.