You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@guacamole.apache.org by Lance Gropper <La...@encorehollywood.com> on 2019/04/25 16:50:10 UTC

admin password not working

Hello All:

In 0.9.14, is there an admin GUI? guacadmin/guacadmin doesn't work.

Lance


This e-mail and any attachments are intended only for use by the addressee(s) named herein and may contain confidential information. If you are not the intended recipient of this e-mail, you are hereby notified any dissemination, distribution or copying of this email and any attachments is strictly prohibited. If you receive this email in error, please immediately notify the sender by return email and permanently delete the original, any copy and any printout thereof. The integrity and security of e-mail cannot be guaranteed.

Re: admin password not working

Posted by Nick Couchman <vn...@apache.org>.
On Thu, Apr 25, 2019 at 1:49 PM Lance Gropper <
Lance.Gropper@encorehollywood.com> wrote:

> So far, on /etc/guacamole - I had to create that and all files/folders in
> it after installing the server and client...
>
>
>
Yes, there is nothing pre-installed for that directory.

-Nick

RE: admin password not working

Posted by Lance Gropper <La...@encorehollywood.com>.
So far, on /etc/guacamole - I had to create that and all files/folders in it after installing the server and client...

From: Nick Couchman <vn...@apache.org>
Sent: Thursday, April 25, 2019 10:47 AM
To: user@guacamole.apache.org
Subject: Re: admin password not working


[ CAUTION ]

This email originated outside Deluxe.



On Thu, Apr 25, 2019 at 1:43 PM Lance Gropper <La...@encorehollywood.com>> wrote:
Hello Nick:

I'm working on it - I haven't done anything with SQL before (I'm trying this with postgresql). One thing I'm running into is in the instructions, it keeps referring to a folder called "GUACAMOLE_HOME" - where is this located? Many thanks for your help so far.

http://guacamole.apache.org/doc/gug/configuring-guacamole.html#guacamole-home<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fguacamole.apache.org%2Fdoc%2Fgug%2Fconfiguring-guacamole.html%23guacamole-home&data=02%7C01%7CLance.Gropper%40encorehollywood.com%7C4376d70990cb4f1191f608d6c9a60308%7C8688c7c41f2a4115a918361023dde469%7C1%7C0%7C636918112189638945&sdata=PHUm4zx8qLfBrI99mhcV2kdA%2F12W9Qk%2F%2B0%2BkIJRIZ0E%3D&reserved=0>

I use PostgreSQL routinely, so you shouldn't have any issues with that, but post back if you do.

-Nick



[ CAUTION ]

DO NOT open attachments or click links from unknown senders. Only respond if you can validate the senders legitimacy.




This e-mail and any attachments are intended only for use by the addressee(s) named herein and may contain confidential information. If you are not the intended recipient of this e-mail, you are hereby notified any dissemination, distribution or copying of this email and any attachments is strictly prohibited. If you receive this email in error, please immediately notify the sender by return email and permanently delete the original, any copy and any printout thereof. The integrity and security of e-mail cannot be guaranteed.

Re: admin password not working

Posted by Nick Couchman <vn...@apache.org>.
On Thu, Apr 25, 2019 at 2:36 PM Lance Gropper <
Lance.Gropper@encorehollywood.com> wrote:

> Where do you get the " schema/ directory containing PostgreSQL-specific
> SQL scripts required to set up the database"?
>
>
Assuming you downloaded Guacamole from the web page, it's in the tarball
file that contains the various JDBC extension - it contains the JAR files,
and also had schema files for each of the modules:

nick_couchman@linux-i0lj:~/Downloads/guacamole-auth-jdbc-1.0.0> ll
postgresql/
total 4908
-rw-r--r-- 1 nick_couchman 200513 5025782 Dec 21 16:22
guacamole-auth-jdbc-postgresql-1.0.0.jar
drwxr-xr-x 3 nick_couchman 200513      83 Dec 12 12:52 schema
nick_couchman@linux-i0lj:~/Downloads/guacamole-auth-jdbc-1.0.0> ll
postgresql/schema/
total 28
-rw-r--r-- 1 nick_couchman 200513 21749 Dec 12 12:52 001-create-schema.sql
-rw-r--r-- 1 nick_couchman 200513  2699 Dec 12 12:52
002-create-admin-user.sql
drwxr-xr-x 2 nick_couchman 200513   242 Apr 25 15:07 upgrade

-Nick

>

RE: admin password not working

Posted by Lance Gropper <La...@encorehollywood.com>.
Where do you get the " schema/ directory containing PostgreSQL-specific SQL scripts required to set up the database"?

From: Lance Gropper <La...@encorehollywood.com>
Sent: Thursday, April 25, 2019 11:25 AM
To: user@guacamole.apache.org
Subject: RE: admin password not working


[ CAUTION ]

This email originated outside Deluxe.



Hello Nick:

I'm stuck fighting a chicken/egg problem: When I tried to add a user for postgresql, it said it couldn't be done as a privileged user, so I created a non-privileged (system) user. When that user tries to add itself as a user on postgresql, it says the user has to be privileged user.

Lance

From: Lance Gropper
Sent: Thursday, April 25, 2019 11:05 AM
To: user@guacamole.apache.org
Subject: RE: admin password not working

Here's more from journalctl - following what it says farther below, postgresql is running, but I get this:

[root@guacamole-post system]# createdb guacamole_db
createdb: could not connect to database template1: FATAL:  role "root" does not exist

---farther below---

Apr 25 11:02:33 guacamole-post.post.ad polkitd[5966]: Registered Authentication Agent for unix-process:5476:7008494 (system bus name :1.333 [/usr/bin/pktty
Apr 25 11:02:33 guacamole-post.post.ad systemd[1]: Reloading.
Apr 25 11:02:33 guacamole-post.post.ad polkitd[5966]: Unregistered Authentication Agent for unix-process:5476:7008494 (system bus name :1.333, object path
Apr 25 11:02:38 guacamole-post.post.ad polkitd[5966]: Registered Authentication Agent for unix-process:5500:7009015 (system bus name :1.334 [/usr/bin/pktty
Apr 25 11:02:38 guacamole-post.post.ad systemd[1]: Starting PostgreSQL database server...
-- Subject: Unit postgresql.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit postgresql.service has begun starting up.
Apr 25 11:02:38 guacamole-post.post.ad postgresql-check-db-dir[5516]: "/var/lib/pgsql/data" is missing or empty.
Apr 25 11:02:38 guacamole-post.post.ad postgresql-check-db-dir[5516]: Use "postgresql-setup initdb" to initialize the database cluster.
Apr 25 11:02:38 guacamole-post.post.ad postgresql-check-db-dir[5516]: See /usr/share/doc/postgresql-9.2.24/README.rpm-dist for more information.
Apr 25 11:02:38 guacamole-post.post.ad polkitd[5966]: Unregistered Authentication Agent for unix-process:5500:7009015 (system bus name :1.334, object path
Apr 25 11:02:38 guacamole-post.post.ad systemd[1]: postgresql.service: control process exited, code=exited status=1
Apr 25 11:02:38 guacamole-post.post.ad systemd[1]: Failed to start PostgreSQL database server.
-- Subject: Unit postgresql.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit postgresql.service has failed.
--
-- The result is failed.
Apr 25 11:02:38 guacamole-post.post.ad systemd[1]: Unit postgresql.service entered failed state.
Apr 25 11:02:38 guacamole-post.post.ad systemd[1]: postgresql.service failed.

From: Lance Gropper
Sent: Thursday, April 25, 2019 11:01 AM
To: user@guacamole.apache.org
Subject: RE: admin password not working

I figured out part of it - I only had the postgresql client installed - not the server. Now with the server installed:

[root@guacamole-post system]# systemctl status postgresql.service
● postgresql.service - PostgreSQL database server
   Loaded: loaded (/usr/lib/systemd/system/postgresql.service; disabled; vendor preset: disabled)
   Active: failed (Result: exit-code) since Thu 2019-04-25 11:00:10 PDT; 10s ago
  Process: 5343 ExecStartPre=/usr/bin/postgresql-check-db-dir ${PGDATA} (code=exited, status=1/FAILURE)

Apr 25 11:00:10 guacamole-post.post.ad systemd[1]: Starting PostgreSQL database server...
Apr 25 11:00:10 guacamole-post.post.ad systemd[1]: postgresql.service: control process exited, code=exited status=1
Apr 25 11:00:10 guacamole-post.post.ad systemd[1]: Failed to start PostgreSQL database server.
Apr 25 11:00:10 guacamole-post.post.ad systemd[1]: Unit postgresql.service entered failed state.
Apr 25 11:00:10 guacamole-post.post.ad systemd[1]: postgresql.service failed.

From: Lance Gropper
Sent: Thursday, April 25, 2019 10:57 AM
To: 'user@guacamole.apache.org' <us...@guacamole.apache.org>
Subject: RE: admin password not working

[root@guacamole-post guacamole]# service postgresql start
Redirecting to /bin/systemctl start postgresql.service
Failed to start postgresql.service: Unit not found.
[root@guacamole-post guacamole]# systemctl start postgresql
Failed to start postgresql.service: Unit not found.

From: Lance Gropper
Sent: Thursday, April 25, 2019 10:54 AM
To: user@guacamole.apache.org
Subject: RE: admin password not working

So I have postgresql installed. How do I start it?

[root@guacamole-post init.d]# createdb guacamole_db
createdb: could not connect to database template1: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

From: Nick Couchman <vn...@apache.org>
Sent: Thursday, April 25, 2019 10:47 AM
To: user@guacamole.apache.org
Subject: Re: admin password not working


[ CAUTION ]

This email originated outside Deluxe.



On Thu, Apr 25, 2019 at 1:43 PM Lance Gropper <La...@encorehollywood.com>> wrote:
Hello Nick:

I'm working on it - I haven't done anything with SQL before (I'm trying this with postgresql). One thing I'm running into is in the instructions, it keeps referring to a folder called "GUACAMOLE_HOME" - where is this located? Many thanks for your help so far.

http://guacamole.apache.org/doc/gug/configuring-guacamole.html#guacamole-home<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fguacamole.apache.org%2Fdoc%2Fgug%2Fconfiguring-guacamole.html%23guacamole-home&data=02%7C01%7CLance.Gropper%40encorehollywood.com%7C92c05ad5dcb3491ca2c608d6c9aca021%7C8688c7c41f2a4115a918361023dde469%7C1%7C0%7C636918140601883811&sdata=EmB0ovwvReUJUzl8VGRRiQTnlCpFJXZqgC3ZDOFBllE%3D&reserved=0>

I use PostgreSQL routinely, so you shouldn't have any issues with that, but post back if you do.

-Nick



[ CAUTION ]

DO NOT open attachments or click links from unknown senders. Only respond if you can validate the senders legitimacy.



This e-mail and any attachments are intended only for use by the addressee(s) named herein and may contain confidential information. If you are not the intended recipient of this e-mail, you are hereby notified any dissemination, distribution or copying of this email and any attachments is strictly prohibited. If you receive this email in error, please immediately notify the sender by return email and permanently delete the original, any copy and any printout thereof. The integrity and security of e-mail cannot be guaranteed.



[ CAUTION ]

DO NOT open attachments or click links from unknown senders. Only respond if you can validate the senders legitimacy.




This e-mail and any attachments are intended only for use by the addressee(s) named herein and may contain confidential information. If you are not the intended recipient of this e-mail, you are hereby notified any dissemination, distribution or copying of this email and any attachments is strictly prohibited. If you receive this email in error, please immediately notify the sender by return email and permanently delete the original, any copy and any printout thereof. The integrity and security of e-mail cannot be guaranteed.

RE: admin password not working

Posted by Lance Gropper <La...@encorehollywood.com>.
Hello Nick:

I'm stuck fighting a chicken/egg problem: When I tried to add a user for postgresql, it said it couldn't be done as a privileged user, so I created a non-privileged (system) user. When that user tries to add itself as a user on postgresql, it says the user has to be privileged user.

Lance

From: Lance Gropper
Sent: Thursday, April 25, 2019 11:05 AM
To: user@guacamole.apache.org
Subject: RE: admin password not working

Here's more from journalctl - following what it says farther below, postgresql is running, but I get this:

[root@guacamole-post system]# createdb guacamole_db
createdb: could not connect to database template1: FATAL:  role "root" does not exist

---farther below---

Apr 25 11:02:33 guacamole-post.post.ad polkitd[5966]: Registered Authentication Agent for unix-process:5476:7008494 (system bus name :1.333 [/usr/bin/pktty
Apr 25 11:02:33 guacamole-post.post.ad systemd[1]: Reloading.
Apr 25 11:02:33 guacamole-post.post.ad polkitd[5966]: Unregistered Authentication Agent for unix-process:5476:7008494 (system bus name :1.333, object path
Apr 25 11:02:38 guacamole-post.post.ad polkitd[5966]: Registered Authentication Agent for unix-process:5500:7009015 (system bus name :1.334 [/usr/bin/pktty
Apr 25 11:02:38 guacamole-post.post.ad systemd[1]: Starting PostgreSQL database server...
-- Subject: Unit postgresql.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit postgresql.service has begun starting up.
Apr 25 11:02:38 guacamole-post.post.ad postgresql-check-db-dir[5516]: "/var/lib/pgsql/data" is missing or empty.
Apr 25 11:02:38 guacamole-post.post.ad postgresql-check-db-dir[5516]: Use "postgresql-setup initdb" to initialize the database cluster.
Apr 25 11:02:38 guacamole-post.post.ad postgresql-check-db-dir[5516]: See /usr/share/doc/postgresql-9.2.24/README.rpm-dist for more information.
Apr 25 11:02:38 guacamole-post.post.ad polkitd[5966]: Unregistered Authentication Agent for unix-process:5500:7009015 (system bus name :1.334, object path
Apr 25 11:02:38 guacamole-post.post.ad systemd[1]: postgresql.service: control process exited, code=exited status=1
Apr 25 11:02:38 guacamole-post.post.ad systemd[1]: Failed to start PostgreSQL database server.
-- Subject: Unit postgresql.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit postgresql.service has failed.
--
-- The result is failed.
Apr 25 11:02:38 guacamole-post.post.ad systemd[1]: Unit postgresql.service entered failed state.
Apr 25 11:02:38 guacamole-post.post.ad systemd[1]: postgresql.service failed.

From: Lance Gropper
Sent: Thursday, April 25, 2019 11:01 AM
To: user@guacamole.apache.org
Subject: RE: admin password not working

I figured out part of it - I only had the postgresql client installed - not the server. Now with the server installed:

[root@guacamole-post system]# systemctl status postgresql.service
● postgresql.service - PostgreSQL database server
   Loaded: loaded (/usr/lib/systemd/system/postgresql.service; disabled; vendor preset: disabled)
   Active: failed (Result: exit-code) since Thu 2019-04-25 11:00:10 PDT; 10s ago
  Process: 5343 ExecStartPre=/usr/bin/postgresql-check-db-dir ${PGDATA} (code=exited, status=1/FAILURE)

Apr 25 11:00:10 guacamole-post.post.ad systemd[1]: Starting PostgreSQL database server...
Apr 25 11:00:10 guacamole-post.post.ad systemd[1]: postgresql.service: control process exited, code=exited status=1
Apr 25 11:00:10 guacamole-post.post.ad systemd[1]: Failed to start PostgreSQL database server.
Apr 25 11:00:10 guacamole-post.post.ad systemd[1]: Unit postgresql.service entered failed state.
Apr 25 11:00:10 guacamole-post.post.ad systemd[1]: postgresql.service failed.

From: Lance Gropper
Sent: Thursday, April 25, 2019 10:57 AM
To: 'user@guacamole.apache.org' <us...@guacamole.apache.org>
Subject: RE: admin password not working

[root@guacamole-post guacamole]# service postgresql start
Redirecting to /bin/systemctl start postgresql.service
Failed to start postgresql.service: Unit not found.
[root@guacamole-post guacamole]# systemctl start postgresql
Failed to start postgresql.service: Unit not found.

From: Lance Gropper
Sent: Thursday, April 25, 2019 10:54 AM
To: user@guacamole.apache.org
Subject: RE: admin password not working

So I have postgresql installed. How do I start it?

[root@guacamole-post init.d]# createdb guacamole_db
createdb: could not connect to database template1: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

From: Nick Couchman <vn...@apache.org>
Sent: Thursday, April 25, 2019 10:47 AM
To: user@guacamole.apache.org
Subject: Re: admin password not working


[ CAUTION ]

This email originated outside Deluxe.



On Thu, Apr 25, 2019 at 1:43 PM Lance Gropper <La...@encorehollywood.com>> wrote:
Hello Nick:

I'm working on it - I haven't done anything with SQL before (I'm trying this with postgresql). One thing I'm running into is in the instructions, it keeps referring to a folder called "GUACAMOLE_HOME" - where is this located? Many thanks for your help so far.

http://guacamole.apache.org/doc/gug/configuring-guacamole.html#guacamole-home<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fguacamole.apache.org%2Fdoc%2Fgug%2Fconfiguring-guacamole.html%23guacamole-home&data=02%7C01%7CLance.Gropper%40encorehollywood.com%7C4376d70990cb4f1191f608d6c9a60308%7C8688c7c41f2a4115a918361023dde469%7C1%7C0%7C636918112189638945&sdata=PHUm4zx8qLfBrI99mhcV2kdA%2F12W9Qk%2F%2B0%2BkIJRIZ0E%3D&reserved=0>

I use PostgreSQL routinely, so you shouldn't have any issues with that, but post back if you do.

-Nick



[ CAUTION ]

DO NOT open attachments or click links from unknown senders. Only respond if you can validate the senders legitimacy.




This e-mail and any attachments are intended only for use by the addressee(s) named herein and may contain confidential information. If you are not the intended recipient of this e-mail, you are hereby notified any dissemination, distribution or copying of this email and any attachments is strictly prohibited. If you receive this email in error, please immediately notify the sender by return email and permanently delete the original, any copy and any printout thereof. The integrity and security of e-mail cannot be guaranteed.

RE: admin password not working

Posted by Lance Gropper <La...@encorehollywood.com>.
Here's more from journalctl - following what it says farther below, postgresql is running, but I get this:

[root@guacamole-post system]# createdb guacamole_db
createdb: could not connect to database template1: FATAL:  role "root" does not exist

---farther below---

Apr 25 11:02:33 guacamole-post.post.ad polkitd[5966]: Registered Authentication Agent for unix-process:5476:7008494 (system bus name :1.333 [/usr/bin/pktty
Apr 25 11:02:33 guacamole-post.post.ad systemd[1]: Reloading.
Apr 25 11:02:33 guacamole-post.post.ad polkitd[5966]: Unregistered Authentication Agent for unix-process:5476:7008494 (system bus name :1.333, object path
Apr 25 11:02:38 guacamole-post.post.ad polkitd[5966]: Registered Authentication Agent for unix-process:5500:7009015 (system bus name :1.334 [/usr/bin/pktty
Apr 25 11:02:38 guacamole-post.post.ad systemd[1]: Starting PostgreSQL database server...
-- Subject: Unit postgresql.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit postgresql.service has begun starting up.
Apr 25 11:02:38 guacamole-post.post.ad postgresql-check-db-dir[5516]: "/var/lib/pgsql/data" is missing or empty.
Apr 25 11:02:38 guacamole-post.post.ad postgresql-check-db-dir[5516]: Use "postgresql-setup initdb" to initialize the database cluster.
Apr 25 11:02:38 guacamole-post.post.ad postgresql-check-db-dir[5516]: See /usr/share/doc/postgresql-9.2.24/README.rpm-dist for more information.
Apr 25 11:02:38 guacamole-post.post.ad polkitd[5966]: Unregistered Authentication Agent for unix-process:5500:7009015 (system bus name :1.334, object path
Apr 25 11:02:38 guacamole-post.post.ad systemd[1]: postgresql.service: control process exited, code=exited status=1
Apr 25 11:02:38 guacamole-post.post.ad systemd[1]: Failed to start PostgreSQL database server.
-- Subject: Unit postgresql.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit postgresql.service has failed.
--
-- The result is failed.
Apr 25 11:02:38 guacamole-post.post.ad systemd[1]: Unit postgresql.service entered failed state.
Apr 25 11:02:38 guacamole-post.post.ad systemd[1]: postgresql.service failed.

From: Lance Gropper
Sent: Thursday, April 25, 2019 11:01 AM
To: user@guacamole.apache.org
Subject: RE: admin password not working

I figured out part of it - I only had the postgresql client installed - not the server. Now with the server installed:

[root@guacamole-post system]# systemctl status postgresql.service
● postgresql.service - PostgreSQL database server
   Loaded: loaded (/usr/lib/systemd/system/postgresql.service; disabled; vendor preset: disabled)
   Active: failed (Result: exit-code) since Thu 2019-04-25 11:00:10 PDT; 10s ago
  Process: 5343 ExecStartPre=/usr/bin/postgresql-check-db-dir ${PGDATA} (code=exited, status=1/FAILURE)

Apr 25 11:00:10 guacamole-post.post.ad systemd[1]: Starting PostgreSQL database server...
Apr 25 11:00:10 guacamole-post.post.ad systemd[1]: postgresql.service: control process exited, code=exited status=1
Apr 25 11:00:10 guacamole-post.post.ad systemd[1]: Failed to start PostgreSQL database server.
Apr 25 11:00:10 guacamole-post.post.ad systemd[1]: Unit postgresql.service entered failed state.
Apr 25 11:00:10 guacamole-post.post.ad systemd[1]: postgresql.service failed.

From: Lance Gropper
Sent: Thursday, April 25, 2019 10:57 AM
To: 'user@guacamole.apache.org' <us...@guacamole.apache.org>
Subject: RE: admin password not working

[root@guacamole-post guacamole]# service postgresql start
Redirecting to /bin/systemctl start postgresql.service
Failed to start postgresql.service: Unit not found.
[root@guacamole-post guacamole]# systemctl start postgresql
Failed to start postgresql.service: Unit not found.

From: Lance Gropper
Sent: Thursday, April 25, 2019 10:54 AM
To: user@guacamole.apache.org
Subject: RE: admin password not working

So I have postgresql installed. How do I start it?

[root@guacamole-post init.d]# createdb guacamole_db
createdb: could not connect to database template1: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

From: Nick Couchman <vn...@apache.org>
Sent: Thursday, April 25, 2019 10:47 AM
To: user@guacamole.apache.org
Subject: Re: admin password not working


[ CAUTION ]

This email originated outside Deluxe.



On Thu, Apr 25, 2019 at 1:43 PM Lance Gropper <La...@encorehollywood.com>> wrote:
Hello Nick:

I'm working on it - I haven't done anything with SQL before (I'm trying this with postgresql). One thing I'm running into is in the instructions, it keeps referring to a folder called "GUACAMOLE_HOME" - where is this located? Many thanks for your help so far.

http://guacamole.apache.org/doc/gug/configuring-guacamole.html#guacamole-home<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fguacamole.apache.org%2Fdoc%2Fgug%2Fconfiguring-guacamole.html%23guacamole-home&data=02%7C01%7CLance.Gropper%40encorehollywood.com%7C4376d70990cb4f1191f608d6c9a60308%7C8688c7c41f2a4115a918361023dde469%7C1%7C0%7C636918112189638945&sdata=PHUm4zx8qLfBrI99mhcV2kdA%2F12W9Qk%2F%2B0%2BkIJRIZ0E%3D&reserved=0>

I use PostgreSQL routinely, so you shouldn't have any issues with that, but post back if you do.

-Nick



[ CAUTION ]

DO NOT open attachments or click links from unknown senders. Only respond if you can validate the senders legitimacy.




This e-mail and any attachments are intended only for use by the addressee(s) named herein and may contain confidential information. If you are not the intended recipient of this e-mail, you are hereby notified any dissemination, distribution or copying of this email and any attachments is strictly prohibited. If you receive this email in error, please immediately notify the sender by return email and permanently delete the original, any copy and any printout thereof. The integrity and security of e-mail cannot be guaranteed.

Re: admin password not working

Posted by Nick Couchman <vn...@apache.org>.
On Thu, Apr 25, 2019 at 2:01 PM Lance Gropper <
Lance.Gropper@encorehollywood.com> wrote:

> I figured out part of it - I only had the postgresql client installed -
> not the server. Now with the server installed:
>
>
>
> [root@guacamole-post system]# systemctl status postgresql.service
>
> ● postgresql.service - PostgreSQL database server
>
>    Loaded: loaded (/usr/lib/systemd/system/postgresql.service; disabled;
> vendor preset: disabled)
>
>    Active: failed (Result: exit-code) since Thu 2019-04-25 11:00:10 PDT;
> 10s ago
>
>   Process: 5343 ExecStartPre=/usr/bin/postgresql-check-db-dir ${PGDATA}
> (code=exited, status=1/FAILURE)
>
>
IIRC you have to initialize the database, first.  Where the command is
varies based on Postgres version and distribution, but might be something
as simple as "initdb".  Then try starting the service.

-Nick


>

RE: admin password not working

Posted by Lance Gropper <La...@encorehollywood.com>.
I figured out part of it - I only had the postgresql client installed - not the server. Now with the server installed:

[root@guacamole-post system]# systemctl status postgresql.service
● postgresql.service - PostgreSQL database server
   Loaded: loaded (/usr/lib/systemd/system/postgresql.service; disabled; vendor preset: disabled)
   Active: failed (Result: exit-code) since Thu 2019-04-25 11:00:10 PDT; 10s ago
  Process: 5343 ExecStartPre=/usr/bin/postgresql-check-db-dir ${PGDATA} (code=exited, status=1/FAILURE)

Apr 25 11:00:10 guacamole-post.post.ad systemd[1]: Starting PostgreSQL database server...
Apr 25 11:00:10 guacamole-post.post.ad systemd[1]: postgresql.service: control process exited, code=exited status=1
Apr 25 11:00:10 guacamole-post.post.ad systemd[1]: Failed to start PostgreSQL database server.
Apr 25 11:00:10 guacamole-post.post.ad systemd[1]: Unit postgresql.service entered failed state.
Apr 25 11:00:10 guacamole-post.post.ad systemd[1]: postgresql.service failed.

From: Lance Gropper
Sent: Thursday, April 25, 2019 10:57 AM
To: 'user@guacamole.apache.org' <us...@guacamole.apache.org>
Subject: RE: admin password not working

[root@guacamole-post guacamole]# service postgresql start
Redirecting to /bin/systemctl start postgresql.service
Failed to start postgresql.service: Unit not found.
[root@guacamole-post guacamole]# systemctl start postgresql
Failed to start postgresql.service: Unit not found.

From: Lance Gropper
Sent: Thursday, April 25, 2019 10:54 AM
To: user@guacamole.apache.org
Subject: RE: admin password not working

So I have postgresql installed. How do I start it?

[root@guacamole-post init.d]# createdb guacamole_db
createdb: could not connect to database template1: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

From: Nick Couchman <vn...@apache.org>
Sent: Thursday, April 25, 2019 10:47 AM
To: user@guacamole.apache.org
Subject: Re: admin password not working


[ CAUTION ]

This email originated outside Deluxe.



On Thu, Apr 25, 2019 at 1:43 PM Lance Gropper <La...@encorehollywood.com>> wrote:
Hello Nick:

I'm working on it - I haven't done anything with SQL before (I'm trying this with postgresql). One thing I'm running into is in the instructions, it keeps referring to a folder called "GUACAMOLE_HOME" - where is this located? Many thanks for your help so far.

http://guacamole.apache.org/doc/gug/configuring-guacamole.html#guacamole-home<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fguacamole.apache.org%2Fdoc%2Fgug%2Fconfiguring-guacamole.html%23guacamole-home&data=02%7C01%7CLance.Gropper%40encorehollywood.com%7C4376d70990cb4f1191f608d6c9a60308%7C8688c7c41f2a4115a918361023dde469%7C1%7C0%7C636918112189638945&sdata=PHUm4zx8qLfBrI99mhcV2kdA%2F12W9Qk%2F%2B0%2BkIJRIZ0E%3D&reserved=0>

I use PostgreSQL routinely, so you shouldn't have any issues with that, but post back if you do.

-Nick



[ CAUTION ]

DO NOT open attachments or click links from unknown senders. Only respond if you can validate the senders legitimacy.




This e-mail and any attachments are intended only for use by the addressee(s) named herein and may contain confidential information. If you are not the intended recipient of this e-mail, you are hereby notified any dissemination, distribution or copying of this email and any attachments is strictly prohibited. If you receive this email in error, please immediately notify the sender by return email and permanently delete the original, any copy and any printout thereof. The integrity and security of e-mail cannot be guaranteed.

RE: admin password not working

Posted by Lance Gropper <La...@encorehollywood.com>.
[root@guacamole-post guacamole]# service postgresql start
Redirecting to /bin/systemctl start postgresql.service
Failed to start postgresql.service: Unit not found.
[root@guacamole-post guacamole]# systemctl start postgresql
Failed to start postgresql.service: Unit not found.

From: Lance Gropper
Sent: Thursday, April 25, 2019 10:54 AM
To: user@guacamole.apache.org
Subject: RE: admin password not working

So I have postgresql installed. How do I start it?

[root@guacamole-post init.d]# createdb guacamole_db
createdb: could not connect to database template1: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

From: Nick Couchman <vn...@apache.org>
Sent: Thursday, April 25, 2019 10:47 AM
To: user@guacamole.apache.org
Subject: Re: admin password not working


[ CAUTION ]

This email originated outside Deluxe.



On Thu, Apr 25, 2019 at 1:43 PM Lance Gropper <La...@encorehollywood.com>> wrote:
Hello Nick:

I'm working on it - I haven't done anything with SQL before (I'm trying this with postgresql). One thing I'm running into is in the instructions, it keeps referring to a folder called "GUACAMOLE_HOME" - where is this located? Many thanks for your help so far.

http://guacamole.apache.org/doc/gug/configuring-guacamole.html#guacamole-home<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fguacamole.apache.org%2Fdoc%2Fgug%2Fconfiguring-guacamole.html%23guacamole-home&data=02%7C01%7CLance.Gropper%40encorehollywood.com%7C4376d70990cb4f1191f608d6c9a60308%7C8688c7c41f2a4115a918361023dde469%7C1%7C0%7C636918112189638945&sdata=PHUm4zx8qLfBrI99mhcV2kdA%2F12W9Qk%2F%2B0%2BkIJRIZ0E%3D&reserved=0>

I use PostgreSQL routinely, so you shouldn't have any issues with that, but post back if you do.

-Nick



[ CAUTION ]

DO NOT open attachments or click links from unknown senders. Only respond if you can validate the senders legitimacy.




This e-mail and any attachments are intended only for use by the addressee(s) named herein and may contain confidential information. If you are not the intended recipient of this e-mail, you are hereby notified any dissemination, distribution or copying of this email and any attachments is strictly prohibited. If you receive this email in error, please immediately notify the sender by return email and permanently delete the original, any copy and any printout thereof. The integrity and security of e-mail cannot be guaranteed.

RE: admin password not working

Posted by Lance Gropper <La...@encorehollywood.com>.
So I have postgresql installed. How do I start it?

[root@guacamole-post init.d]# createdb guacamole_db
createdb: could not connect to database template1: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

From: Nick Couchman <vn...@apache.org>
Sent: Thursday, April 25, 2019 10:47 AM
To: user@guacamole.apache.org
Subject: Re: admin password not working


[ CAUTION ]

This email originated outside Deluxe.



On Thu, Apr 25, 2019 at 1:43 PM Lance Gropper <La...@encorehollywood.com>> wrote:
Hello Nick:

I'm working on it - I haven't done anything with SQL before (I'm trying this with postgresql). One thing I'm running into is in the instructions, it keeps referring to a folder called "GUACAMOLE_HOME" - where is this located? Many thanks for your help so far.

http://guacamole.apache.org/doc/gug/configuring-guacamole.html#guacamole-home<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fguacamole.apache.org%2Fdoc%2Fgug%2Fconfiguring-guacamole.html%23guacamole-home&data=02%7C01%7CLance.Gropper%40encorehollywood.com%7C4376d70990cb4f1191f608d6c9a60308%7C8688c7c41f2a4115a918361023dde469%7C1%7C0%7C636918112189638945&sdata=PHUm4zx8qLfBrI99mhcV2kdA%2F12W9Qk%2F%2B0%2BkIJRIZ0E%3D&reserved=0>

I use PostgreSQL routinely, so you shouldn't have any issues with that, but post back if you do.

-Nick



[ CAUTION ]

DO NOT open attachments or click links from unknown senders. Only respond if you can validate the senders legitimacy.




This e-mail and any attachments are intended only for use by the addressee(s) named herein and may contain confidential information. If you are not the intended recipient of this e-mail, you are hereby notified any dissemination, distribution or copying of this email and any attachments is strictly prohibited. If you receive this email in error, please immediately notify the sender by return email and permanently delete the original, any copy and any printout thereof. The integrity and security of e-mail cannot be guaranteed.

Re: admin password not working

Posted by Nick Couchman <vn...@apache.org>.
On Thu, Apr 25, 2019 at 1:43 PM Lance Gropper <
Lance.Gropper@encorehollywood.com> wrote:

> Hello Nick:
>
>
>
> I'm working on it - I haven't done anything with SQL before (I'm trying
> this with postgresql). One thing I'm running into is in the instructions,
> it keeps referring to a folder called "GUACAMOLE_HOME" - where is this
> located? Many thanks for your help so far.
>

http://guacamole.apache.org/doc/gug/configuring-guacamole.html#guacamole-home

I use PostgreSQL routinely, so you shouldn't have any issues with that, but
post back if you do.

-Nick

>

RE: admin password not working

Posted by Lance Gropper <La...@encorehollywood.com>.
Hello Nick:

I'm working on it - I haven't done anything with SQL before (I'm trying this with postgresql). One thing I'm running into is in the instructions, it keeps referring to a folder called "GUACAMOLE_HOME" - where is this located? Many thanks for your help so far.

Lance

From: Nick Couchman <vn...@apache.org>
Sent: Thursday, April 25, 2019 10:41 AM
To: user@guacamole.apache.org
Subject: Re: admin password not working


[ CAUTION ]

This email originated outside Deluxe.



On Thu, Apr 25, 2019 at 1:38 PM Lance Gropper <La...@encorehollywood.com>> wrote:
I think I need a user-mapping.xml entry for guacadmin...


If that's how you're managing connections, then, yes; please keep in mind though, that creating a guacadmin entry in user-mapping.xml will not get you an administrative user in the same sense as when you create it within the JDBC module - so, you won't be able to create entries for the user-mapping.xml file from within the Guacamole interface, you will have to manually manage that file with a text editor, script, etc.  The full administrative capability of the Guacamole interface is only implemented from the JDBC module.

-Nick



[ CAUTION ]

DO NOT open attachments or click links from unknown senders. Only respond if you can validate the senders legitimacy.




This e-mail and any attachments are intended only for use by the addressee(s) named herein and may contain confidential information. If you are not the intended recipient of this e-mail, you are hereby notified any dissemination, distribution or copying of this email and any attachments is strictly prohibited. If you receive this email in error, please immediately notify the sender by return email and permanently delete the original, any copy and any printout thereof. The integrity and security of e-mail cannot be guaranteed.

Re: admin password not working

Posted by Nick Couchman <vn...@apache.org>.
On Thu, Apr 25, 2019 at 1:38 PM Lance Gropper <
Lance.Gropper@encorehollywood.com> wrote:

> I think I need a user-mapping.xml entry for guacadmin...
>
>
>

If that's how you're managing connections, then, yes; please keep in mind
though, that creating a guacadmin entry in user-mapping.xml will not get
you an administrative user in the same sense as when you create it within
the JDBC module - so, you won't be able to create entries for the
user-mapping.xml file from within the Guacamole interface, you will have to
manually manage that file with a text editor, script, etc.  The full
administrative capability of the Guacamole interface is only implemented
from the JDBC module.

-Nick

RE: admin password not working

Posted by Lance Gropper <La...@encorehollywood.com>.
I think I need a user-mapping.xml entry for guacadmin...

From: Lance Gropper <La...@encorehollywood.com>
Sent: Thursday, April 25, 2019 10:26 AM
To: user@guacamole.apache.org
Subject: RE: admin password not working


[ CAUTION ]

This email originated outside Deluxe.



Hello Nick:

Per the user manual, database authentication is optional...

Lance

From: Nick Couchman <vn...@apache.org>
Sent: Thursday, April 25, 2019 10:22 AM
To: user@guacamole.apache.org
Subject: Re: admin password not working


[ CAUTION ]

This email originated outside Deluxe.



On Thu, Apr 25, 2019 at 12:50 PM Lance Gropper <La...@encorehollywood.com>> wrote:
Hello All:

In 0.9.14, is there an admin GUI? guacadmin/guacadmin doesn't work.

Yes, but you need to make sure of a couple of things:
1) You're using the JDBC authentication module
2) You've imported both of the SQL files - 001 for the schema itself, and 002 for the default admin user.

-Nick



[ CAUTION ]

DO NOT open attachments or click links from unknown senders. Only respond if you can validate the senders legitimacy.



This e-mail and any attachments are intended only for use by the addressee(s) named herein and may contain confidential information. If you are not the intended recipient of this e-mail, you are hereby notified any dissemination, distribution or copying of this email and any attachments is strictly prohibited. If you receive this email in error, please immediately notify the sender by return email and permanently delete the original, any copy and any printout thereof. The integrity and security of e-mail cannot be guaranteed.



[ CAUTION ]

DO NOT open attachments or click links from unknown senders. Only respond if you can validate the senders legitimacy.




This e-mail and any attachments are intended only for use by the addressee(s) named herein and may contain confidential information. If you are not the intended recipient of this e-mail, you are hereby notified any dissemination, distribution or copying of this email and any attachments is strictly prohibited. If you receive this email in error, please immediately notify the sender by return email and permanently delete the original, any copy and any printout thereof. The integrity and security of e-mail cannot be guaranteed.

Re: admin password not working

Posted by Nick Couchman <vn...@apache.org>.
On Thu, Apr 25, 2019 at 1:25 PM Lance Gropper <
Lance.Gropper@encorehollywood.com> wrote:

> Hello Nick:
>
>
>
> Per the user manual, database authentication is optional...
>

Yes, that's correct; however, complete administration of Guacamole is only
implemented in the JDBC authentication module.

If you don't install any extra authentication modules, it will use the
user-mapping.xml file, where you define the username/password combinations
within that file, and you also define connection information:
http://guacamole.apache.org/doc/gug/configuring-guacamole.html#user-mapping

If you install the LDAP authentication module, then all of your
administration is done within your LDAP tree and whatever tools you use to
manage that, and Guacamole simply pulls that information in upon
authentication by a LDAP user:
http://guacamole.apache.org/doc/gug/ldap-auth.html#ldap-auth-schema

If you install the JDBC module, authentication and connection information
is stored within the database, and you can manage the connections, users,
groups, etc., from within the Guacamole application.

You can also combine modules, like LDAP and JDBC, such that connections are
stored within JDBC but user authentication is done through LDAP:
http://guacamole.apache.org/doc/gug/ldap-auth.html#ldap-and-database

-Nick

>

RE: admin password not working

Posted by Lance Gropper <La...@encorehollywood.com>.
Hello Nick:

Per the user manual, database authentication is optional...

Lance

From: Nick Couchman <vn...@apache.org>
Sent: Thursday, April 25, 2019 10:22 AM
To: user@guacamole.apache.org
Subject: Re: admin password not working


[ CAUTION ]

This email originated outside Deluxe.



On Thu, Apr 25, 2019 at 12:50 PM Lance Gropper <La...@encorehollywood.com>> wrote:
Hello All:

In 0.9.14, is there an admin GUI? guacadmin/guacadmin doesn't work.

Yes, but you need to make sure of a couple of things:
1) You're using the JDBC authentication module
2) You've imported both of the SQL files - 001 for the schema itself, and 002 for the default admin user.

-Nick



[ CAUTION ]

DO NOT open attachments or click links from unknown senders. Only respond if you can validate the senders legitimacy.




This e-mail and any attachments are intended only for use by the addressee(s) named herein and may contain confidential information. If you are not the intended recipient of this e-mail, you are hereby notified any dissemination, distribution or copying of this email and any attachments is strictly prohibited. If you receive this email in error, please immediately notify the sender by return email and permanently delete the original, any copy and any printout thereof. The integrity and security of e-mail cannot be guaranteed.

Re: admin password not working

Posted by Nick Couchman <vn...@apache.org>.
On Thu, Apr 25, 2019 at 12:50 PM Lance Gropper <
Lance.Gropper@encorehollywood.com> wrote:

> Hello All:
>
>
>
> In 0.9.14, is there an admin GUI? guacadmin/guacadmin doesn't work.
>

Yes, but you need to make sure of a couple of things:
1) You're using the JDBC authentication module
2) You've imported both of the SQL files - 001 for the schema itself, and
002 for the default admin user.

-Nick

>

RE: admin password not working

Posted by Lance Gropper <La...@encorehollywood.com>.
Doesn't open with http either...

-----Original Message-----
From: sciUser <sh...@securitycentric.net>
Sent: Thursday, April 25, 2019 10:24 AM
To: user@guacamole.apache.org
Subject: RE: admin password not working

[ CAUTION ]

This email originated outside Deluxe.




My apologies, I just updated it on the post, its http not https



--
Sent from: https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fapache-guacamole-general-user-mailing-list.2363388.n4.nabble.com%2F&amp;data=02%7C01%7CLance.Gropper%40encorehollywood.com%7Cb9fc9fc748c54abaf73008d6c9a4335f%7C8688c7c41f2a4115a918361023dde469%7C1%7C0%7C636918104407625431&amp;sdata=IJlC7B1tSDX7vnnWrNEMbKMi4PU5KtOHKvWZMNZJeiw%3D&amp;reserved=0


[ CAUTION ]

DO NOT open attachments or click links from unknown senders. Only respond if you can validate the senders legitimacy.



This e-mail and any attachments are intended only for use by the addressee(s) named herein and may contain confidential information. If you are not the intended recipient of this e-mail, you are hereby notified any dissemination, distribution or copying of this email and any attachments is strictly prohibited. If you receive this email in error, please immediately notify the sender by return email and permanently delete the original, any copy and any printout thereof. The integrity and security of e-mail cannot be guaranteed.

RE: admin password not working

Posted by sciUser <sh...@securitycentric.net>.
My apologies, I just updated it on the post, its http not https



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

RE: admin password not working

Posted by Lance Gropper <La...@encorehollywood.com>.
Hello:

The link you provided won't open. Default username and password isn't working for me...

-----Original Message-----
From: sciUser <sh...@securitycentric.net>
Sent: Thursday, April 25, 2019 10:19 AM
To: user@guacamole.apache.org
Subject: Re: admin password not working

[ CAUTION ]

This email originated outside Deluxe.




Hello Lance,

If you are using 9.14 and having issues with your copy, try the pre-built appliance at https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fguacamole.securitycentric.net%2Fappliance%2F&amp;data=02%7C01%7CLance.Gropper%40encorehollywood.com%7C6d1df7580acf4d6b60c708d6c9a22366%7C8688c7c41f2a4115a918361023dde469%7C1%7C0%7C636918095549910347&amp;sdata=ZuiLRBejc2rLoraDOt8L2ky%2BENTR1c14dCr6lNacYaY%3D&amp;reserved=0

Both Vmware and Xenserver versions, these work out of the box.

But to answer your question generally guacadmin is both username and password for default installs.
Thank You




--
Sent from: https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fapache-guacamole-general-user-mailing-list.2363388.n4.nabble.com%2F&amp;data=02%7C01%7CLance.Gropper%40encorehollywood.com%7C6d1df7580acf4d6b60c708d6c9a22366%7C8688c7c41f2a4115a918361023dde469%7C1%7C0%7C636918095549910347&amp;sdata=%2F69ccwM7kzThQxVm%2BmCp1QWdhW9BXzs4bay8%2F2MaNFU%3D&amp;reserved=0


[ CAUTION ]

DO NOT open attachments or click links from unknown senders. Only respond if you can validate the senders legitimacy.



This e-mail and any attachments are intended only for use by the addressee(s) named herein and may contain confidential information. If you are not the intended recipient of this e-mail, you are hereby notified any dissemination, distribution or copying of this email and any attachments is strictly prohibited. If you receive this email in error, please immediately notify the sender by return email and permanently delete the original, any copy and any printout thereof. The integrity and security of e-mail cannot be guaranteed.

Re: admin password not working

Posted by sciUser <sh...@securitycentric.net>.
Hello Lance,

If you are using 9.14 and having issues with your copy, try the pre-built
appliance at https://guacamole.securitycentric.net/appliance/

Both Vmware and Xenserver versions, these work out of the box.

But to answer your question generally guacadmin is both username and
password for default installs.
Thank You




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