Question

why my dashboard for host shows undetermined values or no values at all?

  • 30 March 2022
  • 16 replies
  • 587 views

Badge +3

 

 

 

 


16 replies

Userlevel 3
Badge +9

Hello @pooja,

Do you have any errors in the following log files ?

  • /var/log/centreon/eventReportBuilder.log
  • /var/log/centreon/dashboardBuilder.log

 

Regards.

Badge +3

Hi @itoussies

/var/log/centreon/eventReportBuilder.log

 

/var/log/centreon/dashboardBuilder.log

 

Userlevel 3
Badge +9

Maybe the related tables are empty… What is the result of the following SQL command (to do in the central server) :

SELECT * 
FROM centreon_storage.hoststateevents
WHERE host_id in (
SELECT host_id
FROM centreon.host
WHERE host_name='Centreon_Master'
);

 

Badge +3

@itoussies 

 

Badge +3

Hi Team,

 

Anything on this?? as my graph is still undetermined. :(

Userlevel 5
Badge +16

Hello @pooja ,

Could give us the timezone of your server and the timezone configure for php ?

You can send us the output of the following command:

timedatectl
grep -Riri date.timezone /etc/

Badge

ça signifie quoi la partie indéterminée dans un tableau de bord?

 

Badge +4

@chaimae C’est quand il n’y a aucunes données sur le statut d’un host/service.

par exemple, tu sélectionne un host que tu viens d’ajouter sur Centreon puis tu sélectionne la période “les 6 dernier mois”. Vu que ton host n’existait pas il y a quelques mois, aucunes données du statut du host existe. le statut est donc considéré indéterminée.

Badge +3

@Kriko please find the timezone of my server and timezone configured for php as asked 

 

Userlevel 5
Badge +16

Which version of Centreon are you ?

Badge +3

@Kriko it is Centreon version 21.04.9

Badge

Maybe the related tables are empty… What is the result of the following SQL command (to do in the central server) :

SELECT * 
FROM centreon_storage.hoststateevents
WHERE host_id in (
SELECT host_id
FROM centreon.host
WHERE host_name='Centreon_Master'
);

 

Hello, I have the same problem and apparently I don't have data when I run that query in SQL, does the same thing happen to anyone? How can I solve this problem, thank you very much!

 

Userlevel 3
Badge +11

@sylarion is this a new setup? could be the reason for the lack of data.

Badge

@sylarion is this a new setup? could be the reason for the lack of data.

Good morning! Happy 2023! It's not a new configuration, I'm in Argentina, Buenos Aires, what would be wrong with my configuration? Because I followed the instructions from the official Centreon page.

Userlevel 3
Badge +11

@sylarion how about

 

SELECT *  FROM centreon_storage.hoststateevents  
WHERE host_id in (
SELECT host_id
FROM centreon.host
)
LIMIT 10;

also, have you checked your cron jobs?

/etc/cron.d/centreon

Badge

@sylarion how about

 

SELECT *  FROM centreon_storage.hoststateevents  
WHERE host_id in (
SELECT host_id
FROM centreon.host
)
LIMIT 10;

also, have you checked your cron jobs?

/etc/cron.d/centreon

 

MariaDB [(none)]> SELECT *  FROM centreon_storage.hoststateevents
    -> WHERE host_id in (
    ->                    SELECT host_id
    ->                    FROM centreon.host
    ->               )
    -> LIMIT 10;
+-------------------+------------+---------+------------+-------+-------------+-------------+----------+--------+
| hoststateevent_id | end_time   | host_id | start_time | state | last_update | in_downtime | ack_time | in_ack |
+-------------------+------------+---------+------------+-------+-------------+-------------+----------+--------+
|                75 | 1673319600 |      87 | 1673273926 |     0 |           1 |           0 |     NULL |      0 |
|                76 | 1673319600 |      88 | 1673277780 |     0 |           1 |           0 |     NULL |      0 |
+-------------------+------------+---------+------------+-------+-------------+-------------+----------+--------+
2 rows in set (0.005 sec)
 

 

 

 

*******************************************************************************************************

cat /etc/cron

[root@Argentina~]# cat /etc/cron
cron.d/       cron.daily/   cron.deny     cron.hourly/  cron.monthly/ crontab       cron.weekly/
[root@Argentina~]# cat /etc/cron
cron.d/       cron.daily/   cron.deny     cron.hourly/  cron.monthly/ crontab       cron.weekly/
[root@Argentina~]# cat /etc/cron.d
cron.d/     cron.daily/ cron.deny
[root@Argentina~]# cat /etc/cron.d
cron.d/     cron.daily/ cron.deny
[root@Argentina~]# cat /etc/cron.d/cent
centreon     centstorage
[root@Argentina~]# cat /etc/cron.d/cent
centreon     centstorage
[root@Argentina~]# cat /etc/cron.d/cent
centreon     centstorage
[root@Argentina~]# cat /etc/cron.d/centreon
# ########################################
#
# Cron Configuration for Centreon
#
PATH=/sbin:/bin:/usr/sbin:/usr/bin

# rewrite file with new cron line
CRONTAB_EXEC_USER=""

############################
# Cron for CentACL
* * * * * apache /usr/bin/php -q /usr/local/centreon/cron/centAcl.php >> /usr/local/centreon/log/centAcl.log 2>&1

############################
# Cron for Centreon-Downtime
*/5 * * * * apache /usr/bin/php -q /usr/local/centreon/cron/downtimeManager.php >> /usr/local/centreon/log/downtimeManager.log 2>&1

############################
# Cron to build state events
0 3 * * * centreon /usr/local/centreon/cron/eventReportBuilder --config=/etc/centreon/conf.pm >> /usr/local/centreon/log/eventReportBuilder.log 2>&1

# Cron to build reporting
0 6 * * * centreon /usr/local/centreon/cron/dashboardBuilder --config=/etc/centreon/conf.pm >> /usr/local/centreon/log/dashboardBuilder.log 2>&1

 

 

Reply