<div dir="ltr">Install app_mysql.so after then check your dialplan .<br></div><div class="gmail_extra"><br><div class="gmail_quote">On Sun, Apr 23, 2017 at 10:30 PM, <span dir="ltr"><<a href="mailto:asterisk-users-request@lists.digium.com" target="_blank">asterisk-users-request@lists.digium.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Send asterisk-users mailing list submissions to<br>
<a href="mailto:asterisk-users@lists.digium.com">asterisk-users@lists.digium.<wbr>com</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" rel="noreferrer" target="_blank">http://lists.digium.com/<wbr>mailman/listinfo/asterisk-<wbr>users</a><br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:asterisk-users-request@lists.digium.com">asterisk-users-request@lists.<wbr>digium.com</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:asterisk-users-owner@lists.digium.com">asterisk-users-owner@lists.<wbr>digium.com</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of asterisk-users digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. Re: asterisk name in mysql (Atux Atux)<br>
2. Re: asterisk name in mysql (Antony Stone)<br>
3. Re: Hack attempt sequential config file read looking for<br>
valid files. (Tim S)<br>
<br>
<br>
------------------------------<wbr>------------------------------<wbr>----------<br>
<br>
Message: 1<br>
Date: Sat, 22 Apr 2017 23:25:52 +0300<br>
From: Atux Atux <<a href="mailto:atuxnull@gmail.com">atuxnull@gmail.com</a>><br>
To: Asterisk Users Mailing List - Non-Commercial Discussion<br>
<<a href="mailto:asterisk-users@lists.digium.com">asterisk-users@lists.digium.<wbr>com</a>><br>
Subject: Re: [asterisk-users] asterisk name in mysql<br>
Message-ID:<br>
<<a href="mailto:CACoLBwUid-NOos3Qp9x3CP%2BfFmrKzk%2BQJuYXTQnnOw4BS2thaw@mail.gmail.com">CACoLBwUid-NOos3Qp9x3CP+<wbr>fFmrKzk+QJuYXTQnnOw4BS2thaw@<wbr>mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Thanks a lot for the reply.<br>
I did follow that already, but i do have a problem. Here is my<br>
extensions.conf part for that particular number<br>
exten => 6912345678,1,Answer()<br>
exten => 6912345678,n,MYSQL(Connect connid 127.0.0.1 root mypasswd asterisk)<br>
exten => 6912345678,n,MYSQL(Query resultid ${connid} SET NAMES utf8)<br>
exten => 6912345678,n,GotoIf($["${<wbr>connid}" = ""]?nodb)<br>
exten => 6912345678,n,MYSQL(Query resultid ${connid} SELECT displayname<br>
FROM root WHERE phonenumber="${CALLERID(num)}" LIMIT 1)<br>
exten => 6912345678,n,MYSQL(Fetch fetchid ${resultid} displayname)<br>
exten => 6912345678,n,MYSQL(Clear ${resultid})<br>
exten => 6912345678,n,Set(CALLERID(<wbr>name)=${displayname})<br>
exten => 6912345678,n,MYSQL(Disconnect ${connid})<br>
exten => 6912345678,n(nodb),NoOp(<wbr>DoneDB)<br>
exten => 6912345678,n,Dial(SIP/450&SIP/<wbr>451,20)<br>
exten => 6912345678,n,VoiceMail(450@<wbr>Office,su)<br>
exten => 6912345678,n,Busy(3)<br>
<br>
6912345678 is my DID<br>
<br>
<br>
<br>
and here is the error i am getting<br>
[Apr 22 23:20:29] WARNING[9725][C-00000002]: pbx.c:4991<br>
pbx_extension_helper: No application 'MYSQL' for extension (IncomingDial,<br>
6951921078, 2)<br>
== Spawn extension (DialIn, 6912345678, 2) exited non-zero on<br>
'Dongle/dongle0-0100000002'<br>
<br>
<br>
Any ideas please?<br>
<br>
<br>
On Fri, Apr 21, 2017 at 10:22 PM, John Kiniston <<a href="mailto:johnkiniston@gmail.com">johnkiniston@gmail.com</a>><br>
wrote:<br>
<br>
> You can use func_odbc to do this.<br>
><br>
> <a href="https://wiki.asterisk.org/wiki/display/AST/Getting+" rel="noreferrer" target="_blank">https://wiki.asterisk.org/<wbr>wiki/display/AST/Getting+</a><br>
> Asterisk+Connected+to+MySQL+<wbr>via+ODBC2<br>
><br>
> There is a good chapter in the Asterisk book about using ODBC for<br>
> hotdesking that may help you understand ODBC as well.<br>
><br>
> <a href="http://www.asteriskdocs.org/en/3rd_Edition/asterisk-book-" rel="noreferrer" target="_blank">http://www.asteriskdocs.org/<wbr>en/3rd_Edition/asterisk-book-</a><br>
> html-chunk/getting_funky.html<br>
><br>
> On Fri, Apr 21, 2017 at 12:12 PM, Atux Atux <<a href="mailto:atuxnull@gmail.com">atuxnull@gmail.com</a>> wrote:<br>
><br>
>> hi. currently i am running the phonebook in astdb with<br>
>><br>
>><br>
>> *database put cidname 0123456789 "name_surname"*<br>
>> and i retrive it with<br>
>><br>
>><br>
>> *exten =>9876543210,1,Set(CALLERID(<wbr>name)=${DB(cidname/${CALLERID(<wbr>num)})})*<br>
>> Now, my system has mysql and i got all my contacts in there in a database<br>
>> is called *asterisk *and a table called *addressbook**. *password of the<br>
>> mysql is<br>
>><br>
>> *whateverpasswd*<br>
>> how do i alter the above section of the extensions.conf code to query<br>
>> mysql everytime there is a call, please?<br>
>><br>
>><br>
>><br>
>> --<br>
>> ______________________________<wbr>______________________________<wbr>_________<br>
>> -- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" rel="noreferrer" target="_blank">http://www.api-digital.com</a> --<br>
>><br>
>> Check out the new Asterisk community forum at:<br>
>> <a href="https://community.asterisk.org/" rel="noreferrer" target="_blank">https://community.asterisk.<wbr>org/</a><br>
>><br>
>> New to Asterisk? Start here:<br>
>> <a href="https://wiki.asterisk.org/wiki/display/AST/Getting+Started" rel="noreferrer" target="_blank">https://wiki.asterisk.org/<wbr>wiki/display/AST/Getting+<wbr>Started</a><br>
>><br>
>> asterisk-users mailing list<br>
>> To UNSUBSCRIBE or update options visit:<br>
>> <a href="http://lists.digium.com/mailman/listinfo/asterisk-users" rel="noreferrer" target="_blank">http://lists.digium.com/<wbr>mailman/listinfo/asterisk-<wbr>users</a><br>
>><br>
><br>
><br>
><br>
> --<br>
> A human being should be able to change a diaper, plan an invasion, butcher<br>
> a hog, conn a ship, design a building, write a sonnet, balance accounts,<br>
> build a wall, set a bone, comfort the dying, take orders, give orders,<br>
> cooperate, act alone, solve equations, analyze a new problem, pitch manure,<br>
> program a computer, cook a tasty meal, fight efficiently, die gallantly.<br>
> Specialization is for insects.<br>
> ---Heinlein<br>
><br>
> --<br>
> ______________________________<wbr>______________________________<wbr>_________<br>
> -- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" rel="noreferrer" target="_blank">http://www.api-digital.com</a> --<br>
><br>
> Check out the new Asterisk community forum at: <a href="https://community.asterisk" rel="noreferrer" target="_blank">https://community.asterisk</a>.<br>
> org/<br>
><br>
> New to Asterisk? Start here:<br>
> <a href="https://wiki.asterisk.org/wiki/display/AST/Getting+Started" rel="noreferrer" target="_blank">https://wiki.asterisk.org/<wbr>wiki/display/AST/Getting+<wbr>Started</a><br>
><br>
> asterisk-users mailing list<br>
> To UNSUBSCRIBE or update options visit:<br>
> <a href="http://lists.digium.com/mailman/listinfo/asterisk-users" rel="noreferrer" target="_blank">http://lists.digium.com/<wbr>mailman/listinfo/asterisk-<wbr>users</a><br>
><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.digium.com/pipermail/asterisk-users/attachments/20170422/9a783769/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.digium.com/<wbr>pipermail/asterisk-users/<wbr>attachments/20170422/9a783769/<wbr>attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Sat, 22 Apr 2017 22:34:50 +0200<br>
From: Antony Stone <<a href="mailto:Antony.Stone@asterisk.open.source.it">Antony.Stone@asterisk.open.<wbr>source.it</a>><br>
To: "Asterisk Users Mailing List - Non-Commercial Discussion"<br>
<<a href="mailto:asterisk-users@lists.digium.com">asterisk-users@lists.digium.<wbr>com</a>><br>
Subject: Re: [asterisk-users] asterisk name in mysql<br>
Message-ID: <<a href="mailto:201704222234.50994.Antony.Stone@asterisk.open.source.it">201704222234.50994.Antony.<wbr>Stone@asterisk.open.source.it</a>><br>
Content-Type: Text/Plain; charset="iso-8859-15"<br>
<br>
On Saturday 22 April 2017 at 22:25:52, Atux Atux wrote:<br>
<br>
> Thanks a lot for the reply.<br>
> I did follow that already, but i do have a problem. Here is my<br>
> extensions.conf part for that particular number<br>
> exten => 6912345678,1,Answer()<br>
> exten => 6912345678,n,MYSQL(Connect connid 127.0.0.1 root mypasswd<br>
> asterisk)<br>
<br>
...snip...<br>
<br>
> and here is the error i am getting<br>
> [Apr 22 23:20:29] WARNING[9725][C-00000002]: pbx.c:4991<br>
> pbx_extension_helper: No application 'MYSQL' for extension (IncomingDial,<br>
> 6951921078, 2)<br>
> == Spawn extension (DialIn, 6912345678, 2) exited non-zero on<br>
> 'Dongle/dongle0-0100000002'<br>
><br>
><br>
> Any ideas please?<br>
<br>
What have you put into func_odbc.conf?<br>
<br>
ie: what's the definition of MYSQL?<br>
<br>
<br>
Antony.<br>
<br>
--<br>
Software development can be quick, high quality, or low cost.<br>
<br>
The customer gets to pick any two out of three.<br>
<br>
Please reply to the list;<br>
please *don't* CC me.<br>
<br>
<br>
<br>
------------------------------<br>
<br>
Message: 3<br>
Date: Sat, 22 Apr 2017 13:42:01 -0700<br>
From: Tim S <<a href="mailto:tim.strommen@gmail.com">tim.strommen@gmail.com</a>><br>
To: Asterisk Users Mailing List - Non-Commercial Discussion<br>
<<a href="mailto:asterisk-users@lists.digium.com">asterisk-users@lists.digium.<wbr>com</a>><br>
Subject: Re: [asterisk-users] Hack attempt sequential config file read<br>
looking for valid files.<br>
Message-ID:<br>
<<wbr>CAJv9tkzrw33JQ82VJEnp7g6X4QMv7<wbr>u8mST3ytHNAp_V=<a href="mailto:pxfDvw@mail.gmail.com">pxfDvw@mail.<wbr>gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Exactly.<br>
<br>
If one's external access control is set correctly, you should basically<br>
never see any outside attack traffic at your Asterisk box (you've see it in<br>
the firewall logs instead).<br>
<br>
Following the concept of "least privileges" is where you should start if<br>
you have Asterisk attached to a SIP service you pay for. If you have one<br>
SIP provider, the only IP address (or IP pool/range) that should talk to<br>
your Asterisk box from outside your firewall is exclusively the servers of<br>
your SIP provider. Everything else should be "dropped" (no response at<br>
all).<br>
<br>
Google "GRC Shields Up" and run that free port scanner to see what you have<br>
open, closed or what they call "stealth" (dropped). If a firewall is setup<br>
correctly, port 5060 should appear "stealth" from any IP address other than<br>
your service provider.<br>
<br>
You can also Shodan yourself: "<a href="https://www.shodan.io/host{yourPublicIP}" rel="noreferrer" target="_blank">https://www.shodan.io/host{<wbr>yourPublicIP}</a>" -<br>
but Shodan doesn't tell you whether the packets are dropped or rejected.<br>
In general you want your public IP to only show services on Shodan that you<br>
intend every random request to get access to - for example a public web<br>
server on port 80 and 443.<br>
<br>
It's a good idea to review these resources often (once a quarter, once a<br>
month, once a week - your choice), especially after any software or<br>
hardware changes on your network. You may find something has been<br>
misconfigured at installation, that you would need to address.<br>
<br>
Best<br>
<br>
-Tim<br>
<br>
On Fri, Apr 21, 2017 at 9:53 AM, Victor Villarreal <<a href="mailto:mefhigoseth@gmail.com">mefhigoseth@gmail.com</a>><br>
wrote:<br>
<br>
> Hi David, Tim,<br>
><br>
> Try to use Bail2Ban at last resort. Fail2Ban is a ractive approach, that<br>
> permit the traffinc AND ONLY BLOCK them after certain level triggered.<br>
><br>
><br>
> Use iptables to block the unused services faced to public networks like<br>
> Internet. And configure these services properly, so they listen only<br>
> selected interfaces and IPs, and not from 0.0.0.0<br>
><br>
> 2017-04-21 13:47 GMT-03:00 Tim S <<a href="mailto:tim.strommen@gmail.com">tim.strommen@gmail.com</a>>:<br>
><br>
>> Is that IP in your network or outside (I can ping it so I'm guessing it's<br>
>> outside your network)? Do you have a firewall between your asterisk box<br>
>> and the internet? Is there a WHITELIST of IP addresses that only allow<br>
>> your provider's limited IP pool to connect to your asterisk box from<br>
>> outside?<br>
>><br>
>> If you are getting TFTP requests hitting your Asterisk box, they are not<br>
>> properly being filtered at your firewall - ftp and tftp are considered<br>
>> insecure communication methods, that port (69 I think) should be closed on<br>
>> your firewall unless you have a really good reason to have it opened (and<br>
>> unless you run a public FTP site, THERE IS NO GOOD REASON).<br>
>><br>
>> Fail2Ban is a BLACKLIST method, blacklists are most effective after good<br>
>> network hygiene is implemented, as you drastically limit the pool of<br>
>> potential bad actors with a whitelist.<br>
>><br>
>> Best,<br>
>><br>
>> -Tim<br>
>><br>
>> On Fri, Apr 21, 2017 at 9:38 AM, Dovid Bender <<a href="mailto:dovid@telecurve.com">dovid@telecurve.com</a>><br>
>> wrote:<br>
>><br>
>>> This is old news. They use Shodan and then try to connect. Set up<br>
>>> Fail2Ban that say after 10 404's to ban the IP.<br>
>>><br>
>>><br>
>>> On Fri, Apr 21, 2017 at 12:27 PM, Jerry Geis <<a href="mailto:jerry.geis@gmail.com">jerry.geis@gmail.com</a>><br>
>>> wrote:<br>
>>><br>
>>>> I "justed" happened to look at /var/log/messages...<br>
>>>><br>
>>>> I saw:<br>
>>>> Apr 21 12:18:40 in.tftpd[22719]: RRQ from 69.64.57.18 filename<br>
>>>> 0004f2034f6b.cfg<br>
>>>> Apr 21 12:18:40 in.tftpd[22719]: Client 69.64.57.18 File not found<br>
>>>> 0004f2034f6b.cfg<br>
>>>> Apr 21 12:18:40 in.tftpd[22720]: RRQ from 69.64.57.18 filename<br>
>>>> 0004f2034f6c.cfg<br>
>>>> Apr 21 12:18:40 in.tftpd[22720]: Client 69.64.57.18 File not found<br>
>>>> 0004f2034f6c.cfg<br>
>>>> Apr 21 12:18:40 in.tftpd[22721]: RRQ from 69.64.57.18 filename<br>
>>>> 0004f2034f6d.cfg<br>
>>>> Apr 21 12:18:40 in.tftpd[22721]: Client 69.64.57.18 File not found<br>
>>>> 0004f2034f6d.cfg<br>
>>>> Apr 21 12:18:40 in.tftpd[22722]: RRQ from 69.64.57.18 filename<br>
>>>> 0004f2034f6e.cfg<br>
>>>><br>
>>>> so basically an sequential read of polycom MAC address config files.<br>
>>>> Some is trying to read to determine if I have any polycom files just<br>
>>>> sequential read after read.<br>
>>>> And if so - it would get any extension and password at that time.<br>
>>>> Luckily I have none.<br>
>>>><br>
>>>> However - how does one block attempts like this ?<br>
>>>><br>
>>>> Thanks!<br>
>>>><br>
>>>> Jerry<br>
>>>><br>
>>>> --<br>
>>>> ______________________________<wbr>______________________________<wbr>_________<br>
>>>> -- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" rel="noreferrer" target="_blank">http://www.api-digital.com</a> --<br>
>>>><br>
>>>> Check out the new Asterisk community forum at:<br>
>>>> <a href="https://community.asterisk.org/" rel="noreferrer" target="_blank">https://community.asterisk.<wbr>org/</a><br>
>>>><br>
>>>> New to Asterisk? Start here:<br>
>>>> <a href="https://wiki.asterisk.org/wiki/display/AST/Getting+Started" rel="noreferrer" target="_blank">https://wiki.asterisk.org/<wbr>wiki/display/AST/Getting+<wbr>Started</a><br>
>>>><br>
>>>> asterisk-users mailing list<br>
>>>> To UNSUBSCRIBE or update options visit:<br>
>>>> <a href="http://lists.digium.com/mailman/listinfo/asterisk-users" rel="noreferrer" target="_blank">http://lists.digium.com/<wbr>mailman/listinfo/asterisk-<wbr>users</a><br>
>>>><br>
>>><br>
>>><br>
>>> --<br>
>>> ______________________________<wbr>______________________________<wbr>_________<br>
>>> -- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" rel="noreferrer" target="_blank">http://www.api-digital.com</a> --<br>
>>><br>
>>> Check out the new Asterisk community forum at:<br>
>>> <a href="https://community.asterisk.org/" rel="noreferrer" target="_blank">https://community.asterisk.<wbr>org/</a><br>
>>><br>
>>> New to Asterisk? Start here:<br>
>>> <a href="https://wiki.asterisk.org/wiki/display/AST/Getting+Started" rel="noreferrer" target="_blank">https://wiki.asterisk.org/<wbr>wiki/display/AST/Getting+<wbr>Started</a><br>
>>><br>
>>> asterisk-users mailing list<br>
>>> To UNSUBSCRIBE or update options visit:<br>
>>> <a href="http://lists.digium.com/mailman/listinfo/asterisk-users" rel="noreferrer" target="_blank">http://lists.digium.com/<wbr>mailman/listinfo/asterisk-<wbr>users</a><br>
>>><br>
>><br>
>><br>
>> --<br>
>> ______________________________<wbr>______________________________<wbr>_________<br>
>> -- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" rel="noreferrer" target="_blank">http://www.api-digital.com</a> --<br>
>><br>
>> Check out the new Asterisk community forum at:<br>
>> <a href="https://community.asterisk.org/" rel="noreferrer" target="_blank">https://community.asterisk.<wbr>org/</a><br>
>><br>
>> New to Asterisk? Start here:<br>
>> <a href="https://wiki.asterisk.org/wiki/display/AST/Getting+Started" rel="noreferrer" target="_blank">https://wiki.asterisk.org/<wbr>wiki/display/AST/Getting+<wbr>Started</a><br>
>><br>
>> asterisk-users mailing list<br>
>> To UNSUBSCRIBE or update options visit:<br>
>> <a href="http://lists.digium.com/mailman/listinfo/asterisk-users" rel="noreferrer" target="_blank">http://lists.digium.com/<wbr>mailman/listinfo/asterisk-<wbr>users</a><br>
>><br>
><br>
><br>
><br>
> --<br>
> GnuPG Key ID: 0x39BCA9D8<br>
> <a href="https://www.github.com/mefhigoseth" rel="noreferrer" target="_blank">https://www.github.com/<wbr>mefhigoseth</a><br>
> ...:::[ God Rulz ! ]:::...<br>
><br>
> --<br>
> ______________________________<wbr>______________________________<wbr>_________<br>
> -- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" rel="noreferrer" target="_blank">http://www.api-digital.com</a> --<br>
><br>
> Check out the new Asterisk community forum at: <a href="https://community.asterisk" rel="noreferrer" target="_blank">https://community.asterisk</a>.<br>
> org/<br>
><br>
> New to Asterisk? Start here:<br>
> <a href="https://wiki.asterisk.org/wiki/display/AST/Getting+Started" rel="noreferrer" target="_blank">https://wiki.asterisk.org/<wbr>wiki/display/AST/Getting+<wbr>Started</a><br>
><br>
> asterisk-users mailing list<br>
> To UNSUBSCRIBE or update options visit:<br>
> <a href="http://lists.digium.com/mailman/listinfo/asterisk-users" rel="noreferrer" target="_blank">http://lists.digium.com/<wbr>mailman/listinfo/asterisk-<wbr>users</a><br>
><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.digium.com/pipermail/asterisk-users/attachments/20170422/3c6361ea/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.digium.com/<wbr>pipermail/asterisk-users/<wbr>attachments/20170422/3c6361ea/<wbr>attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
______________________________<wbr>_________________<br>
--Bandwidth and Colocation Provided by <a href="http://www.api-digital.com--" rel="noreferrer" target="_blank">http://www.api-digital.com--</a><br>
<br>
Check out the new Asterisk community forum at: <a href="https://community.asterisk.org/" rel="noreferrer" target="_blank">https://community.asterisk.<wbr>org/</a><br>
<br>
New to Asterisk? Start here:<br>
<a href="https://wiki.asterisk.org/wiki/display/AST/Getting+Started" rel="noreferrer" target="_blank">https://wiki.asterisk.org/<wbr>wiki/display/AST/Getting+<wbr>Started</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" rel="noreferrer" target="_blank">http://lists.digium.com/<wbr>mailman/listinfo/asterisk-<wbr>users</a><br>
<br>
End of asterisk-users Digest, Vol 153, Issue 28<br>
******************************<wbr>*****************<br>
</blockquote></div><br></div>