Pipelines as in docs gives "The 'environment' section must be a map."

My Pipelines configuration gets rejected with the following message:

The 'environment' section in your bitbucket-pipelines.yml file must be a map.

Using the docs, I created the following yml:

pipelines:
  branches:
    main:
      - step:
          image: php
          script:
            - php -v
            - apt-get update && apt-get install -y unzip
            - curl -sS https://getcomposer.org/installer | php -- --install-dir=/usr/local/bin --filename=composer
            - composer -V
            - composer install
            - bin/console doctrine:schema:create
            - bin/console doctrine:fixtures:load
            - vendor/bin/phpunit
          services:
            - mysql
definitions:
  services:
    mysql:
      image: mysql
      environment:
        MYSQL_DATABASE: tournament
        MYSQL_RANDOM_ROOT_PASSWORD: yes
        MYSQL_USERNAME: tournament_user
        MYSQL_PASSWORD: tournament_password

What's wrong with this configuration file? Why is it rejected?

6 answers

1 accepted

USERNAME should be USER and the values should be encapsulated in apostrophes. This works:

      environment:
        MYSQL_DATABASE: 'tournament'
        MYSQL_RANDOM_ROOT_PASSWORD: 'yes'
        MYSQL_USER: 'tournament_user'
        MYSQL_PASSWORD: 'tournament_password'
Joshua Tjhin Atlassian Team Apr 26, 2017

Good catch

I had the same problem and through a process of elimination found that the error comes from using MYSQL_RANDOM_ROOT_PASSWORD. So, despite what the pipelines documentation says, I don't think this is supported properly yet.

I replaced:

MYSQL_RANDOM_ROOT_PASSWORD: yes

with:

MYSQL_ROOT_PASSWORD: some_password

Not ideal but it is a workaround for now.

Joshua Tjhin Atlassian Team Apr 26, 2017

Hi Kieren, sorry for the incorrect example in the docs. I've gone ahead and fixed it.

It's an issue with yml where yes gets converted to a boolean (true) which messes with Pipelines since you can't have a boolean environment variable they must be strings.

If you wrap the yes in quotes then it should work.

MYSQL_RANDOM_ROOT_PASSWORD: 'yes'

Hi Joshua

Many thanks for this. Much appreciated.

Cheers

Kieren

I found the error! You shouldn't use MYSQL_USERNAME but MYSQL_USER!

Awesome, i'll check that out later.They also seem to have updated the docs as now the credentials are in quotes and they weren't before (still says MYSQL_USERNAME though)!

https://confluence.atlassian.com/bitbucket/test-with-databases-in-bitbucket-pipelines-856697462.html

Joshua Tjhin Atlassian Team Apr 26, 2017

Very sorry about this. Good catch. I've updated it to MYSQL_USER

Thanks

It also seems to fire on every commit, since the branch is called 'default', not 'main', but that is another issue for another time ^^.

Thanks, that worked!

It totally shouldn't have, since even the mysql docker docs acknowledge the random_root parameter, but hey, fine for now :)

These answers were very helpful. Thanks everyone.

Team Atlassian -- the docs on the page at the link below are still incorrect -- need to add quotes around the environment variables and also use MYSQL_USER not MYSQL_USERNAME. Please fix these. Thx.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Jun 06, 2018 in Bitbucket

Do you use Bitbucket Cloud and Jira Cloud? If so, let us know!

Hi Community, I'm Julia and I'm on the Jira Software Cloud marketing team!  We're looking for companies or teams using Bitbucket Cloud and Jira Software Cloud. If your team fits the t...

62 views 1 3
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you