Help Migrating Voicemail To Database

Home » Asterisk Users » Help Migrating Voicemail To Database
Asterisk Users No Comments

I am in the process of configuring my systems to store voicemail in a mysql databse as opposed to on the filesystem, as it is now.

My backup server is currently configured for db storage, while my production server is still using the filesystem during testing.

When I record a vm message on my backup server, I am able to retrieve it, hear it, and delete it as expected. So, I believe my backup server is properly configured.

However, when I move to my production server and run a script, that I wrote, to import the vm from the file system to the database, I have problems. I’m able to access the message from the voicemail system. However, when I go to listen to it, I get silence and the Asterisk server stops responding to new calls; I have to restart asterisk.

The console log looks like:
[Jun 14 07:30:58] — Playing ‘vm-youhave.ulaw’ (language ‘en’)
[Jun 14 07:30:59] — Playing ‘digits/1.ulaw’ (language ‘en’)
[Jun 14 07:31:00] — Playing ‘vm-INBOX.ulaw’ (language ‘en’)
[Jun 14 07:31:01] — Playing ‘vm-and.ulaw’ (language ‘en’)
[Jun 14 07:31:01] — Playing ‘vm-first.ulaw’ (language ‘en’)
voip11*CLI>
voip11*CLI>

The console remains responsive, but I’m unable to make any for test calls w/o a restart.

The database record that results from my import script looks just like a comparable one created by recording a message from my phone, so I don’t THINK it’s a data issue.

Also, I’ve been able to verify that the database does contain an actual .wav file with the correct format.

Has anyone seen this before?

Any suggestions would be welcome.

Mike Diehl.