Cacti 0.8.8 (a,b) + Ubuntu 12 + pulgin HMIB not working

[Tryb3]

Hi everyone,
First, excuse me for my poor english.

I currently have some problem with cacti and hmib on Ubuntu 12.04 to 12.10 :
I made installs from scratch several times (suspected plugins incompatibility, or error from me), with several tutorials

I tried cacti 0.8.8a and 0.8.8b, Spine or not ; and hmib
everything is configured right in settings (checked 100+ times), same for templates (post 0.8.7)

On a windows Server i managed to install everything and it's working great, but on Ubuntu I'm still having nothing reported on hmib tab.
- it detects my cacti as unknow and everything is empty or '0' in hmib subtabs same for other OS
- It doesn't populate the SQL right (like mentionned in post on doesnt populate hrsystem ...)
- when i use entries for os type that are working on my Windows Install of cacti, they don''t work on Ubuntu install of Cacti. I can rescan 1000 times with no effect.
- all graphs pre host mib are still working well

- I got SQL error when i add host

Code: Select all

08/23/2013 03:21:56 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1064', SQL:"SELECT COUNT(*) FROM plugin_hmib_hrSWInstalled AS hrswi INNER JOIN host ON host.id=hrswi.host_id INNER JOIN plugin_hmib_hrSystem AS hrs ON host.id=hrs.host_id WHERE hrs.host_type="
08/23/2013 03:21:56 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SELECT hrswi.*, host.hostname, host.description, host.disabled FROM plugin_hmib_hrSWInstalled AS hrswi INNER JOIN host ON host.id=hrswi.host_id INNER JOIN plugin_hmib_hrSystem AS hrs ON host.id=hrs.host_id WHERE hrs.host_type= ORDER BY name ASC LIMIT 0,30"

- data queries returns 0 row :
host-type-graph (verbose) :

Code: Select all

+ Running data query [11].
+ Found type = '6' [Script Query - Script Server].
+ Found data query XML file at '/usr/share/cacti/site/resource/script_server/hmib_host_types.xml'
+ XML file parsed ok.
+ <arg_num_indexes> missing in XML file, 'Index Count Changed' not supported
+ Executing script for list of indexes '"/usr/bin/php" -q /usr/share/cacti/site/scripts/ss_hmib_htypes.php index' Index Count: 0
+ Executing script query '"/usr/bin/php" -q /usr/share/cacti/site/scripts/ss_hmib_htypes.php query index'
+ Executing script query '"/usr/bin/php" -q /usr/share/cacti/site/scripts/ss_hmib_htypes.php query name'
+ Executing script query '"/usr/bin/php" -q /usr/share/cacti/site/scripts/ss_hmib_htypes.php query version'

summary app-stats (verbose):

Code: Select all

+ Running data query [10].
+ Found type = '6' [Script Query - Script Server].
+ Found data query XML file at '/usr/share/cacti/site/resource/script_server/hmib_sum_apps.xml'
+ XML file parsed ok.
+ <arg_num_indexes> missing in XML file, 'Index Count Changed' not supported
+ Executing script for list of indexes '"/usr/bin/php" -q /usr/share/cacti/site/scripts/ss_hmib_sum_apps.php index' Index Count: 0
+ Executing script query '"/usr/bin/php" -q /usr/share/cacti/site/scripts/ss_hmib_sum_apps.php query appName'

I dont understand why it worked so easily on windows server and can't get it working on Ubuntu
I managed to correct some bugs etc in other plugins, but all i learned from cacti last 2 months (only working on this lately) dind't helped me to correct this one.

You can contact me at office mail : b.gauchon@mediactive.fr if needed.
Cacti technical infos :

Console -_ Utilities -_ Technical Support.pdf

tech infos on my cacti (system utilities >> technical)

(183.25 KiB) Downloaded 285 times

[Tryb3]

Hi community,

I' got a question for moderators (gandalf do you read me ?) :

Why so many posts unresolved, When so many people encounters them ?

Looks like community is very active on very easy pb (like prerequisites, or rights) , but when it comes to deeper pb ...

Plz , to all people who have managed to get rid of some nasty pb , please posts your how-to

PS : really sorry for my poor english