Novembre: 2019
L	M	M	G	V	S	D
« Ott
	1	2	3
4	5	6	7	8	9	10
11	12	13	14	15	16	17
18	19	20	21	22	23	24
25	26	27	28	29	30

Articoli nella categoria News

HwGroup SMS-GW3

Ott 04, 2019 ~ Scritto da paolo

Links:
https://www.hw-group.com/support/how-to-send-sms-via-hwg-sms-gw3
https://www.hw-group.com/accessory/sms-gw3

Methods of sending text messages:

Using netGSM (SOAP – HTTP POST)
Uploading a XML file using cURL
Uploading a XML file using PHP
Sending a SMS from Nagios
Using HTTP GET
Sending a SMS from Nagios
Sending a SMS using Wget
Sending a SMS using cURL
Sending a SMS from PRTG
Using the SNMP Write function

Sending text messages using the netGSM protocol

The netGSM protocol is based on SOAP; that is, sending a XML file using HTTP POST. For a description of the netGSM protocol, see: http://hw-group.us/product-version/netgsm

In a nutshell, HTTP POST is used to send a XML file (service.xml) with the following structure:

GsmOut

SMS
123456789
Hello World!

For a description of individual parameters, see the above-mentioned protocol description.
Uploading a XML file using cURL

cURL is a command-line tool to transfer data using protocols such as HTTP, FTP and more. cURL consists of two parts – the curl.exe console application, and the libcurl.dll library that implements all the curl functions.

The library can be used for writing your own scripts (bindings are available for many languages).

cURL is available free of charge at https://curl.haxx.se/ (https://curl.haxx.se/download.html) however, attention must be paid to choose the correct version to download.

The 32-bit version will not work in a 64-bit Windows environment, even though it starts OK!

cURL is started from the command line with the following command:

curl -X POST -T service.xml 192.168.100.169

where

-X defines the transfer method, in this case POST
-T specifies that a file is uploaded and what is its name (the file must be in the same folder as the curl.exe utility; otherwise, the path must be given)
IP address is the address of HWg-SMS-GW3

If the HWg-SMS-GW3 is secured with a username and a password, the credentials must be specified with the -u parameter:

curl -X POST -T service.xml -u user:pass 192.168.100.169

The response is:

C:\Users\volmr\Desktop\curl>curl -X POST -T service.xml -u user:pass 192.168.100.169
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
0 375 0 0 0 0 0 0 –:–:– 0:00:01 –:–:– 0

1
169

100 667 100 292 100 375 292 375 0:00:01 0:00:01 –:–:– 657

C:\Users\volmr\Desktop\curl>

Uploading a XML file using PHP

PHP is one of the most popular open source web scripting language. Sending a SMS from your own website is very simple; an example script follows:

GsmOut

“.$type.”
“.$nmr.”
“.$text.”

“;

$fp = @fsockopen($host, $port, $errno, $errstr, 30);
if (!$fp) {
echo “$host:$port: $errstr ($errno)\r\n”;
}
else {
fwrite($fp, “POST /service.xml HTTP/1.0\r\n”);
fwrite($fp, “User-Agent: MyPHPTest\r\n”);
fwrite($fp, sprintf(“Host: %s\r\n”, $host));
fwrite($fp, sprintf(“Authorization: Basic %s\r\n”, base64_encode($user . “:” . $pass)));
fwrite($fp, sprintf(“Content-Length: %d\r\n\r\n”, strlen($xml)));

fwrite($fp, $xml);
while (!feof($fp)) {
echo fgets($fp, 128);
}
fclose($fp);
}

Simply fill out the address, username and password for your HWg-SMS-GW3 and everything works right away. The $type, $nmr and $text variables can be of course passed from other scripts.
Sending a SMS from Nagios

Nagios uses scripts written in Perl. The Netways company from Germany has provided the notify-poseidon-sms.pl script that can send up to 160 characters with this command:

./notify-poseidon-sms.pl -H 192.0.2.10 -M “Test message” -D 123456789

where:
-H – (Host) IP address of HWg-SMS-GW3
-M – (Message) message text
-D – (Destination) recipient’s telephone number

A limitation is that the script can only send SMS and cannot ring the recipient’s phone number; however, this can be easily changed, see e.g. notify-poseidon-call.pl (see the attachments). Also, it does not support http authentication.

Example of use in Windows:

C:\Users\volmr\Desktop\curl>perl notify-poseidon-sms.pl -H 192.168.100.169 -M “Hello World!” -D 777232759
OK, message sent with ID 1 to ‘777232759’

C:\Users\volmr\Desktop\curl>

Sending text messages using HTTP GET

HTTP GET is a method where all parameters are passed directly in the URL. This method is often used for simple applications because it allows for simple debugging and is easy to code. One simply invokes the address with the necessary parameters:

values.xml?Cmd=SMS&Nmr=00420123456789&Text=Hello World!

where:
Values.xml – file in the GW that the command should process. It is either values.xml or service.xml
Cmd – command that instructs what the GW should do: SMS – send a text message, CALL – ring the number
Nmr – phone number in national or international format. It is recommended to use 00 instead of the “+” sign so that there is no need to replace the “+” with an entity
Text – message text encoded in UTF-8

A disadvantage is that the HTTP GET method, natively used to display WWW pages, is difficult to secure against misuse (one would need to set WWW Security, which then prevents unrestricted browsing of the HWg-SMS-GW3 web interface).

And even then, the login credentials are sent in the URL in the open:

http://user:pass@192.168.1.1/values.xml?Cmd=SMS&Nmr=777232759&Text=Hello 20World!

For these reasons, the sending of messages via HTTP GET is disabled by default, and must be manually enabled at the GSM Modem tab if it is needed:

Sending a SMS from a web browser

Enter the URL of HWg-SMS-GW3 including the requested commands into the address field of the web browser:

http://192.168.100.169/values.xml?Cmd=SMS&Nmr=777232759&Text=Hello World!

After sending, a XML confirmation appears:

1
2

Sending SMS using Wget

GNU Wget is a command-line utility that serves as a simple but powerful http client. It implements file transfer over HTTP, HTTPS and FTP protocols. It is available at https://www.gnu.org/software/wget/ and Windows versions are available at http://gnuwin32.sourceforge.net/packages/wget.htm

Wget is very simple to use – simply enter the same command that would be entered in the browser address field. However, the entire URL must be enclosed in double quotes:

wget “http://192.168.100.169/values.xml?Cmd=SMS&Nmr=777232759&Text=Hello World!”

The result looks like this:

C:\Users\volmr\Desktop\wget>wget “http://192.168.100.169/values.xml?Cmd=SMS&Nmr=777232759&Text=Hello World!”
–2017-12-28 15:56:35– http://192.168.100.169/values.xml?Cmd=SMS&Nmr=777232759&Text=Hello%20World!
Connecting to 192.168.100.169:80… connected.
HTTP request sent, awaiting response… 200 Ok
Length: unspecified [text/xml]
Saving to: ‘values.xml@Cmd=SMS&Nmr=777232759&Text=Hello%20World!.1’

values.xml@Cmd=SMS&Nmr=777232 [ <=> ] 118 –.-KB/s in 0s

2017-12-28 15:56:35 (5.48 MB/s) – ‘values.xml@Cmd=SMS&Nmr=777232759&Text=Hello%20World!.1’ saved [118]

C:\Users\volmr\Desktop\wget>

Sending SMS using cURL

The cURL utility is used in the same way as the wget utility. This is the command:

curl “http://192.168.100.169/values.xml?Cmd=SMS&Nmr=777232759&Text=Hello World!”

And this is the application’s response:

C:\Users\volmr\Desktop\curl>curl “http://192.168.100.169/values.xml?Cmd=SMS&Nmr=777232759&Text=Hello World!”

1
4

C:\Users\volmr\Desktop\curl>

Of course, the main result is that the message is sent.
Sending a SMS from PRTG

PRTG Network Monitor is a complex network monitoring solution that combines Paessler’s expertise with a complete set of monitoring functions, intuitive and easy-to-use UI and the most advanced monitoring tool suitable for all types of networks.

PRTG Network Monitor can send text messages using the HTTP GET method. The setting up only involves specifying a URL for sending the messages.

This is done with the Enterprise Console (application or WWW interface) in Setup > System Administration > Notification Delivery. The Custom URL field should contain:

http://IP_adresa/values.xml?Cmd=SMS&Nmr=%SMSNUMBER&Text=%SMSTEXT

This ensures that the SMSNUMBER and SMSTEXT system variables are inserted at the correct places in the URL.

PRTG currently does not support security using username and password!

Sending a SMS using the SNMP Write function (snmpset)

Starting from firmware version 1.1.3, HWg-SMS-GW3 supports the sending of SMS and dialing of numbers using SNMP. SNMP write, or more exactly SNMP SET function, is used for that purpose.

However, it is necessary to write all the 3 required OIDs for the recipient’s number, message text and function (SMS/ring/SMS+ring). The OIDs are the following:

msgQueueNmr (OID .1.3.6.1.4.1.21796.4.10.2.2.0) – (mandatory) Recipient’s phone number in national or international format. The international format can use either “+” or “00”.
msgQueueCmd (OID .1.3.6.1.4.1.21796.4.10.2.3.0) – (mandatory) Action: 1=sms, 2=ring, 3=sms+ring
msgQueueText (OID .1.3.6.1.4.1.21796.4.10.2.1.0) – (mandatory) Message text. Can be omitted if the requested action is ring only.

In a concrete example, the individual commands could look like this:

snmpset -v 1 -c private 192.168.100.169 1.3.6.1.4.1.21796.4.10.2.2.0 i: 777232759
snmpset -v 1 -c private 192.168.100.169 1.3.6.1.4.1.21796.4.10.2.1.0 s “Hello World!”
snmpset -v 1 -c private 192.168.100.169 1.3.6.1.4.1.21796.4.10.2.3.0 i: 1

When the commands are entered in the command line, the following appears:

C:\usr\bin>snmpset -v 1 -c private 192.168.100.169 1.3.6.1.4.1.21796.4.10.2.2.0 i: 777232759
SNMPv2-SMI::enterprises.21796.4.10.2.2.0 = INTEGER: 777232759

C:\usr\bin>snmpset -v 1 -c private 192.168.100.169 1.3.6.1.4.1.21796.4.10.2.1.0 s “Hello World!”
SNMPv2-SMI::enterprises.21796.4.10.2.1.0 = STRING: “Hello World!”

C:\usr\bin>snmpset -v 1 -c private 192.168.100.169 1.3.6.1.4.1.21796.4.10.2.3.0 i: 1
SNMPv2-SMI::enterprises.21796.4.10.2.3.0 = INTEGER: 1

C:\usr\bin>

The command to ring the number then looks like this:

snmpset -v 1 -c private 192.168.100.169 1.3.6.1.4.1.21796.4.10.2.2.0 i: 777232759
snmpset -v 1 -c private 192.168.100.169 1.3.6.1.4.1.21796.4.10.2.3.0 i: 2

and the response:

C:\usr\bin>snmpset -v 1 -c private 192.168.100.169 1.3.6.1.4.1.21796.4.10.2.2.0 i: 777232759
SNMPv2-SMI::enterprises.21796.4.10.2.2.0 = INTEGER: 777232759

C:\usr\bin>snmpset -v 1 -c private 192.168.100.169 1.3.6.1.4.1.21796.4.10.2.3.0 i: 2
SNMPv2-SMI::enterprises.21796.4.10.2.3.0 = INTEGER: 2

C:\usr\bin>

con tag hwgroup, linux, php, script, sms, windows, zabbix

How to use PDO with PHP and MySQL

Lug 06, 2019 ~ Scritto da paolo

$db = new PDO('mysql:host=localhost;dbname=mydb;', 'username', 'password');

$q="select my query";
$db->query($q);

con tag mysql, pdo, php, query

How to use fgetcsv in PHP

Giu 06, 2019 ~ Scritto da paolo

$i=0;
if (($handle = fopen("myfile.csv", "r")) !== FALSE) {
    while (($cells = fgetcsv($handle, 1000, ",")) !== FALSE) {
        if ($i==0){// header 

        }else{ //content
                 
        }
        $i++;
    }
    fclose($handle);
}

con tag csv, php, script

VSFTPD Error 500 OOPS

Ago 08, 2018 ~ Scritto da paolo

insert
allow_writeable_chroot=YES

into:
/etc/vsftpd/vsftpd.conf

Execute a PHP script from another PHP script

Mar 13, 2018 ~ Scritto da paolo

hello.php

Command line: php hello.php

include('hello.php');

$output = shell_exec('php hello.php');

$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, "http://www.myDomain.com/hello.php");
curl_setopt($ch, CURLOPT_HEADER, 0);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true)

$output = curl_exec($ch);
curl_close($ch);
echo $output;

con tag php, script

il 75% delle app per Android tracciano l’utente

Dic 20, 2017 ~ Scritto da paolo

https://www.techrepublic.com/article/over-75-of-android-apps-are-secretly-tracking-users/

con tag android, linux, mobile, phones

Best Exchange ActiveSync Mail Apps for AndroidForWork

Ago 01, 2017 ~ Scritto da paolo

Today we’ll talk about Exchange ActiveSync Mail Apps for AndroidForWork environment.

In my company we use Blackberry UEM 12.6 as MDM platfrom; with the new functionalities of Android For Work we can enable only some apps for the Play Store and block all the other ones.

As Mail apps we tested Blackberry Hub, Outlook by Microsoft, BlueMail by Blue Mail Inc, Email Exchange by MailWise and Vmware Boxer on mainly Samsung S7 devices.

Here some considerations and at the end the definitive choice.

Blackberry Hub

PROS:

Good integration with the UEM Environment
Good Support for Exchange/ActiveSync
Receive settings and configurations from UEM

CONS:

not working with hybrid configuration of Exchange and office 365
Free only for 30 days and purchasable only by single user, not via B2B channel

Outlook

PROS:

Very good support of Exchange and Office 365 connections; quick, clean and essential app.
completely free and without advertising

CONS:

no integration with the system calendar and partially with the address book (in-app option to sync contacts but a lot of problems for searching into Company Exchange Global Address List)
No week-view into integrated Calendar
Very slow sync for mail and calendar events (even 30 minutes late!!)

BlueMail

PROS:

Good support of Exchange and Office365 (but only with thirdy-part provided ActiveSync component)
Perfect sync with the company GAL
Perfect sync with the Calendar
Completely free and without advertising

CONS:

Without the default Android e-mail client and without another app that wake up the ActiveSync feature BlueMail cannot manage ActiveSync accounts.

VmWare Boxer

PROS:

Good support of Exchange and Office365
Perfect sync with the company GAL
Perfect sync with the Calendar
Completely free and without advertising

CONS:

some minor features outlook-desktop style are missing

MailWise

PROS:

Good support of Exchange and Office365
Perfect sync with the company GAL
Perfect sync with the Calendar

CONS:

the free version of the app requests upgrade to pro version for 2.99$.

Conclusion

At the end of the tests we decided to use VmWare Boxer as default mail/calendar/address book client for Android because of the limits and lacks of the other apps.

In the future we hope that Blackberry could resolve the license issues and the office 365 (also in hybrid configuration) support for its Android suite apps because this could effort security, limitations and control on the users accounts.

con tag android, androidforwork, apps, bluemail, boxer, hub, mail, mailwise, mdm, outlook, vmware

Crack password on an Excel VBA Project

Lug 03, 2017 ~ Scritto da paolo

Please backup your files first!

Open the file(s) that contain your locked VBA Projects

Create a new xlsm file and store this code in Module1

code credited to Siwtom (nick name), a Vietnamese developer

Option Explicit
Private Const PAGE_EXECUTE_READWRITE = &H40
Private Declare Sub MoveMemory Lib "kernel32" Alias "RtlMoveMemory" _
            (Destination As Long, Source As Long, ByVal Length As Long)
Private Declare Function VirtualProtect Lib "kernel32" (lpAddress As Long, _
    ByVal dwSize As Long, ByVal flNewProtect As Long, lpflOldProtect As Long) As Long
Private Declare Function GetModuleHandleA Lib "kernel32" (ByVal lpModuleName As String) As Long

Private Declare Function GetProcAddress Lib "kernel32" (ByVal hModule As Long, _
            ByVal lpProcName As String) As Long

Private Declare Function DialogBoxParam Lib "user32" Alias "DialogBoxParamA" (ByVal hInstance As Long, _
            ByVal pTemplateName As Long, ByVal hWndParent As Long, _
            ByVal lpDialogFunc As Long, ByVal dwInitParam As Long) As Integer

    Dim HookBytes(0 To 5) As Byte
    Dim OriginBytes(0 To 5) As Byte
    Dim pFunc As Long
    Dim Flag As Boolean

    Private Function GetPtr(ByVal Value As Long) As Long
        GetPtr = Value
    End Function

    Public Sub RecoverBytes()
        If Flag Then MoveMemory ByVal pFunc, ByVal VarPtr(OriginBytes(0)), 6
    End Sub

    Public Function Hook() As Boolean
        Dim TmpBytes(0 To 5) As Byte
        Dim p As Long
        Dim OriginProtect As Long

        Hook = False

        pFunc = GetProcAddress(GetModuleHandleA("user32.dll"), "DialogBoxParamA")


        If VirtualProtect(ByVal pFunc, 6, PAGE_EXECUTE_READWRITE, OriginProtect) <> 0 Then

            MoveMemory ByVal VarPtr(TmpBytes(0)), ByVal pFunc, 6
            If TmpBytes(0) <> &H68 Then

                MoveMemory ByVal VarPtr(OriginBytes(0)), ByVal pFunc, 6

                p = GetPtr(AddressOf MyDialogBoxParam)

                HookBytes(0) = &H68
                MoveMemory ByVal VarPtr(HookBytes(1)), ByVal VarPtr(p), 4
                HookBytes(5) = &HC3

                MoveMemory ByVal pFunc, ByVal VarPtr(HookBytes(0)), 6
                Flag = True
                Hook = True
            End If
        End If
    End Function

    Private Function MyDialogBoxParam(ByVal hInstance As Long, _
            ByVal pTemplateName As Long, ByVal hWndParent As Long, _
            ByVal lpDialogFunc As Long, ByVal dwInitParam As Long) As Integer
        If pTemplateName = 4070 Then
            MyDialogBoxParam = 1
        Else
            RecoverBytes
            MyDialogBoxParam = DialogBoxParam(hInstance, pTemplateName, _
                               hWndParent, lpDialogFunc, dwInitParam)
            Hook
        End If
    End Function

Paste this code under the above code in Module1 and run it

    Sub unprotected()
        If Hook Then
            MsgBox "VBA Project is unprotected!", vbInformation, "*****"
        End If
    End Sub

Come back to your VBA Projects and enjoy.

con tag excel, macro, password, vba

how to know what type of object we handle with powershell

Giu 29, 2017 ~ Scritto da paolo

This simple powershell script returns True o False if our object is of the same specified type or not.

<# $object contains my username string #>
$object="MyUser"
<# $type contains the type string (User or Group or Computer or OU) #>
$type="User" 

$seek = [System.DirectoryServices.DirectorySearcher]"LDAP://dc=contoso,dc=com"
$seek.Filter = “(&(name=$object)(objectCategory=$type))”
 
Write-Host($seek.FindOne() -ne $null)

con tag powershell, script

Search

Categories

Paolo Grid

Links

Articoli nella categoria News

HwGroup SMS-GW3

How to use PDO with PHP and MySQL

How to use fgetcsv in PHP

VSFTPD Error 500 OOPS

Execute a PHP script from another PHP script

il 75% delle app per Android tracciano l’utente

Best Exchange ActiveSync Mail Apps for AndroidForWork

Blackberry Hub

Outlook

BlueMail

VmWare Boxer

MailWise

Conclusion

Crack password on an Excel VBA Project

how to know what type of object we handle with powershell

Recent Posts

Recent Comments

Paolo History

Search

Categories

Paolo Tag Cloud

Paolo Grid

Links

Articoli nella categoria News

Blackberry Hub

Outlook

BlueMail

VmWare Boxer

MailWise

Conclusion

Recent Posts

Recent Comments

Paolo History