Whether you are using PCF, cf-deployment, or KubeCF, there is an easy pattern to connect to the underlying MySQL or PostgreSQL databases that works regardless of the secrets provider (CredHub, Vault, or Kubernetes secrets). Makes you feel a bit like a pirate, right?
So, break out your sand shovels and let's go hunting for some connection strings!
Finding the First Treasure
All flavors of Cloud Foundry have a Cloud Controller API service. This service is either a pod or VM. The configuration file used to start the API service is always in clear text. This includes configurations for the API to talk to the Cloud Controller database.
What does this mean?
Find the configuration file and you'll find the database connection string in clear text.
X marks the spot!
What You'll Need
While this sounds like a huge security hole, it is not. In order to gain access to the configuration files, you'll need
bosh ssh access which typically is limited to a small set of operations folks.
Begin the Hunt
Let's start by going after the
cloud_controller database. Depending on the flavor of the Cloud Foundry installer you'll either be hunting for a VM or a pod.
bosh ssh api/0(or if older
bosh ssh cloud_controller/0)
- Navigate to
k exec -it api-0 -- cat /var/vcap/jobs/cloud_controller_ng/config/cloud_controller_ng.yml
Parsing the Config File
Inside this file will be a reference to
db:, this will contain your database connection string like:
db: &db database: "mysql2://databaseusername:email@example.com:3306/cloud_controller"
Congratulations! You can now use this connection string to attach manually to the
UAA and the Other CF Databases
You can repeat the same pattern for UAA and other databases. When you find the component with the configuration file, scan the configuration file for the credentials and then manually make the connection to the database:
|Database||vm/pod||Config File Location|
Beware of the Treasure's Curse
Just because you have access to the databases of Cloud Foundry now, doesn't mean you should start dropping tables in production to exercise your ticketing system's ability to handle tickets-per-minute.
If you are running anything other than a SELECT statement be sure to back up the database first. For instructions on how to do this refer to: https://www.starkandwayne.com/blog/manual-backup-of-ccdb-uaadb-on-cloud-foundry/
(PS: put your sandbox toys away when you are done with them, otherwise dad will run over them with the lawnmower. Again. )