Re: [asterisk-users] how to use a database

2018-12-10 Thread Marcelo Terres 
Oh, I didn't know that.

Regards,

Marcelo H. Terres 
IM: mhter...@jabber.mundoopensource.com.br
https://www.mundoopensource.com.br
https://twitter.com/mhterres
https://linkedin.com/in/marceloterres

On Mon, 10 Dec 2018 at 14:50, Floimair Florian  wrote:
>
> Alembic currently doesn't cover queue_logs.
> As of now it only covers configuration, voicemail and cdr.
>
>
>
>
> With best regards
>
> Florian Floimair
> Innovation - Software-Development
>
> COMMEND INTERNATIONAL GMBH
> A-5020 Salzburg, Saalachstraße 51
> http://www.commend.com 
>
> Security and Communication by Commend
>
> FN 178618z | LG Salzburg
>
> Am 07.12.18, 15:56 schrieb "asterisk-users im Auftrag von hw" 
> :
>
> On 12/07/2018 03:36 PM, Administrator TOOTAI wrote:
> > Le 07/12/2018 à 14:32, hw a écrit :
> >
> > [...]
> >>
> >> Queues seem to be the only way to have several phones ring at once, or
> >> are there other ways?
> >
> > Dial(SIP/Phone1/Phone2&.../Phonex,,)
> >
>
> Good to know, thanks!
>
>
> What are the entries needed in the queue_members table when using odbc?
> Alembic made the primary key so that each queue can only have one entry
> (What is an interface here?), and there's probably a reason for that.
> How do you enter several members for a queue?  Asterisk seems to either
> rather crash than to create a queue, or to do nothing.
>
> --
> _
> -- 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

-- 
_
-- 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

Re: [asterisk-users] how to use a database

2018-12-10 Thread Floimair Florian 
Alembic currently doesn't cover queue_logs.
As of now it only covers configuration, voicemail and cdr.


 
 
With best regards

Florian Floimair
Innovation - Software-Development

COMMEND INTERNATIONAL GMBH
A-5020 Salzburg, Saalachstraße 51
http://www.commend.com 

Security and Communication by Commend

FN 178618z | LG Salzburg

Am 07.12.18, 15:56 schrieb "asterisk-users im Auftrag von hw" 
:

On 12/07/2018 03:36 PM, Administrator TOOTAI wrote:
> Le 07/12/2018 à 14:32, hw a écrit :
> 
> [...]
>>
>> Queues seem to be the only way to have several phones ring at once, or 
>> are there other ways?
> 
> Dial(SIP/Phone1/Phone2&.../Phonex,,)
> 

Good to know, thanks!


What are the entries needed in the queue_members table when using odbc? 
Alembic made the primary key so that each queue can only have one entry 
(What is an interface here?), and there's probably a reason for that. 
How do you enter several members for a queue?  Asterisk seems to either 
rather crash than to create a queue, or to do nothing.

-- 
_
-- 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

Re: [asterisk-users] how to use a database

2018-12-08 Thread hw 

On 12/07/2018 04:14 PM, Administrator TOOTAI wrote:

Le 07/12/2018 à 15:56, hw a écrit :

On 12/07/2018 03:36 PM, Administrator TOOTAI wrote:

Le 07/12/2018 à 14:32, hw a écrit :

[...]


Queues seem to be the only way to have several phones ring at once, 
or are there other ways?


Dial(SIP/Phone1/Phone2&.../Phonex,,)



Good to know, thanks!


What are the entries needed in the queue_members table when using 
odbc? Alembic made the primary key so that each queue can only have 
one entry (What is an interface here?), and there's probably a reason 
for that. How do you enter several members for a queue?  Asterisk 
seems to either rather crash than to create a queue, or to do nothing.


Why you don't just add members dynamically in a queu using 
AddQueueMember/RemoveQueueMember or even with pause/unpause members ?


So far, there's only one queue, and it's members are always the same.

With dynamic queue members, how do you solve the problem of 
automatically recreating queues when restarting asterisk?


BTW the above dial string has nothing to do with queue, it just a cmd 
that rings all phones at once.


Yes --- I was looking for a way to do that, and the only way I found was 
using a queue.  I have two cases in one of which a queue is just right 
while ringing several phones at once and not having a queue would be 
better in the other.


--
_
-- 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

Re: [asterisk-users] how to use a database

2018-12-07 Thread Administrator TOOTAI 

Le 07/12/2018 à 15:56, hw a écrit :

On 12/07/2018 03:36 PM, Administrator TOOTAI wrote:

Le 07/12/2018 à 14:32, hw a écrit :

[...]


Queues seem to be the only way to have several phones ring at once, 
or are there other ways?


Dial(SIP/Phone1/Phone2&.../Phonex,,)



Good to know, thanks!


What are the entries needed in the queue_members table when using odbc? 
Alembic made the primary key so that each queue can only have one entry 
(What is an interface here?), and there's probably a reason for that. 
How do you enter several members for a queue?  Asterisk seems to either 
rather crash than to create a queue, or to do nothing.


Why you don't just add members dynamically in a queu using 
AddQueueMember/RemoveQueueMember or even with pause/unpause members ?


BTW the above dial string has nothing to do with queue, it just a cmd 
that rings all phones at once.


--
Daniel

--
_
-- 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

Re: [asterisk-users] how to use a database

2018-12-07 Thread hw 

On 12/07/2018 03:36 PM, Administrator TOOTAI wrote:

Le 07/12/2018 à 14:32, hw a écrit :

[...]


Queues seem to be the only way to have several phones ring at once, or 
are there other ways?


Dial(SIP/Phone1/Phone2&.../Phonex,,)



Good to know, thanks!


What are the entries needed in the queue_members table when using odbc? 
Alembic made the primary key so that each queue can only have one entry 
(What is an interface here?), and there's probably a reason for that. 
How do you enter several members for a queue?  Asterisk seems to either 
rather crash than to create a queue, or to do nothing.


--
_
-- 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

Re: [asterisk-users] how to use a database

2018-12-07 Thread hw 

On 12/07/2018 02:45 PM, Marcelo Terres wrote:

https://wiki.asterisk.org/wiki/display/AST/Managing+Realtime+Databases+with+Alembic


alembic did not create any tables for logging.

--
_
-- 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

Re: [asterisk-users] how to use a database

2018-12-07 Thread Administrator TOOTAI 

Le 07/12/2018 à 14:32, hw a écrit :

[...]


Queues seem to be the only way to have several phones ring at once, or 
are there other ways?


Dial(SIP/Phone1/Phone2&.../Phonex,,)

--
Daniel

--
_
-- 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

Re: [asterisk-users] how to use a database

2018-12-07 Thread Marcelo Terres 
https://wiki.asterisk.org/wiki/display/AST/Managing+Realtime+Databases+with+Alembic

Marcelo H. Terres 
IM: mhter...@jabber.mundoopensource.com.br
https://www.mundoopensource.com.br
https://twitter.com/mhterres
https://linkedin.com/in/marceloterres
On Fri, 7 Dec 2018 at 13:34, hw  wrote:
>
> On 12/06/2018 10:26 PM, Marcelo Terres wrote:
> > The Asterisk source has a tool to create the db
>
> Which one is that?
>
>
> --
> _
> -- 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

Re: [asterisk-users] how to use a database

2018-12-07 Thread hw 

On 12/06/2018 10:26 PM, Marcelo Terres wrote:

The Asterisk source has a tool to create the db


Which one is that?


--
_
-- 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

Re: [asterisk-users] how to use a database

2018-12-07 Thread hw 

On 12/06/2018 08:43 PM, Antony Stone wrote:

On Thursday 06 December 2018 at 17:49:25, hw wrote:

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.


Did I say anything about using it for queues?

Queues seem to be the only way to have several phones ring at once, or 
are there other ways?



Without seeing the "note in some configuration file" that you refer to, though,
I don't know what to say about this.


It says


"However, 

; note that using dynamic realtime extensions is not recommended anymore 
as a
; best practice; instead, you should consider writing a static dialplan 
with

; proper data abstraction via a tool like func_odbc."


in extconfig.conf.


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.


Which feature?


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.


good


We did start off just talking about getting queue_log into a database table,
though.


That's why I changed the subject.  Now I started with CDR logging to the 
database because queue logging seems to be even more difficult, and it's 
not working because asterisk says "cdr_odbc.c:174 odbc_log: Unable to 
retrieve database handle.  CDR failed." while I can connect to the 
datasource given in cdr_odbc.conf with isql just fine.  I made another 
post about that, though.


--
_
-- 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

Re: [asterisk-users] how to use a database

2018-12-06 Thread Marcelo Terres 
The Asterisk source has a tool to create the db

Marcelo

On Thu, 6 Dec 2018, 19:44 Antony Stone  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

Re: [asterisk-users] how to use a database

2018-12-06 Thread Antony Stone 
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

Re: [asterisk-users] how to use a database

2018-12-06 Thread hw 

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)?


Do I get to see the queries that are being used to write this data, or 
do I need to form them myself and enter them into some configuration file?



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.



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?


How do I make asterisk reload func_odbc.conf?  Or is that not needed?


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 :)

--
_
-- 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

Re: [asterisk-users] how to use a database (was: figuring out what happened to a call)

2018-12-05 Thread Antony Stone 
On Wednesday 05 December 2018 at 15:31:38, hw wrote:

> On 12/05/2018 01:19 PM, Antony Stone wrote:
> > On Wednesday 05 December 2018 at 13:04:57, hw wrote:
> >> On 12/04/2018 07:07 PM, Antony Stone wrote:
> >>> On Tuesday 04 December 2018 at 16:11:39, hw wrote:
>  On 12/01/2018 05:30 PM, Marcelo Terres wrote:
> > Queue_log
>  
>  Thanks!
>  
>  That's not really it; however, how do I make it so that asterisk
>  writes this information right away into a mariadb database instead of
>  into a file so that I could actually use it?
> >>> 
> >>> Send your queue_log entries to odbc?
> >> 
> >> odbc?  Seriously?
> > 
> > Yes, it's the preferred method of talking to databases from Asterisk.
> 
> After reading some documentation, anything else but odbc appears to be
> more or less deprecated :/

Indeed.

> > If you want to use the MySQL-specific driver / connector, you can still
> > use that for some things, but Voicemail in a database can only be done
> > via ODBC, for example.
> > 
> >>> It's a setting in extconfig.conf.
> >> 
> >> Does mysql not work?  It's mentioned there, too.
> > 
> > By all means try it - if it's mentioned, it'll probably work, but ODBC is
> > the more generic and better-supported way of using databases with
> > Asterisk.
> 
> Since it really seems to be the most reasonable choice, I've set up an
> odbc connection and used alembic to create tables in a database for
> asterisk.
> 
> Now how is this managable?  Is there a tool that reads the files I have
> and enters the configuration into the database?

Not that I know of.

> And when changes are to be made, editing configuration files is tremendously
> easier than going through the tables in the database and try to make the
> changes there.

Okay, so carry on using config files if you want to.

I was only answering your question about getting Asterisk Queue logs *out* 
into a database table; I wasn't recommending anything about reading config file 
*from* a database (although this is indeed possible if you want to).

> For now, can I make it so that only the queue_log is written into the
> database?

Yes.

> 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 dynamic are changes made in the database?

If by "dynamic" you mean "quickly used" then the answer is "immediately".

> 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.

> That seems to be what this is intended for; in any case, it's what I'm going
> to need, which is why I went to all these lengths to connect to a database.

Okay, sounds good, then.

> Is it possible to use configuration from both the database and the files
> at the same time?

Yes.

> That would save me converting all the entries in the files for now.

Yes.


Antony.

-- 
What do you get when you cross a joke with a rhetorical question?

   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