[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