SQL is down - ideas?

[mchavannes]

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

[donmontalvo]

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>

[jorgeislaspined]

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

[sharriston]

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.