[asterisk-users] Storing voicemail in mysql

[Al Baker]

This won't fix your problem, but it will Save you worse ones.
DON'T use ROOT as your Mysql user to do this, after you get it working, 
set up another MySQL user, and give the account as FEW privileges as 
possible.

mark morreny wrote:
> Dear friends,
>
> Asterisk's voicemail functions work fine for me, but I am having 
> difficulty storing the voice messages inside mysql.  My real-time CDR 
> recording works so I assume the odbc connection is fine. 
> The voicemail.conf I have is :
> [general]
> format = wav
> attach = yes
> dbuser=root
> dbpass=sqlpass
> dbhost=localhost
> dbname=asterisk
> odbcstorage=asterisk
> odbctable=voicemessages
>
> Asterisk shows no error message so I really don't know what's wrong 
> there. 
>
>     -- Saved useragent "wengo/v1/wengophoneng/wengo/rev12359/trunk/" 
> for peer 2001
>     -- Executing [100 at my-phones:1] VoiceMail("SIP/2001-08225788", 
> "2000") in new stack
>     -- <SIP/2001-08225788> Playing 'vm-intro' (language 'en')
>     -- ast_get_srv: SRV lookup for '_sip._udp.voipuser.org' mapped to 
> host sip.voipuser.org <http://sip.voipuser.org>, port 5060
>     -- <SIP/2001-08225788> Playing 'beep' (language 'en')
>     -- Recording the message
>     -- x=0, open writing:  
> /var/spool/asterisk/voicemail/default/2000/tmp/OayHq7 format: wav, 
> 0x821ebd0
>     -- User hung up
>
> The recording is still inside a file.
>
> Is there anyway to fix it?
>
> Thanks alot for your help.
>
> Mark
> ------------------------------------------------------------------------
>
> _______________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users