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

[RR]

On 1/18/07, JR Richardson <jmr.richardson at gmail.com> wrote:
> > I'm using asterisk 1.2.9.1 and mysql 3.23, asterisk add-ons 1.2.3.
> > All seems to work normally with realtime voicemail, reads vmbox
> > parameters from the db fine.  When I try to change the password,
> > asterisk operates normally, "enter new password" ok, "re-enter new
> > password" ok, "password has been changed"
> >
> > There are no entries in the mysql.log setting the new password in the
> > database.  How can I isolate between asterisk, realtime driver, and
> > mysql?
>
> I updated to asterisk 1.2.14 and add-ons 1.2.5 with no luck.  I still don't
> see any update statement in the mysql.log when I change a password.  I built
> a vmbox in the voicemail.conf file and can change that password just fine.
> Any suggestions?
>
> Thanks.
>
> JR
>

Not sure about how you log in MySQL but using ODBC, in your
odbcinst.ini or a similar file for Mysql, which keeps the settings for
your db driver etc, you should be able to turn on logging. I can in
odbcinst and it creates logs.

The problem you have seems more like a permission problem however, the
user you're using to log into the DB doesn't seem to have the
permission to write to the table which keeps the user information OR
the voicemail database itself. This problem becomes a bit trickier
when your vm user table is actually a view of tables that hold
subscriber/user information and is compounded by the fact if
voicemails are being stored in a different db than where the sip/iax
user information is being stored to derive sipusers and sippeers
family values as then the user that asterisk is using to connect to
the voicemail db will also need write permission in the db that stores
user information.

I dunno if any of that made sense but the password change works for me
fine in 1.2.x as well as 1.4b3, haven't tested 1.4 Release yet. But in
short, check pemissions for the user accessing the db(s)

HTH
\R