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 <[email protected]> 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 <[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]. ------------------------------------------------------------------------------ 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].
