Skip to main content
Question

SQL is down - ideas?

  • October 6, 2017
  • 3 replies
  • 9 views

Forum|alt.badge.img+1

Database password has been changed, SLQ database needs to be restarted, can not open database utility as password is incorrect. How can you get around this issue?

We have looked online for answers and everything says we need to contact JAMF to help resolve the issue. Has anyone else encountered this problem? What was the solution?

Thanks

3 replies

donmontalvo
Forum|alt.badge.img+36
  • Hall of Fame
  • October 6, 2017

Is the password right in your JSSDBUtilityConfig.xml file (<DataBasePassword> key value)?

It should be in the same folder as JSSDatabaseUtility.jar.

On RHEL:

$ xmllint --format /path/to/JSSDBUtilityConfig.xml
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<utility>
  <scheduler>
    <scheduled>XXXX</scheduled>
    <hours>XX</hours>
    <scheduledBackupPath/>
    <deleteOld>XXXX</deleteOld>
    <deleteOlderThanDays>XX</deleteOlderThanDays>
  </scheduler>
  <backupPath>/path/to/backup/folder</backupPath>
  <ServerName>XX.XX.XX.XX</ServerName>
  <ServerPort>XXXX</ServerPort>
  <DataBaseName>XXXXXXXXXXX</DataBaseName>
  <DataBaseUser>XXXXXXXX</DataBaseUser>
  <DataBasePassword>********</DataBasePassword>
</utility>

Forum|alt.badge.img+1

hello, is it MySQL? Windows or Linux ? are you getting any SQL error number?


sharriston
Forum|alt.badge.img+10
  • Valued Contributor
  • October 6, 2017

Also which version of MySQL are you on. I had 5.7 and found that I got the database error everyday and no backups were completing. Backed up my database, removed MySQL 5.7 and installed 5.6 and it has been fine since.