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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 [email protected] 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. _______________________________________________ --Bandwidth and Colocation sponsored by Easynews.com -- 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
