[asterisk-bugs] [Asterisk 0015492]: [patch] Voicemail.conf gets overwritten when using Realtime for voicemail

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=15492 
====================================================================== 
Reported By:                cbbs70a
Assigned To:                lmadsen
====================================================================== 
Project:                    Asterisk
Issue ID:                   15492
Category:                   Addons/res_config_mysql
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     ready for testing
Asterisk Version:           1.4.23 
Regression:                 No 
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2009-07-13 11:55 CDT
Last Modified:              2009-07-15 10:53 CDT
====================================================================== 
Summary:                    [patch] Voicemail.conf gets overwritten when using
Realtime for voicemail
Description: 
Using Asterisk 1.4.23.1 and realtime for voicemail, if the user tries to
change their password and enters the same password, the voicemail.conf file
gets overwritten. 

The overwritten file looks like this:
;!
;! Automatically generated configuration file
;! Filename: voicemail.conf (/etc/asterisk/voicemail.conf)
;! Generator: AppVoicemail
;! Creation Date: Mon Jul 13 12:47:30 2009
;!
====================================================================== 

---------------------------------------------------------------------- 
 (0107792) cbbs70a (reporter) - 2009-07-15 10:53
 https://issues.asterisk.org/view.php?id=15492#c107792 
---------------------------------------------------------------------- 
I have additional information that might help. Seeing the following in the
debug:

[Jul 13 12:10:03] DEBUG[27453]: res_config_mysql.c:404 config_mysql: MySQL
RealTime: Static SQL: SELECT category, var_name, var_val, cat_metric FROM
voicemail WHERE filename='voicemail.conf' and commented=0 ORDER BY
filename, cat_metric desc, var_metric asc, category, var_name, var_val, id


I added the above columns into the voicemail dbtable. Thats when the
voicemail.conf file was overwritten. When I deleted those columns, the file
was not overwritten. This was very reproducible. What are those columns
for??? 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2009-07-15 10:53 cbbs70a        Note Added: 0107792                          
======================================================================