Advanced
Mailing List Archive

Mailing List Archive

  1. Home >
  2. NTop>
  3. Users
Mysql errors
ralvarado at anycast
Sep 24, 2017, 9:03 PM
Post #1 of 4 (607 views)
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','')



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
Ntop@listgateway.unipi.it
http://listgateway.unipi.it/mailman/listinfo/ntop
Re: Mysql errors [ In reply to ]
mainardi at ntop
Sep 25, 2017, 12:45 AM
Post #2 of 4 (605 views)
Permalink
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 <ralvarado@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','')
>
>
>
> 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
> Ntop@listgateway.unipi.it
> http://listgateway.unipi.it/mailman/listinfo/ntop
Re: Mysql errors [ In reply to ]
ralvarado at anycast
Sep 25, 2017, 5:01 AM
Post #3 of 4 (604 views)
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 <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 <ralvarado@anycast.cl [mailto:ralvarado@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','')



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
Ntop@listgateway.unipi.it [mailto:Ntop@listgateway.unipi.it]
http://listgateway.unipi.it/mailman/listinfo/ntop
Re: Mysql errors [ In reply to ]
mainardi at ntop
Sep 26, 2017, 6:42 AM
Post #4 of 4 (597 views)
Permalink
Roberto, yes you can fix it by changing column to BIGINT type

Simon

> On 25 Sep 2017, at 14:01, Roberto Alvarado <ralvarado@anycast.cl> 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 <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 <ralvarado@anycast.cl <mailto:ralvarado@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','')
>>>
>>>
>>>
>>> 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
>>> Ntop@listgateway.unipi.it <mailto:Ntop@listgateway.unipi.it>
>>> http://listgateway.unipi.it/mailman/listinfo/ntop
>>
> _______________________________________________
> Ntop mailing list
> Ntop@listgateway.unipi.it
> http://listgateway.unipi.it/mailman/listinfo/ntop

©2024 GT.net. A Gossamer Threads company.
5th Floor, 455 Granville St., Vancouver, BC V6C 1T1, Canada | Legal