On 10/5/2023 9:55 AM, maniardpa...@gmail.com wrote:
Respected members,
I am a self-funded student who has just installed (compiled version) of
the Apache Guacamole. I've taken a DB approach to authentication via
MariaDB. When accessing the Guacamole page (http://ip:8080/guacamole) I
get the following error:
"An error has occurred and this action cannot be completed. If the
problem persists, please notify your system administrator or check your
system logs."
I can see the following logs in /var/log/syslog when the request is
presented:
[Warning] Aborted connection 31 to db: 'unconnected' user:
'unauthenticated' host: 'localhost' (This connection closed normally
without authentication)
You will need to check the Tomcat logs. The location of the Tomcat logs
varies by who provided your Tomcat and how it was installed. Some Linux
distributions provide a "tomcat" package that logs to the systemd
journal, or you might have a version of Tomcat that logs to a
"catalina.out" file in its own dedicated log directory (commonly
"/var/log/tomcat", "/var/log/tomcat9", or similar).
I have attempted the following two connectors by placing them into the
/etc/guacamole/lib/ folder:
1. mysql-connector-j-8.1.0.jar
2. mariadb-java-client-1.8.0.jar
You should not put two versions of the MySQL/MariaDB driver in
/etc/guacamole/lib. You need to pick one and use only that driver.
I have further created the following links too:
1. ln -s /etc/guacamole /usr/share/tomcat/.guacamole && ln -s
/etc/guacamole/guacamole.war /usr/share/tomcat/webapps/
You do not need to create a link between "/etc/guacamole" and
"/usr/share/tomcat/.guacamole". The "/etc/guacamole" directory is the
default unless overridden. Creating that link effectively overrides
"/etc/guacamole" with "/usr/share/tomcat/.guacamole" ... which is just a
symlink back to the original default.
It shouldn't hurt anything, but it will make things needlessly confusing.
I would also not recommend placing the guacamole.war file within
/etc/guacamole. The /etc directory is meant for configuration files, and
placing the full webapp there is unusual. That said, doing so won't hurt
anything but my brain.
I have added DBs using:
1. mysql -u root -p guacamoledb <
/home/ra/guacamole-auth-jdbc/mysql/schema/001-create-schema.sql
2. mysql -u root -p guacamoledb <
/home/ra/guacamole-auth-jdbc/mysql/schema/002-create-admin-user.sql
I added it using the root password of the OS and not the MariaDB
password. I am not sure if this is what is causing the issue. When I am
retrying with MariaDB password, I am getting:
1. ERROR 1050 (42S01) at line 24: Table 'guacamole_connection_group'
already exists
2. ERROR 1062 (23000) at line 21: Duplicate entry 'USER-guacadmin' for
key 'guacamole_entity_name_scope'
I reckon this is where I am wrong, but I am uncertain. I have added a
username and password in the "/etc/guacamole/guacamole.properties" that
I did not use while adding the above configuration.
No, this shouldn't hurt anything, but the scripts cannot be run multiple
times against the same database. The errors you're seeing are due to the
database schema already having been applied.
This is not the cause of your trouble. The database exists and has the
expected tables, as shown by the errors complaining that the tables
already exist.
Following are the technical details:
1. Host type: VM
2. Host (technically guest) OS: Ubuntu Server 22.04.3 LTS
3. Apacha Guacamole version: 1.5.3
4. Tomcat version: 9
5. Java version: openjdk 11.0.20.1 2023-08-24
6. MariaDB version: mariadb Ver 15.1 Distrib 10.6.12-MariaDB, for
debian-linux-gnu (x86_64) using EditLine wrapper
What is the most optimal way to diagnose and rectify the error?
You need to locate your Tomcat logs and read through the messages from
Guacamole in those logs. If you're in the right place, there will be
numerous messages regarding the extensions in place, the directory being
used as the basis for Guacamole's configuration ("GUACAMOLE_HOME"), and
error messages regarding the failure that occurred.
If you don't see a ton of messages logged by Guacamole during its
startup procedures, you're in the wrong log.
- Mike
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscr...@guacamole.apache.org
For additional commands, e-mail: user-h...@guacamole.apache.org
