Re: [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-boun...@lists.digium.com 
[mailto:asterisk-users-boun...@lists.digium.com] Im Auftrag von Paul Neuwirth
Gesendet: Mittwoch, 17. Januar 2018 18:42
An: John Kiniston 
Cc: Asterisk Users Mailing List - Non-Commercial Discussion 

Betreff: Re: [asterisk-users] asterisk mysql contacts

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 => s,n,Set(CALLERID(NAME)=LOOKUP_CALLERID(${CALLERID(NUM)}))
> 
> 
> On Wed, Jan 17, 2018 at 6:16 AM, Atux Atux  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=E,1,wvMG11IAUjITKI9-y3nyVs3P0RZJsq30__4xDz-72btjUUH7bIQSCS6WS2L7TfK4uNbT5HR1_ddQxdmzXQozIG-BkpakxNG__r6VfbMmrnn_MAxMYZHm-uXP=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=E,1,Nw3s7x8mQWnEoAnyQapORcAM3-ksUAhgqQPgOIJ3dG1arLzQ3jW5MDlVqbrYQe_M5Km5UatyfRI1AY0WEq1l8Q6l6goT61cis4RiKxhCGUiPT8CLyPwBlf-gc3ZN=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

Re: [asterisk-users] asterisk mysql contacts

[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 => s,n,Set(CALLERID(NAME)=LOOKUP_CALLERID(${CALLERID(NUM)}))
> 
> 
> On Wed, Jan 17, 2018 at 6:16 AM, Atux Atux  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 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

Re: [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  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

Re: [asterisk-users] asterisk mysql contacts

[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
https://www.voip-info.org/wiki/view/Asterisk+cmd+MYSQL

You might want to look into AGI plus your favorite scriptinglanguage
though.

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

[asterisk-users] asterisk mysql contacts

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

Re: [asterisk-users] queue peridiodic-announce-frequency

[Paul Neuwirth]

On Wed, 17 Jan 2018 12:08:40 +0100
Antony Stone  wrote:

> On Wednesday 17 January 2018 at 11:59:21, Paul Neuwirth wrote:
> 
> > Hello group,
> > 
> > I tried a lot to enlarge the frequency (i.e. more announces, low
> > wait between). according to config, every 30 seconds the
> > announcement should take place. In fact, the first periodic
> > announce is done after 2 minutes?
> > What is my fault?  
> 
> Config snipped for clarity...
> 
> > [defaultq]
> > timeout = 10
> > retry = 99
> > wrapuptime=15
> > maxlen = 0
> > announce-frequency = 30
> > min-announce-frequency = 30
> > periodic-announce-frequency = 30
> > announce-holdtime = yes
> > announce-position = yes
> > announce-to-first-user = yes
> > periodic-announce = tt-allbusy,hold-or-dial-0
> > reportholdtime = yes  
> 
> I believe that both timeout and retry have to be less than the
> announce intervals.
> 
> In your case, retry is set to 99, with the announce intervals set at
> 30, therefore you would get announcements at 30, 60, 90, 120, 150...
> except that retry=99 stops any announcement before 99, therefore the
> first one you get is at 120 (2 minutes).
> 
> So, try setting retry to a value not less than 30 and see if that
> fixes things.
> 
> 
> 
> Antony.
> 

thank you. working fine now. I misinterpret the retry (thought counts).
Unfortunately the documentation (comments) lack dimensions almost at
all..

Regards

Paul

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

Re: [asterisk-users] remote Asterisk console

[Daniel Tryba]

On Tue, Jan 16, 2018 at 06:19:30PM +0100, Paul Neuwirth wrote:
> Thank you both. That was (most likely) what I was looking for - but
> still some worries about sending plaintext passwords...

The AMI interface can use a Challenge-Response mechanisme for logins,
if you are this concerned you should use this even over TLS/SSL/SSH.


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

Re: [asterisk-users] queue peridiodic-announce-frequency

[Antony Stone]

On Wednesday 17 January 2018 at 11:59:21, Paul Neuwirth wrote:

> Hello group,
> 
> I tried a lot to enlarge the frequency (i.e. more announces, low wait
> between). according to config, every 30 seconds the announcement should
> take place. In fact, the first periodic announce is done after 2
> minutes?
> What is my fault?

Config snipped for clarity...

> [defaultq]
> timeout = 10
> retry = 99
> wrapuptime=15
> maxlen = 0
> announce-frequency = 30
> min-announce-frequency = 30
> periodic-announce-frequency = 30
> announce-holdtime = yes
> announce-position = yes
> announce-to-first-user = yes
> periodic-announce = tt-allbusy,hold-or-dial-0
> reportholdtime = yes

I believe that both timeout and retry have to be less than the announce 
intervals.

In your case, retry is set to 99, with the announce intervals set at 30, 
therefore you would get announcements at 30, 60, 90, 120, 150... except that 
retry=99 stops any announcement before 99, therefore the first one you get is 
at 120 (2 minutes).

So, try setting retry to a value not less than 30 and see if that fixes things.



Antony.

-- 
"It would appear we have reached the limits of what it is possible to achieve 
with computer technology, although one should be careful with such statements; 
they tend to sound pretty silly in five years."

 - John von Neumann (1949)

   Please reply to the list;
 please *don't* CC me.

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

[asterisk-users] queue peridiodic-announce-frequency

[Paul Neuwirth]

Hello group,

I tried a lot to enlarge the frequency (i.e. more announces, low wait
between). according to config, every 30 seconds the announcement should
take place. In fact, the first periodic announce is done after 2
minutes?
What is my fault?

Thank you

Regards 

Paul


# zypper if asterisk
Loading repository data...
Reading installed packages...


Information for package asterisk:
-
Repository : openSUSE_networkTelephony 
Name   : asterisk  
Version: 14.7.5-1.2
Arch   : x86_64
Vendor : obs://build.opensuse.org/network:telephony
Installed Size : 19.9 MiB  
Installed  : Yes   
Status : up-to-date
Source package : asterisk-14.7.5-1.2.src   
Summary: The Asterisk Open Source PBX


# grep -vE '^\s*;.*|^\s*$' queues.conf 
[general]
persistentmembers = yes
monitor-type = MixMonitor
[defaultq]
musicclass = default_noannounce
announce = tt-busy
strategy = ringall
context = qoutcon
timeout = 10 
retry = 99
wrapuptime=15
maxlen = 0
setinterfacevar=yes
setqueueentryvar=yes
setqueuevar=yes
announce-frequency = 30
min-announce-frequency = 30
periodic-announce-frequency = 30
announce-holdtime = yes
announce-position = yes
announce-to-first-user = yes 
periodic-announce = tt-allbusy,hold-or-dial-0
monitor-format = wav49 monitor-type = MixMonitor
reportholdtime = yes
ringinuse = yes 
member => SIP/XXW
member => SIP/XXX
member => SIP/XXY
member => SIP/XXZ
member => SIP/XXA

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