MySQL RealTime: Retrieve SQL: SELECT * FROM voicemail_users WHERE mailbox = '201' AND context = 'default'
There is no column 'context'.
Add a column 'context' to your voicemail_users table, default value of 'default', make sure the column is filled with 'default' as a value. Or edit the source code to modify the SQL call, to ignore querying the "AND context = '....".
Do this and your login should work.
----------------------------------------------------- "Yeah, we rocked the vote all right. Those little bastards betrayed us again." - Hunter S. Thompson on the 2004 election.
On Tue, 18 Jan 2005, Vamsi Pottangi wrote:
Hi,
Realtime SIP and Extensions are working fine but facing some problems with Voicemail.
Added an entry to extconfig.conf voicemail => mysql,asterisk,voicemail_users
Created the corresponding table and an entry for mailbox 201. This is also reflected in the CLI as shown below. CLI> realtime load voicemail mailbox 201 Column Name Column Value -------------------- -------------------- uniqueid 1 customer_id 201 mailbox 201 password 201 fullname Mailbox 201 stamp 20050118164309 CLI>
When I try to log into the Voicemailmain, it cribs for incorrect login as shown below. Where am I going wrong ?
Jan 18 17:49:12 DEBUG[5502]: MySQL RealTime: Retrieve SQL: SELECT * FROM extensions_table WHERE exten = '8500' AND context = 'default' AND priority = '1' Jan 18 17:49:12 DEBUG[5502]: MySQL RealTime: Everything is fine. Jan 18 17:49:12 DEBUG[5502]: MySQL RealTime: Retrieve SQL: SELECT * FROM extensions_table WHERE exten LIKE '\_%' AND context = 'default' AND priority = '1' ORDER BY exten Jan 18 17:49:12 DEBUG[5502]: MySQL RealTime: Everything is fine. Jan 18 17:49:12 VERBOSE[5502]: -- Executing VoiceMailMain ("SIP/vamsi-0c3c", "") in new stack Jan 18 17:49:12 DEBUG[5502]: Scheduling timer at 160 sample intervals Jan 18 17:49:12 VERBOSE[5502]: -- Playing 'vm-login' (language 'en') Jan 18 17:49:12 DEBUG[5502]: Stopping retransmission on '[EMAIL PROTECTED]' of Response 101: Found Jan 18 17:49:14 DEBUG[5502]: Manager received command 'Command' Jan 18 17:49:14 DEBUG[5502]: Scheduling timer at 0 sample intervals Jan 18 17:49:14 DEBUG[5502]: Scheduling timer at 0 sample intervals Jan 18 17:49:16 DEBUG[5502]: MySQL RealTime: Retrieve SQL: SELECT * FROM voicemail_users WHERE mailbox = '201' AND context = 'default' Jan 18 17:49:16 DEBUG[5502]: MySQL RealTime: Everything is fine. Jan 18 17:49:16 DEBUG[5502]: Scheduling timer at 160 sample intervals Jan 18 17:49:16 VERBOSE[5502]: -- Playing 'vm-password' (language 'en') Jan 18 17:49:17 DEBUG[5502]: Scheduling timer at 0 sample intervals Jan 18 17:49:17 DEBUG[5502]: Scheduling timer at 0 sample intervals Jan 18 17:49:19 VERBOSE[5502]: -- Incorrect password '201' for user '201' (context = <any>) Jan 18 17:49:19 DEBUG[5502]: Scheduling timer at 160 sample intervals Jan 18 17:49:19 VERBOSE[5502]: -- Playing 'vm-incorrect- mailbox' (language 'en') Jan 18 17:49:22 DEBUG[5502]: Scheduling timer at 0 sample intervals Jan 18 17:49:22 DEBUG[5502]: Scheduling timer at 0 sample intervals
Thanks, ~Vamsi _______________________________________________ Asterisk-Users mailing list [email protected] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
_______________________________________________ Asterisk-Users mailing list [email protected] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
