Hello,
In the process of upgrading a couple of voicemail servers from CVS (end of
august 2005) to 1.2.1
This is a purely voicemail system using mysql configurations.
All my mailboxes are in the "default" context and it worked fine under
the
CVS version. But with 1.2.1 the voicemailmain fails to authenticate. I
debugged and searched around a bit.
And found the problem in the Mysql request.
Under CVS the request was:
Dec 8 10:13:53 DEBUG[32760] res_config_mysql.c: MySQL RealTime: Retrieve
SQL: SELECT * FROM users WHERE mailbox = '201' AND context =
'default'
Under 1.2.1 the request is:
Dec 7 15:09:55 DEBUG[3900] res_config_mysql.c: MySQL RealTime: Retrieve
SQL: SELECT * FROM users WHERE mailbox = '201' AND context = ''
According to the documentation, if I don't specify the context, it should
take the "default" context shouldn't it?
After googling a bit, I found bug 5899 which seems to be related, but the
way I understand it, the old behaviour was if no context pas specified, it
selected without context. In the new version it selects the default context.
Tried testing with the "searchcontexts=yes". It recognises the
mailbox, but
doesn't seem to match the password.
Dec 8 10:41:34 VERBOSE[5567] logger.c: -- Executing
VoiceMailMain("SIP/1111-c37a", "201") in new stack
Dec 8 10:41:34 DEBUG[5567] res_config_mysql.c: MySQL RealTime: Retrieve
SQL: SELECT * FROM users WHERE mailbox = '201'
Dec 8 10:41:34 DEBUG[5567] res_config_mysql.c: MySQL RealTime: Everything
is fine.
Dec 8 10:41:34 VERBOSE[5567] logger.c: -- Playing 'vm-password'
(language 'en')
Dec 8 10:41:37 VERBOSE[5567] logger.c: -- Incorrect password '123'
for
user '201' (context = default)
Am I missing something? When I don't specify the context, it should take the
"default context" or the "default" context ? Where do I
specify it?
Any ideas why the password match isin't working if I revert to the old
method ?
Example mysql entry:
+--------+-----------+-------+-------+--------+--------+-------------+-----+
------+------+------+--------+-------------+--------------+-------+
|uniqueid|customer_id|context|mailbox|password|fullname|email
|pager|attach|saycid|delete|envelope|serveremail |stamp |options|
+--------+-----------+-------+-------+--------+--------+-------------+-----+
------+------+------+--------+-------------+--------------+-------+
| 1| 0|default| 201 | 123 |Bob |null@null.com|
|yes |no |no |no |test@test.com|20051207164443|NULL |
+--------+-----------+-------+-------+--------+--------+-------------+-----+
------+------+------+--------+-------------+--------------+-------+
Extension is simply a "Voicemailmain(201)"
Thanks,
Benjamin