Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Thu Apr 25, 2019 6:59 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 10 posts ] 
Author Message
 Post subject: Add device failed
PostPosted: Thu Nov 01, 2018 9:56 am 
Offline
Cacti User

Joined: Wed Dec 07, 2011 9:19 am
Posts: 322
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


Top
 Profile  
 
 Post subject: Re: Add device failed
PostPosted: Thu Nov 01, 2018 10:53 am 
Offline
Cacti Guru User

Joined: Sun Aug 27, 2017 12:05 am
Posts: 2414
Are there any error logs?

_________________
Official Cacti Developer

Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation

My resources:
How to submit Pull Requests
Development Wiki and How To's
Updated NetSNMP Memory template for Cacti 1.x
Cisco SFP template for Cacti 0.8.8


Top
 Profile  
 
 Post subject: Re: Add device failed
PostPosted: Fri Nov 02, 2018 1:22 am 
Offline
Cacti User

Joined: Wed Dec 07, 2011 9:19 am
Posts: 322
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


Top
 Profile  
 
 Post subject: Re: Add device failed
PostPosted: Fri Nov 02, 2018 4:09 am 
Offline
Cacti Guru User

Joined: Sun Aug 27, 2017 12:05 am
Posts: 2414
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?

_________________
Official Cacti Developer

Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation

My resources:
How to submit Pull Requests
Development Wiki and How To's
Updated NetSNMP Memory template for Cacti 1.x
Cisco SFP template for Cacti 0.8.8


Top
 Profile  
 
 Post subject: Re: Add device failed
PostPosted: Fri Nov 02, 2018 7:04 am 
Offline
Cacti User

Joined: Wed Dec 07, 2011 9:19 am
Posts: 322
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:
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


Top
 Profile  
 
 Post subject: Re: Add device failed
PostPosted: Fri Nov 02, 2018 8:06 am 
Offline
Cacti Guru User

Joined: Sun Aug 27, 2017 12:05 am
Posts: 2414
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.

_________________
Official Cacti Developer

Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation

My resources:
How to submit Pull Requests
Development Wiki and How To's
Updated NetSNMP Memory template for Cacti 1.x
Cisco SFP template for Cacti 0.8.8


Top
 Profile  
 
 Post subject: Re: Add device failed
PostPosted: Fri Nov 02, 2018 8:14 am 
Offline
Cacti User

Joined: Wed Dec 07, 2011 9:19 am
Posts: 322
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


Top
 Profile  
 
 Post subject: Re: Add device failed
PostPosted: Fri Nov 02, 2018 8:40 am 
Offline
Cacti Guru User

Joined: Sun Aug 27, 2017 12:05 am
Posts: 2414
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?

_________________
Official Cacti Developer

Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation

My resources:
How to submit Pull Requests
Development Wiki and How To's
Updated NetSNMP Memory template for Cacti 1.x
Cisco SFP template for Cacti 0.8.8


Top
 Profile  
 
 Post subject: Re: Add device failed
PostPosted: Fri Nov 02, 2018 8:44 am 
Offline
Cacti Guru User

Joined: Sun Aug 27, 2017 12:05 am
Posts: 2414
I've compared your table to mine in 1.2.0, and the only other difference is this:
Code:
--- 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:
sudo -u <website user> php -q cli/upgrade_database.php --forcever=1.1.38

_________________
Official Cacti Developer

Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation

My resources:
How to submit Pull Requests
Development Wiki and How To's
Updated NetSNMP Memory template for Cacti 1.x
Cisco SFP template for Cacti 0.8.8


Top
 Profile  
 
 Post subject: Re: Add device failed
PostPosted: Mon Nov 05, 2018 3:30 am 
Offline
Cacti User

Joined: Wed Dec 07, 2011 9:19 am
Posts: 322
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


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 10 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 4 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group