[
https://issues.apache.org/jira/browse/GUACAMOLE-215?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Michael Jumper resolved GUACAMOLE-215.
--------------------------------------
Resolution: Invalid
The PostgreSQL JDBC driver .jar is definitely loaded from GUACAMOLE_HOME/lib/
if present.
If you're not seeing this happen, please verify that:
# GUACAMOLE_HOME is actually the location you expect.
# If you do not wish to use the default GUACAMOLE_HOME location (the
".guacamole" directory within the home directory of the user running your
servlet container), verify that GUACAMOLE_HOME is actually being overridden as
expected. Tomcat, for example, will not read environment variables from
/etc/profile or similar; the service starts with a clean environment, and
additional environment variables require very specific steps to be set.
# SELinux is not blocking the loading of the PostgreSQL JDBC driver. "/etc" is
a good location for config files, but is an extremely odd location to keep
libraries. Given that GUACAMOLE_HOME contains config files *and* libraries,
"/etc/guacamole" is a poor choice for GUACAMOLE_HOME. Context-based security
systems like SELinux may reject attempts to load drivers from such a location.
Even if this isn't the cause of your difficulties, it would make more sense to
keep GUACAMOLE_HOME outside "/etc" for the sake of complying with file system
hierarchy conventions.
By far, the most common cause of problems with library/extension loading is
improper and unnecessary overriding of GUACAMOLE_HOME. Setting environment
variables for use within Tomcat is difficult, and unless you have a specific
need to do otherwise, it's better to just use the default location.
> Guacamole client doesn't see the postgres jdbc driver
> -----------------------------------------------------
>
> Key: GUACAMOLE-215
> URL: https://issues.apache.org/jira/browse/GUACAMOLE-215
> Project: Guacamole
> Issue Type: Bug
> Components: guacamole-client
> Affects Versions: 0.9.11-incubating
> Environment: CentOS Linux release 7.3.1611 (Core)
> PostgreSQL 9.2.18
> PostgreSQL JDBC 4.2 Driver, 42.0.0
> Reporter: Mate
> Priority: Critical
> Attachments: log.txt
>
>
> I'm trying to setup guacamole with Postgres database authentication.
> Guacamole client starts but it doesn't allow me to sign in. It seems for me
> that guacamole client doesn't see the jdbc driver and no matter if I put
> jdbc.jar in GUACAMOLE_HOME/lib or not, I get the same warnings in the log
> file. Permissions are set correctly.
> From the logs I see that auth extension is loaded, so it seems that variable
> from tomcat is loaded correctly but something goes wrong with lib.
> GUACAMOLE_HOME="/etc/guacamole"
> guacamole.properties
> ------------------------------------------------------
> # PostgreSQL properties
> postgresql-hostname: localhost
> postgresql-port: 5432
> postgresql-database: guacamole_db
> postgresql-username: test
> postgresql-password: test
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
