OMG I have just seen that the login screen Im reaching said "0.9.13-incubating" so not sure why it is getting this version instead 1.0.0. Could someone point me in the right direction? Im really lost
Thanks a lot in advance El vie., 11 ene. 2019 a las 20:33, Erik Berndt (< [email protected]>) escribió: > > 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. >
