> Any other tip? Having just experienced similar issues after upgrading, try clearing your browser cache. Otherwise, monitoring your catalina.out as you attempt to login may prove useful. Seems as if the client is loaded just fine if you can see the login screen, but it sounds like the JDBC extension is the source of the login issues.
Erik Berndt / Systems Administrator On Fri, Jan 11, 2019 at 2:28 PM David Rodriguez <[email protected]> wrote: > 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 >> > -- This e-mail and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient or the person responsible for delivering the e-mail to the intended recipient, be advised that you have received this e-mail in error and that any use, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately notify Superior Paving Corp. by telephone at (703) 631-0004. You will be reimbursed for reasonable costs incurred in notifying us.
