[Asterisk-Users] MySQL Voicemail Problems

[Matthew Boehm]

Our mysql-voicemail works perfectly. Why does your extension have + in it?
All of our extensions are simple 4 numberd ones.
I have no [default] in my voicemail.conf file.
That is really wierd since the query is working fine. Anything in the debug?

Matthew

----- Original Message ----- 
From: "TSS Support" <support at tss.net>
To: <asterisk-users at lists.digium.com>
Sent: Friday, September 17, 2004 3:56 PM
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