Is the storage of actual voicemail messages in a database still limited to ODBC? If so, why? And is the use of mySQL and ODBC at the same time still a bad idea? If so, why? I want to store all of my voicemail stuff in a database so that I can give users web access to it, but I don't want to run web services on my * server itself. If it is all in a DB, I can have a web box and a separate SQL box and none of it should affect *.
Hi Peder, I asked the same question some time ago. Never got any answer... :-( Norbert Peder @ NetworkOblivion schrieb:> Is the storage of actual voicemail messages in a database still limited > to ODBC? If so, why? > > And is the use of mySQL and ODBC at the same time still a bad idea? If > so, why? > > I want to store all of my voicemail stuff in a database so that I can > give users web access to it, but I don't want to run web services on my > * server itself. If it is all in a DB, I can have a web box and a > separate SQL box and none of it should affect *. > > _______________________________________________ > --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 >
On 11/28/06, Peder @ NetworkOblivion <peder@networkoblivion.com> wrote:> Is the storage of actual voicemail messages in a database still limited > to ODBC? If so, why? > > And is the use of mySQL and ODBC at the same time still a bad idea? If > so, why? > > I want to store all of my voicemail stuff in a database so that I can > give users web access to it, but I don't want to run web services on my > * server itself. If it is all in a DB, I can have a web box and a > separate SQL box and none of it should affect *. >Mate, I can't say it with authority but I'm almost certain that the only DB that a specific driver was written for is MySQL. I think if you use res_mysql.o you should be able to talk to mySql directly without needing ODBC. I'm using ODBC via FreeTDS to an MSSQL Server, now that might be a disaster waiting to happen but won't know till I put some load on it. It seems to work well in the Lab with about 4-5 asterisk servers ALL accessing voicemail concurrently.
Hi Peder -> Is the storage of actual voicemail messages in a database still limited > to ODBC? If so, why?Yes. Why? Nobody has developed a voicemail solution that directly connects to a *SQL database for message storage.> And is the use of mySQL and ODBC at the same time still a bad idea? If > so, why?ODBC is just a connection to interface with a database. You have to run a database like mysql in order to use an ODBC driver. Can you use the same mysql database for asterisk configs and odbc voicemail storage: yes.> I want to store all of my voicemail stuff in a database so that I can > give users web access to it, but I don't want to run web services on my > * server itself. If it is all in a DB, I can have a web box and a > separate SQL box and none of it should affect *.Yes, you can do this. There are other ways to do this without using database storage for voicemail (e.g. you could use normal file-based storage for voicemail and have the webserver connect to the vm storage on the * server via nfs). - Noah