Hi Fuad, I think you should put the db return value in am avp before using it in the sl_send_reply. $avp(ip) = $avp(ra=>ip) Or whatever the syntax is. Make sure that the DB query is returning the required value.
Also I guess just using a 302 is not enough and you need to set the proper contact header in the reply so the calling party make use of it. Regards, Sammy On Apr 28, 2016 1:18 PM, "Ahmad Fuad" <ahmad.fawad4...@gmail.com> wrote: > Dear Support, > > Kindly find below my Database Table (kamailio.ext). Column names are "ext" > and "ip" > > mysql> select * from ext > -> ; > +------+----------------+ > | ext | ip | > +------+----------------+ > | 202 | 192.168.55.157 | > | 203 | 192.168.55.158 | > | 204 | 192.168.55.159 | > +------+----------------+ > 3 rows in set (0.00 sec) > > I want to run this type of queries in kamailio. I have tried following > command but no luck so far. Although I have added following line in the > configuration file as well. Thanks > > modparam("sqlops", "sqlcon", "cb=>mysql://root:123456@localhost/kamailio") > > > sql_query("cb", "select ip from ext where ext=$rU", "ra"); > sl_send_reply("302","$ra"); > > > PLEASE HELP !!! when we see the traces using wireshark it shows internal > error. Thanks > > 275.733635441 192.168.55.144 -> 192.168.55.157 SIP 431 Status: 302 > Internal Server Error | > > -- > Best Regards, > > Ahmad Fuad > > _______________________________________________ > SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list > sr-users@lists.sip-router.org > http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users > >
_______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users