Add device failed

Beta testing discussion area

Moderators: Moderators, Developers

Post Reply
Author
Message
Rno
Cacti User
Posts: 325
Joined: Wed Dec 07, 2011 9:19 am

Add device failed

#1 Post by Rno » Thu Nov 01, 2018 9:56 am

I can't explain that but, now I can only save one device, the second on I got a device failed
I try using automation to test it, but i get this: (read from bottom to top)

018/11/01 15:10:13 - AUTOM8 [PID: 13291] - Adding Device - Failed
2018/11/01 15:10:13 - AUTOM8 [PID: 13291] Device: 10.30.0.131, Checking DNS: Found 'se-slu-131.recolte.lausanne.ch', Status: Not in Cacti, Ping: Responded, SNMP: SE-SLU-131.recolte.lausanne.ch Responded, Template: Cisco Router
2018/11/01 15:10:12 - AUTOM8 [PID: 13287] Found 1 Threads
2018/11/01 15:10:12 - AUTOM8 [PID: 13291] Device: 10.30.0.130, Checking DNS: Not found, Status: Not in Cacti, Ping: No response
2018/11/01 15:10:10 - AUTOM8 NOTE: Graph Added - Device[62], Graph[403], DS[Missing Datasource 540]
2018/11/01 15:10:07 - AUTOM8 [PID: 13287] Found 1 Threads
2018/11/01 15:10:02 - AUTOM8 [PID: 13287] Found 1 Threads
2018/11/01 15:10:01 - AUTOM8 NOTE: Graph Added - Device[62], Graph[402], DS[Missing Datasource 539]
2018/11/01 15:09:57 - AUTOM8 [PID: 13287] Found 1 Threads
2018/11/01 15:09:53 - AUTOM8 [PID: 13291] Creating Thresholds
2018/11/01 15:09:53 - AUTOM8 [PID: 13291] - Adding Device - Success
2018/11/01 15:09:52 - AUTOM8 [PID: 13287] Found 1 Threads
2018/11/01 15:09:52 - MAP host: 10.30.0.13 location: Suisse;Lausanne;Rue du Vallon 27;0;Atelier mecanique (62)
2018/11/01 15:09:52 - AUTOM8 NOTE: [PID: 13291] create_device_node() Device[62] Tree Item - Added - Parent[11] Id[84]
2018/11/01 15:09:47 - AUTOM8 [PID: 13287] Found 1 Threads
2018/11/01 15:09:47 - AUTOM8 [PID: 13291] Device: 10.30.0.13, Checking DNS: Not found, Status: Not in Cacti, Ping: Responded, SNMP: SE-AMV-3003.recolte.lausanne.ch Responded, Template: Cisco Router
2018/11/01 15:09:45 - AUTOM8 [PID: 13291] Device: 10.30.0.129, Checking DNS: Not found, Status: Not in Cacti, Ping: No response
2018/11/01 15:09:44 - DBCALL DEVEL: SQL Save on table 'automation_snmp_items': 'a:16:{s:2:"id";i:1;s:7:"snmp_id";i:1;s:8:"sequence";s:1:"1";s:14:"snmp_community";s:7:"telvlsn";s:12:"snmp_version";s:1:"2";s:13:"snmp_username";s:5:"admin";s:13:"snmp_password";s:8:"baseball";s:18:"snmp_auth_protocol";s:3:"MD5";s:20:"snmp_priv_passphrase";s:0:"";s:18:"snmp_priv_protocol";s:3:"DES";s:12:"snmp_context";s:0:"";s:14:"snmp_engine_id";s:0:"";s:9:"snmp_port";s:3:"161";s:12:"snmp_timeout";s:4:"1000";s:12:"snmp_retries";s:1:"3";s:8:"max_oids";s:2:"10";}'
2018/11/01 15:09:43 - AUTOM8 [PID: 13291] Device: 10.30.0.128, Checking DNS: Found 'se-spe-128.recolte.lausanne.ch', Status: Not in Cacti, Ping: Responded, SNMP: No response, Alive no SNMP!

And I if I do with my plugin who call api_device_save, I just got an error with host id of 0, but can't find why it's not possible to save.
And my DB has only 2 device, cacti and 1 device.
i do the call like that:
$new_hostid = api_device_save( '0', $snmp_array['host_template_id'], $hostrecord_array['description'], $hostrecord_array['hostname'],
$snmp_array['snmp_community'], $snmp_array['snmp_version'], $snmp_array['snmp_username'], $snmp_array['snmp_password'],
$snmp_array['snmp_port'], $snmp_array['snmp_timeout'], $snmp_array['disable'], $snmp_array['availability_method'],
$snmp_array['ping_method'], $snmp_array['ping_port'], $snmp_array['ping_timeout'], $snmp_array['ping_retries'], $snmp_array['notes'],
$snmp_array['snmp_auth_protocol'], $snmp_array['snmp_priv_passphrase'], $snmp_array['snmp_priv_protocol'], $snmp_array['snmp_context'],
$snmp_array['snmp_engine_id'], $snmp_array['max_oids'], $snmp_array['device_threads'], 1, 0 );
CentOS
Production
Cacti 0.8.8h
Spine 0.8.8h
PIA 3.1
Aggregate 0.75
Monitor 1.3
Settings 0.71
Weathermap 0.98
Thold 0.5
rrdclean 0.41

Own plugin: LinkDiscovery 0.3, Map 0.4

Test
Cacti 1.2.1
Spine 1.2.1
thold 1.0.6
monitor 2.3.5
php 7.2.11
mariadb 5.5.56
Own plugin:
ExtendDB 1.1.2
LinkDiscovery 1.2.4
Map 1.2.5


Rno
Cacti User
Posts: 325
Joined: Wed Dec 07, 2011 9:19 am

Re: Add device failed

#3 Post by Rno » Fri Nov 02, 2018 1:22 am

No error, even in debug level 7

But in api_device.php there isn't much more cacti_log
So here is a new test.
The first device is saved correctly, not the second one:

2018/11/02 07:16:37 - DBCALL DEVEL: SQL Save on table 'host': 'a:33:{s:2:"id";s:1:"0";s:16:"host_template_id";s:1:"6";s:9:"poller_id";i:1;s:7:"site_id";i:0;s:11:"external_id";s:0:"";s:11:"description";s:11:"sre-dch9-60";s:8:"hostname";s:31:"sre-dch9-60.recolte.lausanne.ch";s:5:"notes";s:30:"Added by Link Discovery Plugin";s:8:"location";s:0:"";s:12:"snmp_version";s:1:"2";s:14:"snmp_community";s:7:"telvlsn";s:13:"snmp_username";s:0:"";s:13:"snmp_password";s:0:"";s:18:"snmp_auth_protocol";s:0:"";s:20:"snmp_priv_passphrase";s:0:"";s:18:"snmp_priv_protocol";s:0:"";s:12:"snmp_context";s:0:"";s:14:"snmp_engine_id";s:0:"";s:9:"snmp_port";s:3:"161";s:12:"snmp_timeout";s:3:"500";s:8:"disabled";b:0;s:19:"availability_method";s:1:"2";s:11:"ping_method";s:1:"2";s:9:"ping_port";s:2:"23";s:12:"ping_timeout";s:3:"400";s:12:"ping_retries";s:1:"1";s:8:"max_oids";i:10;s:14:"device_threads";i:1;s:7:"monitor";s:2:"on";s:12:"monitor_text";s:0:"";s:19:"monitor_criticality";s:0:"";s:12:"monitor_warn";s:0:"";s:13:"monitor_alert";s:0:"";}'
2018/11/02 07:16:37 - LINKDISCOVERY template 6
2018/11/02 07:16:36 - LINKDISCOVERY snmp interface id for: sre-dch9-60.recolte.lausanne.ch type: 6
2018/11/02 07:16:36 - LINKDISCOVERY Find peer: sre-dch9-60.recolte.lausanne.ch - sre-dch9-60 nb: 56 capa: 00:00:02:29 ip: 0A FD EE 1E good: 8 on :sre-vbb-30.recolte.lausanne.ch max: 59
2018/11/02 07:16:36 - LINKDISCOVERY End saved
2018/11/02 07:16:36 - LINKDISCOVERY api Save error: 0 host: se-pdp-40 se-pdp-40.recolte.lausanne.ch
2018/11/02 07:16:36 - LINKDISCOVERY Host se-pdp-40 saved id 0 Host template: 6
2018/11/02 07:16:36 - LINKDISCOVERY template 6
2018/11/02 07:16:36 - LINKDISCOVERY snmp interface id for: se-pdp-40.recolte.lausanne.ch type: 6
2018/11/02 07:16:36 - LINKDISCOVERY Find peer: se-pdp-40.recolte.lausanne.ch - se-pdp-40 nb: 57 capa: 00:00:02:28 ip: 0A FD EE 3E good: 8 on :sre-vbb-30.recolte.lausanne.ch max: 59
2018/11/02 07:16:36 - LINKDISCOVERY End saved
2018/11/02 07:16:20 - LINKDISCOVERY Created status graph: 380 - sre-vbb-30 Te2/2/8 - Status - SE-CH9-40 / N5K-C5548UP / -1
2018/11/02 07:16:20 - DBCALL DEVEL: SQL Save on table 'data_template_rrd': 'a:10:{s:2:"id";i:0;s:26:"local_data_template_rrd_id";s:2:"70";s:13:"local_data_id";s:3:"545";s:16:"data_template_id";s:2:"44";s:16:"data_source_name";s:10:"int_status";s:11:"rrd_minimum";s:1:"0";s:11:"rrd_maximum";s:1:"0";s:19:"data_source_type_id";s:1:"1";s:13:"rrd_heartbeat";s:3:"600";s:19:"data_input_field_id";s:1:"0";}'
2018/11/02 07:16:20 - DBCALL DEVEL: SQL Save on table 'data_template_data': 'a:10:{s:2:"id";i:0;s:27:"local_data_template_data_id";s:2:"49";s:13:"local_data_id";s:3:"545";s:16:"data_template_id";s:2:"44";s:4:"name";s:37:"|host_description| - Interface status";s:16:"data_source_path";s:0:"";s:13:"data_input_id";s:1:"2";s:22:"data_source_profile_id";s:1:"1";s:8:"rrd_step";s:3:"300";s:6:"active";s:2:"on";}'
2018/11/02 07:16:20 - DBCALL DEVEL: SQL Save on table 'data_local': 'a:5:{s:2:"id";i:0;s:16:"data_template_id";s:2:"44";s:7:"host_id";s:2:"51";s:13:"snmp_query_id";s:1:"1";s:10:"snmp_index";s:3:"380";}'
2018/11/02 07:16:19 - DBCALL DEVEL: SQL Save on table 'graph_templates_item': 'a:21:{s:28:"local_graph_template_item_id";s:3:"405";s:14:"local_graph_id";s:3:"406";s:17:"graph_template_id";s:2:"38";s:8:"sequence";s:1:"3";s:2:"id";i:0;s:12:"task_item_id";i:0;s:8:"color_id";i:0;s:5:"alpha";s:2:"FF";s:13:"graph_type_id";s:1:"1";s:10:"line_width";s:4:"0.00";s:6:"dashes";N;s:11:"dash_offset";i:0;s:7:"cdef_id";i:0;s:7:"vdef_id";i:0;s:5:"shift";N;s:25:"consolidation_function_id";s:1:"4";s:9:"textalign";N;s:11:"text_format";s:19:"(1 = Up | 0 = Down)";s:5:"value";s:0:"";s:11:"hard_return";s:2:"on";s:9:"gprint_id";s:1:"2";}'
2018/11/02 07:16:19 - DBCALL DEVEL: SQL Save on table 'graph_templates_item': 'a:21:{s:28:"local_graph_template_item_id";s:3:"404";s:14:"local_graph_id";s:3:"406";s:17:"graph_template_id";s:2:"38";s:8:"sequence";s:1:"2";s:2:"id";i:0;s:12:"task_item_id";i:0;s:8:"color_id";i:0;s:5:"alpha";s:2:"FF";s:13:"graph_type_id";s:1:"9";s:10:"line_width";s:4:"0.00";s:6:"dashes";N;s:11:"dash_offset";i:0;s:7:"cdef_id";s:2:"18";s:7:"vdef_id";i:0;s:5:"shift";N;s:25:"consolidation_function_id";s:1:"4";s:9:"textalign";N;s:11:"text_format";s:0:"";s:5:"value";s:0:"";s:11:"hard_return";s:2:"on";s:9:"gprint_id";s:1:"3";}'
2018/11/02 07:16:19 - DBCALL DEVEL: SQL Save on table 'graph_templates_item': 'a:21:{s:28:"local_graph_template_item_id";s:3:"403";s:14:"local_graph_id";s:3:"406";s:17:"graph_template_id";s:2:"38";s:8:"sequence";s:1:"1";s:2:"id";i:0;s:12:"task_item_id";i:0;s:8:"color_id";s:2:"12";s:5:"alpha";s:2:"FF";s:13:"graph_type_id";s:1:"7";s:10:"line_width";s:4:"0.00";s:6:"dashes";N;s:11:"dash_offset";i:0;s:7:"cdef_id";s:2:"18";s:7:"vdef_id";i:0;s:5:"shift";N;s:25:"consolidation_function_id";s:1:"1";s:9:"textalign";N;s:11:"text_format";s:15:"Current status:";s:5:"value";s:0:"";s:11:"hard_return";s:0:"";s:9:"gprint_id";s:1:"2";}'
2018/11/02 07:16:19 - DBCALL DEVEL: SQL Save on table 'graph_templates_graph': 'a:34:{s:2:"id";i:0;s:29:"local_graph_template_graph_id";s:2:"42";s:14:"local_graph_id";s:3:"406";s:17:"graph_template_id";s:2:"38";s:5:"title";s:37:"|host_description| - Interface Status";s:14:"vertical_label";s:6:"status";s:15:"image_format_id";s:1:"1";s:6:"height";s:2:"50";s:5:"width";s:3:"500";s:10:"base_value";s:4:"1000";s:10:"slope_mode";s:2:"on";s:10:"auto_scale";s:2:"on";s:15:"auto_scale_opts";s:1:"2";s:14:"auto_scale_log";s:0:"";s:15:"scale_log_units";s:0:"";s:16:"auto_scale_rigid";s:2:"on";s:11:"upper_limit";s:3:"100";s:11:"lower_limit";s:1:"0";s:10:"unit_value";s:0:"";s:19:"unit_exponent_value";s:0:"";s:11:"unit_length";N;s:10:"no_gridfit";N;s:10:"alt_y_grid";N;s:10:"right_axis";N;s:16:"right_axis_label";N;s:17:"right_axis_format";N;s:20:"right_axis_formatter";N;s:19:"left_axis_formatter";N;s:12:"auto_padding";s:2:"on";s:14:"dynamic_labels";N;s:18:"force_rules_legend";N;s:9:"tab_width";s:2:"30";s:15:"legend_position";N;s:16:"legend_direction";N;}'
2018/11/02 07:16:19 - DBCALL DEVEL: SQL Save on table 'graph_local': 'a:6:{s:2:"id";i:0;s:17:"graph_template_id";s:2:"38";s:7:"host_id";s:2:"51";s:13:"snmp_query_id";s:1:"1";s:19:"snmp_query_graph_id";s:2:"23";s:10:"snmp_index";s:3:"380";}'
2018/11/02 07:16:19 - LINKDISCOVERY Created traffic graph: 380 - sre-vbb-30 Te2/2/8 - Traffic - SE-CH9-40 / N5K-C5548UP / -1
2018/11/02 07:16:17 - DBCALL DEVEL: SQL Save on table 'data_template_rrd': 'a:10:{s:2:"id";i:0;s:26:"local_data_template_rrd_id";s:1:"3";s:13:"local_data_id";s:3:"544";s:16:"data_template_id";s:1:"2";s:16:"data_source_name";s:11:"traffic_out";s:11:"rrd_minimum";s:1:"0";s:11:"rrd_maximum";s:12:"100000000000";s:19:"data_source_type_id";s:1:"2";s:13:"rrd_heartbeat";s:3:"600";s:19:"data_input_field_id";s:1:"0";}'
2018/11/02 07:16:16 - DBCALL DEVEL: SQL Save on table 'data_template_rrd': 'a:10:{s:2:"id";i:0;s:26:"local_data_template_rrd_id";s:1:"2";s:13:"local_data_id";s:3:"544";s:16:"data_template_id";s:1:"2";s:16:"data_source_name";s:10:"traffic_in";s:11:"rrd_minimum";s:1:"0";s:11:"rrd_maximum";s:12:"100000000000";s:19:"data_source_type_id";s:1:"2";s:13:"rrd_heartbeat";s:3:"600";s:19:"data_input_field_id";s:1:"0";}'
2018/11/02 07:16:16 - DBCALL DEVEL: SQL Save on table 'data_template_data': 'a:10:{s:2:"id";i:0;s:27:"local_data_template_data_id";s:1:"2";s:13:"local_data_id";s:3:"544";s:16:"data_template_id";s:1:"2";s:4:"name";s:28:"|host_description| - Traffic";s:16:"data_source_path";s:0:"";s:13:"data_input_id";s:1:"2";s:22:"data_source_profile_id";s:1:"1";s:8:"rrd_step";s:3:"300";s:6:"active";s:2:"on";}'
2018/11/02 07:16:15 - DBCALL DEVEL: SQL Save on table 'data_local': 'a:5:{s:2:"id";i:0;s:16:"data_template_id";s:1:"2";s:7:"host_id";s:2:"51";s:13:"snmp_query_id";s:1:"1";s:10:"snmp_index";s:3:"380";}'
2018/11/02 07:16:15 - DBCALL DEVEL: SQL Save on table 'graph_templates_item': 'a:21:{s:28:"local_graph_template_item_id";s:4:"2097";s:14:"local_graph_id";s:3:"405";s:17:"graph_template_id";s:2:"41";s:8:"sequence";s:2:"10";s:2:"id";i:0;s:12:"task_item_id";i:0;s:8:"color_id";i:0;s:5:"alpha";s:2:"FF";s:13:"graph_type_id";s:1:"9";s:10:"line_width";s:4:"0.00";s:6:"dashes";s:0:"";s:11:"dash_offset";i:0;s:7:"cdef_id";s:1:"2";s:7:"vdef_id";i:0;s:5:"shift";s:0:"";s:25:"consolidation_function_id";s:1:"3";s:9:"textalign";s:0:"";s:11:"text_format";s:8:"Maximum:";s:5:"value";s:0:"";s:11:"hard_return";s:2:"on";s:9:"gprint_id";s:1:"2";}'
2018/11/02 07:16:14 - DBCALL DEVEL: SQL Save on table 'graph_templates_item': 'a:21:{s:28:"local_graph_template_item_id";s:4:"2096";s:14:"local_graph_id";s:3:"405";s:17:"graph_template_id";s:2:"41";s:8:"sequence";s:1:"9";s:2:"id";i:0;s:12:"task_item_id";i:0;s:8:"color_id";i:0;s:5:"alpha";s:2:"FF";s:13:"graph_type_id";s:1:"9";s:10:"line_width";s:4:"0.00";s:6:"dashes";s:0:"";s:11:"dash_offset";i:0;s:7:"cdef_id";s:1:"2";s:7:"vdef_id";i:0;s:5:"shift";s:0:"";s:25:"consolidation_function_id";s:1:"1";s:9:"textalign";s:0:"";s:11:"text_format";s:8:"Average:";s:5:"value";s:0:"";s:11:"hard_return";s:0:"";s:9:"gprint_id";s:1:"2";}'
2018/11/02 07:16:14 - DBCALL DEVEL: SQL Save on table 'graph_templates_item': 'a:21:{s:28:"local_graph_template_item_id";s:4:"2095";s:14:"local_graph_id";s:3:"405";s:17:"graph_template_id";s:2:"41";s:8:"sequence";s:1:"8";s:2:"id";i:0;s:12:"task_item_id";i:0;s:8:"color_id";i:0;s:5:"alpha";s:2:"FF";s:13:"graph_type_id";s:1:"9";s:10:"line_width";s:4:"0.00";s:6:"dashes";s:0:"";s:11:"dash_offset";i:0;s:7:"cdef_id";s:1:"2";s:7:"vdef_id";i:0;s:5:"shift";s:0:"";s:25:"consolidation_function_id";s:1:"4";s:9:"textalign";s:0:"";s:11:"text_format";s:8:"Current:";s:5:"value";s:0:"";s:11:"hard_return";s:0:"";s:9:"gprint_id";s:1:"2";}'
2018/11/02 07:16:14 - DBCALL DEVEL: SQL Save on table 'graph_templates_item': 'a:21:{s:28:"local_graph_template_item_id";s:4:"2094";s:14:"local_graph_id";s:3:"405";s:17:"graph_template_id";s:2:"41";s:8:"sequence";s:1:"7";s:2:"id";i:0;s:12:"task_item_id";i:0;s:8:"color_id";s:2:"20";s:5:"alpha";s:2:"7F";s:13:"graph_type_id";s:1:"7";s:10:"line_width";s:4:"0.00";s:6:"dashes";s:0:"";s:11:"dash_offset";i:0;s:7:"cdef_id";s:2:"19";s:7:"vdef_id";i:0;s:5:"shift";s:0:"";s:25:"consolidation_function_id";s:1:"1";s:9:"textalign";s:0:"";s:11:"text_format";s:8:"Outbound";s:5:"value";s:0:"";s:11:"hard_return";s:0:"";s:9:"gprint_id";s:1:"2";}'
2018/11/02 07:16:14 - DBCALL DEVEL: SQL Save on table 'graph_templates_item': 'a:21:{s:28:"local_graph_template_item_id";s:4:"2093";s:14:"local_graph_id";s:3:"405";s:17:"graph_template_id";s:2:"41";s:8:"sequence";s:1:"6";s:2:"id";i:0;s:12:"task_item_id";i:0;s:8:"color_id";s:2:"20";s:5:"alpha";s:2:"FF";s:13:"graph_type_id";s:1:"4";s:10:"line_width";s:4:"0.00";s:6:"dashes";s:0:"";s:11:"dash_offset";i:0;s:7:"cdef_id";s:2:"19";s:7:"vdef_id";i:0;s:5:"shift";s:0:"";s:25:"consolidation_function_id";s:1:"3";s:9:"textalign";s:0:"";s:11:"text_format";s:0:"";s:5:"value";s:0:"";s:11:"hard_return";s:0:"";s:9:"gprint_id";s:1:"2";}'
2018/11/02 07:16:13 - DBCALL DEVEL: SQL Save on table 'graph_templates_item': 'a:21:{s:28:"local_graph_template_item_id";s:4:"2092";s:14:"local_graph_id";s:3:"405";s:17:"graph_template_id";s:2:"41";s:8:"sequence";s:1:"5";s:2:"id";i:0;s:12:"task_item_id";i:0;s:8:"color_id";i:0;s:5:"alpha";s:2:"FF";s:13:"graph_type_id";s:1:"9";s:10:"line_width";s:4:"0.00";s:6:"dashes";s:0:"";s:11:"dash_offset";i:0;s:7:"cdef_id";s:1:"2";s:7:"vdef_id";i:0;s:5:"shift";s:0:"";s:25:"consolidation_function_id";s:1:"3";s:9:"textalign";s:0:"";s:11:"text_format";s:8:"Maximum:";s:5:"value";s:0:"";s:11:"hard_return";s:2:"on";s:9:"gprint_id";s:1:"2";}'
2018/11/02 07:16:13 - DBCALL DEVEL: SQL Save on table 'graph_templates_item': 'a:21:{s:28:"local_graph_template_item_id";s:4:"2091";s:14:"local_graph_id";s:3:"405";s:17:"graph_template_id";s:2:"41";s:8:"sequence";s:1:"4";s:2:"id";i:0;s:12:"task_item_id";i:0;s:8:"color_id";i:0;s:5:"alpha";s:2:"FF";s:13:"graph_type_id";s:1:"9";s:10:"line_width";s:4:"0.00";s:6:"dashes";s:0:"";s:11:"dash_offset";i:0;s:7:"cdef_id";s:1:"2";s:7:"vdef_id";i:0;s:5:"shift";s:0:"";s:25:"consolidation_function_id";s:1:"1";s:9:"textalign";s:0:"";s:11:"text_format";s:8:"Average:";s:5:"value";s:0:"";s:11:"hard_return";s:0:"";s:9:"gprint_id";s:1:"2";}'
2018/11/02 07:16:12 - DBCALL DEVEL: SQL Save on table 'graph_templates_item': 'a:21:{s:28:"local_graph_template_item_id";s:4:"2090";s:14:"local_graph_id";s:3:"405";s:17:"graph_template_id";s:2:"41";s:8:"sequence";s:1:"3";s:2:"id";i:0;s:12:"task_item_id";i:0;s:8:"color_id";i:0;s:5:"alpha";s:2:"FF";s:13:"graph_type_id";s:1:"9";s:10:"line_width";s:4:"0.00";s:6:"dashes";s:0:"";s:11:"dash_offset";i:0;s:7:"cdef_id";s:1:"2";s:7:"vdef_id";i:0;s:5:"shift";s:0:"";s:25:"consolidation_function_id";s:1:"4";s:9:"textalign";s:0:"";s:11:"text_format";s:8:"Current:";s:5:"value";s:0:"";s:11:"hard_return";s:0:"";s:9:"gprint_id";s:1:"2";}'
2018/11/02 07:16:12 - DBCALL DEVEL: SQL Save on table 'graph_templates_item': 'a:21:{s:28:"local_graph_template_item_id";s:4:"2089";s:14:"local_graph_id";s:3:"405";s:17:"graph_template_id";s:2:"41";s:8:"sequence";s:1:"2";s:2:"id";i:0;s:12:"task_item_id";i:0;s:8:"color_id";s:2:"22";s:5:"alpha";s:2:"7F";s:13:"graph_type_id";s:1:"7";s:10:"line_width";s:4:"0.00";s:6:"dashes";s:0:"";s:11:"dash_offset";i:0;s:7:"cdef_id";s:1:"2";s:7:"vdef_id";i:0;s:5:"shift";s:0:"";s:25:"consolidation_function_id";s:1:"1";s:9:"textalign";s:0:"";s:11:"text_format";s:7:"Inbound";s:5:"value";s:0:"";s:11:"hard_return";s:0:"";s:9:"gprint_id";s:1:"2";}'
2018/11/02 07:16:12 - DBCALL DEVEL: SQL Save on table 'graph_templates_item': 'a:21:{s:28:"local_graph_template_item_id";s:4:"2088";s:14:"local_graph_id";s:3:"405";s:17:"graph_template_id";s:2:"41";s:8:"sequence";s:1:"1";s:2:"id";i:0;s:12:"task_item_id";i:0;s:8:"color_id";s:2:"22";s:5:"alpha";s:2:"FF";s:13:"graph_type_id";s:1:"4";s:10:"line_width";s:4:"0.00";s:6:"dashes";s:0:"";s:11:"dash_offset";i:0;s:7:"cdef_id";s:1:"2";s:7:"vdef_id";i:0;s:5:"shift";s:0:"";s:25:"consolidation_function_id";s:1:"3";s:9:"textalign";s:0:"";s:11:"text_format";s:0:"";s:5:"value";s:0:"";s:11:"hard_return";s:0:"";s:9:"gprint_id";s:1:"2";}'
2018/11/02 07:16:11 - DBCALL DEVEL: SQL Save on table 'graph_templates_graph': 'a:34:{s:2:"id";i:0;s:29:"local_graph_template_graph_id";s:3:"255";s:14:"local_graph_id";s:3:"405";s:17:"graph_template_id";s:2:"41";s:5:"title";s:28:"|host_description| - Traffic";s:14:"vertical_label";s:15:"bits per second";s:15:"image_format_id";s:1:"1";s:6:"height";s:3:"200";s:5:"width";s:3:"700";s:10:"base_value";s:4:"1000";s:10:"slope_mode";s:2:"on";s:10:"auto_scale";s:2:"on";s:15:"auto_scale_opts";s:1:"1";s:14:"auto_scale_log";s:0:"";s:15:"scale_log_units";s:0:"";s:16:"auto_scale_rigid";s:2:"on";s:11:"upper_limit";s:3:"100";s:11:"lower_limit";s:1:"0";s:10:"unit_value";s:0:"";s:19:"unit_exponent_value";s:0:"";s:11:"unit_length";s:0:"";s:10:"no_gridfit";s:0:"";s:10:"alt_y_grid";s:0:"";s:10:"right_axis";s:0:"";s:16:"right_axis_label";s:0:"";s:17:"right_axis_format";s:1:"0";s:20:"right_axis_formatter";s:1:"0";s:19:"left_axis_formatter";s:1:"0";s:12:"auto_padding";s:2:"on";s:14:"dynamic_labels";s:0:"";s:18:"force_rules_legend";s:0:"";s:9:"tab_width";s:0:"";s:15:"legend_position";s:1:"0";s:16:"legend_direction";s:1:"0";}'
2018/11/02 07:16:11 - DBCALL DEVEL: SQL Save on table 'graph_local': 'a:6:{s:2:"id";i:0;s:17:"graph_template_id";s:2:"41";s:7:"host_id";s:2:"51";s:13:"snmp_query_id";s:1:"1";s:19:"snmp_query_graph_id";s:2:"27";s:10:"snmp_index";s:3:"380";}'
2018/11/02 07:16:11 - LINKDISCOVERY Saved Host, descr: se-ch9-40 hostname: se-ch9-40.recolte.lausanne.ch res: 1
2018/11/02 07:16:10 - AUTOM8 NOTE: Graph Added - Device[se-ch9-40], Graph[se-ch9-40 - CPU Usage], DS[se-ch9-40 1 Minute CPU, se-ch9-40 5 Minute CPU, se-ch9-40 5 Second CPU] Graphs[se-ch9-40 - CPU Usage]
2018/11/02 07:15:51 - DBCALL DEVEL: SQL Save on table 'data_template_rrd': 'a:10:{s:2:"id";i:0;s:26:"local_data_template_rrd_id";s:2:"65";s:13:"local_data_id";s:3:"543";s:16:"data_template_id";s:2:"39";s:16:"data_source_name";s:11:"5sec_nexcpu";s:11:"rrd_minimum";s:1:"0";s:11:"rrd_maximum";s:3:"100";s:19:"data_source_type_id";s:1:"1";s:13:"rrd_heartbeat";s:3:"600";s:19:"data_input_field_id";s:1:"0";}'
2018/11/02 07:15:51 - DBCALL DEVEL: SQL Save on table 'data_template_data': 'a:10:{s:2:"id";i:0;s:27:"local_data_template_data_id";s:2:"44";s:13:"local_data_id";s:3:"543";s:16:"data_template_id";s:2:"39";s:4:"name";s:32:"|host_description| 5 Second CPU";s:16:"data_source_path";s:0:"";s:13:"data_input_id";s:1:"1";s:22:"data_source_profile_id";s:1:"1";s:8:"rrd_step";s:3:"300";s:6:"active";s:2:"on";}'
2018/11/02 07:15:51 - DBCALL DEVEL: SQL Save on table 'data_local': 'a:3:{s:2:"id";i:0;s:16:"data_template_id";s:2:"39";s:7:"host_id";s:2:"63";}'
2018/11/02 07:15:49 - DBCALL DEVEL: SQL Save on table 'data_template_rrd': 'a:10:{s:2:"id";i:0;s:26:"local_data_template_rrd_id";s:2:"67";s:13:"local_data_id";s:3:"542";s:16:"data_template_id";s:2:"41";s:16:"data_source_name";s:11:"5min_nexcpu";s:11:"rrd_minimum";s:1:"0";s:11:"rrd_maximum";s:3:"100";s:19:"data_source_type_id";s:1:"1";s:13:"rrd_heartbeat";s:3:"600";s:19:"data_input_field_id";s:1:"0";}'
2018/11/02 07:15:49 - DBCALL DEVEL: SQL Save on table 'data_template_data': 'a:10:{s:2:"id";i:0;s:27:"local_data_template_data_id";s:2:"46";s:13:"local_data_id";s:3:"542";s:16:"data_template_id";s:2:"41";s:4:"name";s:32:"|host_description| 5 Minute CPU";s:16:"data_source_path";s:0:"";s:13:"data_input_id";s:1:"1";s:22:"data_source_profile_id";s:1:"1";s:8:"rrd_step";s:3:"300";s:6:"active";s:2:"on";}'
2018/11/02 07:15:48 - DBCALL DEVEL: SQL Save on table 'data_local': 'a:3:{s:2:"id";i:0;s:16:"data_template_id";s:2:"41";s:7:"host_id";s:2:"63";}'
2018/11/02 07:15:45 - DBCALL DEVEL: SQL Save on table 'data_template_rrd': 'a:10:{s:2:"id";i:0;s:26:"local_data_template_rrd_id";s:2:"66";s:13:"local_data_id";s:3:"541";s:16:"data_template_id";s:2:"40";s:16:"data_source_name";s:11:"1min_nexcpu";s:11:"rrd_minimum";s:1:"0";s:11:"rrd_maximum";s:3:"100";s:19:"data_source_type_id";s:1:"1";s:13:"rrd_heartbeat";s:3:"600";s:19:"data_input_field_id";s:1:"0";}'
2018/11/02 07:15:45 - DBCALL DEVEL: SQL Save on table 'data_template_data': 'a:10:{s:2:"id";i:0;s:27:"local_data_template_data_id";s:2:"45";s:13:"local_data_id";s:3:"541";s:16:"data_template_id";s:2:"40";s:4:"name";s:32:"|host_description| 1 Minute CPU";s:16:"data_source_path";s:0:"";s:13:"data_input_id";s:1:"1";s:22:"data_source_profile_id";s:1:"1";s:8:"rrd_step";s:3:"300";s:6:"active";s:2:"on";}'
2018/11/02 07:15:44 - DBCALL DEVEL: SQL Save on table 'data_local': 'a:3:{s:2:"id";i:0;s:16:"data_template_id";s:2:"40";s:7:"host_id";s:2:"63";}'
2018/11/02 07:15:44 - DBCALL DEVEL: SQL Save on table 'graph_templates_item': 'a:21:{s:28:"local_graph_template_item_id";s:3:"393";s:14:"local_graph_id";s:3:"404";s:17:"graph_template_id";s:2:"36";s:8:"sequence";s:2:"18";s:2:"id";i:0;s:12:"task_item_id";i:0;s:8:"color_id";i:0;s:5:"alpha";s:2:"FF";s:13:"graph_type_id";s:1:"1";s:10:"line_width";s:4:"0.00";s:6:"dashes";N;s:11:"dash_offset";i:0;s:7:"cdef_id";i:0;s:7:"vdef_id";i:0;s:5:"shift";N;s:25:"consolidation_function_id";s:1:"1";s:9:"textalign";N;s:11:"text_format";s:23:"Last Poll: |date_time|";s:5:"value";s:0:"";s:11:"hard_return";s:2:"on";s:9:"gprint_id";s:1:"2";}'
2018/11/02 07:15:43 - DBCALL DEVEL: SQL Save on table 'graph_templates_item': 'a:21:{s:28:"local_graph_template_item_id";s:3:"392";s:14:"local_graph_id";s:3:"404";s:17:"graph_template_id";s:2:"36";s:8:"sequence";s:2:"17";s:2:"id";i:0;s:12:"task_item_id";i:0;s:8:"color_id";i:0;s:5:"alpha";s:2:"FF";s:13:"graph_type_id";s:1:"9";s:10:"line_width";s:4:"0.00";s:6:"dashes";N;s:11:"dash_offset";i:0;s:7:"cdef_id";i:0;s:7:"vdef_id";i:0;s:5:"shift";N;s:25:"consolidation_function_id";s:1:"3";s:9:"textalign";N;s:11:"text_format";s:8:"Maximum:";s:5:"value";s:0:"";s:11:"hard_return";s:2:"on";s:9:"gprint_id";s:1:"3";}'
2018/11/02 07:15:43 - DBCALL DEVEL: SQL Save on table 'graph_templates_item': 'a:21:{s:28:"local_graph_template_item_id";s:3:"391";s:14:"local_graph_id";s:3:"404";s:17:"graph_template_id";s:2:"36";s:8:"sequence";s:2:"16";s:2:"id";i:0;s:12:"task_item_id";i:0;s:8:"color_id";i:0;s:5:"alpha";s:2:"FF";s:13:"graph_type_id";s:1:"9";s:10:"line_width";s:4:"0.00";s:6:"dashes";N;s:11:"dash_offset";i:0;s:7:"cdef_id";i:0;s:7:"vdef_id";i:0;s:5:"shift";N;s:25:"consolidation_function_id";s:1:"1";s:9:"textalign";N;s:11:"text_format";s:8:"Average:";s:5:"value";s:0:"";s:11:"hard_return";s:0:"";s:9:"gprint_id";s:1:"3";}'
2018/11/02 07:15:42 - DBCALL DEVEL: SQL Save on table 'graph_templates_item': 'a:21:{s:28:"local_graph_template_item_id";s:3:"390";s:14:"local_graph_id";s:3:"404";s:17:"graph_template_id";s:2:"36";s:8:"sequence";s:2:"15";s:2:"id";i:0;s:12:"task_item_id";i:0;s:8:"color_id";i:0;s:5:"alpha";s:2:"FF";s:13:"graph_type_id";s:1:"9";s:10:"line_width";s:4:"0.00";s:6:"dashes";N;s:11:"dash_offset";i:0;s:7:"cdef_id";i:0;s:7:"vdef_id";i:0;s:5:"shift";N;s:25:"consolidation_function_id";s:1:"4";s:9:"textalign";N;s:11:"text_format";s:8:"Current:";s:5:"value";s:0:"";s:11:"hard_return";s:0:"";s:9:"gprint_id";s:1:"3";}'
2018/11/02 07:15:42 - DBCALL DEVEL: SQL Save on table 'graph_templates_item': 'a:21:{s:28:"local_graph_template_item_id";s:3:"389";s:14:"local_graph_id";s:3:"404";s:17:"graph_template_id";s:2:"36";s:8:"sequence";s:2:"14";s:2:"id";i:0;s:12:"task_item_id";i:0;s:8:"color_id";s:1:"9";s:5:"alpha";s:2:"CC";s:13:"graph_type_id";s:1:"4";s:10:"line_width";s:4:"0.00";s:6:"dashes";N;s:11:"dash_offset";i:0;s:7:"cdef_id";i:0;s:7:"vdef_id";i:0;s:5:"shift";N;s:25:"consolidation_function_id";s:1:"1";s:9:"textalign";N;s:11:"text_format";s:9:"5 Minutes";s:5:"value";s:0:"";s:11:"hard_return";s:0:"";s:9:"gprint_id";s:1:"2";}'
2018/11/02 07:15:42 - DBCALL DEVEL: SQL Save on table 'graph_templates_item': 'a:21:{s:28:"local_graph_template_item_id";s:3:"388";s:14:"local_graph_id";s:3:"404";s:17:"graph_template_id";s:2:"36";s:8:"sequence";s:2:"12";s:2:"id";i:0;s:12:"task_item_id";i:0;s:8:"color_id";i:0;s:5:"alpha";s:2:"FF";s:13:"graph_type_id";s:1:"9";s:10:"line_width";s:4:"0.00";s:6:"dashes";N;s:11:"dash_offset";i:0;s:7:"cdef_id";i:0;s:7:"vdef_id";i:0;s:5:"shift";N;s:25:"consolidation_function_id";s:1:"3";s:9:"textalign";N;s:11:"text_format";s:8:"Maximum:";s:5:"value";s:0:"";s:11:"hard_return";s:2:"on";s:9:"gprint_id";s:1:"3";}'
2018/11/02 07:15:41 - DBCALL DEVEL: SQL Save on table 'graph_templates_item': 'a:21:{s:28:"local_graph_template_item_id";s:3:"387";s:14:"local_graph_id";s:3:"404";s:17:"graph_template_id";s:2:"36";s:8:"sequence";s:2:"11";s:2:"id";i:0;s:12:"task_item_id";i:0;s:8:"color_id";i:0;s:5:"alpha";s:2:"FF";s:13:"graph_type_id";s:1:"9";s:10:"line_width";s:4:"0.00";s:6:"dashes";N;s:11:"dash_offset";i:0;s:7:"cdef_id";i:0;s:7:"vdef_id";i:0;s:5:"shift";N;s:25:"consolidation_function_id";s:1:"1";s:9:"textalign";N;s:11:"text_format";s:8:"Average:";s:5:"value";s:0:"";s:11:"hard_return";s:0:"";s:9:"gprint_id";s:1:"3";}'
2018/11/02 07:15:41 - DBCALL DEVEL: SQL Save on table 'graph_templates_item': 'a:21:{s:28:"local_graph_template_item_id";s:3:"386";s:14:"local_graph_id";s:3:"404";s:17:"graph_template_id";s:2:"36";s:8:"sequence";s:2:"10";s:2:"id";i:0;s:12:"task_item_id";i:0;s:8:"color_id";i:0;s:5:"alpha";s:2:"FF";s:13:"graph_type_id";s:1:"9";s:10:"line_width";s:4:"0.00";s:6:"dashes";N;s:11:"dash_offset";i:0;s:7:"cdef_id";i:0;s:7:"vdef_id";i:0;s:5:"shift";N;s:25:"consolidation_function_id";s:1:"4";s:9:"textalign";N;s:11:"text_format";s:8:"Current:";s:5:"value";s:0:"";s:11:"hard_return";s:0:"";s:9:"gprint_id";s:1:"3";}'
2018/11/02 07:15:41 - DBCALL DEVEL: SQL Save on table 'graph_templates_item': 'a:21:{s:28:"local_graph_template_item_id";s:3:"385";s:14:"local_graph_id";s:3:"404";s:17:"graph_template_id";s:2:"36";s:8:"sequence";s:1:"9";s:2:"id";i:0;s:12:"task_item_id";i:0;s:8:"color_id";s:3:"441";s:5:"alpha";s:2:"CC";s:13:"graph_type_id";s:1:"4";s:10:"line_width";s:4:"0.00";s:6:"dashes";N;s:11:"dash_offset";i:0;s:7:"cdef_id";i:0;s:7:"vdef_id";i:0;s:5:"shift";N;s:25:"consolidation_function_id";s:1:"1";s:9:"textalign";N;s:11:"text_format";s:9:"1 Minutes";s:5:"value";s:0:"";s:11:"hard_return";s:0:"";s:9:"gprint_id";s:1:"2";}'
2018/11/02 07:15:40 - DBCALL DEVEL: SQL Save on table 'graph_templates_item': 'a:21:{s:28:"local_graph_template_item_id";s:3:"384";s:14:"local_graph_id";s:3:"404";s:17:"graph_template_id";s:2:"36";s:8:"sequence";s:1:"4";s:2:"id";i:0;s:12:"task_item_id";i:0;s:8:"color_id";i:0;s:5:"alpha";s:2:"FF";s:13:"graph_type_id";s:1:"9";s:10:"line_width";s:4:"0.00";s:6:"dashes";N;s:11:"dash_offset";i:0;s:7:"cdef_id";i:0;s:7:"vdef_id";i:0;s:5:"shift";N;s:25:"consolidation_function_id";s:1:"3";s:9:"textalign";N;s:11:"text_format";s:8:"Maximum:";s:5:"value";s:0:"";s:11:"hard_return";s:2:"on";s:9:"gprint_id";s:1:"3";}'
2018/11/02 07:15:40 - DBCALL DEVEL: SQL Save on table 'graph_templates_item': 'a:21:{s:28:"local_graph_template_item_id";s:3:"383";s:14:"local_graph_id";s:3:"404";s:17:"graph_template_id";s:2:"36";s:8:"sequence";s:1:"3";s:2:"id";i:0;s:12:"task_item_id";i:0;s:8:"color_id";i:0;s:5:"alpha";s:2:"FF";s:13:"graph_type_id";s:1:"9";s:10:"line_width";s:4:"0.00";s:6:"dashes";N;s:11:"dash_offset";i:0;s:7:"cdef_id";i:0;s:7:"vdef_id";i:0;s:5:"shift";N;s:25:"consolidation_function_id";s:1:"1";s:9:"textalign";N;s:11:"text_format";s:8:"Average:";s:5:"value";s:0:"";s:11:"hard_return";s:0:"";s:9:"gprint_id";s:1:"3";}'
2018/11/02 07:15:40 - DBCALL DEVEL: SQL Save on table 'graph_templates_item': 'a:21:{s:28:"local_graph_template_item_id";s:3:"382";s:14:"local_graph_id";s:3:"404";s:17:"graph_template_id";s:2:"36";s:8:"sequence";s:1:"2";s:2:"id";i:0;s:12:"task_item_id";i:0;s:8:"color_id";i:0;s:5:"alpha";s:2:"FF";s:13:"graph_type_id";s:1:"9";s:10:"line_width";s:4:"0.00";s:6:"dashes";N;s:11:"dash_offset";i:0;s:7:"cdef_id";i:0;s:7:"vdef_id";i:0;s:5:"shift";N;s:25:"consolidation_function_id";s:1:"4";s:9:"textalign";N;s:11:"text_format";s:8:"Current:";s:5:"value";s:0:"";s:11:"hard_return";s:0:"";s:9:"gprint_id";s:1:"3";}'
2018/11/02 07:15:39 - DBCALL DEVEL: SQL Save on table 'graph_templates_item': 'a:21:{s:28:"local_graph_template_item_id";s:3:"381";s:14:"local_graph_id";s:3:"404";s:17:"graph_template_id";s:2:"36";s:8:"sequence";s:1:"1";s:2:"id";i:0;s:12:"task_item_id";i:0;s:8:"color_id";s:3:"440";s:5:"alpha";s:2:"CC";s:13:"graph_type_id";s:1:"7";s:10:"line_width";s:4:"0.00";s:6:"dashes";N;s:11:"dash_offset";i:0;s:7:"cdef_id";i:0;s:7:"vdef_id";i:0;s:5:"shift";N;s:25:"consolidation_function_id";s:1:"1";s:9:"textalign";N;s:11:"text_format";s:9:"5 Seconds";s:5:"value";s:0:"";s:11:"hard_return";s:0:"";s:9:"gprint_id";s:1:"2";}'
2018/11/02 07:15:39 - DBCALL DEVEL: SQL Save on table 'graph_templates_graph': 'a:34:{s:2:"id";i:0;s:29:"local_graph_template_graph_id";s:2:"40";s:14:"local_graph_id";s:3:"404";s:17:"graph_template_id";s:2:"36";s:5:"title";s:30:"|host_description| - CPU Usage";s:14:"vertical_label";s:7:"percent";s:15:"image_format_id";s:1:"1";s:6:"height";s:3:"120";s:5:"width";s:3:"600";s:10:"base_value";s:4:"1000";s:10:"slope_mode";s:2:"on";s:10:"auto_scale";s:2:"on";s:15:"auto_scale_opts";s:1:"1";s:14:"auto_scale_log";s:0:"";s:15:"scale_log_units";s:0:"";s:16:"auto_scale_rigid";s:2:"on";s:11:"upper_limit";s:3:"100";s:11:"lower_limit";s:1:"0";s:10:"unit_value";s:0:"";s:19:"unit_exponent_value";s:0:"";s:11:"unit_length";N;s:10:"no_gridfit";N;s:10:"alt_y_grid";N;s:10:"right_axis";N;s:16:"right_axis_label";N;s:17:"right_axis_format";N;s:20:"right_axis_formatter";N;s:19:"left_axis_formatter";N;s:12:"auto_padding";s:2:"on";s:14:"dynamic_labels";N;s:18:"force_rules_legend";N;s:9:"tab_width";s:2:"30";s:15:"legend_position";N;s:16:"legend_direction";N;}'
2018/11/02 07:15:38 - DBCALL DEVEL: SQL Save on table 'graph_local': 'a:6:{s:2:"id";i:0;s:17:"graph_template_id";s:2:"36";s:7:"host_id";s:2:"63";s:13:"snmp_query_id";i:0;s:19:"snmp_query_graph_id";i:0;s:10:"snmp_index";s:0:"";}'
2018/11/02 07:15:38 - LINKDISCOVERY Host se-ch9-40 saved id 63 Host template: 6
2018/11/02 07:15:37 - MAP host: se-ch9-40.recolte.lausanne.ch location: Suisse;Lausanne;Place Chauderon 9;-1; (63)
2018/11/02 07:15:37 - AUTOM8 NOTE: [PID: 23468] create_device_node() Device[se-ch9-40] Tree Item - Added - Parent[11] Id[85]
2018/11/02 07:15:37 - DBCALL DEVEL: SQL Save on table 'graph_tree_items': 'a:8:{s:2:"id";i:0;s:13:"graph_tree_id";s:1:"3";s:5:"title";s:0:"";s:6:"parent";s:2:"11";s:14:"local_graph_id";i:0;s:7:"host_id";s:2:"63";s:18:"host_grouping_type";s:1:"1";s:18:"sort_children_type";i:0;}'
2018/11/02 07:15:27 - DBCALL DEVEL: SQL Save on table 'host': 'a:33:{s:2:"id";s:1:"0";s:16:"host_template_id";s:1:"6";s:9:"poller_id";i:1;s:7:"site_id";i:0;s:11:"external_id";s:0:"";s:11:"description";s:9:"se-ch9-40";s:8:"hostname";s:29:"se-ch9-40.recolte.lausanne.ch";s:5:"notes";s:30:"Added by Link Discovery Plugin";s:8:"location";s:0:"";s:12:"snmp_version";s:1:"2";s:14:"snmp_community";s:7:"telvlsn";s:13:"snmp_username";s:0:"";s:13:"snmp_password";s:0:"";s:18:"snmp_auth_protocol";s:0:"";s:20:"snmp_priv_passphrase";s:0:"";s:18:"snmp_priv_protocol";s:0:"";s:12:"snmp_context";s:0:"";s:14:"snmp_engine_id";s:0:"";s:9:"snmp_port";s:3:"161";s:12:"snmp_timeout";s:3:"500";s:8:"disabled";b:0;s:19:"availability_method";s:1:"2";s:11:"ping_method";s:1:"2";s:9:"ping_port";s:2:"23";s:12:"ping_timeout";s:3:"400";s:12:"ping_retries";s:1:"1";s:8:"max_oids";i:10;s:14:"device_threads";i:1;s:7:"monitor";s:2:"on";s:12:"monitor_text";s:0:"";s:19:"monitor_criticality";s:0:"";s:12:"monitor_warn";s:0:"";s:13:"monitor_alert";s:0:"";}'
2018/11/02 07:15:27 - LINKDISCOVERY template 6
2018/11/02 07:15:27 - LINKDISCOVERY snmp interface id for: se-ch9-40.recolte.lausanne.ch type: 6
CentOS
Production
Cacti 0.8.8h
Spine 0.8.8h
PIA 3.1
Aggregate 0.75
Monitor 1.3
Settings 0.71
Weathermap 0.98
Thold 0.5
rrdclean 0.41

Own plugin: LinkDiscovery 0.3, Map 0.4

Test
Cacti 1.2.1
Spine 1.2.1
thold 1.0.6
monitor 2.3.5
php 7.2.11
mariadb 5.5.56
Own plugin:
ExtendDB 1.1.2
LinkDiscovery 1.2.4
Map 1.2.5

netniV
Cacti Guru User
Posts: 2686
Joined: Sun Aug 27, 2017 12:05 am

Re: Add device failed

#4 Post by netniV » Fri Nov 02, 2018 4:09 am

Does your own plugin modify the host table in some way? Can you run an SQL DESC on the table that is failing to save?

Rno
Cacti User
Posts: 325
Joined: Wed Dec 07, 2011 9:19 am

Re: Add device failed

#5 Post by Rno » Fri Nov 02, 2018 7:04 am

No my plugin dosen't change anything on the table.
I have another plugin that add some field into the table (the last 3 fields)

Code: Select all

MariaDB [cacti]> desc host;
+------------------------+-----------------------+------+-----+---------------------+-----------------------------+
| Field                  | Type                  | Null | Key | Default             | Extra                       |
+------------------------+-----------------------+------+-----+---------------------+-----------------------------+
| id                     | mediumint(8) unsigned | NO   | PRI | NULL                | auto_increment              |
| poller_id              | int(10) unsigned      | NO   | MUL | 1                   |                             |
| site_id                | int(10) unsigned      | NO   | MUL | 1                   |                             |
| host_template_id       | mediumint(8) unsigned | NO   |     | 0                   |                             |
| description            | varchar(150)          | NO   |     |                     |                             |
| hostname               | varchar(100)          | YES  | MUL | NULL                |                             |
| location               | varchar(40)           | YES  |     | NULL                |                             |
| notes                  | mediumtext            | YES  |     | NULL                |                             |
| external_id            | varchar(40)           | YES  | MUL | NULL                |                             |
| snmp_community         | varchar(100)          | YES  |     | NULL                |                             |
| snmp_version           | tinyint(1) unsigned   | NO   |     | 1                   |                             |
| snmp_username          | varchar(50)           | YES  |     | NULL                |                             |
| snmp_password          | varchar(50)           | YES  |     | NULL                |                             |
| snmp_auth_protocol     | char(6)               | YES  |     |                     |                             |
| snmp_priv_passphrase   | varchar(200)          | YES  |     |                     |                             |
| snmp_priv_protocol     | char(6)               | YES  |     |                     |                             |
| snmp_context           | varchar(64)           | YES  |     |                     |                             |
| snmp_engine_id         | varchar(64)           | YES  |     |                     |                             |
| snmp_port              | mediumint(5) unsigned | NO   |     | 161                 |                             |
| snmp_timeout           | mediumint(8) unsigned | NO   |     | 500                 |                             |
| snmp_sysDescr          | varchar(300)          | NO   |     |                     |                             |
| snmp_sysObjectID       | varchar(128)          | NO   |     |                     |                             |
| snmp_sysUpTimeInstance | int(10) unsigned      | NO   |     | 0                   |                             |
| snmp_sysContact        | varchar(300)          | NO   |     |                     |                             |
| snmp_sysName           | varchar(300)          | NO   |     |                     |                             |
| snmp_sysLocation       | varchar(300)          | NO   |     |                     |                             |
| availability_method    | smallint(5) unsigned  | NO   |     | 1                   |                             |
| ping_method            | smallint(5) unsigned  | YES  |     | 0                   |                             |
| ping_port              | int(12) unsigned      | YES  |     | 0                   |                             |
| ping_timeout           | int(12) unsigned      | YES  |     | 500                 |                             |
| ping_retries           | int(12) unsigned      | YES  |     | 2                   |                             |
| max_oids               | int(12) unsigned      | YES  |     | 10                  |                             |
| device_threads         | tinyint(2) unsigned   | NO   |     | 1                   |                             |
| disabled               | char(2)               | YES  | MUL | NULL                |                             |
| monitor                | char(3)               | NO   |     | on                  |                             |
| monitor_text           | varchar(1024)         | NO   |     |                     |                             |
| monitor_criticality    | tinyint(3) unsigned   | NO   |     | 0                   |                             |
| monitor_warn           | double                | NO   |     | 0                   |                             |
| monitor_alert          | double                | NO   |     | 0                   |                             |
| thold_send_email       | int(10)               | NO   |     | 1                   |                             |
| thold_host_email       | int(10)               | YES  |     | NULL                |                             |
| status                 | tinyint(2)            | NO   | MUL | 0                   |                             |
| status_event_count     | mediumint(8) unsigned | NO   |     | 0                   |                             |
| status_fail_date       | timestamp             | NO   |     | 0000-00-00 00:00:00 |                             |
| status_rec_date        | timestamp             | NO   |     | 0000-00-00 00:00:00 |                             |
| status_last_error      | varchar(255)          | YES  |     |                     |                             |
| min_time               | decimal(10,5)         | YES  |     | 9.99999             |                             |
| max_time               | decimal(10,5)         | YES  |     | 0.00000             |                             |
| cur_time               | decimal(10,5)         | YES  |     | 0.00000             |                             |
| avg_time               | decimal(10,5)         | YES  |     | 0.00000             |                             |
| polling_time           | double                | YES  |     | 0                   |                             |
| total_polls            | int(12) unsigned      | YES  |     | 0                   |                             |
| failed_polls           | int(12) unsigned      | YES  |     | 0                   |                             |
| availability           | decimal(8,5)          | NO   |     | 100.00000           |                             |
| last_updated           | timestamp             | NO   |     | CURRENT_TIMESTAMP   | on update CURRENT_TIMESTAMP |
| serial_no              | char(20)              | NO   |     |                     |                             |
| type                   | char(50)              | NO   |     |                     |                             |
| isPhone                | char(2)               | NO   |     |                     |                             |
+------------------------+-----------------------+------+-----+---------------------+-----------------------------+
And it fall to save a device when created by hand or by automation:
by hand:
Action failed
Sorry, we could not process your last action.

Save Successful.

Here is the log:
og [Total Lines: 3435 - Admin view - Unfiltered] [ 1.2.0 - Beta 2 ]
2018/11/02 13:02:19 - MAP host: sre-b30-130.recolte.lausanne.ch location: Suisse;Lausanne;Place Chauderon 9;-1;Local telecom (67)
2018/11/02 13:02:18 - AUTOM8 TRACE [PID: 10263] automation_execute_device_create_tree() Device[sre-b30-130], rule: 5, matching hosts: []
2018/11/02 13:02:18 - AUTOM8 TRACE [PID: 10263] get_matching_hosts() returning: SELECT h.id AS host_id, h.hostname, h.description, h.disabled, h.status, ht.name AS host_template_name FROM host AS h LEFT JOIN host_template AS ht ON (h.host_template_id=ht.id) WHERE ( `h`.`description` LIKE 'sre-d%') AND h.id=67 matches: 0
2018/11/02 13:02:18 - AUTOM8 TRACE [PID: 10263] build_matching_objects_filter() returns: `h`.`description` LIKE 'sre-d%'
2018/11/02 13:02:18 - AUTOM8 TRACE [PID: 10263] build_rule_item_filter() returns: `h`.`description` LIKE 'sre-d%'
2018/11/02 13:02:18 - AUTOM8 TRACE [PID: 10263] build_rule_item_filter() called: [{"id":"11","rule_id":"5","rule_type":"3","sequence":"1","operation":"0","field":"h.description","operator":"3","pattern":"sre-d"}], prefix:
2018/11/02 13:02:18 - AUTOM8 TRACE [PID: 10263] build_matching_objects_filter() called rule id: 5
2018/11/02 13:02:18 - AUTOM8 TRACE [PID: 10263] get_matching_hosts() called: {"id":"5","name":"DC","tree_id":"3","tree_item_id":"8","leaf_type":"3","host_grouping_type":"1"} type: 3
2018/11/02 13:02:18 - AUTOM8 TRACE [PID: 10263] automation_execute_device_create_tree() Device[sre-b30-130], rule: 5 name: DC type: 3
2018/11/02 13:02:18 - AUTOM8 TRACE [PID: 10263] automation_execute_device_create_tree() Device[sre-b30-130], rule: 4, node: 87
2018/11/02 13:02:18 - AUTOM8 NOTE: [PID: 10263] create_device_node() Device[sre-b30-130] Tree Item - Added - Parent[6] Id[87]
2018/11/02 13:02:18 - AUTOM8 TRACE [PID: 10263] automation_execute_device_create_tree() Device[sre-b30-130], rule: 4, parent: 6
2018/11/02 13:02:18 - AUTOM8 TRACE [PID: 10263] create_all_header_nodes() called: Item 67 matches: 0 items
2018/11/02 13:02:18 - AUTOM8 TRACE [PID: 10263] automation_execute_device_create_tree() Device[sre-b30-130], rule: 4, matching hosts: [{"host_id":"67","hostname":"sre-b30-130.recolte.lausanne.ch","description":"sre-b30-130","disabled":"","status":"0","host_template_name":"Cisco 4500-X"}]
2018/11/02 13:02:18 - AUTOM8 TRACE [PID: 10263] get_matching_hosts() returning: SELECT h.id AS host_id, h.hostname, h.description, h.disabled, h.status, ht.name AS host_template_name FROM host AS h LEFT JOIN host_template AS ht ON (h.host_template_id=ht.id) WHERE ( `h`.`description` LIKE 'sre-b%') AND h.id=67 matches: 1
2018/11/02 13:02:18 - AUTOM8 TRACE [PID: 10263] build_matching_objects_filter() returns: `h`.`description` LIKE 'sre-b%'
2018/11/02 13:02:18 - AUTOM8 TRACE [PID: 10263] build_rule_item_filter() returns: `h`.`description` LIKE 'sre-b%'
2018/11/02 13:02:18 - AUTOM8 TRACE [PID: 10263] build_rule_item_filter() called: [{"id":"10","rule_id":"4","rule_type":"3","sequence":"1","operation":"0","field":"h.description","operator":"3","pattern":"sre-b"}], prefix:
2018/11/02 13:02:18 - AUTOM8 TRACE [PID: 10263] build_matching_objects_filter() called rule id: 4
2018/11/02 13:02:18 - AUTOM8 TRACE [PID: 10263] get_matching_hosts() called: {"id":"4","name":"PdB","tree_id":"3","tree_item_id":"6","leaf_type":"3","host_grouping_type":"1"} type: 3
2018/11/02 13:02:18 - AUTOM8 TRACE [PID: 10263] automation_execute_device_create_tree() Device[sre-b30-130], rule: 4 name: PdB type: 3
2018/11/02 13:02:18 - AUTOM8 TRACE [PID: 10263] automation_execute_device_create_tree() Device[sre-b30-130], rule: 3, matching hosts: []
2018/11/02 13:02:18 - AUTOM8 TRACE [PID: 10263] get_matching_hosts() returning: SELECT h.id AS host_id, h.hostname, h.description, h.disabled, h.status, ht.name AS host_template_name FROM host AS h LEFT JOIN host_template AS ht ON (h.host_template_id=ht.id) WHERE ( `h`.`description` LIKE 'SE-%') AND h.id=67 matches: 0
2018/11/02 13:02:18 - AUTOM8 TRACE [PID: 10263] build_matching_objects_filter() returns: `h`.`description` LIKE 'SE-%'
2018/11/02 13:02:18 - AUTOM8 TRACE [PID: 10263] build_rule_item_filter() returns: `h`.`description` LIKE 'SE-%'
2018/11/02 13:02:18 - AUTOM8 TRACE [PID: 10263] build_rule_item_filter() called: [{"id":"9","rule_id":"3","rule_type":"3","sequence":"1","operation":"0","field":"h.description","operator":"3","pattern":"SE-"}], prefix:
2018/11/02 13:02:18 - AUTOM8 TRACE [PID: 10263] build_matching_objects_filter() called rule id: 3
2018/11/02 13:02:18 - AUTOM8 TRACE [PID: 10263] get_matching_hosts() called: {"id":"3","name":"Switch","tree_id":"3","tree_item_id":"11","leaf_type":"3","host_grouping_type":"1"} type: 3
2018/11/02 13:02:18 - AUTOM8 TRACE [PID: 10263] automation_execute_device_create_tree() Device[sre-b30-130], rule: 3 name: Switch type: 3
2018/11/02 13:02:18 - AUTOM8 TRACE [PID: 10263] automation_execute_device_create_tree() Device[sre-b30-130], matching rule sql: SELECT atr.id, atr.name, atr.tree_id, atr.tree_item_id, atr.leaf_type, atr.host_grouping_type FROM automation_tree_rules AS atr WHERE enabled='on' AND leaf_type=3 matches: 3
2018/11/02 13:02:18 - AUTOM8 TRACE [PID: 10263] automation_execute_device_create_tree() Device[sre-b30-130] called
2018/11/02 13:02:14 - AUTOM8 TRACE [PID: 10263] automation_hook_graph_template() Device[sre-b30-130] - skipped: Graph Creation Switch is: off
2018/11/02 13:02:14 - AUTOM8 TRACE [PID: 10263] automation_hook_graph_template() called: Device[sre-b30-130], GT[Cisco 4500 VSS Status]
2018/11/02 13:02:14 - AUTOM8 TRACE [PID: 10263] automation_hook_graph_template() Device[sre-b30-130] - skipped: Graph Creation Switch is: off
2018/11/02 13:02:14 - AUTOM8 TRACE [PID: 10263] automation_hook_graph_template() called: Device[sre-b30-130], GT[Cisco 4500 CPU usage]
2018/11/02 13:02:14 - AUTOM8 TRACE [PID: 10263] automation_execute_data_query() Device[sre-b30-130] - create sql: SELECT h.id AS host_id, h.hostname, h.description, ht.name AS host_template_name FROM host AS h LEFT JOIN host_template AS ht ON h.host_template_id=ht.id WHERE ( `ht`.`name` LIKE '%Linux%' AND `h`.`snmp_version` >= '2') AND h.id=67 matches: 0
2018/11/02 13:02:14 - AUTOM8 TRACE [PID: 10263] build_matching_objects_filter() returns: `ht`.`name` LIKE '%Linux%' AND `h`.`snmp_version` >= '2'
2018/11/02 13:02:14 - AUTOM8 TRACE [PID: 10263] build_rule_item_filter() returns: `ht`.`name` LIKE '%Linux%' AND `h`.`snmp_version` >= '2'
2018/11/02 13:02:14 - AUTOM8 TRACE [PID: 10263] build_rule_item_filter() called: [{"id":"4","rule_id":"2","rule_type":"1","sequence":"1","operation":"0","field":"ht.name","operator":"1","pattern":"Linux"},{"id":"5","rule_id":"2","rule_type":"1","sequence":"2","operation":"1","field":"h.snmp_version","operator":"12","pattern":"2"}], prefix:
2018/11/02 13:02:14 - AUTOM8 TRACE [PID: 10263] build_matching_objects_filter() called rule id: 2
2018/11/02 13:02:14 - AUTOM8 TRACE [PID: 10263] automation_execute_data_query() Device[sre-b30-130] - rule=2 name: Traffic 64 bit Server Linux
2018/11/02 13:02:14 - AUTOM8 TRACE [PID: 10263] automation_execute_data_query() Device[sre-b30-130] - create sql: SELECT h.id AS host_id, h.hostname, h.description, ht.name AS host_template_name FROM host AS h LEFT JOIN host_template AS ht ON h.host_template_id=ht.id WHERE ( `h`.`snmp_sysDescr` <> '' AND `h`.`snmp_version` >= '2' AND `h`.`snmp_sysDescr` NOT LIKE '%Windows%') AND h.id=67 matches: 0
2018/11/02 13:02:14 - AUTOM8 TRACE [PID: 10263] build_matching_objects_filter() returns: `h`.`snmp_sysDescr` <> '' AND `h`.`snmp_version` >= '2' AND `h`.`snmp_sysDescr` NOT LIKE '%Windows%'
2018/11/02 13:02:14 - AUTOM8 TRACE [PID: 10263] build_rule_item_filter() returns: `h`.`snmp_sysDescr` <> '' AND `h`.`snmp_version` >= '2' AND `h`.`snmp_sysDescr` NOT LIKE '%Windows%'
2018/11/02 13:02:14 - AUTOM8 TRACE [PID: 10263] build_rule_item_filter() called: [{"id":"1","rule_id":"1","rule_type":"1","sequence":"1","operation":"0","field":"h.snmp_sysDescr","operator":"8","pattern":""},{"id":"2","rule_id":"1","rule_type":"1","sequence":"2","operation":"1","field":"h.snmp_version","operator":"12","pattern":"2"},{"id":"8","rule_id":"1","rule_type":"1","sequence":"3","operation":"1","field":"h.snmp_sysDescr","operator":"2","pattern":"Windows"}], prefix:
2018/11/02 13:02:14 - AUTOM8 TRACE [PID: 10263] build_matching_objects_filter() called rule id: 1
2018/11/02 13:02:14 - AUTOM8 TRACE [PID: 10263] automation_execute_data_query() Device[sre-b30-130] - rule=1 name: Traffic 64 bit Server
2018/11/02 13:02:14 - AUTOM8 TRACE [PID: 10263] automation_execute_data_query() Device[sre-b30-130] - sql: SELECT agr.id, agr.name, agr.snmp_query_id, agr.graph_type_id FROM automation_graph_rules AS agr WHERE snmp_query_id=1 AND enabled='on' - found: 2
2018/11/02 13:02:14 - AUTOM8 TRACE [PID: 10263] automation_execute_data_query() Device[sre-b30-130] - start - data query: 1

And if I look into the Database, the record is correct, all information are here
CentOS
Production
Cacti 0.8.8h
Spine 0.8.8h
PIA 3.1
Aggregate 0.75
Monitor 1.3
Settings 0.71
Weathermap 0.98
Thold 0.5
rrdclean 0.41

Own plugin: LinkDiscovery 0.3, Map 0.4

Test
Cacti 1.2.1
Spine 1.2.1
thold 1.0.6
monitor 2.3.5
php 7.2.11
mariadb 5.5.56
Own plugin:
ExtendDB 1.1.2
LinkDiscovery 1.2.4
Map 1.2.5

netniV
Cacti Guru User
Posts: 2686
Joined: Sun Aug 27, 2017 12:05 am

Re: Add device failed

#6 Post by netniV » Fri Nov 02, 2018 8:06 am

OK, well I can see a small problem with that plugin. It's adding fields with no defaults. Therefore, when something that knows nothing about those fields attempts to create a record, it will error because they do not allow nulls and they have no default value.

Rno
Cacti User
Posts: 325
Joined: Wed Dec 07, 2011 9:19 am

Re: Add device failed

#7 Post by Rno » Fri Nov 02, 2018 8:14 am

Ok I change it
but still same error

2018/11/02 14:11:36 - MAP host: sre-b45-145.recolte.lausanne.ch location: Suisse;Lausanne;Place Chauderon 9;-1;Local telecom (69)
2018/11/02 14:11:35 - AUTOM8 TRACE [PID: 6762] automation_execute_device_create_tree() Device[sre-b45-145], rule: 5, matching hosts: []
2018/11/02 14:11:35 - AUTOM8 TRACE [PID: 6762] get_matching_hosts() returning: SELECT h.id AS host_id, h.hostname, h.description, h.disabled, h.status, ht.name AS host_template_name FROM host AS h LEFT JOIN host_template AS ht ON (h.host_template_id=ht.id) WHERE ( `h`.`description` LIKE 'sre-d%') AND h.id=69 matches: 0
2018/11/02 14:11:35 - AUTOM8 TRACE [PID: 6762] build_matching_objects_filter() returns: `h`.`description` LIKE 'sre-d%'
2018/11/02 14:11:35 - AUTOM8 TRACE [PID: 6762] build_rule_item_filter() returns: `h`.`description` LIKE 'sre-d%'
2018/11/02 14:11:35 - AUTOM8 TRACE [PID: 6762] build_rule_item_filter() called: [{"id":"11","rule_id":"5","rule_type":"3","sequence":"1","operation":"0","field":"h.description","operator":"3","pattern":"sre-d"}], prefix:
2018/11/02 14:11:35 - AUTOM8 TRACE [PID: 6762] build_matching_objects_filter() called rule id: 5
2018/11/02 14:11:35 - AUTOM8 TRACE [PID: 6762] get_matching_hosts() called: {"id":"5","name":"DC","tree_id":"3","tree_item_id":"8","leaf_type":"3","host_grouping_type":"1"} type: 3
2018/11/02 14:11:35 - AUTOM8 TRACE [PID: 6762] automation_execute_device_create_tree() Device[sre-b45-145], rule: 5 name: DC type: 3
2018/11/02 14:11:35 - AUTOM8 TRACE [PID: 6762] automation_execute_device_create_tree() Device[sre-b45-145], rule: 4, node: 89
2018/11/02 14:11:35 - AUTOM8 NOTE: [PID: 6762] create_device_node() Device[sre-b45-145] Tree Item - Added - Parent[6] Id[89]
2018/11/02 14:11:35 - AUTOM8 TRACE [PID: 6762] automation_execute_device_create_tree() Device[sre-b45-145], rule: 4, parent: 6
2018/11/02 14:11:35 - AUTOM8 TRACE [PID: 6762] create_all_header_nodes() called: Item 69 matches: 0 items
2018/11/02 14:11:35 - AUTOM8 TRACE [PID: 6762] automation_execute_device_create_tree() Device[sre-b45-145], rule: 4, matching hosts: [{"host_id":"69","hostname":"sre-b45-145.recolte.lausanne.ch","description":"sre-b45-145","disabled":"","status":"0","host_template_name":"Cisco 4500-X"}]
2018/11/02 14:11:35 - AUTOM8 TRACE [PID: 6762] get_matching_hosts() returning: SELECT h.id AS host_id, h.hostname, h.description, h.disabled, h.status, ht.name AS host_template_name FROM host AS h LEFT JOIN host_template AS ht ON (h.host_template_id=ht.id) WHERE ( `h`.`description` LIKE 'sre-b%') AND h.id=69 matches: 1
2018/11/02 14:11:35 - AUTOM8 TRACE [PID: 6762] build_matching_objects_filter() returns: `h`.`description` LIKE 'sre-b%'
2018/11/02 14:11:35 - AUTOM8 TRACE [PID: 6762] build_rule_item_filter() returns: `h`.`description` LIKE 'sre-b%'
2018/11/02 14:11:35 - AUTOM8 TRACE [PID: 6762] build_rule_item_filter() called: [{"id":"10","rule_id":"4","rule_type":"3","sequence":"1","operation":"0","field":"h.description","operator":"3","pattern":"sre-b"}], prefix:
2018/11/02 14:11:35 - AUTOM8 TRACE [PID: 6762] build_matching_objects_filter() called rule id: 4
2018/11/02 14:11:35 - AUTOM8 TRACE [PID: 6762] get_matching_hosts() called: {"id":"4","name":"PdB","tree_id":"3","tree_item_id":"6","leaf_type":"3","host_grouping_type":"1"} type: 3
2018/11/02 14:11:35 - AUTOM8 TRACE [PID: 6762] automation_execute_device_create_tree() Device[sre-b45-145], rule: 4 name: PdB type: 3
2018/11/02 14:11:35 - AUTOM8 TRACE [PID: 6762] automation_execute_device_create_tree() Device[sre-b45-145], rule: 3, matching hosts: []
2018/11/02 14:11:35 - AUTOM8 TRACE [PID: 6762] get_matching_hosts() returning: SELECT h.id AS host_id, h.hostname, h.description, h.disabled, h.status, ht.name AS host_template_name FROM host AS h LEFT JOIN host_template AS ht ON (h.host_template_id=ht.id) WHERE ( `h`.`description` LIKE 'SE-%') AND h.id=69 matches: 0
2018/11/02 14:11:35 - AUTOM8 TRACE [PID: 6762] build_matching_objects_filter() returns: `h`.`description` LIKE 'SE-%'
2018/11/02 14:11:35 - AUTOM8 TRACE [PID: 6762] build_rule_item_filter() returns: `h`.`description` LIKE 'SE-%'
2018/11/02 14:11:35 - AUTOM8 TRACE [PID: 6762] build_rule_item_filter() called: [{"id":"9","rule_id":"3","rule_type":"3","sequence":"1","operation":"0","field":"h.description","operator":"3","pattern":"SE-"}], prefix:
2018/11/02 14:11:35 - AUTOM8 TRACE [PID: 6762] build_matching_objects_filter() called rule id: 3
2018/11/02 14:11:35 - AUTOM8 TRACE [PID: 6762] get_matching_hosts() called: {"id":"3","name":"Switch","tree_id":"3","tree_item_id":"11","leaf_type":"3","host_grouping_type":"1"} type: 3
2018/11/02 14:11:35 - AUTOM8 TRACE [PID: 6762] automation_execute_device_create_tree() Device[sre-b45-145], rule: 3 name: Switch type: 3
2018/11/02 14:11:35 - AUTOM8 TRACE [PID: 6762] automation_execute_device_create_tree() Device[sre-b45-145], matching rule sql: SELECT atr.id, atr.name, atr.tree_id, atr.tree_item_id, atr.leaf_type, atr.host_grouping_type FROM automation_tree_rules AS atr WHERE enabled='on' AND leaf_type=3 matches: 3
2018/11/02 14:11:35 - AUTOM8 TRACE [PID: 6762] automation_execute_device_create_tree() Device[sre-b45-145] called
2018/11/02 14:11:31 - AUTOM8 TRACE [PID: 6762] automation_hook_graph_template() Device[sre-b45-145] - skipped: Graph Creation Switch is: off
2018/11/02 14:11:31 - AUTOM8 TRACE [PID: 6762] automation_hook_graph_template() called: Device[sre-b45-145], GT[Cisco 4500 VSS Status]
2018/11/02 14:11:31 - AUTOM8 TRACE [PID: 6762] automation_hook_graph_template() Device[sre-b45-145] - skipped: Graph Creation Switch is: off
2018/11/02 14:11:31 - AUTOM8 TRACE [PID: 6762] automation_hook_graph_template() called: Device[sre-b45-145], GT[Cisco 4500 CPU usage]
2018/11/02 14:11:31 - AUTOM8 TRACE [PID: 6762] automation_execute_data_query() Device[sre-b45-145] - create sql: SELECT h.id AS host_id, h.hostname, h.description, ht.name AS host_template_name FROM host AS h LEFT JOIN host_template AS ht ON h.host_template_id=ht.id WHERE ( `ht`.`name` LIKE '%Linux%' AND `h`.`snmp_version` >= '2') AND h.id=69 matches: 0
2018/11/02 14:11:31 - AUTOM8 TRACE [PID: 6762] build_matching_objects_filter() returns: `ht`.`name` LIKE '%Linux%' AND `h`.`snmp_version` >= '2'
2018/11/02 14:11:31 - AUTOM8 TRACE [PID: 6762] build_rule_item_filter() returns: `ht`.`name` LIKE '%Linux%' AND `h`.`snmp_version` >= '2'
2018/11/02 14:11:31 - AUTOM8 TRACE [PID: 6762] build_rule_item_filter() called: [{"id":"4","rule_id":"2","rule_type":"1","sequence":"1","operation":"0","field":"ht.name","operator":"1","pattern":"Linux"},{"id":"5","rule_id":"2","rule_type":"1","sequence":"2","operation":"1","field":"h.snmp_version","operator":"12","pattern":"2"}], prefix:
2018/11/02 14:11:31 - AUTOM8 TRACE [PID: 6762] build_matching_objects_filter() called rule id: 2
2018/11/02 14:11:31 - AUTOM8 TRACE [PID: 6762] automation_execute_data_query() Device[sre-b45-145] - rule=2 name: Traffic 64 bit Server Linux
2018/11/02 14:11:31 - AUTOM8 TRACE [PID: 6762] automation_execute_data_query() Device[sre-b45-145] - create sql: SELECT h.id AS host_id, h.hostname, h.description, ht.name AS host_template_name FROM host AS h LEFT JOIN host_template AS ht ON h.host_template_id=ht.id WHERE ( `h`.`snmp_sysDescr` <> '' AND `h`.`snmp_version` >= '2' AND `h`.`snmp_sysDescr` NOT LIKE '%Windows%') AND h.id=69 matches: 0
2018/11/02 14:11:31 - AUTOM8 TRACE [PID: 6762] build_matching_objects_filter() returns: `h`.`snmp_sysDescr` <> '' AND `h`.`snmp_version` >= '2' AND `h`.`snmp_sysDescr` NOT LIKE '%Windows%'
2018/11/02 14:11:31 - AUTOM8 TRACE [PID: 6762] build_rule_item_filter() returns: `h`.`snmp_sysDescr` <> '' AND `h`.`snmp_version` >= '2' AND `h`.`snmp_sysDescr` NOT LIKE '%Windows%'
2018/11/02 14:11:31 - AUTOM8 TRACE [PID: 6762] build_rule_item_filter() called: [{"id":"1","rule_id":"1","rule_type":"1","sequence":"1","operation":"0","field":"h.snmp_sysDescr","operator":"8","pattern":""},{"id":"2","rule_id":"1","rule_type":"1","sequence":"2","operation":"1","field":"h.snmp_version","operator":"12","pattern":"2"},{"id":"8","rule_id":"1","rule_type":"1","sequence":"3","operation":"1","field":"h.snmp_sysDescr","operator":"2","pattern":"Windows"}], prefix:
2018/11/02 14:11:31 - AUTOM8 TRACE [PID: 6762] build_matching_objects_filter() called rule id: 1
2018/11/02 14:11:31 - AUTOM8 TRACE [PID: 6762] automation_execute_data_query() Device[sre-b45-145] - rule=1 name: Traffic 64 bit Server
2018/11/02 14:11:31 - AUTOM8 TRACE [PID: 6762] automation_execute_data_query() Device[sre-b45-145] - sql: SELECT agr.id, agr.name, agr.snmp_query_id, agr.graph_type_id FROM automation_graph_rules AS agr WHERE snmp_query_id=1 AND enabled='on' - found: 2
2018/11/02 14:11:31 - AUTOM8 TRACE [PID: 6762] automation_execute_data_query() Device[sre-b45-145] - start - data query: 1


DESC:
| serial_no | char(20) | YES | | NULL | |
| type | char(50) | YES | | NULL | |
| isPhone | char(2) | YES | | NULL | |
CentOS
Production
Cacti 0.8.8h
Spine 0.8.8h
PIA 3.1
Aggregate 0.75
Monitor 1.3
Settings 0.71
Weathermap 0.98
Thold 0.5
rrdclean 0.41

Own plugin: LinkDiscovery 0.3, Map 0.4

Test
Cacti 1.2.1
Spine 1.2.1
thold 1.0.6
monitor 2.3.5
php 7.2.11
mariadb 5.5.56
Own plugin:
ExtendDB 1.1.2
LinkDiscovery 1.2.4
Map 1.2.5

netniV
Cacti Guru User
Posts: 2686
Joined: Sun Aug 27, 2017 12:05 am

Re: Add device failed

#8 Post by netniV » Fri Nov 02, 2018 8:40 am

Do you have a test environment where you can turn on the SQL logging? That way you would be able to see what is failing with the SQL statement, if anything. Turning on that in your live environment would be a lot of detail. Are there any MySQL/MariaDB logs that show the error?

netniV
Cacti Guru User
Posts: 2686
Joined: Sun Aug 27, 2017 12:05 am

Re: Add device failed

#9 Post by netniV » Fri Nov 02, 2018 8:44 am

I've compared your table to mine in 1.2.0, and the only other difference is this:

Code: Select all

--- a/tmp/s1
+++ b/tmp/s2
@@ -8,7 +8,7 @@
 | description            | varchar(150)          | NO   |     |                     |                             |
 | hostname               | varchar(100)          | YES  | MUL | NULL                |                             |
 | location               | varchar(40)           | YES  |     | NULL                |                             |
-| notes                  | mediumtext            | YES  |     | NULL                |                             |
+| notes                  | text                  | YES  |     | NULL                |                             |
 | external_id            | varchar(40)           | YES  | MUL | NULL                |                             |
 | snmp_community         | varchar(100)          | YES  |     | NULL                |                             |
 | snmp_version           | tinyint(1) unsigned   | NO   |     | 1                   |                             |
@@ -56,8 +56,5 @@
 | failed_polls           | int(12) unsigned      | YES  |     | 0                   |                             |
 | availability           | decimal(8,5)          | NO   |     | 100.00000           |                             |
 | last_updated           | timestamp             | NO   |     | CURRENT_TIMESTAMP   | on update CURRENT_TIMESTAMP |
-| serial_no              | char(20)              | NO   |     |                     |                             |
-| type                   | char(50)              | NO   |     |                     |                             |
-| isPhone                | char(2)               | NO   |     |                     |                             |
 +------------------------+-----------------------+------+-----+---------------------+-----------------------------+
Try running the following to make sure your DB is at the right state:

Code: Select all

sudo -u <website user> php -q cli/upgrade_database.php --forcever=1.1.38

Rno
Cacti User
Posts: 325
Joined: Wed Dec 07, 2011 9:19 am

Re: Add device failed

#10 Post by Rno » Mon Nov 05, 2018 3:30 am

Ok I pass the script, but since it was a brand new install dosen't make sense that much.
but when I look the cacti.sql I saw why 'note' is different:
notes text,

it's a type text not a medium text.

I will try to activate the log on mysql, since so far I have not error what so ever in my log.
Hope t find the right level, and, yes my server 1.2 is a test one, the production is still in 0.8.8.h
CentOS
Production
Cacti 0.8.8h
Spine 0.8.8h
PIA 3.1
Aggregate 0.75
Monitor 1.3
Settings 0.71
Weathermap 0.98
Thold 0.5
rrdclean 0.41

Own plugin: LinkDiscovery 0.3, Map 0.4

Test
Cacti 1.2.1
Spine 1.2.1
thold 1.0.6
monitor 2.3.5
php 7.2.11
mariadb 5.5.56
Own plugin:
ExtendDB 1.1.2
LinkDiscovery 1.2.4
Map 1.2.5

Post Reply