[asterisk-users] asterisk mysql contacts

[John Kiniston]

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.
>
>
> --
> _____________________________________________________________________
> -- 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
>



-- 
A human being should be able to change a diaper, plan an invasion, butcher
a hog, conn a ship, design a building, write a sonnet, balance accounts,
build a wall, set a bone, comfort the dying, take orders, give orders,
cooperate, act alone, solve equations, analyze a new problem, pitch manure,
program a computer, cook a tasty meal, fight efficiently, die gallantly.
Specialization is for insects.
---Heinlein
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20180117/7f8258ea/attachment.html>