I have installed civicrm bitnami stack on google cloud.

I need to connect sql database with tableau for data visualisation. How can i get the server, port, username and password for this connection.

  • Connect to Bitnami using SSH.
  • Find civicrm.settings.php with find . -name civicrm.settings.php. You can probably speed things along by first navigating to apps/civicrm/htdocs.
  • In the file, look for the line that defines CIVICRM_DSN, which can be interpreted as follows:
    define('CIVICRM_DSN', 'mysql://user:password@host/database?new_link=true');

According to the Bitnami CiviCRM docs the port is 3006. I assume that's correct and not a typo for "3306".

  • I figured out the credentials using bitnami docs. The mySQL doc says the default username is root, and the password is the Admin Password (Temporary) that we see in google cloud console where Admin URL, site address are listed. I did SSH from there and able to connect with mysql using root and temp password. The port is actually 3306, i checked the docs. Problem is what to enter in Server/Host in Tableau ? Second, in CIVICRM_DSN, what is username and password.
    – Ajeet
    Feb 28 '19 at 8:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.