Could not connect to mysql service with Bitbucket Pipelines

Oleksandr Zaitsev_r71hkd

 

Pipeline error stack:

<span>Traceback (most recent call last):</span>

<span>&nbsp; File "/usr/local/lib/python3.6/unittest/loader.py", line 428, in _find_test_path</span><span> module = self._get_module_from_name(name)</span>

<span>&nbsp; File "/usr/local/lib/python3.6/unittest/loader.py", line 369, in _get_module_from_name</span><span> __import__(name)</span>

<span>&nbsp;</span><span> File "/opt/atlassian/pipelines/agent/build/tests.py", line 8, in <module></span><span> db = MySQLdb.connect(**settings.TEST_DATABASE)</span>

<span>&nbsp;</span><span> File "/usr/local/lib/python3.6/site-packages/MySQLdb/__init__.py", line 85, in Connect</span><span> return Connection(*args, **kwargs)</span>

<span>&nbsp;</span><span> File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py", line 204, in __init__</span><span> super(Connection, self).__init__(*args, **kwargs2)</span>

<span>&nbsp;&nbsp;</span><span>_mysql_exceptions.OperationalError: (1045, "Access denied for user 'test_user'@'127.0.0.1' (using password: YES)")</span>

 

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&nbsp;<a href="https://confluence.atlassian.com/bitbucket/how-to-run-common-databases-in-bitbucket-pipelines-891130454.html?_ga=2.22534651.1136015438.1558966438-504594531.1546883304#HowtoruncommondatabasesinBitbucketPipelines-MySQL%E2%80%93testuser" target="_blank" rel="noopener nofollow noreferrer">How to run common databases in Bitbucket Pipelines</a>

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

Peter Plewa

Hi @Oleksandr Zaitsev

Sorry for delayed response, did you manage to resolve your issue or could you provide me information with the current state of your pipeline? There are number of articles on how to connect to mysql service, is any of those helpful?

https://community.atlassian.com/t5/forums/searchpage/tab/message?advanced=false&allow_punctuation=false&q=pipelines+mysql

Thanks,
Peter