Re: [asterisk-users] asterisk mysql contacts

2018-01-17 Thread Floimair Florian
ailing List - Non-Commercial Discussion <asterisk-users@lists.digium.com> Betreff: Re: [asterisk-users] asterisk mysql contacts 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. > > [CALL

Re: [asterisk-users] asterisk mysql contacts

2018-01-17 Thread Paul Neuwirth
On Wed, 17 Jan 2018 09:26:28 -0700 John Kiniston 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 =>

Re: [asterisk-users] asterisk mysql contacts

2018-01-17 Thread 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

Re: [asterisk-users] asterisk mysql contacts

2018-01-17 Thread Daniel Tryba
On Wed, Jan 17, 2018 at 03:16:04PM +0200, Atux Atux wrote: [asterisk dialplan mysql] > I would like to ask if there is a way to implement this easily in my > dialplan, please. The answer is: yes If you'd search for "asterisk dialplan mysql", you'get something like

[asterisk-users] asterisk mysql contacts

2018-01-17 Thread Atux Atux
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