<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:st1 =
"urn:schemas-microsoft-com:office:smarttags"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16674" name=GENERATOR><!--[if !mso]>
<STYLE>v\:* {
BEHAVIOR: url(#default#VML)
}
o\:* {
BEHAVIOR: url(#default#VML)
}
w\:* {
BEHAVIOR: url(#default#VML)
}
.shape {
BEHAVIOR: url(#default#VML)
}
</STYLE>
<![endif]--><o:SmartTagType name="place"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="country-region"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="City"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><!--[if !mso]>
<STYLE>
st1\:*{behavior:url(#default#ieooui) }
</STYLE>
<![endif]-->
<STYLE>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</STYLE>
</HEAD>
<BODY lang=EN-US vLink=blue link=blue bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Are you sure? that's strange... here's my
cfg:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial
size=2>modparam("dialog","db_url","mysql://openser:xxxxxxx@localhost/openser")</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>modparam("dialog", "enable_stats",
0)<BR>modparam("dialog", "dlg_flag", 5)<BR>modparam("dialog", "default_timeout",
21600)<BR>modparam("dialog", "dlg_match_mode", 1)<BR>modparam("dialog",
"db_mode", 1)</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> if (method=="INVITE")
{<BR> # Store Dialog in
db<BR> setflag(5);</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>You have to look at the table while the call is
online.</FONT></DIV>
<BLOCKQUOTE dir=ltr
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=ali.jawad@splendor.net href="mailto:ali.jawad@splendor.net">Ali
Jawad</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=david.villasmil.work@gmail.com
href="mailto:david.villasmil.work@gmail.com">David Villasmil</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Cc:</B> <A title=users@lists.openser.org
href="mailto:users@lists.openser.org">users@lists.openser.org</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, June 17, 2008 2:28
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [OpenSER-Users] Enter Dialog
info to database</DIV>
<DIV><BR></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Well I did
</SPAN></FONT><FONT face=Wingdings color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Wingdings">J</SPAN></FONT><FONT
face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> and it did not work,
no info is written into the db<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" color=navy size=2><SPAN
style="FONT-SIZE: 11pt; COLOR: navy">With Regards<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" color=navy size=2><SPAN
style="FONT-SIZE: 11pt; COLOR: navy"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" color=navy size=2><SPAN
style="FONT-SIZE: 11pt; COLOR: navy">Ali Jawad<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" color=navy size=2><SPAN
style="FONT-SIZE: 11pt; COLOR: navy">System
Administrator<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" color=navy size=2><SPAN
style="FONT-SIZE: 11pt; COLOR: navy">Splendor Telecom (<A
href="http://www.splendor.net">www.splendor.net</A>)<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><st1:place w:st="on"><st1:City w:st="on"><FONT
face="Times New Roman" color=navy size=2><SPAN
style="FONT-SIZE: 11pt; COLOR: navy">Beirut</SPAN></FONT></st1:City><FONT
color=navy size=2><SPAN style="FONT-SIZE: 11pt; COLOR: navy">,
<st1:country-region
w:st="on">Lebanon</st1:country-region></SPAN></FONT></st1:place><FONT
color=navy size=2><SPAN
style="FONT-SIZE: 11pt; COLOR: navy"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" color=navy size=2><SPAN
style="FONT-SIZE: 11pt; COLOR: navy">Phone: +961 1
373725<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" color=navy size=2><SPAN
style="FONT-SIZE: 11pt; COLOR: navy">Fax: + 961 1
375554<o:p></o:p></SPAN></FONT></P></DIV>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<DIV>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center><FONT
face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">
<HR tabIndex=-1 align=center width="100%" SIZE=2>
</SPAN></FONT></DIV>
<P class=MsoNormal><B><FONT face=Tahoma size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT
face=Tahoma size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> David
Villasmil [mailto:david.villasmil.work@gmail.com] <BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> Tuesday, June 17, 2008 3:27
PM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> Ali Jawad<BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> Re: [OpenSER-Users] Enter Dialog
info to database</SPAN></FONT><o:p></o:p></P></DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-BOTTOM: 12pt"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt">try it and you'll
see<BR><BR>;)<o:p></o:p></SPAN></FONT></P>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">On Tue, Jun 17, 2008 at 2:22 PM, Ali Jawad <<A
href="mailto:ali.jawad@splendor.net">ali.jawad@splendor.net</A>>
wrote:<o:p></o:p></SPAN></FONT></P>
<DIV vlink="blue" link="blue">
<DIV>
<P><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Hi I am setting the
flag as follows</SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> </SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">if
(is_method("INVITE")) {</SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">
setflag(4);</SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">
}</SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> </SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Is that the correct
way ?</SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> </SPAN></FONT><o:p></o:p></P>
<DIV>
<P><FONT face="Times New Roman" color=navy size=2><SPAN
style="FONT-SIZE: 11pt; COLOR: navy">With Regards</SPAN></FONT><o:p></o:p></P>
<P><FONT face="Times New Roman" color=navy size=2><SPAN
style="FONT-SIZE: 11pt; COLOR: navy"> </SPAN></FONT><o:p></o:p></P></DIV>
<P><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> </SPAN></FONT><o:p></o:p></P>
<DIV>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center><FONT
face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">
<HR align=center width="100%" SIZE=2>
</SPAN></FONT></DIV>
<P><B><FONT face=Tahoma size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT
face=Tahoma size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> David
Villasmil [mailto:<A href="mailto:david.villasmil.work@gmail.com"
target=_blank>david.villasmil.work@gmail.com</A>] <BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> Tuesday, June 17, 2008 3:21
PM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> Ali Jawad<BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> Re: [OpenSER-Users] Enter Dialog
info to database</SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<DIV>
<P><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P>
<P style="MARGIN-BOTTOM: 12pt"><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">You have to set the flag on incoming INVITEs to enable
db on the dialog.<o:p></o:p></SPAN></FONT></P>
<DIV>
<P><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">On Tue,
Jun 17, 2008 at 2:18 PM, Ali Jawad <<A href="mailto:ali.jawad@splendor.net"
target=_blank>ali.jawad@splendor.net</A>>
wrote:<o:p></o:p></SPAN></FONT></P>
<DIV vlink="purple" link="blue">
<DIV>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Hi
All</SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> </SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I
have the following dialog module setup </SPAN></FONT><o:p></o:p></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> </SPAN></FONT><o:p></o:p></P>
<P><FONT face="Times New Roman" size=2><SPAN lang=PL style="FONT-SIZE: 11pt">#
----- Dialog -----------</SPAN></FONT><o:p></o:p></P>
<P><FONT face="Times New Roman" size=2><SPAN lang=PL
style="FONT-SIZE: 11pt">modparam("dialog",
"db_url","mysql://openser:xxxxxxxxxxxxx@localhost/openser")</SPAN></FONT><o:p></o:p></P>
<P><FONT face="Times New Roman" size=2><SPAN lang=PL
style="FONT-SIZE: 11pt">modparam("dialog", "db_mode",
1)</SPAN></FONT><o:p></o:p></P>
<P><FONT face="Times New Roman" size=2><SPAN lang=PL
style="FONT-SIZE: 11pt">modparam("dialog", "dlg_flag",
4)</SPAN></FONT><o:p></o:p></P>
<P><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 11pt">modparam("dialog", "enable_stats",
1)</SPAN></FONT><o:p></o:p></P>
<P><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 11pt">modparam("dialog", "rr_param",
"did")</SPAN></FONT><o:p></o:p></P>
<P><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 11pt"> </SPAN></FONT><o:p></o:p></P>
<P><FONT face="Times New Roman" size=2><SPAN style="FONT-SIZE: 11pt">If I
execute</SPAN></FONT><o:p></o:p></P>
<P><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 11pt"> </SPAN></FONT><o:p></o:p></P>
<P><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 11pt">/usr/local/sbin/openserctl fifo
dlg_list</SPAN></FONT><o:p></o:p></P>
<P><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 11pt"> </SPAN></FONT><o:p></o:p></P>
<P><FONT face="Times New Roman" size=2><SPAN style="FONT-SIZE: 11pt">I get the
dialogs that are taking place. However there is nothing written into the
database even for calls longer than 2 minute</SPAN></FONT><o:p></o:p></P>
<P><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 11pt"> </SPAN></FONT><o:p></o:p></P>
<P><FONT face="Times New Roman" size=2><SPAN style="FONT-SIZE: 11pt">Anything
I missed here?</SPAN></FONT><o:p></o:p></P>
<P><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 11pt">Thanks</SPAN></FONT><o:p></o:p></P>
<P><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 11pt"> </SPAN></FONT><o:p></o:p></P>
<P><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV></DIV>
<P style="MARGIN-BOTTOM: 12pt"><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><BR>_______________________________________________<BR>Users
mailing list<BR><A href="mailto:Users@lists.openser.org"
target=_blank>Users@lists.openser.org</A><BR><A
href="http://lists.openser.org/cgi-bin/mailman/listinfo/users"
target=_blank>http://lists.openser.org/cgi-bin/mailman/listinfo/users</A><o:p></o:p></SPAN></FONT></P></DIV></DIV></DIV>
<P><FONT face="Times New Roman" color=#888888 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #888888"><BR><BR>-- <BR>This message has been
scanned for viruses and <BR>dangerous content by <A
href="http://www.mailscanner.info/" target=_blank><B><SPAN
style="FONT-WEIGHT: bold">MailScanner</SPAN></B></A><B><SPAN
style="FONT-WEIGHT: bold">, and is <BR>believed to be clean.
<o:p></o:p></SPAN></B></SPAN></FONT></P></DIV></DIV></DIV>
<P class=MsoNormal><B><FONT face="Times New Roman" size=3><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 12pt"><BR><BR>-- <BR>This message has
been scanned for viruses and <BR>dangerous content by <A
href="http://www.mailscanner.info/">MailScanner</A>, and is <BR>believed to be
clean. </SPAN></FONT></B><o:p></o:p></P></DIV></BLOCKQUOTE></BODY></HTML>