[asterisk-users] Reading Voicemail Config from MySQL [+ ODBC]

[Mosiuoa Tsietsi]

Hi,

After some more searching I decided to try USING unix ODBC for the
connection.  I have both the unixODBC and unixODBC-devel packages on my
fedora box:

[root at myserver /]# rpm -qa | grep -i unixodbc
unixODBC-2.2.11-7.1
unixODBC-devel-2.2.11-7.1

Here are my odbcinsi.ini and odbc.ini files respectively:

[MySQL]
Description     = ODBC for MySQL
Driver          = /usr/lib/libmyodbc.so
Setup           = /usr/lib/libodbcmyS.so
FileUsage       = 1

---
[MYSQL-asterisk]
Driver = MySQL
Description = Data source for dynamic asterisk voicemail configuration
Trace = Yes
TraceFile = stderr
SERVER = localhost
USER = root
PASSWORD = rootroot9
PORT = 3306
DATABASE = asterisk
-----

Below are my res_odbc.conf and extconfig.conf files for supplying
details of the DSN name and and database/table for asterisk

[mysql1]
enabled => yes
dsn => MySQL-asterisk
username => root
password => ***
pre-connect => yes

---
[settings]
voicemail => odbc,mysql1,users
---
I am able to execute:
[root at myserver /]# isql -v MySQL-asterisk
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL>                                      

which shows I can connect to the database on the command line using my
DSN name.

In the asterisk CLI however, the command:

asterisk*CLI> odbc show
No such command 'odbc' (type 'help' for help)

fails which is supposed to show connections to MySQL from the CLI.  ANd
lastly the command:

asterisk*CLI> realtime load voicemail mailbox 7521
No rows found matching search criteria.
Nov  6 00:33:10 WARNING[2965]: config.c:920 find_engine: Realtime
mapping for 'voicemail' found to engine 'odbc', but the engine is not
available

also fails.  Where are I going wrong?
Thanks.

On Sun, 2006-11-05 at 13:39 +0200, Mosiuoa Tsietsi wrote:
> Hi all,
> 
> I have been trying to get my asterisk (v1.2.10) to lookup voicemail
> config data from my mysql database as opposed to voicemail.conf +
> sip.conf for my users.  Users register with SER and get passed through
> to asterisk when they dial out. I followed the instructions as per
> http://www.voip-info.org/wiki/view/Asterisk+voicemail+database
> 
> so basically I have 
> 1) Build asterisk-addons-1.2.5 and added the USE_MYSQL_VM_INTERFACE=1 to
> the asterisk/apps folder and built asterisk again
> 2) I configured my voicemail.conf appropriately:
> 
> dbuser=username
> dbpass=password
> dbhost=localhost
> dbname=asterisk_vm
> 
> and have a database called asterisk_vm with a table called users with
> the fields needed by asterisk
> 3) Populated my database with some values
> 
> When I try to leave a voicemail, I get the following error in the CLI:
> 
> -- Called 7521 at myserver
>     -- SIP/myserver-08c5ef80 is ringing
>     -- Nobody picked up in 20000 ms
>     -- Executing VoiceMail("SIP/myserver-08c731a0", "u7521") in new
> stack
> Nov  5 13:30:55 WARNING[18146]: app_voicemail.c:2412 leave_voicemail: No
> entry in voicemail config file for '7521'
> 
> I was able (thanks to some guys on this list) to get my Prepaid
> application to read from the database but voicemail won't.
>  
> Please help me with this error.  Thanks.
> 
> _______________________________________________
> --Bandwidth and Colocation provided by Easynews.com --
> 
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
> 
-- 
The Law of Unintended Consequences:  for every action, there is an
excellent chance of producing an opposite and totally disproportionate
reaction. - Clyde Haberman