Summary:	ASTERISK-02439: [patch] vmail.cgi does not use MySQL database when enabled.
Reporter:	mplsejo (mplsejo)	Labels:
Date Opened:	2004-09-20 21:28:57	Date Closed:	2004-11-09 00:36:39.000-0600
Priority:	Minor	Regression?	No
Status:	Closed/Complete	Components:	Core/General
Versions:		Frequency of Occurrence
Related Issues:
Environment:		Attachments:	( 0) vmail.mysql-ejo.patch
Description:	The vmail.cgi script does not understand the mysql database. Patch attached allows user to configure alternate routines for fetching the configuration for authentication and droplist of mail boxes for forwarding. ****** ADDITIONAL INFORMATION ****** vmail.cgi was modified to include database authentication. MySQL is provided as an example however it is possible to write routines for any RDBMS.  In our implementation we require DBI and DBD::mysql as additional perl packages. The patch overrides 3 existing functions (check_login, validmailbox and mailboxlist) with mysql enabled replacements.  This is done without implmenting very many custom lines inside the existing code by reassigning the function assignments to our custom functions at runtime as opposed to modifying the original functions. example:       if(\&check_login != \&mysql_check_login) {               undef &check_login;               *check_login = \&mysql_check_login;       } =-=-=-=-=-=-=-= My patch skills are weak, so if someone can clean up the patch and repost that would help everyone else out I'm sure. =-=-=-=-=-=-=-= I catch a flight to Astricon in a couple of hours, so I'll get that release to Digium at the show I guess.
Comments:	By: Mark Spencer (markster) 2004-09-20 21:49:31 Do you have a disclaimer on file? By: mplsejo (mplsejo) 2004-09-20 22:02:12 Nope, not yet. See note above. I'll be at the show and will sign one there. I've left my offices and will not have access to a fax line until after Astricon. By: Mark Spencer (markster) 2004-10-20 17:18:28 Okay so did we get it taken care of? By: Brian West (bkw918) 2004-10-27 19:22:32 Can you combine this with bug 2686 so we can all work together? By: Russell Bryant (russell) 2004-11-09 00:35:51.000-0600 Either 2686 fixed this problem and/or the author has lost interest. By: Russell Bryant (russell) 2004-11-09 00:35:51.000-0600 Either 2686 fixed this problem and/or the author has lost interest.