How to include mysqli in bitbucket-pipelines.yml

[kayhanisi]

First of all I am having trouble on fixing this error on the pipeline.

I am using Codeigniter as the framework, I was able to include the phpunit test, but now the problem is mysql.

This is the error that I am getting :

Type:  ErrorMessage:
Call to undefined function mysqli_init()
Filename:    /opt/atlassian/pipelines/agent/build/system/database/drivers/mysqli/mysqli_driver.php
Line Number: 136

Basically the question in place is, how to solve this issue and what is causing it?

[Jade Krafsig · Accepted solution]

I figured it out. You have to add the mysql-client and then tell it to use the extension. This worked for me:

pipelines:
  default:
    - step:
      name: php-56-mysql-latest
      image: php:5.6-apache
  script:
    - apt-get update && apt-get install -y unzip mysql-client
    - docker-php-ext-install mysqli
    - curl -sS https://getcomposer.org/installer | php -- --install-dir=/usr/local/bin --filename=composer
    - composer -V
    - composer config -g github-oauth.github.com 9351b824c3e8f8fea61c0349f9b6aed8295878a8
    - composer install --no-interaction --no-progress --prefer-dist
    - ln -s /bin/true /usr/sbin/sendmail
    - composer test
  services:
    - mysql

definitions:
 services:
   mysql:
     image: mysql:latest
     environment:
       MYSQL_DATABASE: test
       MYSQL_ROOT_PASSWORD: root