Manually Editing the Database Connection

Updated: 01 July 2021
Product: Jamf Pro

Jamf Pro uses information in the DataBase.xml file to connect to the MySQL database. For instructions on using Jamf Pro Server Tools to perform this task, see the Editing the Database Connection Using Jamf Pro Server Tools article.

Requirements

Jamf Pro 10.0.0 or later

  1. Using a text editor, open the DataBase.xml file located in the Tomcat directory:
    .../webapps/ROOT/WEB-INF/xml/DataBase.xml
    Note:

    The path to the Tomcat directory varies by OS and the method that was used to install Tomcat. Example paths include:

    • Ubuntu: /usr/local/jss/tomcat
    • RedHat: /usr/local/jss/tomcat
    • Windows: C:\Program Files\JSS\Tomcat
    • macOS: /Library/JSS/Tomcat
  2. When the DataBase.xml file is open, the content should look similar to the following:
    <?xml version="1.0" encoding="ISO-8859-1"?>
<DataBase>
<DataBaseType>mysql</DataBaseType>
<DataBaseDriver>org.mariadb.jdbc.Driver</DataBaseDriver>
<ServerName>localhost</ServerName>
<ServerPort>3306</ServerPort>
<DataBaseName>jamfsoftware</DataBaseName>
<DataBaseUser>jamfsoftware</DataBaseUser>
<DataBasePassword>jamfsw03</DataBasePassword>
...
</DataBase>
  3. Edit the <DataBaseName>, <DataBaseUser>, and <DataBasePassword> values to match the values that you used when you created the MySQL database and user.
  4. If MySQL is not installed on the same server as Jamf Pro, or if you have selected a custom port, you may also need to edit the <ServerName> and <ServerPort> values.
  5. Save the DataBase.xml file.
  6. Restart Tomcat. For instructions, see the Starting and Stopping Tomcat article.