Support unix socket connection to MySQL and PostgreSQL

[darinpope]

Summary

If you use Google Cloud Run along with Google Cloud SQL, the only option available uses unix sockets when using the currently GA Public IP offerings. Extend the connection configuration to support unix sockets.

Documentation

• https://cloud.google.com/sql/docs/mysql/connect-run#php
• https://cloud.google.com/sql/docs/postgres/connect-run#php

Note

• Although you can use the standard connection methods with a Private IP Cloud SQL offering, private IP is still in beta for both Cloud Run and Cloud SQL. By providing unix sockets, that allows us to use the GA offerings.

[acelaya]

Sounds like something nice to have.

[acelaya]

Hey @darinpope. The change is almost ready, but I'm having some dificulties to test it.

If I publish a v2.5.0-alpha.1 including this, would you be open to test it on your Google Cloud set-up and confirm if it works?

[darinpope]

sure, I can try it out. However, it may be a little later in the week before I can work on it.

[acelaya]

Sure, that's perfect. I'll try to publish the alpha version during the week and afterwards, you can test it whenever you can/want.

[acelaya]

So basically, this alpha version (and the next stable version if everything goes right) will allow you to provide the DB_UNIX_SOCKET env var to the docker image, in order to define the socket for MySQL, MariaDB or Postgres.

It will also support it during the manual installation if you are not using the docker image, but since you mentioned Google Cloud Run, I guess it's the former for you.

[acelaya]

Once this is finished, a docker image for v2.5.0-alpha.1 will be available: https://github.com/shlinkio/shlink/runs/1470673278

[darinpope]

After a false start, it appears to install and run, but I need to do more validation work in GCP. More to come...