- Jamf Nation Community
- Products
- Jamf Pro
- Re: Database Connection Error
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Posted on 01-11-2017 11:37 AM
Hello,
The previous systems admin trained me for a week and was gone. I do not have much experience on these things. I appreciate any help I can get from all of you.
The problem:
I try to enter into the JSS dashboard through the web address and it gives me an error message.
The following error was encountered: Exception: Exception during pool initialization Please verify the following items: - MySQL is running on localhost - MySQL is accepting network connections - The user jamfsoftware@localhost has been granted privileges to the jamfsoftware database
Any suggestions in how to fix this would be amazing.
Solved! Go to Solution.
Labels:
1 ACCEPTED SOLUTION
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Posted on 01-11-2017 11:41 AM
What is your JSS running on? Linux, Windows, macOS? Is your database on a separate server? Was this working before you were trained? Sounds like you should grant user privileges to the database first using the GRANT ALL command in MySQL.
6 REPLIES 6
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Posted on 01-11-2017 11:41 AM
What is your JSS running on? Linux, Windows, macOS? Is your database on a separate server? Was this working before you were trained? Sounds like you should grant user privileges to the database first using the GRANT ALL command in MySQL.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Posted on 01-11-2017 11:52 AM
macOS, it's on a separate server. It was working before and continued to work until about last week. The server was upgraded and I'm sure that had a part in it.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Posted on 01-11-2017 11:58 AM
Nevermind, problem resolved. Thank you so much.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Posted on 01-11-2017 12:01 PM
I forgot to turn MySQL back on.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Posted on 01-11-2017 12:10 PM
We had that issue earlier this week. I chalked it up to a failed upgrade to casper 9.97.
Jamf support and I eventually used the flush-hosts command in mysql and everything started talking immediately. Some documentation from mysql on the command is below. Basically I am assuming my app server flooded the mysql server with bad requests and the mysql instance ,detecting a DDOS, turned off access for the app server to protect itself.
http://dev.mysql.com/doc/refman/5.7/en/blocked-host.html
Chris
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Posted on 03-05-2017 12:32 PM
I am running into the same issue as well. Just recently updated to the newest version, and got the same error message above. I am running a Windows server and I have verified that both the Tomcat and MySQL services are running on the server. I did attempt to get into the MySQL command prompt, but unfortunately I do not know the root password. :(
Any thoughts on how I can fix this issue? I want to try to fix it before school resumes tomorrow.
Thanks!
UPDATE: I apologize, the error message is different from this post, so please ignore my message. I will post a new message. Thanks!
