No database connection (Fresh JSS Install on RHEL 7 headless)

Hi Bobdole,
I experience the same after upgrading to JSS v 10.17.1 today.
What helped was to do a
jamf-pro server restart
(tells the CLI to restart jamf server application).

It is not fixed though, after restarting the server, or a shutdown and start up the issue appears again.

In my case too all services are active and running as you posted before.

I will open a case tomorrow and see if Jamf may be of help.
If I can get a resolution I will post it here.

BR Thomas

After many hours of troubleshooting I self resolved this by manually pointing the MySQL database to the jamf database. Connect to MySQL as root and run “use database;” then a server restart. Apparently my MySQL instance was connecting to the wrong database.

@Bobdole Could you elaborate on that solution? In my case Jamf Pro and the MySQL database are hosted on different servers, so to attempt this same fix, should I look to work with server that's actually hosting the database or should I look to work with the MySQL service running on the server hosting Jamf Pro?

You can configure the following lines in /usr/local/jss/tomcat/webapps/ROOT/WEB-INF/xml/DataBase.xml to manually point your JSS to a certain DB @TheJazzDisciple @bobdole01

1. <DataBaseName>db name</DataBaseName>
2. <DataBaseUser>db user</DataBaseUser>
3. <DataBasePassword>db user password</DataBasePassword>
4. <ServerName>IP or DNS</ServerName>
5. <ServerPort>your port</ServerPort>

also check the config / set the config with the jamf commands on the database server

Usage:
  jamf-pro database [command]

Available Commands:
  backup            Back up the database
  config            Configure database settings
  convert-to-innodb Convert database to InnoDB
  init              Initialize up the database
  restart           Restart the database service
  restore           Restore the database from a file
  schedules         Manage scheduled backups
  start             Start the database service
  status            Show the status of the database service
  stop              Stop the database service
  test-connection   Test connection to the database

Flags:
  -h, --help   help for database

Global Flags:
  -v, --verbose   Additional output where available

Use "jamf-pro database [command] --help" for more information about a command.

Thanks for the tip @bobdole01! I just upgraded from MySQL 5.7 to 8 and was getting the database connection error. After going into MySQL and selecting the proper database everything worked again. Thank you!

Try this:

Modify the DataBase.xml file in /usr/local/jss/tomcat/webapps/ROOT/WEB-INF/xml/ on the Tomcat server, replace this line:

<jdbcParameters>?characterEncoding=utf8&amp;useUnicode=true&amp;jdbcCompliantTruncation=false&amp;useServerPrepStmts=true</jdbcParameters>

with this one:

<jdbcParameters>?characterEncoding=utf8&amp;useUnicode=true&amp;jdbcCompliantTruncation=false&amp;useServerPrepStmts=true&amp;usePipelineAuth=false&amp;useBatchMultiSend=false</jdbcParameters>

then restart the tomcat.