It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage
Highlighted

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

 

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?

 

1 comment

Hello,

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

Thanks

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'

Comment

Log in or Sign up to comment
TAGS
Community showcase
Published in Bitbucket

Powering DevOps with Bitbucket Server & Data Center

Hi everyone, The Cloud team recently announced 12 new DevOps features that help developers ship better code, faster   ! While we’re all excited about the new improvements to Bitbucket ...

1,594 views 0 6
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you