You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@guacamole.apache.org by mamet007 <mo...@gmail.com> on 2020/07/08 20:02:55 UTC
olumn guacamole_entity.type does not exist
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: user-unsubscribe@guacamole.apache.org
For additional commands, e-mail: user-help@guacamole.apache.org
Re: olumn guacamole_entity.type does not exist
Posted by mamet007 <mo...@gmail.com>.
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: user-unsubscribe@guacamole.apache.org
For additional commands, e-mail: user-help@guacamole.apache.org
Re: olumn guacamole_entity.type does not exist
Posted by Nick Couchman <vn...@apache.org>.
On Wed, Jul 8, 2020 at 7:54 PM mamet007 <mo...@gmail.com> 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
Re: olumn guacamole_entity.type does not exist
Posted by mamet007 <mo...@gmail.com>.
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: user-unsubscribe@guacamole.apache.org
For additional commands, e-mail: user-help@guacamole.apache.org
Re: olumn guacamole_entity.type does not exist
Posted by mamet007 <mo...@gmail.com>.
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: user-unsubscribe@guacamole.apache.org
For additional commands, e-mail: user-help@guacamole.apache.org
Re: olumn guacamole_entity.type does not exist
Posted by Mike Jumper <mj...@apache.org>.
On Wed, Jul 8, 2020, 14:20 Mike Jumper <mj...@apache.org> wrote:
> On Wed, Jul 8, 2020, 13:17 mamet007 <mo...@gmail.com> 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
Re: olumn guacamole_entity.type does not exist
Posted by Mike Jumper <mj...@apache.org>.
On Wed, Jul 8, 2020, 13:17 mamet007 <mo...@gmail.com> 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
Re: olumn guacamole_entity.type does not exist
Posted by mamet007 <mo...@gmail.com>.
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: user-unsubscribe@guacamole.apache.org
For additional commands, e-mail: user-help@guacamole.apache.org
Re: olumn guacamole_entity.type does not exist
Posted by Nick Couchman <vn...@apache.org>.
On Wed, Jul 8, 2020 at 4:03 PM mamet007 <mo...@gmail.com> 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