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: [email protected] [mailto:[email protected]] Im Auftrag von Paul Neuwirth Gesendet: Mittwoch, 17. Januar 2018 18:42 An: John Kiniston <[email protected]> Cc: Asterisk Users Mailing List - Non-Commercial Discussion <[email protected]> Betreff: Re: [asterisk-users] asterisk mysql contacts On Wed, 17 Jan 2018 09:26:28 -0700 John Kiniston <[email protected]> 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 <[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. > > > > 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 -- _____________________________________________________________________ -- 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
