Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Mon May 22, 2017 10:30 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 7 posts ] 
Author Message
 Post subject: Plugin Mangement page show garbage
PostPosted: Fri Feb 27, 2009 1:25 am 
Offline

Joined: Wed Nov 01, 2006 2:29 am
Posts: 24
Location: Singapore
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 5664 times ]
Top
 Profile  
 
 Post subject: solved
PostPosted: Wed Mar 04, 2009 12:47 am 
Offline

Joined: Wed Nov 01, 2006 2:29 am
Posts: 24
Location: Singapore
Could solve the problem by rolling back from php 5.2.8 to 5.2.5

cheers

Kai


Top
 Profile  
 
 Post subject:
PostPosted: Wed Mar 04, 2009 7:46 am 
Offline
Developer
User avatar

Joined: Tue May 14, 2002 5:08 pm
Posts: 14863
Location: MI, USA
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 MacTrack, Boost, CLog, SpikeKill, Platform RTM, DSStats, maintainer of Spine, lot's of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
Gandalfs Official Debugging Help
Central Plugin Repository
Central Templates Repository


Top
 Profile  
 
 Post subject: current setup
PostPosted: Wed Mar 04, 2009 11:06 am 
Offline

Joined: Wed Nov 01, 2006 2:29 am
Posts: 24
Location: Singapore
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

[list=]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[/list]


Attachments:
5.2.5.png
5.2.5.png [ 64.92 KiB | Viewed 5543 times ]
5.2.8.png
5.2.8.png [ 67.97 KiB | Viewed 5543 times ]
Top
 Profile  
 
 Post subject:
PostPosted: Wed Mar 04, 2009 3:46 pm 
Offline
Developer

Joined: Thu Apr 07, 2005 3:29 pm
Posts: 2534
Location: B/CS Texas
Try removing the hostinfo plugin and see if the error goes away.

_________________
CactiEZ CD


Top
 Profile  
 
 Post subject: hostinfo
PostPosted: Wed Mar 04, 2009 8:31 pm 
Offline

Joined: Wed Nov 01, 2006 2:29 am
Posts: 24
Location: Singapore
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


Top
 Profile  
 
 Post subject: Re: Plugin Mangement page show garbage
PostPosted: Sun Feb 01, 2015 2:38 am 
Offline

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


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 7 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 4 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group