Yes, I will definitely change to use a normal DB user other than root. In the meanwhile, could someone please help me out? How can I fix this problem so my voice messages can be stored in DB?<br><br>Thanks,<br>Mark<br><br>
<div class="gmail_quote">On Mon, Mar 24, 2008 at 2:29 AM, Al Baker <<a href="mailto:bwentdg@pipeline.com">bwentdg@pipeline.com</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
This won't fix your problem, but it will Save you worse ones.<br>
DON'T use ROOT as your Mysql user to do this, after you get it working,<br>
set up another MySQL user, and give the account as FEW privileges as<br>
possible.<br>
<div class="Ih2E3d"><br>
mark morreny wrote:<br>
> Dear friends,<br>
><br>
> Asterisk's voicemail functions work fine for me, but I am having<br>
> difficulty storing the voice messages inside mysql. My real-time CDR<br>
> recording works so I assume the odbc connection is fine.<br>
> The voicemail.conf I have is :<br>
> [general]<br>
> format = wav<br>
> attach = yes<br>
> dbuser=root<br>
> dbpass=sqlpass<br>
> dbhost=localhost<br>
> dbname=asterisk<br>
> odbcstorage=asterisk<br>
> odbctable=voicemessages<br>
><br>
> Asterisk shows no error message so I really don't know what's wrong<br>
> there.<br>
><br>
> -- Saved useragent "wengo/v1/wengophoneng/wengo/rev12359/trunk/"<br>
> for peer 2001<br>
> -- Executing [100@my-phones:1] VoiceMail("SIP/2001-08225788",<br>
> "2000") in new stack<br>
> -- <SIP/2001-08225788> Playing 'vm-intro' (language 'en')<br>
> -- ast_get_srv: SRV lookup for '_sip._udp.voipuser.org' mapped to<br>
</div>> host <a href="http://sip.voipuser.org" target="_blank">sip.voipuser.org</a> <<a href="http://sip.voipuser.org" target="_blank">http://sip.voipuser.org</a>>, port 5060<br>
<div class="Ih2E3d">> -- <SIP/2001-08225788> Playing 'beep' (language 'en')<br>
> -- Recording the message<br>
> -- x=0, open writing:<br>
> /var/spool/asterisk/voicemail/default/2000/tmp/OayHq7 format: wav,<br>
> 0x821ebd0<br>
> -- User hung up<br>
><br>
> The recording is still inside a file.<br>
><br>
> Is there anyway to fix it?<br>
><br>
> Thanks alot for your help.<br>
><br>
> Mark<br>
</div>> ------------------------------------------------------------------------<br>
><br>
> _______________________________________________<br>
> -- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
><br>
> asterisk-users mailing list<br>
> To UNSUBSCRIBE or update options visit:<br>
> <a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br>
<br>
_______________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br>
</blockquote></div><br>