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
Plugin Mangement page show garbage
Moderators: Developers, Moderators
Plugin Mangement page show garbage
- Attachments
-
- Plugin Management.png (51.94 KiB) Viewed 17709 times
- TheWitness
- Developer
- Posts: 17047
- Joined: Tue May 14, 2002 5:08 pm
- Location: MI, USA
- Contact:
Very interesting. Please provide more details about your os and how you obtained php.
TheWitness
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?
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?
current setup
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
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 (67.97 KiB) Viewed 17588 times
-
- 5.2.5.png (64.92 KiB) Viewed 17588 times
hostinfo
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
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
Re: Plugin Mangement page show garbage
About
example:
If you've used Windows you must change the configuration file of MySQL (my.ini) as follows, [mysqld]==>change to==>[wampmysqld].DB Exec Failed!, Error:'1366', SQL:"INSERT INTO `plugin_rrdclean`
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
Who is online
Users browsing this forum: No registered users and 0 guests