Bug in homer-docker

[David Villasmil]

Hello,

while building up homer-docker, I see two problems:

1- run.sh tries to execute the rotating script as "/opt/homer_rotate" which doesn't exists anymore, the correct script is "/opt/homer_mysql_rotate.pl"

2- while it tries to create the webrtc tables i get for both:

DBD::mysql::db do failed: Specified key was too long; max key length is 767 bytes at opt/homer_mysql_rotate.pl line 408.

Failed to execute query [CREATE TABLE IF NOT EXISTS `webrtc_capture_all_20170329` (

  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

  `micro_ts` bigint(18) NOT NULL DEFAULT '0',

  `method` varchar(100) NOT NULL DEFAULT '',

  `caller` varchar(250) NOT NULL DEFAULT '',

  `callee` varchar(250) NOT NULL DEFAULT '',

  `session_id` varchar(256) NOT NULL DEFAULT '',

  `correlation_id` varchar(256) NOT NULL DEFAULT '',

  `source_ip` varchar(60) NOT NULL DEFAULT '',

  `source_port` int(10) NOT NULL DEFAULT 0,

  `destination_ip` varchar(60) NOT NULL DEFAULT '',

  `destination_port` int(10) NOT NULL DEFAULT 0,

  `proto` int(5) NOT NULL DEFAULT 0,

  `family` int(1) DEFAULT NULL,

  `type` int(5) NOT NULL DEFAULT 0,

  `node` varchar(125) NOT NULL DEFAULT '',

  `msg` varchar(3000) NOT NULL DEFAULT '',

  PRIMARY KEY (`id`,`date`),

  KEY `date` (`date`),

  KEY `sessionid` (`session_id`),

  KEY `correlationid` (`correlation_id`)

) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8 COMMENT='20170329'

/*!50100 PARTITION BY RANGE ( UNIX_TIMESTAMP(`date`))

(PARTITION p2017032900 VALUES LESS THAN (1490832000),

PARTITION pmax VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */ ;

I tried reproducing #2 on a different mysql but it doesn't happen... has this happen to anyone else?

I will make a PR to fix these two bugs once i've got them sorted out.

Regards,

David Villasmil

email: david.vill...@gmail.com

phone: +34669448337

ᐧ

[Lorenzo Mangani]

Hi David,

Thanks, this is indeed on the way. The issue should only happen if you pull the latest homer repos, while the Docker containers builders are pinned to specific releases pre-scripts change.

This being said, the current modifications across rotation scripts position/naming surely spans here too so any help to test and rectify is surely MUCH appreciated!

Kind Regards,

Lorenzo Mangani

Managing Director and Core Dev

QXIP BV - Capture Engineering

Amsterdam, The Netherlands

Desk: +31 20 8080468 / +1 202-632-7227

Mobile: +31 6 4603-2730

Email: in...@qxip.net

Find our more about HOMER, PCAPTURE, CAPTAGENT and all our Services and Solutions at http://qxip.net 

CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential or legally privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of this original message. 

--
You received this message because you are subscribed to the Google Groups "Homer Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to homer-dev+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.