Add ability to set database type

[gil0109]

I would like to use the docker image with other databases.

Any chance we could add a variable to adjust the driver parameter at the configuration.php file with the default being mysql?

Also, when I manually change the default, the mysqladmin ping -h"$FUSIO_DB_HOST" --silent in the docker-entrypoint.sh fails.

[chriskapp]

Hi, so in general this would be possible but then you need to install also the fitting database driver and tools depending on the database which you want to use. Fusio is able to work with most databases. So which database do you want to use?

[gil0109]

Good point. I use openshift so I don't really worry about my database being down but it makes sense.

I am thinking we change the configuration.php and add a FUSIO_DB_TYPE variable:

    'psx_connection'          => [
        'dbname'              => getenv('FUSIO_DB_NAME'),
        'user'                => getenv('FUSIO_DB_USER'),
        'password'            => getenv('FUSIO_DB_PW'),
        'host'                => getenv('FUSIO_DB_HOST'),
        'driver'              => getenv('FUSIO_DB_TYPE'),

And maybe default it to mysql in the dockerfile environments (and others ?? .env/compose yaml)

And then just to do a if then on that environment variable in docker-entrypoint.sh to run the ping test in for just mysql until we figure out the ping test for all the other db options?

Other enhancements i am working on - maybe you want them as new issues. I am hoping you agree with them so I don't need to fork my changes independently.

1. I have SQL Server driver support via the docker file, I am using openshift so i had to modify a bit to allow non-root running of odbc. I am hoping you could add that to your repo. Or if you want I could submit a pull request.
2. I combined a lot of the dockerfile using && \ instead of separate RUN/ENV/etc.commands to reduce the size of the final dockerfile
3. In Progress: Working on copying the output of /var/www/html/fusio/public (I think all I need is index.php) via the docker-entrypoint.sh as Openshift creates the volume outside of the build process so that folder is empty on initial startup.

Ref: https://github.com/gil0109/fusio-docker/tree/openshift_fixes

[chriskapp]

We have added the type at the latest release