Hi, Thanks to all for the helpful suggestions. Regards, John ________________________________ From: Kaufman <bkaufman(a)bcmone.com> Sent: 13 April 2023 14:28 To: Kamailio (SER) - Users Mailing List <sr-users(a)lists.kamailio.org> Subject: [SR-Users] Re: CLI & destination based LCR CAUTION: This email originated from outside your organization. Exercise caution when opening attachments or clicking links, especially from unknown senders. SQLOPS would work. The difficulty is in writing your rules in your query. Implementing the query and getting results in Kamailio is trivial if that’s done. If your rules are strictly based on matching prefixes (which is pretty common in telephony) and you’re using postgres, the prefix opclass is pretty helpful in making the queries more efficient: https://github.com/dimitri/prefix Kaufman From: John Cahill <John.Cahill(a)Firstcomeurope.co.uk> Sent: Thursday, April 13, 2023 4:57 AM To: sr-users(a)lists.kamailio.org Subject: [SR-Users] CLI & destination based LCR CAUTION: This email originated from outside the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe. Hi, I'd like to build an LCR solution that routes on both CLI & destination e.g. CLI matches ^\+49*, destinations matches ^\+44* => route to gateway 5 for a large rule set (~ tens of thousands). Any recommendations for which modules to use? Can kamailio perform this particular task well or should I look at another solution? I'd be very grateful to hear about any experience of doing this. Many Thanks. Regards, John

Hi, I am still using the PDB Daemon with Carrierroute (initially developed by and for 1&1) for that purpose: https://kamailio.org/docs/modules/devel/modules/pdb.html https://github.com/kamailio/kamailio/tree/master/utils/pdbt It is not exactly your use case, but it allows you to match numbers to a carrier, which then can be used for routing (e.g., have a different routing tree for numbers from one carrier, another routing tree for numbers from another carrier, and a default routing tree for all others). Works like a charm. Thanks, Carsten -- Carsten Bock I CTO & Founder ng-voice GmbH Trostbrücke 1 I 20457 Hamburg I Germany T +49 179 2021244 I www.ng-voice.com Registry Office at Local Court Hamburg, HRB 120189 Managing Directors: Dr. David Bachmann, Carsten Bock, Quirin Maderspacher Am Do., 13. Apr. 2023 um 15:48 Uhr schrieb Juha Heinanen <jh(a)tutpro.com>om>: