I would say "sqlops" would be helpful for your case. You can fetch any variable
from db with proper query.
Regards
EU.
Get Outlook for Android<https://aka.ms/ghei36>
________________________________
From: sr-users <sr-users-bounces(a)lists.kamailio.org> on behalf of Mihai Cezar
<mihai(a)mokalife.ro>
Sent: Sunday, December 27, 2020 3:18:49 PM
To: Kamailio (SER) - Users Mailing List <sr-users(a)lists.kamailio.org>
Subject: [SR-Users] Read $fd from mysql?
Hello,
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 ;)
# Dispatch requests
route[DISPATCH] {
switch ($fd){
case
"oro.streamlinepbx.nl<http://oro.streamlinepbx.nl>":
if (!ds_select_dst("1", "4")) {
send_reply(503, "Service Unavailable
$fd");
exit;
}
break;
case
"oro3.streamlinepbx.nl<http://oro3.streamlinepbx.nl>":
if (!ds_select_dst("2", "4")) {
send_reply(503, "Service Unavailable
$fd");
exit;
}
break;
............
default:
log("unknow destination?");
send_reply(503, "No service defined");
xlog("--- SCRIPT: going to <$ru> via <$du>
...Exiting");
exit;
}
xlog("--- SCRIPT: going to <$ru> via <$du> (attrs:
$xavp(_dsdst_=>attrs))\n");
t_on_failure("RTF_DISPATCH");
route(RELAY);
exit;
}
Thanks,