CONF: How does one "connect to the database", for a stand-alone Confluence v3.5.5 instance ?

[Freedom Is Not Anarchy]

GOAL: How does one connect to the database, for a stand-alone Confluence v3.5.5 instance ?

BACKGROUND:

I see a lot of people offering that we , ... connect to the Confluence DB, and execute SQL ... , for various purposes.

* Where: When you look at the attached architectural diagram ... where is the DB , in this filesystem ? (It does not appear to be under /home/confluence ).

* Connection String: Where is the connection string we can use ? Where , under /home/confluence ?

Thanks in advance for helping ?

[Amalia]

Have you performed any Confluence installation using the Setup Wizard before? If not, please refer to those links and follow the recommended step on how to setup Confluence to work with the external database.

If you've installed Confluence using the embedded HSQLDB (for evaluation purposes only), the data is stored in Confluence Home Directory. Otherwise, it's stored in your chosen external database.

The connection string is stored in confluence.cfg.xml file in Confluence Home Directory. This file is created during the installation.