[Asterisk-Users] MySQL Voicemail Problems

TSS Support support at tss.net
Fri Sep 17 13:56:01 MST 2004


I know this has been moved to contrib, but is anybody using it successfully? 
We are looking at using Asterisk for the fine IVR features it has, tied in 
with another platform. Calls are getting routed to it, but the following is 
happening: (I've redacted phone#s and passwords)

asterisk log:
Sep 17 11:56:24 WARNING[17423]: No entry in voicemail config file for 
'+13609XX2000'
Sep 17 11:56:34 WARNING[17423]: Timeout, but no rule 't' in context 
'default'

When this happens, the following query is happening:

040917 11:56:24     102 Query       SELECT 
password,fullname,email,pager,options FROM users WHERE context='default' AND 
mailbox='+13609XX2000'

The query works fine:

vm:/var/log/mysql# mysql -p asterisk
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 108 to server version: 4.0.20-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SELECT password,fullname,email,pager,options FROM users WHERE 
context='default' AND mailbox='+13609XX2000';
+----------+-----------+-----------------+------------+---------+
| password | fullname  | email           | pager      | options |
+----------+-----------+-----------------+------------+---------+
| XXXX     | Test User | support at tss.net | 8005551212 |         |
+----------+-----------+-----------------+------------+---------+
1 row in set (0.01 sec)

mysql> \q
Bye

Voicemail.conf looks like this:

;
; Voicemail Configuration
;
[general]
; Default formats for writing Voicemail
format=wav49
serveremail=support at tss.net
attach=yes
skipms=3000
maxsilence=5
silencethreshold=128
maxlogins=5

dbuser=asterisk
dbpass=xxxxxxx
dbhost=localhost
dbname=asterisk

pbxskip=yes
fromstring=Passnet Voicemail

[zonemessages]
eastern=America/New_York|'vm-received' Q 'digits/at' IMp
central=America/Chicago|'vm-received' Q 'digits/at' IMp
central24=America/Chicago|'vm-received' q 'digits/at' H 'digits/hundred' M 
'hours'

[default]



Am I missing something obvious? The system is Debian stable. I compiled the 
package myself, using deb-buildpackage, after modifying the appropriate file 
for an include. The Asterisk server is logging in and executing a query, and 
if I run that query myself I get results back ... what else is left? Help, 
please!

-Keith, TSS Support 




More information about the asterisk-users mailing list