asterisk users - Apr 2008 - need examples of asterisk and mysql integration

I'm presently working on a project to build a scheduling system
accessible by both web and phone.  on the web side one can query what
items are available when by using the time or the item as a key then
reserve for an available time slot.  reservations may also be modified
by the user that made them or an admin.  Where may I find examples of
doing similar things with asterisk?  all I've been able to find thus
far is examples of how to store call detail records and voicemail
using a database.

Thanks in advance,

Eric

P.S.

Has anyone already built an asterisk/web based scheduling system like this?

vicidial has something similar in a way that you can schedule a callback ...
maybe you can download it & get a closer look at the code, it connects to
asterisk thru asterisk-perl module.

On Tue, Apr 22, 2008 at 8:13 PM, Eric Fort <eric.fort at gmail.com> wrote:
> I'm presently working on a project to build a scheduling system
> accessible by both web and phone.  on the web side one can query what
> items are available when by using the time or the item as a key then
> reserve for an available time slot.  reservations may also be modified
> by the user that made them or an admin.  Where may I find examples of
> doing similar things with asterisk?  all I've been able to find thus
> far is examples of how to store call detail records and voicemail
> using a database.
>
> Thanks in advance,
>
> Eric
>
> P.S.
>
> Has anyone already built an asterisk/web based scheduling system like
> this?
>
> _______________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
> 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/20080422/e3a68f68/attachment.htm

Hi,

I suggest you look at writing a PERL  agi program to handle all of 
the MYSQL / DB
access and just pass variables between your CONTEXT/dialplan.   I have done
a lot of these things.  You can get PERL examples for DBI  and use one of
provided  agi scripts as a prototype.

..mike..

At 04:13 PM 4/22/2008, you wrote:
>I'm presently working on a project to build a scheduling system
>accessible by both web and phone.  on the web side one can query what
>items are available when by using the time or the item as a key then
>reserve for an available time slot.  reservations may also be modified
>by the user that made them or an admin.  Where may I find examples of
>doing similar things with asterisk?  all I've been able to find thus
>far is examples of how to store call detail records and voicemail
>using a database.
>
>Thanks in advance,
>
>Eric
>
>P.S.
>
>Has anyone already built an asterisk/web based scheduling system like this?
>
>_______________________________________________
>-- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
>asterisk-users mailing list
>To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users

On 13:13, Tue 22 Apr 08, Eric Fort wrote:
> I'm presently working on a project to build a scheduling system
> accessible by both web and phone.  on the web side one can query what
> items are available when by using the time or the item as a key then
> reserve for an available time slot.  reservations may also be modified
> by the user that made them or an admin.  Where may I find examples of
> doing similar things with asterisk?  all I've been able to find thus
> far is examples of how to store call detail records and voicemail
> using a database.
Hi,

With AGI you can write logic in whatever language fits you best.
if you like perl, use the asterisk-perl stuff.
if you like php, you can use the native mysql stuff
if you like bash, you can use the mysql commandline client
etc etc
You can even use the MYSQL dialplan functions. Not sure where they are,
I think in -addons.

-- 

Michiel van Baak
michiel at vanbaak.eu
http://michiel.vanbaak.eu
GnuPG key: http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x71C946BD

"Why is it drug addicts and computer aficionados are both called
users?"

On Tue, 2008-04-22 at 13:13 -0700, Eric Fort wrote:
> I'm presently working on a project to build a scheduling system
> accessible by both web and phone.  on the web side one can query what
> items are available when by using the time or the item as a key then
> reserve for an available time slot.  reservations may also be modified
> by the user that made them or an admin.  Where may I find examples of
> doing similar things with asterisk?  

don't forget ruby's adhearsion
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20080422/b3ba68f9/attachment.htm
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 5537 bytes
Desc: not available
Url :
http://lists.digium.com/pipermail/asterisk-users/attachments/20080422/b3ba68f9/attachment.bin