[asterisk-users] asterisk mysql contacts

[Floimair Florian]

Yes there is.

You can follow the ODBC section in this document:

https://wiki.asterisk.org/wiki/display/AST/Setting+up+PJSIP+Realtime
 
 
With best regards

Florian Floimair
Innovation - Software-Development

COMMEND INTERNATIONAL GMBH
http://www.commend.com

Security and Communication by Commend

FN 178618z | LG Salzburg

-----Ursprüngliche Nachricht-----
Von: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-bounces at lists.digium.com] Im Auftrag von Paul Neuwirth
Gesendet: Mittwoch, 17. Januar 2018 18:42
An: John Kiniston <johnkiniston at gmail.com>
Cc: Asterisk Users Mailing List - Non-Commercial Discussion <asterisk-users at lists.digium.com>
Betreff: Re: [asterisk-users] asterisk mysql contacts

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

--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by https://linkprotect.cudasvc.com/url?a=http://www.api-digital.com&c=E,1,wvMG11IAUjITKI9-y3nyVs3P0RZJsq30__4xDz-72btjUUH7bIQSCS6WS2L7TfK4uNbT5HR1_ddQxdmzXQozIG-BkpakxNG__r6VfbMmrnn_MAxMYZHm-uXP&typo=1 --

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:
   https://linkprotect.cudasvc.com/url?a=http://lists.digium.com/mailman/listinfo/asterisk-users&c=E,1,Nw3s7x8mQWnEoAnyQapORcAM3-ksUAhgqQPgOIJ3dG1arLzQ3jW5MDlVqbrYQe_M5Km5UatyfRI1AY0WEq1l8Q6l6goT61cis4RiKxhCGUiPT8CLyPwBlf-gc3ZN&typo=1