General Configuration Settings

Supplied Database Connection Drivers

Adding Database Connection Drivers

If you need to add additional connection drivers then:

1. Copy your JDBC driver JAR file(s) into the Yellowfin/appserver/webapps/ROOT/WEB-INF/lib/ directory.
2. If the DB Name is not in Yellowfin's database list (see below) you will need to edit the file Yellowfin/appserver/webapps/ROOT/WEB-INF/web.xml and add the class name for your driver to the list in the JDBCDrivers parameter.
   Note: if the database name is simply greyed out in the list you won't need to perform this step.
   
3. You will then need to restart Yellowfin for the new driver to become available.

Updating the TCP/IP Port

The TCP/IP port is used for the connection from the browser. You may have to change the port number if you have another service running on the Yellowfin server which has a port conflict. Choose a Port number which is not being used by another service. Note: The port was initially configured during the installation process.

To update you port number open the server.xml file located in:
Yellowfin/appserver/conf/server.xml

There are two ports that are used by Yellowfin by default, and two more that can be configured:

1. The port that Tomcat listens on for shut down requests (used internally by Tomcat) (see line 1, below)
2. The port that Tomcat listens on for HTTP browser connections (see line 3, below)
3. The port that Tomcat listens on for HTTPS browser connections (see line 21, below)
4. The port that Tomcat listens on for AJP connections (used when connecting Tomcat to IIS or Apache) (see line 35, below)

<Server port="8085" shutdown="SHUTDOWN">		
  <Service name="Catalina">
    <Connector port="80"				
               maxHttpHeaderSize="8192"
               maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
               enableLookups="false" redirectPort="8443" acceptCount="100"
               connectionTimeout="20000" disableUploadTimeout="true"
               URIEncoding="UTF-8"
               compression="on"
               compressionMinSize="2048"
               noCompressionUserAgents="gozilla, traviata"
               compressableMimeType="text/html,text/xml,text/plain"
               />

    <!-- Uncomment this for an SSL connector running on port 8443 (change
         the port as required). You will need to generate a certificate
         and save it in this directory as "tomcat.key" (change the
         keystoreFile and keystorePass values as required).
         See: http://tomcat.apache.org/tomcat-5.5-doc/ssl-howto.html -->
    <!--
    <Connector port="8443"				
               maxHttpHeaderSize="8192"
               maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
               enableLookups="false" disableUploadTimeout="true"
               acceptCount="100" scheme="https" secure="true"
               clientAuth="false" sslProtocol="TLS" URIEncoding="UTF-8"
               keystoreFile="${catalina.home}/conf/tomcat.key"
               keystorePass="password"
               />
    -->
    
    <!-- Uncomment this for an AJP connector, to connect tomcat to another
         web server such as Apache or IIS -->
    <!--
    <Connector port="8009" protocol="AJP/1.3" />	
    -->

    <Engine name="Catalina" defaultHost="localhost">
      <Host name="localhost" appBase="webapps"
       unpackWARs="true" autoDeploy="false"
       xmlValidation="false" xmlNamespaceAware="false">
      </Host>
    </Engine>
  </Service>
</Server>

Outgoing Mail Settings

Yellowfin can be configured to broadcast electronic mail on an adhoc or scheduled basis. A SMTP server must be running for outgoing mail to be sent successfully.
By default the Yellowfin application will use localhost as the SMTP server. If you would like to use another SMTP server (such as an ISP SMTP server) you must manually modify the SMTP configuration using the Administration Configuration page.

Warning: Generally in an OEM deployment you may not wish to have your clients modify the some configuration items. There is a risk that your users may modify a key attributes which will break their instance of Yellowfin. Use role management to remove the associated functions from their roles.