<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<tt>Hi Sasmita,<br>
<br>
Unfortunately bad news - the db_cachedb can convert SQL to MongoDB
only. Redis is not supported - my bad :(<br>
<br>
Regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
<div class="moz-cite-prefix">On 11.09.2015 09:12, Sasmita Panda
wrote:<br>
</div>
<blockquote
cite="mid:CALf-Q44L=YELaSFzh1eaHch3fgtXyF=AjNZJkJZLE3OjK7b9QA@mail.gmail.com"
type="cite">
<div dir="ltr"><font color="#000000">Hi <span
style="font-size:12.8px;white-space:nowrap"> </span><span
dir="ltr" name="Bogdan-Andrei" class=""
style="font-size:12.8px;white-space:nowrap">Bogdan ,</span></font>
<div><span dir="ltr" name="Bogdan-Andrei" class=""
style="color:rgb(119,119,119);font-size:12.8px;white-space:nowrap"><br>
</span></div>
<div><span dir="ltr" name="Bogdan-Andrei" class=""
style="color:rgb(119,119,119);font-size:12.8px;white-space:nowrap">
</span><span dir="ltr" name="Bogdan-Andrei" class=""
style="font-size:12.8px;white-space:nowrap"><font
color="#000000">Now I am trying to compile opensips-1.11
with db_cachedb module and cachedb_redis module .</font></span></div>
<div><span dir="ltr" name="Bogdan-Andrei" class=""
style="font-size:12.8px;white-space:nowrap"><font
color="#000000">As of now redis is working separately
without this db_cachedb . When I am trying to combine both
its throwing some</font></span></div>
<div><span dir="ltr" name="Bogdan-Andrei" class=""
style="font-size:12.8px;white-space:nowrap"><font
color="#000000">error . </font></span></div>
<div><span dir="ltr" name="Bogdan-Andrei" class=""
style="font-size:12.8px;white-space:nowrap"><font
color="#000000"><br>
</font></span></div>
<div><span dir="ltr" name="Bogdan-Andrei" class=""
style="font-size:12.8px;white-space:nowrap"><font
color="#0000ff">Error while running opensips :</font></span></div>
<div><span dir="ltr" name="Bogdan-Andrei" class=""
style="font-size:12.8px;white-space:nowrap"><font
color="#0000ff"><br>
</font></span></div>
<div><font color="#0000ff"><span dir="ltr" name="Bogdan-Andrei"
class="" style="font-size:12.8px;white-space:nowrap"> </span><span
style="font-size:12.8px;white-space:nowrap"> NOTICE:db_cachedb:mod_init:
initializing module db_cachedb ...</span></font></div>
<div><span style="font-size:12.8px;white-space:nowrap"><font
color="#0000ff"> NOTICE:cachedb_redis:mod_init:
initializing module cachedb_redis ...</font></span></div>
<div><span style="font-size:12.8px;white-space:nowrap"><font
color="#0000ff"> WARNING:acc:mod_init: Integer flags are
now deprecated! Use unique quoted strings!</font></span></div>
<div><span style="font-size:12.8px;white-space:nowrap"><font
color="#0000ff"> ERROR:db_cachedb:db_cachedb_query: The
selected NoSQL driver cannot convert select queries</font></span></div>
<div><span style="font-size:12.8px;white-space:nowrap"><font
color="#0000ff"> ERROR:core:db_table_version: error in
db_query</font></span></div>
<div><span style="font-size:12.8px;white-space:nowrap"><font
color="#0000ff"> ERROR:core:db_check_table_version:
querying version for table acc</font></span></div>
<div><span style="font-size:12.8px;white-space:nowrap"><font
color="#0000ff"> ERROR:acc:acc_db_init: error during table
version check</font></span></div>
<div><span style="font-size:12.8px;white-space:nowrap"><font
color="#0000ff"> ERROR:acc:mod_init: failed...did you load
a database module?</font></span></div>
<div><span style="font-size:12.8px;white-space:nowrap"><font
color="#0000ff"> ERROR:core:init_mod: failed to initialize
module acc</font></span></div>
<div><span style="font-size:12.8px;white-space:nowrap"><font
color="#0000ff"> ERROR:core:main: error while initializing
modules</font></span></div>
<div><span style="font-size:12.8px;white-space:nowrap"><font
color="#0000ff"> NOTICE:cachedb_redis:destroy: destroy
module cachedb_redis ...</font></span></div>
<div><span style="font-size:12.8px;white-space:nowrap"><font
color="#0000ff"> NOTICE:db_cachedb:destroy: destroy module
db_cachedb ...</font></span></div>
<div><span style="font-size:12.8px;white-space:nowrap"><font
color="#0000ff"><br>
</font></span></div>
<div><span style="font-size:12.8px;white-space:nowrap"><font
color="#0000ff"><br>
</font></span></div>
<div><span style="font-size:12.8px;white-space:nowrap"><font
color="#000000"> I was trying to find the solution for
this . But I saw you have suggested to someone that ,
there is some issue in</font></span></div>
<div><span style="font-size:12.8px;white-space:nowrap"><font
color="#000000"> redis module which cant . bellow is the
link where you have suggested to use mangodb in place of
redis .</font></span></div>
<div><span style="font-size:12.8px;white-space:nowrap"><font
color="#000000"><br>
</font></span></div>
<div><span style="font-size:12.8px;white-space:nowrap"><font
color="#000000"> </font><font color="#0000ff"> <a
moz-do-not-send="true"
href="http://comments.gmane.org/gmane.comp.voip.opensips.user/27693">http://comments.gmane.org/gmane.comp.voip.opensips.user/27693</a></font></span><br>
</div>
<div><span style="font-size:12.8px;white-space:nowrap"><font
color="#0000ff"><br>
</font></span></div>
<div><span style="font-size:12.8px;white-space:nowrap"><font
color="#000000"> Can you please suggest me what can I do
to fix this error . Waiting for your reply .</font></span></div>
</div>
<div class="gmail_extra"><br clear="all">
<div>
<div class="gmail_signature">
<div dir="ltr"><b><i>Thanks & Regards</i></b>
<div><i>Sasmita Panda</i></div>
<div><i>Network Testing and Software Engineer</i></div>
<div><i>3CLogic , ph:07827611765</i></div>
</div>
</div>
</div>
<br>
<div class="gmail_quote">On Thu, Sep 10, 2015 at 4:35 PM,
Sasmita Panda <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:spanda@3clogic.com" target="_blank">spanda@3clogic.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">Hi ,
<div><br>
</div>
<div> I saw your reply . But still my problem is not get
solved .</div>
<div><br>
</div>
<div> Firstly : For storing data in redis you replied
to use " <span style="font-size:12.8px">db_cachedb</span><span
style="font-size:12.8px"> " module to convert sql data
to non sql data and store in redis . But this is
module is available in opensips-1.11 but I am using
opensips-1.8 now and this version does not support
"db_cachedb" module . I may use this process latter
when I move to the latest version of opensips . This
is option is not relevant to me now .</span></div>
<div><span style="font-size:12.8px"><br>
</span></div>
<div><span style="font-size:12.8px"> Secondly : extra
accounting option is also not suitable for my query .
let me explain you what extra accounting is doing and
what I want .</span></div>
<div><br>
</div>
<div> As of now accounting is is printing login in my
syslog file directly when a transaction completes </div>
<div>the logs look like :</div>
<div><b><font color="#20124d"> </font><font
color="#0000ff">ACC: transaction answered:
timestamp=1441881036;method=INVITE;from_tag=99022274ae6e465eaaccfe6ac6a004d6;to_tag=e02c1a68;call_id=d56d3914a9a74aa6931f65dc0f11ccfd;code=200;reason=OK;</font></b><br>
</div>
<div><b><font color="#0000ff"><br>
</font></b></div>
<div><font color="#000000"> This is already happening .
Now if I will use extra accounting then that will
append the extra log in this line . </font></div>
<div><font color="#000000">For example : I added </font></div>
<div><font color="#000000"> modparam("acc",
"log_extra","uaA=$hdr(User-Agent)")</font></div>
<div>Now new accounting log will look like bellow format </div>
<div><b><font color="#20124d"> </font><font
color="#0000ff">ACC: transaction answered:
timestamp=1441881036;method=INVITE;from_tag=99022274ae6e465eaaccfe6ac6a004d6;to_tag=e02c1a68;call_id=d56d3914a9a74aa6931f65dc0f11ccfd;code=200;reason=OK;</font></b><font
color="#0000ff"><b>uaA=WebAstra</b></font><br>
</div>
<div> </div>
<div> This adds extra parameter in the accounting
message . It wont solve my problem .</div>
<div><br>
</div>
<div> Now my requirement :</div>
<div> Particularly, I just want the transaction
timestamp .for both INVITE and BYE , so that I can
calculate the total time of a call .</div>
<div> I want this particular timestamp in a
variable or the entire accounting information in a
variable .</div>
<div>I can say . I will manage this in opensips.cfg file
to print the logs .</div>
<div><br>
</div>
<div> for example : xlog("L_NOTICE", " Account $acc :
callID $ci : method $rm \n"); </div>
<div>In $acc , I want the accounting information so that I
can store this in redis by key:value pair . </div>
<div><br>
</div>
<div> I hope now you will understand my requirement
.Please help me if you have any solution .</div>
<div><br>
</div>
<div>Regards</div>
<span class="HOEnZb"><font color="#888888">
<div>Sasmita</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><span style="font-size:12.8px"> </span></div>
<div><span style="font-size:12.8px"><br>
</span></div>
<div><span style="font-size:12.8px"><br>
</span></div>
<div><span style="font-size:12.8px"><br>
</span></div>
<div><span style="font-size:12.8px"><br>
</span></div>
<div><span style="font-size:12.8px"><br>
</span></div>
<div><span style="font-size:12.8px"><br>
</span></div>
<div><span style="font-size:12.8px"><br>
</span></div>
<div><span style="font-size:12.8px"> </span></div>
</font></span></div>
<div class="gmail_extra"><span class=""><br clear="all">
<div>
<div>
<div dir="ltr"><b><i>Thanks & Regards</i></b>
<div><i>Sasmita Panda</i></div>
<div><i>Network Testing and Software Engineer</i></div>
<div><i>3CLogic , ph:07827611765</i></div>
</div>
</div>
</div>
<br>
</span>
<div>
<div class="h5">
<div class="gmail_quote">On Wed, Sep 9, 2015 at 9:37
PM, Bogdan-Andrei Iancu <span dir="ltr"><<a
moz-do-not-send="true"
href="mailto:bogdan@opensips.org"
target="_blank">bogdan@opensips.org</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF"> <tt>Hi,
see inlines.<br>
<br>
Regards,<br>
</tt><span>
<pre cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a moz-do-not-send="true" href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.com</a></pre>
</span><span>
<div>On 09.09.2015 18:09, Sasmita Panda wrote:<br>
</div>
<blockquote type="cite">
<p dir="ltr">Hi ,</p>
<p dir="ltr"> Thank you so much for the
early response . </p>
<p dir="ltr"> First of all I don't want
to store the accounting information in
opensips data base . because it's getting
overloaded with lots of data . </p>
<p dir="ltr"> As you suggested , is this
possible I can convert SQL db to no SQL db
in directly ,without storing the
information in account table of opensips ?
</p>
</blockquote>
</span> [bogdan]<br>
with the db_cachedb module, the SQL operations
are translated on the fly to noSQL operations
without any middle storage.<span><br>
<blockquote type="cite">
<p dir="ltr"> Aa of now , my opensips is
compiled with acc module , SQL module ,
cache_redis module and all other module
which are necessary. </p>
<p dir="ltr"> I will try your option too
by computing it with db_cachedb . <br>
</p>
</blockquote>
</span> [bogdan]<br>
Set the acc module to use DB backend, set a db
url to point to the db_cachedb backend, load the
cache_redis module. See example:<br>
<a moz-do-not-send="true"
href="http://www.opensips.org/html/docs/modules/1.11.x/db_cachedb.html#id249605"
target="_blank">http://www.opensips.org/html/docs/modules/1.11.x/db_cachedb.html#id249605</a><span><br>
<blockquote type="cite">
<p dir="ltr"> <br>
Before that I wanted to do something
else . I wanted to parse some variable of
accounting information and wanted to store
that in redis . <br>
For example , $ci : call_I'd , $rd:
remote destination . <br>
Similarly , can't I get the
accounting data in above variable format ?
May be I need to do some changes in acc
module code . But excatly where should I
change I don't know . </p>
</blockquote>
</span> [bogdan]<br>
See the extra accounting option in the acc
module:<br>
<a moz-do-not-send="true"
href="http://www.opensips.org/html/docs/modules/1.11.x/acc.html#ACC-extra-id"
target="_blank">http://www.opensips.org/html/docs/modules/1.11.x/acc.html#ACC-extra-id</a>
<div>
<div><br>
<br>
<blockquote type="cite">
<p dir="ltr"> I appropriate your
response. But consider my query one more
time and reply if there is any other
convenient option .</p>
<p dir="ltr"> Regards <br>
Sasmita</p>
<div class="gmail_quote">On Sep 9, 2015
8:13 PM, "Bogdan-Andrei Iancu" <<a
moz-do-not-send="true"
href="mailto:bogdan@opensips.org"
target="_blank">bogdan@opensips.org</a>>
wrote:<br type="attribution">
<blockquote class="gmail_quote"
style="margin:0 0 0
.8ex;border-left:1px #ccc
solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
<tt>Hi Sasmita,<br>
<br>
The acc module supports the log,
sql and AAA interfaces when comes
to writing the CDRs.<br>
<br>
To get to a redis DB (a noSQL DB),
you should use acc module with the
sql (db) support plus the
db_cachedb module to convert from
sql to nosql.<br>
<br>
Best regards,<br>
</tt>
<pre cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a moz-do-not-send="true" href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.com</a></pre>
<div>On 09.09.2015 14:01, Sasmita
Panda wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">Hi All ,
<div><br>
</div>
<div><br>
</div>
<div> I wanted to store the
accounting data of a call in
redis cache .</div>
<div>I had compiled the opensips
module with cache_redis and
acc module successfully.</div>
<div><br>
</div>
<div> Now , as for my
understanding , acc module
print the logs of accounting
information directly .</div>
<div><br>
</div>
<div> for acc module i have
done be bellow configuration .</div>
<div> loadmodule "acc.so"</div>
<div> modparam("acc",
"log_flag", 2)</div>
<div> Then I have done ,
setflag(2) , where i wanted to
do accounting .</div>
<div><br>
</div>
<div> Can anyone help me how
to store that accounting
information in a variable, so
that I can use that variable
to store the data in redis
server ?</div>
<div><br>
</div>
<div>Please reply or let me know
if any further details needed
.</div>
<div><br>
</div>
<div><br>
</div>
<div>
<div>
<div>
<div dir="ltr"><b><i>Thanks
& Regards</i></b>
<div><i>Sasmita Panda</i></div>
<div><i>Network Testing
and Software
Engineer</i></div>
<div><i>3CLogic ,
ph:07827611765</i></div>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
Users mailing list
<a moz-do-not-send="true" href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a moz-do-not-send="true" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</div>
</blockquote>
</div>
</blockquote>
<br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
</body>
</html>