<div dir="ltr">Hi Daniel,<div><br></div><div>Thank you for your reply,</div><div><br></div><div>I did what you suggested in your last email, but the issue remains, maybe i did something wrong, so in order we try understand if i did or not something wrong please have a look at the mongodb commands to create db, collection and document.</div><div><br></div><div><div>> use kamailio</div><div>switched to db kamailio</div><div>> </div></div><div>> db<br></div><div><div>kamailio</div><div>> db.createCollection("version")<br></div></div><div><div>> show collections</div><div>system.indexes</div><div>version</div><div>> </div></div><div>> db.getCollection("version").insert({table_name: "presentity", table_version: 4 })<br></div><div>WriteResult({ "nInserted" : 1 })<br></div><div>> db.getCollection("version").find({})<br></div><div><div>{ "_id" : ObjectId("55d2fb67b04c015195aee4b1"), "table_name" : "presentity", "table_version" : 4 }</div></div><div><br></div><div>Best Regards</div><div>José Seabra</div><div><br></div><div><br></div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">2015-08-18 7:09 GMT+01:00 Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
Indeed the issue is related to checking the version table. You have
to create a collection named "version" in kamailio database, then
add the records for the tables you are using with the fields:<br>
<br>
- table_name corresponding to the table name (e.g., presentity)<br>
- table_version value as in lib/srdb1/schema/* (e.g., 4)<br>
<br>
If you have kamailio database created in mysql (or other sql
server), you can simply look at the content of table "version".<br>
<br>
If I get to better internet connection while traveling these days, I
will try to put together proper guidelines.<br>
<br>
Cheers,<br>
Daniel<div><div class="h5"><br>
<br>
<div>On 17/08/15 19:10, José Seabra wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">This shouldn't check the table version in mongodb
or i'm wrong?
<div>Best regards</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">2015-08-17 16:45 GMT+01:00 José Seabra
<span dir="ltr"><<a href="mailto:joseseabra4@gmail.com" target="_blank">joseseabra4@gmail.com</a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">I have tried that but kamailio gave me the
following error:
<div><br>
<div>
<div> 0(2344) ERROR: <core> [db.c:435]:
db_check_table_version(): invalid version 0 for
table presentity found, expected 4 (check table
structure and table "version")</div>
<div> 0(2344) ERROR: presence [presence.c:358]:
mod_init(): error during table version check</div>
<div> 0(2344) ERROR: <core> [sr_module.c:945]:
init_mod(): Error while initializing module presence
(/usr/local/lib64/kamailio/modules/presence.so)</div>
<div>ERROR: error while initializing modules</div>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div>Presence module configuration:</div>
<div><br>
</div>
<div>
<div>modparam("presence", "server_address", "sip:<a href="http://10.0.20.100:5080" target="_blank">10.0.20.100:5080</a>")</div>
<div>modparam("presence", "subs_db_mode", 3)</div>
<div>modparam("presence", "expires_offset", 60)</div>
<div>modparam("presence", "send_fast_notify", 0)</div>
<div>modparam("presence", "clean_period", 30)</div>
<div>modparam("presence", "publ_cache", 0)</div>
<div>modparam("presence", "sip_uri_match", 1)<br>
</div>
<div>modparam("presence", "waitn_time", 1)</div>
<div>modparam("presence", "notifier_processes", 0)</div>
<div>modparam("presence", "db_url",
"mongodb://localhost/kamailio")<br>
</div>
</div>
<div><br>
</div>
<div>Best Regards</div>
<div>José Seabra</div>
<div><br>
</div>
</div>
</div>
<div>
<div>
<div class="gmail_extra"><br>
<div class="gmail_quote">2015-08-17 16:33 GMT+01:00
Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> Hello,<br>
<br>
do not remember exactly if you need to create an
empty collection, anyhow, the main idea is that
there is no table definition, because mongo is a
document-storage like engine. The records store
all the details about all the fields.<br>
<br>
In other words, you should be ready to go after
basic setup of mongodb collection and
configuring kamailio modules to use the server.<br>
<br>
Cheers,<br>
Daniel
<div>
<div><br>
<br>
<div>On 17/08/15 16:51, José Seabra wrote:<br>
</div>
</div>
</div>
<blockquote type="cite">
<div>
<div>
<div dir="ltr">Hello all,
<div>
<div>I would like to test my presence
server using db_mongodb as database
server instead of using mysql, but i
don't find any documentation
explaining how i can configure
mongodb database(data structure) for
presence or even for the other
kamailio modules.</div>
<div><br>
</div>
<div>
<div>Can someone guide me in this
setup?<br>
</div>
<div><br>
</div>
Best Regards</div>
<div><br>
</div>
<div>
<div>-- <br>
</div>
<div>Cumprimentos
<div>José Seabra</div>
</div>
</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></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>
<br clear="all">
<div><br>
</div>
-- <br>
</div>
</div>
<div>Cumprimentos<span><font color="#888888">
<div>José Seabra</div>
</font></span></div>
</blockquote>
</div>
<br>
</div>
<br clear="all">
<div><br>
</div>
-- <br>
<div>Cumprimentos
<div>José Seabra</div>
</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></pre>
</div></div></div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature">Cumprimentos<div>José Seabra</div></div>
</div>