On Fri, Jan 11, 2019, 11:21 Nick Couchman <[email protected] wrote: > On Fri, Jan 11, 2019 at 14:06 David Rodriguez <[email protected]> wrote: > >> Hi, >> >> I have tried to upgrade from 0.9.14 to 1.0.0 and something didn't work as >> Im getting a blank screen accesing the login screen. >> >> In the catalina log file I have seen the below errors, so I assumed this >> was something related to the mysql schema. >> >> ### Error querying database. Cause: >> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column >> 'username' in 'field list' >> ### The error may exist in >> org/apache/guacamole/auth/jdbc/user/UserMapper.xml >> ### The error may involve defaultParameterMap >> ### The error occurred while setting parameters >> ### SQL: SELECT user_id, username, >> password_hash, password_salt, password_date, $ >> ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: >> Unknown column 'username' in 'field list' >> >> > This is the result of a mismatch between the database schema and the JDBC > extension. Most likely you upgraded the DB to the 1.0.0 schema but it > looks like the old extension is still loaded. Make sure that you upgrade > the JDBC extension file (remove 0.9.14 jar, make sure 1.0.0 jar is on > place) and restart Tomcat (or whatever container you're using). >
Another point: If the 0.9.14 extension is being loaded, the webapp must also be 0.9.14. There are sanity checks that verify extension versions match before loading them. - Mike
