asterisk users - Sep 2006 - voicemail access thru apache on another server

Hello ppl,
Am trying to build a system, wherein users can access their profiles, 
and hence voicemails thru a browser.
I am using Apache and am running it on another box and asterisk on 
another. Am keeping them seperate to not have http traffic on the same 
box as asterisk.

Now, my qs:
Is there a way to tell Asterisk to store the msgXXXX.txt information in 
an sql database, so that it's easier to access the voice mail info??

Am planning to run another apache on the asterisk box, solely for 
providing file-playing access(thru hrefs on my first web-server).

Also, any way to run a script or something, to move a message from INBOX 
to Old, when a user listens to the message thru the web browser??

Any ideas good ppl??

thanks in advance.

cheerz
Ben.

have a look at Wiki for asterisk +  odbc storage. The database for
storing entire voicemail messages can be stored on a local or a remote
database. Then you can do whatever you want with it. You will have to
recompile asterisk by turning on ODBC storage. It's all there on the
Wiki

Hi Benjamin,
> Am trying to build a system, wherein users can access their profiles, 
> and hence voicemails thru a browser.
> I am using Apache and am running it on another box and asterisk on 
> another. Am keeping them seperate to not have http traffic on the same 
> box as asterisk.
> 
> Now, my qs:
> Is there a way to tell Asterisk to store the msgXXXX.txt information in 
> an sql database, so that it's easier to access the voice mail info??
I would wait until the IMAP support in asterisk (currently only in the
svn version) is stable instead using sql-db based storage. At least if
were talking about an medium installation or bigger.
> Also, any way to run a script or something, to move a message from INBOX 
> to Old, when a user listens to the message thru the web browser??
 > Now, how on earth do i read the recordings and play them out  thru a
browser!!

I did write a proof of concept script in php for accessing and manipulating
the voicemail folder. It has no locking atm therefore there are some race 
conditions and its not usuable in a large scale production environment.
Youre welcome to add session/locking suport though :}
The script enables you to view, read, move, delete and forward voicemails
using URLs. ascii based and asterisk realtime authentication is supported.
You can use it at least to extract the code how to send an audiofile (if
youre using php that is). Should be no problem to convert the scripts
to perl or any other script language.

Script:
http://sip-syndication.com/index.php?option=com_remository&Itemid=26&func=select&id=2
Documentation:
http://sip-syndication.com/index.php?option=com_content&task=category&sectionid=5&id=21&Itemid=47

cheers,

   Arnd

On Thu, Sep 14, 2006 at 06:14:52PM +0530, Benjamin Jacob
wrote:
> Hello ppl,
> Am trying to build a system, wherein users can access their profiles, 
> and hence voicemails thru a browser.
> I am using Apache and am running it on another box and asterisk on 
> another. Am keeping them seperate to not have http traffic on the same 
> box as asterisk.
Just to give you another direction: mod_proxy of apache and a locla
httpd on the box that runs asterisk...
> 
> Now, my qs:
> Is there a way to tell Asterisk to store the msgXXXX.txt information in 
> an sql database, so that it's easier to access the voice mail info??
Or use the mysql, postgresql or ODBC storage.

Or use the imap storage and some web-based imap client.

-- 
Tzafrir Cohen         sip:tzafrir@local.xorcom.com
icq#16849755          iax:tzafrir@local.xorcom.com
+972-50-7952406          jabber:tzafrir@jabber.org
tzafrir.cohen@xorcom.com     http://www.xorcom.com