[asterisk-dev] Fwd: Realtime Voicemail Password Change Not Working

[Brett List]

edit your
/etc/asterisk/logger.conf

file and add "debug" to the console =>
line

Then:
asterisk -r

and at the CLI type:
logger reload

see if that helps.
-Brett



On 1/17/07, JR Richardson <jmr.richardson at gmail.com> wrote:
>
> Hi all,
>
> I'm struggling with an issues trying to debug further, need some
> pointers.  I've been through the standard debugs, logs for asterisk
> and mysql.  I'm not seeing where asterisk is sending the update
> password statement to mysql. All other read/write activity is
> functioning properly.  Changing the password works in the
> voicemail.conf file, just not to the mysql database, more info below.
> Question:
> How do I get more advanced debugging, C code level, on what is
> happening in the asterisk process associated with mysql driver?  I've
> done some gdb bactraces but shows no errors, all processes seem ok.
> Is there another tool I can use to see in detail what asterisk is
> doing, how it is interacting with mysql realtime driver?
>
> Thanks.
> JR
>
> ---------- Forwarded message ----------
> From: JR Richardson <jmr.richardson at gmail.com>
> Date: Jan 17, 2007 2:14 PM
> Subject: Re: Realtime Voicemail Password Change Not Working
> To: asterisk-users at lists.digium.com
>
>
> > On 1/17/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?
> >
> > 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?
>
> Yes, I'm using the handset to change the vm password, throught the vm
> advanced features.  I can directly change the db as expected, just not
> through the vm application.
>
> > 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 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
> --
> JR Richardson
> Engineering for the Masses
>
>
> --
> JR Richardson
> Engineering for the Masses
> _______________________________________________
> --Bandwidth and Colocation provided by Easynews.com --
>
> asterisk-dev mailing list
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-dev/attachments/20070117/aad5d0ee/attachment-0001.htm