On 1/18/07, JR Richardson <[EMAIL PROTECTED]> 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 _______________________________________________ --Bandwidth and Colocation provided by Easynews.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
