[Asterisk-Users] ODBC Problem with voicemail.

[Omar belakhdar]

I've installed the last released asterisk 1.2.2 on my own HLFS system
with a 2.6.14.3 kernel. I've also a 2 FXO/ 1 FXS digium card on it.
Every thing is working correctly.

For ODBC, I'm using UnixODBC with pgsql. The voice messages are
correctly written  to the database and also their number is correctly
reported by VoicemailMain dialogue.

However, after reading the time/day of the new message, the system
hangup without playing the message and automatically reports that it
"couldn't open /var/spool/.../msg0000.WAV, from the file.c
(ast_filehelper) and "Unable to open /var/.../msg0000" from the file.c
(ast_streamfile) methods.

After some dubbeguing (I've a sptripped system, I don't have access to
all symbols), it seems like the temporary files are not created at all
and the open method (in retieve_file method) return always -1 which
prevent from creating the file of the message. The directory is writable
for the asterisk user but not for the group. Even the description file
of the message is created correctly as I've seen.

My question is: does asterisk create the file even if the message is
empty or not? If it doesn't so the problem could come from the ODBC part
as asterisk is not able to read the data even if message is correctly
recorded in the database.

The message is reported as read and thus becomes old. I checked that
from the code and this happens from the playing_message method as expected.

Is there any people in the list who encoutered similar problems?

Many thanks.

Omar.