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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of TSS Support Sent: Friday, September 17, 2004 4:56 PM To: [EMAIL PROTECTED] 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
