<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1491" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV>
<DIV><FONT face=Arial size=2>Thanks,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>After months of trying to get this working, your
solution fixed the problem. Now the only issue I have is the
following:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Apr 27 12:09:04 max /usr/local/sbin/ser[30538]:
ACC: transaction answered: <A
href="mailto:call_id=93EF8C43-C9E2-4E4C-997C-B1A4DA8FD137@10.200.3.173">call_id=93EF8C43-C9E2-4E4C-997C-B1A4DA8FD137@10.200.3.173</A>,
totag=as113261f7, from=6494485566
<sip:6494485566@voip.fast.co.nz>;tag=3875371437,
i-uri=sip:03@voip.fast.co.nz, method=INVITE, o-uri=sip:03@202.150.105.150:5070,
fromtag=3875371437, code=200, to=<sip:03@voip.fast.co.nz>;tag=as113261f7,
uid=n/a, userpart=03<BR>Apr 27 12:09:04 max /usr/local/sbin/ser[30541]: ACC:
request acknowledged: <A
href="mailto:call_id=93EF8C43-C9E2-4E4C-997C-B1A4DA8FD137@10.200.3.173">call_id=93EF8C43-C9E2-4E4C-997C-B1A4DA8FD137@10.200.3.173</A>,
totag=as113261f7, from=6494485566
<sip:6494485566@voip.fast.co.nz>;tag=3875371437,
i-uri=sip:03@202.150.105.150:5070, method=ACK,
o-uri=sip:03@202.150.105.150:5070, fromtag=3875371437, code=200,
to=<sip:03@voip.fast.co.nz>;tag=as113261f7, uid=n/a, userpart=03<BR>Apr 27
12:09:33 max /usr/local/sbin/ser[30537]: ACC: transaction answered: <A
href="mailto:call_id=93EF8C43-C9E2-4E4C-997C-B1A4DA8FD137@10.200.3.173">call_id=93EF8C43-C9E2-4E4C-997C-B1A4DA8FD137@10.200.3.173</A>,
totag=as113261f7, from=6494485566
<sip:6494485566@voip.fast.co.nz>;tag=3875371437,
i-uri=sip:03@202.150.105.150:5070, method=BYE,
o-uri=sip:03@202.150.105.150:5070, fromtag=3875371437, code=200,
to=<sip:03@voip.fast.co.nz>;tag=as113261f7, uid=n/a,
userpart=03<BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Any ideas?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks</FONT></DIV>
<DIV><FONT face=Arial size=2>Barry</DIV></FONT>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=mschulte@netlogic.net href="mailto:mschulte@netlogic.net">Matt
Schulte</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=edgardo.g@pacific.net.ph
href="mailto:edgardo.g@pacific.net.ph">Edgardo O. Gonzales II</A> ; <A
title=kofi@radiocomplex.com href="mailto:kofi@radiocomplex.com">Kofi
Obiri-Yeboah</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Cc:</B> <A title=serusers@lists.iptel.org
href="mailto:serusers@lists.iptel.org">serusers@lists.iptel.org</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, April 27, 2005 1:13
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [Serusers] ACC into
mysql</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=999040613-26042005><FONT face=Arial color=#0000ff size=2>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:</FONT></SPAN></DIV>
<DIV><SPAN class=999040613-26042005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=999040613-26042005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=999040613-26042005><FONT face=Arial color=#0000ff
size=2>modparam("acc", "db_url",
"mysql://ser:serro@blah.mysql.haha/dbname")<BR># Note flag 2, you will need to
setflag(1); AND setflag(2);</FONT></SPAN></DIV>
<DIV><SPAN class=999040613-26042005><FONT face=Arial color=#0000ff
size=2>modparam("acc", "db_flag", 2)<BR></DIV></FONT></SPAN>
<DIV><SPAN class=999040613-26042005><FONT face=Arial color=#0000ff
size=2>#Note this one logs all failed calls from the invite response, I find
it useful</DIV></FONT></SPAN>
<DIV><SPAN class=999040613-26042005><FONT face=Arial color=#0000ff
size=2>modparam("acc", "failed_transactions", 1)<BR></FONT></SPAN></DIV>
<DIV><SPAN class=999040613-26042005><FONT face=Arial color=#0000ff size=2># In
your route config use something like the following</FONT></SPAN></DIV>
<DIV><SPAN class=999040613-26042005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=999040613-26042005><FONT face=Arial color=#0000ff size=2>#
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</FONT></SPAN></DIV>
<DIV><SPAN class=999040613-26042005><FONT face=Arial color=#0000ff
size=2>...</FONT></SPAN></DIV>
<DIV><SPAN class=999040613-26042005><FONT face=Arial color=#0000ff size=2>if
(!method == "REGISTER" || !method == "INFO" )
{<BR>
setflag(1);<BR>
setflag(2);</FONT></SPAN></DIV>
<DIV><SPAN class=999040613-26042005><FONT face=Arial color=#0000ff
size=2>}</FONT></SPAN></DIV>
<DIV><SPAN class=999040613-26042005><FONT face=Arial color=#0000ff
size=2>...</FONT></SPAN></DIV>
<DIV><SPAN class=999040613-26042005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=999040613-26042005><FONT face=Arial color=#0000ff size=2>#
Doing the above ensure everything gets tagged including BYE's. A good reason
why your BYE's may not get</FONT></SPAN></DIV>
<DIV><SPAN class=999040613-26042005><FONT face=Arial color=#0000ff size=2>#
tagged is possibly because record-route could be relaying the call before the
flag gets set, just a thought..</DIV></FONT></SPAN>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV></BLOCKQUOTE></BLOCKQUOTE></DIV></BODY></HTML>