[Asterisk-Users] Realtime Voicemail ...

[Matt Klein]

> 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
> '000d6579-6bab0004-7410df72-6c33d501 at 135.254.197.186' 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
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>