[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