<!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.2900.2873" 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="PersonName"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><!--[if !mso]>
<STYLE>st1\:* {
BEHAVIOR: url(#default#ieooui)
}
</STYLE>
<![endif]-->
<STYLE>@font-face {
font-family: Tahoma;
}
@page Section1 {size: 612.0pt 792.0pt; margin: 72.0pt 90.0pt 72.0pt 90.0pt; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: blue; TEXT-DECORATION: underline
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm; FONT-FAMILY: "Times New Roman"; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
SPAN.EmailStyle20 {
COLOR: navy; FONT-FAMILY: Arial; mso-style-type: personal-reply
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-US vLink=blue link=blue>
<DIV><SPAN class=084434917-09062006><FONT face=Arial color=#0000ff size=2>Two
solutions...</FONT></SPAN></DIV>
<DIV><SPAN class=084434917-09062006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=084434917-09062006><FONT face=Arial color=#0000ff size=2>1. Set
OpenSER to to receive registrations from phones. OpenSER 'fans out' the
registrations to multiple Asterisk boxes with the send() command. This will
break things like call transfer however unless you can guarantee that a
transferred call goes back to the same Asterisk box.</FONT></SPAN></DIV>
<DIV><SPAN class=084434917-09062006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=084434917-09062006><FONT face=Arial color=#0000ff size=2>2.
Write a script that either reads the /var/lib/asterisk/astdb file directly (with
DB module), or screen scrapes it with 'asterisk -rx sip show peers'. Pass the
registration info to sipsak who sends the registrations to the other Asterisk
boxes. Because the registrations come through the normal channels, Asterisk will
update what's in memory and what's in astdb with no locking
situations.</FONT></SPAN></DIV>
<DIV><SPAN class=084434917-09062006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=084434917-09062006><FONT face=Arial color=#0000ff
size=2>Unfortunately this 'enterprise grade' software doesn't work well in a
clustered environment.</FONT></SPAN></DIV>
<DIV><SPAN class=084434917-09062006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=084434917-09062006><FONT face=Arial color=#0000ff
size=2>Doug.</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Jon Schøpzinsky
[mailto:jos@detele.dk]<BR><B>Sent:</B> Friday, June 09, 2006 4:37
AM<BR><B>To:</B> Asterisk Users Mailing List - Non-Commercial
Discussion<BR><B>Subject:</B> SV: [Asterisk-Users] Database file to copy for
active sessions.<BR><BR></FONT></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">There is a solution,
but its not straight forward, and not really documented
anywhere.<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">A possible solution,
is to set a SER server up, before your asterisk, and let that handle the SIP
registrations.<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">Jon<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>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center><FONT
face="Times New Roman" size=3><SPAN lang=DA 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 lang=DA
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">Fra:</SPAN></FONT></B><FONT
face=Tahoma size=2><SPAN lang=DA style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">
asterisk-users-bounces@lists.digium.com
[mailto:asterisk-users-bounces@lists.digium.com] <B><SPAN
style="FONT-WEIGHT: bold">På vegne af </SPAN></B>Shenen Shenen<BR><B><SPAN
style="FONT-WEIGHT: bold">Sendt:</SPAN></B> 9. juni 2006 12:21<BR><B><SPAN
style="FONT-WEIGHT: bold">Til:</SPAN></B> <st1:PersonName w:st="on">Asterisk
Users Mailing List - Non-Commercial Discussion</st1:PersonName><BR><B><SPAN
style="FONT-WEIGHT: bold">Emne:</SPAN></B> Re: [Asterisk-Users] Database file
to copy for active sessions.</SPAN></FONT><SPAN
lang=DA><o:p></o:p></SPAN></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">So my only solution is to use only
X-lite softphone where I can add more than 1 proxy, and a Cisco switchboard
where I can set up a VRRP protocol, so in case of fall, the cisco make the
resolutions of all tables and permited me to call from IP phones like CISCO IP
phones or wi_fi phone without problems or registration in asterisk.....I
think......becouse in this way I see there isn't a solution....right?
<o:p></o:p></SPAN></FONT></P>
<DIV>
<P class=MsoNormal><SPAN class=gmailquote><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt">On 6/9/06, <st1:PersonName
w:st="on"><B><SPAN style="FONT-WEIGHT: bold">Jon
Schøpzinsky</SPAN></B></st1:PersonName> <<A
href="mailto:jos@detele.dk">jos@detele.dk</A>> wrote:</SPAN></FONT></SPAN>
<o:p></o:p></P>
<DIV>
<DIV link="blue" vlink="blue">
<DIV>
<P><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">It's a little more
tricky than that.</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">Our solution involves
an external manager application, some clever IAX2 routing and dialplan mysql
queries. </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">We tried the solution
with just copying the registration, but it seems as though the SIP channel has
the registry information in an </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">Internal data
structure.</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">Jon</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>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center><FONT
face="Times New Roman" size=3><SPAN lang=DA style="FONT-SIZE: 12pt">
<HR align=center width="100%" SIZE=2>
</SPAN></FONT></DIV>
<P><B><FONT face=Tahoma size=2><SPAN lang=DA
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">Fra:</SPAN></FONT></B><FONT
face=Tahoma size=2><SPAN lang=DA style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">
<A href="mailto:asterisk-users-bounces@lists.digium.com"
target=_blank>asterisk-users-bounces@lists.digium.com</A> [mailto:<A
href="mailto:asterisk-users-bounces@lists.digium.com" target=_blank>
asterisk-users-bounces@lists.digium.com</A>] <B><SPAN
style="FONT-WEIGHT: bold">På vegne af </SPAN></B>Shenen Shenen<BR><B><SPAN
style="FONT-WEIGHT: bold">Sendt:</SPAN></B> 9. juni 2006 11:56<BR><B><SPAN
style="FONT-WEIGHT: bold">Til:</SPAN></B> <st1:PersonName w:st="on">Asterisk
Users Mailing List - Non-Commercial Discussion</st1:PersonName><BR><B><SPAN
style="FONT-WEIGHT: bold">Emne:</SPAN></B> Re: [Asterisk-Users] Database file
to copy for active sessions.</SPAN></FONT><SPAN lang=DA>
</SPAN><o:p></o:p></P></DIV></DIV>
<DIV><SPAN id=q_10bb84085c3e07e7_1>
<P><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P>
<DIV>
<P><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">ok...but
if I run a softphone and it is registered in the CLI and I see this:
<o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">--
Registered SIP '655' at <A href="http://192.168.251.10/"
target=_blank>192.168.251.10</A> port 1175 expires
900<o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">this
registration where is put?in which file?<o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">Can I
copy this registration to another machine?<o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><BR><BR> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">On
6/9/06, <st1:PersonName w:st="on"><B><SPAN style="FONT-WEIGHT: bold">Jon
Schøpzinsky</SPAN></B></st1:PersonName> <<A href="mailto:jos@detele.dk"
target=_blank> jos@detele.dk</A>> wrote: <o:p></o:p></SPAN></FONT></P>
<DIV>
<DIV link="blue" vlink="blue">
<DIV>
<P><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Hello</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">I can save you a lot
of time, and tell you that it wont work.</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">It does hold some
registration information in the asterisk database, but most of the information
is kept internally in Asterisk. </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">Just
FYI.</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">Jon</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>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center><FONT
face="Times New Roman" size=3><SPAN lang=DA style="FONT-SIZE: 12pt">
<HR align=center width="100%" SIZE=2>
</SPAN></FONT></DIV>
<P><B><FONT face=Tahoma size=2><SPAN lang=DA
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">Fra:</SPAN></FONT></B><FONT
face=Tahoma size=2><SPAN lang=DA style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">
<A href="mailto:asterisk-users-bounces@lists.digium.com"
target=_blank>asterisk-users-bounces@lists.digium.com</A> [mailto:<A
href="mailto:asterisk-users-bounces@lists.digium.com" target=_blank>
asterisk-users-bounces@lists.digium.com</A>] <B><SPAN
style="FONT-WEIGHT: bold">På vegne af </SPAN></B>Shenen Shenen<BR><B><SPAN
style="FONT-WEIGHT: bold">Sendt:</SPAN></B> 9. juni 2006 11:37<BR><B><SPAN
style="FONT-WEIGHT: bold">Til:</SPAN></B> <A
href="mailto:asterisk-users@lists.digium.com"
target=_blank>asterisk-users@lists.digium.com</A><BR><B><SPAN
style="FONT-WEIGHT: bold">Emne: </SPAN></B>[Asterisk-Users] Database file to
copy for active sessions.</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>
<DIV>
<P><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">How can I
copy all the contenent of the asterisk database to another
machine?<o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">I want
copy all the active sessions from one <A href="mailto:asterisk@home"
target=_blank>asterisk@home </A>to another one and running on the
second(this I can do using vrrp protocol, it isn't a problem), I want
copy only all the active sessions and softphone registrations to another
<A href="mailto:asterisk@home" target=_blank>asterisk@home</A> and then run on
it.<o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<P><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P><FONT face="Times New Roman" size=2><SPAN style="FONT-SIZE: 10pt">--<BR>No
virus found in this incoming message.<BR>Checked by AVG Free
Edition.<BR>Version: 7.1.394 / Virus Database: 268.8.3/359 - Release Date:
08-06-2006 </SPAN></FONT><o:p></o:p></P></DIV></DIV>
<P><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P>
<P><FONT face="Times New Roman" size=2><SPAN style="FONT-SIZE: 10pt">--<BR>No
virus found in this outgoing message.<BR>Checked by AVG Free
Edition.<BR>Version: 7.1.394 / Virus Database: 268.8.3/359 - Release Date:
08-06-2006 </SPAN></FONT><o:p></o:p></P></DIV>
<P style="MARGIN-BOTTOM: 12pt"><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><BR>_______________________________________________
<BR>--Bandwidth and Colocation provided by <A href="http://easynews.com/"
target=_blank>Easynews.com</A> --<BR><BR>Asterisk-Users mailing list<BR>To
UNSUBSCRIBE or update options visit: <BR> <A
href="http://lists.digium.com/mailman/listinfo/asterisk-users"
target=_blank>http://lists.digium.com/mailman/listinfo/asterisk-users</A><o:p></o:p></SPAN></FONT></P></DIV>
<P style="MARGIN-BOTTOM: 12pt"><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P>
<P><FONT face="Times New Roman" size=2><SPAN style="FONT-SIZE: 10pt">--<BR>No
virus found in this incoming message.<BR>Checked by AVG Free
Edition.<BR>Version: 7.1.394 / Virus Database: 268.8.3/359 - Release Date:
08-06-2006 </SPAN></FONT><o:p></o:p></P></DIV></DIV></DIV></SPAN>
<DIV><SPAN id=q_10bb84085c3e07e7_3>
<P class=MsoNormal><SPAN class=e><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></SPAN></P>
<P><FONT face="Times New Roman" size=2><SPAN style="FONT-SIZE: 10pt">--<BR>No
virus found in this outgoing message.<BR>Checked by AVG Free
Edition.<BR>Version: 7.1.394 / Virus Database: 268.8.3/359 - Release Date:
08-06-2006</SPAN></FONT><o:p></o:p></P></DIV>
<P class=MsoNormal style="MARGIN-BOTTOM: 12pt"><FONT face="Times New Roman"
size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN><BR>_______________________________________________
<BR>--Bandwidth and Colocation provided by <A href="http://easynews.com/"
target=_blank>Easynews.com</A> --<BR><BR>Asterisk-Users mailing list<BR>To
UNSUBSCRIBE or update options visit: <BR> <A
href="http://lists.digium.com/mailman/listinfo/asterisk-users"
target=_blank>http://lists.digium.com/mailman/listinfo/asterisk-users</A><BR><BR><o:p></o:p></SPAN></FONT></P></DIV>
<P class=MsoNormal style="MARGIN-BOTTOM: 12pt"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P>
<P><FONT face="Times New Roman" size=2><SPAN style="FONT-SIZE: 10pt">--<BR>No
virus found in this incoming message.<BR>Checked by AVG Free
Edition.<BR>Version: 7.1.394 / Virus Database: 268.8.3/359 - Release Date:
08-06-2006</SPAN></FONT><o:p></o:p></P></DIV><BR>
<P><FONT size=2>--<BR>No virus found in this outgoing message.<BR>Checked by
AVG Free Edition.<BR>Version: 7.1.394 / Virus Database: 268.8.3/359 - Release
Date: 08-06-2006<BR></FONT></P></BLOCKQUOTE></BODY></HTML>