Re: [SR-Users] DBTEXT / AVPOPS and custom database

Hi , I'm trying to use the db_text and avpops modules to implement a simple custom database but having problems getting it to work . I'm trying to find the Identity of the recipient for an inbound call based on the called number . I have a database file:- 1)LineIDs - contains the called numbers in the username field and an attribute for that line ID (inbound/ outbound) ,and the recipient identity in the value field I am trying to get the attribute and value pairs that matches the line number in the user name column , id(int,auto) uuid(str,null) username(str) domain(str,null) attribute(str) type(int) value(str) 1::+12125551212::inbound:0:Foster 2::012125551212::inbound:0:Foster 3::12125551212::inbound:0:Foster 4::+4412125551212::inbound:0:Foster 5::+12125551213::inbound:0:Foster 6::012125551213::inbound:0:Foster 7::013440001::inbound:0:Foster 8::call-centre::inbound:0:MBA 9::call-centre::outbound:0:MBA 10::01344665544::inbound:0:chicken 11::01344665544::outbound:0:chicken I try to load the AVPs that match a received number using the following line in the kamailio script file $var(rc)=avp_db_load("01344665544/username","s:recipient/LineIDs"); I have also tried $var(rc)=avp_db_load("01344665544/username","$avp(s:tenants)/LineIDs"); And $var(rc)=avp_db_load("01344665544","$avp(i:123)/LineIDs"); But it fails to find any matching rows ( AVPS) . Am I using the function correctly ? The debug output is shown below , there are some custom debug lines I have added in the db_text C files . DEBUG: avpops [avpops_impl.c:378]: AVPOPS: calls db_load_avp DEBUG: db_text [dbt_base.c:185]: DBTEXT: dbt_query called DEBUG: db_text [dbt_file.c:102]: request for table [LineIDs] DEBUG: db_text [dbt_file.c:109]: db is [/etc/kamailio/Tenants] DEBUG: db_text [dbt_file.c:124]: loading file [/etc/kamailio/Tenants/LineIDs] DEBUG: db_text [dbt_tb.c:187]: mtime is 1383910898 DEBUG: db_text [dbt_file.c:215]: column[0] is INT! DEBUG: db_text [dbt_file.c:210]: column[1] is STR! DEBUG: db_text [dbt_file.c:210]: column[2] is STR! DEBUG: db_text [dbt_file.c:210]: column[3] is STR! DEBUG: db_text [dbt_file.c:210]: column[4] is STR! DEBUG: db_text [dbt_file.c:215]: column[5] is INT! DEBUG: db_text [dbt_file.c:210]: column[6] is STR! DEBUG: db_text [dbt_base.c:240]: new res with 3 cols DEBUG: db_text [dbt_res.c:52]: DBTEXT: dbt_result_new called DEBUG: db_text [dbt_res.c:79]: new res with 3 cols DEBUG: db_text [dbt_res.c:100]: DBTEXT: dbt_result_new returns DEBUG: db_text [dbt_api.c:255]: DBTEXT: dbt_get_result called DEBUG: <core> [db_res.c:118]: allocate 48 bytes for result set at 0x7f334a85c390 DEBUG: <core> [db_res.c:155]: allocate 24 bytes for result names at 0x7f334a85c3e0 DEBUG: <core> [db_res.c:165]: allocate 12 bytes for result types at 0x7f334a85c1f0 DEBUG: db_text [dbt_api.c:80]: allocate 16 bytes for RES_NAMES[0] at 0x7f334a85c1c0 DEBUG: db_text [dbt_api.c:80]: allocate 16 bytes for RES_NAMES[1] at 0x7f334a85c420 DEBUG: db_text [dbt_api.c:80]: allocate 16 bytes for RES_NAMES[2] at 0x7f334a85c450 DEBUG: db_text [dbt_api.c:281]: DBTEXT: dbt_get_result returns 0 DEBUG: avpops [avpops_impl.c:389]: AVPOPS: db_load_avp returns 0 DEBUG: avpops [avpops_db.c:271]: close avp query DEBUG: <core> [db_res.c:81]: freeing 3 columns DEBUG: <core> [db_res.c:85]: freeing RES_NAMES[0] at 0x7f334a85c1c0 DEBUG: <core> [db_res.c:85]: freeing RES_NAMES[1] at 0x7f334a85c420 DEBUG: <core> [db_res.c:85]: freeing RES_NAMES[2] at 0x7f334a85c450 DEBUG: <core> [db_res.c:94]: freeing result names at 0x7f334a85c3e0 DEBUG: <core> [db_res.c:99]: freeing result types at 0x7f334a85c1f0 DEBUG: <core> [db_res.c:136]: freeing result set at 0x7f334a85c390 DEBUG: avpops [avpops_impl.c:420]: loaded avps = 0 INFO: avp_db_load return result is -1 I was expecting it to return at least one AVP . Any suggestions gratefully received . Hugh James Hugh James | Telephony Developer icons * 0845 543 0822 * * Hugh.James(a)semafone.com * www.semafone.com <http://www.semafone.com> * @semafone <http://twitter.com/semafone> * SEMAFONE, 3 The Billings, Walnut Tree Close, Guildford, Surrey GU1 4UL logo This e-mail is intended only for the addressee named above. As this e-mail may contain confidential or privileged information if you are not the named addressee or the person responsible for delivering the message to the named addressee, please telephone us immediately. Please note that we cannot guarantee that this message, or any attachment, is virus free or has not been intercepted and amended. The views of the author may not necessarily reflect those of the Company. _______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users(a)lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users