[asterisk-users] RE: Realtime Voicemail Password Change Not Working

[kjcsb]

>
> I was able to update the password through the dialplan with this:
> exten => 5555,1,MYSQL(Connect connid 127.0.0.1 pbx pbx pbxdb)
> exten => 5555,2,MYSQL(Query resultid ${connid} UPDATE\ voicemail\ SET\
> password=1111\ where\ mailbox=52007)
> exten => 5555,3,MYSQL(Clear ${resultid})
> exten => 5555,4,MYSQL(Disconnect ${connid})
> exten => 5555,5,Hangup
>
> Finaly I got an update statement in the mysql log:
> 12 Query       UPDATE voicemail SET password=1111 where mailbox=52007
>
> So these results suggest that mysql, voicemail table, and the res_mysql
> adddon are working fine.  It suggests that app_voicemail is not passing 
> the
> update statement to the res_mysql driver.
>
> This was a clean install, nothing out of the ordinary.
I would second the other posters suggestion: use Realtime update (show 
application realtime update) since it uses the actual realtime setup. The 
MySQL command shown above uses a new connection that you specify so is not 
such a good test.

Cameron