Apache httpd mod_remoteip does not work correctly with internal IPs

Issue

• We have configured mod_remoteip correctly as per How to use mod_remoteip to get client IP address when Apache httpd is behind a proxy server or load balancer . But, when accessing the site from the intranet, the IP of the proxy (not the IP of the client) is being logged.
• The Apache httpd is not logging the true client IP address behind a load balancer. Instead, it logs the load balancer's IP address (192.168.100.1) in the access logs.