Ibra
08/17/2022, 7:14 PMversion: '2'
services:
mysql:
restart: always
image: mysql:5.7
volumes:
- /fleet/data:/data
command: mysqld --datadir=/data/mysqldata --slow_query_log=0 --log_output=TABLE --log-queries-not-using-indexes --event-scheduler=ON
environment:
MYSQL_ROOT_PASSWORD: *****************
MYSQL_DATABASE: fleet_db
MYSQL_USER: fleet_user
MYSQL_PASSWORD: ************************
ports:
- "3306:3306"
mailhog:
restart: always
image: mailhog/mailhog:latest
ports:
- "8025:8025"
- "1025:1025"
redis:
restart: always
image: redis:5
ports:
- "6379:6379"
fleet:
restart: always
image: fleetdm/fleet:v4.17.0
volumes:
- /fleet/fleet:/fleet
command: sh -c "echo '\n' | /usr/bin/fleet prepare db && /usr/bin/fleet serve"
environment:
FLEET_MYSQL_ADDRESS: mysql:3306
FLEET_MYSQL_DATABASE: fleet_db
FLEET_MYSQL_USERNAME: fleet_user
FLEET_MYSQL_PASSWORD: *****************
FLEET_REDIS_ADDRESS: redis:6379
FLEET_SERVER_CERT: /etc/letsencrypt/live/it-asset.acme.it/fullchain.pem
FLEET_SERVER_KEY: /etc/letsencrypt/live/it-asset.acme.it/privkey.pem
FLEET_LOGGING_JSON: "true"
FLEET_AUTH_JWT_KEY:
FLEET_SERVER_TLS: 'false'
FLEET_OSQUERY_LABEL_UPDATE_INTERVAL: 5m
FLEET_VULNERABILITIES_PERIODICITY: 60m
ports:
- "8443:8080"
sharvil
08/17/2022, 7:30 PMports:
- ""127.20.0.2:3306:3306"
In the mysql section, according to docker-compose docs..Ibra
08/17/2022, 7:39 PMports:
- "10.0.0.2:3306:3306"
and this is what appears to me:
docker inspect fleet-mysql-1
"NetworkMode": "fleet_default",
"PortBindings": {
"3306/tcp": [
{
"HostIp": "10.0.0.2",
"HostPort": "3306"
}
]
},
mysql root@10.0.0.2 -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[root@itl-cslapp-54 fleet]#
sharvil
08/17/2022, 7:45 PMIbra
08/17/2022, 7:46 PMKathy Satterlee
08/17/2022, 9:22 PMmysql -uroot -p -h10.0.0.2 -P3306
?Benjamin Edwards
08/17/2022, 9:41 PM