[Asterisk-Users] Re: Forward Voicemail to remote server?

[Watkins, Bradley]

I believe the odbcstorage variable in voicemail.conf needs to be set to the
name of the connection in res_odbc.conf not the dsn.  So in your example,
you would need:  odbcstorage=MySQL

Regards,
- Brad

-----Original Message-----
From: asterisk-users-bounces at lists.digium.com
[mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Noah Miller
Sent: Tuesday, November 22, 2005 6:01 PM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: [Asterisk-Users] Re: Forward Voicemail to remote server?


Hi All -
 
>>>> Of course, what I really want is an asterisk VM system where user 
>>>> accounts are transparent across many servers, and VM's can be 
>>>> shuffled around between the servers as a configuration option in 
>>>> voicemail.conf. I wish I could code and knew Objective-C!  Maybe I 
>>>> should submit a feature request.
>>> 
>>> Why don't you use realtime voicemail with the thing for storing 
>>> messages as blobs?

Well, so I'm trying to get this set up, and I'm a little stuck.  I think
I've got at least two separate problems.  Asterisk (1.2 from tarball) shows
this warning:

Nov 22 16:57:54 WARNING[8150]: app_voicemail.c:2065 messagecount: Failed to
obtain database object for 'asterisk'!

It also says it's still recording to a file spool:

    -- Recording the message
    -- x=0, open writing:
/var/spool/asterisk/voicemail/default/68/INBOX/msg0000 format: wav49,
0x81afdc8


I've got the voicemessages table set up in mysql (database name 'asterisk').
My res_odbc.conf looks like this:

[MySQL]
dsn => asterisk
username => asterisk
password => secret
pre-connect => yes


And my voicemail.conf (relevant portion) looks like this:

[general]
odbcstorage=asterisk
odbctable=voicemessages


I don't know if it makes a difference, but the only thing in my
extconfig.conf is:

voicemail => mysql,asterisk,voicemail_users


My odbc.ini looks like this:
[MySQL]
Description = MySQL test database
Trace       = Off
TraceFile   = stderr
Driver      = MySQL
SERVER      = 127.0.0.1
USER        = asterisk
PASSWORD    = secret
PORT        = 3306
DATABASE    = asterisk


Anybody know what I've bungled?

Thanks!
Noah Miller



_______________________________________________
--Bandwidth and Colocation sponsored by Easynews.com --

Asterisk-Users mailing list
Asterisk-Users at 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



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it.