Skip to main content
Solved

Database Connection Error


Forum|alt.badge.img+4

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.

Best answer by ryanstayloradob

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.

View original
Did this topic help you find an answer to your question?

6 replies

Forum|alt.badge.img+5
  • New Contributor
  • 53 replies
  • Answer
  • January 11, 2017

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.


Forum|alt.badge.img+4
  • Author
  • Contributor
  • 20 replies
  • January 11, 2017

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.


Forum|alt.badge.img+4
  • Author
  • Contributor
  • 20 replies
  • January 11, 2017

Nevermind, problem resolved. Thank you so much.


Forum|alt.badge.img+4
  • Author
  • Contributor
  • 20 replies
  • January 11, 2017

I forgot to turn MySQL back on.


Forum|alt.badge.img+10
  • Contributor
  • 23 replies
  • January 11, 2017

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


Bcodom
Forum|alt.badge.img+4
  • Contributor
  • 11 replies
  • March 5, 2017

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!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings