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>
Going through this per parameter:

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>
If you need to point your installation to a specific Configuration Database, do so here.

JDBCUser - The username Yellowfin accesses the Configuration Database with.

JDBCPassword - The password Yellowfin supplies to access the database (encrypted by default).

JDBCPasswordEncrypted - This defaults to true.  If you need to change your password, see this post.


Yellowfin DB connection information and events are logged under 'jdbc.log'

Is article helpful?