Plugin Mangement page show garbage

Support for the Plugin Architecture

Moderators: Developers, Moderators

Post Reply
kos
Posts: 25
Joined: Wed Nov 01, 2006 2:29 am
Location: Singapore

Plugin Mangement page show garbage

Post by 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
Attachments
Plugin Management.png
Plugin Management.png (51.94 KiB) Viewed 17709 times
kos
Posts: 25
Joined: Wed Nov 01, 2006 2:29 am
Location: Singapore

solved

Post by kos »

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

cheers

Kai
User avatar
TheWitness
Developer
Posts: 17047
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Post by TheWitness »

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

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
kos
Posts: 25
Joined: Wed Nov 01, 2006 2:29 am
Location: Singapore

current setup

Post by 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
Attachments
5.2.8.png
5.2.8.png (67.97 KiB) Viewed 17588 times
5.2.5.png
5.2.5.png (64.92 KiB) Viewed 17588 times
cigamit
Developer
Posts: 3369
Joined: Thu Apr 07, 2005 3:29 pm
Location: B/CS Texas
Contact:

Post by cigamit »

Try removing the hostinfo plugin and see if the error goes away.
kos
Posts: 25
Joined: Wed Nov 01, 2006 2:29 am
Location: Singapore

hostinfo

Post by 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
Posts: 3
Joined: Sun Feb 01, 2015 1:09 am

Re: Plugin Mangement page show garbage

Post by 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
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests