CereusReporting - PDF Reports - 4.00 for Cacti 1.x out soon!

xefil · Post by **xefil** » Tue Jun 22, 2010 3:33 am

Autosolved again, but installing the additional Report Engine, thank you a lot, now I'm taking a look possibility to upgrade to corporate or professional. many thank's!

simon

phalek · Post by **phalek** » Tue Jun 22, 2010 3:40 am

Just one remark, the 2x2 column report is buggy at the moment. I have to dig into this to fix it.

You may also want to to look at BBCacti a Blackberry client for Cacti which does include nmidCreatePDF support ( adding graphs to a report from your blackberry )

http://www.network-outsourcing.de/bbcacti.html

There will be clients for Windows Mobile, Blackberry and Android available for doing this.

xefil · Post by **xefil** » Tue Jun 22, 2010 9:36 am

Hello!

Now that the plugin works perfectly, it seems it causes a big problem on the poller. The poller (SPINE) doesn't start at all.
If I uninstall the plugin, all works perfectly. It's not enough disable the plugin, I must uninstall to have the poller works again, otherwise all my graphs stop to be updated. I've enabled the debug and on the cron minute I can see the poller start but no logs in debug mode. Uninstalling the plugin all goes well.
Maybe some plugin_hooks, priviledges or what else?
Ideas?

thanks!

Simon

phalek · Post by **phalek** » Tue Jun 22, 2010 9:49 am

this only happen when the sourceguardian ixed loaders are not correctly loaded.

How did you install the loader, through php.ini or using the "dl()" method ?

Other than that the plugin ( at least the free and pro variants ) do not do anything during polling cycle ....

xefil · Post by **xefil** » Tue Jun 22, 2010 10:25 am

I've copied the ixed loader into "/usr/lib/php/modules/" and its called from php.ini with:

extension=ixed.5.1.lin

Simon

phalek · Post by **phalek** » Tue Jun 22, 2010 12:04 pm

any chance we could have a look at the system or does your company policies forbid remote support ?

phalek · Post by **phalek** » Tue Jun 22, 2010 2:22 pm

Version 0.84 is available now Build 39:

- Fixed 2x2 column bug
- Removed Watermark from Free version when using the mPDF engine
- change the poller code in the setup.php file

If you use the "Free" Edition, please set the "Scheduler being used" option to "Cron". This will prevent the poller code to be run at all ( only used for scheduling )

xefil · Post by **xefil** » Wed Jun 23, 2010 1:59 am

phalek wrote:any chance we could have a look at the system or does your company policies forbid remote support ?

Really difficult, near impossible. The servers are on private lan too. btw, I could try the new 0.84. Strange is, as said, the poller doesn't start at all if the plugin is installed. I'll try the last build and before the install delete ANY record concern '%NMID%'.

Any other idea is appreciated

phalek · Post by **phalek** » Wed Jun 23, 2010 2:06 am

Somehow you are able to connect to the servers

The remote support tool is quite easy:

I connect to your workstation where you can see and follow everything I do, or if preferred, I only tell you where to go to and what to do. I would not connect directly to the servers.

THe only requirement for this to work is that your workstation is able to connect to the internet (directly or via a normal proxy ).

--
Nevertheless, do the logs not show up anything ? Either cacti log or syslog ? You may have to enable error logging in the php.ini file, it is normally turned off by default .

xefil · Post by **xefil** » Wed Jun 23, 2010 2:14 am

phalek wrote: I connect to your workstation where you can see and follow everything I do, or if preferred, I only tell you where to go to and what to do. I would not connect directly to the servers.

Internal policies doesn't allow me to obtain external access, even if I'm really sure about the trusted support you could give me. I could follow your suggestions here or in MSN in example

About cacti.log: If the plugin is installed (enabled or disabled is the same) and I'm on 'tail -f' on cacti.log, on scheduled time (cron) nothing shows up.
On /var/log/cron I can see that the poller is called, also it starts but nothing is logged.
Now I'll try to install last build and delete all nmid entries before. After that, enable error log and wait */5.

Thank's!!

Simon

xefil · Post by **xefil** » Wed Jun 23, 2010 3:05 am

Enabling DEBUG mode in cacti, the ONLY lines logged on cron start are:

Code: Select all

06/23/2010 09:55:01 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook = 'config_arrays'"
06/23/2010 09:55:01 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT * FROM plugin_realms ORDER BY plugin, display"
06/23/2010 09:55:01 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin = 'aggregate' AND file = 'aggregate_templates.php,aggregate_templates_items.php,color_templates.php,color_templates_items.php'"
06/23/2010 09:55:01 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin = 'nectar' AND file = 'nectar.php,nectar_edit.php'"
06/23/2010 09:55:01 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin = 'reportit' AND file = 'cc_view.php,cc_charts.php'"
06/23/2010 09:55:01 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin = 'reportit' AND file = 'cc_reports.php,cc_rrdlist.php,cc_items.php,cc_run.php'"
06/23/2010 09:55:01 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin = 'reportit' AND file = 'cc_templates.php,cc_measurands.php,cc_variables.php'"
06/23/2010 09:55:01 AM - CMDPHP: Poller[0] DEVEL: SQL Cell: "SELECT status FROM plugin_config WHERE directory = 'reportit'"
06/23/2010 09:55:01 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin = 'weathermap' AND file = 'weathermap-cacti-plugin.php'"
06/23/2010 09:55:01 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin = 'weathermap' AND file = 'weathermap-cacti-plugin-mgmt.php'"

Then *nothing*

Otherwise, uninstalling the plugin, all goes well:

Code: Select all

06/23/2010 10:00:01 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin = 'nectar' AND file = 'nectar.p
hp,nectar_edit.php'"
06/23/2010 10:00:01 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin = 'reportit' AND file = 'cc_vie
w.php,cc_charts.php'"
06/23/2010 10:00:01 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin = 'reportit' AND file = 'cc_rep
orts.php,cc_rrdlist.php,cc_items.php,cc_run.php'"
06/23/2010 10:00:01 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin = 'reportit' AND file = 'cc_tem
plates.php,cc_measurands.php,cc_variables.php'"
06/23/2010 10:00:01 AM - CMDPHP: Poller[0] DEVEL: SQL Cell: "SELECT status FROM plugin_config WHERE directory = 'reportit'"
06/23/2010 10:00:01 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin = 'weathermap' AND file = 'weat
hermap-cacti-plugin.php'"
06/23/2010 10:00:01 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin = 'weathermap' AND file = 'weat
hermap-cacti-plugin-mgmt.php'"
06/23/2010 10:00:01 AM - CMDPHP: Poller[0] DEVEL: SQL Cell: "SELECT directory FROM plugin_config WHERE directory='boost' and status='1'
"
06/23/2010 10:00:01 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin = 'superlinks' AND file = 'supe
rlinks.php'"
06/23/2010 10:00:01 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin = 'superlinks' AND file = 'supe
rlinks-mgmt.php'"
06/23/2010 10:00:01 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook =
 'config_settings'"
06/23/2010 10:00:01 AM - CMDPHP: Poller[0] DEVEL: SQL Cell: "select value from settings where name='cfgm_IPmanagers'"
06/23/2010 10:00:01 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT id FROM plugin_realms WHERE plugin='reportit' ORDER BY id ASC"
06/23/2010 10:00:01 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook =
 'valid_host_fields'"
06/23/2010 10:00:01 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook =
 'config_form'"
06/23/2010 10:00:01 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook =
 'config_insert'"
06/23/2010 10:00:01 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook =
 'poller_top'"
06/23/2010 10:00:01 AM - CMDPHP: Poller[0] DEVEL: SQL Cell: "SELECT COUNT(*) FROM poller_item WHERE rrd_next_step<=0"
06/23/2010 10:00:01 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT host_id, COUNT(*) AS data_sources       FROM poller_item       WHE
RE rrd_next_step<=0       GROUP BY host_id       ORDER BY host_id"
06/23/2010 10:00:01 AM - POLLER: Poller[0] NOTE: Poller Int: '300', Cron Int: '300', Time Since Last: '900', Max Runtime '298', Poller
Runs: '1'
06/23/2010 10:00:01 AM - POLLER: Poller[0] WARNING: Cron is out of sync with the Poller Interval!  The Poller Interval is '300' seconds
, with a maximum of a '300' second Cron, but 900 seconds have passed since the last poll!
06/23/2010 10:00:01 AM - CMDPHP: Poller[0] DEVEL: SQL Exec: "REPLACE INTO settings (name,value) VALUES ('poller_lastrun',1277280001)"
06/23/2010 10:00:01 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT id FROM host WHERE disabled = '' ORDER BY id"
06/23/2010 10:00:01 AM - CMDPHP: Poller[0] DEVEL: SQL Exec: "REPLACE INTO settings (name,value) VALUES ('path_webroot','/opt/cacti')"
06/23/2010 10:00:01 AM - CMDPHP: Poller[0] DEVEL: SQL Exec: "TRUNCATE TABLE poller_time"
06/23/2010 10:00:01 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT local_data_id, rrd_name FROM poller_output"
06/23/2010 10:00:01 AM - POLLER: Poller[0] WARNING: Poller Output Table not Empty.  Issues Found: 2, Data Sources: (DS[334]), (DS[810])
06/23/2010 10:00:01 AM - CMDPHP: Poller[0] DEVEL: SQL Exec: "TRUNCATE TABLE poller_output"
06/23/2010 10:00:01 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "SELECT name, file, function FROM plugin_hooks WHERE status = 1 AND hook =
 'poller_command_args'"
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'path_php_binary''
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEBUG: The path_php variable is /usr/bin/php
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'availability_method''
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEBUG: The availability_method variable is 3
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'ping_recovery_count''
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEBUG: The ping_recovery_count variable is 3
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'ping_failure_count''
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEBUG: The ping_failure_count variable is 2
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'ping_method''
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEBUG: The ping_method variable is 1
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'ping_retries''
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEBUG: The ping_retries variable is 1
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'ping_timeout''
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEBUG: The ping_timeout variable is 400
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'snmp_retries''
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEBUG: The snmp_retries variable is 3
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'log_perror''
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEBUG: The log_perror variable is 1
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'log_pwarn''
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEBUG: The log_pwarn variable is 1
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'boost_redirect''
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEBUG: The boost_redirect variable is 0
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'log_pstats''
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEBUG: The log_pstats variable is 1
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'max_threads''
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEBUG: The threads variable is 20
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'poller_interval''
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEBUG: The polling interval is 300 seconds
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'concurrent_processes''
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEBUG: The number of concurrent processes is 5
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'script_timeout''
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEBUG: The script timeout is 12
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'php_servers''
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEBUG: The number of php script servers to run is 4
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEVDBG: SQL:'SELECT action FROM poller_item WHERE action=2 AND host_id BETWEEN 0 AND 79 LIMIT
 1'
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEBUG: StartHost='0', EndHost='79', TotalPHPScripts='1'
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEBUG: The PHP Script Server is Required
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'max_get_size''
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEBUG: The Maximum SNMP OID Get Size is 15
06/23/2010 10:00:01 AM - SPINE: Poller[0] SPINE: Initializing Net-SNMP API
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEBUG: SNMP Header Version is 5.3.1
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEBUG: SNMP Library Version is 5.3.1
06/23/2010 10:00:01 AM - SPINE: Poller[0] SPINE: Initializing PHP Script Server(s)
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEBUG: SS[0] PHP Script Server Routine Starting
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEBUG: SS[0] PHP Script Server About to FORK Child Process
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEBUG: SS[0] PHP Script Server Child FORK Success
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'path_php_binary''
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEBUG: The path_php variable is /usr/bin/php
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'availability_method''
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEBUG: The availability_method variable is 3
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'ping_recovery_count''
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEBUG: The ping_recovery_count variable is 3
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'ping_failure_count''
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEBUG: The ping_failure_count variable is 2
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEVDBG: SQL:'SELECT value FROM settings WHERE name = 'ping_method''
06/23/2010 10:00:01 AM - SPINE: Poller[0] DEBUG: The ping_method variable is 1
(...)

Ideas?

I've deleted all NMID mysql entries and reinstalled the last version fresh, setting the scheduler method to CRON.

Simon

phalek · Post by **phalek** » Wed Jun 23, 2010 3:35 am

did you enable the php error log ?

xefil · Post by **xefil** » Wed Jun 23, 2010 4:04 am

phalek wrote:did you enable the php error log ?

On php.ini:

Code: Select all

[root@cacti ~]# grep -i error /etc/php.ini | grep -v \;
error_reporting  =  E_ALL
display_errors = On
display_startup_errors = Off
log_errors = On
log_errors_max_len = 1024
ignore_repeated_errors = Off
track_errors = Off
sybase.min_error_severity = 10
mssql.min_error_severity = 10
[root@cacti ~]#

Should be enough

phalek · Post by **phalek** » Wed Jun 23, 2010 4:14 am

put a line in the section where the "error_reporting" is ( or uncomment it ):

Code: Select all

error_log = syslog

All php errors will then display in syslog. Alternatively you can also specify a file.

xefil · Post by **xefil** » Thu Jun 24, 2010 7:04 am

Hello, here the last news with all enabled:

Code: Select all

Jun 24 13:57:07 cacti httpd: PHP Warning:  Invalid argument supplied for foreach() in /opt/cacti/lib/plugins.php on line 128
Jun 24 13:57:07 cacti last message repeated 7 times
Jun 24 14:00:01 cacti php: PHP Fatal error:  Cannot redeclare title_trim() (previously declared in /opt/cacti/lib/functions.php:32) in /root/functions.php on line 38

At 14:00 the cron is started, no logs and no updates.

A doubt:
With last Plugin Architecture do I have to specify the plugin into '/opt/cacti/include/global.php'? I don't think it's mandatory...

Any help?

Simon

Cacti

CereusReporting - PDF Reports - 4.00 for Cacti 1.x out soon!

poller issue

Who is online