Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Netflow in PandoraFMS - No data found
#3
(05-27-2019, 12:44 PM)eduardo.corral Wrote:
(05-24-2019, 03:43 PM)srichards Wrote: Pandora FMS v7.0NG.734 - Build 181105 - MR 9

I'm unable to see any NetFlow data.

I can see that nfcapd is running and nfdump is installed

/var/spool/pandora/data_in/netflow# ls -l --block-size=M
total 1481M

-rw-r----- 1 root apache 131M May 24 16:00 nfcapd.201905241500
-rw-r----- 1 root apache 467M May 24 16:25 nfcapd.201905241600
-rw-r----- 1 root apache  74M May 24 15:34 nfcapd.current.12863
-rw-r----- 1 root apache  37M May 24 15:55 nfcapd.current.15646
-rw-r----- 1 root apache 144M May 24 16:05 nfcapd.current.15917
-rw-r----- 1 root apache  52M May 24 16:07 nfcapd.current.18055
-rw-r----- 1 root apache 458M May 24 16:42 nfcapd.current.18558
-rw-r----- 1 root apache  93M May 24 16:46 nfcapd.current.21559

Good afternoon, srichards

Please do try to change the permissions of the files in /var/spool/pandora/data_in/netflow to: 


Code:
-rw-r--r--


Can you send us please a screenshot of the configuration you have in Setup > Netflow? It would be extremely useful. 

It is important to note too that the MR you have is outdated. To update it, please execute the following command in /var/www/html/pandora_console/extras/mr: 

Code:
for i in `ls | sort -n`; do mysql -u root -ppandora pandora -e "source $i"; done


Kind regards, 

Eduardo.

Hi Eduardo,

Thanks for the fast reply. I've tried running the db updates directly into MYSQL CLI and via Heidi but the MR stays the same at MR 9

I have my output from your script here if it helps?

:/var/www/html/pandora_console/extras/mr# ./simon.ps
ERROR 1064 (42000) at line 1 in file: 'simon.ps': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'for i in `ls | sort -n`' at line 1
ERROR 1064 (42000) at line 1 in file: 'simon.ps': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'root -pXXXXXXXXXXXXXXX pandora -e "source $i"' at line 1
ERROR 1064 (42000) at line 1 in file: 'simon.ps': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'done' at line 1
ERROR at line 1: Can't initialize batch_readline
ERROR 1060 (42S21) at line 3 in file: '1.sql': Duplicate column name 'default_event_filter'
+---+
| 1 |
+---+
| 1 |
+---+
+---+
| 1 |
+---+
| 1 |
+---+
ERROR 1060 (42S21) at line 3 in file: '3.sql': Duplicate column name 'is_password_type'
ERROR 1060 (42S21) at line 3 in file: '4.sql': Duplicate column name 'autorefresh_white_list'
+---+
| 1 |
+---+
| 1 |
+---+
ERROR 1060 (42S21) at line 13 in file: '6.sql': Duplicate column name 'exec_proxy'
ERROR 1060 (42S21) at line 15 in file: '6.sql': Duplicate column name 'server_to_exec'
ERROR 1062 (23000) at line 17 in file: '6.sql': Duplicate entry '8' for key 'PRIMARY'
ERROR 1062 (23000) at line 19 in file: '6.sql': Duplicate entry '25' for key 'PRIMARY'
ERROR 1060 (42S21) at line 3 in file: '7.sql': Duplicate column name 'show_statistics'
ERROR 1060 (42S21) at line 2 in file: '8.sql': Duplicate column name 'time_autorefresh'
ERROR 1060 (42S21) at line 3 in file: '8.sql': Duplicate column name 'lapse_calc'
ERROR 1060 (42S21) at line 4 in file: '8.sql': Duplicate column name 'lapse'
ERROR 1060 (42S21) at line 5 in file: '8.sql': Duplicate column name 'visual_format'
ERROR 1060 (42S21) at line 6 in file: '8.sql': Duplicate column name 'lapse_calc'
ERROR 1060 (42S21) at line 7 in file: '8.sql': Duplicate column name 'lapse'
ERROR 1060 (42S21) at line 8 in file: '8.sql': Duplicate column name 'visual_format'
+---+
| 1 |
+---+
| 1 |
+---+
ERROR 1060 (42S21) at line 13 in file: '9.sql': Duplicate column name 'safe_mode_module'
ERROR 1060 (42S21) at line 14 in file: '9.sql': Duplicate column name 'safe_mode_module'
ERROR 1060 (42S21) at line 16 in file: '9.sql': Duplicate column name 'element_group'
ERROR 1060 (42S21) at line 18 in file: '9.sql': Duplicate column name 'id_layout_linked_weight'
ERROR 1060 (42S21) at line 20 in file: '9.sql': Duplicate column name 'show_on_top'
ERROR 1060 (42S21) at line 22 in file: '9.sql': Duplicate column name 'cells_slideshow'
ERROR 1060 (42S21) at line 3 in file: '10.sql': Duplicate column name 'unified_filters_id'
ERROR 1060 (42S21) at line 4 in file: '10.sql': Duplicate column name 'hide_no_data'
ERROR 1060 (42S21) at line 5 in file: '10.sql': Duplicate column name 'field_order'
ERROR 1060 (42S21) at line 8 in file: '10.sql': Duplicate column name 'summatory_series'
ERROR 1060 (42S21) at line 9 in file: '10.sql': Duplicate column name 'average_series'
ERROR 1060 (42S21) at line 10 in file: '10.sql': Duplicate column name 'modules_series'
ERROR 1060 (42S21) at line 3 in file: '11.sql': Duplicate column name 'is_favourite'
ERROR 1060 (42S21) at line 10 in file: '11.sql': Duplicate column name 'fullscale'
ERROR 1060 (42S21) at line 12 in file: '11.sql': Duplicate column name 'fullscale'
ERROR 1060 (42S21) at line 14 in file: '11.sql': Duplicate column name 'hide_no_data'
ERROR 1060 (42S21) at line 16 in file: '11.sql': Duplicate column name 'last_unknown_update'
ERROR 1060 (42S21) at line 3 in file: '12.sql': Duplicate column name 'type_graph'
ERROR 1060 (42S21) at line 5 in file: '12.sql': Duplicate column name 'clock_animation'
ERROR 1060 (42S21) at line 6 in file: '12.sql': Duplicate column name 'time_format'
ERROR 1060 (42S21) at line 7 in file: '12.sql': Duplicate column name 'timezone'
ERROR 1062 (23000) at line 13 in file: '13.sql': Duplicate entry '100' for key 'PRIMARY'
ERROR 1060 (42S21) at line 40 in file: '14.sql': Duplicate column name 'update_secondary_groups'
ERROR 1060 (42S21) at line 41 in file: '14.sql': Duplicate column name 'update_secondary_groups'
ERROR 1064 (42000) at line 50 in file: '14.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '0' at line 1
ERROR 1243 (HY000) at line 51 in file: '14.sql': Unknown prepared statement handler (pr_oum721) given to EXECUTE
ERROR 1243 (HY000) at line 52 in file: '14.sql': Unknown prepared statement handler (pr_oum721) given to DEALLOCATE PREPARE
ERROR 1025 (HY000) at line 3 in file: '15.sql': Error on rename of './pandora/tcluster' to './pandora/#sql2-1b94-14' (errno: 152)
ERROR 1025 (HY000) at line 5 in file: '15.sql': Error on rename of './pandora/tcluster_agent' to './pandora/#sql2-1b94-14' (errno: 152)
ERROR 1025 (HY000) at line 7 in file: '15.sql': Error on rename of './pandora/tcluster_agent' to './pandora/#sql2-1b94-14' (errno: 152)
ERROR 1060 (42S21) at line 15 in file: '17.sql': Duplicate column name 'custom_fields'
ERROR 1060 (42S21) at line 3 in file: '18.sql': Duplicate column name 'quiet'
ERROR 1060 (42S21) at line 4 in file: '18.sql': Duplicate column name 'cps'
ERROR 1060 (42S21) at line 5 in file: '18.sql': Duplicate column name 'cascade_protection'
ERROR 1060 (42S21) at line 7 in file: '18.sql': Duplicate column name 'cps'
ERROR 1060 (42S21) at line 9 in file: '18.sql': Duplicate column name 'cps'
ERROR 1060 (42S21) at line 11 in file: '18.sql': Duplicate column name 'cps'
ERROR 1060 (42S21) at line 13 in file: '18.sql': Duplicate column name 'evaluate_sla'
ERROR 1060 (42S21) at line 15 in file: '18.sql': Duplicate column name 'cps'
ERROR 1060 (42S21) at line 19 in file: '18.sql': Duplicate column name 'id_node'
ERROR 1060 (42S21) at line 23 in file: '18.sql': Duplicate column name 'data'
ERROR 1060 (42S21) at line 25 in file: '18.sql': Duplicate column name 'data'
ERROR 1060 (42S21) at line 27 in file: '18.sql': Duplicate column name 'data'
ERROR 1060 (42S21) at line 29 in file: '18.sql': Duplicate column name 'module_status'
ERROR 1060 (42S21) at line 31 in file: '18.sql': Duplicate column name 'module_status'
ERROR 1060 (42S21) at line 33 in file: '18.sql': Duplicate column name 'module_status'
ERROR 1050 (42S01) at line 35 in file: '18.sql': Table 'tautoconfig' already exists
ERROR 1050 (42S01) at line 44 in file: '18.sql': Table 'tautoconfig_rules' already exists
ERROR 1050 (42S01) at line 58 in file: '18.sql': Table 'tautoconfig_actions' already exists
ERROR 1060 (42S21) at line 59 in file: '19.sql': Duplicate column name 'no_hierarchy'
ERROR 1060 (42S21) at line 3 in file: '20.sql': Duplicate column name 'recursion'
ERROR 1060 (42S21) at line 5 in file: '20.sql': Duplicate column name 'user_comment'
ERROR 1060 (42S21) at line 6 in file: '20.sql': Duplicate column name 'source'
ERROR 1060 (42S21) at line 7 in file: '20.sql': Duplicate column name 'id_extra'
ERROR 1060 (42S21) at line 12 in file: '20.sql': Duplicate column name 'linked_layout_status_type'
ERROR 1060 (42S21) at line 13 in file: '20.sql': Duplicate column name 'linked_layout_status_as_service_warning'
ERROR 1060 (42S21) at line 14 in file: '20.sql': Duplicate column name 'linked_layout_status_as_service_critical'
ERROR 1060 (42S21) at line 15 in file: '20.sql': Duplicate column name 'linked_layout_node_id'
ERROR 1060 (42S21) at line 16 in file: '20.sql': Duplicate column name 'linked_layout_status_type'
ERROR 1060 (42S21) at line 17 in file: '20.sql': Duplicate column name 'linked_layout_status_as_service_warning'
ERROR 1060 (42S21) at line 18 in file: '20.sql': Duplicate column name 'linked_layout_status_as_service_critical'
ERROR 1060 (42S21) at line 19 in file: '20.sql': Duplicate column name 'linked_layout_node_id'
ERROR 1060 (42S21) at line 25 in file: '20.sql': Duplicate column name 'hidden'
ERROR 1060 (42S21) at line 27 in file: '20.sql': Duplicate column name 'snmp_version'
ERROR 1060 (42S21) at line 28 in file: '20.sql': Duplicate column name 'snmp_auth_user'
ERROR 1060 (42S21) at line 29 in file: '20.sql': Duplicate column name 'snmp_auth_pass'
ERROR 1060 (42S21) at line 30 in file: '20.sql': Duplicate column name 'snmp_auth_method'
ERROR 1060 (42S21) at line 31 in file: '20.sql': Duplicate column name 'snmp_privacy_method'
ERROR 1060 (42S21) at line 32 in file: '20.sql': Duplicate column name 'snmp_privacy_pass'
ERROR 1060 (42S21) at line 33 in file: '20.sql': Duplicate column name 'snmp_security_level'
ERROR 1060 (42S21) at line 34 in file: '20.sql': Duplicate column name 'custom_fields'
ERROR 1062 (23000) at line 45 in file: '20.sql': Duplicate entry '1' for key 'PRIMARY'
ERROR 1060 (42S21) at line 3 in file: '21.sql': Duplicate column name 'is_favourite'
ERROR 1060 (42S21) at line 6 in file: '21.sql': Duplicate column name 'show_last_value'
ERROR 1060 (42S21) at line 7 in file: '21.sql': Duplicate column name 'show_last_value'
ERROR 1060 (42S21) at line 10 in file: '21.sql': Duplicate column name 'meta_dbuser'
ERROR 1060 (42S21) at line 11 in file: '21.sql': Duplicate column name 'meta_dbpass'
ERROR 1060 (42S21) at line 12 in file: '21.sql': Duplicate column name 'meta_dbhost'
ERROR 1060 (42S21) at line 13 in file: '21.sql': Duplicate column name 'meta_dbport'
ERROR 1060 (42S21) at line 14 in file: '21.sql': Duplicate column name 'meta_dbname'
ERROR 1060 (42S21) at line 3 in file: '22.sql': Duplicate column name 'id_group'
ERROR 1091 (42000) at line 5 in file: '22.sql': Can't DROP 'flash_chart'; check that column/key exists
ERROR 1060 (42S21) at line 7 in file: '22.sql': Duplicate column name 'default_custom_view'
ERROR 1060 (42S21) at line 3 in file: '23.sql': Duplicate column name 'group_search'
ERROR 1060 (42S21) at line 5 in file: '23.sql': Duplicate column name 'module_status'
ERROR 1060 (42S21) at line 7 in file: '23.sql': Duplicate column name 'recursion'
ERROR 1060 (42S21) at line 9 in file: '23.sql': Duplicate column name 'group_recursion'
ERROR 1060 (42S21) at line 3 in file: '24.sql': Duplicate column name 'orientation'
ERROR 1060 (42S21) at line 7 in file: '25.sql': Duplicate column name 'wmi_enabled'
ERROR 1060 (42S21) at line 8 in file: '25.sql': Duplicate column name 'auth_strings'
ERROR 1060 (42S21) at line 9 in file: '25.sql': Duplicate column name 'autoconfiguration_enabled'
ERROR 1050 (42S01) at line 25 in file: '25.sql': Table 'tnotification_source' already exists
ERROR 1060 (42S21) at line 50 in file: '25.sql': Duplicate column name 'url'
ERROR 1060 (42S21) at line 51 in file: '25.sql': Duplicate column name 'response_mode'
ERROR 1060 (42S21) at line 52 in file: '25.sql': Duplicate column name 'citicity'
ERROR 1060 (42S21) at line 53 in file: '25.sql': Duplicate column name 'id_source'
ERROR 1060 (42S21) at line 54 in file: '25.sql': Duplicate column name 'subtype'
ERROR 1242 (21000) at line 56 in file: '25.sql': Subquery returns more than 1 row
ERROR 1005 (HY000) at line 57 in file: '25.sql': Can't create table 'pandora.#sql-1b94_1e' (errno: 121)
ERROR 1242 (21000) at line 119 in file: '25.sql': Subquery returns more than 1 row
ERROR 1062 (23000) at line 120 in file: '25.sql': Duplicate entry '2-0' for key 'PRIMARY'
ERROR 1060 (42S21) at line 14 in file: '26.sql': Duplicate column name 'show_extended_events'
ERROR 1060 (42S21) at line 20 in file: '26.sql': Duplicate column name 'combo_values'
ERROR 1060 (42S21) at line 22 in file: '26.sql': Duplicate column name 'summary'
ERROR 1091 (42000) at line 3 in file: '27.sql': Can't DROP 'output'; check that column/key exists
ERROR 1060 (42S21) at line 5 in file: '27.sql': Duplicate column name 'ff_type'
ERROR 1060 (42S21) at line 6 in file: '27.sql': Duplicate column name 'ff_type'
ERROR 1060 (42S21) at line 7 in file: '27.sql': Duplicate column name 'ff_type'
ERROR 1060 (42S21) at line 8 in file: '27.sql': Duplicate column name 'ff_type'
ERROR 1060 (42S21) at line 10 in file: '27.sql': Duplicate column name 'ff_normal'
ERROR 1060 (42S21) at line 11 in file: '27.sql': Duplicate column name 'ff_warning'
ERROR 1060 (42S21) at line 12 in file: '27.sql': Duplicate column name 'ff_critical'
ERROR 1146 (42S02) at line 14 in file: '27.sql': Table 'pandora.tuser_task' doesn't exist
ERROR 1060 (42S21) at line 16 in file: '27.sql': Duplicate column name 'total_time'
ERROR 1060 (42S21) at line 17 in file: '27.sql': Duplicate column name 'time_failed'
ERROR 1060 (42S21) at line 18 in file: '27.sql': Duplicate column name 'time_in_ok_status'
ERROR 1060 (42S21) at line 19 in file: '27.sql': Duplicate column name 'time_in_unknown_status'
ERROR 1060 (42S21) at line 20 in file: '27.sql': Duplicate column name 'time_of_not_initialized_module'
ERROR 1060 (42S21) at line 21 in file: '27.sql': Duplicate column name 'time_of_downtime'
ERROR 1060 (42S21) at line 22 in file: '27.sql': Duplicate column name 'total_checks'
ERROR 1060 (42S21) at line 23 in file: '27.sql': Duplicate column name 'checks_failed'
ERROR 1060 (42S21) at line 24 in file: '27.sql': Duplicate column name 'checks_in_ok_status'
ERROR 1060 (42S21) at line 25 in file: '27.sql': Duplicate column name 'unknown_checks'
ERROR 1060 (42S21) at line 26 in file: '27.sql': Duplicate column name 'agent_max_value'
ERROR 1060 (42S21) at line 27 in file: '27.sql': Duplicate column name 'agent_min_value'
ERROR 1060 (42S21) at line 29 in file: '27.sql': Duplicate column name 'total_time'
ERROR 1060 (42S21) at line 30 in file: '27.sql': Duplicate column name 'time_failed'
ERROR 1060 (42S21) at line 31 in file: '27.sql': Duplicate column name 'time_in_ok_status'
ERROR 1060 (42S21) at line 32 in file: '27.sql': Duplicate column name 'time_in_unknown_status'
ERROR 1060 (42S21) at line 33 in file: '27.sql': Duplicate column name 'time_of_not_initialized_module'
ERROR 1060 (42S21) at line 34 in file: '27.sql': Duplicate column name 'time_of_downtime'
ERROR 1060 (42S21) at line 35 in file: '27.sql': Duplicate column name 'total_checks'
ERROR 1060 (42S21) at line 36 in file: '27.sql': Duplicate column name 'checks_failed'
ERROR 1060 (42S21) at line 37 in file: '27.sql': Duplicate column name 'checks_in_ok_status'
ERROR 1060 (42S21) at line 38 in file: '27.sql': Duplicate column name 'unknown_checks'
ERROR 1060 (42S21) at line 39 in file: '27.sql': Duplicate column name 'agent_max_value'
ERROR 1060 (42S21) at line 40 in file: '27.sql': Duplicate column name 'agent_min_value'
ERROR 1060 (42S21) at line 42 in file: '27.sql': Duplicate column name 'type'
ERROR 1060 (42S21) at line 43 in file: '27.sql': Duplicate column name 'type'
[email protected]:/var/www/html/pandora_console/extras/mr#
 Reply
Messages In This Thread
RE: Netflow in PandoraFMS - No data found - by srichards - 05-28-2019, 08:59 AM


Users browsing this thread: 1 Guest(s)


(c) 2006-2018 Artica Soluciones Tecnológicas. Contents of this wiki are under Create Common Attribution v3 licence. | pandorafms.com | pandorafms.org

Theme © MyBB Themes