[Asterisk-Users] MySQL Voicemail Problems

[Michael Workman]

Yes I found some problems in it and created a patch for it also I am
patching the IAX2 iaxfriends to work properly should have it completed
tonight

But I have the Voicemail one done...



 

-----Original Message-----
From: asterisk-users-bounces at lists.digium.com
[mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of TSS Support
Sent: Friday, September 17, 2004 4:56 PM
To: asterisk-users at lists.digium.com
Subject: [Asterisk-Users] MySQL Voicemail Problems

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 

_______________________________________________
Asterisk-Users mailing list
Asterisk-Users at 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