Could not connect to mysql service from main container in Bitbucket Pipelines

[Oleksandr Zaitsev]

Pipeline error stack:

Traceback (most recent call last): File "/usr/local/lib/python3.6/unittest/loader.py", line 428, in _find_test_path module = self._get_module_from_name(name) File "/usr/local/lib/python3.6/unittest/loader.py", line 369, in _get_module_from_name __import__(name) File "/opt/atlassian/pipelines/agent/build/tests.py", line 8, in <module> db = MySQLdb.connect(**settings.TEST_DATABASE) File "/usr/local/lib/python3.6/site-packages/MySQLdb/__init__.py", line 85, in Connect return Connection(*args, **kwargs) File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py", line 204, in __init__ super(Connection, self).__init__(*args, **kwargs2)_mysql_exceptions.OperationalError: (1045, "Access denied for user 'test_user'@'127.0.0.1' (using password: YES)")

bitbucket-pipelines.yml:

image: nikolaik/python-nodejs:python3.6-nodejs8

pipelines:
  default:
    - step:
        name: Python + JS unit tests
        caches:
          - docker
          - pip
          - node
        script:
          - cp -n settings_example.py settings.py
          - python -V
          - pip install --upgrade pip
          - pip install -r requirements.txt
          - python -m unittest discover
        services:
          - docker
          - mysql

definitions:
  services:
    mysql:
      image: mysql:5.6
      environment:
        MYSQL_DATABASE: pipelines
        MYSQL_RANDOM_ROOT_PASSWORD: 'yes'
        MYSQL_USERNAME: test_user
        MYSQL_PASSWORD: test_user_password

settings.py:

TEST_DATABASE = {
    "host": "127.0.0.1",
    "user": "test_user",
    "password": "test_user_password",
    "database": "pipelines"
}

I use example for mysql user from How to run common databases in Bitbucket Pipelines

It seems to be easy to setup but and I confused. What is my mistake?

[Andrei Elizaga]

Hello,

I'm also encountering this issue.  How did it work out for you?

Thanks

[Oleksandr Zaitsev]

With following config it works:

image: nikolaik/python-nodejs:python3.6-nodejs8

pipelines:
  default:
    - step:
        name: Python + JS unit tests
        caches:
          - pip
          - node
        script:
          - cp settings_example.py settings.py
          - python -V
          - pip install --upgrade pip
          - pip install -r requirements.txt
          - python -m unittest discover -v
        services:
          - mysql

definitions:
  services:
    mysql:
      image: mysql:5.6
      variables:
        MYSQL_DATABASE: '​pipelines'
        MYSQL_RANDOM_ROOT_PASSWORD: 'yes'
        MYSQL_USER: 'test_user'
        MYSQL_PASSWORD: 'test_user_password'