Roberto,

Please, refer to this issue: https://github.com/ntop/ntopng/issues/1387 
<https://github.com/ntop/ntopng/issues/1387>

Simone

> On 25 Sep 2017, at 06:03, Roberto Alvarado <[email protected]> wrote:
> 
> Hi Folks,
> 
> Do you have an idea to fix this kind of errors:
> 
> 
> Sep 25 00:52:01 mhost ntopng: [MySQLDB.cpp:55] ERROR: MySQL error: Out of 
> range value for column 'idx' at row 1 [rc=-1]
> Sep 25 00:52:01 mhost ntopng: [MySQLDB.cpp:56] ERROR: INSERT INTO `flowsv4` 
> (VLAN_ID,L7_PROTO,IP_SRC_ADDR,L4_SRC_PORT,IP_DST_ADDR,L4_DST_PORT,PROTOCOL,IN_BYTES,OUT_BYTES,PACKETS,FIRST_SWITCHED,LAST_SWITCHED,INFO,JSON,NTOPNG_INSTANCE_NAME,INTERFACE_ID,PROFILE)
>  VALUES 
> (‘0’,’91’,’2417852771’,'39889','2327448076','443','6','80','0','2','1506311491','1506311491','',COMPRESS('{
>  "8": "144.29.129.99", "12": "REMOVED", "7": 39889, "11": 443, "4": 6, 
> "57590": 91, "57591": "SSL", "6": 20, "2": 2, "1": 80, "24": 0, "23": 0, 
> "22": 1506311491, "21": 1506311491, "json": { "15": "REMOVED", "10": "24", 
> "14": "18", "5": "72", "16": "26258", "17": "52511", "130": "172.20.0.1" }, 
> "57595": 0.000000, "57596": 0.000000, "SRC_IP_COUNTRY": "US", 
> "SRC_IP_LOCATION": [ -83.376297, 42.464500 ], "DST_IP_COUNTRY": "CL", 
> "DST_IP_LOCATION": [ -70.400002, -23.650000 ], "NTOPNG_INSTANCE_NAME": 
> "REMOVED", "INTERFACE": "tcp:\/\/127.0.0.1:5556" }'), 'REMOVED', '0','')
> Sep 25 00:52:01 mhost ntopng: [MySQLDB.cpp:55] ERROR: MySQL error: Out of 
> range value for column 'idx' at row 1 [rc=-1]
> Sep 25 00:52:01 mhost ntopng: [MySQLDB.cpp:56] ERROR: INSERT INTO `flowsv4` 
> (VLAN_ID,L7_PROTO,IP_SRC_ADDR,L4_SRC_PORT,IP_DST_ADDR,L4_DST_PORT,PROTOCOL,IN_BYTES,OUT_BYTES,PACKETS,FIRST_SWITCHED,LAST_SWITCHED,INFO,JSON,NTOPNG_INSTANCE_NAME,INTERFACE_ID,PROFILE)
>  VALUES 
> (‘0’,’0’,'2327448016','11211','3638218325','36721','6','136','0','2','1506311491','1506311491','',COMPRESS('{
>  "8": "REMOVED", "12": "216.218.206.85", "7": 11211, "11": 36721, "4": 6, 
> "6": 49, "2": 2, "1": 136, "24": 0, "23": 0, "22": 1506311491, "21": 
> 1506311491, "json": { "15": "192.168.67.185", "10": "0", "14": "24", "5": 
> "192", "16": "52511", "17": "6939", "130": "172.20.0.1" }, "57595": 0.000000, 
> "57596": 0.000000, "SRC_IP_COUNTRY": "CL", "SRC_IP_LOCATION": [ -70.400002, 
> -23.650000 ], "DST_IP_COUNTRY": "US", "DST_IP_LOCATION": [ -121.962097, 
> 37.549702 ], "NTOPNG_INSTANCE_NAME": "REMOVED", "INTERFACE": 
> "tcp:\/\/127.0.0.1:5556" }'), 'REMOVED', '0','')
> 
> 
> 
> root@mhost:/var/log# ntopng -V
> v.3.1.170925    [Enterprise/Professional build]
> GIT rev:        dev:462e6aa0725d3e25aec5264554736bc7a933dbbf:20170925
> Pro rev:        r1172
> Built on:       Debian GNU/Linux 8.2 (jessie)
> System Id:      REMOVED
> Platform:       x86_64
> Edition:        Professional
> License Type:   Permanent
> Maintenance:    Until Thu Mar 22 12:28:01 2018 [178 days left]
> License:        REMOVED
> root@mhost:/var/log# 
> 
> Log Level Config: Normal
> 
> Thanks
> Regards
> Roberto
> _______________________________________________
> Ntop mailing list
> [email protected]
> http://listgateway.unipi.it/mailman/listinfo/ntop

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

Reply via email to