You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@guacamole.apache.org by David Rodriguez <dj...@gmail.com> on 2019/01/11 19:05:47 UTC
Blank screen after upgrade to 1.0.0.
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'
I have tried again to process all schema upgrade .sql files and all
returned duplicated column (what is expected) except upgrade-pre-0.9.6.sql
which show the below:
root@tvh-server:/home/djrm/Descargas/guacamole1.0/guacamole-auth-jdbc-1.0.0/mysql/schema/upgrade#
mysql -u root -p guacamole_db < upgrade-pre-0.9.6.sql
Enter password:
ERROR 1054 (42S22) at line 24: Unknown column 'user_id' in 'field list'
Can it be this blank screen due to any error on this sql file? The content
of the file is:
INSERT INTO guacamole_user_permission
(user_id, affected_user_id, permission)
SELECT user_id, user_id, 'READ'
FROM guacamole_user
WHERE
user_id NOT IN (
SELECT user_id
FROM guacamole_user_permission
WHERE
user_id = affected_user_id
AND permission = 'READ'
);
Any help would be really appreciated!
Thanks
David
Re: Blank screen after upgrade to 1.0.0.
Posted by David Rodriguez <dj...@gmail.com>.
OK, I found the issue... it is related to the Spanish translation as
setting English language it show 1.0.0
is there any easy way to fix this?
El sáb., 12 ene. 2019 a las 10:52, David Rodriguez (<dj...@gmail.com>)
escribió:
> Probably any error happened with the script and I was not aware of....
> I have manually processed the pre upgrade script 0.9.14 and finally the
> related table was created (the full script always said that the first
> column was duplicated therefore it didnt reach the part of the script for
> this table creation...)
>
> Login back to working now! however the login screen still showing 0.9.13
> incubing in the right footer.... see attached. What could be the reason of
> that?
>
> Any light?
>
>
> Thanks
>
> El sáb., 12 ene. 2019 a las 1:16, Mike Jumper (<mj...@apache.org>)
> escribió:
>
>> On Fri, Jan 11, 2019, 16:02 David Rodriguez <djrm05@gmail.com wrote:
>>
>>> Yes those .sql were executed in order. Should I do it again?
>>>
>>
>> No, the scripts aren't idempotent.
>>
>> Are you sure you ran then against that database? No errors? Made a backup
>> before the upgrade?
>>
>> If unsure, we may never know what happened, but if they ran properly the
>> table would exist.
>>
>> - Mike
>>
>>
Re: Blank screen after upgrade to 1.0.0.
Posted by David Rodriguez <dj...@gmail.com>.
Probably any error happened with the script and I was not aware of....
I have manually processed the pre upgrade script 0.9.14 and finally the
related table was created (the full script always said that the first
column was duplicated therefore it didnt reach the part of the script for
this table creation...)
Login back to working now! however the login screen still showing 0.9.13
incubing in the right footer.... see attached. What could be the reason of
that?
Any light?
Thanks
El sáb., 12 ene. 2019 a las 1:16, Mike Jumper (<mj...@apache.org>)
escribió:
> On Fri, Jan 11, 2019, 16:02 David Rodriguez <djrm05@gmail.com wrote:
>
>> Yes those .sql were executed in order. Should I do it again?
>>
>
> No, the scripts aren't idempotent.
>
> Are you sure you ran then against that database? No errors? Made a backup
> before the upgrade?
>
> If unsure, we may never know what happened, but if they ran properly the
> table would exist.
>
> - Mike
>
>
Re: Blank screen after upgrade to 1.0.0.
Posted by Mike Jumper <mj...@apache.org>.
On Fri, Jan 11, 2019, 16:02 David Rodriguez <djrm05@gmail.com wrote:
> Yes those .sql were executed in order. Should I do it again?
>
No, the scripts aren't idempotent.
Are you sure you ran then against that database? No errors? Made a backup
before the upgrade?
If unsure, we may never know what happened, but if they ran properly the
table would exist.
- Mike
Re: Blank screen after upgrade to 1.0.0.
Posted by David Rodriguez <dj...@gmail.com>.
Yes those .sql were executed in order. Should I do it again?
El sáb., 12 ene. 2019 0:20, Mike Jumper <mj...@apache.org> escribió:
> On Fri, Jan 11, 2019 at 12:22 PM David Rodriguez <dj...@gmail.com> wrote:
>
>> 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
>>
>
> Either your database is still from an older version or it was not properly
> updated. The guacamole_user_history table was added in 0.9.14. Did you run
> each of the relevant upgrade scripts against your database?
>
> From "Upgrading an existing database" in the database auth documentation
> [1]:
>
> "... These scripts are incremental and, when relevant, must be run in
> order. For example, if you are upgrading an existing database from version
> 0.9.13-incubating to version 1.0.0, you would need to run the
> upgrade-pre-0.9.14.sql script (because 0.9.13-incubating is older than
> 0.9.14), followed by the upgrade-pre-1.0.0.sql script (because
> 0.9.13-incubating is also older than 1.0.0)."
>
> - Mike
>
> [1] http://guacamole.apache.org/doc/gug/jdbc-auth.html
>
>
Re: Blank screen after upgrade to 1.0.0.
Posted by Mike Jumper <mj...@apache.org>.
On Fri, Jan 11, 2019 at 12:22 PM David Rodriguez <dj...@gmail.com> wrote:
> 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
>
Either your database is still from an older version or it was not properly
updated. The guacamole_user_history table was added in 0.9.14. Did you run
each of the relevant upgrade scripts against your database?
From "Upgrading an existing database" in the database auth documentation
[1]:
"... These scripts are incremental and, when relevant, must be run in
order. For example, if you are upgrading an existing database from version
0.9.13-incubating to version 1.0.0, you would need to run the
upgrade-pre-0.9.14.sql script (because 0.9.13-incubating is older than
0.9.14), followed by the upgrade-pre-1.0.0.sql script (because
0.9.13-incubating is also older than 1.0.0)."
- Mike
[1] http://guacamole.apache.org/doc/gug/jdbc-auth.html
Re: Blank screen after upgrade to 1.0.0.
Posted by David Rodriguez <dj...@gmail.com>.
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 (<
erikberndt@superiorpaving.net>) 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 <dj...@gmail.com> 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 (<dj...@gmail.com>)
>> 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 (<
>>> erikberndt@superiorpaving.net>) 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 <dj...@gmail.com>
>>>> 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 (<vn...@apache.org>)
>>>>> escribió:
>>>>>
>>>>>> On Fri, Jan 11, 2019 at 14:06 David Rodriguez <dj...@gmail.com>
>>>>>> 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.
>
Re: Blank screen after upgrade to 1.0.0.
Posted by Erik Berndt <er...@superiorpaving.net>.
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 <dj...@gmail.com> 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 (<dj...@gmail.com>)
> 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 (<
>> erikberndt@superiorpaving.net>) 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 <dj...@gmail.com>
>>> 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 (<vn...@apache.org>)
>>>> escribió:
>>>>
>>>>> On Fri, Jan 11, 2019 at 14:06 David Rodriguez <dj...@gmail.com>
>>>>> 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.
Re: Blank screen after upgrade to 1.0.0.
Posted by David Rodriguez <dj...@gmail.com>.
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 (<dj...@gmail.com>)
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 (<
> erikberndt@superiorpaving.net>) 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 <dj...@gmail.com> 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 (<vn...@apache.org>)
>>> escribió:
>>>
>>>> On Fri, Jan 11, 2019 at 14:06 David Rodriguez <dj...@gmail.com> 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.
>>
>
Re: Blank screen after upgrade to 1.0.0.
Posted by Nick Couchman <vn...@apache.org>.
On Fri, Jan 11, 2019 at 14:47 David Rodriguez <dj...@gmail.com> wrote:
> 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
>
Yeah, that could be a problem. You need to go to your Tomcat directory and
remove the existing guacamole.war file (or whatever it is called in your
install and then copy the 1.0.0 war for into place. I'd shut down Tomcat
before you do that and then restart it when you're done just to be sure.
-Nick
Re: Blank screen after upgrade to 1.0.0.
Posted by David Rodriguez <dj...@gmail.com>.
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 (<
erikberndt@superiorpaving.net>) 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 <dj...@gmail.com> 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 (<vn...@apache.org>)
>> escribió:
>>
>>> On Fri, Jan 11, 2019 at 14:06 David Rodriguez <dj...@gmail.com> 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.
>
Re: Blank screen after upgrade to 1.0.0.
Posted by Erik Berndt <er...@superiorpaving.net>.
> 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 <dj...@gmail.com> 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 (<vn...@apache.org>)
> escribió:
>
>> On Fri, Jan 11, 2019 at 14:06 David Rodriguez <dj...@gmail.com> 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.
Re: Blank screen after upgrade to 1.0.0.
Posted by David Rodriguez <dj...@gmail.com>.
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 (<vn...@apache.org>)
escribió:
> On Fri, Jan 11, 2019 at 14:06 David Rodriguez <dj...@gmail.com> 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
>
Re: Blank screen after upgrade to 1.0.0.
Posted by Mike Jumper <mj...@apache.org>.
On Fri, Jan 11, 2019, 11:21 Nick Couchman <vnick@apache.org wrote:
> On Fri, Jan 11, 2019 at 14:06 David Rodriguez <dj...@gmail.com> 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).
>
Another point: If the 0.9.14 extension is being loaded, the webapp must
also be 0.9.14. There are sanity checks that verify extension versions
match before loading them.
- Mike
Re: Blank screen after upgrade to 1.0.0.
Posted by Nick Couchman <vn...@apache.org>.
On Fri, Jan 11, 2019 at 14:06 David Rodriguez <dj...@gmail.com> 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