The DataBase.xml File Contains Invalid MySQL Server Location Details

Technical Articles
Solution
Application
Content Type
Technical Documentation
Utilities & Services
ft:locale
en-US

Jamf Pro uses information in the DataBase.xml file to locate the MySQL database. If the DataBase.xml file's server location details are incorrect, a database connection error will occur. Follow these steps to verify and resolve this issue.

  1. Log in to the server hosting Tomcat.
  2. Locate the DataBase.xml file, stored in one of the following locations:

    • Linux: /usr/local/jss/tomcat/webapps/ROOT/WEB-INF/xml/DataBase.xml

    • Windows: C:\Program Files\JSS\Tomcat\webapps\ROOT\WEB-INF\XML\DataBase.xml

  3. Open the DataBase.xml file in a plain text editor and locate the following line:
    <ServerName>localhost</ServerName>
  4. Verify that the server location details are correct.
    If the database is hosted on the same server as the Tomcat server, the value should be set to "localhost", as shown in the above example. If the database is hosted on a separate server from the Tomcat server, the value should be either the fully qualified domain name or the IP address of the database server.
    1. If the server location details are correct, this is not the issue. Refer to the next possible issue in this article to continue troubleshooting.
    2. If the server location details are incorrect, continue following these steps to resolve.
  5. Edit the DataBase.xml file to reflect the correct server location details, and save the changes to the file.
  6. Restart Tomcat.

    For more information, see the Starting and Stopping Tomcat article.

  7. Reattempt connection to the database.

    If the database connection error persists, refer to the next possible issue in this article to continue troubleshooting.