Summary:ASTERISK-02405: MYSQL Voice Mail Lookup
Reporter:slowmo (slowmo)Labels:
Date Opened:2004-09-14 22:50:32Date Closed:2011-06-07 14:10:04
Versions:Frequency of
Environment:Attachments:( 0) mysql-vm-routines.h
Description:MYSQL Lookups in Database was Fixed to context and and would not let one context user connect to other...

Example my adminusr could not connect to managers voice mail
Now Made for Dynamic lookup in MySQl
Comments:By: Brian West (bkw918) 2004-09-14 23:00:11

diff -u please so we can see what you have changed with ease.


By: Rob Gagnon (rgagnon) 2004-09-20 10:42:06

Even without the diff -u, I can see an issue with you having more than one of the same username under different contexts

The SQL used to select the user is faulty, as it is missing the context in the where clause.  You are also missing the context in the update statement as well.

This patch would UNDO some old bug repairs of long ago.

For example:  If you have user "joe@context" and user "joe@othercontext"...

If joe@context changes his password, joe@othercontext gets the same password.  This is bad.

Contexts are there to seperate users into different groups.  That's why you need them in the SQL.

By: Mark Spencer (markster) 2004-09-26 14:01:52

Is this ready to be closed?

By: Russell Bryant (russell) 2004-09-26 23:56:31

I sent a message to SlowMo about this on IRC and he responded with "??".  Feel free to re-open if you would like to follow up on this.