David, I tried “reload”, but it only re-reads the conf files. It doesn’t seem to pull in any changes to a re-written to the AstDB. I’ll have to take a look at a remote db server; disappointed that Digium didn’t consider a simpler way to sync the AstDB!
cheers, Shamus > > ------------------------------ > > Message: 6 > Date: Fri, 5 Dec 2014 12:24:39 -0500 > From: David Kerr <da...@kerr.net> > Subject: Re: [Astlinux-users] AstDB replication > To: AstLinux Users Mailing List <astlinux-users@lists.sourceforge.net> > Message-ID: > <CAJJxGdHZ_EH48+cD=ZER_BJT5FZAWuDS5vtQQEMnp=y7pvh...@mail.gmail.com> > Content-Type: text/plain; charset="utf-8" > > Don't know if this will help but I found this... > http://www.open-voip.org/index.php?title=Asterisk_High_availablity > One of the suggestions they have is to use a remote db server, shared by > both asterisk systems. > > Another thought I had... would an asterisk "reload" cause the db file to be > closed/reopened? > > David > > On Fri, Dec 5, 2014 at 9:21 AM, Shamus Rask <sha...@srask.ca> wrote: > >> Lonnie, Michael: >> >> Thank you for your replies. I had taken a look at the Perl script on >> void-info, however, as it states, it is not reliable. I am currently doing >> something similar from the CLI. The issue is that I have no guarantee of >> proper sync without writing a whole write-ack layer. >> >> Lonnie?you are correct that the values are written directly to disc. The >> issue is that if you were to copy the modified db to another instance, >> Asterisk only ?opens? the db on startup. Until it opens the modified db, it >> has no knowledge of any changes. >> >> This seems to be a failing of Asterisk? was hoping someone else had banged >> their head against this one and had some ideas. >> >> many thanks, >> Shamus >> >>> Message: 2 >>> Date: Mon, 1 Dec 2014 21:12:19 -0600 >>> From: Lonnie Abelbeck <li...@lonnie.abelbeck.com> >>> Subject: Re: [Astlinux-users] AstDB replication >>> To: AstLinux Users Mailing List <astlinux-users@lists.sourceforge.net> >>> Message-ID: <c519481f-3367-4bc5-821f-3b8b72cf4...@lonnie.abelbeck.com> >>> Content-Type: text/plain; charset=windows-1252 >>> >>> Hi Shamus, >>> >>> At least with Asterisk 11 which uses sqlite3, the writes seem to go >> directly to disk, for example... >>> >>> shell pbx # echo '.dump' | sqlite3 --batch /mnt/kd/astdb.sqlite3 | grep >> '/foo/bar' >>> (nothing) >>> >>> asterisk pbx*CLI> database put foo bar 0 >>> >>> shell pbx # echo '.dump' | sqlite3 --batch /mnt/kd/astdb.sqlite3 | grep >> '/foo/bar' >>> INSERT INTO "astdb" VALUES('/foo/bar','0'); >>> >>> asterisk pbx*CLI> database del foo bar >>> >>> shell pbx # echo '.dump' | sqlite3 --batch /mnt/kd/astdb.sqlite3 | grep >> '/foo/bar' >>> (nothing) >>> >>> So, from this simple test the /mnt/kd/astdb.sqlite3 file seems to be >> kept current in real time. I suspect occasional rsync's should work though >> you may want to make a temp copy of /mnt/kd/astdb.sqlite3 and rsync that >> just in case the /mnt/kd/astdb.sqlite3 got written to while the rsync was >> still active. >>> >>> Lonnie >>> >>> >>> >>> ------------------------------ >>> >>> Message: 3 >>> Date: Tue, 2 Dec 2014 04:30:04 +0000 >>> From: Michael Knill <michael.kn...@ipcsolutions.com.au> >>> Subject: Re: [Astlinux-users] AstDB replication >>> To: AstLinux Users Mailing List <astlinux-users@lists.sourceforge.net> >>> Message-ID: <a9c0d1b8-a943-4bfb-b1c7-80691b8a1...@ipcsolutions.com.au> >>> Content-Type: text/plain; charset="utf-8" >>> >>> There is a Perl script here that you can modify to achieve this: >>> >>> http://www.voip-info.org/wiki/view/Asterisk+database >>> >>> Regards >>> Michael Knill >> >> >> ------------------------------------------------------------------------------ >> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server >> from Actuate! Instantly Supercharge Your Business Reports and Dashboards >> with Interactivity, Sharing, Native Excel Exports, App Integration & more >> Get technology previously reserved for billion-dollar corporations, FREE >> >> http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk >> _______________________________________________ >> Astlinux-users mailing list >> Astlinux-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/astlinux-users >> >> Donations to support AstLinux are graciously accepted via PayPal to >> pay...@krisk.org. > -------------- next part -------------- > An HTML attachment was scrubbed... > > ------------------------------ > > ------------------------------------------------------------------------------ > Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server > from Actuate! Instantly Supercharge Your Business Reports and Dashboards > with Interactivity, Sharing, Native Excel Exports, App Integration & more > Get technology previously reserved for billion-dollar corporations, FREE > http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk > > ------------------------------ > > _______________________________________________ > Astlinux-users mailing list > Astlinux-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/astlinux-users > > Donations to support AstLinux are graciously accepted via PayPal to > pay...@krisk.org. > > End of Astlinux-users Digest, Vol 101, Issue 2 > ********************************************** ------------------------------------------------------------------------------ Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration & more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk _______________________________________________ Astlinux-users mailing list Astlinux-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/astlinux-users Donations to support AstLinux are graciously accepted via PayPal to pay...@krisk.org.
