Hello all, currently trying to troubleshoot my gitlab-ci setup for a Ruby on Rails project that uses a MySQL -v 5.7 database. Running into the below error:
Mysql2::Error::ConnectionError: Access denied for user 'debian-sys-maint'@'172.17.0.3' (using password: YES)
I store the username and password as environment variables in the GitLab CI / CD Variables section.
DB_USERNAMEDB_PASSWORD
I then connect to the DB and access those variables:
echo "SELECT 'OK';" | mysql --user="$DB_USERNAME" --password="$DB_PASSWORD" --host="$DB_HOST" "$MYSQL_DATABASE"
After that I run:
bundle exec rake db:create db:migrate db:seed
That’s when the error from above occurs and fails to create the DB. Of note, I’m able to connect to the standup db locally with the same user and password stored in the GitLab CI / CD environment variables.
.gitlab-ci.yml
image: 'registry.gitlab.com/lisasnapit/onboarding-app:latest'
stages:
- build
- mysql
- rubocop
variables:
LC_ALL: C.UTF-8
LANG: en_US.UTF-8
LANGUAGE: en_US.UTF-8
.default-cache: &default-cache
cache:
untracked: true
key: suna-cache
paths:
- node_modules/
- vendor/
- public/
build:
<<: *default-cache
stage: build
script:
- ruby -v
- node -v
- yarn --version
- which ruby
- gem install bundler -v 1.17.3 --no-document
- bundle install --path=vendor
- yarn install
mysql:
<<: *default-cache
stage: mysql
variables:
MYSQL_DATABASE: standup
MYSQL_ROOT_PASSWORD: ''
MYSQL_ALLOW_EMPTY_PASSWORD: 'yes'
DB_USERNAME: $DB_USERNAME
DB_PASSWORD: $DB_PASSWORD
DB_HOST: 'mysql'
services:
- mysql:5.7
before_script:
- gem install bundler -v 1.17.3 --no-document
- bundle install --path=vendor
- cp config/database.gitlab config/database.yml
script:
- echo "SELECT 'OK';" | mysql --user="$DB_USERNAME" --password="$DB_PASSWORD" --host="$DB_HOST" "$MYSQL_DATABASE"
- sleep 20
- bundle exec rake db:create db:migrate db:seed
- bundle exec rails assets:precompile
rubocop:
<<: *default-cache
stage: rubocop
before_script:
- gem install bundler -v 1.17.3 --no-document
- bundle install --path=vendor
script:
- bundle exec rubocop
config/database.yml
default: &default
adapter: mysql2
encoding: utf8
pool: <%= ENV['RAILS_MAX_THREADS'] || 5 %>
timeout: 5000
database: <%= ENV['DB'] %>
username: <%= ENV['DB_USERNAME'] || 'root' %>
password: <%= ENV['DB_PASSWORD'] %>
host: <%= ENV['DB_HOST'] %>
development:
<<: *default
database: <%= ENV['DB'] || 'standup' %>
# Warning: The database defined as "test" will be erased and
# re-generated from your development database when you run "rake".
# Do not set this db to the same as development or production.
test:
<<: *default
database: standup_test
production:
<<: *default
username: <%= ENV['DB_USERNAME'] %>
