Shamus, Keep in mind AstLinux supports dialplan Functions with func_odbc, via the file /mnt/kd/asterisk-odbc.sqlite3:
Asterisk ODBC using SQLite3 http://doc.astlinux.org/userdoc:tt_asterisk-odbc Though, I'm not sure how the "libsqlite3odbc.so" handles the SQLite database file being changed at the filesystem level. I suspect it would work better than AstDB for your special case, but a lot of testing is required to see if updating "/mnt/kd/asterisk-odbc.sqlite3" worked properly, else a custom build with MySQL support. Lonnie On Dec 7, 2014, at 6:55 PM, Shamus Rask <sha...@srask.ca> wrote: > 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. ------------------------------------------------------------------------------ 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.
