<!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"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2737.800" name=GENERATOR>
<STYLE>@font-face {
        font-family: Trebuchet MS;
}
@page Section1 {size: 612.0pt 792.0pt; margin: 42.55pt 42.55pt 42.55pt 42.55pt; }
P.MsoNormal {
        FONT-SIZE: 10pt; MARGIN: 0pt; FONT-FAMILY: "Trebuchet MS"
}
LI.MsoNormal {
        FONT-SIZE: 10pt; MARGIN: 0pt; FONT-FAMILY: "Trebuchet MS"
}
DIV.MsoNormal {
        FONT-SIZE: 10pt; MARGIN: 0pt; FONT-FAMILY: "Trebuchet MS"
}
P.MsoFootnoteText {
        FONT-SIZE: 9pt; MARGIN: 0pt; FONT-FAMILY: "Trebuchet MS"
}
LI.MsoFootnoteText {
        FONT-SIZE: 9pt; MARGIN: 0pt; FONT-FAMILY: "Trebuchet MS"
}
DIV.MsoFootnoteText {
        FONT-SIZE: 9pt; MARGIN: 0pt; FONT-FAMILY: "Trebuchet MS"
}
A:link {
        COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
        COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
        COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
        COLOR: purple; TEXT-DECORATION: underline
}
ADDRESS {
        FONT-SIZE: 12pt; MARGIN: 0pt; FONT-FAMILY: "Times New Roman"
}
SPAN.EmailStyle18 {
        COLOR: windowtext; FONT-FAMILY: Arial; mso-style-type: personal-compose
}
DIV.Section1 {
        page: Section1
}
</STYLE>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></HEAD>
<BODY lang=EN-US vLink=purple link=blue bgColor=#ffffff>
<DIV><FONT face="Trebuchet MS" size=2>Dave, you must turn no the persistent
storage of the usrloc table. After this the contacts added in the memory
table can be dumped to mysql.</FONT></DIV>
<DIV><FONT face="Trebuchet MS" size=2>You can also check in the script serctl if
the value of the variable FOREVER_REL is appropiate or is too high for your
mysql aliases table and cause the INSERT to fail. In my network i have reduced
this value to FOREVER_REL=31536000 (one year).</FONT></DIV>
<DIV><FONT face="Trebuchet MS" size=2></FONT> </DIV>
<DIV><FONT face="Trebuchet MS" size=2>... FROM README FILE OF USRLOC MODULE
...</FONT></DIV>
<DIV><FONT face="Trebuchet MS" size=2>1.3.10. db_mode (integer)</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Trebuchet MS" size=2> The usrloc module can utilize
database for persistent contact<BR> storage. If you use database,
your contacts will survive<BR> machine restarts or sw crashes. The
disadvantage is that<BR> accessing database can be very time
consuming. Therefore,<BR> usrloc module implements three database
accessing modes:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Trebuchet MS" size=2> * 0 - This
disables database completely. Only memory will
be<BR> used. Contacts will not survive
restart. Use this value if<BR> you need a
really fast usrloc and contact persistence
is<BR> not necessarry or is provided by
other means.<BR> * 1 - Write-Through scheme. All changes
to usrloc are<BR> immediately reflected in
database too. This is very slow,<BR> but
very reliable. Use this scheme if speed is not
your<BR> priority but need to make sure that
no registered contacts<BR> will be lost
during crash or reboot.<BR> * 2 - Write-Back scheme.
This is a combination of previous<BR> two
schemes. All changes are made to memory and
database<BR> synchronization is done in the
timer. The timer deletes<BR> all expired
contacts and flushes all modified or new<BR>
contacts to database. Use this scheme if you
encounter<BR> high-load peaks and want them
to process as fast as<BR> possible. The mode
will not help at all if the load is<BR> high
all the time. Also, latency of this mode is
much<BR> lower than latency of mode 1, but
slightly higher than<BR> latency of mode
0.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Trebuchet MS" size=2> Warning</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Trebuchet MS" size=2> In case of crash or restart
contacts that are in memory only<BR> and haven't been flushed yet
will get lost. If you want<BR> minimize the risk, use shorter timer
interval.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Trebuchet MS" size=2> Default value is
0.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Trebuchet MS" size=2> Example 1-10. Set db_mode
parameter<BR>...<BR>modparam("usrloc", "db_mode", 2)<BR>...<BR></FONT></DIV>
<DIV><FONT face="Trebuchet MS" 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=dave@fuuz.com href="mailto:dave@fuuz.com">Dave Bath</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</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, July 14, 2004 3:40
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [Serusers] Aliasing
problem</DIV>
<DIV><FONT face="Trebuchet MS" size=2></FONT><FONT face="Trebuchet MS"
size=2></FONT><BR></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face="Courier New" size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">Hey
guys,<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">I have been playing with
SER for a few days now, and apart from having to rebuild all the RPMs to get
it working on FC1 with mysql4 (mysql4 is apparently not officially supported
in FC1 ?!) everything was smooth and dandy. Really enjoying using such a
powerful and flexible product. <o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">However, I have one
problem, and I’ve done my best to trawl all the groups and lists, and debug it
myself and I cannot work out what is going on – perhaps I just don’t
understand how it works properly. I am trying to set numerical aliases
so that incoming routing can be handled more easily by a PSTN gateway. I
am trying the command:<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">Serctl alias add 1000
sip:admin@<sipserver><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">I get a reply that the
alias has been added (once a previous message on this list pointed out that I
needed to add lookup(“aliases”); to ser.cfg)!<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">The problem is the mysql
table is still empty – although serctl says that the alias has been added, it
doesn’t seem to have been. When I try and call “1000” I get a 404 not found,
but calling “admin” works fine. <o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">Does anyone have any
ideas?! <o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">Also, on a slight side
note, I was assuming that the aliases are reboot-safe… they’re stored in the
database and will get reloaded if ser is rebooted. Is this the case by
default or does an option need to be enabled?<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">Sorry for the long
post. Many thanks to everyone who has worked on this, and it would be
fantastic to get this last bit sorted out.<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">Cheers,<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">Dave<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">Inmarsat
Ltd<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">Global Satellite
Communications<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">Regional BGAN
Engineer<o:p></o:p></SPAN></FONT></P></DIV>
<P>
<HR>
<P></P>_______________________________________________<BR>Serusers mailing
list<BR>serusers@lists.iptel.org<BR>http://lists.iptel.org/mailman/listinfo/serusers<BR></BLOCKQUOTE></BODY></HTML>