<div>edit your </div>
<div>/etc/asterisk/logger.conf</div>
<div> </div>
<div>file and add "debug" to the console => </div>
<div>line</div>
<div> </div>
<div>Then:</div>
<div>asterisk -r</div>
<div> </div>
<div>and at the CLI type:</div>
<div>logger reload</div>
<div> </div>
<div>see if that helps.</div>
<div>-Brett</div>
<div><br><br> </div>
<div><span class="gmail_quote">On 1/17/07, <b class="gmail_sendername">JR Richardson</b> <<a href="mailto:jmr.richardson@gmail.com">jmr.richardson@gmail.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Hi all,<br><br>I'm struggling with an issues trying to debug further, need some<br>pointers. I've been through the standard debugs, logs for asterisk
<br>and mysql. I'm not seeing where asterisk is sending the update<br>password statement to mysql. All other read/write activity is<br>functioning properly. Changing the password works in the<br>voicemail.conf file, just not to the mysql database, more info below.
<br>Question:<br>How do I get more advanced debugging, C code level, on what is<br>happening in the asterisk process associated with mysql driver? I've<br>done some gdb bactraces but shows no errors, all processes seem ok.
<br>Is there another tool I can use to see in detail what asterisk is<br>doing, how it is interacting with mysql realtime driver?<br><br>Thanks.<br>JR<br><br>---------- Forwarded message ----------<br>From: JR Richardson <
<a href="mailto:jmr.richardson@gmail.com">jmr.richardson@gmail.com</a>><br>Date: Jan 17, 2007 2:14 PM<br>Subject: Re: Realtime Voicemail Password Change Not Working<br>To: <a href="mailto:asterisk-users@lists.digium.com">
asterisk-users@lists.digium.com</a><br><br><br>> On 1/17/07, JR Richardson <<a href="mailto:jmr.richardson@gmail.com">jmr.richardson@gmail.com</a>> wrote:<br>> > > I'm using asterisk <a href="http://1.2.9.1">
1.2.9.1</a> and mysql 3.23, asterisk add-ons 1.2.3.<br>> > > All seems to work normally with realtime voicemail, reads vmbox<br>> > > parameters from the db fine. When I try to change the password,<br>> > > asterisk operates normally, "enter new password" ok, "re-enter new
<br>> > > password" ok, "password has been changed"<br>> > ><br>> > > There are no entries in the mysql.log setting the new password in the<br>> > > database. How can I isolate between asterisk, realtime driver, and
<br>> > > mysql?<br>> ><br>> > I updated to asterisk 1.2.14 and add-ons 1.2.5 with no luck. I still don't<br>> > see any update statement in the mysql.log when I change a password. I built
<br>> > a vmbox in the voicemail.conf file and can change that password just fine.<br>> > Any suggestions?<br>><br>> JR,<br>><br>> I'm just pulling things out of the air here, but if realtime voicemail
<br>> works like realtime users/peers, loading everything into memory from<br>> MySQL, then there would need to be some type or prune command to force<br>> the re-read of the voicemail table, this is asuming you change the
<br>> password via MySQL and not on the handset. Maybe something like DBput<br>> would work to update astdb as well. Again just throwing out ideas...<br>><br>> It sounds like you are using the handset to update the password. Is
<br>> this correct?<br><br>Yes, I'm using the handset to change the vm password, throught the vm<br>advanced features. I can directly change the db as expected, just not<br>through the vm application.<br><br>> Not sure about how you log in MySQL but using ODBC, in your
<br>> odbcinst.ini or a similar file for Mysql, which keeps the settings for<br>> your db driver etc, you should be able to turn on logging. I can in<br>> odbcinst and it creates logs.<br>><br>> The problem you have seems more like a permission problem however, the
<br>> user you're using to log into the DB doesn't seem to have the<br>> permission to write to the table which keeps the user information OR<br>> the voicemail database itself. This problem becomes a bit trickier
<br>> when your vm user table is actually a view of tables that hold<br>> subscriber/user information and is compounded by the fact if<br>> voicemails are being stored in a different db than where the sip/iax<br>
> user information is being stored to derive sipusers and sippeers<br>> family values as then the user that asterisk is using to connect to<br>> the voicemail db will also need write permission in the db that stores
<br>> user information.<br><br>I use the same database for the sip, iax, exten and vm, different<br>tables. When a sip device registers, asterisk writes to the database<br>with updates to the sip table ipaddress, port and regseconds, so I
<br>don't think there is a write permissions issue from asterisk res_mysql<br>to the mysql database. I thought of that also and changed the user to<br>full access, but that didn't help. Mysql logs all database<br>
transactions in the /var/log/mysql.log file. I see all the query<br>selects from the voicemail table and i see all the query updates to<br>the sip table, but never see any query updates for the vmpasswd to the<br>voicemail table. I would assume there would at least be errors if
<br>there was a permissions problem. I don't see where asterisk is trying<br>to update the vmpassword through the realtime driver.<br><br>How is your voicemail.conf file setup?<br><br>Thanks.<br><br>JR<br>--<br>JR Richardson
<br>Engineering for the Masses<br><br><br>--<br>JR Richardson<br>Engineering for the Masses<br>_______________________________________________<br>--Bandwidth and Colocation provided by <a href="http://Easynews.com">Easynews.com
</a> --<br><br>asterisk-dev mailing list<br>To UNSUBSCRIBE or update options visit:<br> <a href="http://lists.digium.com/mailman/listinfo/asterisk-dev">http://lists.digium.com/mailman/listinfo/asterisk-dev</a><br></blockquote>
</div><br>