MySQL Port on CID Lookup

ivan.ramirez · May 12, 2025, 4:56pm

How can I configure the database port for MySQL in the CID lookup?
In my case, the remote database is an Odoo database running on PostgreSQL (port 5432).

mo10 · May 13, 2025, 4:19pm

Give it a try:
…XXX:5432

ivan.ramirez · May 14, 2025, 1:32am

Hi @mo10 -

Thanks for your advice—I really appreciate it. It was my first shoot, but unfortunately, it didn’t go as planned.

mo10 · May 14, 2025, 5:22am

Also keep in mind: PostgreSQL is not MySQL

ivan.ramirez · May 15, 2025, 4:34pm

Hi @mo10 -

Thanks for your help and support.

I understand that PostgreSQL is not MySQL. However, I can query the database in that language to retrieve the contact name.

I suppose that, in essence, what the system does is assume port 3306 for the connection.

Ideally, the form should have an additional field to configure the remote database port.

As you can see bellow, a MySQL query is working fine from console using psql using port 5432:

system · June 14, 2025, 4:34pm

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