[Asterisk-Users] Realtime Voicemail ...

Matthew Boehm mboehm at cytelcom.com
Tue Jan 18 08:00:52 MST 2005


You are missing many columns in that table. Goto the wiki and get the right
schema.

-Matthew
----- Original Message ----- 
From: "Vamsi Pottangi" <vamsipottangi at gmail.com>
To: <Asterisk-Users at lists.digium.com>
Sent: Tuesday, January 18, 2005 6:13 AM
Subject: [Asterisk-Users] Realtime Voicemail ...


> 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




More information about the asterisk-users mailing list