olumn guacamole_entity.type does not exist

classic Classic list List threaded Threaded
9 messages Options
Reply | Threaded
Open this post in threaded view
|

olumn guacamole_entity.type does not exist

mamet007
All of sudent I started to have this issue in my new build. I built the
server 3 times but for some reason i am getting that error any idea?
### 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'::guacamole_entity_type         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'::guacamole_entity_type
### Cause: org.postgresql.util.PSQLException: ERROR: column
guacamole_entity.type does not exist
  Position: 814




--
Sent from: http://apache-guacamole-general-user-mailing-list.2363388.n4.nabble.com/

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: olumn guacamole_entity.type does not exist

vnick
On Wed, Jul 8, 2020 at 4:03 PM mamet007 <[hidden email]> wrote:
All of sudent I started to have this issue in my new build. I built the
server 3 times but for some reason i am getting that error any idea?

Are you using a clean database, or did you import an existing one?

If a new database, make sure that the schema you're using is the current one for the release.  It looks like you're missing the schema changes that were introduced in the 1.0.0 build to support user groups.

If an existing database, make sure you apply the schema updates to the database to get the correct columns.

-Nick
Reply | Threaded
Open this post in threaded view
|

Re: olumn guacamole_entity.type does not exist

mamet007
In reply to this post by mamet007
Using a fresh copy of RDS on AWS.  I initialized the schema few times already
here is the output of my 2nd attempt.


psql:db_schema_tamplate_output.sql:27: ERROR:  type
"guacamole_connection_group_db" already exists
psql:db_schema_tamplate_output.sql:36: ERROR:  type "guacamole_entity_db"
already exists
psql:db_schema_tamplate_output.sql:47: ERROR:  type
"guacamole_object_permission_db" already exists
psql:db_schema_tamplate_output.sql:60: ERROR:  type
"guacamole_system_permission_db" already exists
psql:db_schema_tamplate_output.sql:69: ERROR:  type
"guacamole_proxy_encryption_method" already exists
psql:db_schema_tamplate_output.sql:98: ERROR:  relation
"guacamole_connection_group" already exists
psql:db_schema_tamplate_output.sql:101: ERROR:  relation
"guacamole_connection_group_parent_id" already exists
psql:db_schema_tamplate_output.sql:139: ERROR:  relation
"guacamole_connection" already exists
psql:db_schema_tamplate_output.sql:142: ERROR:  relation
"guacamole_connection_parent_id" already exists
psql:db_schema_tamplate_output.sql:162: ERROR:  relation "guacamole_entity"
already exists
psql:db_schema_tamplate_output.sql:212: ERROR:  relation "guacamole_user"
already exists
psql:db_schema_tamplate_output.sql:238: ERROR:  relation
"guacamole_user_group" already exists
psql:db_schema_tamplate_output.sql:261: ERROR:  relation
"guacamole_user_group_member" already exists
psql:db_schema_tamplate_output.sql:287: ERROR:  relation
"guacamole_sharing_profile" already exists
psql:db_schema_tamplate_output.sql:290: ERROR:  relation
"guacamole_sharing_profile_primary_connection_id" already exists
psql:db_schema_tamplate_output.sql:309: ERROR:  relation
"guacamole_connection_parameter" already exists
psql:db_schema_tamplate_output.sql:312: ERROR:  relation
"guacamole_connection_parameter_connection_id" already exists
psql:db_schema_tamplate_output.sql:333: ERROR:  relation
"guacamole_sharing_profile_parameter" already exists
psql:db_schema_tamplate_output.sql:336: ERROR:  relation
"guacamole_sharing_profile_parameter_sharing_profile_id" already exists
psql:db_schema_tamplate_output.sql:357: ERROR:  relation
"guacamole_user_attribute" already exists
psql:db_schema_tamplate_output.sql:360: ERROR:  relation
"guacamole_user_attribute_user_id" already exists
psql:db_schema_tamplate_output.sql:381: ERROR:  relation
"guacamole_user_group_attribute" already exists
psql:db_schema_tamplate_output.sql:384: ERROR:  relation
"guacamole_user_group_attribute_user_group_id" already exists
psql:db_schema_tamplate_output.sql:405: ERROR:  relation
"guacamole_connection_attribute" already exists
psql:db_schema_tamplate_output.sql:408: ERROR:  relation
"guacamole_connection_attribute_connection_id" already exists
psql:db_schema_tamplate_output.sql:429: ERROR:  relation
"guacamole_connection_group_attribute" already exists
psql:db_schema_tamplate_output.sql:432: ERROR:  relation
"guacamole_connection_group_attribute_connection_group_id" already exists
psql:db_schema_tamplate_output.sql:453: ERROR:  relation
"guacamole_sharing_profile_attribute" already exists
psql:db_schema_tamplate_output.sql:456: ERROR:  relation
"guacamole_sharing_profile_attribute_sharing_profile_id" already exists
psql:db_schema_tamplate_output.sql:479: ERROR:  relation
"guacamole_connection_permission" already exists
psql:db_schema_tamplate_output.sql:482: ERROR:  relation
"guacamole_connection_permission_connection_id" already exists
psql:db_schema_tamplate_output.sql:485: ERROR:  relation
"guacamole_connection_permission_entity_id" already exists
psql:db_schema_tamplate_output.sql:508: ERROR:  relation
"guacamole_connection_group_permission" already exists
psql:db_schema_tamplate_output.sql:511: ERROR:  relation
"guacamole_connection_group_permission_connection_group_id" already exists
psql:db_schema_tamplate_output.sql:514: ERROR:  relation
"guacamole_connection_group_permission_entity_id" already exists
psql:db_schema_tamplate_output.sql:537: ERROR:  relation
"guacamole_sharing_profile_permission" already exists
psql:db_schema_tamplate_output.sql:540: ERROR:  relation
"guacamole_sharing_profile_permission_sharing_profile_id" already exists
psql:db_schema_tamplate_output.sql:543: ERROR:  relation
"guacamole_sharing_profile_permission_entity_id" already exists
psql:db_schema_tamplate_output.sql:561: ERROR:  relation
"guacamole_system_permission" already exists
psql:db_schema_tamplate_output.sql:564: ERROR:  relation
"guacamole_system_permission_entity_id" already exists
psql:db_schema_tamplate_output.sql:588: ERROR:  relation
"guacamole_user_permission" already exists
psql:db_schema_tamplate_output.sql:591: ERROR:  relation
"guacamole_user_permission_affected_user_id" already exists
psql:db_schema_tamplate_output.sql:594: ERROR:  relation
"guacamole_user_permission_entity_id" already exists
psql:db_schema_tamplate_output.sql:618: ERROR:  relation
"guacamole_user_group_permission" already exists
psql:db_schema_tamplate_output.sql:621: ERROR:  relation
"guacamole_user_group_permission_affected_user_group_id" already exists
psql:db_schema_tamplate_output.sql:624: ERROR:  relation
"guacamole_user_group_permission_entity_id" already exists
psql:db_schema_tamplate_output.sql:659: ERROR:  relation
"guacamole_connection_history" already exists
psql:db_schema_tamplate_output.sql:662: ERROR:  relation
"guacamole_connection_history_user_id" already exists
psql:db_schema_tamplate_output.sql:665: ERROR:  relation
"guacamole_connection_history_connection_id" already exists
psql:db_schema_tamplate_output.sql:668: ERROR:  relation
"guacamole_connection_history_sharing_profile_id" already exists
psql:db_schema_tamplate_output.sql:671: ERROR:  relation
"guacamole_connection_history_start_date" already exists
psql:db_schema_tamplate_output.sql:674: ERROR:  relation
"guacamole_connection_history_end_date" already exists
psql:db_schema_tamplate_output.sql:677: ERROR:  relation
"guacamole_connection_history_connection_id_start_date" already exists
psql:db_schema_tamplate_output.sql:698: ERROR:  relation
"guacamole_user_history" already exists
psql:db_schema_tamplate_output.sql:701: ERROR:  relation
"guacamole_user_history_user_id" already exists
psql:db_schema_tamplate_output.sql:704: ERROR:  relation
"guacamole_user_history_start_date" already exists
psql:db_schema_tamplate_output.sql:707: ERROR:  relation
"guacamole_user_history_end_date" already exists
psql:db_schema_tamplate_output.sql:710: ERROR:  relation
"guacamole_user_history_user_id_start_date" already exists
psql:db_schema_tamplate_output.sql:732: ERROR:  relation
"guacamole_user_password_history" already exists
psql:db_schema_tamplate_output.sql:735: ERROR:  relation
"guacamole_user_password_history_user_id" already exists
psql:db_schema_tamplate_output.sql:737: ERROR:  role "guacadmin" already
exists
GRANT
GRANT
GRANT



schema i am using has the table but it never makes it to database

CREATE TABLE guacamole_entity (

  entity_id     serial                  NOT NULL,
  name          varchar(128)            NOT NULL,
  type          guacamole_entity_type   NOT NULL,

  PRIMARY KEY (entity_id),

  CONSTRAINT guacamole_entity_name_scope
    UNIQUE (type, name)

);



--
Sent from: http://apache-guacamole-general-user-mailing-list.2363388.n4.nabble.com/

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: olumn guacamole_entity.type does not exist

mjumper
Administrator
On Wed, Jul 8, 2020, 13:17 mamet007 <[hidden email]> wrote:
Using a fresh copy of RDS on AWS.  I initialized the schema few times already
here is the output of my 2nd attempt.

The script is not idempotent, and multiple initialization attempts will not be fresh. What was the output of your *first* attempt?

If only specific columns are not being created, in this case a column which uses a custom type, perhaps the user you are using to apply the schema lacks necessary permissions?

- Mike

Reply | Threaded
Open this post in threaded view
|

Re: olumn guacamole_entity.type does not exist

mjumper
Administrator
On Wed, Jul 8, 2020, 14:20 Mike Jumper <[hidden email]> wrote:
On Wed, Jul 8, 2020, 13:17 mamet007 <[hidden email]> wrote:
Using a fresh copy of RDS on AWS.  I initialized the schema few times already
here is the output of my 2nd attempt.

The script is not idempotent, and multiple initialization attempts will not be fresh. What was the output of your *first* attempt?

If only specific columns are not being created, in this case a column which uses a custom type, perhaps the user you are using to apply the schema lacks necessary permissions?

Also, from your previous message:

> psql:db_schema_tamplate_output.sql:27: ERROR:  type "guacamole_connection_group_db" already exists
> psql:db_schema_tamplate_output.sql:36: ERROR:  type "guacamole_entity_db" already exists
> ...
> psql:db_schema_tamplate_output.sql:737: ERROR:  role "guacadmin" already exists

What is this "db_schema_tamplate_output.sql"? Where is this "guacamole_connection_group_db" coming from and why does it think "guacadmin" is a role?

The provided schema scripts do not include types called "guacamole_connection_group_db" or "guacamole_entity_db" (they are "guacamole_connection_group_type" and "guacamole_entity_type"), and "guacadmin" is not a PostgreSQL user/role but a Guacamole user. To PostgreSQL, "guacadmin" would just be arbitrary string data in a table. It looks like the script you're using is not the schema that we've provided, but rather another script based on that schema which has been modified such that it is incorrect.

- Mike

Reply | Threaded
Open this post in threaded view
|

Re: olumn guacamole_entity.type does not exist

mamet007
I am automating the db initialization; I have a script that reads Shema file
and output it again withe the create user section with the passwords. I also
have another script that will pick up the output.sql file and initialize it
against the DB. using a  master password.  what I am about to do now is to
not to have my script open the schema file and initialize without the
section below, maybe my script is messing it up the schema when writes it
out.

----- Create none root user -------
CREATE USER xxxx WITH PASSWORD 'xxxxxx';
GRANT ALL PRIVILEGES ON DATABASE "xxxxx" to db_uidname;
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO xxxx;
GRANT usage, select on all sequences in schema public to xxxx;




--
Sent from: http://apache-guacamole-general-user-mailing-list.2363388.n4.nabble.com/

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: olumn guacamole_entity.type does not exist

mamet007
It was a copy of the schema that was causing the DB issue. now I am able to
login using AD credential but not the guacadmin user Postgres credentials.
however, I am able to login with the same user gauacadmin directly to the
Database but not through the application. any clues on to why? I need to log
in with postgress credentials once to set up the group permissions  .



--
Sent from: http://apache-guacamole-general-user-mailing-list.2363388.n4.nabble.com/

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: olumn guacamole_entity.type does not exist

vnick
On Wed, Jul 8, 2020 at 7:54 PM mamet007 <[hidden email]> wrote:
It was a copy of the schema that was causing the DB issue. now I am able to
login using AD credential but not the guacadmin user Postgres credentials.
however, I am able to login with the same user gauacadmin directly to the
Database but not through the application. any clues on to why? I need to log
in with postgress credentials once to set up the group permissions  .


This is what Mike mentioned before - whatever script you used converted that into a "CREATE ROLE" command in Postgres, which is *NOT* the same as creating a guacadmin user in Guacamole.  You need to get the second SQL script - 002-create-admin-user.sql - and run that against your Postgres database.

-Nick
Reply | Threaded
Open this post in threaded view
|

Re: olumn guacamole_entity.type does not exist

mamet007
Thank you!!! Thank you Mike sorry if I missed your first note!!!
 I have been at this for the past 48 hrs rebuilt the server about 10 times.
you guys are awsome!!!




--
Sent from: http://apache-guacamole-general-user-mailing-list.2363388.n4.nabble.com/

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]