[SR-Users] error using avp_db_load with mongodb

hdssdsdsdsfsdf hdssdsdsdsfsdf hdssdsdsdsfsdf at mail.com
Fri Jul 28 18:03:52 CEST 2017

It seems I'm missing something when checking the structure. I've multiple entries in the database now that seem to have exactly the same types, but the config works for one, and gives an error on the other one:

{ "_id" : ObjectId("597b5698e498421a40458dc3"), "uuid" : "", "attribute" : "email", "value" : "sip:555 at bla.bla", "type" : 0, "username" : "555", "domain" : null }
{ "_id" : ObjectId("597b5d9a61d1521f067391ae"), "uuid" : "", "attribute" : "email", "value" : "sip:123 at bla.bla", "type" : 0, "username" : "666", "domain" : null }

I compared all the types, and they're the same, using statements like:

typeof db.usr_preferences.findOne({"username":"666"})._id

The first entry has been made by using:
So, using kamailio. The second version has been created by me manually in the database (which is what I'll do for the real entries). 

The first entry now works fine, but the second one gives the following error:
ERROR: <core> [usr_avp.c:424]: search_avp(): 0 ID or NULL NAME AVP!
when using the initial code again:

                        if (avp_db_load("$to/username", "$avp(s:email)")) {

Where does the second entry differ?

> Sent: Wednesday, July 26, 2017 at 6:58 PM
> From: "Sebastian Damm" <damm at sipgate.de>
> To: "Kamailio (SER) - Users Mailing List" <sr-users at lists.kamailio.org>
> Subject: Re: [SR-Users] error using avp_db_load with mongodb
> Hi,
> I've seen this before, but with MySQL. Kamailio is pretty strict with
> data types of database fields. IIRC I tried to use it with a view and
> the view returned a string value where Kamailio expected an integer
> and threw the same error. So maybe you might want to check the
> reference structure of the usr_preferences table under
> https://github.com/kamailio/kamailio/blob/master/utils/kamctl/mongodb/kamailio/usr_preferences.json
> with your local structure.
> Sebastian
> _______________________________________________
> Kamailio (SER) - Users Mailing List
> sr-users at lists.kamailio.org
> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

More information about the sr-users mailing list