Odoo Help


This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Mass mailing unsubscribe & tracking with multiple databases

Mario Gielissen | Openworx
on 10/2/15, 7:40 AM 1,128 views

E-mails send from mass mailing have a unsubscribe link and use trackingpixel to see how many times a mail is opened. The URL from unsubscribe and trackingpixel contains the databasename. But with a server with multiple databases the unsubscribe and tracking URL ain't working and gives a 404 error.

It works when there is only one database, but how to deal with multiple databases?



| 7 7 8
Turnhout, Belgium

My Odoo blog: http://www.odoo.yenthevg.com/

My Twitter: https://twitter.com/Yenthe666

On 10/2/15, 7:46 AM

Hi Mario,

This issue has been around for ages in Odoo and sadly they haven't fixed this yet. I have a topic about this here.The only way to get this working in a multi-db environment is to use a db-filter. You'll have to run your Odoo service with the db-filter, something along these lines:

openerp-server --db-filter='^%d'


Hi Tenthe, When I use your fix for mass_mailing and add report.url parameter, it should work for a multi-db environment? Mario

Mario Gielissen | Openworx
on 10/2/15, 7:59 AM

A lot will work but not everything Mario. Have a look at this Github issue: https://github.com/odoo/odoo/pull/3289 and at the docs: https://www.odoo.com/documentation/8.0/setup/deploy.html you should use the db-filter to be absolutely sure and to do it following the rules.

on 10/2/15, 8:02 AM

With html_widget_embedded_picture images are base64 embedded in the mail. If unsubscibe and tracking are working with your fix, it's good enough for me.

Mario Gielissen | Openworx
on 10/2/15, 8:42 AM

Yenthe, I've tested your patch and the unsubscribe link (status OK) and tracking seems to work.

Mario Gielissen | Openworx
on 10/2/15, 9:55 AM

Ahh perfect. Then those patches will do the job! Best of luck.

on 10/2/15, 10:01 AM

Yenthe, Unscubscibe link says ok, but the Opt-Out is not true?

Mario Gielissen | Openworx
on 10/7/15, 5:00 AM

@Mario I'm afraid I haven't ever used/needed the opt-out so I'm not sure what your problem is. What exactly is the problem?

on 10/7/15, 5:27 AM

@Yenthe When clicking on the unsubscribe link, the Odoo site says OK. But when I check the e-mailaddress in the mailinglist, opt-out is not marked.

Mario Gielissen | Openworx
on 10/7/15, 2:24 PM

@Mario I wasn't even aware that it should happen actually. Perhaps you should update your codebase to the newest version and see if it is fixed there? Otherwise you'll need to find the correct method and fix it I guess.

on 10/8/15, 1:58 AM

@Yenthe, the newest codebase isn't fixed with unsubscribe and multidb, you get an 404 error. That's why I use your fix.

Mario Gielissen | Openworx
on 10/8/15, 1:31 PM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)


Asked: 10/2/15, 7:40 AM
Seen: 1128 times
Last updated: 10/2/15, 9:55 AM