You are missing many columns in that table. Goto the wiki and get the right
schema.
-Matthew
----- Original Message -----
From: "Vamsi Pottangi" <[EMAIL PROTECTED]>
To: <Asterisk-Users@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
> '[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
> Asterisk-Users@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
_______________________________________________
Asterisk-Users mailing list
Asterisk-Users@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
