I have used that script as a general guideline, but never ran it outright as there are a few particulars in our environment where this wouldn't work. However, I would recommend downloading the pre-compiled client again and placing it in your GUAC_HOME directory again to be sure, then restart Tomcat and Guacd to see what version displays.
Erik Berndt / Systems Administrator On Fri, Jan 11, 2019 at 2:54 PM David Rodriguez <[email protected]> wrote: > btw I used the below script to upgrade > > > https://raw.githubusercontent.com/MysticRyuujin/guac-install/master/guac-upgrade.sh > > El vie., 11 ene. 2019 a las 20:46, David Rodriguez (<[email protected]>) > escribió: > >> 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. >>> >> -- 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.
