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@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@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
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@lists.digium.com [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of TSS Support Sent: Friday, September 17, 2004 4:56 PM To: asterisk-users@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@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@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@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
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@tss.net> To: <asterisk-users@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 itsuccessfully?> 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 followingis> 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@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@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 compiledthe> package myself, using deb-buildpackage, after modifying the appropriatefile> 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@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