[asterisk-users] how to use a database

[Marcelo Terres]

The Asterisk source has a tool to create the db

Marcelo

On Thu, 6 Dec 2018, 19:44 Antony Stone <Antony.Stone at asterisk.open.source.it
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20181206/e2247e88/attachment.html>