[jira] [Created] (GUACAMOLE-540) Discrepancy with remote_host between tables

["Joseph L. Casale (JIRA)" <ji...@apache.org>]

Joseph L. Casale created GUACAMOLE-540:
------------------------------------------

             Summary: Discrepancy with remote_host between tables
                 Key: GUACAMOLE-540
                 URL: https://issues.apache.org/jira/browse/GUACAMOLE-540
             Project: Guacamole
          Issue Type: Improvement
          Components: guacamole-auth-jdbc
         Environment: # cat /etc/redhat-release
CentOS Linux release 7.4.1708 (Core)

# apachectl -V
Server version: Apache/2.4.6 (CentOS)
Server built:   Oct 19 2017 20:39:16
Server's Module Magic Number: 20120211:24
Server loaded:  APR 1.4.8, APR-UTIL 1.5.2
Compiled using: APR 1.4.8, APR-UTIL 1.5.2
Architecture:   64-bit
Server MPM:     prefork
  threaded:     no
    forked:     yes (variable process count)
Server compiled with....
 -D APR_HAS_SENDFILE
 -D APR_HAS_MMAP
 -D APR_HAVE_IPV6 (IPv4-mapped addresses enabled)
 -D APR_USE_SYSVSEM_SERIALIZE
 -D APR_USE_PTHREAD_SERIALIZE
 -D SINGLE_LISTEN_UNSERIALIZED_ACCEPT
 -D APR_HAS_OTHER_CHILD
 -D AP_HAVE_RELIABLE_PIPED_LOGS
 -D DYNAMIC_MODULE_LIMIT=256
 -D HTTPD_ROOT="/etc/httpd"
 -D SUEXEC_BIN="/usr/sbin/suexec"
 -D DEFAULT_PIDLOG="/run/httpd/httpd.pid"
 -D DEFAULT_SCOREBOARD="logs/apache_runtime_status"
 -D DEFAULT_ERRORLOG="logs/error_log"
 -D AP_TYPES_CONFIG_FILE="conf/mime.types"
 -D SERVER_CONFIG_FILE="conf/httpd.conf"

# tomcat version
Server version: Apache Tomcat/7.0.76
Server built:   Oct 30 2017 10:21:55 UTC
Server number:  7.0.76.0
OS Name:        Linux
OS Version:     3.10.0-693.21.1.el7.x86_64
Architecture:   amd64
JVM Version:    1.8.0_161-b14
JVM Vendor:     Oracle Corporation

# java -version
openjdk version "1.8.0_161"
OpenJDK Runtime Environment (build 1.8.0_161-b14)
OpenJDK 64-Bit Server VM (build 25.161-b14, mixed mode)
            Reporter: Joseph L. Casale


I have apache proxying into tomcat on the same server with guacamole-auth-jdbc-postgresql. The guacamole_connection_history.remote_host column shows the actual client address whereas guacamole_user_history.remote_host shows localhost unless connecting to tomcat directly.

Regardless of apache's config, I think the code should have consistency in how the value is obtained.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)