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.
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 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:
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?
Thanks for your advice.