We had a tiny problem with our xServe (10.10.5) due to space, and everything went haywire. Got 6 GB of space back and now we can't seem to get the JSS to start back up. It's stuck on the painful 'Checking for tables...' progress bar. I have searched high and low with no avail. All the posts on this are outdated, at least a year or more, and none of the command lines are working to fix. Was wondering if there's anything new in fixing this problem ASAP. Please advise.
We'd want to take a look at the JAMFSoftwareServer.log in this case; it'll usually have an error of some sort that will help point us in the direction of what might be wrong.
I've opened up a case for you with your Technical Account Manager and will send an e-mail on that shortly so you can grab that log file and get it sent in to us to take a look at. Please note if your JAMFSoftwareServer.log is over 20MB in size, we may need to zip it up to get the file size a bit smaller or our e-mail system may reject the attachment.
JAMF Software Support
Great, I'll keep an eye on the case.
Just so you're aware, both your TAM and I are at the JNUC today; I did let him know what's going on and that there is a case, so he's aware that your JSS is currently in a non-functional state as well.
JAMF Software Support
I am getting this issues right now with our JSS 9.96.
it is 9:30am Sydney time so under huge pressure to get this back up ASAP.
I cannot find that path on our db server and I am not the person that originally set the server up...
@monaronyc Did you run that command on the DB server or on the JSS?
@BrentSlater9 Ours is the same. JSS and database. But if you navigate to the Library folder on your JSS and look for the JSS folder, in it is a bin folder with the JSSDatabase Utility. You can start there. Restart MySQL and restart Tomcat from under the Utilities menu. Then launch your browser to your JSS URL. You'll probably see it repairing as it loads.
@ssurma Could be a few things, depending on your scenario. Are you hosting an on-prem JPS instance? Are MySQL, Tomcat, and your file distribution working off the same machine, or are these services separated?
If all your services are running on one machine, you might want to double-check MySQL after your restart, because your MySQL service might not be running. You could try this terminal command if you're running High Sierra to attempt a kickstart of the MySQL service:
sudo launchctl load -F /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist
Beyond this, you might want to contact your Jamf buddy --
Hope that helps a bit, at least.