<div dir="ltr">wow i missed this due to a lot of connection logs in /var/log/mongodb/mongod.log<div><br></div><div>2015-11-16T09:56:47.675+0000 I QUERY [conn56345] assertion 16256 Invalid ns [siptrace?replicaSet=rs0&slaveOk=true&readPreference=primaryPreferred.version] ns:siptrace?replicaSet=rs0&slaveOk=true&readPreference=primaryPreferred.version query:{ table_name: "sip_trace" }<br></div><div><br></div><div>looks like the parameters are being appended to the db name</div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature">Kelvin Chua</div></div>
<br><div class="gmail_quote">On Mon, Nov 16, 2015 at 7:26 PM, Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
Can you try with ndb_mongodb module?<br>
<br>
Is anything suspect in the logs of mongodb server?<br>
<br>
What is the version of mongodb-c-driver?<br>
<br>
Cheers,<br>
Daniel<div><div class="h5"><br>
<br>
<div>On 16/11/15 11:12, Kelvin Chua wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div>I also figured the code checks out, so i'm not sure where
to look, there is no error, just that queries return nothing</div>
<div><br>
</div>
If I point the mongo URI just to the primary node, I get this
<div><br>
</div>
<div>
<div>Nov 16 17:59:45 SG1-SIP /usr/local/sbin/kamailio[16451]:
DEBUG: db_mongodb [mongodb_connection.c:55]:
db_mongodb_new_connection(): connection open to: mongodb://<a href="http://10.0.1.2/siptrace" target="_blank">10.0.1.2/siptrace</a></div>
<div>Nov 16 17:59:45 SG1-SIP /usr/local/sbin/kamailio[16451]:
DEBUG: db_mongodb [mongodb_dbase.c:851]: db_mongodb_query():
query to collection [version]</div>
<div>Nov 16 17:59:45 SG1-SIP /usr/local/sbin/kamailio[16451]:
DEBUG: db_mongodb [mongodb_dbase.c:885]: db_mongodb_query():
query filter: { "table_name" : "sip_trace" }</div>
<div>Nov 16 17:59:45 SG1-SIP /usr/local/sbin/kamailio[16451]:
DEBUG: db_mongodb [mongodb_dbase.c:904]: db_mongodb_query():
columns filter: { "table_version" : 1 }</div>
<div>Nov 16 17:59:45 SG1-SIP /usr/local/sbin/kamailio[16451]:
DEBUG: db_mongodb [mongodb_dbase.c:349]:
db_mongodb_get_columns(): 1 columns returned from the query</div>
<div>Nov 16 17:59:45 SG1-SIP /usr/local/sbin/kamailio[16451]:
DEBUG: db_mongodb [mongodb_dbase.c:377]:
db_mongodb_get_columns(): Found a field[0] named:
table_version</div>
<div>Nov 16 17:59:45 SG1-SIP /usr/local/sbin/kamailio[16451]:
DEBUG: db_mongodb [mongodb_dbase.c:396]:
db_mongodb_get_columns(): allocate 16 bytes for RES_NAMES[0]
at 0x7f521bfb3ca8</div>
<div>Nov 16 17:59:45 SG1-SIP /usr/local/sbin/kamailio[16451]:
DEBUG: db_mongodb [mongodb_dbase.c:406]:
db_mongodb_get_columns(): use DB1_INT result type</div>
<div>Nov 16 17:59:45 SG1-SIP /usr/local/sbin/kamailio[16451]:
DEBUG: db_mongodb [mongodb_dbase.c:460]:
db_mongodb_get_columns():
RES_NAMES(0x7f521bfb3ca8)[0]=[table_version] (16)</div>
<div>Nov 16 17:59:45 SG1-SIP /usr/local/sbin/kamailio[16451]:
DEBUG: db_mongodb [mongodb_dbase.c:671]:
db_mongodb_convert_result(): selected document: { "_id" : {
"$oid" : "5642dec7775a1afd9ecc394e" }, "table_version" : 4 }</div>
</div>
<div><br>
</div>
<div><br>
</div>
<div>if i include a replicaset, this happens:</div>
<div><br>
</div>
<div>
<div>Nov 16 17:56:47 SG1-SIP /usr/local/sbin/kamailio[16131]:
DEBUG: db_mongodb [mongodb_connection.c:55]:
db_mongodb_new_connection(): connection open to: mongodb://<a href="http://10.0.1.1" target="_blank">10.0.1.1</a>,10.0.1.2,<a href="http://10.0.1.3/siptrace?replicaSet=rs0&slaveOk=true&readPreference=primaryPreferred" target="_blank">10.0.1.3/siptrace?replicaSet=rs0&slaveOk=true&readPreference=primaryPreferred</a></div>
<div>Nov 16 17:56:47 SG1-SIP /usr/local/sbin/kamailio[16131]:
DEBUG: db_mongodb [mongodb_dbase.c:851]: db_mongodb_query():
query to collection [version]</div>
<div>Nov 16 17:56:47 SG1-SIP /usr/local/sbin/kamailio[16131]:
DEBUG: db_mongodb [mongodb_dbase.c:885]: db_mongodb_query():
query filter: { "table_name" : "sip_trace" }</div>
<div>Nov 16 17:56:47 SG1-SIP /usr/local/sbin/kamailio[16131]:
DEBUG: db_mongodb [mongodb_dbase.c:904]: db_mongodb_query():
columns filter: { "table_version" : 1 }</div>
<div>Nov 16 17:56:47 SG1-SIP /usr/local/sbin/kamailio[16125]:
DEBUG: db_mongodb [mongodb_dbase.c:733]:
db_mongodb_store_result(): no result from mongodb</div>
<div>Nov 16 17:56:47 SG1-SIP /usr/local/sbin/kamailio[16126]:
DEBUG: db_mongodb [mongodb_dbase.c:733]:
db_mongodb_store_result(): no result from mongodb</div>
<div>Nov 16 17:56:47 SG1-SIP /usr/local/sbin/kamailio[16154]:
DEBUG: <core> [sr_module.c:897]: init_mod_child():
rank -2: ndb_mongodb</div>
<div>Nov 16 17:56:47 SG1-SIP /usr/local/sbin/kamailio[16128]:
DEBUG: db_mongodb [mongodb_dbase.c:733]:
db_mongodb_store_result(): no result from mongodb</div>
<div>Nov 16 17:56:47 SG1-SIP /usr/local/sbin/kamailio[16130]:
DEBUG: db_mongodb [mongodb_dbase.c:733]:
db_mongodb_store_result(): no result from mongodb</div>
<div>Nov 16 17:56:47 SG1-SIP /usr/local/sbin/kamailio[16131]:
DEBUG: db_mongodb [mongodb_dbase.c:733]:
db_mongodb_store_result(): no result from mongodb</div>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
</div>
<div class="gmail_extra"><br clear="all">
<div>
<div>Kelvin Chua</div>
</div>
<br>
<div class="gmail_quote">On Mon, Nov 16, 2015 at 5:39 PM,
Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com" target="_blank"></a><a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> Quickly looking at
the code, the ndb_mongodb should work with this kind of
uri. Do you get any errors?<br>
<br>
Can you run with debug=3 and watch for log messages from
ndb_mongodb containing '... added server ...'. Does it
have the replica set uri there?<br>
<br>
Cheers,<br>
Daniel
<div>
<div><br>
<br>
<div>On 16/11/15 09:57, Kelvin Chua wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">yes,
<div><br>
</div>
<div>for example:</div>
<div><br>
</div>
<div>mongodb://<a href="http://10.0.1.1" target="_blank">10.0.1.1</a>,10.0.1.2,<a href="http://10.0.1.3/replicaSet=rs0&slaveOk=true&readPreference=primaryPreferred" target="_blank">10.0.1.3/replicaSet=rs0&slaveOk=true&readPreference=primaryPreferred</a><br>
</div>
<div><br>
</div>
<div>i tried this but it didn't work.</div>
<div><br>
</div>
<div><br>
</div>
<div>according to mongoc documentation, this URI
should be valid</div>
<div><br>
</div>
<div><a href="http://api.mongodb.org/c/1.2.1/mongoc_uri_t.html" target="_blank">http://api.mongodb.org/c/1.2.1/mongoc_uri_t.html</a><br>
</div>
<div><br>
</div>
<div><br>
</div>
</div>
<div class="gmail_extra"><br clear="all">
<div>
<div>Kelvin Chua</div>
</div>
<br>
<div class="gmail_quote">On Thu, Nov 12, 2015 at
3:53 PM, Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> Is
there a specific format of the url for this
case?<br>
<br>
Cheers,<br>
Daniel
<div>
<div><br>
<br>
<div>On 11/11/15 11:41, Kelvin Chua
wrote:<br>
</div>
</div>
</div>
<blockquote type="cite">
<div>
<div>
<div dir="ltr">
<div>anybody ever tried using a
mongodb url with replicasets and
parameters to work</div>
<div>with kamailio?</div>
<br clear="all">
<div>
<div>Kelvin Chua</div>
</div>
</div>
<br>
<fieldset></fieldset>
<br>
</div>
</div>
<pre>_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><span><font color="#888888">
</font></span></pre>
<span><font color="#888888"> </font></span></blockquote>
<span><font color="#888888"> <br>
<pre cols="72">--
Daniel-Constantin Mierla
<a href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Book: SIP Routing With Kamailio - <a href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
Kamailio Advanced Training, Nov 30-Dec 2, Berlin - <a href="http://asipto.com/kat" target="_blank">http://asipto.com/kat</a></pre>
</font></span></div>
<br>
_______________________________________________<br>
SIP Express Router (SER) and Kamailio
(OpenSER) - sr-users mailing list<br>
<a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a><br>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br>
<br>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
<pre cols="72">--
Daniel-Constantin Mierla
<a href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Book: SIP Routing With Kamailio - <a href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
Kamailio Advanced Training, Nov 30-Dec 2, Berlin - <a href="http://asipto.com/kat" target="_blank">http://asipto.com/kat</a></pre>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
<pre cols="72">--
Daniel-Constantin Mierla
<a href="http://twitter.com/#!/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Book: SIP Routing With Kamailio - <a href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
Kamailio Advanced Training, Nov 30-Dec 2, Berlin - <a href="http://asipto.com/kat" target="_blank">http://asipto.com/kat</a></pre>
</div></div></div>
</blockquote></div><br></div>