Plugin Mangement page show garbage

[kos]

Hi all,

I installed cacti 0.8.7d including PA 2.4.

The single steps were:

- rename existing Cacti installaion
- install 0.8.7d and move rra's, scripts etc to new installation (works fine)
- install PA 2.4 and changed config, global.php and import the pa.sql (plugin checkbox visible in Realm)
- move old plugins to the new folder
- activate "Plugin Management" in Realm table

Result: everything works fine (graphs, weathermap, monitor ....plugins) except the plugin managment page which shows trash (see below)

Any idea?

Thanks

Kai

[kos]

Could solve the problem by rolling back from php 5.2.8 to 5.2.5

cheers

Kai

[TheWitness]

Very interesting. Please provide more details about your os and how you obtained php.

TheWitness

[kos]

Hi Witness,

with PHP 5.2.8 I get the messy view. Php.5.2.5 and 5.2.9 show each similar results, but the tabs "Installed ..." are still missing (see graph).

PHP I get from http://museum.php.net/php5/ as win.zip

PIA works fine with the old plugins and shows problems only with newly installed plugins, like rrdclean, aggregate and thold which I installed according to the new definition. I can see all menues etc, but as soon as data needs to be stored to database, nothing happens or I get error messages in log.

e.g
------------------------------------------------------------------
rrd clean does not allow to store data to database. In the log I can see the following error messages;

03/04/2009 03:47:10 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1366', SQL:"INSERT INTO `plugin_rrdclean` VALUES('', 'sg128sg0nsm0002_com_trusted_traffic_in_1698.rrd', '2008-10-08 04:06:04', '0.18', 'None', '0', '0', 'None')'
-------------------------------------------------------------------
thold does not allow to add devices.


3/04/2009 03:51:21 PM - POLLER: Poller[0] THOLD: Can not send Host Recovering email since the 'Alert e-mail' setting is not set!
03/04/2009 03:51:21 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1054', SQL:"UPDATE thold_data SET tcheck = 0'
03/04/2009 03:51:21 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT * FROM thold_data WHERE thold_enabled = 'on' AND tcheck = 1"
03/04/2009 03:51:21 PM - SYSTEM STATS: Time:20.6610 Method:spine Processes:2 Threads:10 Hosts:170 HostsPerProcess:85 DataSources:1825 RRDsProcessed:1007
03/04/2009 03:51:01 PM - CACTID: Poller[0] Host[6] NOTICE: HOST EVENT: Host Returned from DOWN State

----------------------------------------------------------
Your help is really appreciated as I dont know how to continue.

Thanks

Kai

• Technical Support
  General Information
  Date Wed, 04 Mar 2009 15:16:00 +0000
  Cacti Version 0.8.7d
  Cacti OS win32
  SNMP Version NET-SNMP version: 5.3.0.1
  RRDTool Version RRDTool 1.2.x
  Hosts 180
  Graphs 1041
  Data Sources SNMP: 32
  SNMP Query: 878
  Script - Script Server (PHP): 169
  Total: 1079
  Poller Information
  Interval 300
  Type spine
  Items Action[0]: 1664
  Action[2]: 161
  Total: 1825
  Concurrent Processes 2
  Max Threads 10
  PHP Servers 2
  Script Timeout 300
  Max OID 25
  Last Run Statistics Time:21.9105 Method:spine Processes:2 Threads:10 Hosts:170 HostsPerProcess:85 DataSources:1825 RRDsProcessed:1007
  PHP Information
  PHP Version 5.2.8
  PHP OS WINNT
  PHP uname Windows NT S128A305 5.2 build 3790
  PHP SNMP Installed
  max_execution_time 90
  memory_limit 128M
  MySQL Table Information
  Name Rows Engine Collation Check Status
  cdef 24 MyISAM latin1_swedish_ci OK
  cdef_items 36 MyISAM latin1_swedish_ci OK
  colors 108 MyISAM latin1_swedish_ci OK
  data_input 13 MyISAM latin1_swedish_ci OK
  data_input_data 9104 MyISAM latin1_swedish_ci OK
  data_input_fields 56 MyISAM latin1_swedish_ci OK
  data_local 1079 MyISAM latin1_swedish_ci OK
  data_template 58 MyISAM latin1_swedish_ci OK
  data_template_data 1137 MyISAM latin1_swedish_ci OK
  data_template_data_rra 4552 MyISAM latin1_swedish_ci OK
  data_template_rrd 2715 MyISAM latin1_swedish_ci OK
  graph_local 1041 MyISAM latin1_swedish_ci OK
  graph_template_input 120 MyISAM latin1_swedish_ci OK
  graph_template_input_defs 371 MyISAM latin1_swedish_ci OK
  graph_templates 47 MyISAM latin1_swedish_ci OK
  graph_templates_gprint 5 MyISAM latin1_swedish_ci OK
  graph_templates_graph 1088 MyISAM latin1_swedish_ci OK
  graph_templates_item 14996 MyISAM latin1_swedish_ci OK
  graph_tree 6 MyISAM latin1_swedish_ci OK
  graph_tree_items 241 MyISAM latin1_swedish_ci OK
  host 180 MyISAM latin1_swedish_ci OK
  host_graph 205 MyISAM latin1_swedish_ci OK
  host_snmp_cache 42646 MyISAM latin1_swedish_ci OK
  host_snmp_query 181 MyISAM latin1_swedish_ci OK
  host_template 16 MyISAM latin1_swedish_ci OK
  host_template_graph 25 MyISAM latin1_swedish_ci OK
  host_template_snmp_query 22 MyISAM latin1_swedish_ci OK
  plugin_aggregate_color_template_items 44 MyISAM latin1_swedish_ci OK
  plugin_aggregate_color_templates 4 MyISAM latin1_swedish_ci OK
  plugin_cfgmng 2 MyISAM latin1_swedish_ci OK
  plugin_cfgmng_basis 1 MyISAM latin1_swedish_ci OK
  plugin_cfgmng_data 1 MyISAM latin1_swedish_ci OK
  plugin_config 3 MyISAM latin1_swedish_ci OK
  plugin_db_changes 0 MyISAM latin1_swedish_ci OK
  plugin_docs 0 MyISAM latin1_swedish_ci OK
  plugin_hooks 36 MyISAM latin1_swedish_ci OK
  plugin_realms 8 MyISAM latin1_swedish_ci OK
  plugin_rrdclean 0 MyISAM latin1_swedish_ci OK
  plugin_rrdclean_action 0 MyISAM latin1_swedish_ci OK
  plugin_thold_contacts 2 MyISAM latin1_swedish_ci OK
  plugin_thold_log 0 MyISAM latin1_swedish_ci OK
  plugin_thold_template_contact 0 MyISAM latin1_swedish_ci OK
  plugin_thold_threshold_contact 0 MyISAM latin1_swedish_ci OK
  plugin_update_info 15 MyISAM latin1_swedish_ci OK
  poller 0 MyISAM latin1_swedish_ci OK
  poller_command 0 MyISAM latin1_swedish_ci OK
  poller_item 1825 MyISAM latin1_swedish_ci OK
  poller_output 0 MyISAM latin1_swedish_ci OK
  poller_reindex 170 MyISAM latin1_swedish_ci OK
  poller_time 2 MyISAM latin1_swedish_ci OK
  rra 5 MyISAM latin1_swedish_ci OK
  rra_cf 18 MyISAM latin1_swedish_ci OK
  settings 201 MyISAM latin1_swedish_ci OK
  settings_graphs 254 MyISAM latin1_swedish_ci OK
  settings_tree 1 MyISAM latin1_swedish_ci OK
  snmp_query 9 MyISAM latin1_swedish_ci OK
  snmp_query_graph 23 MyISAM latin1_swedish_ci OK
  snmp_query_graph_rrd 47 MyISAM latin1_swedish_ci OK
  snmp_query_graph_rrd_sv 58 MyISAM latin1_swedish_ci OK
  snmp_query_graph_sv 40 MyISAM latin1_swedish_ci OK
  superlinks_auth 2 MyISAM latin1_swedish_ci OK
  superlinks_pages 2 MyISAM latin1_swedish_ci OK
  thold 0 MyISAM latin1_swedish_ci OK
  thold_data 0 MyISAM latin1_swedish_ci OK
  thold_template 0 MyISAM latin1_swedish_ci OK
  tholdset 1 MyISAM latin1_swedish_ci OK
  user_auth 27 MyISAM latin1_swedish_ci OK
  user_auth_perms 8 MyISAM latin1_swedish_ci OK
  user_auth_realm 278 MyISAM latin1_swedish_ci OK
  user_log 3691 MyISAM latin1_swedish_ci OK
  version 1 MyISAM latin1_swedish_ci OK
  weathermap_auth 16 MyISAM latin1_swedish_ci OK
  weathermap_data 0 MyISAM latin1_swedish_ci OK
  weathermap_maps 8 MyISAM latin1_swedish_ci OK

[cigamit]

Try removing the hostinfo plugin and see if the error goes away.

[kos]

hmmmm,

days ago I removed hostinfo in a first step after problem appeared - but did not help. Hostinfo bla bla... was still visible and no idea where/how/why.

Currently hostinfo plugin is not installed and its not in the .......plugins/.. folder. Problem with the trash above of the plugin management page exists, as soon as I have php 5.2.5 active and disappears with 5.2.8 or 5.2.9

Meanwhile I could get the new plugins working by:

- activating 5.2.9 and reboot server
- repair all relevant tables (hope dies last)
- disable and uninstall all 2.0 plugins
- remove it from plugin folder
- refresh plugin page
- move 2.0 plugins back
- install/enable via plugin page

I did that few times before but may be not in the order mentioned above. Get the feeling its important to install PIA in an EMPTY folder and not throw it on the existing one. In the second step get PIA page working first and AFTER that move back existing old plugins .

At the end of the day, I have plugins up and running - only remaining issue are the missing tabs of plugin page (like shown in the graph) but so far it does not limit the function of that great architecture and plugins.

cheers and thanks

Kai

[orchius]

About

DB Exec Failed!, Error:'1366', SQL:"INSERT INTO `plugin_rrdclean`

If you've used Windows you must change the configuration file of MySQL (my.ini) as follows, [mysqld]==>change to==>[wampmysqld].

example:

Code: Select all

[client]
#password	= your_password
port		= 3306
socket		= /tmp/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[wampmysqld]
port		= 3306
socket		= /tmp/mysql.sock
key_buffer_size = 16M
max_allowed_packet = 1M
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
basedir=c:/mysql
log-error=c:/mysql/logs/mysql.log
datadir=c:/mysql/data
# Avoid warning
explicit_defaults_for_timestamp = TRUE
lc-messages-dir=c:/mysql/share
# Change your locale here !
lc-messages=fr_FR

[mysqld]
port=3306
explicit_defaults_for_timestamp = TRUE

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout