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