Plugin Multi-Pollerserver (Cacticluster) 0.2.2b [closed]

[der_doc]

Hi ritosaeba,
when your cacti work hard than is this plugin that what you whant.
The plugin is the resulting because the monitored devices are many many many

Iam waiting for your mind.

MfG
Der_Doc

[der_doc]

Ok have fun at testing.

[npeltier]

Hi all!

First, I want to thank you for sharing your work with us, as I was planning to do something similar with my cacti (which is becoming to big to complete the polling in 5 minutes)

I am just starting with your plugin but I had an issue after installing the plugin, the tables "host" and "poller_server" where not modified / created right, I had to add these requests to make something appear on the configuration page (http://my_server/cacti/plugins/multipollerserver/multipollerserver.php) :
ALTER TABLE poller_server ADD hostcount INT(5) NULL DEFAULT '0' AFTER aktive;
ALTER TABLE poller_server ADD backup_poller_id INT(3) NULL DEFAULT '0';
ALTER TABLE poller_server ADD backup_mode INT(1) NULL DEFAULT '0';
ALTER TABLE host ADD backup_poller_id INT(3) NULL DEFAULT '0';

I will let you know how things go from now.

[TaLL0s]

Hi all!

First, I want to thank you for sharing your work with us, as I was planning to do something similar with my cacti (which is becoming to big to complete the polling in 5 minutes)

I am just starting with your plugin but I had an issue after installing the plugin, the tables "host" and "poller_server" where not modified / created right, I had to add these requests to make something appear on the configuration page (http://my_server/cacti/plugins/multipollerserver/multipollerserver.php) :
ALTER TABLE poller_server ADD hostcount INT(5) NULL DEFAULT '0' AFTER aktive;
ALTER TABLE poller_server ADD backup_poller_id INT(3) NULL DEFAULT '0';
ALTER TABLE poller_server ADD backup_mode INT(1) NULL DEFAULT '0';
ALTER TABLE host ADD backup_poller_id INT(3) NULL DEFAULT '0';

I will let you know how things go from now.

Hello,

I have got exactly same problem. I have create in table poller_server as above but still i have problem with backup_server_name.

In log i have:
08/14/2013 03:04:03 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT poller_server.id, poller_server.name AS server_name, poller_server.hostname, poller_server.backup_poller_id, poller_server.poller_lastrun, poller_server.hostcount, poller_server.aktive FROM poller_server where (poller_server.name like '%%%%') ORDER BY backup_server_name ASC LIMIT 40,40"

Execute this in mysql:

Code: Select all

mysql> SELECT DISTINCT  host.id,  host.description AS device_name,  host.hostname,  host.poller_id  FROM host  INNER JOIN `poller_item` ON  `poller_item`.`host_id` = `host`.`id`  where (host.description like '%%%%')  ORDER BY backup_server_name ASC LIMIT 40,40;
ERROR 1054 (42S22): Unknown column 'backup_server_name' in 'order clause'

What parameters i should use to create column backup_server_name?

Cacti 0.8.8a.

Thanks for your advice.

[der_doc]

Hi boys,

sorry for the long delay. I dont now what you mean
My english is not so support fine. But i will trai to help you.

Can everyone you run this commands in phpmyadmin with no errors?

Code: Select all

ALTER TABLE poller_server ADD hostcount INT(5) NULL DEFAULT '0' AFTER aktive;
ALTER TABLE poller_server ADD backup_poller_id INT(3) NULL DEFAULT '0';
ALTER TABLE poller_server ADD backup_mode INT(1) NULL DEFAULT '0';
ALTER TABLE host ADD backup_poller_id INT(3) NULL DEFAULT '0';

You must use the tar.gz files from cactipage for run the plugin.

Pleace let me know the results.

[npeltier]

Yes it works (i tried installing a new cacti, latest version, and latest multi-poller)
With these commands it's better (for the cacti interface at least)
I still don't know how to make the polling work on the secondary poller servers (the first one always work but not the others)

[der_doc]

After my holiday, iam in danmark the weter is perfect i will post the report ho you can poll on other pollers.

cu der_doc

[TaLL0s]

Hello,

Thank you for your response. I gave up using the plugin because of having lost already collected data.

Thank you.

[npeltier]

Hey der_doc!

Just wondering if you're planning on going back to work ... In the next few days, weeks or months ?

Enjoy whatever's left of it anyway !

[optimuscream]

Hello Der_Doc

Simple question

What should I configure in a pollerserver? I have configured only spine with spine.conf , with mysql line to masterserver cacti mysql.
Multipoller plugins config installed correctly in the masterserver (cacti 0.8.8a). Database updated, also adding pollerserver works.(Choose Device, dropdown etc).

But the pollerserver not poll anything, I've make sure snmpwalk manually works.
Only masterserver always do the polling process.
I hope I explained it clearly.

Thanks.

[optimuscream]

Hello Der_Doc

Simple question

What should I configure in a pollerserver? I have configured only spine with spine.conf , with mysql line to masterserver cacti mysql.
Multipoller plugins config installed correctly in the masterserver (cacti 0.8.8a). Database updated, also adding pollerserver works.(Choose Device, dropdown etc).

But the pollerserver not poll anything, I've make sure snmpwalk manually works.
Only masterserver always do the polling process.
I hope I explained it clearly.

Thanks.

I make it works. At first I thought NFS is not necessary but obviously needed.
Thanks.

[angelitoblu]

Hi everyone,

I try to install de multipoller 0.2.2b plugin, but in the setup process i have the follow error screen's:

Screen Shot 2013-10-10 at 8.40.46 PM.png (41.95 KiB) Viewed 9514 times

and the next step:

Screen Shot 2013-10-10 at 8.42.07 PM.png (73.89 KiB) Viewed 9514 times

My installation feature's:

Centos 6.4
PHP 5.3.3
Cacti 88a from tar.gz
Spine 87g compile from tar.gz

Thanks

[optimuscream]

My installation feature's:

Centos 6.4
PHP 5.3.3
Cacti 88a from tar.gz
Spine 87g compile from tar.gz

Thanks

I also have this error before with CentOS.
Change to Ubuntu Server LTS 12.04 solved the problem. Something messed or not compatible with the patch , don't know exactly , maybe with PHP version .
Hope this help.

[npeltier]

Angelitoblu,

You should try to stop displaying notices and enable short tags (<?) use in your PHP configuration file.

Regards,

NP

[angelitoblu]

Hi,

Thanks for the comments,

I try to install over Ubuntu,

Regards