[OpenSIPS-Users] Opensips Acc module .

Bogdan-Andrei Iancu bogdan at opensips.org
Mon Sep 21 11:56:11 CEST 2015


Hi Sasmita,

Unfortunately bad news - the db_cachedb can convert SQL to MongoDB only. 
Redis is not supported - my bad :(

Regards,

Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com

On 11.09.2015 09:12, Sasmita Panda wrote:
> Hi Bogdan ,
>
> Now I am trying to compile  opensips-1.11 with db_cachedb module and 
> cachedb_redis module .
> As of now redis is working separately without this db_cachedb . When I 
> am trying to combine both its throwing some
> error .
>
> Error while running opensips :
>
>  NOTICE:db_cachedb:mod_init: initializing module db_cachedb ...
>  NOTICE:cachedb_redis:mod_init: initializing module cachedb_redis ...
>  WARNING:acc:mod_init: Integer flags are now deprecated! Use unique 
> quoted strings!
>  ERROR:db_cachedb:db_cachedb_query: The selected NoSQL driver cannot 
> convert select queries
>  ERROR:core:db_table_version: error in db_query
>  ERROR:core:db_check_table_version: querying version for table acc
>  ERROR:acc:acc_db_init: error during table version check
>  ERROR:acc:mod_init: failed...did you load a database module?
>  ERROR:core:init_mod: failed to initialize module acc
>  ERROR:core:main: error while initializing modules
>  NOTICE:cachedb_redis:destroy: destroy module cachedb_redis ...
>  NOTICE:db_cachedb:destroy: destroy module db_cachedb ...
>
>
>   I was trying to find the solution for this . But I saw you have 
> suggested to someone that , there is some issue in
>  redis module which cant . bellow is the link where you have suggested 
> to use mangodb in place of redis .
>
> http://comments.gmane.org/gmane.comp.voip.opensips.user/27693
>
>  Can you please suggest me what can I do to fix this error . Waiting 
> for your reply .
>
> */Thanks & Regards/*
> /Sasmita Panda/
> /Network Testing and Software Engineer/
> /3CLogic , ph:07827611765/
>
> On Thu, Sep 10, 2015 at 4:35 PM, Sasmita Panda <spanda at 3clogic.com 
> <mailto:spanda at 3clogic.com>> wrote:
>
>     Hi ,
>
>      I saw your reply . But still my problem is not get solved .
>
>           Firstly : For storing data in redis you replied to use  "
>     db_cachedb " 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 .
>
>          Secondly : extra accounting option is also not suitable for
>     my query . let me explain you what extra accounting is doing and
>     what I want .
>
>         As of now accounting is is printing login in my syslog file
>     directly when a transaction completes
>     the logs look like :
>     *ACC: transaction answered:
>     timestamp=1441881036;method=INVITE;from_tag=99022274ae6e465eaaccfe6ac6a004d6;to_tag=e02c1a68;call_id=d56d3914a9a74aa6931f65dc0f11ccfd;code=200;reason=OK;*
>     *
>     *
>        This is already happening . Now if I will use extra accounting
>     then that will append the extra log in this line .
>     For example : I added
>            modparam("acc", "log_extra","uaA=$hdr(User-Agent)")
>     Now new  accounting log will look like bellow format
>     *ACC: transaction answered:
>     timestamp=1441881036;method=INVITE;from_tag=99022274ae6e465eaaccfe6ac6a004d6;to_tag=e02c1a68;call_id=d56d3914a9a74aa6931f65dc0f11ccfd;code=200;reason=OK;**uaA=WebAstra*
>         This adds extra parameter in the accounting message .  It wont
>     solve my problem .
>
>       Now my requirement :
>              Particularly, I just want the transaction timestamp .for
>     both INVITE and BYE , so that I can calculate the total time of a
>     call .
>             I want this particular timestamp in a variable or the
>     entire accounting information in a variable .
>     I can say . I will manage this in opensips.cfg file to print the
>     logs .
>
>         for example :  xlog("L_NOTICE", " Account $acc : callID $ci :
>     method $rm  \n");
>     In $acc , I want the accounting information so that I can store
>     this in redis by key:value pair .
>
>        I hope now you will understand my requirement .Please  help me
>     if you have any solution .
>
>     Regards
>     Sasmita
>
>
>
>
>
>
>
>
>
>
>
>
>     */Thanks & Regards/*
>     /Sasmita Panda/
>     /Network Testing and Software Engineer/
>     /3CLogic , ph:07827611765/
>
>     On Wed, Sep 9, 2015 at 9:37 PM, Bogdan-Andrei Iancu
>     <bogdan at opensips.org <mailto:bogdan at opensips.org>> wrote:
>
>         Hi, see inlines.
>
>         Regards,
>
>         Bogdan-Andrei Iancu
>         OpenSIPS Founder and Developer
>         http://www.opensips-solutions.com
>
>         On 09.09.2015 18:09, Sasmita Panda wrote:
>>
>>         Hi ,
>>
>>            Thank you so much for the early response .
>>
>>              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 .
>>
>>              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 ?
>>
>         [bogdan]
>         with the db_cachedb module, the SQL operations are translated
>         on the fly to noSQL operations without any middle storage.
>>
>>             Aa of now , my opensips is compiled with acc module , SQL
>>         module , cache_redis module and all other module which are
>>         necessary.
>>
>>              I will try your option too by computing it with
>>         db_cachedb .
>>
>         [bogdan]
>         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:
>         http://www.opensips.org/html/docs/modules/1.11.x/db_cachedb.html#id249605
>>
>>
>>              Before that I wanted to do something else . I wanted to
>>         parse some variable of accounting information and wanted to
>>         store that in redis .
>>             For example , $ci :  call_I'd , $rd: remote destination .
>>              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 .
>>
>         [bogdan]
>         See the extra accounting option in the acc module:
>         http://www.opensips.org/html/docs/modules/1.11.x/acc.html#ACC-extra-id
>
>
>
>>              I appropriate your response. But consider my query one
>>         more time and reply if there is any other convenient option .
>>
>>         Regards
>>         Sasmita
>>
>>         On Sep 9, 2015 8:13 PM, "Bogdan-Andrei Iancu"
>>         <bogdan at opensips.org <mailto:bogdan at opensips.org>> wrote:
>>
>>             Hi Sasmita,
>>
>>             The acc module supports the log, sql and AAA interfaces
>>             when comes to writing the CDRs.
>>
>>             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.
>>
>>             Best regards,
>>
>>             Bogdan-Andrei Iancu
>>             OpenSIPS Founder and Developer
>>             http://www.opensips-solutions.com
>>
>>             On 09.09.2015 14:01, Sasmita Panda wrote:
>>>             Hi All ,
>>>
>>>
>>>                  I wanted to store the accounting data of a call in
>>>             redis cache .
>>>             I had compiled the opensips module with cache_redis and
>>>             acc module successfully.
>>>
>>>                   Now , as for my understanding , acc module print
>>>             the logs of accounting information directly .
>>>
>>>                  for acc module i have done be bellow configuration .
>>>                  loadmodule "acc.so"
>>>                  modparam("acc", "log_flag", 2)
>>>                  Then I have done , setflag(2) , where i wanted to
>>>             do accounting .
>>>
>>>                 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 ?
>>>
>>>             Please reply or let me know if any further details needed .
>>>
>>>
>>>             */Thanks & Regards/*
>>>             /Sasmita Panda/
>>>             /Network Testing and Software Engineer/
>>>             /3CLogic , ph:07827611765/
>>>
>>>
>>>             _______________________________________________
>>>             Users mailing list
>>>             Users at lists.opensips.org  <mailto:Users at lists.opensips.org>
>>>             http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>
>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20150921/c1e99088/attachment-0001.htm>


More information about the Users mailing list