Hi Guys,

I hope someone can help.

I have been pulling my hair out trying to get geoip multi website redirect to work in Odoo14

I have installed geoip2 as per the odoo instructions.

I have then downloaded the database from maxmind, unzipped it  and FTP’d GeoLite2-City.mmdb to /usr/share/GeoIP

Restarted the server.

I then added the code to a test page, but the brackets remain empty.  I have tested this from a non local machine too, with the same results.

When I check the odoo log, I can see that odoo is logging visitors Ips.  I have also tested this with a non-local machine, and the IP in the log is correct. So I think this means that the IP is being forwarded through the reverse proxi properly?

If anyone can see what im missing here, or has any pointers that would be really appreciated.

Many thanks,

Sion.

My Odoo conf file:

addons_path = /usr/lib/python3/dist-packages/odoo/addons

admin_passwd = my password

csv_internal_sep = ,

data_dir = /var/lib/odoo/.local/share/Odoo

db_host = False

db_maxconn = 64

db_name = False

db_password = False

db_port = False

db_sslmode = prefer

db_template = template0

db_user = odoo

dbfilter =

demo = {}

email_from = False

geoip_database = /usr/share/GeoIP/GeoLite2-City.mmdb

http_enable = True

http_interface =

http_port = 8069

import_partial =

limit_memory_hard = 2684354560

limit_memory_soft = 2147483648

limit_request = 8192

limit_time_cpu = 120

limit_time_real = 1200

limit_time_real_cron = -1

list_db = True

log_db = False

log_db_level = warning

log_handler = :INFO

log_level = info

logfile = /var/log/odoo/odoo-server.log

longpolling_port = 8072

max_cron_threads = 1

osv_memory_age_limit = False

osv_memory_count_limit = False

pg_path =

pidfile =

proxy_mode = True

reportgz = False

screencasts =

screenshots = /tmp/odoo_tests

server_wide_modules = base,web

smtp_password = False

smtp_port = 25

smtp_server = localhost

smtp_ssl = False

smtp_user = False

syslog = False

test_enable = False

test_file =

test_tags = None

transient_age_limit = 1.0

translate_modules = ['all']

unaccent = False

upgrade_path =

without_demo = False

workers = 5

My Nginx file:

#odoo server

upstream odoo {

server 127.0.0.1:8069;

}

upstream odoochat {

server 127.0.0.1:8072;

}

server {

server_name shop.mysite.com;

include snippets/letsencrypt.conf;

listen 443 ssl; # managed by Certbot

ssl_certificate /etc/letsencrypt/live/mysite.com/fullchain.pem; # managed by Certbot

ssl_certificate_key /etc/letsencrypt/live/mysite.com/privkey.pem; # managed by Certbot

include /etc/letsencrypt/options-ssl-nginx.conf; # managed by Certbot

ssl_dhparam /etc/letsencrypt/ssl-dhparams.pem; # managed by Certbot

proxy_read_timeout 720s;

proxy_connect_timeout 720s;

proxy_send_timeout 720s;

# Add Headers for odoo proxy mode

proxy_set_header X-Forwarded-Host $host;

proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;

proxy_set_header X-Forwarded-Proto $scheme;

proxy_set_header X-Real-IP $remote_addr;

# log

access_log /var/log/nginx/odoo.access.log;

error_log /var/log/nginx/odoo.error.log;

# Redirect longpoll requests to odoo longpolling port

location /longpolling {

proxy_pass http://odoochat;

}

# Redirect requests to odoo backend server

location / {

proxy_redirect off;

proxy_pass http://odoo;

}

# common gzip

gzip_types text/css text/scss text/plain text/xml application/xml application/json application/javascript;

gzip on;

}

server {

listen 80;

server_name shop.mysite.com www.shop.mysite.com;

rewrite ^(.*) https://$host$1 permanent;

}

server {

listen 443 ssl;

server_name www.shop.mysite.com;

return 301 $scheme://shop.mysite.com$request_uri;

}

server {

server_name usa.mysite.com;

include snippets/letsencrypt.conf;

listen 443 ssl; # managed by Certbot

ssl_certificate /etc/letsencrypt/live/usa.mysite.com/fullchain.pem; # managed by Certbot

ssl_certificate_key /etc/letsencrypt/live/usa.mysite.com/privkey.pem; # managed by Certbot

include /etc/letsencrypt/options-ssl-nginx.conf; # managed by Certbot

ssl_dhparam /etc/letsencrypt/ssl-dhparams.pem; # managed by Certbot

proxy_read_timeout 720s;

proxy_connect_timeout 720s;

proxy_send_timeout 720s;

# Add Headers for odoo proxy mode

proxy_set_header X-Forwarded-Host $host;

proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;

proxy_set_header X-Forwarded-Proto $scheme;

proxy_set_header X-Real-IP $remote_addr;

# log

access_log /var/log/nginx/odoo.access.log;

error_log /var/log/nginx/odoo.error.log;

# Redirect longpoll requests to odoo longpolling port

location /longpolling {

proxy_pass http://odoochat;

}

# Redirect requests to odoo backend server

location / {

proxy_redirect off;

proxy_pass http://odoo;

}

# common gzip

gzip_types text/css text/scss text/plain text/xml application/xml application/json application/javascript;

gzip on;

}