zwass
schedule_epoch
in the osquery optionscsanders
06/21/2018, 6:30 PMruben
06/22/2018, 8:04 AMmarpaia
06/22/2018, 3:41 PMAshir
06/23/2018, 12:17 AM2018/06/23 00:05:13 FAIL 20171219164727_UpdateScheduledQueryKey.go (adding foreign key to query_name column: Error 1452: Cannot add or update a child row: a foreign key constraint fails (`kolide`.`#sql-44e8_2b6f7f2`, CONSTRAINT `#sql-44e8_2b6f7f2_ibfk_1` FOREIGN KEY (`query_name`) REFERENCES `queries` (`name`))), quitting migration.
marpaia
06/23/2018, 5:15 PMNchen
06/24/2018, 9:51 AMteoseller
06/25/2018, 2:34 PMTom Frost
06/26/2018, 8:46 AMzwass
fleetctl convert
to convert osquery pack JSON into the fleetctl yaml format. Then you can apply the yaml.darren
07/03/2018, 11:07 AMlvferdi
07/03/2018, 12:41 PMmarpaia
07/06/2018, 4:11 PMgjyoung
07/07/2018, 2:06 PMMustafa
07/09/2018, 8:48 AMdarren
07/12/2018, 1:55 PMryan
07/16/2018, 5:18 AM<http://kolide.co|kolide.co>
Issued by: Let's Encrypt Authority X3
Expired: Sunday, July 15, 2018 at 6:37:26 AM Mountain Daylight Time
Cert is expiredzwass
defensivedepth
07/16/2018, 7:26 PMcen
07/18/2018, 10:13 PMwell. for MariaDB-server-10.1 we get this error @groob
2018/07/18 20:58:55 FAIL 20170306075207_UseUTF8MB.go (alter table file_integrity_monitoring_files: Error 1071: Specified key was too long; max key length is 767 bytes), quitting migration.
did some looking around
found this here
gogs/gogs#4894
Because of mysql 5.6 (includes prior versions) InnoDB max index length is 767 bytes, mysql 5.7.7 is up to 3072 bytes.
If some varchar column's length is 255, when the character format is utf-8 needs 2553=765 bytes for index length, It's OK.
But, an utf8mb needs 2554=1020 bytes for index length.
Solutions:
UPGRADE the mysql to 5.7.7(Mariadb 10.2.2)
Change the utf8mb column length to 191 (191*4=764)
Change the utf8mb to utf8
set innodb_file_format=Barracuda, innodb_large_prefix=on and create table using ROW_FORMAT=DYNAMIC or COMPRESSED (default for 5.7.7)
seems to be the same issue
marpaia
07/19/2018, 7:55 PMgjyoung
07/24/2018, 10:29 PMjrossi
07/25/2018, 5:40 PMjrossi
07/25/2018, 6:52 PMmarpaia
07/25/2018, 7:37 PMgroob
benbass
07/25/2018, 7:51 PMgroob
thatMacAdmin
07/26/2018, 3:08 PMpirxthepilot
07/26/2018, 8:44 PM