title: Getting Database Authentication to work on Apache Guacamole
body: <p>Got Apache Guacamole and Tomcat working between two laptops and a PC under
  LAN.</p>
  <p>However, was always updating user and connection details through
  user-mapping.xml</p>
  <p>I decided to then set up Database Authentication for easier changing of
  user-mapping,</p>
  <p>setup and had active SQLServer, MYSQL as well as now PostGreSQL, all are
  active and running (not concurrently, tried one by one and then uninstalled)
  however guacamole login details remain the same and seem to be unaffected by
  the changes in guacamole.properties.</p>
  <p>Here is my latest guacamole.properties file for reference. (PostGreSQL
  Version atm)</p>
  <pre><code>guacd-hostname:localhost
  guacd-port: 4822
  user-mapping:/etc/guacamole/user-mapping.xml
  auth-provider:
  net.sourceforge.guacamole.net.basic.BasicFileAuthenticationProvider
  # MySQL properties
  #mysql-hostname: localhost
  #mysql-port: 3306
  #mysql-database: guacamole_db
  #mysql-username: SHRDC
  #mysql-password: Shrdc_1234
  #mysql-user-required: true
  # PostgreSQL properties
  postgresql-hostname: localhost
  postgresql-port: 5432
  postgresql-database: guacamole_db
  postgresql-username: SHRDC
  postgresql-password: Shrdc_1234
  postgresql-user-required: true
  </code></pre>
  <p>I feel its some connector, driver issue hence not being recognised.
  Something to change in /lib or /extensions?</p>
  <p>For reference, the auth driver and auth connector i am using are currently:</p>
  <p>in /extensions:
  guacamole-auth-jdbc-postgresql.jar (Previously was
  guacamole-auth-jdbc-postgresql-1.2.0.jar before i renamed it trying smth
  out)</p>
  <p>in /lib:
  postgresql-42.2.14.jar</p>
  <p>all steps followed as per:
  <a href="https://guacamole.apache.org/doc/gug/jdbc-auth.html" rel="nofollow noreferrer">https://guacamole.apache.org/doc/gug/jdbc-auth.html</a></p>
  <p>Would love some feedback, been stuck trying to get DB authentication to work
  for a week plus now!</p>
  <p>Sincerely</p>