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

Announcements concerning Plugins for Cacti

Moderators: Moderators, Developers

Author
Message
der_doc
Cacti User
Posts: 51
Joined: Mon Jul 24, 2006 7:20 am
Location: Braunschweig, Germany

Re: Plugin Multi-Pollerserver (Cacticluster) ver. 0.2.2

#16 Post by der_doc » Tue Dec 04, 2012 11:48 am

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

Iam waiting for your mind.

MfG
Der_Doc
Image
ImageImage

der_doc
Cacti User
Posts: 51
Joined: Mon Jul 24, 2006 7:20 am
Location: Braunschweig, Germany

Re: Plugin Multi-Pollerserver (Cacticluster) ver. 0.2.2b

#17 Post by der_doc » Wed Jun 19, 2013 12:58 pm

Ok have fun at testing.
Image
ImageImage

npeltier
Posts: 27
Joined: Mon Aug 08, 2011 4:04 am

Re: Plugin Multi-Pollerserver (Cacticluster) ver. 0.2.2b

#18 Post by npeltier » Thu Aug 01, 2013 8:08 am

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
Posts: 11
Joined: Tue Nov 09, 2010 4:48 am
Location: Cracow

Re: Plugin Multi-Pollerserver (Cacticluster) ver. 0.2.2b

#19 Post by TaLL0s » Wed Aug 14, 2013 8:33 am

npeltier wrote: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
Cacti User
Posts: 51
Joined: Mon Jul 24, 2006 7:20 am
Location: Braunschweig, Germany

Re: Plugin Multi-Pollerserver (Cacticluster) 0.2.2b reupload

#20 Post by der_doc » Sat Aug 24, 2013 6:48 am

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.
Image
ImageImage

npeltier
Posts: 27
Joined: Mon Aug 08, 2011 4:04 am

Re: Plugin Multi-Pollerserver (Cacticluster) 0.2.2b reupload

#21 Post by npeltier » Tue Sep 10, 2013 5:19 am

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
Cacti User
Posts: 51
Joined: Mon Jul 24, 2006 7:20 am
Location: Braunschweig, Germany

Re: Plugin Multi-Pollerserver (Cacticluster) 0.2.2b reupload

#22 Post by der_doc » Thu Sep 12, 2013 3:02 am

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

cu der_doc
Image
ImageImage

TaLL0s
Posts: 11
Joined: Tue Nov 09, 2010 4:48 am
Location: Cracow

Re: Plugin Multi-Pollerserver (Cacticluster) 0.2.2b reupload

#23 Post by TaLL0s » Fri Sep 13, 2013 4:34 am

Hello,

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

Thank you.

npeltier
Posts: 27
Joined: Mon Aug 08, 2011 4:04 am

Re: Plugin Multi-Pollerserver (Cacticluster) 0.2.2b reupload

#24 Post by npeltier » Fri Sep 20, 2013 12:40 am

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
Posts: 34
Joined: Mon Jun 13, 2011 11:20 pm

Re: Plugin Multi-Pollerserver (Cacticluster) 0.2.2b reupload

#25 Post by optimuscream » Thu Oct 03, 2013 3:40 am

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
Posts: 34
Joined: Mon Jun 13, 2011 11:20 pm

Re: Plugin Multi-Pollerserver (Cacticluster) 0.2.2b reupload

#26 Post by optimuscream » Mon Oct 07, 2013 12:20 am

optimuscream wrote: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
Posts: 2
Joined: Thu Oct 10, 2013 8:09 pm

Re: Plugin Multi-Pollerserver (Cacticluster) 0.2.2b reupload

#27 Post by angelitoblu » Thu Oct 10, 2013 8:44 pm

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
Screen Shot 2013-10-10 at 8.40.46 PM.png (41.95 KiB) Viewed 4516 times
and the next step:
Screen Shot 2013-10-10 at 8.42.07 PM.png
Screen Shot 2013-10-10 at 8.42.07 PM.png (73.89 KiB) Viewed 4516 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
Posts: 34
Joined: Mon Jun 13, 2011 11:20 pm

Re: Plugin Multi-Pollerserver (Cacticluster) 0.2.2b reupload

#28 Post by optimuscream » Sun Oct 13, 2013 10:52 pm

angelitoblu wrote:
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
Posts: 27
Joined: Mon Aug 08, 2011 4:04 am

Re: Plugin Multi-Pollerserver (Cacticluster) 0.2.2b reupload

#29 Post by npeltier » Mon Oct 14, 2013 10:46 am

Angelitoblu,

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

Regards,

NP

angelitoblu
Posts: 2
Joined: Thu Oct 10, 2013 8:09 pm

Re: Plugin Multi-Pollerserver (Cacticluster) 0.2.2b reupload

#30 Post by angelitoblu » Wed Oct 16, 2013 5:58 pm

Hi,

Thanks for the comments,

I try to install over Ubuntu,

Regards

Post Reply