And apologies. Solved it. It was indeed the type problem, where I had to insert the "type" field as "NumberInt(0)" to prevent it from turning into a float (which the "typeof" command I use to check if they were the same type didn't show as different, but just as a number).
Sent: Monday, July 31, 2017 at 11:51 AM From: "hdssdsdsdsfsdf hdssdsdsdsfsdf" hdssdsdsdsfsdf@mail.com To: sr-users@lists.kamailio.org Cc: sr-users@lists.kamailio.org Subject: Re: [SR-Users] error using avp_db_load with mongodb
Correction, the error is actually: ERROR: avpops [avpops_impl.c:123]: dbrow2avp(): wrong field types in dbrow
Sent: Monday, July 31, 2017 at 10:55 AM From: "hdssdsdsdsfsdf hdssdsdsdsfsdf" hdssdsdsdsfsdf@mail.com To: sr-users@lists.kamailio.org Cc: "Kamailio (SER) - Users Mailing List" sr-users@lists.kamailio.org Subject: Re: [SR-Users] error using avp_db_load with mongodb
Thanks, I changed that, but that doesn't deal with the original problem.
I still have the situation where I've two mongodb entries that are completely similar: { "_id" : ObjectId("597b5698e498421a40458dc3"), "uuid" : "", "attribute" : "email", "value" : "sip:555@bla.bla", "type" : 0, "username" : "555", "domain" : null } { "_id" : ObjectId("597b5d9a61d1521f067391ae"), "uuid" : "", "attribute" : "email", "value" : "sip:123@bla.bla", "type" : 0, "username" : "666", "domain" : null }
with: avp_db_load("$tu/username", "$avp(s:email)")
succeeding on the first entry (when $tu contains 555) and failing on the second entry (when $tu contains 666), with error message:
ERROR: <core> [usr_avp.c:424]: search_avp(): 0 ID or NULL NAME AVP!
Sent: Monday, July 31, 2017 at 9:10 AM From: "Sebastian Damm" damm@sipgate.de To: "Kamailio (SER) - Users Mailing List" sr-users@lists.kamailio.org Subject: Re: [SR-Users] error using avp_db_load with mongodb
Hi,
On Fri, Jul 28, 2017 at 6:03 PM, hdssdsdsdsfsdf hdssdsdsdsfsdf hdssdsdsdsfsdf@mail.com wrote:
if (avp_db_load("$to/username", "$avp(s:email)")) { xlog("bla02"); }$to is not a valid pseudo variable. You probably want to replace "$to/username" by "$tU" or "$rU" or some variable where the user you are searching is written in the SIP packet.
BR Sebastian
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users