We have moved our voicemail message store to a MySQL database. The idea was to have voicemail on a database server so that we can move from our production environment to a failover environment without having to deal with voicemail getting spread across two machines.
I heard from two users to day who cannot check their voicemail from the user portal. I thought we tested that when we moved to MySQL, but it could have gotten missed.
Is anyone else using a database for voicemail? Any idea how to go about troubleshooting this? We're running MTE 6.1.1.5.
Actually, the move to mysql
Actually, the move to mysql was pretty painless. The hardest part was installing/configuring odbc. I like being able to use sql to query the vm data.
We have a script that imported all of the existing data into the database in a matter of minutes. The next step in the plan its to develop process for purging old voicemail. We have a number of users who didn't let us turn on vm-to-email-with-delete, so we've got a large number of very old messages.
I don't think this problem with viewing messages in the portal started when we imported into the db. It seems to have only surfaced a few days ago. We saw messages in the portal aster the db migration.
Ok, apparently this was a bad
Ok, apparently this was a bad idea. Seems like it is not supported on the current version of the user portal. Alex said it may be one day, but not now. We're weighing options of whether to leave it as is and give up the user portal functionality or write a script to move it back.
you could have just mapped the portion of the filesystem to a SAN using something like iSCSI on a backside network. Then all of /var/spool/asterisk could have gone along for a ride. Seems easier IMO.