The pfSense Store

Author Topic: ntopng compiled with sqlite?  (Read 1031 times)

0 Members and 1 Guest are viewing this topic.

Offline brainloss

  • Newbie
  • *
  • Posts: 11
  • Karma: +0/-0
    • View Profile
ntopng compiled with sqlite?
« on: October 01, 2014, 04:48:04 am »
Hello,

I spend hours trying to make ntop work (fail!) but found ntopng!  Awesome.

I would like to enable logging data to disk, but the option requires sqlite.
I see I could modifiy /usr/local/etc/rc.d/ntopng.sh to add the '-F'

--dump-flows | -F
Dump expired flows. If ntopng is compiled with sqlite support, flows
can dumped persistently on disk using this option. Databases are
created daily under <data directory>/<interface>db.


Question:   Has the ntopng addon for pfsense been compiled with sqlite support?   Or any suggestions how this dump to disk feature could be enabled
(This is test lab environment)


Thanks,
Paul

Offline jimp

  • Administrator
  • Hero Member
  • *****
  • Posts: 16767
  • Karma: +398/-2
    • View Profile
Re: ntopng compiled with sqlite?
« Reply #1 on: October 07, 2014, 12:32:37 pm »
Yes, it has.

The FreeBSD port lists sqlite in the ntopng port's Makefile, and it's not a selectable option so it's always on, so it should have that support included.
Need help fast? Commercial Support!

Co-Author of pfSense: The Definitive Guide. - Check the Doc Wiki for FAQs.

Do not PM for help!

Offline mohamed hafez

  • Newbie
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Re: ntopng compiled with sqlite?
« Reply #2 on: October 22, 2014, 02:50:28 pm »
to be able to save data to disk you should first specify the directory with write permission but before that we should have a user to run the service because by default the service runs with user "nobody".

there are a lot of options that are not available on the web GUI need to be added and configured.

Offline bc4gdi

  • Newbie
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Re: ntopng compiled with sqlite?
« Reply #3 on: December 18, 2014, 01:08:37 pm »
Were you ever able to sort out getting ntopng to keep historical data? If so, would you mind sharing your method and it's result?

Thanks,
Ben

Offline brainloss

  • Newbie
  • *
  • Posts: 11
  • Karma: +0/-0
    • View Profile
Re: ntopng compiled with sqlite?
« Reply #4 on: February 28, 2015, 09:08:15 am »
On 2.2 its seems I see the option tic box for historical data.... and...  its seems to work!   Awesome
Thank you so much for including this option on the GUI

Offline killmasta93

  • Full Member
  • ***
  • Posts: 152
  • Karma: +4/-0
    • View Profile
Re: ntopng compiled with sqlite?
« Reply #5 on: April 25, 2015, 01:36:08 pm »
in what directory does ntopng store the information? I tried looking in /usr/pbi/ntopng-i386 but nothing :(