search

kolide / kolide-quickstart

[DEPRECATED] A quickstart demo for Kolide tools
https://kolide.com
MIT License
52 stars 19 forks source link

fail to load on mac over docker #33

Closed nigifabio closed 7 years ago

nigifabio commented 7 years ago

2017-04-07 17:43:35 ⌚ FNIGI-M-Q01R in ~/dev/kolide-quickstart ± |master ✓| → ./demo.sh up simple #########blablakety####r3flE0A Using default tag: latest latest: Pulling from kolide/kolide 709515475419: Pull complete a3ed95caeb02: Pull complete 4d5debf068cf: Pull complete c82e57e701cd: Pull complete Digest: sha256:c154e71826c4f4f876a1c618ff995232a6b004c0baf8f827106b8d51dde3f266 Status: Downloaded newer image for kolide/kolide:latest Using default tag: latest latest: Pulling from kolide/openssl b7f33cc0b48e: Pull complete d952d1e7feba: Pull complete Digest: sha256:9d86215afdd5d76faae9de32b7be862a64542ff7ddcc753c43b34118f42aead8 Status: Downloaded newer image for kolide/openssl:latest Generating RSA private key, 2048 bit long modulus .........................................+++ .....................+++ e is 65537 (0x10001) writing RSA key Signature ok subject=/CN=kolide Getting Private key Creating network "kolidequickstart_default" with the default driver Pulling redis (redis:3.2.4)... 3.2.4: Pulling from library/redis 43c265008fae: Pull complete 2738f760012a: Pull complete a3b2771d56b8: Pull complete 5d98f21a4432: Pull complete eebb159250d6: Pull complete 723650aaa26f: Pull complete a7712c26a3f2: Pull complete Digest: sha256:5af2446f774075f2b5bc14738368dc111c357c2a11dd304a90b098e27ff1a50e Status: Downloaded newer image for redis:3.2.4 Pulling mailhog (mailhog/mailhog:latest)... latest: Pulling from mailhog/mailhog b7f33cc0b48e: Already exists b17e1dd5b935: Pull complete fa5b96f79f47: Pull complete 1a3f7f919f7e: Pull complete Digest: sha256:618b44697cf947cc03decfee05883fd1ae67b277c9e07a5c9f3f3421eacfaf89 Status: Downloaded newer image for mailhog/mailhog:latest Pulling mysql (mysql:5.7)... 5.7: Pulling from library/mysql 6d827a3ef358: Pull complete ed0929eb7dfe: Pull complete 03f348dc3b9d: Pull complete fd337761ca76: Pull complete 7e6cc16d464a: Pull complete ca3d380bc018: Pull complete 3fe11378d5c0: Pull complete 2b5dfd325645: Pull complete b54281d17fbe: Pull complete 7eae4db8eea5: Pull complete 76cf68e17b09: Pull complete Digest: sha256:49b7d6d8d45f8c3300cba056e8cdf36c714d99e0b40f7005b9e6e75e64ecdf7c Status: Downloaded newer image for mysql:5.7 Creating kolidequickstart_mailhog_1 Creating kolidequickstart_redis_1 Creating kolidequickstart_mysql_1 Creating kolidequickstart_kolide_1 Waiting for MySQL to accept connections...\c

Waiting for Kolide server to accept connections...\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c Error: Kolide failed to start up. Exiting.

groob commented 7 years ago

The issue you're seeing is happening because the kolide container is failing to connect to the mysql one. We've noticed over time that Docker for Mac can sometimes fail network connections between macs. (see https://github.com/docker/for-mac/issues/1374 for example)

I recommend running docker rm -f $(docker ps -a -q) (which will remove all containers you have running on your mac, if you wan to preserve some you can just remove the kolide ones) then restart the docker daemon and try again.

nigifabio commented 7 years ago

thanks Groob, is now working

ashvinashoke commented 7 years ago

I'm having the same issue that nigifabio had but it persists after removing all containers and restarting Docker.

zwass commented 7 years ago

@ashvinashoke are you running the latest version of kolide-quickstart?

ashvinashoke commented 7 years ago

@zwass Yes I am.

ashvinashoke commented 7 years ago

@zwass In the demo.sh file, does the server address need to be set to 127.0.0.1 if I'm trying to run Kolide locally?

zwass commented 7 years ago

No, you should be able to run it just by following the instructions. Can you paste the error you are seeing?

zwass commented 7 years ago

Can you please provide the full output of the command? And the results of docker-compose ps?

ashvinashoke commented 7 years ago

./demo.sh up simple <my license string>

Using default tag: latest latest: Pulling from kolide/kolide 52a8f959a09a: Already exists a3ed95caeb02: Already exists 13b5209e6196: Already exists 9005727a1eab: Already exists Digest: sha256:956d4bf9c11c88f75ad92df9375a0285948aaf42950180d8f8501edbf835548a Status: Image is up to date for kolide/kolide:latest Using default tag: latest latest: Pulling from kolide/openssl Digest: sha256:9d86215afdd5d76faae9de32b7be862a64542ff7ddcc753c43b34118f42aead8 Status: Image is up to date for kolide/openssl:latest kolidequickstart_mailhog_1 is up-to-date kolidequickstart_redis_1 is up-to-date kolidequickstart_mysql_1 is up-to-date Starting kolidequickstart_kolide_1 ... Starting kolidequickstart_kolide_1 ... done Waiting for MySQL to accept connections... Waiting for Kolide server to accept connections.....................................................Error: Kolide failed to start up. Exiting. ashvin-ashoke-mbpr15:kolide-quickstart ashvinashoke$

docker-compose ps WARNING: The KOLIDE_HOST_HOSTNAME variable is not set. Defaulting to a blank string. WARNING: The KOLIDE_HOST_IP variable is not set. Defaulting to a blank string. Name Command State Ports

kolidequickstart_kolide_1 sh -c echo '\n' | ./kolide ... Exit 1
kolidequickstart_mailhog_1 MailHog Up 1025/tcp, 0.0.0.0:8025->8025/tcp kolidequickstart_mysql_1 docker-entrypoint.sh mysql ... Up 3306/tcp
kolidequickstart_redis_1 docker-entrypoint.sh redis ... Up 6379/tcp

zwass commented 7 years ago

Are you replacing <my license string> with the license string from your https://kolide.com/ account?

ashvinashoke commented 7 years ago

Yes

zwass commented 7 years ago

I just tried starting again from scratch and it works for me. I know this is silly, but have you restarted your computer? Can you post the output of docker-compose logs?

ashvinashoke commented 7 years ago

Yeah I've tried restarting. Here's the output:

WARNING: The KOLIDE_HOST_HOSTNAME variable is not set. Defaulting to a blank string. WARNING: The KOLIDE_HOST_IP variable is not set. Defaulting to a blank string. Attaching to kolidequickstart_kolide_1, kolidequickstart_redis_1, kolidequickstart_mysql_1, kolidequickstart_mailhog_1 redis_1 | 1:C 11 Jul 23:38:46.424 # Warning: no config file specified, using the default config. In order to specify a config file use redis-server /path/to/redis.conf redis1 | ._
redis1 | .-__ ''-._ redis_1 | _.- .. ''-. Redis 3.2.4 (00000000/0) 64 bit redis1 | .-`` .-.\/ ., ''-.
mysql_1 | 2017-07-11T23:38:46.984157Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). redis_1 | ( ' , .-|, ) Running in standalone mode kolide_1 | Using config file: /tmp/kolide.yml mysql_1 | 2017-07-11T23:38:46.988567Z 0 [Note] mysqld (mysqld 5.7.18) starting as process 1 ... redis1 | |`-.-...- ...-.`-._|' _.-'| Port: 6379 kolide_1 | Migrations already completed. Nothing to do. mysql_1 | 2017-07-11T23:38:46.992293Z 0 [Warning] Setting lower_case_table_names=2 because file system for /tmp/mysqldata/ is case insensitive redis1 | | `-. ._ / _.-' | PID: 1 kolide_1 | Using config file: /tmp/kolide.yml mysql_1 | 2017-07-11T23:38:46.994188Z 0 [Note] InnoDB: PUNCH HOLE support available redis_1 |-. `-. -./ _.-' _.-' kolide_1 | ################################################################################ mysql_1 | 2017-07-11T23:38:46.994233Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins redis_1 | |-.`-. `-..-' .-'.-'|
kolide_1 | # ERROR: mysql_1 | 2017-07-11T23:38:46.994238Z 0 [Note] InnoDB: Uses event mutexes redis1 | | `-.-._ _.-'_.-' | http://redis.io kolide_1 | # A value must be supplied for --auth_jwt_key. This value is used to create mysql_1 | 2017-07-11T23:38:46.994240Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier kolide_1 | # session tokens for users. redis_1 |-. `-.-.__.-'_.-' _.-' mysql_1 | 2017-07-11T23:38:46.994242Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 kolide_1 | # mailhog_1 | [HTTP] Binding to address: 0.0.0.0:8025 redis_1 | |-.`-. -.__.-' _.-'_.-'| mysql_1 | 2017-07-11T23:38:46.994245Z 0 [Note] InnoDB: Using Linux native AIO kolide_1 | # Consider using the following randomly generated key: mailhog_1 | Creating API v1 with WebPath: redis_1 | |-.`-. .-'.-' |
mysql_1 | 2017-07-11T23:38:46.994595Z 0 [Note] InnoDB: Number of pools: 1 kolide_1 | # xNLJS/uZ1KX2sW/LAbHWmBpa7efbHZka mailhog_1 | Creating API v2 with WebPath: redis1 | `-. -._-..-'.-' .-'
mysql_1 | 2017-07-11T23:38:46.994715Z 0 [Note] InnoDB: Using CPU crc32 instructions kolide_1 | ################################################################################ mailhog_1 | 2017/07/11 23:38:46 Using in-memory storage redis1 | `-. -.__.-' _.-' mysql_1 | 2017-07-11T23:38:47.002650Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M kolide_1 | Using config file: /tmp/kolide.yml mailhog_1 | 2017/07/11 23:38:46 [SMTP] Binding to address: 0.0.0.0:1025 redis_1 |-. .-'
mysql_1 | 2017-07-11T23:38:47.008301Z 0 [Note] InnoDB: Completed initialization of buffer pool kolide_1 | Migrations already completed. Nothing to do. mailhog_1 | 2017/07/11 23:38:46 Serving under http://0.0.0.0:8025/ redis_1 | `-..-'
mysql_1 | 2017-07-11T23:38:47.011308Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). kolide_1 | Using config file: /tmp/kolide.yml mailhog_1 | [APIv1] KEEPALIVE /api/v1/events redis_1 | mysql_1 | 2017-07-11T23:38:47.041951Z 0 [Note] InnoDB: Highest supported file format is Barracuda. kolide_1 | ################################################################################ mailhog_1 | [APIv1] KEEPALIVE /api/v1/events redis_1 | 1:M 11 Jul 23:38:46.425 # WARNING: The TCP backlog setting of 511 cannot be enforced because /proc/sys/net/core/somaxconn is set to the lower value of 128. mysql_1 | 2017-07-11T23:38:47.051539Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 13898535 kolide_1 | # ERROR: mailhog_1 | [APIv1] KEEPALIVE /api/v1/events redis_1 | 1:M 11 Jul 23:38:46.425 # Server started, Redis version 3.2.4 mysql_1 | 2017-07-11T23:38:47.051575Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 13898544 kolide_1 | # A value must be supplied for --auth_jwt_key. This value is used to create mailhog_1 | [APIv1] KEEPALIVE /api/v1/events redis_1 | 1:M 11 Jul 23:38:46.425 # WARNING you have Transparent Huge Pages (THP) support enabled in your kernel. This will create latency and memory usage issues with Redis. To fix this issue run the command 'echo never > /sys/kernel/mm/transparent_hugepage/enabled' as root, and add it to your /etc/rc.local in order to retain the setting after a reboot. Redis must be restarted after THP is disabled. mysql_1 | 2017-07-11T23:38:47.051927Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 13898544 kolide_1 | # session tokens for users. mailhog_1 | [APIv1] KEEPALIVE /api/v1/events redis_1 | 1:M 11 Jul 23:38:46.425 The server is now ready to accept connections on port 6379 mysql_1 | 2017-07-11T23:38:47.051947Z 0 [Note] InnoDB: Database was not shutdown normally! kolide_1 | # mailhog_1 | [APIv1] KEEPALIVE /api/v1/events redis_1 | 1:signal-handler (1499876066) Received SIGTERM scheduling shutdown... mysql_1 | 2017-07-11T23:38:47.051950Z 0 [Note] InnoDB: Starting crash recovery. kolide_1 | # Consider using the following randomly generated key: mailhog_1 | [APIv1] KEEPALIVE /api/v1/events redis_1 | 1:M 12 Jul 16:14:26.193 # User requested shutdown... mysql_1 | 2017-07-11T23:38:48.296277Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" kolide_1 | # htYIUS68s3mQifw24yoo/zVKn+MqXih4 mailhog_1 | [APIv1] KEEPALIVE /api/v1/events redis_1 | 1:M 12 Jul 16:14:26.194 Saving the final RDB snapshot before exiting. mysql_1 | 2017-07-11T23:38:48.296313Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables kolide_1 | ################################################################################ mailhog_1 | [APIv1] KEEPALIVE /api/v1/events redis_1 | 1:M 12 Jul 16:14:26.196 DB saved on disk mysql_1 | 2017-07-11T23:38:48.297173Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... kolide_1 | Using config file: /tmp/kolide.yml mailhog_1 | [APIv1] KEEPALIVE /api/v1/events redis_1 | 1:M 12 Jul 16:14:26.196 # Redis is now ready to exit, bye bye... mysql_1 | 2017-07-11T23:38:48.357702Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. kolide_1 | Migrations already completed. Nothing to do. mailhog_1 | [APIv1] KEEPALIVE /api/v1/events redis_1 | 1:C 12 Jul 16:50:59.819 # Warning: no config file specified, using the default config. In order to specify a config file use redis-server /path/to/redis.conf mysql_1 | 2017-07-11T23:38:48.377849Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. kolide_1 | Using config file: /tmp/kolide.yml mailhog_1 | [APIv1] KEEPALIVE /api/v1/events redis1 | ._
mysql_1 | 2017-07-11T23:38:48.377900Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. kolide_1 | ################################################################################ mailhog_1 | [APIv1] KEEPALIVE /api/v1/events redis1 | .-__ ''-._ mysql_1 | 2017-07-11T23:38:48.378270Z 0 [Note] InnoDB: Waiting for purge to start kolide_1 | # ERROR: mailhog_1 | [APIv1] KEEPALIVE /api/v1/events redis_1 | _.- .. ''-. Redis 3.2.4 (00000000/0) 64 bit mysql_1 | 2017-07-11T23:38:48.428590Z 0 [Note] InnoDB: 5.7.18 started; log sequence number 13898544 kolide_1 | # A value must be supplied for --auth_jwt_key. This value is used to create mailhog_1 | [APIv1] KEEPALIVE /api/v1/events redis1 | .-`` .-.\/ ., ''-.
mysql_1 | 2017-07-11T23:38:48.428828Z 0 [Note] Plugin 'FEDERATED' is disabled. kolide_1 | # session tokens for users. mailhog_1 | [APIv1] KEEPALIVE /api/v1/events redis_1 | ( ' , .-|, ) Running in standalone mode mysql_1 | 2017-07-11T23:38:48.429998Z 0 [Note] InnoDB: Loading buffer pool(s) from /tmp/mysqldata/ib_buffer_pool kolide_1 | # mailhog_1 | [APIv1] KEEPALIVE /api/v1/events redis1 | |`-.-...- ...-.`-._|' _.-'| Port: 6379 mysql_1 | 2017-07-11T23:38:48.441006Z 0 [Warning] World-writable config file './auto.cnf' is ignored. kolide_1 | # Consider using the following randomly generated key: mailhog_1 | [APIv1] KEEPALIVE /api/v1/events redis1 | | `-. ._ / _.-' | PID: 1 mysql_1 | 2017-07-11T23:38:48.441490Z 0 [Warning] World-writable config file './auto.cnf' has been removed. kolide_1 | # nC0tVJwcPfyRH8ylWybD3rM8wjlBE/a9 mailhog_1 | [APIv1] KEEPALIVE /api/v1/events redis_1 |-. `-. -./ _.-' _.-' mysql_1 | kolide_1 | ################################################################################ mailhog_1 | [APIv1] KEEPALIVE /api/v1/events redis_1 | |-.`-. -.__.-' _.-'_.-'| mysql_1 | 2017-07-11T23:38:48.442485Z 0 [Note] Salting uuid generator variables, current_pid: 1, server_start_time: 1499816326, bytes_sent: 0, kolide_1 | Using config file: /tmp/kolide.yml mailhog_1 | [APIv1] KEEPALIVE /api/v1/events redis_1 | |-.`-. .-'.-' | http://redis.io
mysql_1 | 2017-07-11T23:38:48.442575Z 0 [Note] Generated uuid: '165b3bf9-6692-11e7-9624-0242ac120003', server_start_time: 281476476526983, bytes_sent: 64455968 kolide_1 | Migrations already completed. Nothing to do. mailhog_1 | [APIv1] KEEPALIVE /api/v1/events redis1 | `-. -._-..-'.-' .-'
mysql_1 | 2017-07-11T23:38:48.442617Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 165b3bf9-6692-11e7-9624-0242ac120003. kolide_1 | Using config file: /tmp/kolide.yml mailhog_1 | [APIv1] KEEPALIVE /api/v1/events redis1 | |`-.-._-..-' .-'.-'|
mysql_1 | 2017-07-11T23:38:48.468591Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. kolide_1 | ################################################################################ mailhog_1 | [APIv1] KEEPALIVE /api/v1/events redis1 | | `-.-._ _.-'_.-' | mysql_1 | 2017-07-11T23:38:48.475406Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170711 23:38:48 kolide_1 | # ERROR: mailhog_1 | [APIv1] KEEPALIVE /api/v1/events redis_1 |-. `-.`-..-'.-' .-'
mysql_1 | 2017-07-11T23:38:48.476116Z 0 [Warning] CA certificate ca.pem is self signed. kolide_1 | # A value must be supplied for --auth_jwt_key. This value is used to create mailhog_1 | [APIv1] KEEPALIVE /api/v1/events redis1 | `-. `-._.-' .-'
mysql_1 | 2017-07-11T23:38:48.477623Z 0 [Note] Server hostname (bind-address): ''; port: 3306 kolide_1 | # session tokens for users. mailhog_1 | [APIv1] KEEPALIVE /api/v1/events redis1 | `-. _.-'
mysql_1 | 2017-07-11T23:38:48.477661Z 0 [Note] IPv6 is available. kolide_1 | # mailhog_1 | [APIv1] KEEPALIVE /api/v1/events redis_1 | `-.__.-'
mysql_1 | 2017-07-11T23:38:48.477667Z 0 [Note] - '::' resolves to '::'; kolide_1 | # Consider using the following randomly generated key: mailhog_1 | [APIv1] KEEPALIVE /api/v1/events redis_1 | mysql_1 | 2017-07-11T23:38:48.477693Z 0 [Note] Server socket created on IP: '::'. kolide_1 | # xnXUvZwg69AgY9VlN+HmIbgMtTI3Yjrc mailhog_1 | [APIv1] KEEPALIVE /api/v1/events redis_1 | 1:M 12 Jul 16:50:59.823 # WARNING: The TCP backlog setting of 511 cannot be enforced because /proc/sys/net/core/somaxconn is set to the lower value of 128. mysql_1 | 2017-07-11T23:38:48.503350Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode. kolide_1 | ################################################################################ mailhog_1 | [APIv1] KEEPALIVE /api/v1/events redis_1 | 1:M 12 Jul 16:50:59.824 # Server started, Redis version 3.2.4 mysql_1 | 2017-07-11T23:38:48.503392Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode. kolide_1 | Using config file: /tmp/kolide.yml mailhog_1 | [APIv1] KEEPALIVE /api/v1/events redis_1 | 1:M 12 Jul 16:50:59.824 # WARNING you have Transparent Huge Pages (THP) support enabled in your kernel. This will create latency and memory usage issues with Redis. To fix this issue run the command 'echo never > /sys/kernel/mm/transparent_hugepage/enabled' as root, and add it to your /etc/rc.local in order to retain the setting after a reboot. Redis must be restarted after THP is disabled. mysql_1 | 2017-07-11T23:38:48.504004Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. kolide_1 | Migrations already completed. Nothing to do. mailhog_1 | [APIv1] KEEPALIVE /api/v1/events redis_1 | 1:M 12 Jul 16:50:59.824 DB loaded from disk: 0.000 seconds mysql_1 | 2017-07-11T23:38:48.504541Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode. kolide_1 | Using config file: /tmp/kolide.yml mailhog_1 | [APIv1] KEEPALIVE /api/v1/events redis_1 | 1:M 12 Jul 16:50:59.824 The server is now ready to accept connections on port 6379 mysql_1 | 2017-07-11T23:38:48.538751Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode. kolide_1 | ################################################################################ mailhog_1 | [APIv1] KEEPALIVE /api/v1/events mysql_1 | 2017-07-11T23:38:48.679462Z 0 [Note] Event Scheduler: Loaded 0 events kolide_1 | # ERROR: mailhog_1 | [APIv1] KEEPALIVE /api/v1/events mysql_1 | 2017-07-11T23:38:48.679738Z 0 [Note] mysqld: ready for connections. kolide_1 | # A value must be supplied for --auth_jwt_key. This value is used to create mailhog_1 | [APIv1] KEEPALIVE /api/v1/events mysql_1 | Version: '5.7.18' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL) kolide_1 | # session tokens for users. mailhog_1 | [APIv1] KEEPALIVE /api/v1/events mysql_1 | 2017-07-11T23:38:48.679759Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check. kolide_1 | # mailhog_1 | [APIv1] KEEPALIVE /api/v1/events mysql_1 | 2017-07-11T23:38:48.679761Z 0 [Note] Beginning of list of non-natively partitioned tables kolide_1 | # Consider using the following randomly generated key: mailhog_1 | [APIv1] KEEPALIVE /api/v1/events mysql_1 | 2017-07-11T23:38:48.994749Z 0 [Note] End of list of non-natively partitioned tables kolide_1 | # bFQ96BXLM7xmBl2F5+SM3R8kbgzAfTFd mailhog_1 | [APIv1] KEEPALIVE /api/v1/events mysql_1 | 2017-07-11T23:38:50.056968Z 4 [Note] Aborted connection 4 to db: 'kolide' user: 'kolide' host: '172.18.0.5' (Got an error reading communication packets) kolide_1 | ################################################################################ mailhog_1 | [APIv1] KEEPALIVE /api/v1/events mysql_1 | 2017-07-11T23:38:50.080169Z 5 [Note] Aborted connection 5 to db: 'kolide' user: 'kolide' host: '172.18.0.5' (Got an error reading communication packets) mailhog_1 | [APIv1] KEEPALIVE /api/v1/events mysql_1 | 2017-07-11T23:42:18.217022Z 6 [Note] Aborted connection 6 to db: 'kolide' user: 'kolide' host: '172.18.0.5' (Got an error reading communication packets) mailhog_1 | [APIv1] KEEPALIVE /api/v1/events mysql_1 | 2017-07-11T23:42:18.230411Z 7 [Note] Aborted connection 7 to db: 'kolide' user: 'kolide' host: '172.18.0.5' (Got an error reading communication packets) mailhog_1 | [APIv1] KEEPALIVE /api/v1/events mysql_1 | 2017-07-11T23:46:39.149387Z 9 [Note] Aborted connection 9 to db: 'kolide' user: 'kolide' host: '172.18.0.5' (Got an error reading communication packets) mailhog_1 | [APIv1] KEEPALIVE /api/v1/events mysql_1 | 2017-07-11T23:46:39.163900Z 10 [Note] Aborted connection 10 to db: 'kolide' user: 'kolide' host: '172.18.0.5' (Got an error reading communication packets) mailhog_1 | [APIv1] KEEPALIVE /api/v1/events mysql_1 | 2017-07-11T23:51:31.893755Z 12 [Note] Aborted connection 12 to db: 'kolide' user: 'kolide' host: '172.18.0.5' (Got an error reading communication packets) mailhog_1 | [APIv1] KEEPALIVE /api/v1/events mysql_1 | 2017-07-11T23:51:31.909620Z 13 [Note] Aborted connection 13 to db: 'kolide' user: 'kolide' host: '172.18.0.5' (Got an error reading communication packets) mailhog_1 | [APIv1] KEEPALIVE /api/v1/events mysql_1 | 2017-07-12T00:06:23.001300Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 379089ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.) mailhog_1 | [APIv1] KEEPALIVE /api/v1/events mysql_1 | 2017-07-12T16:10:06.001566Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 55369776ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.) mailhog_1 | [APIv1] KEEPALIVE /api/v1/events mysql_1 | 2017-07-12T16:14:26.160482Z 0 [Note] Giving 0 client threads a chance to die gracefully mailhog_1 | [APIv1] KEEPALIVE /api/v1/events mysql_1 | 2017-07-12T16:14:26.160518Z 0 [Note] Shutting down slave threads mailhog_1 | [APIv1] KEEPALIVE /api/v1/events mysql_1 | 2017-07-12T16:14:26.160527Z 0 [Note] Forcefully disconnecting 0 remaining clients mailhog_1 | [APIv1] KEEPALIVE /api/v1/events mysql_1 | 2017-07-12T16:14:26.160550Z 0 [Note] Event Scheduler: Purging the queue. 0 events mailhog_1 | [APIv1] KEEPALIVE /api/v1/events mysql_1 | 2017-07-12T16:14:26.160665Z 0 [Note] Binlog end mailhog_1 | [APIv1] KEEPALIVE /api/v1/events mysql_1 | 2017-07-12T16:14:26.168614Z 0 [Note] Shutting down plugin 'ngram' mailhog_1 | [APIv1] KEEPALIVE /api/v1/events mysql_1 | 2017-07-12T16:14:26.168647Z 0 [Note] Shutting down plugin 'BLACKHOLE' mailhog_1 | [APIv1] KEEPALIVE /api/v1/events mysql_1 | 2017-07-12T16:14:26.168653Z 0 [Note] Shutting down plugin 'partition' mailhog_1 | [APIv1] KEEPALIVE /api/v1/events mysql_1 | 2017-07-12T16:14:26.168658Z 0 [Note] Shutting down plugin 'ARCHIVE' mailhog_1 | [APIv1] KEEPALIVE /api/v1/events mailhog_1 | [APIv1] KEEPALIVE /api/v1/events mailhog_1 | [APIv1] KEEPALIVE /api/v1/events mailhog_1 | [APIv1] KEEPALIVE /api/v1/events mailhog_1 | [APIv1] KEEPALIVE /api/v1/events mailhog_1 | [APIv1] KEEPALIVE /api/v1/events mailhog_1 | [APIv1] KEEPALIVE /api/v1/events mailhog_1 | 2017/07/12 16:51:00 Using in-memory storage mailhog_1 | 2017/07/12 16:51:00 [SMTP] Binding to address: 0.0.0.0:1025 mailhog_1 | 2017/07/12 16:51:00 Serving under http://0.0.0.0:8025/ mailhog_1 | [HTTP] Binding to address: 0.0.0.0:8025 mailhog_1 | Creating API v1 with WebPath: mailhog_1 | Creating API v2 with WebPath: mailhog_1 | [APIv1] KEEPALIVE /api/v1/events mailhog_1 | [APIv1] KEEPALIVE /api/v1/events mysql_1 | 2017-07-12T16:14:26.168662Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' mysql_1 | 2017-07-12T16:14:26.168667Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' mysql_1 | 2017-07-12T16:14:26.168671Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' mysql_1 | 2017-07-12T16:14:26.168676Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' mysql_1 | 2017-07-12T16:14:26.168683Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' mysql_1 | 2017-07-12T16:14:26.168698Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' mysql_1 | 2017-07-12T16:14:26.168703Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' mysql_1 | 2017-07-12T16:14:26.168738Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' mysql_1 | 2017-07-12T16:14:26.168755Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' mysql_1 | 2017-07-12T16:14:26.168763Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' mysql_1 | 2017-07-12T16:14:26.168769Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' mysql_1 | 2017-07-12T16:14:26.168775Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' mysql_1 | 2017-07-12T16:14:26.168781Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' mysql_1 | 2017-07-12T16:14:26.168787Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' mysql_1 | 2017-07-12T16:14:26.168804Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' mysql_1 | 2017-07-12T16:14:26.168810Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' mysql_1 | 2017-07-12T16:14:26.168814Z 0 [Note] Shutting down plugin 'INNODB_METRICS' mysql_1 | 2017-07-12T16:14:26.168818Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' mysql_1 | 2017-07-12T16:14:26.168822Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' mysql_1 | 2017-07-12T16:14:26.168828Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' mysql_1 | 2017-07-12T16:14:26.168837Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' mysql_1 | 2017-07-12T16:14:26.168859Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' mysql_1 | 2017-07-12T16:14:26.168866Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' mysql_1 | 2017-07-12T16:14:26.168872Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' mysql_1 | 2017-07-12T16:14:26.168877Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' mysql_1 | 2017-07-12T16:14:26.168895Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' mysql_1 | 2017-07-12T16:14:26.168905Z 0 [Note] Shutting down plugin 'INNODB_CMP' mysql_1 | 2017-07-12T16:14:26.168909Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' mysql_1 | 2017-07-12T16:14:26.168912Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' mysql_1 | 2017-07-12T16:14:26.168916Z 0 [Note] Shutting down plugin 'INNODB_TRX' mysql_1 | 2017-07-12T16:14:26.168923Z 0 [Note] Shutting down plugin 'InnoDB' mysql_1 | 2017-07-12T16:14:26.169049Z 0 [Note] InnoDB: FTS optimize thread exiting. mysql_1 | 2017-07-12T16:14:26.169352Z 0 [Note] InnoDB: Starting shutdown... mysql_1 | 2017-07-12T16:14:26.275256Z 0 [Note] InnoDB: Dumping buffer pool(s) to /tmp/mysqldata/ib_buffer_pool mysql_1 | 2017-07-12T16:14:26.280919Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 170712 16:14:26 mysql_1 | 2017-07-12T16:14:27.186862Z 0 [Note] InnoDB: Shutdown completed; log sequence number 13898572 mysql_1 | 2017-07-12T16:14:27.188039Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" mysql_1 | 2017-07-12T16:14:27.188065Z 0 [Note] Shutting down plugin 'MRG_MYISAM' mysql_1 | 2017-07-12T16:14:27.188076Z 0 [Note] Shutting down plugin 'MyISAM' mysql_1 | 2017-07-12T16:14:27.188090Z 0 [Note] Shutting down plugin 'CSV' mysql_1 | 2017-07-12T16:14:27.188102Z 0 [Note] Shutting down plugin 'MEMORY' mysql_1 | 2017-07-12T16:14:27.188107Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' mysql_1 | 2017-07-12T16:14:27.188138Z 0 [Note] Shutting down plugin 'sha256_password' mysql_1 | 2017-07-12T16:14:27.188149Z 0 [Note] Shutting down plugin 'mysql_native_password' mysql_1 | 2017-07-12T16:14:27.188268Z 0 [Note] Shutting down plugin 'binlog' mysql_1 | 2017-07-12T16:14:27.192967Z 0 [Note] mysqld: Shutdown complete mysql_1 | mysql_1 | 2017-07-12T16:51:01.724779Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). mysql_1 | 2017-07-12T16:51:01.733397Z 0 [Note] mysqld (mysqld 5.7.18) starting as process 1 ... mysql_1 | 2017-07-12T16:51:01.737799Z 0 [Warning] Setting lower_case_table_names=2 because file system for /tmp/mysqldata/ is case insensitive mysql_1 | 2017-07-12T16:51:01.742058Z 0 [Note] InnoDB: PUNCH HOLE support available mysql_1 | 2017-07-12T16:51:01.742115Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins mysql_1 | 2017-07-12T16:51:01.742132Z 0 [Note] InnoDB: Uses event mutexes mysql_1 | 2017-07-12T16:51:01.742143Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier mysql_1 | 2017-07-12T16:51:01.742154Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 mysql_1 | 2017-07-12T16:51:01.742163Z 0 [Note] InnoDB: Using Linux native AIO mysql_1 | 2017-07-12T16:51:01.743804Z 0 [Note] InnoDB: Number of pools: 1 mysql_1 | 2017-07-12T16:51:01.747385Z 0 [Note] InnoDB: Using CPU crc32 instructions mysql_1 | 2017-07-12T16:51:01.754667Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M mysql_1 | 2017-07-12T16:51:01.768516Z 0 [Note] InnoDB: Completed initialization of buffer pool mysql_1 | 2017-07-12T16:51:01.775800Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). mysql_1 | 2017-07-12T16:51:01.805674Z 0 [Note] InnoDB: Highest supported file format is Barracuda. mysql_1 | 2017-07-12T16:51:01.987417Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables mysql_1 | 2017-07-12T16:51:01.988310Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... mysql_1 | 2017-07-12T16:51:02.043879Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. mysql_1 | 2017-07-12T16:51:02.062290Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. mysql_1 | 2017-07-12T16:51:02.062389Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. mysql_1 | 2017-07-12T16:51:02.062942Z 0 [Note] InnoDB: Waiting for purge to start mysql_1 | 2017-07-12T16:51:02.116342Z 0 [Note] InnoDB: 5.7.18 started; log sequence number 13898572 mysql_1 | 2017-07-12T16:51:02.116908Z 0 [Note] Plugin 'FEDERATED' is disabled. mysql_1 | 2017-07-12T16:51:02.120215Z 0 [Note] InnoDB: Loading buffer pool(s) from /tmp/mysqldata/ib_buffer_pool mysql_1 | 2017-07-12T16:51:02.136652Z 0 [Warning] World-writable config file './auto.cnf' is ignored. mysql_1 | 2017-07-12T16:51:02.137402Z 0 [Warning] World-writable config file './auto.cnf' has been removed. mysql_1 | mysql_1 | 2017-07-12T16:51:02.137715Z 0 [Note] Salting uuid generator variables, current_pid: 1, server_start_time: 1499878261, bytes_sent: 0, mysql_1 | 2017-07-12T16:51:02.138435Z 0 [Note] Generated uuid: '49b73e69-6722-11e7-a7ef-0242ac120004', server_start_time: 281476476588918, bytes_sent: 54502688 mysql_1 | 2017-07-12T16:51:02.138537Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 49b73e69-6722-11e7-a7ef-0242ac120004. mysql_1 | 2017-07-12T16:51:02.153075Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. mysql_1 | 2017-07-12T16:51:02.159143Z 0 [Warning] CA certificate ca.pem is self signed. mysql_1 | 2017-07-12T16:51:02.163834Z 0 [Note] Server hostname (bind-address): ''; port: 3306 mysql_1 | 2017-07-12T16:51:02.163961Z 0 [Note] IPv6 is available. mysql_1 | 2017-07-12T16:51:02.163985Z 0 [Note] - '::' resolves to '::'; mysql_1 | 2017-07-12T16:51:02.164014Z 0 [Note] Server socket created on IP: '::'. mysql_1 | 2017-07-12T16:51:02.176643Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170712 16:51:02 mysql_1 | 2017-07-12T16:51:02.190262Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode. mysql_1 | 2017-07-12T16:51:02.190359Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode. mysql_1 | 2017-07-12T16:51:02.190800Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. mysql_1 | 2017-07-12T16:51:02.191213Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode. mysql_1 | 2017-07-12T16:51:02.220076Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode. mysql_1 | 2017-07-12T16:51:02.376855Z 0 [Note] Event Scheduler: Loaded 0 events mysql_1 | 2017-07-12T16:51:02.377263Z 0 [Note] mysqld: ready for connections. mysql_1 | Version: '5.7.18' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL) mysql_1 | 2017-07-12T16:51:02.377313Z 0 [Note] Executing 'SELECT FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check. mysql_1 | 2017-07-12T16:51:02.377338Z 0 [Note] Beginning of list of non-natively partitioned tables mysql_1 | 2017-07-12T16:51:02.811119Z 0 [Note] End of list of non-natively partitioned tables mysql_1 | 2017-07-12T16:51:02.841580Z 3 [Note] Aborted connection 3 to db: 'kolide' user: 'kolide' host: '172.18.0.5' (Got an error reading communication packets) mysql_1 | 2017-07-12T16:51:02.865831Z 4 [Note] Aborted connection 4 to db: 'kolide' user: 'kolide' host: '172.18.0.5' (Got an error reading communication packets)