[Asterisk-Users] ast_data does not patch

[beonice]

Lonnie, 

If you look at:

http://www.voip-info.org/wiki-Asterisk+RealTime

it says that MySQL _is_ supported.

I don't know whether RealTime PostgreSQL, but I can't
upgrade to RealTime anyway ... I need a stable version
of asterisk, and the current stable version does not
include RealTime. :(

I am hoping to be able to use MySQL as well ... I've
got all the config files set up correctly, I believe,
but I get nowhere because:
  a) ast_data seems to be currently broken
  b) the shipped version of asterisk app_voicemail.c
seems to have a bug in its select statement ...
MySQL's log shows that it's connecting correctly to
the database, but then it issues a command "SEL"
instead of the command "SELECT * from users WHERE ..."

Very frustrating. I don't really want to debug this
code, but it looks like I'm going to give it a shot
anyway. (No, not the ast_data code, the basic
app_voicemail.c code.)

Lonnie, if you have any luck getting ast_data to work,
or find a contact address for rgagnon (who seems to
have done the original development and presumably is
still maintaining it), please forward that to me.

Cheers,
Maya

--- lonnie at outstep.com wrote:

> Thanks....
> 
> I'll look into it, but from the little that I read
> on RealTime, I was
> under the impression that it did not use MySQL or
> PostgreSQL which is a
> database feature that I was hoping to use.
> 
> --Lonnie
> 
> 
> > Why not just use the built-in database features to
> do what you want? Its
> > called RealTime. Lots of info on it on the wiki.
> >
> > -Matthew
> >
> > ----- Original Message -----
> > From: <lonnie at outstep.com>
> > To: "'Asterisk Users Mailing List - Non-Commercial
> Discussion'"
> > <asterisk-users at lists.digium.com>
> > Sent: Saturday, February 12, 2005 4:56 PM
> > Subject: [Asterisk-Users] ast_data does not patch
> >
> >
> >> Hello all,
> >>
> >> I have just been trying to install the latest
> ast_data from:
> >>
> >> http://svn.asteriskdocs.org/res_data/ast_data/
> >>
> >> into my cvs version of Asterisk and have found
> that the install patching
> >> fails.
> >> ---------------------------------------------
> >>
> >> patching file contrib/scripts/sip-friends.sql
> >> patching file contrib/scripts/iax-friends.sql
> >> patching file apps/app_voicemail.c
> >> patching file apps/app_directory.c
> >> patching file channels/chan_sip.c
> >> Hunk #2 succeeded at 621 (offset 9 lines).
> >> Hunk #3 FAILED at 1480.
> >> Hunk #4 succeeded at 1549 (offset 11 lines).
> >> Hunk #5 succeeded at 1617 (offset 18 lines).
> >> Hunk #6 succeeded at 1972 (offset 11 lines).
> >> 1 out of 6 hunks FAILED -- saving rejects to file
> >> channels/chan_sip.c.rej
> >> patching file channels/chan_iax2.c
> >> Hunk #2 succeeded at 593 with fuzz 2 (offset 13
> lines).
> >> Hunk #3 FAILED at 944.
> >> Hunk #4 succeeded at 4441 (offset 57 lines).
> >> Hunk #5 FAILED at 5234.
> >> 2 out of 5 hunks FAILED -- saving rejects to file
> >> channels/chan_iax2.c.rej
> >> patching file Makefile
> >> patching file pbx.c
> >> Hunk #6 succeeded at 1390 (offset 18 lines).
> >> Hunk #8 succeeded at 1439 (offset 18 lines).
> >> Hunk #10 succeeded at 1508 (offset 18 lines).
> >> patching file asterisk.c
> >> Hunk #2 succeeded at 1922 (offset 76 lines).
> >>
> >> ----------------------------------------------
> >>
> >> Does anyone know how to get in touch with the
> developer or have another
> >> viable and working option that will allow me to
> dynamically place my
> >> users
> >> information in a MySQL database?
> >>
> >> Thanks,
> >> Lonnie
> >>
> >>
> >> _______________________________________________
> >> Asterisk-Users mailing list
> >> Asterisk-Users at lists.digium.com
> >>
>
http://lists.digium.com/mailman/listinfo/asterisk-users
> >> To UNSUBSCRIBE or update options visit:
> >>   
>
http://lists.digium.com/mailman/listinfo/asterisk-users
> >>
> >
> > _______________________________________________
> > Asterisk-Users mailing list
> > Asterisk-Users at lists.digium.com
> >
>
http://lists.digium.com/mailman/listinfo/asterisk-users
> > To UNSUBSCRIBE or update options visit:
> >   
>
http://lists.digium.com/mailman/listinfo/asterisk-users
> >
> 
> 
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
>
http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>   
>
http://lists.digium.com/mailman/listinfo/asterisk-users
> 



		
__________________________________ 
Do you Yahoo!? 
Yahoo! Mail - Find what you need with new enhanced search.
http://info.mail.yahoo.com/mail_250