The Asterisk source has a tool to create the db Marcelo
On Thu, 6 Dec 2018, 19:44 Antony Stone <[email protected] wrote: > On Thursday 06 December 2018 at 17:49:25, hw wrote: > > > On 12/05/2018 05:00 PM, Antony Stone wrote: > > > On Wednesday 05 December 2018 at 15:31:38, hw wrote: > > >> I don't see a table for that. > > > > > > You need to create that for yourself. > > > > > > Asterisk can write to database tables, but doesn't help you set them > up, > > > for reasons I can't comment on. > > > > How do I know what the schema needs to be? Does anybody have a scheme > > for the queue_log table (and maybe others)? > > A Google search for "asterisk queue_log schema" gives results such as: > > http://work.mikeboylan.com/posts/2012/03/asterisk-queuelog-to-mysql.html > > https://gist.github.com/melvinlee/f57da3080dff40f71631 > > https://stackoverflow.com/questions/30161384/asterisk-11-queue-log-to-mysql > > https://www.voip-info.org/asterisk-queuelog-on-mysql/ > > > Do I get to see the queries that are being used to write this data, > > No. > > > or do I need to form them myself and enter them into some configuration > file? > > No. > > > >> How dynamic are changes made in the database? > > > > > > If by "dynamic" you mean "quickly used" then the answer is > "immediately". > > > > There's a note in some configuration file saying that dynamic extensions > > are deprecated and suggesting to use func_odbc instead. This func_odbc > > seems to be the most awkward way anyone could think of for this, though. > > I use func_odbc in plenty of situations, but I'm not familiar with it > being > recommended for managing queues. > > Without seeing the "note in some configuration file" that you refer to, > though, > I don't know what to say about this. > > > >> For example, if I want to have an extension 'foobar' and want to ring > > >> different devices depending on some factors (like time of day, for > > >> example), can I modify the entry in the database for the device to > ring > > >> from 'bar' to 'baz', and baz will ring instead of bar from thereon? > > > > > > Yes. > > > > And IIUC the extension would use something like > > 'Dial(SIP/ODBC_PICK_USER(...))' after defining a query for my > > ..._PICK_USER function in func_odbc.conf to return what to dial > > depending on the argument(s) supplied? > > No comment; I don't use this feature myself. > > > How do I make asterisk reload func_odbc.conf? Or is that not needed? > > Not needed. The whole point of configs in database tables is that they > take > effect immediately without having to tell Asterisk to reload anything. > > We did start off just talking about getting queue_log into a database > table, > though. > > > >> Is it possible to use configuration from both the database and the > files > > >> at the same time? > > > > > > Yes. > > > > So far, that seems to work fine :) > > Good. > > > Antony. > > -- > Software development can be quick, high quality, or low cost. > > The customer gets to pick any two out of three. > > Please reply to the > list; > please *don't* CC > me. > > -- > _____________________________________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > > Check out the new Asterisk community forum at: > https://community.asterisk.org/ > > New to Asterisk? Start here: > https://wiki.asterisk.org/wiki/display/AST/Getting+Started > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users
-- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- Check out the new Asterisk community forum at: https://community.asterisk.org/ New to Asterisk? Start here: https://wiki.asterisk.org/wiki/display/AST/Getting+Started asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
