Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,293,821
Community Members
 
Community Events
165
Community Groups

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

Git push size limits are coming to Bitbucket Cloud starting April 4th, 2022

Beginning on April 4th, we will be implementing push limits. This means that your push cannot be completed if it is over 3.5 GB. If you do attempt to complete a push that is over 3.5 GB, it will fail...

2,118 views 2 9
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