Fwconsole restart shows SQL error (notifications table - Paging pro entry) after freePBX 15 Update

Charles_Darwin · July 26, 2021, 4:53pm

I think this is new…today I updated my freePBX 15 server through the web-ui and now when I do a fwconsole restart I see this:

Running FreePBX startup...
Running Asterisk pre from Firewall module
Running Asterisk pre from Sysadmin module
Running Sysadmin Hooks
Restarting fail2ban
fail2ban Restarted
Updating License Information for 1xxxxxxxxx
Checking Vpn server 
Starting Asterisk...
[============================] 1 sec
Asterisk Started
Running Asterisk post from Core module
Running Asterisk post from Pagingpro module
SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'link' cannot be null
[root@pbx ~]# 
Broadcast message from [email protected] (Mon Jul 26 18:47:20 2021):

Firewall service now starting.

Any ideas? My webbrowser crashed during the update process.

EDIT: I also saw the sha1 error with Zulu during the update…by the way

PitzKey · July 26, 2021, 5:11pm

This is why I NEVER do updates through the GUI.
IDK why, but I have a feeling this is Zulu. Do you have zulu installed?

MariaDB [(none)]> SELECT
    -> table_name,
    -> column_name,
    -> data_type,
    -> ordinal_position
    -> FROM INFORMATION_SCHEMA.COLUMNS
    -> WHERE table_schema = 'asterisk'
    -> AND column_name = 'link' ;
+--------------------------------+-------------+-----------+------------------+
| table_name                     | column_name | data_type | ordinal_position |
+--------------------------------+-------------+-----------+------------------+
| digiumaddoninstaller_addons    | link        | varchar   |                4 |
| notifications                  | link        | varchar   |                6 |
| zulu_interactions_stream_links | link        | longtext  |                2 |
+--------------------------------+-------------+-----------+------------------+
3 rows in set (0.64 sec)

What is the output of:
(Run mysql)

select * from asterisk.digiumaddoninstaller_addons;
describe asterisk.digiumaddoninstaller_addons;
select * from asterisk.zulu_interactions_stream_links;
describe asterisk.zulu_interactions_stream_links;

Charles_Darwin · July 26, 2021, 5:20pm

Zulu was uninstalled on my machine. I now installed it (but disabled it), but still the same error.

Here is the mysql output:

MariaDB [asterisk]> select * from asterisk.digiumaddoninstaller_addons;
+------+----------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------+-----------------------------------------------------------------------------+---------------+----------------+----------------+---------------+-------------------+--------------+-------------+---------------+
| id   | name                             | description                                                                                                                                                                                                                                                                                                                                                                                                                                      | link                                                           | documentation                                                               | product_index | category_index | register_limit | status        | supported_version | is_installed | is_uptodate | is_registered |
+------+----------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------+-----------------------------------------------------------------------------+---------------+----------------+----------------+---------------+-------------------+--------------+-------------+---------------+
| dpma | Digium Phone Module for Asterisk | Digium Phone Module for Asterisk                                                                                                                                                                                                                                                                                                                                                                                                                 | http://store.digium.com/productview.php?product_code=804-00032 | http://www.digium.com/en/products/software/digium-phone-module-for-asterisk |            10 |              0 |              0 | not_installed | 0.1               |            1 |           1 |             1 |
| g729 | G.729 Codec                      | Digium's G.729 Codec is a software module for Asterisk that compresses the audio data stream to use significantly less network bandwidth than a standard or uncompressed VoIP call. This allows more calls to be carried without increasing network capacity and allows voice to travel on limited-bandwidth connections that would otherwise not support VoIP. To purchase a license key, visit http://www.digium.com/en/products/g729codec.php | http://www.digium.com/en/products/g729codec.php                | https://www.digium.com/en/products/software/g729-codec                      |             4 |              0 |              0 | not_installed | 0.1               |            0 |           0 |             0 |
+------+----------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------+-----------------------------------------------------------------------------+---------------+----------------+----------------+---------------+-------------------+--------------+-------------+---------------+
2 rows in set (0.00 sec)

MariaDB [asterisk]> describe asterisk.digiumaddoninstaller_addons;
+-------------------+------------------+------+-----+---------------+-------+
| Field             | Type             | Null | Key | Default       | Extra |
+-------------------+------------------+------+-----+---------------+-------+
| id                | varchar(25)      | NO   | PRI | NULL          |       |
| name              | varchar(255)     | NO   |     |               |       |
| description       | text             | YES  |     | NULL          |       |
| link              | varchar(255)     | NO   |     |               |       |
| documentation     | varchar(255)     | NO   |     |               |       |
| product_index     | int(10) unsigned | NO   |     | NULL          |       |
| category_index    | int(10) unsigned | NO   |     | NULL          |       |
| register_limit    | int(10) unsigned | NO   |     | 0             |       |
| status            | varchar(50)      | NO   |     | not_installed |       |
| supported_version | varchar(50)      | YES  |     | 0.1           |       |
| is_installed      | tinyint(1)       | NO   |     | 0             |       |
| is_uptodate       | tinyint(1)       | NO   |     | 0             |       |
| is_registered     | tinyint(1)       | NO   |     | 0             |       |
+-------------------+------------------+------+-----+---------------+-------+
13 rows in set (0.00 sec)

MariaDB [asterisk]> select * from asterisk.zulu_interactions_stream_links;
Empty set (0.01 sec)

MariaDB [asterisk]> describe asterisk.zulu_interactions_stream_links;
+-----------+-------------+------+-----+---------+-------+
| Field     | Type        | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| stream_id | varchar(36) | NO   |     | NULL    |       |
| link      | longtext    | NO   |     | NULL    |       |
+-----------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

MariaDB [asterisk]>

Thanks @PitzKey …so it seems to be bug, right?

lgaetz · July 26, 2021, 5:33pm

The digium addons module doesn’t really do much of anything, do you need it installed?

Charles_Darwin · July 26, 2021, 5:35pm

I think I once registered a new version of DPMA with it…and later found out that it wasn’t necessary to register.
But isn’t the error related to Zulu with missing link entries in one table?

Charles_Darwin · July 26, 2021, 6:41pm

Does anybody know, who is complaining about the empty table asterisk.zulu_interactions_stream_links? Which module is it? Maybe I can downgrade it…
Zulu is already disabled…so it must be some other module…am I wrong?
Maybe others have the same problem, but havent done a “fwconsole restart” since the last updates!

EDIT: The error above means “You are trying to store a null value in a NOT NULL column.”…so which module is doing it?

jfinstrom · July 26, 2021, 8:08pm

/var/www/html/admin/modules/zulu/module.xml:		<table name="zulu_interactions_stream_links">

So it is obviously zulu but something somewhere is calling it direct (which is always dumb for this reason) I can’t grep it out because it is in an obfuscated module

Charles_Darwin · July 26, 2021, 8:44pm

ok…it was the notifications table. I changed the link-column and allowed NULL. Now the error during fwconsole restart is gone.
In the notifications table there are two new entries with link-value NULL and they belong to the paging pro module. Interesting…

Don’t worry about the tampered file. I have to adjust CID-Superfecta to work with Umlaute and Herold.at

EDIT: My working hypothesis is that there is a bug in the newest version of the Dashboard or whatever handles the notifications…or it is the paging-pro module, which reports in the wrong format

By the way…no paging groups use any calendar. So I don’t know where the message comes from.

PitzKey · July 26, 2021, 9:50pm

Please report this: issues.freepbx.org

Please post the ticket number here.

Charles_Darwin · July 26, 2021, 10:13pm

Still dont know if this is unique to my freePBX 15 server. If notifications stop working on other machines (especially the page pro ones), we would know…

EDIT: It might be related to the fact that I upgraded this machine from freePBX 14 to 15. Another possibility is that during the recent module updates something went wrong. Everything seems to work so far…

PitzKey · July 27, 2021, 8:40am

File a report with the most info possible, if they can reproduce, then good, if not, they will close it… Nothing to lose…

Charles_Darwin · July 27, 2021, 5:21pm

ok…I did

https://issues.freepbx.org/browse/FREEPBX-22692

Charles_Darwin · July 28, 2021, 4:58pm

New (Edge) version of Paging pro is available, which fixes the issue.

system · August 4, 2021, 4:58pm

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.