Connecting to the Yellowfin Repository DB (web.xml settings)

The Yellowfin DB connection details are stored within the web.xml file, located at :

Yellowfin/appserver/webapps/ROOT/WEB-INF/web.xml

See section 'Initiate JDBC Connection Pooling - Setup/Configuration' (see below).

  <servlet>
    <servlet-name>InitConnectionPool</servlet-name>
    <servlet-class>com.hof.servlet.InitConnectionPool</servlet-class>
    <init-param>
      <param-name>Description</param-name>
      <param-value>Yellowfin Connection Pool</param-value>
    </init-param>
    <init-param>
      <param-name>JDBCDriverClass</param-name>
      <param-value>com.mysql.jdbc.Driver</param-value>
    </init-param>
    <init-param>
      <param-name>JDBCUrl</param-name>
      <param-value>jdbc:mysql://localhost:3306/73yellowfin20170420?characterEncoding=utf8</param-value>
    </init-param>
    <init-param>
      <param-name>JDBCUser</param-name>
      <param-value>root</param-value>
    </init-param>
    <!-- 
      Password to the configuration database connection is encrypted at
      installation time. If you need to change this password, you can set
      the JDBCPasswordEncrypted parameter to false, and store the password
      in plaintext in the JDBCPassword parameter.
    -->
    <init-param>
      <param-name>JDBCPassword</param-name>
      <param-value>42HbJ5JSRBH1b4SqTTMo1Q==</param-value>
    </init-param>
    <init-param>
      <param-name>JDBCPasswordEncrypted</param-name>
      <param-value>true</param-value>
    </init-param>
    <init-param>
      <param-name>JDBCMaxCount</param-name>
      <param-value>25</param-value>
    </init-param>
    <init-param>
      <param-name>JDBCMinCount</param-name>
      <param-value>2</param-value>
    </init-param>
    <load-on-startup>4</load-on-startup>
  </servlet>

JDBCDriverClass - This tells Yellowfin which JDBC Driver to use to connect to the Configuration Database.

JDBCUrl - This is the connection string to your Config DB.  The general format is:

jdbc:<RDBMStype>://<hostname-ip>:<port>/<databasename>?<extra parameters>