<div dir="ltr"><div>Thanks Daniel, it looks like sqlops was what I needed! <br></div><div>Don't know how DNS SRV records can help, as the host from($fd) points to private IP's</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Sun, Dec 27, 2020 at 2:34 PM Daniel Donoghue <<a href="mailto:daniel.donoghue@freespee.com">daniel.donoghue@freespee.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div style="overflow-wrap: break-word;"><div>Hi,</div><div><br></div><div>Have you tried using sqlops?</div><div><br></div><div>Something like...</div><div><br></div><div><div style="border:thin dotted rgb(112,170,229);padding-left:10px;padding-right:10px;background-color:rgb(239,248,248);overflow:auto;border-radius:2.5px;font-family:Helvetica,Arial,sans-serif;font-size:15px"><div><pre style="background-color:rgb(252,255,252);border:1px solid rgb(153,204,204);padding-left:15pt;overflow:auto;border-radius:2.5px"><div style="margin:0px;font-stretch:normal;line-height:normal;font-family:Menlo;background-color:rgb(251,255,251)"><span style="font-kerning:none">...</span></div><div style="margin:0px;font-stretch:normal;line-height:normal;font-family:Menlo;background-color:rgb(251,255,251)"><span style="font-kerning:none">modparam("sqlops","sqlcon","ca=><a>dbdriver://username:password@dbhost/dbname</a>")</span></div><div style="margin:0px;font-stretch:normal;line-height:normal;font-family:Menlo;background-color:rgb(251,255,251)"><span style="font-kerning:none">...</span></div><div style="margin:0px;font-stretch:normal;line-height:normal;font-family:Menlo;background-color:rgb(251,255,251)"><span style="font-kerning:none">sql_query("ca", "select dst_grp from lookup_table where from_domain=$(fd{s.escape.common})”, "ra");</span></div><div style="margin:0px;font-stretch:normal;line-height:normal;font-family:Courier;background-color:rgb(251,255,251)"><span style="font-kerning:none">if($dbr(ra=>rows)>0) {</span></div><div style="margin:0px;font-stretch:normal;line-height:normal;font-family:Courier;background-color:rgb(251,255,251)"><span style="font-kerning:none">  ds_select_dst(<span style="font-family:Menlo">"</span>$dbr(ra=>[0,0])<span style="font-family:Menlo">"</span>, <span style="font-family:Menlo">"</span>4<span style="font-family:Menlo">"</span>);</span></div><div style="margin:0px;font-stretch:normal;line-height:normal;font-family:Courier;background-color:rgb(251,255,251)"><span style="font-kerning:none">}</span></div><div style="margin:0px;font-stretch:normal;line-height:normal;font-family:Menlo;background-color:rgb(251,255,251)"><span style="font-kerning:none">sql_result_free("ra");</span></div><span style="font-family:Menlo;background-color:rgb(251,255,251)">...</span>...</pre><div><br></div></div></div></div><div><br></div><div><br></div><div>Alternatively, you could set up some naptr/srv records for all the from domains and simply relay to those, using dns instead of dispatcher, if you’re not already using them.</div><div><br></div><div><br></div>Blessings,<div>—</div><div>Daniel Donoghue</div><div><br></div><div><br><div><br><blockquote type="cite"><div>On 27 Dec 2020, at 13:18, Mihai Cezar <<a href="mailto:mihai@mokalife.ro" target="_blank">mihai@mokalife.ro</a>> wrote:</div><br><div><div dir="ltr"><div>Hello, <br></div><div><br></div><div>I am redirecting the agents/reps to their asterisk server based on the hostname which they connect, and, i wonder if it's possible to read from db instead of the file cause it's getting big ;)</div><div><br></div><div># Dispatch requests<br>route[DISPATCH] {<br>        switch ($fd){<br>                        case "<a href="http://oro.streamlinepbx.nl/" target="_blank">oro.streamlinepbx.nl</a>":<br>                                if (!ds_select_dst("1", "4")) {<br>                                        send_reply(503, "Service Unavailable $fd");<br>                                        exit;<br>                                }<br>                                break;<br>                        case "<a href="http://oro3.streamlinepbx.nl/" target="_blank">oro3.streamlinepbx.nl</a>":<br>                                if (!ds_select_dst("2", "4")) {<br>                                        send_reply(503, "Service Unavailable $fd");<br>                                        exit;<br>                                }<br>                                break;</div><div>                      ............<br>                        default:<br>                            log("unknow destination?");<br>                            send_reply(503, "No service defined");<br>                            xlog("--- SCRIPT: going to <$ru> via <$du> ...Exiting");<br>                            exit;<br>                }<br><br>        xlog("--- SCRIPT: going to <$ru> via <$du> (attrs: $xavp(_dsdst_=>attrs))\n");<br>        t_on_failure("RTF_DISPATCH");<br>        route(RELAY);<br>        exit;<br>}</div><div><br></div><div>Thanks,</div><div><br></div></div>
_______________________________________________<br>Kamailio (SER) - Users Mailing List<br><a href="mailto:sr-users@lists.kamailio.org" target="_blank">sr-users@lists.kamailio.org</a><br><a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><br></div></blockquote></div><br></div></div>_______________________________________________<br>
Kamailio (SER) - Users Mailing List<br>
<a href="mailto:sr-users@lists.kamailio.org" target="_blank">sr-users@lists.kamailio.org</a><br>
<a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><br>
</blockquote></div>