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
_______________________________________________
--Bandwidth and Colocation provided by Easynews.com --
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
