Ok, I have removed the guacamole folder from the tomcat8 webapps folder, downloaded again the .war file and place it in /etc/guacamole (tomcat has a sym link to this) and restarted tomcat again. Now the blank screen back again :(
Catalina log show lot of these errors: 21:15:59.174 [http-nio-8080-exec-7] ERROR o.a.g.rest.RESTExceptionMapper - Unexpected internal error: ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'guacamole_db.guacamole_user_history' d$ ### 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 guacamole_user.user_id, guacamole_entity.entity_id, guacamole_entity.name, pa$ ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'guacamole_db.guacamole_user_history' doesn't exist I have checked again that in /etc/guacamole/extensions folder remains guacamole-auth-jdbc-mysql-1.0.0.jar file Any idea? Thx El vie., 11 ene. 2019 a las 20:58, Erik Berndt (< [email protected]>) escribió: > 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. >
