On Wed, Feb 20, 2019, 11:44 Tezarin <[email protected]> wrote:
> Hi Nick, > I decided to upgrade my guacamole version so puled down the v 1.0.0 (was > running 0.9.14 before), I have a RDS as a database and after I got the > containers running, I noticed the GUI doesn't come up. docker logs shows > this schema error: > ### Error querying database. Cause: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'guacamole.guacamole_entity' doesn't exist### 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, > password_hash, password_salt, password_date, > disabled, expired, access_window_start, > access_window_end, valid_from, > valid_until, timezone, full_name, > email_address, organization, organizational_role, > MAX(start_date) AS last_active FROM guacamole_user > JOIN guacamole_entity ON guacamole_user.entity_id = > guacamole_entity.entity_id LEFT JOIN guacamole_user_history ON > guacamole_user_history.user_id = guacamole_user.user_id WHERE > guacamole_entity.name = ? AND guacamole_entity.type = > 'USER' GROUP BY guacamole_user.user_id, > guacamole_entity.entity_id; SELECT > guacamole_user_attribute.user_id, > guacamole_user_attribute.attribute_name, > guacamole_user_attribute.attribute_value FROM > guacamole_user_attribute JOIN guacamole_user ON > guacamole_user.user_id = guacamole_user_attribute.user_id JOIN > guacamole_entity ON guacamole_user.entity_id = guacamole_entity.entity_id > WHERE guacamole_entity.name = ? AND > guacamole_entity.type = 'USER'### Cause: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'guacamole.guacamole_entity' doesn't exist > > > Can you please advise what I did wrong? http://guacamole.apache.org/releases/1.0.0/#database-schema-changes Also: http://guacamole.apache.org/doc/1.0.0/gug/jdbc-auth.html#idm46248438612160 - Mike
