Hi all,
I am attempting to move my install to Linux from Mac
Step 1 is to move WHD,
step 2 will be to migrate from MySQL to Postgres
So I have MySQL on a Mac, Web Help Desk fresh install on a linux VM
This error is from WHD when I attempt to use the MySQL database.
All of the credentials are accepted ok, then it says ‘we need to upgrade the database’
Upgrade appears to go ok, but then WHD spews this error after the upgrade-
Unknown table 'api_key' in information_schema Stack Trace
Unknown table 'api_key' in information_schemaat com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1218)
at com.mysql.cj.jdbc.DatabaseMetaData$7.forEach(DatabaseMetaData.java:2965)
at com.mysql.cj.jdbc.DatabaseMetaData$7.forEach(DatabaseMetaData.java:2953)
at com.mysql.cj.jdbc.IterateBlock.doForAll(IterateBlock.java:56)
at com.mysql.cj.jdbc.DatabaseMetaData.getPrimaryKeys(DatabaseMetaData.java:3006)
at com.webobjects.jdbcadaptor.JDBCChannel._jdbcGetAttributesForEntity(JDBCChannel.java:806)
at com.webobjects.jdbcadaptor.JDBCChannel.describeModelWithTableNames(JDBCChannel.java:1059)
at com.macsdesign.util.MDSDBUpdater.updateDatabaseWithModelNamed(MDSDBUpdater.java:216)
at com.macsdesign.whd.HelpDeskDBLoader.updateDatabase(HelpDeskDBLoader.java:132)
at com.macsdesign.whd.ui.DBUpdateProgress.performAction(DBUpdateProgress.java:139)
at com.webobjects.woextensions.WOLongResponsePage.run(WOLongResponsePage.java:125)
at java.lang.Thread.run(Thread.java:745)
at com.webobjects.jdbcadaptor.JDBCChannel._jdbcGetAttributesForEntity(JDBCChannel.java:823)
at com.webobjects.jdbcadaptor.JDBCChannel.describeModelWithTableNames(JDBCChannel.java:1059)
at com.macsdesign.util.MDSDBUpdater.updateDatabaseWithModelNamed(MDSDBUpdater.java:216)
at com.macsdesign.whd.HelpDeskDBLoader.updateDatabase(HelpDeskDBLoader.java:132)
at com.macsdesign.whd.ui.DBUpdateProgress.performAction(DBUpdateProgress.java:139)
at com.webobjects.woextensions.WOLongResponsePage.run(WOLongResponsePage.java:125)
at java.lang.Thread.run(Thread.java:745)
I have verified that lower_case_names is set correctly before import as per here-
Upgrading to Web Help Desk 12.6 for MySQL users - SolarWinds Worldwide, LLC. Help and Support
I have also deleted and recreated the table as per here-
Table 'whd.API_KEY' doesn't exist
But there appears to be no data in the table, so I dropped it and tried again.
This time it complained about the next table-
| | Unknown table 'apn_device' in information_schema |
This is driving me nuts, I have literally spent months on this project.
Please help.
