[Serusers] ACC into mysql

Matt Schulte mschulte at netlogic.net
Wed Apr 27 14:49:14 CEST 2005


Assuming you relay properly, when Asterisk asterisk hangs up it should
pass the BYE to SER then SER relays it to the next party(s). This
doesn't sound like an acc problem, as you might have guessed :-)
 
I would have to see most of your config. When you say you have to "click
hangup" what do you mean.. on xlite? Is xlite the UA or is it hanging
off of Asterisk? If not Asterisk, what's hanging off of Asterisk?
 
    Matt

	-----Original Message-----
	From: Barry Murphy [mailto:barry at unix.co.nz] 
	Sent: Tuesday, April 26, 2005 7:17 PM
	To: Barry Murphy; Matt Schulte
	Cc: serusers at lists.iptel.org
	Subject: Re: [Serusers] ACC into mysql
	
	
	Sorry for replying to my own post, however I have discovered
something.
	 
	When I call asterisk and asterisk hangup, my UA is still
connected till I hangup myself, however SER does see the hangup as I
looked in the acc serweb.
	 
<sip:03 at voip.fast.co.nz> <javascript:
open_ctd_win2('sip%3A03%40voip.fast.co.nz',
'sip%3A6494485566%40voip.fast.co.nz');> 	 today 12:09
00:00:29	 caller	
<sip:03 at voip.fast.co.nz> <javascript:
open_ctd_win2('sip%3A03%40voip.fast.co.nz',
'sip%3A6494485566%40voip.fast.co.nz');> 	 today 12:09
00:00:50	 callee	
	 
	So my question is, if the remote end hangs up, how do I
disconnect the caller end?
	 
	Using XLite.
	 
	Barry

		----- Original Message ----- 
		From: Barry Murphy <mailto:barry at unix.co.nz>  
		To: Matt Schulte <mailto:mschulte at netlogic.net>  
		Cc: serusers at lists.iptel.org 
		Sent: Wednesday, April 27, 2005 12:13 PM
		Subject: Re: [Serusers] ACC into mysql

		Thanks,
		 
		After months of trying to get this working, your
solution fixed the problem. Now the only issue I have is the following:
		 
		When I call 03 ( UA -> SER -> Asterisk ) the date and
time is read out to the user, asterisk then hangs up the call, however
SER doesn't see the hangup, I have to manualy click hangup and then SER
gives the BYE.
		 
		Apr 27 12:09:04 max /usr/local/sbin/ser[30538]: ACC:
transaction answered:
call_id=93EF8C43-C9E2-4E4C-997C-B1A4DA8FD137 at 10.200.3.173,
totag=as113261f7, from=6494485566
<sip:6494485566 at voip.fast.co.nz>;tag=3875371437,
i-uri=sip:03 at voip.fast.co.nz, method=INVITE,
o-uri=sip:03 at 202.150.105.150:5070, fromtag=3875371437, code=200,
to=<sip:03 at voip.fast.co.nz>;tag=as113261f7, uid=n/a, userpart=03
		Apr 27 12:09:04 max /usr/local/sbin/ser[30541]: ACC:
request acknowledged:
call_id=93EF8C43-C9E2-4E4C-997C-B1A4DA8FD137 at 10.200.3.173,
totag=as113261f7, from=6494485566
<sip:6494485566 at voip.fast.co.nz>;tag=3875371437,
i-uri=sip:03 at 202.150.105.150:5070, method=ACK,
o-uri=sip:03 at 202.150.105.150:5070, fromtag=3875371437, code=200,
to=<sip:03 at voip.fast.co.nz>;tag=as113261f7, uid=n/a, userpart=03
		Apr 27 12:09:33 max /usr/local/sbin/ser[30537]: ACC:
transaction answered:
call_id=93EF8C43-C9E2-4E4C-997C-B1A4DA8FD137 at 10.200.3.173,
totag=as113261f7, from=6494485566
<sip:6494485566 at voip.fast.co.nz>;tag=3875371437,
i-uri=sip:03 at 202.150.105.150:5070, method=BYE,
o-uri=sip:03 at 202.150.105.150:5070, fromtag=3875371437, code=200,
to=<sip:03 at voip.fast.co.nz>;tag=as113261f7, uid=n/a, userpart=03
		
		Any ideas?
		 
		Thanks
		Barry
		 
		 

			----- Original Message ----- 
			From: Matt Schulte
<mailto:mschulte at netlogic.net>  
			To: Edgardo O. Gonzales II
<mailto:edgardo.g at pacific.net.ph>  ; Kofi Obiri-Yeboah
<mailto:kofi at radiocomplex.com>  
			Cc: serusers at lists.iptel.org 
			Sent: Wednesday, April 27, 2005 1:13 AM
			Subject: RE: [Serusers] ACC into mysql

			This particular config (I don't think?) won't
log to a DB, additionally you need to setflag(1); somewhere in your
config. We tried to set on "outbound" only originally and didn't have
much luck so I set it near the top. To log to (my)sql you will
additionally need to set another flag and setup similar mod params:
			 
			 
			modparam("acc", "db_url",
"mysql://ser:serro@blah.mysql.haha/dbname")
			# Note flag 2, you will need to setflag(1); AND
setflag(2);
			modparam("acc", "db_flag", 2)
			
			#Note this one logs all failed calls from the
invite response, I find it useful
			modparam("acc", "failed_transactions", 1)
			
			# In your route config use something like the
following
			 
			# This is pretty much near the top, while ACC
won't log reg's or INFO anyway, I just thought it'd be a little cleaner
to have
			...
			if (!method == "REGISTER" || !method == "INFO" )
{
			                setflag(1);
			                setflag(2);
			}
			...
			 
			# Doing the above ensure everything gets tagged
including BYE's. A good reason why your BYE's may not get
			# tagged is possibly because record-route could
be relaying the call before the flag gets set, just a thought..

		
  _____  


		

		_______________________________________________
		Serusers mailing list
		serusers at lists.iptel.org
		http://lists.iptel.org/mailman/listinfo/serusers
		

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20050427/6d9d2c37/attachment.htm>


More information about the sr-users mailing list