Closed WirthmU closed 7 years ago
I´m experiencing problems with automatic graph export. Works perfectly running "export now", The status is idle and it shows next time schedule, but nothing happens at that time, also i couldn´t find any information at log files.
Post a screen show of the Gexport page.
Also, please indicate your poller interval.
Also, post the output from this mysql command:
SELECT * FROM graph_exports\G
Pooler interval: 5 minutes
mysql> SELECT * FROM graph_exports; +----+-----------+-------------+---------+---------------------+-----------------------+---------------------+--------------+------------+------------+--------------+-------------+------------------+---------------+---------------+-----------+------------------+-----------------------+---------------+-------------+---------------+--------------+------------------------+-------------+-------------+----------------+-------------+-----------------+-------------------------+--------+------------+---------------------+---------------------+---------------------+---------------------+---------------------+-------------------+------------+--------------+ | id | name | export_type | enabled | export_presentation | export_effective_user | export_expand_hosts | export_theme | graph_tree | graph_site | graph_height | graph_width | graph_thumbnails | graph_columns | graph_perpage | graph_max | export_directory | export_temp_directory | export_timing | export_skip | export_hourly | export_daily | export_sanitize_remote | export_host | export_port | export_passive | export_user | export_password | export_private_key_path | status | export_pid | next_start | last_checked | last_started | last_ended | last_errored | last_runtime | last_error | total_graphs | +----+-----------+-------------+---------+---------------------+-----------------------+---------------------+--------------+------------+------------+--------------+-------------+------------------+---------------+---------------+-----------+------------------+-----------------------+---------------+-------------+---------------+--------------+------------------------+-------------+-------------+----------------+-------------+-----------------+-------------------------+--------+------------+---------------------+---------------------+---------------------+---------------------+---------------------+-------------------+------------+--------------+ | 2 | Dash2 | local | tree | 1 | on | classic | 26 | 100 | 300 | 2 | 20 | 2000 | /var/www/cacti2 | /tmp/ | periodic | 2 | 00 | 00:00 | |||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0 | 2017-05-03 18:10:00 | 2017-05-03 18:00:17 | 2017-05-03 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
18:00:17 | 2017-05-03 18:00:17 | 0000-00-00 00:00:00 | 0.078090906143188 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
NULL | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
3 | Dashboard | local | on | tree | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1 | off | paw | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
100 | 300 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2 | 20 | 2000 | /var/www/cacti | /tmp/ | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
periodic | 1 | 00 | 00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
39066 | 2017-05-08 18:06:00 | 2017-05-15 11:45:00 | 2017-05-15 11:45:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2017-05-15 11:43:42 | 0000-00-00 00:00:00 | 222.11595487595 | NULL | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
646 |
+----+-----------+-------------+---------+---------------------+-----------------------+---------------------+--------------+------------+------------+--------------+-------------+------------------+---------------+---------------+-----------+------------------+-----------------------+---------------+-------------+---------------+--------------+------------------------+-------------+-------------+----------------+-------------+-----------------+-------------------------+--------+------------+---------------------+---------------------+---------------------+---------------------+---------------------+-------------------+------------+--------------+
[image: Imagem inline 1]
2017-05-14 16:14 GMT-03:00 Jimmy Conner notifications@github.com:
Also, post the output from this mysql command:
SELECT * FROM graph_exports\G
— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/Cacti/plugin_gexport/issues/8#issuecomment-301333361, or mute the thread https://github.com/notifications/unsubscribe-auth/AbOPkUepBctciC8StTBipNNCEObDyP9Hks5r51KIgaJpZM4NNbPM .
-- Eng. Igor C. Escoura iescoura@gmail.com
My poller interval is set to 5 minutes.
The printscreens are attached
I have the same issue as WirthmU first post. My poller is at every minute.
Any news to this issue? It seems that I am not the only one that has problems.
The issue has been fixed on my side. I've tested a few things including disable/enable back the plugin and now it works.
Now it works for me too!
Thanks!
Gexport is working from both the command line and also using graph export plugin using "export now" function.
What does not work is "Export Timing" with timing method periodic/polling cycle or hourly/daily.
Gexport status is on idle (green) and next start remains in the past.