Re: Mysql errors
Simone Mainardi <[email protected]>
| Newsgroups | gmane.linux.ntop.general |
|---|---|
| Message-ID | <[email protected]> |
Roberto, yes you can fix it by changing column to BIGINT type Simon > On 25 Sep 2017, at 14:01, Roberto Alvarado <[email protected]> wrote: > > 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 <[email protected]> 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 <[email protected] <mailto:[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] <mailto:[email protected]> >>> http://listgateway.unipi.it/mailman/listinfo/ntop >> > _______________________________________________ > Ntop mailing list > [email protected] > http://listgateway.unipi.it/mailman/listinfo/ntop _______________________________________________ Ntop mailing list [email protected] http://listgateway.unipi.it/mailman/listinfo/ntop