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" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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 | [EMAIL PROTECTED] | 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 > [EMAIL PROTECTED] > 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 > [EMAIL PROTECTED] > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users _______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
