Odoo Help


Mass mailing unsubscribe & tracking with multiple databases

Mario Gielissen | Openworx
on 10/2/15, 7:40 AM 2,084 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?



| 8 8 8

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

Openworx, 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.

Openworx, 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.

Openworx, 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?

Openworx, 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.

Openworx, 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.

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

About This Community

This platform 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.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


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