asterisk users - Jan 2007 - FW: Realtime Voicemail Password Change Not Working

> 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

On 1/17/07, JR Richardson <jmr.richardson@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?
JR,

I'm just pulling things out of the air here, but if realtime voicemail
works like realtime users/peers, loading everything into memory from
MySQL, then there would need to be some type or prune command to force
the re-read of the voicemail table, this is asuming you change the
password via MySQL and not on the handset. Maybe something like DBput
would work to update astdb as well. Again just throwing out ideas...

It sounds like you are using the handset to update the password. Is
this correct?

Regards,
David

On 1/18/07, JR Richardson <jmr.richardson@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

On Wed, Jan 17, 2007 at 10:34:55AM -0600, JR Richardson
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?
If all else fails: an external password changing script:
Look for externpass in the sample voicemail.conf . Its parameters are a
voicemailbox and the new password.

-- 
               Tzafrir Cohen       
icq#16849755                    jabber:tzafrir@jabber.org
+972-50-7952406           mailto:tzafrir.cohen@xorcom.com       
http://www.xorcom.com  iax:guest@local.xorcom.com/tzafrir

On Jan 17, 2007, at 11:00 AM, asterisk-users-request@lists.digium.com  
wrote:
> Date: Wed, 17 Jan 2007 09:55:50 -0700
> From: "David Thomas" <punknow@gmail.com>
> Subject: Re: [asterisk-users] FW: Realtime Voicemail Password Change
> 	Not	Working
> To: "Asterisk Users Mailing List - Non-Commercial Discussion"
> 	<asterisk-users@lists.digium.com>
> Message-ID:
> 	<27cfba050701170855ue6d3ebh702050b7576219b8@mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> On 1/17/07, JR Richardson <jmr.richardson@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?
>
> JR,
>
> I'm just pulling things out of the air here, but if realtime voicemail
> works like realtime users/peers, loading everything into memory from
> MySQL, then there would need to be some type or prune command to force
> the re-read of the voicemail table, this is asuming you change the
> password via MySQL and not on the handset. Maybe something like DBput
> would work to update astdb as well. Again just throwing out ideas...
>
> It sounds like you are using the handset to update the password. Is
> this correct?
I can confirm that I also have this issue.  For the record I can  
confirm that the PIN is not changed in the Mysql DB.  I think,  
however, that I don't have a "uniqueid" column.  Maybe check this
out:
http://bugs.digium.com/view.php?id=8758

Thanks,
- Jesse