Using SQLitening Over The Internet

[Fredrick Ughimi]

>>Forward port 51234 to your local IPv4 address using instructions for TpLink in post above.

All I can see here is NAT Forwarding. There is no Port Forwarding.

By the way I saw the MAC IP Address (70-4F-57-DE-03-A2) at the back of the router.

[Fredrick Ughimi]

>>Did you manually change address for some reason?

No. I obtained it automatically during the router setup. Manually inserting the required parameters was giving me issues so I changed to automatic setup.

[Fredrick Ughimi]

My Router is no longer connecting the internet. Shows red light. I am trying all I can to get it back up.

[cj]

A Type IpConfig at a command prompt
Look for IPv4 Address

B SQLiteningServer.cfg:
hosts=xxx.xxx.xxx.xxx
port=51234

C TPlink router software will showup using http://192.168.1.1  (should be the gateway address)
Forwarding, Virtual Servers
Service Port: 51234
Internal Port: 51234
Ip Address xxx.xxx.xxx.xxx
Common Service Port  "Some name like Foward Port 51234"

Optional:
TpLink Address Reservation so computer reserves the same IPV4 addresses after reboot.
https://www.tp-link.com/ae/faq-182.html

Reset router methods: https://www.tp-link.com/ae/faq-497.html

All I can see here is NAT Forwarding. There is no Port Forwarding.

I saw it in virtual hosting screen shots.  http://www.cfos.de/en/cfos-personal-net/port-forwarding/tp-link-tl-mr3420.htm
The MAC address of the router isn't needed.
Address reservation (if you get everything working) uses the MAC address of the devices (not the router.)
------------------------------------------------------------------
http://setuprouter.com/router/tp-link/tl-mr3420/login.htm
http://www.cfos.de/en/cfos-personal-net/port-forwarding/tp-link-tl-mr3420.htm
https://www.tp-link.com/us/search/?q=TL-MR3420&t=FAQ&s=MODEL
Wouldn't hurt to change router password when you are done.

[Fredrick Ughimi]

Hello CJ,

The router I was using is currently deployed for another use. I would continue this when I get a new router. Is it not possible to use SQLitening over the internet without a router? Say with a static IP address on my server machine? Just thinking. I'd like to try that out in the interim.

Best regards.

[Fredrick Ughimi]

Hello CJ,

I would be having a go at this later in the day. Would be purchasing a router later today.

A Type IpConfig at a command prompt
Look for IPv4 Address

B SQLiteningServer.cfg:
hosts=xxx.xxx.xxx.xxx
port=51234

C TPlink router software will showup using http://192.168.1.1  (should be the gateway address)
Forwarding, Virtual Servers
Service Port: 51234
Internal Port: 51234
Ip Address xxx.xxx.xxx.xxx
Common Service Port  "Some name like Foward Port 51234"

Optional:
TpLink Address Reservation so computer reserves the same IPV4 addresses after reboot.
https://www.tp-link.com/ae/faq-182.html

Reset router methods: https://www.tp-link.com/ae/faq-497.html

All I can see here is NAT Forwarding. There is no Port Forwarding.

I saw it in virtual hosting screen shots.  http://www.cfos.de/en/cfos-personal-net/port-forwarding/tp-link-tl-mr3420.htm
The MAC address of the router isn't needed.
Address reservation (if you get everything working) uses the MAC address of the devices (not the router.)
------------------------------------------------------------------
http://setuprouter.com/router/tp-link/tl-mr3420/login.htm
http://www.cfos.de/en/cfos-personal-net/port-forwarding/tp-link-tl-mr3420.htm
https://www.tp-link.com/us/search/?q=TL-MR3420&t=FAQ&s=MODEL
Wouldn't hurt to change router password when you are done.

You did not mention obtaining the DNS using https://www.freemyip.com  for instance in the steps you provided. An over sight or not needed?


Best regards.

[cj]

FreeMyIP.Com is just an easy way to assign your remote ip address to a name so others can find you when it changes.
If you have a static IP address it can be used without FreeMyIP.com

[Fredrick Ughimi]

Thanks.

[cj]

Welcome.  Be sure to encrypt and hmac over the internet unless you figured out how to use certificates with SQLitening.

[Fredrick Ughimi]

Hello CJ,

Ethernet adapter Ethernet:

   Connection-specific DNS Suffix  . :
   Link-local IPv6 Address . . . . . : fe80::cca6:1fcf:6d1a:6b9e%7
   Autoconfiguration IPv4 Address. . : 169.254.107.158
   Subnet Mask . . . . . . . . . . . : 255.255.0.0
   Default Gateway . . . . . . . . . :

A Type IpConfig at a command prompt
Look for IPv4 Address

Can I use this?  Autoconfiguration IPv4 Address. . : 169.254.107.158

Added:
1. I connected the router to the server computer through a LAN cable
2. I am using a wireless internet network

I guess this is what I need to use?

Wireless LAN adapter Wi-Fi:

   Connection-specific DNS Suffix  . :
   Link-local IPv6 Address . . . . . : fe80::b1e8:1d2:e6b3:d1f%3
   IPv4 Address. . . . . . . . . . . : 192.168.43.5
   Subnet Mask . . . . . . . . . . . : 255.255.255.0
   Default Gateway . . . . . . . . . : 192.168.43.1

[Fredrick Ughimi]

Hello,

How can I connect my router to the my wireless internet connection? My router don't have a usb port and there is no way to connect my wireless internet with a cable.

[cj]

How can I connect my router to the my wireless internet connection? My router don't have a usb port and there is no way to connect my wireless internet with a cable.

Wireless computers connect to router using built-in or USB wireless network adapters
The modem connects to the internet and router plugs into the modem.
Some modems and routers are a single device.  Hopefully you have a cable modem connected to a cable line into the building.

You already plugged in the wireless adapter and no wires are needed

In the router software:  started by http://192.168.1.1  netgear routers are http://192.168.0.1
You may have to get into router software with an ethernet cable the first time since you don't have wifi working.

STEP A
Find wireless settings
1 Enable SSID Broadcast
2 Name (SSID)  Enter name everybody will see with wireless to logon
3 Passphrase    Enter secret logon password


Step B

   TPLink on port forwarding:
https://www.tp-link.com/us/faq-134.html

Name:               Anything you want, example  My Wireless Server
Extemal port:      51234
Internal port:      51234
Internal Server IP 169.254.107.158


Step C (Optional, but suggested)
   Address reservation so IP address can't change
   This assigns the MAC address of the network card to an IP address so the same IP address is always reserve when Windows boots.
https://www.tp-link.com/ae/faq-187.html

MAC Address:  It should appear so you don't have to manually type it in
Reserved IP: Address 169.254.107.158

Connect
In Windows wireless machines:
Click the logon icon on the taskbar
Select network by name
Enter passphrase

Can you see your wireless network name  in the list on any machine or a cell phone?  9/23/18  11:12 AM CST
------------------------------------------------------------------------------------------------------------------
SQLitening server on port 51234 may have to be manually started after Windows begins because wireless drivers may load last.

If you have a shortcut to  SQLiteningServer.exe be sure it uses Run as Administrator.

SQLiteningServer.Cfg
Hosts = 169.254.107.158
Port   = 51234

If using Windows Firewall    SQLiteningServer.exe must be in "Allow an app through Windows Firewall"

[Fredrick Ughimi]

Thank you so much CJ for the detailed information. I was actually using my mobile phone at home to connect to the internet. No way to connect it to the router. I would get a proper modem internet connection when I get to the office tomorrow.

Hopefully

[cj]

Hopefully a cable connection.
Good luck, talk tomorrow if you need help.