> Interesting, well if you're seeing the other selects in the mysql.log > then this update not showing up is bizarre. It would also mean that > permissions are irrelevant if doesn't even attempt to change the > password, as you'd rightly pointed out as well. I just tested it again > and this is what I see in the odbc sql.log > > SQL = [UPDATE vmusers SET password=? WHERE uniqueid=?][length = 46 > (SQL_NTS)] > > So it definately spits out something but my setup is considerably > different to yours. I am using ODBC -> FreeTDS -> MS SQL Server for > starters. There's nothing out of the oridinary in my voicemail.conf. > What I do remember is some conversation sometime about the file > locking fix that was put in or was being talked about regards to > people using static files and multiple people trying to change their > passwords. Just checking if you've compiled (*) clean without any mods > to the code etc. I mean I have made mods to app_voicemail.c but > nothing that affects passwords. Just for giggles, have you tried doing > "realtime update voicemail mailbox 1234 password 2345" ? I know you > said that your db updates for regsecs, ip address etc is working but > try specifically writing to your voicemail table and see if you are > able to manually update the password. At least that way you can just > focus on seeing why the password code is not being triggered in the > (*) code when using MySQL. Sorry I cna't think of anything else to > suggest at the moment.
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. Thanks. JR _______________________________________________ --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