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@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
> 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@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@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 >
You are missing many columns in that table. Goto the wiki and get the right schema. -Matthew ----- Original Message ----- From: "Vamsi Pottangi" <vamsipottangi@gmail.com> 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 > '000d6579-6bab0004-7410df72-6c33d501@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@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
Seemingly Similar Threads
- chan_zap.so: load_module fails: Fedora Core 3: SMP
- maximum concurrent ZAP channels .... max conf ports ...
- Trouble with Realtime
- Asterisk and CCM 5.x SIP trunk
- app_voicemail.c still looking for config file even I try to configure the voicemail from database.