seqeralabs / cx-field-tools-installer

Unofficial Terraform solution to help clients install Seqera Platform
Apache License 2.0
3 stars 1 forks source link

Replace mysql client installation (Ansible) with docker container #1

Closed gwright99 closed 2 months ago

gwright99 commented 7 months ago

The existing solution (v1.0) installs a mysql-community-client package from source.

In early 2024, the MySQL GPG key expired which caused Ansible deployments to fail. There is no compelling need to build from source -- run docker exec commands through a mysql container should be equally effective.

gwright99 commented 3 months ago

During a recent client engagement, the current Ansible steps to install the mysql client failed due to firewall rules preventing contact on port 80.

The switch to a containerized mysql would have avoided this.

gwright99 commented 2 months ago

Success (esha's email address was being used since this implementation still had her as a root-user for some testing she was doing):

$ python3 -i target/python/get_access_token.py 
{"email": "esha.joshi@seqera.io"}
Auth token is:  be359cf5445c0e3d2be64cd0eea...REDACTED
jwt_stdout is:  eyJhbGciOiJIUzI1NiJ9.eyJzdWIiOiIxIiwibmJmIjoxNzIwMDk3MjQ0LCJyb2xlcyI6WyJ1c...REDACTED

Token Value is:  eyJ0aWQiOiAxfS4wZDE5ODZlYWM2ODQyYT...REDACTED