I have Asterisk RealTime configuration with MySQL database. When I call to a number and leave him voicemail it is saved into database table voicemail_users. Right after I leave the message and hangup I got this in the console( CLI ):
[Feb 5 09:33:29] WARNING[C-0000000a]: app_voicemail.c:3925 retrieve_file: SQL Get Data error! coltitle=mailbox [SELECT * FROM voicemessages WHERE dir=? AND msgnum=?]
Note that the message is fully stored into table VOICEMESSAGES and I can listen from the number to which I leave the voicemail.
What can be the problem for this Warning?
This is my res_config_mysql.conf
[general] dbhost = MY_IP dbname = asterisk dbuser = MY_USER dbpass = MY_PASS ;dbport = 3306 ;dbsock = /tmp/mysql.sock ;dbcharset = latin1 requirements=warn ; or createclose or createchar
this is extconfig.conf
[settings] sipusers => mysql,general,sipfriends sippeers => mysql,general,sipfriends extensions => mysql,general,extensions voicemail => mysql,general,voicemail_users