{"action":"created","issue":{"url":"https://api.github.com/repos/ntop/ntopng/issues/1225","repository_url":"https://api.github.com/repos/ntop/ntopng","labels_url":"https://api.github.com/repos/ntop/ntopng/issues/1225/labels{/name}","comments_url":"https://api.github.com/repos/ntop/ntopng/issues/1225/comments","events_url":"https://api.github.com/repos/ntop/ntopng/issues/1225/events","html_url":"https://github.com/ntop/ntopng/issues/1225","id":227463215,"number":1225,"title":"MySQL dump","user":{"login":"ayeshabasit","id":23487380,"avatar_url":"https://avatars2.githubusercontent.com/u/23487380?v=3","gravatar_id":"","url":"https://api.github.com/users/ayeshabasit","html_url":"https://github.com/ayeshabasit","followers_url":"https://api.github.com/users/ayeshabasit/followers","following_url":"https://api.github.com/users/ayeshabasit/following{/other_user}","gists_url":"https://api.github.com/users/ayeshabasit/gists{/gist_id}","starred_url":"https://api.github.com/users/ayeshabasit/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ayeshabasit/subscriptions","organizations_url":"https://api.github.com/users/ayeshabasit/orgs","repos_url":"https://api.github.com/users/ayeshabasit/repos","events_url":"https://api.github.com/users/ayeshabasit/events{/privacy}","received_events_url":"https://api.github.com/users/ayeshabasit/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":20,"created_at":"2017-05-09T18:53:49Z","updated_at":"2017-05-10T20:52:58Z","closed_at":null,"body":"After connecting mySQl to the interfaces successfully, the commandline output stops.\r\n\r\nI want to start logging data asap, but I've been stuck here for a while with both elasticsearch and mysql.\r\n\r\n09/May/2017 23:48:00 [Ntop.cpp:1121] Setting local networks to 127.0.0.0/8\r\n09/May/2017 23:48:00 [Redis.cpp:92] Successfully connected to redis 127.0.0.1:63                                                                             79@0\r\n09/May/2017 23:48:00 [NtopPro.cpp:120] [LICENSE] Reading license from /etc/ntopn                                                                             g.license\r\n09/May/2017 23:48:00 [MySQLDB.cpp:549] Attempting to connect to MySQL for interf                                                                             ace dummy...\r\n09/May/2017 23:48:00 [MySQLDB.cpp:589] Succesfully connected to MySQL [:] for in                                                                             terface dummy\r\n09/May/2017 23:48:02 [MySQLDB.cpp:549] Attempting to connect to MySQL for interf                                                                             ace eth0...\r\n09/May/2017 23:48:02 [MySQLDB.cpp:589] Succesfully connected to MySQL [:] for in                                                                             terface eth0\r\n09/May/2017 23:48:02 [PF_RINGInterface.cpp:53] Reading packets from PF_RING v.6.                                                                             4.1 interface eth0...\r\n09/May/2017 23:48:02 [Ntop.cpp:1267] Registered interface eth0 [id: 0]\r\n09/May/2017 23:48:02 [MySQLDB.cpp:549] Attempting to connect to MySQL for interf                                                                             ace lo...\r\n09/May/2017 23:48:02 [MySQLDB.cpp:589] Succesfully connected to MySQL [:] for in                                                                             terface lo\r\n09/May/2017 23:48:02 [MySQLDB.cpp:549] Attempting to connect to MySQL for interf                                                                             ace lo...\r\n09/May/2017 23:48:02 [MySQLDB.cpp:589] Succesfully connected to MySQL [:] for in                                                                             terface lo\r\n09/May/2017 23:48:02 [PcapInterface.cpp:85] Reading packets from interface lo...\r\n09/May/2017 23:48:02 [Ntop.cpp:1267] Registered interface lo [id: 2]\r\n09/May/2017 23:48:02 [MySQLDB.cpp:549] Attempting to connect to MySQL for interf                                                                             ace premiumcolo...\r\n09/May/2017 23:48:02 [MySQLDB.cpp:589] Succesfully connected to MySQL [:] for in                                                                             terface premiumcolo\r\n09/May/2017 23:48:02 [MySQLDB.cpp:549] Attempting to connect to MySQL for interf                                                                             ace premiumcolo...\r\n09/May/2017 23:48:02 [MySQLDB.cpp:589] Succesfully connected to MySQL [:] for in                                                                             terface premiumcolo\r\n09/May/2017 23:48:02 [PcapInterface.cpp:85] Reading packets from interface premi                                                                             umcolo...\r\n09/May/2017 23:48:02 [Ntop.cpp:1267] Registered interface premiumcolo [id: 8]\r\n09/May/2017 23:48:02 [Ntop.cpp:1279] Registered interface view eth0 [id: 0]\r\n09/May/2017 23:48:02 [Ntop.cpp:1279] Registered interface view lo [id: 2]\r\n09/May/2017 23:48:02 [Ntop.cpp:1279] Registered interface view premiumcolo [id:                                                                              8]\r\n09/May/2017 23:48:02 [main.cpp:255] PID stored in file /var/run/ntopng.pid\r\n09/May/2017 23:48:02 [Utils.cpp:341] User changed to nobody\r\n09/May/2017 23:48:02 [HTTPserver.cpp:501] Please read https://github.com/ntop/nt                                                                             opng/blob/dev/doc/README.SSL if you want to enable SSL.\r\n09/May/2017 23:48:02 [HTTPserver.cpp:544] Web server dirs [/usr/share/ntopng/htt                                                                             pdocs][/usr/share/ntopng/scripts]\r\n09/May/2017 23:48:02 [HTTPserver.cpp:547] HTTP server listening on port 3000\r\n09/May/2017 23:48:02 [MySQLDB.cpp:549] Attempting to connect to MySQL for interf                                                                             ace eth0...\r\n09/May/2017 23:48:02 [MySQLDB.cpp:589] Succesfully connected to MySQL [:] for in                                                                             terface eth0\r\n09/May/2017 23:48:02 [main.cpp:309] Working directory: /var/tmp/ntopng\r\n09/May/2017 23:48:02 [main.cpp:311] Scripts/HTML pages directory: /usr/share/nto                                                                             png\r\n09/May/2017 23:48:02 [Ntop.cpp:271] Welcome to ntopng x86_64 v.2.4.170202 - (C)                                                                              1998-2016 ntop.org\r\n09/May/2017 23:48:02 [Ntop.cpp:276] Built on CentOS release 6.8 (Final)\r\n09/May/2017 23:48:02 [PeriodicActivities.cpp:53] Started periodic activities loo                                                                             p...\r\n09/May/2017 23:48:02 [RuntimePrefs.cpp:34] Dumping alerts into syslog\r\n09/May/2017 23:48:02 [NtopPro.cpp:259] [LICENSE] ntopng systemId: 2933E22211B1B8                                                                             A9\r\n09/May/2017 23:48:02 [NtopPro.cpp:270] [LICENSE] ntopng license: 395D6CED2670FF9                                                                             99C75CD1B13BDBC121496823289F70883CB\r\n09/May/2017 23:48:02 [NtopPro.cpp:291] [LICENSE] Maintenance is available until                                                                              Wed Jun  7 13:14:49 2017 [28 days left]\r\n09/May/2017 23:48:02 [Ntop.cpp:531] Adding 127.0.0.0/8 as IPv4 local network for                                                                              lo\r\n09/May/2017 23:48:02 [Ntop.cpp:531] Adding 203.128.7.0/24 as IPv4 local network                                                                              for eth0\r\n09/May/2017 23:48:02 [Ntop.cpp:531] Adding 192.168.251.24/30 as IPv4 local netwo                                                                             rk for premiumcolo\r\n09/May/2017 23:48:02 [Ntop.cpp:561] Adding ::1/128 as IPv6 local network for lo\r\n09/May/2017 23:48:02 [Ntop.cpp:561] Adding fe80::215:17ff:fe30:dc20/64 as IPv6 l                                                                             ocal network for eth0\r\n09/May/2017 23:48:02 [NetworkInterface.cpp:1538] Started packet polling on inter                                                                             face eth0 [id: 0]...\r\n09/May/2017 23:48:02 [NetworkInterface.cpp:1538] Started packet polling on inter                                                                             face lo [id: 2]...\r\n09/May/2017 23:48:02 [NetworkInterface.cpp:1538] Started packet polling on inter                                                                             face premiumcolo [id: 8]...\r\n09/May/2017 23:48:03 [MySQLDB.cpp:549] Attempting to connect to MySQL for interf                                                                             ace premiumcolo...\r\n09/May/2017 23:48:03 [MySQLDB.cpp:549] Attempting to connect to MySQL for interf                                                                             ace eth0...\r\n09/May/2017 23:48:03 [MySQLDB.cpp:549] Attempting to connect to MySQL for interf                                                                             ace lo...\r\n09/May/2017 23:48:03 [MySQLDB.cpp:589] Succesfully connected to MySQL [:] for in                                                                             terface premiumcolo\r\n09/May/2017 23:48:03 [MySQLDB.cpp:589] Succesfully connected to MySQL [:] for in                                                                             terface eth0\r\n09/May/2017 23:48:03 [MySQLDB.cpp:589] Succesfully connected to MySQL [:] for in                                                                             terface lo\r\nNOTHING AFTER THIS"},"comment":{"url":"https://api.github.com/repos/ntop/ntopng/issues/comments/300609023","html_url":"https://github.com/ntop/ntopng/issues/1225#issuecomment-300609023","issue_url":"https://api.github.com/repos/ntop/ntopng/issues/1225","id":300609023,"user":{"login":"simonemainardi","id":3397663,"avatar_url":"https://avatars3.githubusercontent.com/u/3397663?v=3","gravatar_id":"","url":"https://api.github.com/users/simonemainardi","html_url":"https://github.com/simonemainardi","followers_url":"https://api.github.com/users/simonemainardi/followers","following_url":"https://api.github.com/users/simonemainardi/following{/other_user}","gists_url":"https://api.github.com/users/simonemainardi/gists{/gist_id}","starred_url":"https://api.github.com/users/simonemainardi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/simonemainardi/subscriptions","organizations_url":"https://api.github.com/users/simonemainardi/orgs","repos_url":"https://api.github.com/users/simonemainardi/repos","events_url":"https://api.github.com/users/simonemainardi/events{/privacy}","received_events_url":"https://api.github.com/users/simonemainardi/received_events","type":"User","site_admin":false},"created_at":"2017-05-10T20:52:58Z","updated_at":"2017-05-10T20:52:58Z","body":"See the help for the usage of option -w\r\n\r\n```\r\n[--http-port|-w] <[addr:]port>      | HTTP. Set to 0 to disable http server.\r\n                                    | Addr can be any valid ipv4 (e.g., 192.168.1.1)\r\n                                    | or ipv6 (e.g., [3ffe:2a00:100:7031::1]) address.\r\n                                    | Surround ipv6 addresses with square brackets.\r\n                                    | Prepend a ':' without addr before the port\r\n                                    | to listen on the loopback address.\r\n                                    | Default port: 3000\r\n                                    | Examples:\r\n                                    | -w :3000\r\n                                    | -w 192.168.1.1:3001\r\n                                    | -w [3ffe:2a00:100:7031::1]:3002\r\n```\r\n\r\n\r\n-----\r\n\r\nIf you see flows in the historical data explorer it means that the db is populated. Remember that flows are only exported when they are expired so this can take a few minutes."}}
{"actor":{"display_login":"simonemainardi"}}