[SR-Users] Read $fd from mysql?

[egemen ulus]

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 at lists.kamailio.org> on behalf of Mihai Cezar <mihai at mokalife.ro>
Sent: Sunday, December 27, 2020 3:18:49 PM
To: Kamailio (SER) - Users Mailing List <sr-users at 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,

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20201227/74a3dca4/attachment.htm>