On Wed, 17 Jan 2018 09:26:28 -0700
John Kiniston <johnkinis...@gmail.com> wrote:
> use func_odbc, create a new function that does a lookup.
>
> [CALLERID]
> prefix=LOOKUP
> dsn=MyDB
> readsql=SELECT CALLERID from MyNames where CallerIdNum =
> '${SQL_ESC(${ARG1})}'
>
> exten => s,n,Set(CALLERID(NAME)=LOOKUP_CALLERID(${CALLERID(NUM)}))
>
>
> On Wed, Jan 17, 2018 at 6:16 AM, Atux Atux <atuxn...@gmail.com> wrote:
>
> > Hi. i have an asterisk 11 installation that i run in my soho
> > environment. My system has mysql to store all the cdrs.
> > I would like make use of the mysql and store numbers and names. eg
> > +4922123456789 "Atux Null". So when the +4922123456789 calls in my
> > system the name "Atux Null" will pop up next to the number.
> > at the moment i have a database called MyNames in mysql that has
> > this information, but i do not know how to make the dialplan read
> > from this database.
> > I would like to ask if there is a way to implement this easily in my
> > dialplan, please.
> >
> >
that is a good approach.. thinking over implementing this too.. and
filling the numbers using a trigger on cdr table..
is there a good manual how to set up odbc connection to mysql? I
actually never used odbc on non microscrap systems..
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
Check out the new Asterisk community forum at: https://community.asterisk.org/
New to Asterisk? Start here:
https://wiki.asterisk.org/wiki/display/AST/Getting+Started
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
