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 <[email protected]> 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
--
_____________________________________________________________________
-- 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
