ReportIT created reports tasks not exist.

[mohammadramadan]

Hello Bro,
I have upgraded my cacti deployment from 1.2.25 to 1.2.26, and the upgrade was successful But...
I have noticed that MacTrack plugin displays the number of Mac addresses working but when querying the mac addresses it gives nothing in the mac address tab, and the same with the REPORTIT plugin, the task is working daily I receive the reports but I can't find the reports to edit them in the cacti interface.
Now I have reinstalled the MACtrack plugin, suddenly I found both mactrack and reportit working and i can reach the created two reports.
now again same issue with the reportit, I cant see the reports to edit them but still receiving the reports at their scheduled time.

whats going on, thank you.

[macan]

mactrack version?

[mohammadramadan]

mactrack ver 4.6

[macan]

mactrack - try to set Show: aggragated.
It seems that there is any issue with display mac addresses

[mohammadramadan]

I have selected mactrack: mac address tab: then selected aggregated and it showed the mac addresses normally.

[mohammadramadan]

I have selected mactrack: mac address tab: then selected aggregated and it showed the mac addresses normally.

Hello Bro, Any ideas please?

[mohammadramadan]

mactrack - try to set Show: aggragated.
It seems that there is any issue with display mac addresses

Hello Bro, Any ideas please?

[macan]

I have mactrack on my TODO list, but there is a lot of work. Maybe this week

[mohammadramadan]

I have mactrack on my TODO list, but there is a lot of work. Maybe this week

Thanx alot, will be waiting.

[mohammadramadan]

Hello Bro,
I hope you had a chanse to have a look on this issue.
thank alot

[macan]

Management -> reports - you cannot see here any report?

Try to use button "Clear" in report filters. will there be any reports?

[mohammadramadan]

Hello Macan,
thank you so much for your response, I have clicked clear but stll no reports.
"I am still receiving my two reprtit tasks daily as scheduled but still cant find the two running tasks, or create any new ".

[macan]

Show results of sql queries:

select * from plugin_reportit_templates;

select * from plugin_reportit_reports;

[mohammadramadan]

It seems I am doing something wrong or the command needs tunning:
---------------------------Output---------------------
di@dar-cacti12:~$ sudo mysql
mysql: Deprecated program name. It will be removed in a future release, use '/us r/bin/mariadb' instead
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 1094468
Server version: 11.1.4-MariaDB-1:11.1.4+maria~ubu2204 mariadb.org binary distrib ution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]> select * from plugin_reportit_templates;
ERROR 1046 (3D000): No database selected
MariaDB [(none)]>
MariaDB [(none)]> select * from plugin_reportit_reports;
ERROR 1046 (3D000): No database selected
MariaDB [(none)]>
MariaDB [(none)]>
----------------------------END output------------------

[macan]

first:
use your_db_cacti_name;
select .....



your db name you can find in file your/cacti/include/config.php
or on your SQL server command "show databases;"