Voip Pinoy | Your Resources for Asterisk, VOIP, PHP and MySQL integration

Apparently there is already a company using that name and it is already trademarked, so Digium is renaming Zaptel to DAHDI.

They really like acronyms

Here’s the complete story http://blogs.digium.com/2008/05/19/zaptel-project-being-renamed-to-dahdi/

It’s pretty hard to make Dundi and Asterisk realtime work, but I was able to make it work, thanks to the other tutorials found over the internet.

I will just try to tell you how I did it.

Let’s just start with 2 asterisk servers for now, and then you can just add more servers when you have mastered how to setup dundi.

First you need to make sure dundi is working on both asterisk servers, so setup DUNDi as describe from

Once, you have DUNDi setup properly, edit your sip.conf and insert this line on the general context

regcontext=sipregistration

Once your sip phones registers to this asterisk servers it will be included into a dynamic context named ’sipregistration’, you can verify this by typing ’show dialplan’ on the asterisk CLI.

On your dundi mappings context you need to have something like this for both servers

[mappings]
priv => sipregistration,0,SIP,(IPADDRESSOFTHEOTHERSERVER)/${NUMBER},nopartial

This will tell asterisk how to dial the other server

On your extensions.conf file you would also need to create a Macro to dial and find the extension

[dundi-priv-lookup]
include => lookupdundi

[macro-dundi-priv]
exten => s,1,Goto(${ARG1},1)
include => dundi-priv-lookup

And also, you need to catch if the phone is unavailable to trigger the Macro so you also need to put something like this on your extensions.conf

exten => XXXXXX-CHANUNAVAIL ,1,Macro(dundi-priv|${EXTEN})

That’s about it, so when CHANUNAVAIL is triggered from the other server, it will then do a dundi query on the other server and if the Extension is registered from there, meaning if the extension is seen on sipregistration, then it will pass the call to the other server.

Now you can register phones on either server and they will not miss any call with this configuration.

Ok, I received an email from a local asterisk user group asking about this and I will try and answer it here and give you samples on how to retrieve voicemail from odbc storage with mysql, asterisk and php. This is a good practice if you have a number of clustered asterisk servers and users can login on any of the servers, or maybe you are under SER or a proxy server. And also, this is convenient since voicemail can be accessed thru the phone or the web.

But sorry, I will not go into the details of the PHP code, it should be really easy already.

Ok first of all is that you have to setup voicemail odbc storate first, I will not be able to discuss it here yet.

Moving on…

From your voicemessages table, the most important column there is the longblob named “recording” it might be different on your table but it should be the longblob column.

Now create a php script that queries the “voicemessages” table

Once you have this you can change the longblob to a listenable WAV file by having this code

header(”Content-Disposition: attachment; filename=vmmessage1.wav”);
header(”Content-Description: PHP Generated Data”);
echo $row[’recording’];

Where $row[’recording’] is the longblob column.

That’s about it, you’d be able to listen or download the file and listen to it on your PC