Summary:	ASTERISK-25500: voicemail update problem in PG when change password
Reporter:	sickboy (sickboy)	Labels:
Date Opened:	2015-10-28 08:08:55	Date Closed:	2015-11-09 09:52:42.000-0600
Priority:	Major	Regression?
Status:	Closed/Complete	Components:	Resources/res_config_pgsql
Versions:		Frequency of Occurrence
Related Issues:
Environment:		Attachments:
Description:	Hi there, I've a problem in change_password functionnality, the pg request give me this in PG log : 2015-10-28 13:39:03 CET STATEMENT:  UPDATE voicemail SET password='4567' WHERE ='' AND context='frmailbox'
Comments:	By: Asterisk Team (asteriskteam) 2015-10-28 08:08:58.836-0500 Thanks for creating a report! The issue has entered the triage process. That means the issue will wait in this status until a Bug Marshal has an opportunity to review the issue. Once the issue has been reviewed you will receive comments regarding the next steps towards resolution. A good first step is for you to review the [Asterisk Issue Guidelines|https://wiki.asterisk.org/wiki/display/AST/Asterisk+Issue+Guidelines] if you haven't already. The guidelines detail what is expected from an Asterisk issue report. Then, if you are submitting a patch, please review the [Patch Contribution Process|https://wiki.asterisk.org/wiki/display/AST/Patch+Contribution+Process]. By: Rusty Newton (rnewton) 2015-10-30 17:30:03.197-0500 Thank you for taking the time to report this bug and helping to make Asterisk better. Unfortunately, we cannot work on this bug because your description did not include enough information. Please read over the Asterisk Issue Guidelines [1] which discusses the information necessary for your issue to be resolved and the format that information needs to be in. We would be grateful if you would then provide a more complete description of the problem. At a minimum, we need: 1. The specific steps or actions you took that caused you to encounter the problem. 2. The behavior you expected and the location of documentation that led you to that expectation. 3. The behavior you actually encountered. To demonstrate the issue in detail, please include Asterisk log files generated per the instructions on the wiki [2]. If applicable, please ensure that protocol-level trace debugging is enabled, e.g., 'sip set debug on' if the issue involves chan_sip, and configuration information such as dialplan and channel configuration. Thanks! [1] https://wiki.asterisk.org/wiki/display/AST/Asterisk+Issue+Guidelines [2] https://wiki.asterisk.org/wiki/display/AST/Collecting+Debug+Information By: sickboy (sickboy) 2015-11-05 03:26:29.135-0600 asterisk-13.6.0 with voicemail / ODBC (postgresql connector) modules When i use the option change password in the vocal menu (0 -> 5 -> new password + # -> new password + # -> I have the confirmation that the password is changed but it's not. This is the asterisk logs : -- <SIP/c5z-00000001> Playing 'vm-options.ulaw' (language 'fr')    -- <SIP/c5z-00000001> Playing 'vm-newpassword.ulaw' (language 'fr')    -- <SIP/c5z-00000001> Playing 'vm-reenterpassword.ulaw' (language 'fr')  == Parsing '/etc/asterisk/voicemail.conf': Found  == Parsing '/etc/asterisk/users.conf': Found    -- <SIP/c5z-00000001> Playing 'vm-passchanged.ulaw' (language 'fr') This is the PG request received : 2015-10-28 13:39:03 CET STATEMENT: UPDATE voicemail SET password='4567' WHERE ='' AND context='frmailbox' We see that the field is not OK, it should be : context='fr' mailbox='0911224455' Thanks. By: Rusty Newton (rnewton) 2015-11-05 19:45:49.215-0600 Are you you using res_odbc and res_config_odbc or are you using res_config_pgsql ? Can you reproduce the issue with res_config_odbc? Can you please attach a full debug log as requested and by following the instructions for collecting debug? Before attaching it you should verify that it includes WARNING,ERROR,NOTICE,VERBOSE,DEBUG log channels and that verbose and debug are both turned up to 5. Thanks! By: sickboy (sickboy) 2015-11-06 03:18:32.603-0600 Hello, I use res_odbc but i don't have res_config_odbc (i see it was deprecated ??) This is the logs (set verbose and debug to 5 level)    -- <SIP/c5z-00000002> Playing 'vm-opts.ulaw' (language 'fr')    -- <SIP/c5z-00000002> Playing 'vm-tmpexists.ulaw' (language 'fr')    -- <SIP/c5z-00000002> Playing 'vm-newpassword.ulaw' (language 'fr')    -- <SIP/c5z-00000002> Playing 'vm-reenterpassword.ulaw' (language 'fr')  == Parsing '/etc/asterisk/voicemail.conf': Found  == Parsing '/etc/asterisk/users.conf': Found    -- <SIP/c5z-00000002> Playing 'vm-passchanged.ulaw' (language 'fr')    -- <SIP/c5z-00000002> Playing 'vm-tmpexists.ulaw' (language 'fr') [Nov  6 10:11:53] NOTICE[27484][C-00000002]: app_voicemail.c:8900 close_mailbox: -1 messages received after mailbox opened. Thank you. By: Rusty Newton (rnewton) 2015-11-06 07:43:02.509-0600 res_config_odbc is not deprecated. res_config_odbc is core supported and res_config_pgsql is extended support. Please see if you can reproduce the issue with res_config_odbc. For the log output please check "logger show channels" and be sure you have the correct logger channels being sent to the correct location (console, or your file). I would expect to see some DEBUG messages.. Thanks! By: sickboy (sickboy) 2015-11-09 03:32:59.370-0600 I can't reproduce with this res_c config config: voicemail => odbc,asterisk,voicemail All is OK in my side. Thank you. By: Rusty Newton (rnewton) 2015-11-09 09:52:42.992-0600 Alrighty. I'm going to close this as Workaround Available since res_config_odbc works. The problem is likely in res_config_pgsql and since it is extended support if someone wants to work the issue or we have many people that face it we'll open it again in the future.