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. >> >
