Ad Widget

Collapse

Dumped/Migrated/Reinstall - No Live Data displayed anywhere

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • greggitter
    Junior Member
    • Feb 2022
    • 1

    #1

    Dumped/Migrated/Reinstall - No Live Data displayed anywhere

    *********** SOLVED ***************

    I'm having a strange issue after upgrading my Rpi from Raspian 32 to 64 bit. I thought this would go rather smoothly but not quite. I've spent about 12 hours trying to chase the problem down without luck.

    I dumped the database on the old system and did a clean import into the newly installed system (mariadb)...no errors. Bring up zabbix, my configured dashboards are there, user information, it even sent me one alert (not related to a host...host alerts are not working, but email is), all hosts are present with items and configured alerts. Yet, I see no data at all on any screen. The only place I can see data is to bring up an item for a host and click Test and it will show a live data value. Aside from that, there is no data in Dashboard/Latest Data, just empty columns.

    There are no errors in any of the logs, it appears the backend is working properly, turning debug=5 I can see connections, queries, snmp messages and all seems usual (admittedly, there's a lot of data there and some of it is difficult to comprehend). All processes are running. There don't seem to be any missing dependencies and permissions seem OK. Obviously I'm missing something. This is a fresh install with PHP 7.4 (the old system had the same). Zabbix is running on the same device as the database, nothing unusual about the install. I can't figure out if data is not getting pulled from the database or not posted to the screens through php/apache....not particularly knowledgeable about this aspect. I went ahead and installed 6.0 beta thinking that might "fix" whatever it is I missed, but no difference. The log shows the database was successfully updated. Checking the log of one of the agents, when the server was down, messages indicated the server was not reachable, when I brought it back, it indicated so...so the clients are talking. I can't tell if they are passing data except using the Items/Test (mentioned above) where data values are showing. Just nothing in the zabbix screens (dashboard, latest data, etc). There is data for users, media email information for alerts, and other config data...just no live data. That includes simple icmp pings.

    Is there anything I can check? Or is it possible this isn't quite compatible with Raspbian 64? I can post logs, etc. as needed. Thanks!

    EDIT: Seems the history table is empty, running select * from zabbix.history; returns zero records.

    EDIT 2 - SOLVED: I ended up dropping the database, recreating the dump from the old system using native mysql, grabbing ALL data (history was omitted prior), and reloading a new database; immediately solved the problem. Also verified and tweaked some permissions in etc/zabbix from zabbix:zabbix to root:root except from web being www-data:root and in that folder www-data:www-data. Zabbix 6rc2 is running well.

    Thanks to the devs for a great product!
    Last edited by greggitter; 08-02-2022, 18:44. Reason: Problem Solved
Working...