[Asterisk-Dev] MySQL Voicemail and Directory Patch

[Josh Roberson]

Please post this on bugs.digium.com following the guidelines.  this is 
the location we post patches for testing/etc before they are considered 
for cvs.

-twisted

Matthew Boehm wrote:

>Hey gang,
> I've been using * with voicemail-mysql for a few weeks. Works like a charm.
>Even wrote a nice php web interface to let users check, play and download
>their messages.
>
> Recently found out that if you use mysql-voicemail then you CAN NOT use
>app_directory as app_directory reads its information from voicemail.conf. If
>you are using mysql-voicemail, then there aren't any entries in
>voicemail.conf cause they are all in the database. (insert cheezy *duh*)
>
> So, I spent a few hours today and wrote a small function that grabs the
>information app_directory needs from the voicemail database.
>
> Before I submit this to the CVS, I'd like some people to test it out.
>
>If you already have voicemail-mysql running then you should be able to apply
>both patches and simply type 'make' and have app_directory recompile as my
>patch checks for the same compiler directives that app_voicemail checks for.
>
>MAKE SURE to check the newly patched app_directory.c and set VOICEMAIL_TABLE
>to whatever table you use. I don't enjoy the fact that other authors choose
>to hard-code the tables into their code without making it easy for users to
>change them. I have changed my voicemail table. You may have not. Check to
>be sure.
>
>app_directory_mysql.patch will patch the app_directory.c file inside
>asterisk/apps/ and add the function.
>
>app_directory_mysql_makefile.patch will patch asterisk/apps/Makefile and
>will add a new target app_directory because it needs to be linked
>with -lmysqlclient.
>
>Please send any comments and bugs to me off-list. Read the debug log for
>messages pertaining to 'Directory'.
>
>If you need help setting up voicemail to work with mysql, read here:
>http://voip-info.org/tiki-index.php?page=Asterisk%20voicemail%20database
>
>Thanks,
>Matthew
>  
>