[asterisk-users] asterisk mysql contacts

[Paul Neuwirth]

On Wed, 17 Jan 2018 09:26:28 -0700
John Kiniston <johnkiniston at 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 <atuxnull at 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..