Re: Cannot access Users setting page
On Thu, Jul 5, 2018 at 2:52 PM johnseekins wrote: > Any additional thoughts on this problem? It isn't world-ending, but it does > make maintenance more difficult. > > > John, My only suggestion is to completely blow away every part of your install - DROP the database and re-create it from the schema files, remove all extensions and the WAR file, and redeploy everything. If you do not want to lose your current environment you could at least do this in a parallel test environment to see if it resolves the issue. When you re-install, make sure that all your components match versions and come from the same source - that is, do not try to use a WAR file that you built from some version of source while using a JAR downloaded from the web site. Make sure everything is either downloaded or built, including the DB schema files you use to create the database. It really seems like at some point some component got rev'd a version while the rest of them stayed back, and you're hitting a problem with the mis-match between those versions. -Nick
Re: Cannot access Users setting page
Any additional thoughts on this problem? It isn't world-ending, but it does make maintenance more difficult. -- Sent from: http://apache-guacamole-general-user-mailing-list.2363388.n4.nabble.com/
Re: Cannot access Users setting page
mysql> SELECT DISTINCT permission FROM guacamole_system_permission; +-+ | permission | +-+ | | | CREATE_CONNECTION | | CREATE_CONNECTION_GROUP | | CREATE_USER | | ADMINISTER | +-+ 5 rows in set (0.00 sec) -- Sent from: http://apache-guacamole-general-user-mailing-list.2363388.n4.nabble.com/
Re: Cannot access Users setting page
On Fri, Jun 22, 2018, 15:20 johnseekins wrote: > I have applied update schemas, but only those available in the > guacamole-0.9.14 tarball, so I would *assume* I've avoided 1.0 schemas... > Can you provide the output of the following query: SELECT DISTINCT permission FROM guacamole_system_permission; - Mike
Re: Cannot access Users setting page
I'm downloading all three packages (guacamole-server, guacamole.war, and guacamole-auth-jdbc) from http://apache.claz.org/guacamole/0.9.14/ (obviously this is an example host, I /am/ using the CDN) so they /should/ be the same version. -- Sent from: http://apache-guacamole-general-user-mailing-list.2363388.n4.nabble.com/
Re: Cannot access Users setting page
On Fri, Jun 22, 2018, 13:45 Nick Couchman wrote: > On Fri, Jun 22, 2018 at 15:42 johnseekins wrote: > >> After a re-install of 0.9.14 (to address some problems with the way our >> system was set up) we currently see the following error every time we try >> to >> access the Users setting page: >> >> Jun 22, 2018 3:36:31 PM com.sun.jersey.spi.container.ContainerResponse >> mapMappableContainerException >> SEVERE: The RuntimeException could not be mapped to a response, >> re-throwing >> to the HTTP container >> org.apache.ibatis.exceptions.PersistenceException: >> ### Error querying database. Cause: java.lang.IllegalArgumentException: >> No >> enum constant >> org.apache.guacamole.net.auth.permission.SystemPermission.Type. > > > This type of error usually indicates a mismatch between guacamole > components - that is, you have version 0.9.13-incubating of guacamole.war > and 0.9.14 of the JDBC extension, or something similar. Please verify that > your components are all exactly the same version and from the same source - > of you compiled the JDBC module from the git repo, also use that > guacamole.war version. If your downloaded a version from the web site, > make sure all of the components are from that same version from the site. > Please also check that the database is for 0.9.14 and has not been upgraded for a newer version (the unreleased, in-progress 1.0.0 release). The error looks like your database contains system permission constants that don't exist in Guacamole 0.9.14, which shouldn't be the case. - Mike
Re: Cannot access Users setting page
On Fri, Jun 22, 2018 at 15:42 johnseekins wrote: > After a re-install of 0.9.14 (to address some problems with the way our > system was set up) we currently see the following error every time we try > to > access the Users setting page: > > Jun 22, 2018 3:36:31 PM com.sun.jersey.spi.container.ContainerResponse > mapMappableContainerException > SEVERE: The RuntimeException could not be mapped to a response, re-throwing > to the HTTP container > org.apache.ibatis.exceptions.PersistenceException: > ### Error querying database. Cause: java.lang.IllegalArgumentException: No > enum constant > org.apache.guacamole.net.auth.permission.SystemPermission.Type. This type of error usually indicates a mismatch between guacamole components - that is, you have version 0.9.13-incubating of guacamole.war and 0.9.14 of the JDBC extension, or something similar. Please verify that your components are all exactly the same version and from the same source - of you compiled the JDBC module from the git repo, also use that guacamole.war version. If your downloaded a version from the web site, make sure all of the components are from that same version from the site. Also try restarting Tomcat to make sure everything is loaded from scratch. -Nick