search

sourcebroker / deployer-extended-database

Deployer tasks to manage database synchronization between application instances.
MIT License
39 stars 13 forks source link

Add mysqli flags (e. g. for SSL database connections) #21

Closed JulianXIMA closed 1 year ago

JulianXIMA commented 1 year ago

Currently there is only "host", "user", "password", "dbname" and "port" possible to establish a db-connection (e. g. for db:truncate, db:export, ...). Right now it is not possible to use mysql flags or certificates parameters to use ssl.

It would be nice to implement that in DatabaseUtility.php and the affected deployer-tasks of deployer-extended-database.

To use flags (e. g. for SSL) it also needs to be switched from "mysqli_connect" to "mysqli_real_connect" (https://www.php.net/manual/en/mysqli.real-connect.php).

This change would also need to expand the variable set('db_databases',.... Right?

kszymukowicz commented 1 year ago

@maikschneider Tnx for the PR!

kszymukowicz commented 1 year ago

@JulianXIMA can you somehow test dev-master if it works for your needs?

JulianXIMA commented 1 year ago

@kszymukowicz works for me. Thanks!