[Asterisk-Users] ChanSpy by anthm and more...

[Brian West]

No it doesn't its just a nice standalone res that allows you to use SQLite
from the dialplan, cli and as a CDR engine and sqlite_Switch.

Its great for a standalone pbx because you can do something like this:

exten => s,1,SQL(SELECT total,balance,lastpaydate FROM customers WHERE
callerid=\'${CALLERIDNUM}\')
exten => s,2,Playback(your-balance-is)
exten => s,3,SayNumber(${balance})
exten => s,4,Playback(dollars)

or something crazy like that.. It turns the first row into channel vars and
you cam use those.  This is a lot more powerful and flexible than
DBget/DBput.


Also say you want to do the same query from the CLI 

asterisk*CLI> sql use cdr
asterisk*CLI>
now using /var/lib/asterisk/sqlite/cdr.db

asterisk*CLI> select count(1) from cdr;
asterisk*CLI>

|count(1)|
|131|

Brian
Asterlink.com


> -----Original Message-----
> From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-
> bounces at lists.digium.com] On Behalf Of Kannaiyan Natesan
> Sent: Sunday, September 05, 2004 3:41 PM
> To: Asterisk Users Mailing List - Non-Commercial Discussion
> Subject: Re: [Asterisk-Users] ChanSpy by anthm and more...
> 
> Does it removes the need of external databases (mysql, postgres) or it
> will
> work with existing databases?
> 
> -Kannaiyan
> 
> 
> ----- Original Message -----
> From: "Brian West" <brian at bkw.org>
> To: "'Asterisk Users Mailing List - Non-Commercial Discussion'"
> <asterisk-users at lists.digium.com>
> Sent: Sunday, September 05, 2004 7:04 PM
> Subject: RE: [Asterisk-Users] ChanSpy by anthm and more...
> 
> 
> > http://bugs.digium.com/bug_view_page.php?bug_id=0002384
> >
> > Also res_sqlite is out... :)
> >
> > bkw
> >
> >> -----Original Message-----
> >> From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-
> >> bounces at lists.digium.com] On Behalf Of Brian West
> >> Sent: Sunday, September 05, 2004 12:57 PM
> >> To: 'Asterisk Users Mailing List - Non-Commercial Discussion'
> >> Subject: RE: [Asterisk-Users] ChanSpy by anthm and more...
> >>
> >> Also don't forget to visit us at Astricon... :)
> >>
> >> Brian
> >> Asterlink.com
> >>
> >> > -----Original Message-----
> >> > From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-
> >> > bounces at lists.digium.com] On Behalf Of Brian West
> >> > Sent: Sunday, September 05, 2004 12:26 PM
> >> > To: asterisk-users at lists.digium.com
> >> > Subject: [Asterisk-Users] ChanSpy by anthm and more...
> >> >
> >> > Everyone we have a few new things to give back to the asterisk
> >> community.
> >> >
> >> > http://bugs.digium.com/bug_view_page.php?bug_id=0002379
> >> > http://bugs.digium.com/bug_view_page.php?bug_id=0002380
> >> > http://bugs.digium.com/bug_view_page.php?bug_id=0002381
> >> >
> >> > These include app_chanspy, the ability to spy on ANY bridged call
> >> > taking
> >> > place inside asterisk.  NOT just ZAP as with ZapScan/Barge.
> >> >
> >> > Native format_* files being used for moh.  Reload enabled
> >> res_musiconhold.
> >> >
> >> > format_mp3.c that produces SLNR output to asterisk, format_slinear.c
> >> > for
> >> > raw
> >> > headerless audio, format_base65_wav_gsm.c aka wav49 held in a base64
> >> > containers(it can read and playback from these .b64 files)
> >> >
> >> > All this is thanks to my employer asterlink.com and anthm.
> >> >
> >> > So everyone please test and provide feedback.
> >> >
> >> > Thanks,
> >> > Brian
> >> > Asterlink.com
> >> > PS: More to come at a later date.
> >> >
> >> > _______________________________________________
> >> > 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
> >
> >
> 
> 
> _______________________________________________
> 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