Vitals Tab: No Data

[goofyziggy]

Hi, I have Scrutinizer 6.0.1 on Windows 2003 server. The netflow part is running fine, all graphs work, all interfaces work, etc. The issue is only with the Vitals tab.

The Vitals tab was working just fine last time I checked it about 3 weeks ago. Now there's no data on any of the graphs, tables, nothing. Why would this happen, not sure. I seem to remember there's a file to reset the counters on the Vitals tab, or something like that which restarts the counters. I rebooted the server but this did not fix the issue. At any rate, was curious if anyone knew of ways to check what could be wrong with the Vitals page, thanks.

[benp]

Try logging into your mysql database and repairing the opstats table:

Code: Select all

cd %scrutdir%\mysql\bin\
mysql -u root scrutinizer
repair table scrutinizer.opstats;
exit;

If that doesn't work, you can also try stopping the "Scrutinizer Filed" service, deleting %scrutdir%\files\rrds\operations5.rrd, and then restarting the service. The graphs should start appearing again in about 5 minutes.

[goofyziggy]

Thanx Ben! You got the solution, a database table repair, it was not a file as I originally said, my bad. Per your instructions, I stopped the Scrutinizer service first, then using the MySQL Administrator tool GUI I ran the repair on the Scrutinizer.Opstats table selecting the Extended method. I could have done it on CLI but I like the MySQL Administrator proggie.

It seems the Vitals page is now getting data!! Thank you!!!

[ANPD]

I had the exact same issue. The repair worked.
Thanks.

[benp]

Great -- glad to hear this is helping a lot of people. I'm going to sticky this topic in case anyone else runs into the same trouble with version 6.

[lkalinowski]

Hello,

For me it's not working.
I repaired the table and I deleted the file. But it's not working better.

I'm having some graph for each port I'm using, but the graphs for the server are empty, and last value and average are "-1".

What can i do ?

[jghidoni]

Can you open a command prompt, navigate to scrutinzier\mysql\bin and run:
mysqlcheck --user=root scrutinizer

Do any database tables report errors or corruption?

If so, repair with the same process as before, start mysql command line, then enter:

repair table scrutinizer.{tablename};

Especially if scrutinizer.opstats is still displaying errors, that would explain why you are not seeing graphs for your server vitals.

- Joanne

[lkalinowski]

Hello,

There is no error on the database.

Here is the result :
F:\SCRUTINIZER\mysql\bin>mysqlcheck --user=root scrutiniz
scrutinizer.3rdparty OK
scrutinizer.accesslist OK
scrutinizer.activeif OK
scrutinizer.alarms OK
scrutinizer.apikey OK
scrutinizer.asnames OK
scrutinizer.centralsources OK
scrutinizer.conf OK
scrutinizer.conv_1m_template OK
scrutinizer.conv_template OK
scrutinizer.cookies OK
scrutinizer.denikaconnections OK
scrutinizer.gps OK
scrutinizer.groups OK
scrutinizer.historytables OK
scrutinizer.hosts OK
scrutinizer.hwsummary OK
scrutinizer.lastad OK
scrutinizer.netflows OK
scrutinizer.nodeconnections OK
scrutinizer.nodes OK
scrutinizer.opstats OK
scrutinizer.permissions OK
scrutinizer.policies OK
scrutinizer.protocols OK
scrutinizer.ptypes OK
scrutinizer.qos OK
scrutinizer.reports OK
scrutinizer.reportsas OK
scrutinizer.reportsdevices OK
scrutinizer.reportsfolders OK
scrutinizer.reportsfoldersmem OK
scrutinizer.reportsiprange OK
scrutinizer.reportsports OK
scrutinizer.reportsqos OK
scrutinizer.rollcall OK
scrutinizer.rssfeeds OK
scrutinizer.rtsession OK
scrutinizer.scheduledreports OK
scrutinizer.sessions OK
scrutinizer.snmpauth OK
scrutinizer.snmpif OK
scrutinizer.snmpsystem OK
scrutinizer.total_template OK
scrutinizer.userslist OK

So what can I check next ?

[jghidoni]

Can you go to Settings->Configuration, and tell me what your values are for:
Historical 1 Min Avg
Historical 5 Min Avg
Historical 30 Min Avg
....
Historical 1 Week Avg

- Joanne

[lkalinowski]

Here are the value :

Historical 1 Min Avg : 1
Historical 5 Min Avg : 5
Historical 30 Min Avg : 1
Historical 2 Hr Avg : 0
...
Historical 1 Week Avg : 0

By the way, we are testing a free edition at this time.

Regards,

[jghidoni]

Hello,

So you are keeping 1 minute data for 1 hour, 5 minute data for 5 hours, and 30 minute data for 1 day. What reports are you looking at that you see no data in?

- Joanne

[lkalinowski]

Hello, for all graph I'm having a value of -1 and no graph...

But for each port, it's working

I'd like to have all graph for the server to know how many flows are coming to the server, how many flows are dropped, and so on...

Regards

[nathanh]

If you are seeing -1 values for your graphs in the VITALS tab, it sounds like the OPSTATS table may have some corruption.

You might want to follow the instructions attached to this thread to repair that table. After repairing the table, give it about 30 minutes or so and see if your statistics start posting.

[Manodj]

After the upgrade and migration to v7.2.0 I do not see any graphs in the vitals tab:

From time to time I only see single vertical lines.
Strange enough I don't see history data for the CPU or any other vitals item either.
In this item I have read about this particular problem in v6. So I entered the commands to check the Scrutinizer databases. There were no errors of any kind. I still decided to enter the repair command on the scrutinizer.opstats table. After 24 hours of data the graphs are still not what it should be. How can this be solved without losing historical data?

Manodj

[jghidoni]

Hello Manodj,

Can you confirm that the Plixer Watcher service is running? And if it is, can you restart it and then check your Vitals graphs after 10-15 minutes?

- Joanne