Thanks Nick I had 3 versions of the jar file in the folder, so just left 1.0.0 jar and now I reached the login screen, however doesnt recongnize my user and pass. Any other tip?
Thanks! El vie., 11 ene. 2019 a las 20:21, Nick Couchman (<[email protected]>) escribió: > 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). > > -Nick >
