beonice
2005-Feb-11 15:08 UTC
[Asterisk-Users] Still stuck trying to make Asterisk read MySQL
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 |
me@mydomain.com | | 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
Joe Dennick
2005-Feb-12 15:39 UTC
[Asterisk-Users] Still stuck trying to make Asterisk read MySQL
I've been working with RealTime configuration from MySQL Server, and have had good results. You might check it out. You can do a search for 'realtime' on the Wiki and get some good documentation on how to set it up. I think in the extconfig.conf file, not only do you need to identify the engine (ODBC in your case), but you also need to identify the actual table you used for your Voicemail configuration. If I recall correctly, the default is a table named 'voicemail' and since you are using a different name, you need to specify the name in the extconfig.conf file so it can find it. beonice (beonice@yahoo.com) wrote:> > 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 | > me@mydomain.com | | 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 > 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 >-- Joe Dennick joe@dennick.net