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

[RR]

On 1/18/07, JR Richardson <jmr.richardson at gmail.com> wrote:
>
> I use the same database for the sip, iax, exten and vm, different
> tables.  When a sip device registers, asterisk writes to the database
> with updates to the sip table ipaddress, port and regseconds, so I
> don't think there is a write permissions issue from asterisk res_mysql
> to the mysql database.  I thought of that also and changed the user to
> full access, but that didn't help.  Mysql logs all database
> transactions in the /var/log/mysql.log file.  I see all the query
> selects from the voicemail table and i see all the query updates to
> the sip table, but never see any query updates for the vmpasswd to the
> voicemail table.  I would assume there would at least be errors if
> there was a permissions problem.  I don't see where asterisk is trying
> to update the vmpassword through the realtime driver.
>
> How is your voicemail.conf file setup?
>
> Thanks.
>
> JR

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.

HTH
\R