Hi guys, not sure if I am doing anything wrong but I have a recon server and network server (auto created) but whenever I add a recontask and complete the form (using any settings, I have tried every possible variation) nothing happens. After clicking the 'Add' button I just get a grey/blank page (the menu etc still remains). No error or anything but if I go back to check the recontask nothing has been created. I have read the documentation and all seems OK. Any ideas? Thanks. Pandora FMS v5.1 - Build PC140701
Cannot create Recontask
scottiamit · 8 oct 2014, 1:33 · 6 mensajes · 62 visitas
- Inicio del debate
Hi, Could you send a screenshot? I also like to see the server logs to see if we can fix it. Regards
Sure here are the screenshots: (Link not available anymore) (Link not available anymore) (Link not available anymore) and the log file is located here: (Link not available anymore) Thanks for the reply. Scott.
Hi, Have a problem with the database. Have you changed the version 5.0 to 5.1? To solve the problem I'll leave a link to the wiki. http://wiki.pandorafms.com/index.php?title=Pandora:Pandora_Upgrade#Upgrading_the_Database Regards, Sergio
No dice mate, still the same. Here is the error list from running the script: 87 queries executed, 24 success, 63 errors, 2 warnings Query: -- --------------------------------------------------------------------- -- Table `talert_templates` -- ------------------------... Error Code: 1060 Duplicate column name 'field1_recovery' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0.001 sec -------------------------------------------------- Query: -- --------------------------------------------------------------------- -- Table `talert_actions` -- --------------------------... Error Code: 1060 Duplicate column name 'field1_recovery' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0.001 sec -------------------------------------------------- Query: ALTER TABLE `talert_actions` ADD COLUMN `field2_recovery` text NOT NULL Error Code: 1060 Duplicate column name 'field2_recovery' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: ALTER TABLE `talert_actions` ADD COLUMN `field3_recovery` text NOT NULL Error Code: 1060 Duplicate column name 'field3_recovery' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: ALTER TABLE `talert_actions` ADD COLUMN `field4_recovery` text NOT NULL Error Code: 1060 Duplicate column name 'field4_recovery' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: ALTER TABLE `talert_actions` ADD COLUMN `field5_recovery` text NOT NULL Error Code: 1060 Duplicate column name 'field5_recovery' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: ALTER TABLE `talert_actions` ADD COLUMN `field6_recovery` text NOT NULL Error Code: 1060 Duplicate column name 'field6_recovery' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: ALTER TABLE `talert_actions` ADD COLUMN `field7_recovery` text NOT NULL Error Code: 1060 Duplicate column name 'field7_recovery' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: ALTER TABLE `talert_actions` ADD COLUMN `field8_recovery` text NOT NULL Error Code: 1060 Duplicate column name 'field8_recovery' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: ALTER TABLE `talert_actions` ADD COLUMN `field9_recovery` text NOT NULL Error Code: 1060 Duplicate column name 'field9_recovery' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: ALTER TABLE `talert_actions` ADD COLUMN `field10_recovery` text NOT NULL Error Code: 1060 Duplicate column name 'field10_recovery' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: -- --------------------------------------------------------------------- -- Table `tconfig` -- ---------------------------------... 7 row(s) affected Execution Time : 0.012 sec Transfer Time : 0 sec Total Time : 0.013 sec -------------------------------------------------- Query: UPDATE tconfig SET `value`='#FFFF00' WHERE `token`='graph_color2' 1 row(s) affected Execution Time : 0.004 sec Transfer Time : 0 sec Total Time : 0.004 sec -------------------------------------------------- Query: UPDATE tconfig SET `value`='#FF6600' WHERE `token`='graph_color3' 1 row(s) affected Execution Time : 0.004 sec Transfer Time : 0.001 sec Total Time : 0.005 sec -------------------------------------------------- Query: -- --------------------------------------------------------------------- -- Table `tconfig` -- ---------------------------------... 0 row(s) affected Execution Time : 0.019 sec Transfer Time : 0 sec Total Time : 0.019 sec -------------------------------------------------- Query: -- --------------------------------------------------------------------- -- Table `tconfig_os` -- ------------------------------... 1 row(s) affected Execution Time : 0.004 sec Transfer Time : 0 sec Total Time : 0.004 sec -------------------------------------------------- Query: INSERT INTO `tconfig_os` (`name`, `description`, `icon_name`) VALUES ('Switch', 'Generic switch', 'so_switch.png') 1 row(s) affected Execution Time : 0.001 sec Transfer Time : 0 sec Total Time : 0.002 sec -------------------------------------------------- Query: INSERT INTO `tconfig_os` (`name`, `description`, `icon_name`) VALUES ('Satellite', 'Satellite agent', 'satellite.png') 1 row(s) affected Execution Time : 0.003 sec Transfer Time : 0 sec Total Time : 0.004 sec -------------------------------------------------- Query: -- --------------------------------------------------------------------- -- Table `tagente_modulo` -- --------------------------... 0 row(s) affected Execution Time : 0.045 sec Transfer Time : 0 sec Total Time : 0.046 sec -------------------------------------------------- Query: /* 2014/05/21 */ ALTER TABLE `tagente_modulo` ADD COLUMN `min_ff_event_normal` int(4) unsigned default '0' Error Code: 1060 Duplicate column name 'min_ff_event_normal' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0.001 sec -------------------------------------------------- Query: ALTER TABLE `tagente_modulo` ADD COLUMN `min_ff_event_warning` int(4) unsigned default '0' Error Code: 1060 Duplicate column name 'min_ff_event_warning' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0.001 sec -------------------------------------------------- Query: ALTER TABLE `tagente_modulo` ADD COLUMN `min_ff_event_critical` int(4) unsigned default '0' Error Code: 1060 Duplicate column name 'min_ff_event_critical' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0.001 sec -------------------------------------------------- Query: ALTER TABLE `tagente_modulo` ADD COLUMN `each_ff` tinyint(1) unsigned default '0' Error Code: 1060 Duplicate column name 'each_ff' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: /* 2014/05/31 */ ALTER TABLE `tagente_modulo` ADD COLUMN `ff_timeout` int(4) unsigned default '0' Error Code: 1060 Duplicate column name 'ff_timeout' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0.001 sec -------------------------------------------------- Query: /* 2014/03/18 */ -- --------------------------------------------------------------------- -- Table `tmodule_relationship` -- ---... 0 row(s) affected, 1 warning(s) Execution Time : 0.029 sec Transfer Time : 0 sec Total Time : 0.029 sec Note: To see complete list of warning(s), enable Tools -> Preferences -> General -> Show Warning(s) in Messages Tab -------------------------------------------------- Query: -- --------------------------------------------------------------------- -- Table `talert_snmp` -- -----------------------------... Error Code: 1060 Duplicate column name 'id_group' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0.001 sec -------------------------------------------------- Query: /* 2014/03/19 */ -- --------------------------------------------------------------------- -- Table `talert_snmp` -- ------------... Error Code: 1060 Duplicate column name '_snmp_f11_' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0.001 sec -------------------------------------------------- Query: ALTER TABLE `talert_snmp` ADD COLUMN `_snmp_f12_` text Error Code: 1060 Duplicate column name '_snmp_f12_' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0.001 sec -------------------------------------------------- Query: ALTER TABLE `talert_snmp` ADD COLUMN `_snmp_f13_` text Error Code: 1060 Duplicate column name '_snmp_f13_' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: ALTER TABLE `talert_snmp` ADD COLUMN `_snmp_f14_` text Error Code: 1060 Duplicate column name '_snmp_f14_' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: ALTER TABLE `talert_snmp` ADD COLUMN `_snmp_f15_` text Error Code: 1060 Duplicate column name '_snmp_f15_' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: ALTER TABLE `talert_snmp` ADD COLUMN `_snmp_f16_` text Error Code: 1060 Duplicate column name '_snmp_f16_' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: ALTER TABLE `talert_snmp` ADD COLUMN `_snmp_f17_` text Error Code: 1060 Duplicate column name '_snmp_f17_' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: ALTER TABLE `talert_snmp` ADD COLUMN `_snmp_f18_` text Error Code: 1060 Duplicate column name '_snmp_f18_' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0.001 sec -------------------------------------------------- Query: ALTER TABLE `talert_snmp` ADD COLUMN `_snmp_f19_` text Error Code: 1060 Duplicate column name '_snmp_f19_' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0.001 sec -------------------------------------------------- Query: ALTER TABLE `talert_snmp` ADD COLUMN `_snmp_f20_` text Error Code: 1060 Duplicate column name '_snmp_f20_' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: ALTER TABLE `tnetwork_map` ADD COLUMN `l2_network` tinyint(1) unsigned NOT NULL default '0' Error Code: 1060 Duplicate column name 'l2_network' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: -- --------------------------------------------------------------------- -- Table `tlayout_data` -- ----------------------------... Error Code: 1060 Duplicate column name 'id_group' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0.001 sec -------------------------------------------------- Query: ALTER TABLE `tlayout_data` ADD COLUMN `id_custom_graph` INTEGER UNSIGNED NOT NULL default 0 Error Code: 1060 Duplicate column name 'id_custom_graph' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0.001 sec -------------------------------------------------- Query: -- --------------------------------------------------------------------- -- Table `talert_snmp` -- -----------------------------... Error Code: 1060 Duplicate column name 'order_1' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0.001 sec -------------------------------------------------- Query: ALTER TABLE `talert_snmp` ADD COLUMN `order_2` int(10) unsigned NOT NULL default 2 Error Code: 1060 Duplicate column name 'order_2' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: ALTER TABLE `talert_snmp` ADD COLUMN `order_3` int(10) unsigned NOT NULL default 3 Error Code: 1060 Duplicate column name 'order_3' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: ALTER TABLE `talert_snmp` ADD COLUMN `order_4` int(10) unsigned NOT NULL default 4 Error Code: 1060 Duplicate column name 'order_4' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: ALTER TABLE `talert_snmp` ADD COLUMN `order_5` int(10) unsigned NOT NULL default 5 Error Code: 1060 Duplicate column name 'order_5' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: ALTER TABLE `talert_snmp` ADD COLUMN `order_6` int(10) unsigned NOT NULL default 6 Error Code: 1060 Duplicate column name 'order_6' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: ALTER TABLE `talert_snmp` ADD COLUMN `order_7` int(10) unsigned NOT NULL default 7 Error Code: 1060 Duplicate column name 'order_7' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: ALTER TABLE `talert_snmp` ADD COLUMN `order_8` int(10) unsigned NOT NULL default 8 Error Code: 1060 Duplicate column name 'order_8' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0.001 sec -------------------------------------------------- Query: ALTER TABLE `talert_snmp` ADD COLUMN `order_9` int(10) unsigned NOT NULL default 9 Error Code: 1060 Duplicate column name 'order_9' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: ALTER TABLE `talert_snmp` ADD COLUMN `order_10` int(10) unsigned NOT NULL default 10 Error Code: 1060 Duplicate column name 'order_10' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: ALTER TABLE `talert_snmp` ADD COLUMN `order_11` int(10) unsigned NOT NULL default 11 Error Code: 1060 Duplicate column name 'order_11' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: ALTER TABLE `talert_snmp` ADD COLUMN `order_12` int(10) unsigned NOT NULL default 12 Error Code: 1060 Duplicate column name 'order_12' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: ALTER TABLE `talert_snmp` ADD COLUMN `order_13` int(10) unsigned NOT NULL default 13 Error Code: 1060 Duplicate column name 'order_13' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: ALTER TABLE `talert_snmp` ADD COLUMN `order_14` int(10) unsigned NOT NULL default 14 Error Code: 1060 Duplicate column name 'order_14' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: ALTER TABLE `talert_snmp` ADD COLUMN `order_15` int(10) unsigned NOT NULL default 15 Error Code: 1060 Duplicate column name 'order_15' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: ALTER TABLE `talert_snmp` ADD COLUMN `order_16` int(10) unsigned NOT NULL default 16 Error Code: 1060 Duplicate column name 'order_16' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: ALTER TABLE `talert_snmp` ADD COLUMN `order_17` int(10) unsigned NOT NULL default 17 Error Code: 1060 Duplicate column name 'order_17' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: ALTER TABLE `talert_snmp` ADD COLUMN `order_18` int(10) unsigned NOT NULL default 18 Error Code: 1060 Duplicate column name 'order_18' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: ALTER TABLE `talert_snmp` ADD COLUMN `order_19` int(10) unsigned NOT NULL default 19 Error Code: 1060 Duplicate column name 'order_19' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: ALTER TABLE `talert_snmp` ADD COLUMN `order_20` int(10) unsigned NOT NULL default 20 Error Code: 1060 Duplicate column name 'order_20' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: -- --------------------------------------------------------------------- -- Table `talert_snmp_action` -- ----------------------... 0 row(s) affected, 1 warning(s) Execution Time : 0.001 sec Transfer Time : 0 sec Total Time : 0.001 sec Note: To see complete list of warning(s), enable Tools -> Preferences -> General -> Show Warning(s) in Messages Tab -------------------------------------------------- Query: -- --------------------------------------------------------------------- -- Table `treport` -- ---------------------------------... Error Code: 1060 Duplicate column name 'non_interactive' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0.001 sec -------------------------------------------------- Query: /* 2014/04/11 */ -- --------------------------------------------------------------------- -- Table `trecon_script` and `trecon_t... Error Code: 1060 Duplicate column name 'macros' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: ALTER TABLE `trecon_task` ADD COLUMN `macros` TEXT Error Code: 1060 Duplicate column name 'macros' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: -- --------------------------------------------------------------------- -- Table `trecon_script` -- ---------------------------... 1 row(s) affected Execution Time : 0.004 sec Transfer Time : 0 sec Total Time : 0.005 sec -------------------------------------------------- Query: INSERT INTO `trecon_script` (`name`, `description`, `script`, `macros`) VALUES ('WMI Recon Script','This script&#... 1 row(s) affected Execution Time : 0.003 sec Transfer Time : 0 sec Total Time : 0.004 sec -------------------------------------------------- Query: /* 2014/04/10 */ ALTER TABLE `treport_content` ADD COLUMN `name` varchar(150) NULL Error Code: 1060 Duplicate column name 'name' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0.001 sec -------------------------------------------------- Query: /* 2014/05/05 */ -- --------------------------------------------------------------------- -- Table `tlink` -- ------------------... 0 row(s) affected Execution Time : 0.004 sec Transfer Time : 0 sec Total Time : 0.004 sec -------------------------------------------------- Query: /* 2014/05/07 */ -- --------------------------------------------------------------------- -- Table `tconfig` -- ----------------... 5 row(s) affected Execution Time : 0.003 sec Transfer Time : 0 sec Total Time : 0.003 sec -------------------------------------------------- Query: /* 2014/05/19 */ -- --------------------------------------------------------------------- -- Table `tnetwork_profile` -- -------... 0 row(s) affected Execution Time : 0.001 sec Transfer Time : 0 sec Total Time : 0.001 sec -------------------------------------------------- Query: DELETE FROM `tnetwork_profile` WHERE `id_np`=4 0 row(s) affected Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0.001 sec -------------------------------------------------- Query: DELETE FROM `tnetwork_profile` WHERE `id_np`=5 0 row(s) affected Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0.001 sec -------------------------------------------------- Query: DELETE FROM `tnetwork_profile` WHERE `id_np`=6 0 row(s) affected Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: /* 2014/05/19 */ -- --------------------------------------------------------------------- -- Table `tnetwork_profile_component` ... 0 row(s) affected Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0.001 sec -------------------------------------------------- Query: DELETE FROM `tnetwork_profile_component` WHERE `id_np`=4 0 row(s) affected Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0.001 sec -------------------------------------------------- Query: DELETE FROM `tnetwork_profile_component` WHERE `id_np`=5 0 row(s) affected Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: DELETE FROM `tnetwork_profile_component` WHERE `id_np`=6 0 row(s) affected Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: DELETE FROM `tnetwork_profile_component` WHERE `id_nc`=24 AND `id_np`=3 0 row(s) affected Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0.001 sec -------------------------------------------------- Query: /* 2014/05/25 */ -- --------------------------------------------------------------------- -- Table `tnetwork_component` -- -----... Error Code: 1060 Duplicate column name 'min_ff_event_normal' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0.001 sec -------------------------------------------------- Query: ALTER TABLE `tnetwork_component` ADD COLUMN `min_ff_event_warning` int(4) unsigned default '0' Error Code: 1060 Duplicate column name 'min_ff_event_warning' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0.001 sec -------------------------------------------------- Query: ALTER TABLE `tnetwork_component` ADD COLUMN `min_ff_event_critical` int(4) unsigned default '0' Error Code: 1060 Duplicate column name 'min_ff_event_critical' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0.001 sec -------------------------------------------------- Query: ALTER TABLE `tnetwork_component` ADD COLUMN `each_ff` tinyint(1) unsigned default '0' Error Code: 1060 Duplicate column name 'each_ff' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: /* 2014/05/30 */ -- --------------------------------------------------------------------- -- Table `tnews` -- ------------------... Error Code: 1060 Duplicate column name 'id_group' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: ALTER TABLE `tnews` ADD COLUMN `modal` tinyint(1) DEFAULT 0 Error Code: 1060 Duplicate column name 'modal' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: ALTER TABLE `tnews` ADD COLUMN `expire` tinyint(1) DEFAULT 0 Error Code: 1060 Duplicate column name 'expire' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: ALTER TABLE `tnews` ADD COLUMN `expire_timestamp` DATETIME NOT NULL DEFAULT 0 Error Code: 1060 Duplicate column name 'expire_timestamp' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: /* 2014/05/31 */ -- --------------------------------------------------------------------- -- Table `tagente_estado` -- ---------... Error Code: 1060 Duplicate column name 'ff_start_utimestamp' Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec -------------------------------------------------- Query: /* 2014/06/24 */ -- --------------------------------------------------------------------- -- Table `trecon_script` -- ----------... 0 row(s) affected Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0.001 sec
OK, managed to resolve it. I upgraded from ubuntu 13 to 14. Restarted. Moved the 'pandora_console' folder from /var/www to /var/www/html/ and then copied back the install.php and ran the setup again. I then edited the pandora_server.conf with the new password then started parndor server again. I then created the recontask and it has saved and is running as I type this. Thanks for the help, hopefully smooth sailing from here on.
Entra en tu cuenta para publicar.
