Folks…
is it possible that having poller in a different timezone of the main server can cause some issue ?
We just setup another poller (6th) and all of the first 5 are in the same timezone as our main server. Our 6th poller is in a complete different timezone and we are unable to “discover” devices that we add.
The addhost works fine but discovery failed.
validate.php return that everything is OK except :
====================================
| Component | Version |
|---|---|
| LibreNMS | 1.52-29-g3129dd314 |
| DB Schema | 2019_02_10_220000_add_dates_to_fdb (132) |
| PHP | 7.3.6-1+0~20190531112735.39+stretch~1.gbp6131b7 |
| MySQL | 10.3.13-MariaDB-1:10.3.13+maria~stretch-log |
| RRDTool | 1.6.0 |
| SNMP | NET-SNMP 5.7.3 |
====================================
[OK] Composer Version: 1.8.5
[OK] Dependencies up-to-date.
[OK] Database connection successful
[FAIL] Time between this server and the mysql database is off
Mysql time 2019-06-05 15:00:18
PHP time 2019-06-05 12:00:17
[OK] Database schema correct
And the discovery script give me:
librenms@rPIpoller:~$ ./discovery.php -h HOSTNAMEHIDDEN -d -v
LibreNMS Discovery
SQL[select migration from migrations order by id desc limit 1 [] 320.43ms]
SQL[select count(*) as aggregate from migrations limit 1 [] 435.54ms]
SQL[SELECT version() [] 444.3ms]
===================================
Version info:
Commit SHA: 3129dd3148e846b9adc88a349261db1ec82a3da3
Commit Date: 1559698904
DB Schema: 2019_02_10_220000_add_dates_to_fdb (132)
PHP: 7.3.6-1+0~20190531112735.39+stretch~1.gbp6131b7
MySQL: 10.3.13-MariaDB-1:10.3.13+maria~stretch-log
RRDTool: 1.6.0
SNMP: NET-SNMP 5.7.3
==================================DEBUG!
Updating os_def.cache…
Done
SQL[SELECT * FROM devices WHERE disabled = 0 AND snmp_disable = 0 AND hostname LIKE ‘HOSTNAMEHIDDEN’ AND poller_group IN(16) ORDER BY device_id DESC [] 455.46ms]
./discovery.php HOSTNAMEHIDDEN 2019-06-05 12:05:06 - 0 devices discovered in 2.758 secs
MySQL [1/0.46s]: Cell[1/0.45s] Row[-1/-0.45s] Rows[1/0.46s] Column[0/0.00s] Update[0/0.00s] Insert[0/0.00s] Delete[0/0.00s]
EDIT: My mistake… wrong poller_group ID in the config.php but still having a question if having different timezone can be a problem?