<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
So ndb_mongodb is fine, nothing to backport.<br>
<br>
For db_mongodb, the issue was in the common db url parser -- I will
backport that one.<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<div class="moz-cite-prefix">On 19/11/15 02:57, Kelvin Chua wrote:<br>
</div>
<blockquote
cite="mid:CAMF97-ce6sSQpX_R7p1cGFsSnt_DMTYVrHmFfayWA9LgEzCmWA@mail.gmail.com"
type="cite">
<div dir="ltr">careless mistake, working fine now.
<div>would be best to backport :)</div>
<div>thanks so much!</div>
</div>
<div class="gmail_extra"><br clear="all">
<div>
<div class="gmail_signature">Kelvin Chua</div>
</div>
<br>
<div class="gmail_quote">On Tue, Nov 17, 2015 at 9:54 PM,
Daniel-Constantin Mierla <span dir="ltr"><<a
moz-do-not-send="true" href="mailto:miconda@gmail.com"
target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:miconda@gmail.com">miconda@gmail.com</a></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"> Have you used quotes
around the uri? Like:<br>
<br>
modparam("ndb_mongodb", "server",
"name=mgs1;uri='mongodb://<a moz-do-not-send="true"
href="http://10.0.1.1" target="_blank">10.0.1.1</a>,10.0.1.2,<a
moz-do-not-send="true"
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>
<br>
Cheers,<br>
Daniel
<div>
<div class="h5"><br>
<br>
<div>On 17/11/15 12:32, Kelvin Chua wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">awesome! db_mongodb works perfectly
<div><br>
</div>
<div>but ndb_mongodb returns error</div>
<div><br>
</div>
<div>
<div>Nov 17 19:29:11 SG1-SIP kamailio: DEBUG:
ndb_mongodb [mongodb_client.c:155]:
mongodbc_add_server(): added
server[mgs1]=mongodb://<a
moz-do-not-send="true"
href="http://10.0.1.1" target="_blank">10.0.1.1</a></div>
</div>
<div>
<div>Nov 17 19:29:27 SG1-SIP
/usr/local/sbin/kamailio[29970]: ERROR:
ndb_mongodb [mongodb_client.c:306]:
mongodbc_exec_cmd(): Cursor failure: not
master</div>
</div>
<div><br>
</div>
<div><br>
</div>
<div>it only adds the first host on the mongo uri,
since it is not master, refuses to insert it</div>
<div><br>
</div>
</div>
<div class="gmail_extra"><br clear="all">
<div>
<div>Kelvin Chua</div>
</div>
<br>
<div class="gmail_quote">On Tue, Nov 17, 2015 at
4:20 PM, Daniel-Constantin Mierla <span
dir="ltr"><<a moz-do-not-send="true"
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 the patch from next commit?<br>
<br>
<a moz-do-not-send="true"
href="https://github.com/kamailio/kamailio/commit/4da5d898da9a0a8f2780dcdf864354098268a7e9"
target="_blank">https://github.com/kamailio/kamailio/commit/4da5d898da9a0a8f2780dcdf864354098268a7e9</a><br>
<br>
If all runs ok, I will consider it for
backporting.<br>
<br>
Cheers,<br>
Daniel
<div>
<div><br>
<br>
<div>On 17/11/15 08:37, Kelvin Chua
wrote:<br>
</div>
<blockquote type="cite">
<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>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
moz-do-not-send="true"
href="mailto:miconda@gmail.com"
target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:miconda@gmail.com">miconda@gmail.com</a></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><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
moz-do-not-send="true"
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
moz-do-not-send="true"
href="http://10.0.1.1" target="_blank">10.0.1.1</a>,10.0.1.2,<a
moz-do-not-send="true"
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
moz-do-not-send="true"
href="mailto:miconda@gmail.com" target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:miconda@gmail.com">miconda@gmail.com</a></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
moz-do-not-send="true" href="http://10.0.1.1" target="_blank">10.0.1.1</a>,10.0.1.2,<a
moz-do-not-send="true"
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
moz-do-not-send="true"
href="http://api.mongodb.org/c/1.2.1/mongoc_uri_t.html" target="_blank"><a class="moz-txt-link-freetext" href="http://api.mongodb.org/c/1.2.1/mongoc_uri_t.html">http://api.mongodb.org/c/1.2.1/mongoc_uri_t.html</a></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
moz-do-not-send="true" href="mailto:miconda@gmail.com" target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:miconda@gmail.com">miconda@gmail.com</a></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 moz-do-not-send="true" href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a>
<a moz-do-not-send="true" 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 moz-do-not-send="true" href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a moz-do-not-send="true" href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Book: SIP Routing With Kamailio - <a moz-do-not-send="true" href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
Kamailio Advanced Training, Nov 30-Dec 2, Berlin - <a moz-do-not-send="true" 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
moz-do-not-send="true"
href="mailto:sr-users@lists.sip-router.org" target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a></a><br>
<a
moz-do-not-send="true"
href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users"
target="_blank"><a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a></a><br>
<br>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
<pre cols="72">--
Daniel-Constantin Mierla
<a moz-do-not-send="true" href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a moz-do-not-send="true" href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Book: SIP Routing With Kamailio - <a moz-do-not-send="true" href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
Kamailio Advanced Training, Nov 30-Dec 2, Berlin - <a moz-do-not-send="true" 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 moz-do-not-send="true" href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a moz-do-not-send="true" href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Book: SIP Routing With Kamailio - <a moz-do-not-send="true" href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
Kamailio Advanced Training, Nov 30-Dec 2, Berlin - <a moz-do-not-send="true" 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 moz-do-not-send="true" href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a moz-do-not-send="true" href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Book: SIP Routing With Kamailio - <a moz-do-not-send="true" href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
Kamailio Advanced Training, Nov 30-Dec 2, Berlin - <a moz-do-not-send="true" 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 moz-do-not-send="true" href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a moz-do-not-send="true" href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Book: SIP Routing With Kamailio - <a moz-do-not-send="true" href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
Kamailio Advanced Training, Nov 30-Dec 2, Berlin - <a moz-do-not-send="true" href="http://asipto.com/kat" target="_blank">http://asipto.com/kat</a></pre>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla
<a class="moz-txt-link-freetext" href="http://twitter.com/#!/miconda">http://twitter.com/#!/miconda</a> - <a class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a>
Book: SIP Routing With Kamailio - <a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a>
Kamailio Advanced Training, Nov 30-Dec 2, Berlin - <a class="moz-txt-link-freetext" href="http://asipto.com/kat">http://asipto.com/kat</a></pre>
</body>
</html>