Hello Ali,

yes, this is possible. From the doc: “This parameter may be set multiple times to get many DB connections in the same configuration file.”

http://kamailio.org/docs/modules/stable/modules/sqlops.html#sqlops.p.sqlcon

Use the appropriate connection then later in the logic.

Cheers,

Henning

--

Henning Westerholt – https://skalatan.de/blog/

Kamailio services – https://gilawa.com

From: sr-users <sr-users-bounces@lists.kamailio.org> On Behalf Of Ali Taher
Sent: Monday, February 3, 2020 9:06 AM
To: Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.org>
Subject: [SR-Users] sqlops multiple databases

Hello,

Is there a way in sqlops module to use multiple postgres databases based on routing logic ?

Here is what I’m using right now:

modparam("sqlops","sqlcon","cb=>postgres://postgres:postgres@localhost:5432/db1")

Thanks

Ali Taher