Skip to content

Instantly share code, notes, and snippets.

@ukazap

ukazap/cloud-sql-proxy.service

Forked from goodwill/cloud-sql-proxy.service
Created October 15, 2018 03:25
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ukazap/a5c3f85ede0ba36e117e70ef7f0f3dd5 to your computer and use it in GitHub Desktop.
Save ukazap/a5c3f85ede0ba36e117e70ef7f0f3dd5 to your computer and use it in GitHub Desktop.
Download ZIP
Example Systemd file for starting cloud sql proxy at system start
Raw
readme.md
  1. We assume you already read this: https://cloud.google.com/sql/docs/mysql/connect-external-app#proxy and created a service account for Cloud SQL Client
  2. Download cloud_sql_proxy to /usr/local/bin
  3. Make the following folders, all chown to root:root :
  4. /var/run/cloud-sql-proxy
  5. /var/local/cloud-sql-proxy
  6. Copy downloaded credential json file inside /var/local/cloud-sql-proxy, make sure only root can read as it is credential for connection.
  7. Copy above gist to /lib/systemd/system/cloud-sql-proxy.service
  8. Run systemctl daemon-reload
  9. Run systemctl start cloud-sql-proxy
  10. Profit$$$$
Raw
cloud-sql-proxy.service
[Install]
WantedBy=multi-user.target
[Unit]
Description=Google Cloud Compute Engine SQL Proxy
Requires=networking.service
After=networking.service
[Service]
Type=simple
WorkingDirectory=/usr/local/bin
ExecStart=/usr/local/bin/cloud_sql_proxy -dir=/var/run/cloud-sql-proxy -instances=<instance_connection_name>=tcp:5432 -credential_file=/var/local/cloud_sql_proxy/<credential_json>.json
Restart=always
StandardOutput=journal
User=root
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment