Re: [OpenSIPS-Users] CDR

2024-03-19 Thread Marcin Groszek
Look in to ACC module. On 3/19/2024 7:39 AM, Prathibha B wrote: How to get the Call Detail Record in Opensips? -- Regards, B.Prathibha ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users -- Best

[OpenSIPS-Users] CDR

2024-03-19 Thread Prathibha B
How to get the Call Detail Record in Opensips? -- Regards, B.Prathibha ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users

[OpenSIPS-Users] CDR stopped writing files

2022-11-30 Thread Saint Michael
LOOKING FOR A CONSULTANT My usual engineer Vlad is on vacation util Dec 5th, Today I lost around $1000, of which the client only agreed to pay 50% (they never think that they sent so much traffic), because opensips 3.1 decided to stop writing calls to the hard drive. My question is: what may cause

Re: [OpenSIPS-Users] CDR not generated on 302 redirect

2022-03-15 Thread Ben Newlin
ist Subject: [OpenSIPS-Users] CDR not generated on 302 redirect EXTERNAL EMAIL - Please use caution with links and attachments My new business is to provide 302 Redirect services and Opensips does not genrate a CDR for those calls. Other type of calls do generate a rec

Re: [OpenSIPS-Users] CDR not generated on 302 redirect

2022-03-15 Thread David Villasmil
Look very carefully at the config. There’s probably somewhere it’s enabled. Maybe this https://github.com/OpenSIPS/opensips/blob/master/examples/acc.cfg might give you some ideas… On Tue, 15 Mar 2022 at 14:14, Saint Michael wrote: > My new business is to provide 302 Redirect services and

Re: [OpenSIPS-Users] CDR not generated on 302 redirect

2022-03-15 Thread Alex Balashov
> On Mar 15, 2022, at 10:13 AM, Saint Michael wrote: > > Every call that goes through Opensips should generate a record. Is this just your opinion, or…? -- Alex Balashov | Principal | Evariste Systems LLC Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free) Web: http://www.evaristesys.com/,

[OpenSIPS-Users] CDR not generated on 302 redirect

2022-03-15 Thread Saint Michael
My new business is to provide 302 Redirect services and Opensips does not genrate a CDR for those calls. Other type of calls do generate a record. Is this by design or is it a bug? Every call that goes through Opensips should generate a record. Any idea about what is going on?

Re: [OpenSIPS-Users] CDR rotation

2020-10-06 Thread Saint Michael
it works perfectly, thanks. On Tue, Oct 6, 2020 at 6:18 AM Richard Revels wrote: > https://opensips.org/docs/modules/3.1.x/db_flatstore.html#mi_flat_rotate > > 1) move CDR files to different directory (opensips continues to write to > them) > 2) issue fifo command to cause opensips to write to

Re: [OpenSIPS-Users] CDR rotation

2020-10-06 Thread Richard Revels
https://opensips.org/docs/modules/3.1.x/db_flatstore.html#mi_flat_rotate 1) move CDR files to different directory (opensips continues to write to them) 2) issue fifo command to cause opensips to write to new files 3) insure an accounting record is written to see that new files in original

[OpenSIPS-Users] CDR rotation

2020-10-01 Thread Saint Michael
> > I need to close the CDR files so I can start processing them. I want a new file generated every 60 seconds, if there are calls. is there any way to have opensips behave this way? > > ___ Users mailing list Users@lists.opensips.org

Re: [OpenSIPS-Users] CDR no longer work for permission denied

2020-06-23 Thread Saint Michael
Please ask Vlad Paiu. He fixed it. It turns out that in the new kernel 5.4.0-37-generic of Ubuntu 20.04, the fifo has a lock, so he took these steps: mkdir /home/opensips chown -R opensips:opensips /home/opensips/ /etc/opensips/opensips.cfg , changed to modparam("mi_fifo", "fifo_name",

Re: [OpenSIPS-Users] CDR no longer work for permission denied

2020-06-23 Thread Răzvan Crainea
Can you provide more information abut the environment you're running on? Is it debian or redhat based, could you send us the fifo file permissions, as well as the user OpenSIPS is running with? Best regards, Răzvan Crainea OpenSIPS Core Developer http://www.opensips-solutions.com On 6/14/20

[OpenSIPS-Users] CDR no longer work for permission denied

2020-06-14 Thread Saint Michael
/usr/local/sbin/opensipsctl fifo flat_rotate /usr/local//lib64/opensips/opensipsctl/opensipsctl.fifo: line 121: /tmp/opensips_fifo: Permission denied This happened after upgrading my kernel to 5.4.0-37-generic although I cannot see the connection. ___

Re: [OpenSIPS-Users] CDR capturing not working

2020-04-29 Thread Bogdan-Andrei Iancu
Hi there, What is this cdr_worker.sh file you are talking about ?? Regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developer https://www.opensips-solutions.com On 4/29/20 6:17 AM, Saint Michael wrote: I checked the database and I missed the CDR for many calls.  Later I found them

[OpenSIPS-Users] CDR capturing not working

2020-04-28 Thread Saint Michael
I checked the database and I missed the CDR for many calls. Later I found them sitting in files in /var/log/opensips I run it manually cdr_worker.sh and got this error ./cdr_worker.sh lockfile: Sorry, giving up on "/var/run/opensips_cdr_worker.lock"which means is not firing because the lock is

[OpenSIPS-Users] CDR is not generated in rabbitmq server while call detected as fraud

2019-11-17 Thread Darpan Patel
I have subscribed events like E_ACC_CDR ,E_ACC_EVENT , E_ACC_MISSED_EVENT in startup_route to connect rabbitmq server for sending CDR related information of calls and also used event_routes E_FRD_WARNING and E_FRD_CRITICAL to detect fraud calls. while call detected as a fraud after hang up the

Re: [OpenSIPS-Users] CDR in Flat files

2017-06-08 Thread Kirill Galinurov
Yes i change my rsyslog.conf and now. Everything looks OK ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] CDR in Flat files

2017-06-06 Thread Michele Pinassi
Did you check your rsyslog (/etc/rsyslogd.conf) configuration ? Michele On 05/06/2017 10:52, Kirill Galinurov wrote: > Hi ALL. > I try to store cdr in flat files. > My config is > loadmodule "acc.so" > modparam("acc", "detect_direction", 0) > modparam("acc", "extra_fields", "log: src_ip;

[OpenSIPS-Users] CDR in Flat files

2017-06-05 Thread Kirill Galinurov
Hi ALL. I try to store cdr in flat files. My config is loadmodule "acc.so" modparam("acc", "detect_direction", 0) modparam("acc", "extra_fields", "log: src_ip; dst_ip") modparam("acc", "leg_fields", "log: caller; callee") modparam("acc", "log_facility", "LOG_DAEMON")

Re: [OpenSIPS-Users] CDR when terminating dialog

2016-02-17 Thread Dragomir Haralambiev
Hi, Thanks for your replay. When internet connection is broken with UA, is appear follow message: INFO:dialog:reply_from_caller: terminating dialog ( due to timeout ) with callid = [698777468 Openips send BYE but not make CDR. I try with modparam("acc", "failed_transaction_flag",

Re: [OpenSIPS-Users] CDR when terminating dialog

2016-02-17 Thread Jim DeVito
That looks like you would receive a response indication a timeout. (408 maybe?) If so setting this flag on the transaction should do it. http://www.opensips.org/html/docs/modules/2.2.x/acc#id294062 --- Jim DeVito On 2016-02-17 05:27, Dragomir Haralambiev wrote: Hello, How to setup

[OpenSIPS-Users] CDR when terminating dialog

2016-02-17 Thread Dragomir Haralambiev
Hello, How to setup Opensips 2.2 to make CDR when dialog is terminate by timeout. On log I see follow message: INFO:dialog:reply_from_caller: terminating dialog ( due to timeout ) with callid= Best regards, Dragomir ___ Users mailing list

Re: [OpenSIPS-Users] CDR search slow in CDRTool

2015-12-01 Thread Tomas Andersen
ng list Date: Monday 30 November 2015 at 16:19 To: OpenSIPS users mailling list Subject: Re: [OpenSIPS-Users] CDR search slow in CDRTool Hi, As for the usability questions, from trusted peers it matches the ip to a reseller so this can be billed. The subscriber table is used to find the RPID fr

Re: [OpenSIPS-Users] CDR search slow in CDRTool

2015-11-30 Thread Tomas Andersen
Hi again. I have set up wireshark to check why the CDR rating engine uses so much time. The following SQL queries are run from CDRTool to my OpenSIPS server: select * from domain; select * from trusted_peers; Select rpid from subscriber where username = ‘+47’ and domain =

Re: [OpenSIPS-Users] CDR search slow in CDRTool

2015-11-30 Thread Tijmen de Mes
> From: <users-boun...@lists.opensips.org > <mailto:users-boun...@lists.opensips.org>> on behalf of Tomas Andersen > Reply-To: OpenSIPS users mailling list > Date: Monday 30 November 2015 at 13:31 > To: OpenSIPS users mailling list > Subject: Re: [OpenSIPS-Users] CDR s

Re: [OpenSIPS-Users] CDR search slow in CDRTool

2015-11-30 Thread Tijmen de Mes
Hi Tomas, That query should not take 10 seconds. Here it completes in 0.02s according to mysql. The query is used to determine the flow of the calls. After the query is executed in CDRTool, more logic follows. It can easily be that the delay is in there. If web normalizing is enabled and the

Re: [OpenSIPS-Users] CDR search slow in CDRTool

2015-11-30 Thread Tomas Andersen
en de Mes Reply-To: OpenSIPS users mailling list Date: Monday 30 November 2015 at 13:01 To: OpenSIPS users mailling list Subject: Re: [OpenSIPS-Users] CDR search slow in CDRTool Hi Tomas, That query should not take 10 seconds. Here it completes in 0.02s according to mysql. The query is used to det

Re: [OpenSIPS-Users] CDR search slow in CDRTool

2015-11-30 Thread Tomas Andersen
oun...@lists.opensips.org<mailto:users-boun...@lists.opensips.org>> on behalf of Tomas Andersen Reply-To: OpenSIPS users mailling list Date: Monday 30 November 2015 at 13:31 To: OpenSIPS users mailling list Subject: Re: [OpenSIPS-Users] CDR search slow in CDRTool Hi. Thank you for responding. I ha

[OpenSIPS-Users] CDR search slow in CDRTool

2015-11-27 Thread Tomas Andersen
Hi I have set up CDRTool to read CDRs from my radius database for OpenSIP calls. I am successfully rating calls, but everytime I search for CDR records using the CDRTool GUI it takes 1-3 minutes before the search result window is shown. If there are no matching records the result window is

Re: [OpenSIPS-Users] CDR in flat file

2014-03-06 Thread Răzvan Crainea
Hi, Gary! The configuration file looks ok. Can you check if the /var/log/acc directory exists? Do you see any errors in the logs? Best regards, Razvan Crainea OpenSIPS Core Developer http://www.opensips-solutions.com On 03/05/2014 11:40 PM, Gary Nyquist wrote: Hi, I am trying to configure

[OpenSIPS-Users] CDR in flat file

2014-03-05 Thread Gary Nyquist
Hi, I am trying to configure the OpenSIPS v.1.10 to make it write the CDRs to flat files. But no luck yet. The opensips.cfg looks like this: ... loadmodule dialog.so modparam(dialog, dlg_match_mode, 1) loadmodule acc.so modparam(acc, detect_direction, 1) modparam(acc, failed_transaction_flag,

Re: [OpenSIPS-Users] cdr and Dialog on opensips-cp

2012-08-25 Thread Engineer voip
: From: Ali Pey ali...@gmail.com Subject: Re: [OpenSIPS-Users] cdr and Dialog on opensips-cp To: Engineer voip forvo...@gmail.com Cc: OpenSIPS users mailling list users@lists.opensips.org Date: Friday, August 24, 2012, 8:37 AM Did you get an error for the dlg_list command? Did you try

Re: [OpenSIPS-Users] cdr and Dialog on opensips-cp

2012-08-24 Thread Binan AL Halabi
Hi, have you configured files  db.inc.php and boxes.global.inc.php ? --- On Thu, 8/23/12, Engineer voip forvo...@gmail.com wrote: From: Engineer voip forvo...@gmail.com Subject: Re: [OpenSIPS-Users] cdr and Dialog on opensips-cp To: OpenSIPS users mailling list users@lists.opensips.org Date

Re: [OpenSIPS-Users] cdr and Dialog on opensips-cp

2012-08-24 Thread Engineer voip
Subject: Re: [OpenSIPS-Users] cdr and Dialog on opensips-cp To: OpenSIPS users mailling list users@lists.opensips.org Date: Thursday, August 23, 2012, 3:00 PM Hi, someone can help me please !! 2012/8/23, Engineer voip forvo...@gmail.com: Hello, I did all this procedures but don't work my

Re: [OpenSIPS-Users] cdr and Dialog on opensips-cp

2012-08-24 Thread Bogdan-Andrei Iancu
? --- On Thu, 8/23/12, Engineer voipforvo...@gmail.com wrote: From: Engineer voipforvo...@gmail.com Subject: Re: [OpenSIPS-Users] cdr and Dialog on opensips-cp To: OpenSIPS users mailling listusers@lists.opensips.org Date: Thursday, August 23, 2012, 3:00 PM Hi, someone can help me please !! 2012/8/23

Re: [OpenSIPS-Users] cdr and Dialog on opensips-cp

2012-08-24 Thread Engineer voip
']['charts']=1; Thanks 2012/8/24, Binan AL Halabibinanalhal...@yahoo.com: Hi, have you configured files db.inc.php and boxes.global.inc.php ? --- On Thu, 8/23/12, Engineer voipforvo...@gmail.com wrote: From: Engineer voipforvo...@gmail.com Subject: Re: [OpenSIPS-Users] cdr and Dialog

Re: [OpenSIPS-Users] cdr and Dialog on opensips-cp

2012-08-24 Thread Engineer voip
Subject: Re: [OpenSIPS-Users] cdr and Dialog on opensips-cp To: OpenSIPS users mailling listusers@lists.opensips.org Date: Thursday, August 23, 2012, 3:00 PM Hi, someone can help me please !! 2012/8/23, Engineer voipforvo...@gmail.com: Hello, I did all this procedures but don't work

Re: [OpenSIPS-Users] cdr and Dialog on opensips-cp

2012-08-24 Thread yassine.ab
Hi, trying to put the ip address instead of the path -- View this message in context: http://opensips-open-sip-server.1449251.n2.nabble.com/cdr-and-Dialog-on-opensips-cp-tp7581329p7581380.html Sent from the OpenSIPS - Users mailing list archive at Nabble.com.

Re: [OpenSIPS-Users] cdr and Dialog on opensips-cp

2012-08-24 Thread Ali Pey
: From: Engineer voipforvo...@gmail.com Subject: Re: [OpenSIPS-Users] cdr and Dialog on opensips-cp To: OpenSIPS users mailling listusers@lists.opensips.org Date: Thursday, August 23, 2012, 3:00 PM Hi, someone can help me please !! 2012/8/23, Engineer voipforvo...@gmail.com

Re: [OpenSIPS-Users] cdr and Dialog on opensips-cp

2012-08-24 Thread Binan AL Halabi
Hi, restart DB restart opensips reload apache (service httpd reload) //Binan --- On Fri, 8/24/12, Ali Pey ali...@gmail.com wrote: From: Ali Pey ali...@gmail.com Subject: Re: [OpenSIPS-Users] cdr and Dialog on opensips-cp To: Engineer voip forvo...@gmail.com Cc: OpenSIPS users mailling list

Re: [OpenSIPS-Users] cdr and Dialog on opensips-cp

2012-08-24 Thread Engineer voip
...@gmail.com wrote: From: Ali Pey ali...@gmail.com Subject: Re: [OpenSIPS-Users] cdr and Dialog on opensips-cp To: Engineer voip forvo...@gmail.com Cc: OpenSIPS users mailling list users@lists.opensips.org Date: Friday, August 24, 2012, 8:37 AM Did you get an error for the dlg_list command? Did

Re: [OpenSIPS-Users] cdr and Dialog on opensips-cp

2012-08-24 Thread Ali Pey
ali...@gmail.com Subject: Re: [OpenSIPS-Users] cdr and Dialog on opensips-cp To: Engineer voip forvo...@gmail.com Cc: OpenSIPS users mailling list users@lists.opensips.org Date: Friday, August 24, 2012, 8:37 AM Did you get an error for the dlg_list command? Did you try to make some calls

[OpenSIPS-Users] cdr and Dialog on opensips-cp

2012-08-23 Thread Engineer voip
Hello All, I'm using opensips-cp with opensips 1.8, and i can do the call between two users but i can't get the CDRs and Dialog informations by using opensips-cp. someone can help me, please? thanks ___ Users mailing list Users@lists.opensips.org

Re: [OpenSIPS-Users] cdr and Dialog on opensips-cp

2012-08-23 Thread Binan AL Halabi
Hi, what you get when you click dialog under system list on opensips-cp ? //Binan --- On Thu, 8/23/12, Engineer voip forvo...@gmail.com wrote: From: Engineer voip forvo...@gmail.com Subject: [OpenSIPS-Users] cdr and Dialog on opensips-cp To: OpenSIPS users mailling list users@lists.opensips.org

Re: [OpenSIPS-Users] cdr and Dialog on opensips-cp

2012-08-23 Thread Engineer voip
, Engineer voip forvo...@gmail.com wrote: From: Engineer voip forvo...@gmail.com Subject: [OpenSIPS-Users] cdr and Dialog on opensips-cp To: OpenSIPS users mailling list users@lists.opensips.org Date: Thursday, August 23, 2012, 3:06 AM Hello All, I'm using opensips-cp with opensips 1.8, and i can

Re: [OpenSIPS-Users] cdr and Dialog on opensips-cp

2012-08-23 Thread Binan AL Halabi
,username,password and database)  - call the script from the cron check the opensips-cp INSTALL file for this. //Binan --- On Thu, 8/23/12, Engineer voip forvo...@gmail.com wrote: From: Engineer voip forvo...@gmail.com Subject: Re: [OpenSIPS-Users] cdr and Dialog on opensips-cp To: OpenSIPS

Re: [OpenSIPS-Users] cdr and Dialog on opensips-cp

2012-08-23 Thread Engineer voip
...@gmail.com Subject: Re: [OpenSIPS-Users] cdr and Dialog on opensips-cp To: OpenSIPS users mailling list users@lists.opensips.org Date: Thursday, August 23, 2012, 6:15 AM hello, when i click dialog i get the message ERROR:mi_fifo:mi_fifo_server: command dlg_list is not available thank you

Re: [OpenSIPS-Users] cdr accounting on opensips restart

2011-12-19 Thread Jayesh Nambiar
Hi Razwan, This is the pastebin of logs after shutdown: http://pastebin.com/tvmrSqwB This is the pastebin of logs after start which is huge: http://pastebin.com/C6K4Jt5y --- Jayesh On Wed, Dec 7, 2011 at 5:46 PM, Razvan Crainea razvancrai...@opensips.orgwrote: Hi, Jayesh! I need the logs

Re: [OpenSIPS-Users] cdr accounting on opensips restart

2011-12-08 Thread Razvan Crainea
Hi, Ryan! Unfortunately it won't work. The problem is that the mysql library detects both VARCHAR and VARBINARY as string types. Only BLOB and TEXT are mapped as binary objects. You can find more information here[1]. As far as I know, only the CDR accounting can generate binary data in dialog

Re: [OpenSIPS-Users] cdr accounting on opensips restart

2011-12-08 Thread Ryan Bullock
Awesome information. Dialogs seem to persist over a restart, however I am not sure if they are accounting. I will do a switch back to the defaults, better safe than sorry. Thanks, Ryan 2011/12/8 Razvan Crainea razvancrai...@opensips.org: Hi, Ryan! Unfortunately it won't work. The problem is

Re: [OpenSIPS-Users] cdr accounting on opensips restart

2011-12-07 Thread Razvan Crainea
Hi, Jayesh ! The root of the problem is the accX_flags dialog variable isn't properly serialized. What I'm trying to find out is why this happens, that's why I will need some extra debug as I can't figure out the problem there. So please apply this last patch and try again. It should be

Re: [OpenSIPS-Users] cdr accounting on opensips restart

2011-12-07 Thread Jayesh Nambiar
Hi Razvan, I don't see the patch attached !! --- Jayesh On Wed, Dec 7, 2011 at 2:57 PM, Razvan Crainea razvancrai...@opensips.orgwrote: Hi, Jayesh ! The root of the problem is the accX_flags dialog variable isn't properly serialized. What I'm trying to find out is why this happens, that's

Re: [OpenSIPS-Users] cdr accounting on opensips restart

2011-12-07 Thread Razvan Crainea
Sorr, I forgot to attach it. Here it is. Regards, -- Răzvan Crainea OpenSIPS Developer On 12/07/2011 11:59 AM, Jayesh Nambiar wrote: Hi Razvan, I don't see the patch attached !! --- Jayesh On Wed, Dec 7, 2011 at 2:57 PM, Razvan Crainea razvancrai...@opensips.org

Re: [OpenSIPS-Users] cdr accounting on opensips restart

2011-12-07 Thread Jayesh Nambiar
Hi Razvan, Applied the patch and re-tested it. Here the logs that you are interested in specifically: Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]: DBG:dialog:write_pair: Dumping var name: accX_flags value: #026 Dec 7 15:50:33 dev /usr/local/sbin/opensips[8011]: DBG:dialog:write_pair:

Re: [OpenSIPS-Users] cdr accounting on opensips restart

2011-12-07 Thread Razvan Crainea
Hi, Jayesh! And what is the string in the database? You can see it in the database after you kill opensips with the following command: select vars from dialog; Regards, -- Răzvan Crainea OpenSIPS Developer On 12/07/2011 12:24 PM, Jayesh Nambiar wrote: Hi Razvan, Applied the patch and

Re: [OpenSIPS-Users] cdr accounting on opensips restart

2011-12-07 Thread Jayesh Nambiar
This is the string what I see when I query the dialog table for vars: accX_flags# |accX_db#( 2 1 11 1002 12013386166 919833171405 0 203.153.53.158 203.153.53.136 0 17 0 2 IP India - Mobile 919 9198 2 1 2 4 0.0150 0.0130 0 0. 0.0226 1. 6 1 6 1 1 2 2 2 Aal Izz

Re: [OpenSIPS-Users] cdr accounting on opensips restart

2011-12-07 Thread Razvan Crainea
Hi, Jayesh! It seems like the problem appears while parsing the string got from the database, so after opensips is restarted. The patch attached should give us more information about the error. Regards, -- Răzvan Crainea OpenSIPS Developer On 12/07/2011 12:37 PM, Jayesh Nambiar wrote:

Re: [OpenSIPS-Users] cdr accounting on opensips restart

2011-12-07 Thread Jayesh Nambiar
Hi Razwan, I have applied the patch and made it working. Do you still only need the logs after opensips shutdown or also the logs after opensips restarts. --- Jayesh On Wed, Dec 7, 2011 at 4:35 PM, Razvan Crainea razvancrai...@opensips.orgwrote: Hi, Jayesh! It seems like the problem appears

Re: [OpenSIPS-Users] cdr accounting on opensips restart

2011-12-07 Thread Razvan Crainea
Hi, Jayesh! I need the logs after opensips restarts. The result might also be pretty large. Regards, -- Răzvan Crainea OpenSIPS Developer On 12/07/2011 02:14 PM, Jayesh Nambiar wrote: Hi Razwan, I have applied the patch and made it working. Do you still only need the logs after opensips

Re: [OpenSIPS-Users] cdr accounting on opensips restart

2011-12-07 Thread Razvan Crainea
Hi, Jayesh! Can you check in your mysql database if the vars column from the dialog table is declared as TEXT or BLOB and not CHAR? If not, please change your column into BLOB: ALTER TABLE dialog CHANGE vars vars BLOB; Regards, -- Răzvan Crainea OpenSIPS Developer On 12/07/2011 02:27 PM,

Re: [OpenSIPS-Users] cdr accounting on opensips restart

2011-12-07 Thread Jayesh Nambiar
Hi Razvan, This actually solved the problem. Thank you very much. It was defined as VARCHAR instead of TEXT. Thank you very much for all the efforts. Really appreciate it. Need to get hold of my DB guy for the stupid mistake !! --- Jayesh On Wed, Dec 7, 2011 at 8:13 PM, Razvan Crainea

Re: [OpenSIPS-Users] cdr accounting on opensips restart

2011-12-07 Thread Ryan Bullock
Could a VARBINARY be used here instead? We actually use a memory table for the dialog table to reduce load on our disk and it does not support BLOB or TEXT, so instead we changed it to a large VARCHAR. The mysql docs suggest you can treat a TEXT the same as a VARCHAR, but obviously there are

Re: [OpenSIPS-Users] cdr accounting on opensips restart

2011-12-06 Thread Razvan Crainea
Hi, Jayesh! Yes, I will need extra debugging to see what's happening. Can you send[1] the log in full debugging, taken after OpenSIPS is restarted? [1] pastebin.com Regards, -- Răzvan Crainea OpenSIPS Developer On 12/06/2011 08:13 AM, Jayesh Nambiar wrote: Hi Razvan, The dialogs are

Re: [OpenSIPS-Users] cdr accounting on opensips restart

2011-12-06 Thread Jayesh Nambiar
Hi Razvan, Here are the logs with Dumping var name: Dec 6 17:24:13 dev /usr/local/sbin/opensips[1958]: DBG:dialog:dialog_update_db: inserting new dialog 0x7fa29f2d0708 Dec 6 17:24:13 dev /usr/local/sbin/opensips[1958]: DBG:dialog:write_pair: Dumping var name: accX_flags value: #026 Dec 6

Re: [OpenSIPS-Users] cdr accounting on opensips restart

2011-12-06 Thread Razvan Crainea
Hi, Jayesh! Something is really weird there. I've attached attached a new patch done against a fresh copy. Can you please try this one? Thanks and regards! -- Răzvan Crainea OpenSIPS Developer On 12/06/2011 01:52 PM, Jayesh Nambiar wrote: Hi Razvan, Here are the logs with Dumping var

Re: [OpenSIPS-Users] cdr accounting on opensips restart

2011-12-06 Thread Jayesh Nambiar
Hi Razvan, I am not able to patch. I get the following: patching file dlg_db_handler.c Hunk #1 FAILED at 789. Hunk #2 FAILED at 796. 2 out of 2 hunks FAILED -- saving rejects to file dlg_db_handler.c.rej. This is what I see in dlg_db_handler.c.rej: --- dlg_db_handler.c(revision 8586) +++

[OpenSIPS-Users] cdr accounting on opensips restart

2011-12-06 Thread Jayesh Nambiar
Hi Razvan, I just did a fresh download from http://opensips.org/pub/opensips/latest/src/. I did apply the patch successfully and I still have the problem of CDR not being recorded after restart. Here is the syslog pasted after opensips was being shut down: Dec 6 20:20:13 dev

Re: [OpenSIPS-Users] cdr accounting on opensips restart

2011-12-05 Thread Bogdan-Andrei Iancu
Hi Jayesh, Razvan is checking the code for you and running some tests. Regards, Bogdan On 12/03/2011 02:49 PM, Jayesh Nambiar wrote: Hi Bogdan, Just writing to ask if you got a chance to check if this is a bug or some error in my config !! Thanks, --- Jayesh On Fri, Dec 2, 2011 at 11:23

Re: [OpenSIPS-Users] cdr accounting on opensips restart

2011-12-05 Thread Razvan Crainea
Hi Jayesh, Can you please check if the dialogs are loaded back after a restart. Also, do you see any errors in your log? Regards, -- Ra(zvan Crainea OpenSIPS Developer On 12/05/2011 02:31 PM, Bogdan-Andrei Iancu wrote: Hi Jayesh, Razvan is checking the code for you and running some

Re: [OpenSIPS-Users] cdr accounting on opensips restart

2011-12-05 Thread Jayesh Nambiar
Hi Razvan, The dialogs are definitely loaded on startup and it also matches with existing dialog. I use this to make sure the dialog is matched in my script. So even after a restart, I see the Dialog Matched in my syslog. if(has_totag()) { if(match_dialog()) { log(1, Dialog

Re: [OpenSIPS-Users] cdr accounting on opensips restart

2011-12-03 Thread Jayesh Nambiar
Hi Bogdan, Just writing to ask if you got a chance to check if this is a bug or some error in my config !! Thanks, --- Jayesh On Fri, Dec 2, 2011 at 11:23 AM, Jayesh Nambiar jayesh.v...@gmail.comwrote: Hi Bogdan, The exact version used is 1.7.1 stable release compiled from src. Output of

[OpenSIPS-Users] cdr accounting on opensips restart

2011-12-01 Thread Jayesh Nambiar
Hello All, I am planning to use CDR accounting in my script starting from version 1.7 and it looks fine and working as expected. Although I had one doubt, how do I make sure the CDR accounting still happens if the opensips is restarted and BYE comes after the restart. I have tried db_mode 3 for

Re: [OpenSIPS-Users] cdr accounting on opensips restart

2011-12-01 Thread Bogdan-Andrei Iancu
Hi Jayesh, If dialog module has restart persistence ( db modes 1, 2 and 3) the CDRs should survive across a restart. If this is not the case for you, let me know the exact version of opensips you are running (do opensips -V). Regards, Bogdan On 12/01/2011 12:28 PM, Jayesh Nambiar wrote:

Re: [OpenSIPS-Users] cdr accounting on opensips restart

2011-12-01 Thread Jayesh Nambiar
Hi Bogdan, The exact version used is 1.7.1 stable release compiled from src. Output of opensips -V is: version: opensips 1.7.1-notls (x86_64/linux) flags: STATS: Off, USE_IPV6, USE_TCP, DISABLE_NAGLE, USE_MCAST, SHM_MEM, SHM_MMAP, PKG_MALLOC, F_MALLOC, FAST_LOCK-ADAPTIVE_WAIT

Re: [OpenSIPS-Users] CDR Accounting not working from this provider

2011-05-31 Thread Bogdan-Andrei Iancu
Hi James, The dialog module does not see the BYE, so the dialog is counted as still ongoing so no CDR is generated. Now, about the BYE - by default dialog module exclusively uses a cookie (the did param in the RR/Route header) to do the matching. As you can see in the trace, because you do

[OpenSIPS-Users] CDR Accounting not working from this provider

2011-04-22 Thread jamesp
I have a new provider that I am evaluating and the built-in CDR functionality of the acc module is not working for them. I have tested with a second provider and it works fine. I can only assume that something somewhere in the SIP dialog is causing it to loose track of it. Here is the SIP

Re: [OpenSIPS-Users] CDR Accounting

2011-01-25 Thread Anton Zagorskiy
Hi Dave. So just to be sure I'm clear on this. $Ts rounds down ( truncates ) the current second. So using $avp(s:start_time) = $Ts.$Tsm; would give something like 12343253.543233 and always be accurate? You should understand that $Ts.$Tsm is two independent calls to the system time function. So

Re: [OpenSIPS-Users] CDR Accounting

2011-01-25 Thread Adrian Georgescu
Why do you need microseconds in accounting? All database queries, round trip time to the database on the LAN, radius requests, all add up times impossible to measure. What is the point of accounting microseconds for a process that itself takes unknown amount of time but several order of

Re: [OpenSIPS-Users] CDR Accounting

2011-01-24 Thread Dave Singer
Thanks for that clarification! So just to be sure I'm clear on this. $Ts rounds down ( truncates ) the current second. So using $avp(s:start_time) = $Ts.$Tsm; would give something like 12343253.543233 and always be accurate? Further (standard ACC [without dialog]) you could just put $Tsm in the

[OpenSIPS-Users] CDR Accounting

2011-01-19 Thread Andrew Philp
Hi All, Managed to finally get this working, mainly my stupidity in the end. Just one more question if anyone can tell me. Is it possible to have a better reflection on the duration? At present my system is only showing whole seconds and not milliseconds and this would be helpful.

Re: [OpenSIPS-Users] CDR Accounting

2011-01-19 Thread Anton Zagorskiy
-telecom.ru From: users-boun...@lists.opensips.org [mailto:users-boun...@lists.opensips.org] On Behalf Of Andrew Philp Sent: Wednesday, January 19, 2011 2:12 PM To: OpenSIPS users mailling list Subject: [OpenSIPS-Users] CDR Accounting Hi All, Managed to finally get this working, mainly my stupidity

Re: [OpenSIPS-Users] CDR Accounting

2011-01-19 Thread Andrew Philp
: [OpenSIPS-Users] CDR Accounting Hi All, Managed to finally get this working, mainly my stupidity in the end. Just one more question if anyone can tell me.  Is it possible to have a better reflection on the duration?  At present my system is only showing whole seconds and not milliseconds and this would

Re: [OpenSIPS-Users] CDR Accounting

2011-01-19 Thread Brett Nemeroff
On Wed, Jan 19, 2011 at 5:11 AM, Andrew Philp andrew.ph...@just-tek.comwrote: Just one more question if anyone can tell me. Is it possible to have a better reflection on the duration? At present my system is only showing whole seconds and not milliseconds and this would be helpful. I

Re: [OpenSIPS-Users] CDR Accounting

2011-01-19 Thread Brett Nemeroff
On Wed, Jan 19, 2011 at 8:32 AM, Andrew Philp andrew.ph...@just-tek.comwrote: We are looking to use this for billing directly and for most of our customers are billed on a hundredth of a second. Does this make sense? Sure it does, but I've never heard of sub second billing. The ACC module

Re: [OpenSIPS-Users] CDR Accounting

2011-01-19 Thread Dave Singer
Be careful when using $Tsm. I read a thread the other day that was just talking about it and that it returns milliseconds since midnight, not epoch. So if that is true you will need to somehow handle calls that cross midnight for duration at least and start/answer/end of call if including the

Re: [OpenSIPS-Users] CDR Accounting

2011-01-19 Thread a.zagorskiy
It was my conversation, and I told about 1) $Tsm is MICROseconds (6 digits) 2) It is microseconds of a current second. On Wed, 19 Jan 2011 09:29:28 -0800 Dave Singer dave.sin...@wideideas.com wrote: Be careful when using $Tsm. I read a thread the other day that was just talking about it and

Re: [OpenSIPS-Users] CDR Accounting Example

2011-01-19 Thread Andrew Hash
thanks! From: Anton Zagorskiy a.zagors...@oyster-telecom.ru To: andrew.ph...@just-tek.com; OpenSIPS users mailling list users@lists.opensips.org Sent: Tue, January 18, 2011 3:29:29 AM Subject: Re: [OpenSIPS-Users] CDR Accounting Example Hi Andrew. modparam

[OpenSIPS-Users] CDR Accounting Example

2011-01-18 Thread Andrew Philp
Hi All, Has anyone got a working example of the CDR accounting working with mysql. I have tried to get this sorted but I feel I am missing something. Thanks in adavnce ___ Users mailing list Users@lists.opensips.org

Re: [OpenSIPS-Users] CDR Accounting Example

2011-01-18 Thread Anton Zagorskiy
...@lists.opensips.org] On Behalf Of Andrew Philp Sent: Tuesday, January 18, 2011 2:00 PM To: OpenSIPS users mailling list Subject: [OpenSIPS-Users] CDR Accounting Example Hi All, Has anyone got a working example of the CDR accounting working with mysql.  I have tried to get this sorted but I feel I am missing

[OpenSIPS-Users] cdr vs drouting

2009-09-04 Thread Szasz Szabolcs
Hi, What are main benefits of the drouting vs cdr module? Which of them should I use if I have thousands of routes? Thanks Szasz Szabolcs ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] cdr vs drouting

2009-09-04 Thread Brett Nemeroff
I *think* you mean the LCR module. You want to use the drouting module. It's effectively the replacement for LCR. It's faster and supports more routes. My dr_rules table has over 3 million rules in it. -Brett On Fri, Sep 4, 2009 at 9:34 AM, Szasz Szabolcs szasz.szabo...@gmail.comwrote: Hi,

Re: [OpenSIPS-Users] CDR Tools

2009-04-24 Thread Adrian Georgescu
As long as you end up in MySQL with the same data as Radius server use to write you do not need per se Freeradius. Adrian On Apr 23, 2009, at 7:15 PM, Darren Sessions wrote: Is using freeradius a requirement with CDRTools? or can I use DB access for everything? If so, how do I go about

Re: [OpenSIPS-Users] CDR Tools

2009-04-24 Thread Darren Sessions
Does that mean I can't delete the radacct tables? or can I just point CDRTools in a different direction via global.inc? and if so, what would I point it to? the acc table? On Apr 24, 2009, at 1:42 AM, Adrian Georgescu wrote: As long as you end up in MySQL with the same data as Radius

[OpenSIPS-Users] CDR Tools

2009-04-23 Thread Darren Sessions
Is using freeradius a requirement with CDRTools? or can I use DB access for everything? If so, how do I go about that or can someone point me in the right direction? I've got CDRTools up and running btw with the Freeradius server, it just seems a bit of an extra component when I've got the