Discussion:
[Ntop] Mysql errors
Roberto Alvarado
2017-09-25 04:03:22 UTC
Permalink
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','')



***@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
***@mhost:/var/log#

Log Level Config: Normal

Thanks
Regards
Roberto
Roberto Alvarado
2017-09-25 12:01:57 UTC
Permalink
Hi,

Thanks for the info, but the fix is?

Change the field idx to BIGINT?

And/Or add the mysql parameters to nprobe?

/nprobe ... --mysql=\"localhost:ntopng:nf:root:root\"\n"

Thanks 
regards
Roberto

Sobre 25-09-2017 4:45:11, Simone Mainardi <***@ntop.org> escribió:
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 <***@anycast.cl [mailto:***@anycast.cl]> 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','')



***@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
***@mhost:/var/log#

Log Level Config: Normal

Thanks
Regards
Roberto

Loading...