Sunday, January 28, 2024

Eero Pro 6 router with TPG NBN cable modem

 Connecting an Eero Pro 6 to TPG NBN modem require few additional settings, the simple setup flow in the app doesn't cover these steps.




1. Setup VLAN 






2. Setup PPPoE username / password 





















Wednesday, January 20, 2021

E32-868T20D Lora module UART access with MacOS

This only shows how to put the module in to sleep mode and access config parameters.



 

 
 
Now you can access the info using CoolTerm HEX mode













Command reference - User manual








Saturday, January 16, 2021

HC-05 bluetooth AT commands on MacOS

 

 I bought HC-05 to use with Arduino but ran in to some issues trying to get the AT commands working. In this example I will show how to use this with a 3.3V UART - USB cable.

Module : HC-05, ZS-040

Firmware : VERSION:4.0-20190728- BAD version

Firmware : VERSION:2.0-20100601 - GOOD version (AT commands)


MacBook <---> USB-UART cable <--> HC-05




 

 

 

1) Power on while press and holding the button to switch to AT mode








2) In MacOS use CoolTerm with these settings 

 http://freeware.the-meiers.org/













3) connect the 3.3V UART to USB cable 

https://www.amazon.co.jp/-/en/gp/product/B0742CLF6M/ref=ppx_yo_dt_b_search_asin_title?ie=UTF8&psc=1














4) Power on the module while press and holding the button

press and hold the button every time an AT command is sent

AT

AT+VERSION?











5) Other useful commands 

AT+NAME=HC-05-TEST-1
AT+PSWD=1212



 




Wednesday, February 19, 2020

WPS pushbutton setup pkt capture

Just tested WPS pushbutton setup and trying to figure out how does the client know which AP to connect to. The client is scanning all the channels and the WiFi AP is adding some extra Information elements to the beacon to indicate that it is ready for WPS pushbutton setup




Wednesday, June 19, 2019

SIM7000E Raspberry Pi HAT Sydney, Australia - Telstra testing

I bought a SIM7000E Raspberry Pi HAT and wanted to test with a Telstra regular mobile phone SIM card. This is how I tested it.

***  Seems to only work with Telstra (PLMN 505-01) 

Bought directly from www.waveshare.com , sent by DHL and arrived in 4 days in Sydney.
 

1) Plug the unit directly in to Raspberry Pi GPIO





2) Connect using UART and Picocom 

raspberry pi 3 model b+  - use port  /dev/ttyAMA0  - read this page on how to change the UART port in raspberry pi --> https://spellfoundry.com/2016/05/29/configuring-gpio-serial-port-raspbian-jessie-including-pi-3/

pi@raspberrypi:~ $ picocom --baud 115200 /dev/ttyAMA0
picocom v1.7

port is        : /dev/ttyS0
flowcontrol    : none
baudrate is    : 115200
parity is      : none
databits are   : 8
escape is      : C-a
local echo is  : no
noinit is      : no
noreset is     : no
nolock is      : no
send_cmd is    : sz -vv
receive_cmd is : rz -vv
imap is        :
omap is        :
emap is        : crcrlf,delbs,

Terminal ready
at
OK

3) Check SIM status

at+cpin?
+CPIN: READY

OK

4) Scan for networks. Retry the same command if you get an error.

at+cops=?
+COPS: (1,"505 01","505 01","50501",7),,(0,1,2,3,4),(0,1,2)

OK

PLMN 505-01 is Telstra
PLMN 505-02 is Optus
PLMN 505-03 is Vodafone

It seems like the module only can see Telstra

5) Manually connect to Telstra

at+cops=1,2,"50501"
OK

6) Check signal strength and attached status 

at+csq
+CSQ: 23,99

OK
at+creg?
+CREG: 0,1

OK
 at+cgatt?
+CGATT: 1

OK

 7) Test sending SMS 

at+cmgf=1
OK


at+cmgs="+6148XXXXXXX"
> hi hi hi hi hi
> .
>
+CMGS: 46

OK

8) Test receiving SMS

When you send an SMS to the number of the SIM in the module, these messages will appear on the console

+CMTI: "SM",1

+CMTI: "SM",2

To read individual SMS

OK
at+cmgr=1
+CMGR: "REC UNREAD","+61XXXXXXX",,"19/06/19,14:33:36+40"
Help

OK
at+cmgr=2
+CMGR: "REC UNREAD","+614XXXXXXX",,"19/06/19,14:33:52+40"
How are things

OK


9) Read all SMS

AT+CMGL="ALL"

10) Show massage storage status 

AT+CPMS?

11) Delete all messages 

at+cmgd=0,4

12) Reset

AT+CFUN=1,1 

13) Get band info

AT +CPSI? 

+CPSI: LTE CAT-M1,Online,505-01,0x2029,134409228,328,EUTRAN-BAND28,9410,5,5,-13,-96,-66,14

 

Saturday, May 11, 2019

Get the third highest salary in the employee table - SQL

This is my Table, and I want to get the 3rd highest salary




First lets sort the table by salary in descending order 


Then to get the 3rd highest. Set offset to 2 and get only one line by setting limit to 1.





Traceroute Mac vs Windows

1) Tracert in Windows use ICMP

Packet Capture Link






2 Traceroute in Mac use UDP