Hi need to use the realtime option only for the voicemail
I create a view on the DB asterisk called voicemail_users
mysql> desc voicemail_users;
±------------±------------±-----±----±--------------------±------+
| Field | Type | Null | Key | Default | Extra |
±------------±------------±-----±----±--------------------±------+
| uniqueid | int(11) | NO | | 0 | |
| customer_id | varchar(6) | YES | | NULL | |
| context | varchar(7) | NO | | | |
| mailbox | varchar(6) | YES | | NULL | |
| password | varchar(12) | NO | | NULL | |
| fullname | varchar(30) | YES | | NULL | |
| email | varchar(70) | NO | | NULL | |
| pager | char(0) | NO | | | |
| stamp | timestamp | NO | | 0000-00-00 00:00:00 | |
| attach | tinyint(1) | NO | | NULL | |
±------------±------------±-----±----±--------------------±------+
10 rows in set (0.00 sec)
I add the following line to the extconfig.conf
voicemail => mysql,asterisk,voicemail_users
I configured the res_mysql.conf
However
Jan 23 21:44:12] NOTICE[1454] pbx_ael.c: AEL load process: calculated config file name ‘/etc/asterisk/extensions.ael’.
[Jan 23 21:44:12] NOTICE[1454] pbx_ael.c: AEL load process: parsed config file name ‘/etc/asterisk/extensions.ael’.
[Jan 23 21:44:12] NOTICE[1454] pbx_ael.c: AEL load process: checked config file name ‘/etc/asterisk/extensions.ael’.
[Jan 23 21:44:12] NOTICE[1454] pbx_ael.c: AEL load process: compiled config file name ‘/etc/asterisk/extensions.ael’.
[Jan 23 21:44:12] NOTICE[1454] pbx_ael.c: AEL load process: merged config file name ‘/etc/asterisk/extensions.ael’.
[Jan 23 21:44:12] NOTICE[1454] pbx_ael.c: AEL load process: verified config file name ‘/etc/asterisk/extensions.ael’.
[Jan 23 21:44:12] WARNING[1454] app_voicemail.c: Failed to load configuration file.
[Jan 23 21:44:12] WARNING[1454] cdr_addon_mysql.c: Unable to load config for mysql CDR’s: cdr_mysql.conf
On asterisk
superhost*CLI> realtime mysql status
Connected to asterisk@localhost, port 3306 with …
It is the first time that I try the realtime
what I am doing wrong