Re: [asterisk-users] asterisk-users Digest, Vol 153, Issue 28

2017-04-23 Thread bipin singh 
Install app_mysql.so after then check your dialplan .

On Sun, Apr 23, 2017 at 10:30 PM, 
wrote:

> Send asterisk-users mailing list submissions to
> asterisk-users@lists.digium.com
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://lists.digium.com/mailman/listinfo/asterisk-users
> or, via email, send a message with subject or body 'help' to
> asterisk-users-requ...@lists.digium.com
>
> You can reach the person managing the list at
> asterisk-users-ow...@lists.digium.com
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of asterisk-users digest..."
>
>
> Today's Topics:
>
>1. Re: asterisk name in mysql (Atux Atux)
>2. Re: asterisk name in mysql (Antony Stone)
>3. Re: Hack attempt sequential config file read looking for
>   valid files. (Tim S)
>
>
> --
>
> Message: 1
> Date: Sat, 22 Apr 2017 23:25:52 +0300
> From: Atux Atux 
> To: Asterisk Users Mailing List - Non-Commercial Discussion
> 
> Subject: Re: [asterisk-users] asterisk name in mysql
> Message-ID:
>  mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> Thanks a lot for the reply.
> I did follow that already, but i do have a problem. Here is my
> extensions.conf part for that particular number
> exten => 6912345678,1,Answer()
> exten => 6912345678,n,MYSQL(Connect connid 127.0.0.1 root mypasswd
> asterisk)
> exten => 6912345678,n,MYSQL(Query resultid ${connid} SET NAMES utf8)
> exten => 6912345678,n,GotoIf($["${connid}" = ""]?nodb)
> exten => 6912345678,n,MYSQL(Query resultid ${connid} SELECT displayname
> FROM root WHERE phonenumber="${CALLERID(num)}" LIMIT 1)
> exten => 6912345678,n,MYSQL(Fetch fetchid ${resultid} displayname)
> exten => 6912345678,n,MYSQL(Clear ${resultid})
> exten => 6912345678,n,Set(CALLERID(name)=${displayname})
> exten => 6912345678,n,MYSQL(Disconnect ${connid})
> exten => 6912345678,n(nodb),NoOp(DoneDB)
> exten => 6912345678,n,Dial(SIP/450/451,20)
> exten => 6912345678,n,VoiceMail(450@Office,su)
> exten => 6912345678,n,Busy(3)
>
> 6912345678 is my DID
>
>
>
> and here is the error i am getting
> [Apr 22 23:20:29] WARNING[9725][C-0002]: pbx.c:4991
> pbx_extension_helper: No application 'MYSQL' for extension (IncomingDial,
> 6951921078, 2)
>   == Spawn extension (DialIn, 6912345678, 2) exited non-zero on
> 'Dongle/dongle0-010002'
>
>
> Any ideas please?
>
>
> On Fri, Apr 21, 2017 at 10:22 PM, John Kiniston 
> wrote:
>
> > You can use func_odbc to do this.
> >
> > https://wiki.asterisk.org/wiki/display/AST/Getting+
> > Asterisk+Connected+to+MySQL+via+ODBC2
> >
> > There is a good chapter in the Asterisk book about using ODBC for
> > hotdesking that may help you understand ODBC as well.
> >
> > http://www.asteriskdocs.org/en/3rd_Edition/asterisk-book-
> > html-chunk/getting_funky.html
> >
> > On Fri, Apr 21, 2017 at 12:12 PM, Atux Atux  wrote:
> >
> >> hi. currently i am running the phonebook in astdb with
> >>
> >>
> >> *database put cidname 0123456789 "name_surname"*
> >> and i retrive it with
> >>
> >>
> >> *exten =>9876543210,1,Set(CALLERID(name)=${DB(cidname/${CALLERID(
> num)})})*
> >> Now, my system has mysql and i got all my contacts in there in a
> database
> >> is called *asterisk *and a table called *addressbook**. *password of the
> >> mysql is
> >>
> >> *whateverpasswd*
> >> how do i alter the above section of the extensions.conf code to query
> >> mysql everytime there is a call, 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/
> >
> >

[asterisk-users] Asterisk download stats

2017-04-23 Thread Dovid Bender 
Hi,

Are there any stats on where Asterisk is downloaded from based on the
country?
-- 
_
-- 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] MeetMe and dynamic_features

2017-04-23 Thread Leandro Dardini 
Hello,
I am trying to use a dynamic_features during a MeetMe conference without
any luck. The dynamic_features defined macro works great during a normal
call, but is ignored while on a MeetMe conference.

extensions.conf
[macro-RaiseHand]
exten => s,1,DumpChan(1)

features.conf
RaiseHand => #5,peer/caller,Macro(RaiseHand)

extensions.ael
Set(DYNAMIC_FEATURES=RaiseHand);
MeetMe(1234,F);

I have tried with and without the F parameter...

Any suggestion?

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