I've been continuing to experiment with MySQL. I'm having absolutely no luck getting asterisk to read voicemail configuration data and mailbox configuration data from mysql tables instead of from voicemail.conf.
The default Asterisk setup that reads from voicemail.conf and extensions.conf works fine. I'm using Asterisk CVS-v1-0-12/12/04-15:58:29 on a Whitebox Enterprise Linux box. I'm not using any telephony hardware or SIP phones. I've just got a voicepulse DID talking to asterisk via IAX. I've got mysql downloaded and installed and have successfully got the contributed script reading from my asterisk_vm database to set up the extensions.conf, as per the instructions at: http://www.voip-info.org/wiki-Asterisk+extensions+from+mysql Now I'm trying to get Asterisk to look up voicemail configs from the asterisk_vm database. In order to do this, I've been following the instructions at: http://www.voip-info.org/wiki-Asterisk+voicemail+database So, I've: 1) Updated the /usr/src/asterisk/apps/Makefile to have USE_MYSQL_VM_INTERFACE=1 and recompiled asterisk, with make clean; make; make install 2) Updated voicemail.conf to have the appropriate entries: dbuser=username ;; Yes I changed this to my username dbpass=password ;; Yes I changed this to my password dbhost=localhost dbname=asterisk_vm 3) Created the users table in the asterisk_vm database. +---------+------------+----------+--------------+-------------------+-------+------------+----------------+ | context | mailbox | password | fullname | email | pager | options | stamp | +---------+------------+----------+--------------+-------------------+-------+------------+----------------+ | default | 1111 | 1234 | Moron Tester | [EMAIL PROTECTED] | | attach=yes | 20050211131641 | +---------+------------+----------+--------------+-------------------+-------+------------+----------------+ 4) Updated extensions.conf to have the following line: exten => 1111,1,VoiceMail(u1111) I tried restarting asterisk at this point, called in and tried to leave voicemail for extension (and mailbox) 1111. Here's the message I get: *CLI> Feb 11 13:21:36 WARNING[18393]: app_voicemail.c:1539 leave_voicemail: No entry in voicemail config file for '1111' So I dug around some more and found http://www.voip-info.org/wiki-Asterisk+res_config Decided to try these instructions as well. So: 5) I created the ast_config table as directed: Here is the data: +----+------------+------------+-----------+----------------+----------+----------+---------+ | id | cat_metric | var_metric | commented | filename | category | var_name | var_val | +----+------------+------------+-----------+----------------+----------+----------+---------+ | 1 | 0 | 0 | 0 | voicemail.conf | default | | | +----+------------+------------+-----------+----------------+----------+----------+---------+ 6) I edited /etc/asterisk/configs/res_odbc.conf to contain: [mysql1] dsn = MySQL-asterisk username = myuser password = mypass pre-connect = yes [mysql1] dsn = asterisk_vm username = myuser ;; changed to my userid on mysql password = mypass ;; changed to my password on mysql pre-connect = yes [mysql2] dsn = MySQL2-asterisk username = myuser2 password = mypass2 enabled = no [ENV] VAR=VALUE 7) Inserted glue to tell asterisk where to look: ; /etc/asterisk/res_config_odbc.conf [settings] table = ast_config connection = mysql1 8) Rerouted Asterisk's config engine: ; /etc/asterisk/extconfig.conf [settings] ;queues.conf => odbc voicemail.conf => odbc 9) I modified the sample script load_res_config.pl and ran it, it successfully updated my ast_config table, stuffing in all the settings that I'm used to seeing in voicemail.conf. 10) I restarted asterisk _again_. I get the exact same message. Feb 11 14:18:40 WARNING[18528]: app_voicemail.c:1539 leave_voicemail: No entry in voicemail config file for '1111' I'm totally out of ideas now. Anyone else got a clue to lend me? Thanks, Maya __________________________________ Do you Yahoo!? Take Yahoo! Mail with you! Get it on your mobile phone. http://mobile.yahoo.com/maildemo _______________________________________________ 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
