[asterisk-users] Storing voicemail in mysql

[mark morreny]

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?

Thanks,
Mark

On Mon, Mar 24, 2008 at 2:29 AM, Al Baker <bwentdg at pipeline.com> wrote:

> 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
>
> _______________________________________________
> -- 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20080325/997a44b2/attachment.htm