Mixed Content Errors in multiple languages

spike 2020-12-10 05:58:04 UTC #1

Keywords: Odoo - Google Cloud Platform - Technical issue - Secure Connections (SSL/HTTPS)
bnsupport ID: 4463f4a9-c5dd-6237-13fc-d648df540d76
Description:
I have Odoo 14 CE running fine.
Setup the SSL certs using the auto tool.
Added 2nd language - but cannot access the top tool bar.
Spotted the mixed content error --- don't really know where to go from here. Have seen another post on this --- but no resolution.

Mixed Content: The page at 'https://dealer.gsastuto.com/ja/?fw=1' was loaded over HTTPS, but requested an insecure XMLHttpRequest endpoint 'http://dealer.gsastuto.com/ja/website/translations/3e3e3662962d53a0d7dce4b78680b64cceb942a3?mods=&lang=ja_JP'. This request has been blocked; the content must be served over HTTPS.

spike 2020-12-10 06:27:52 UTC #2

Just a few more things I've tried --

Proxy Mode = true in Odoo conf
Sys Parms set to freeze URL and https://xxxxx

Added RequestHeader set X-Forwarded-Proto "http" to the httpsd-app.conf

gongomgra 2020-12-10 10:16:42 UTC #3

Hi @spike

I visited your website and it is showing a valid certificate. I also visited the provided link and it worked with HTTPS for me.

$curl -LI "http://dealer.gsastuto.com/ja/website/translations/3e3e3662962d53a0d7dce4b78680b64cceb942a3?mods=&lang=ja_JP"
HTTP/1.1 302 Found
Date: Thu, 10 Dec 2020 10:15:32 GMT
Server: Apache
X-Frame-Options: SAMEORIGIN
Location: https://dealer.gsastuto.com/ja/website/translations/3e3e3662962d53a0d7dce4b78680b64cceb942a3?mods=&lang=ja_JP
Content-Type: text/html; charset=iso-8859-1

HTTP/1.1 200 OK
Date: Thu, 10 Dec 2020 10:15:33 GMT
Server: Apache
Content-Length: 81618
X-Frame-Options: SAMEORIGIN
Vary: Accept-Encoding
Etag: W/"PSA-Kn8_cjI4jA"
Cache-Control: public, max-age=31536000, s-maxage=10
X-Content-Type-Options: nosniff
Content-Type: application/json

Can you check your theme or internal Odoo settings for the HTTP link and update it to HTTPS?

spike 2020-12-10 11:09:14 UTC #4

Hello -thanks!

The main problem is when I switch to a language other than default, as an Admin - then I cannot use the translate or other top bar functions. In addition - when language is switched - the translated material fails.

I created another install and then where it's breaking - or at least somethig is breaking it when I set Proxy =True in the conf.

My goal is to run sub-domains, with SSL off the same server. Mainly for test / production. If I just use a single db / instance - I can more or less get it working. But using multiple db - it's broken.

spike 2020-12-10 12:18:10 UTC #5

Latest Update -

1) Backed almost all the db_filter related configs (as described here)
2) Dropped the 2nd DB so only running a single db
3) Now the translations load and the top bar works --- but!

4) With System Parm set to http://localhost - the send mails don't provide the correct email links.
5) I correct that and emails sent - but re-logging resets the URL back to localhost
6) I then add the URL freeze key - everything now working ... BUT!
7) When go to the base URL I see the DB list

So basically I'm about 6 steps forward and 7 steps back.

spike 2020-12-10 12:31:44 UTC #6

Well, closer - but prtty certain my config is not 100% good...

1) unclear on the use of the db_filter and other conf to change (db name -> dealer-astuto-com)
2) especially any Apache2 confs - I basically backed out the changes from before and now everything more or less 'works'.

So - do I really need the following on the httpd-apps conf? This seems to be one of the things that broke the system to begin with ...

####
<Proxy *>
Order deny,allow
Allow from all
</Proxy>
ProxyRequests Off
####

####
options]
addons_path = /opt/bitnami/apps/odoo/lib/odoo-14.0.post20201130-py3.7.egg/odoo/addons
admin_passwd = xxxxxxxxxxxxxx
csv_internal_sep = ,
data_dir = /opt/bitnami/apps/odoo/data
db_host = 127.0.0.1
db_maxconn = 64
db_name = False
db_password = yyyyyyyyyyyyy
db_port = 5432
db_sslmode = prefer
db_template = template0
db_user = bn_odoo
dbfilter = ^dealer.*$
demo = {}
email_from = user@example.com
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 = 60
limit_time_real = 120
limit_time_real_cron = -1
list_db = True
log_db = False
log_db_level = warning
log_handler = :INFO
log_level = info
logfile = /opt/bitnami/apps/odoo/log/production.log
longpolling_port = 8072
max_cron_threads = 2
osv_memory_age_limit = False
osv_memory_count_limit = False
pg_path = /opt/bitnami/postgresql/bin
pidfile =
proxy_mode = False
reportgz = False
screencasts =
screenshots = /tmp/odoo_tests
server_wide_modules = base,web
smtp_password = False
smtp_port = 25
smtp_server = localhost
smtp_ssl = False

#################

gongomgra 2020-12-11 10:09:55 UTC #7

Hi @spike,

Thanks for your investigation. Can you ask for help on the Odoo forums? Note they can help you better than we can as they know exactly how the application internally works

https://www.odoo.com/forum

system 2020-12-25 10:09:55 UTC #8

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.

Bitnami provides free all-in-one installers, virtual machines and cloud images for popular open source applications. Get them now!