Re: Data not persisting through service restart or reboot (MySQL setup)

Hi,

Your ntopng.conf is missing an equal sign:

	-F="mysql;localhost;ntopng;ntopng;ntopng;mysqlpassword"

The "gibberish output" of MySQL is probably from the "json" field, 
which is compressed. You can the uncompressed output with:

	select UNCOMPRESS(JSON) from flowsv4;

Regards,
Emanuele

On Tue, Dec 5, 2017 at 3:33 AM, Matt B <[email protected]> wrote:
> Hey all,
> 
> Between last night and today, I setup nprobe and ntopng with MySQL.  
> My goal is to be able to look at the busiest hosts over a certain 
> period of time, where traffic went etc.
> 
> It was a real pain getting it going, but it's up, running, and 
> showing me data.  The problem I'm having is that the data doesn't 
> appear to persist through a service restart.
> 
> I've spent hours looking in to this but I appear to have everything 
> correct.
> 
> Server is Ubuntu 16.04 with plenty of horsepower.
> 
> My ntopng.conf (the defaults are there, just commented out):
>> --interface="tcp://127.0.0.1:1234"
>> --http-port=3000
>> --local-networks
>> --community
>> -F "mysql;localhost;ntopng;ntopng;ntopng;mysqlpassword"
> 
> My nprobe.conf:
>> -i=none
>> -n=none
>> -3=2055
>> --zmq="tcp://127.0.0.1:1234"
> 
> By everything I can see, there is not now nor has there been an issue 
> connecting to MySQL, I can get in via the creds above on command line.
> 
> One weird thing that might be the culprit is when I go in to MySQL 
> and I do a `SELECT * from flowsv4`, I get an obscene amount of 
> gibberish output with what seems like useful numbers.  Is my table 
> corrupt somehow?  Any other ideas you all might have as to why I 
> can't retain data?

_______________________________________________
Ntop mailing list
[email protected]
http://listgateway.unipi.it/mailman/listinfo/ntop