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 <[email protected]> > Subject: Re: [Astlinux-users] AstDB replication > To: AstLinux Users Mailing List <[email protected]> > 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 <[email protected]> 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 <[email protected]> >>> Subject: Re: [Astlinux-users] AstDB replication >>> To: AstLinux Users Mailing List <[email protected]> >>> Message-ID: <[email protected]> >>> 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 <[email protected]> >>> Subject: Re: [Astlinux-users] AstDB replication >>> To: AstLinux Users Mailing List <[email protected]> >>> Message-ID: <[email protected]> >>> 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 >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/astlinux-users >> >> Donations to support AstLinux are graciously accepted via PayPal to >> [email protected]. > -------------- 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 > [email protected] > https://lists.sourceforge.net/lists/listinfo/astlinux-users > > Donations to support AstLinux are graciously accepted via PayPal to > [email protected]. > > 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 [email protected] https://lists.sourceforge.net/lists/listinfo/astlinux-users Donations to support AstLinux are graciously accepted via PayPal to [email protected].
