[asterisk-users] Asterisk 'Hosting'

[Douglas Garstang]

> -----Original Message-----
> From: Rushowr [mailto:rushowr at phreaker.net]
> Sent: Thursday, August 17, 2006 2:50 PM
> To: 'Asterisk Users Mailing List - Non-Commercial Discussion'
> Subject: RE: [asterisk-users] Asterisk 'Hosting'
> 
> 
> -----Original Message-----
> From: asterisk-users-bounces at lists.digium.com
> [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Douglas
> Garstang
> Sent: Thursday, August 17, 2006 4:39 PM
> To: Asterisk Users Mailing List - Non-Commercial Discussion
> Subject: RE: [asterisk-users] Asterisk 'Hosting'
> 
> > -----Original Message-----
> > From: Douglas Garstang
> > Sent: Thursday, August 17, 2006 2:17 PM
> > To: 'Asterisk Users Mailing List - Non-Commercial Discussion'
> > Subject: RE: [asterisk-users] Asterisk 'Hosting'
> 
> **snip**
> 
> > > I spent 8+ hours a day, 5+ days per week for over 6 
> months thinking 
> > > how these functions fit within the realm of Asterisk. At every 
> > > single turn, after going down every single path, there where 
> > > limitations that forced us to backtrack and evaluate a different 
> > > approach. A script that could handle call routing, in conjection 
> > > with MySQL and stored procedures was the only way to 
> implement our 
> > > requirements. The MySQL command had limitations, realtime was way 
> > > too resource intensive, unreliable and undocumented and so on. 
> > > Yep... i definitely haven't thought about this at all.
> > 
> > Oops. I almost forgot intra-organisational 4 digit 
> extension dialling. 
> > Not just company, but organisational, where a company may have 
> > multiple organisational units. It might be possible to hack 
> together a 
> > flat intra-business 4 digit extension dial lookup in the native 
> > dialplan, but trying to make it a multi-level organisation lookup 
> > would be pure hell... unless you farm the task out to a 
> more advanced 
> > scripting langauge like python, perl whatever.
> 
> >I see the MySQL dial plan command still doesn't support 
> stored procedures
> either, 
> >unless you hack around with the source.
> 
> I've just recently come up against this limitation. Care to 
> share info/code
> concerning making stored procs work with the addon?

Hi. I only just stumled across it myself. I was trying to prove a point to Jeremy. 
On the  voip wiki:

http://www.voip-info.org/wiki/index.php?page=Asterisk+cmd+MYSQL

under a comment titled 'Calling MySQL 5 stored procedures from app_mysql', it looks like someone has managed to modify the source to get it to work.
I haven't tried it yet...

Doug.