Pandora version misaligned with Console

[diego-m]

Like it

Up

0

Down

Drop it

::

Hello Jon Russell,

Can you execute in mysql the next query?

SELECT * FROM tconfig WHERE token = 'current_package_enterprise'; 

Tell us what you get back and we’ll try to narrow it down.

Greetings
Diego

[JonRussell]

Like it

Up

0

Down

Drop it

::

MariaDB [pandora]> SELECT * FROM tconfig WHERE token = ‘current_package_enterprise’; 

+———–+—————————-+——-+
| id_config | token                      | value |
+———–+—————————-+——-+
|        83 | current_package_enterprise | 728   |
+———–+—————————-+——-+

[diego-m]

Like it

Up

0

Down

Drop it

::

Hello Jon Russel,

There you have it, change that value to the current version of pandora. I send you the query.

UPDATE tconfig SET value = ‘743’ WHERE token = ‘current_package_enterprise’;

This is not common but sometimes it happens that depending on how you have updated, this field may not be updated. We hope that after the change it will work properly and that it won’t happen again.

Greetings
Diego

[JonRussell]

Like it

Up

0

Down

Drop it

::

Thanks !
Message gone.

Regards,

Jon.

[JonRussell]

Like it

Up

0

Down

Drop it

::

I get this error after every update … am I missing something in the update process ?
I run yum update, then apply an MR scripts in the /var/www/html/pandora_console/extras/mr/
I restart all the services.

But every time I update to a new version, I get the alert “pandora version misaligned with Console”.

Today (after updating to 747) I have :

[root@pandora centos]# pandora_server -h
Pandora FMS Server 7.0NG.747 Build 200702 Copyright (c) 2004-2020 Artica ST

[root@pandora centos]# rpm -qa | grep pandorafms
pandorafms_console-7.0NG.747-1.noarch
pandorafms_server-7.0NG.747-1.noarch
pandorafms_agent_unix-7.0NG.747-1.x86_64

Bottom of the conlex page :
Pandora FMS v7.0NG.747 - Build PC200702 - MR 39

but in the DB it’s still 746 ?

MariaDB [pandora]> SELECT * FROM tconfig WHERE token = 'current_package_enterprise';
+-----------+----------------------------+-------+
| id_config | token                      | value |
+-----------+----------------------------+-------+
|        83 | current_package_enterprise | 746   |
+-----------+----------------------------+-------+

I can update it manually in the DB, but what is meant to update the DB current_package_enterprise entry after the package is updated ? am I missing a step ?

Thanks !

Jon.

[diego-m]

Like it

Up

0

Down

Drop it

::

Good morning

This error is given by updating via RPM, just like not applying the changes in database, and you have to run the RMs you will also have to make that small change manually. If you update using the online update manager, you should not have this problem since the MRs are applied and the change is made automatically in the database.

Greetings
Diego

[JonRussell]

Like it

Up

0

Down

Drop it

::

I cant seem to get rid of this error in the GUI any more.

“Pandora version misaligned with Console”

[root@pandora ~]# pandora_server -h
Pandora FMS Server v7.0NG.758 Build 211105

[root@pandora ~]# rpm -qa | grep pandorafms
pandorafms_console-7.0NG.758-211105.noarch
pandorafms_agent_unix-7.0NG.758-211105.x86_64
pandorafms_server-7.0NG.758-211105.noarch


In the Database :

SELECT * FROM tconfig WHERE token = 'current_package_enterprise'

+-----------+----------------------------+-------+
| id_config | token                      | value |
+-----------+----------------------------+-------+
|        83 | current_package_enterprise | 758   |
+-----------+----------------------------+-------+

At the bottom of the HTML page :

Pandora FMS v7.0NG.758 - OUM 758 - MR 50

So, everything seems to be set to “758”. But I still have the error on the website interface ?

Is the version stored anywhere else ?

Thanks.

Jon.

[vic]

Like it

Up

0

Down

Drop it

::

Hi JonRussell,

In the last versions of Pandora FMS the token “current_package_enterprise” has been changed to “current_package” so if this token doesn’t exist you will have to add it or modify the previous one.

(!) Check if the ID of the token “current_package_enterprise” is 83 in the tconfig table, if so, launch the following queries:

mysql> SELECT * FROM tconfig WHERE token LIKE ‘%current_package%’;
mysql> UPDATE tconfig SET token =’current_package’ WHERE id_config=83;
mysql> UPDATE tconfig SET value =’758′ WHERE token = ‘current_package’;

Best regards,
Víc

[JonRussell]

Like it

Up

0

Down

Drop it

::

Marvellous ! That’s fixed it.

Thanks !

Jon.

Hi JonRussell,

In the last versions of Pandora FMS the token “current_package_enterprise” has been changed to “current_package” so if this token doesn’t exist you will have to add it or modify the previous one.

(!) Check if the ID of the token “current_package_enterprise” is 83 in the tconfig table, if so, launch the following queries:

mysql> SELECT * FROM tconfig WHERE token LIKE ‘%current_package%’;
mysql> UPDATE tconfig SET token =’current_package’ WHERE id_config=83;
mysql> UPDATE tconfig SET value =’758′ WHERE token = ‘current_package’;

Best regards,
Víc