<html><head></head><body><div class="yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px;"><div dir="ltr" data-setdir="false">Hii,</div><div dir="ltr" data-setdir="false">I am trying to use pstn_route module for the first time, and i want to route the invite to specific pstn server based on its prefix.</div><div dir="ltr" data-setdir="false">I have loaded the module & setup the DB, and it's giving error saying route name (from DB) is not defined after adding the a prefix into DB table., and there were no errors when DB table is empty.</div><div dir="ltr" data-setdir="false">Not sure how to defined it, or i dont know what did i miss. Please help.</div><div><br></div><div dir="ltr" data-setdir="false">#### CONFIG ##########</div><div dir="ltr" data-setdir="false"><div><div>loadmodule "prefix_route.so"</div><div>modparam("prefix_route", "db_url", "mysql://xxxxx:xxxxx@localhost/kamailioDB")</div><div>modparam("prefix_route", "db_table", "new_prefix_route")</div><div><br></div><div>#PSTN Routing table contains</div><div> if (!prefix_route("+44")) {</div><div> xlog("L_INFO", "+44 prefix didnt match with prefix_route DB\n");</div><div> }</div><div><br></div><div dir="ltr" data-setdir="false">########## DB####</div><div>MariaDB [kamailio]> select * from new_prefix_route;</div><div>Empty set (0.00 sec)</div><div><br></div><div>MariaDB [kamailio]> exit;</div><div>##########</div><div><br></div><div><br></div><div>Kamailio looks good untill here, no errors.. </div><div><br></div><div># Now i have added a prefix into sql DB</div><div>INSERT INTO new_prefix_route VALUES ("+44", "10.10.1.1:5060", "route for this prefix");</div><div>###########</div><div>Error log after adding a prefix into new_prefix_route table & restart of kamailio</div><div><br></div><div> 0(5802) CRITICAL: prefix_route [prefix_route.c:72]: add_route(): route name '10.10.1.1:5060' is not defined</div><div> 0(5802) NOTICE: prefix_route [prefix_route.c:170]: pr_db_load(): Total prefix routes loaded: 1</div><div> 0(5802) ERROR: prefix_route [prefix_route.c:174]: pr_db_load(): error flushing tree</div><div> 0(5802) CRITICAL: prefix_route [prefix_route.c:212]: mod_init(): db load failed</div><div><br></div></div>I have tried a "name" instead of IP (though i dont know how to convert that "name" into a IP:Port), But i am still getting same error using "name" instead of IP:port @ route field in DB.</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">Please help.</div></div></body></html>