osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now
Connect to Google CloudSQL database using CloudSQL proxy
I have successfully installed and configured osTicket on Ubuntu using Google CloudSQL as the backend database, by specifiying the IP address of the Google CloudSQL instance during installation.
However the preferred way to connect to Google CloudSQL is to use the CloudSQL proxy which essentially creates a local socket to allow connectivity to CloudSQL.
So rather than using a connection string such as
mysql -h 126.96.36.199 -u root -p
You can connect using a socket such as
mysql -S /cloudsql/production:europe-west1:prod-mysql-lnx -u root -p
How do I configure osTicket to use a connection string with a socket rather than defining a hostname/IP address?