Setting Outgoing Mail Server on Odoo12 and DBVisualizer with Odoo12 on Docker

Aditya Nanda Tri Prakoso
3 min readApr 30, 2021

Hello again, everyone. This one is a journey about running, setting outgoing mail servers, and then visualizing the MRP module database with DBVisualizer.

First off, we need to activate the developer mode and then going to technical and go to the Outgoing Mail Servers. After that, just fill the form as the same as below. For the username and password, use the email that was going to be used for sending mail. After that, go to the Google Account and lower the account security so Odoo can use the email as an outgoing mail.

Here below, I sent out a Purchase Order to my other Gmail account to try out the feature first.

Here below the Gmail account that received the Purchase Order.

For the DBVisualizer part, because we are using docker, there needs to be an adjustment on the docker-compose.yml because the Postgres we are using are not local. We are using Postgres on the docker, so we need to configure other ports.

Below we are the Database Connection on DBVisualizer, just follow the same field as below except for the Database name, it’s need to be same as the Odoo Database name.

Because of my case, we need to see the database for the MRP module, and we need to adjust the database with Specified Tables and choose MRP tables.

I hope this article helps anyone reading this, and thank you for reading this. See ya on another episode of me and Odoo 12!!

Support my youtube channel by subscribing, liking, and commenting on my video!!

Aditya Nanda Tri Prakoso