ASTERISK-06105: Problems in Voicemail

[Home]

Summary: ASTERISK-06105: Problems in Voicemail

Reporter: Alexandre (alexbonatti) Labels:

Date Opened: 2006-01-17 04:32:49.000-0600 Date Closed: 2006-01-17 10:58:10.000-0600

Priority: Major Regression? No

Status: Closed/Complete Components: Applications/app_voicemail

Versions: Frequency of
Occurrence

Related
Issues:

Environment: Attachments:

Description: the 1.2.1 asterisk version, have a problem:

When the voicemail app is called (su<exten>@<context>), the SELECT search the context field empty:
Jan 6 17:04:19 DEBUG[3655] res_config_mysql.c: MySQL RealTime: Retrieve SQL: SELECT * FROM voicemail_users WHERE mailbox = '12010002' AND context = ''
Is doesn´t use any context name, because the app do not find the context...
If you use the field context NULL, the app find it.

context field empty, working:

Jan 6 17:04:19 DEBUG[3655] res_config_mysql.c: MySQL RealTime: Retrieve SQL: SELECT * FROM voicemail_users WHERE mailbox = '12010002' AND context = ''
Jan 6 17:04:19 DEBUG[3655] res_config_mysql.c: MySQL RealTime: Everything is fine.
Jan 6 17:04:19 DEBUG[3585] chan_sip.c: = Found Their Call ID: 5f21105e0a62dc1c05892ecf102840f2@xxx.xxx.xxx.xxx Their Tag as6a281e5d Our tag: as4e9f70bd

context field as teste, don´t working:

Jan 6 16:54:42 DEBUG[3638] res_config_mysql.c: MySQL RealTime: Retrieve SQL: SELECT * FROM voicemail_users WHERE mailbox = '12010002' AND context = ''
Jan 6 16:54:42 DEBUG[3638] res_config_mysql.c: MySQL RealTime: Everything is fine.
Jan 6 16:54:42 WARNING[3638] app_voicemail.c: No entry in voicemail config file for '12010002'

Comments: By: twisted (twisted) 2006-01-17 09:27:33.000-0600

there is no difference in the query between your non-working example and working example...
By: Alexandre (alexbonatti) 2006-01-17 10:38:31.000-0600

this is the problem, the voicemail it's not working with a context. The select parameter just work with no context to the sip user.
By: Jason Parker (jparker) 2006-01-17 10:57:45.000-0600

Already fixed in trunk and 1.2 branch. Please apply the patch in ASTERISK-5816. Reopen this bug if you still have problems.

In the future, please search bugs (include closed bugs) before making a report - there have already been about 5 reports exactly the same as this one. Also, please be sure to select the correct asterisk version - I almost spent time on this, until I noticed you briefly mentioned 1.2.1.