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
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
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
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
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
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
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:
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
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
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:
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
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
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,
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
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
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
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
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
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)
+++
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
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
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
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
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
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
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:
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
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
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
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
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
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
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.
-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
: [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
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
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
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
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
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
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
...@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
42 matches
Mail list logo