SQLitening Support Forum

SQLitening Support => You've got Questions? We've got Answers! => Topic started by: Fredrick Ughimi on May 29, 2018, 11:36:16 am

Title: Using SQLitening Over The Internet
Post by: Fredrick Ughimi on May 29, 2018, 11:36:16 am
Hi,

I would love to use SQLitening over the internet on a Windows Server Machine.

Please, can someone point me in the right direction.

Best regards.
Title: Re: Using SQLitening Over The Internet
Post by: Fredrick Ughimi on June 01, 2018, 08:38:18 am
This is what I have been trying to understand:

http://www.sqlitening.planetsquires.com/index.php?topic=9668.0

Thanks CJ.
Title: Re: Using SQLitening Over The Internet
Post by: Fredrick Ughimi on June 01, 2018, 01:14:24 pm
Do I need a router? It seems so I guess, to do the port IP forwarding.
Title: Re: Using SQLitening Over The Internet
Post by: Fredrick Ughimi on June 01, 2018, 03:55:17 pm
Thanks for the advice. I am just doing this out of curiosity for now. There is no doubt some of my clients would be happy to use their applications I wrote using SQLitening over the internet especially the directors of the companies just to check on things remotely.
Title: Re: Using SQLitening Over The Internet
Post by: Fredrick Ughimi on June 11, 2018, 02:14:35 pm
Hello,

How do I get the my router IP address?

My router is tp-link TL-MR3420 and I am using a wireless 4gb network.

I am not sure if my connection arrangement is okay. I connected the router and the wireless internet device using a USB cable and then I connected my computer to the wireless internet device (wirelessly). I used ipconfig/all to try to retrieve the router IP address (Default Gateway) without success. I even tried bridging the Wireless  and Ethernet  adapters and the Default Gateway I got was 192.168.10.1. I am not sure if I am doing the right thing under this scenario.

Any pointers would be appreciated.
Title: Re: Using SQLitening Over The Internet
Post by: Fredrick Ughimi on June 11, 2018, 02:50:12 pm
Quote
Internal IP v4 address:
IPCONFIG at command prompt


Wireless LAN adapter Wi-Fi:

   Connection-specific DNS Suffix  . :
   Link-local IPv6 Address . . . . . : fe80::69e7:bff9:aa6c:d85f%14
   IPv4 Address. . . . . . . . . . . : 192.168.10.100
   Subnet Mask . . . . . . . . . . . : 255.255.255.0
   Default Gateway . . . . . . . . . : 192.168.10.1
Title: Re: Using SQLitening Over The Internet
Post by: Fredrick Ughimi on June 11, 2018, 03:35:30 pm
Quote
Click link in previous thread to get external ip address.


I did previously and it gave something different from the moment - 169.159.74.114.

I got an error when I tried to check the port (51234) and it says: Error: I could not see your service on 169.159.74.114 on port (51234)


My DNS from https://www.freemyip.com is mnt.freemyip.com

Hosts=mnt.freemyip.com?


#COMPILE EXE
#DIM ALL
#INCLUDE "sqlitening.inc"
FUNCTION PBMAIN () AS LONG

    LOCAL sServer, sPort AS STRING

    sServer = "mnt.freemyip.com"

    sPort = "Default"

    slConnect(sServer, VAL(sPort))
   
    sErr = slGetError
    IF VAL(sErr) <> 0 THEN
         MSGBOX sErr, %MB_TASKMODAL OR %MB_ICONINFORMATION, VD_App.Title
         EXIT FUNCTION
    END IF

   slOpen ("TestFreeDB.db3","C")

END FUNCTION
                               



Title: Re: Using SQLitening Over The Internet
Post by: Fredrick Ughimi on June 12, 2018, 11:58:27 am
Hello CJ,

>>No router and everything is wifi?
There a wireless router attached to the wifi. Sometimes I use the wifi alone. Like now.

>>Local IPV4 address shown using IPCONFIG keeps changing or do you have a static ip address?
It keeps changing. I don't have a static IP address

>>Does the hosts line need to be continually changed?
???

>>Are you allowing port 51234 inbound through firewall?
Yes.

>>SqliteningServer.exe allowed through firewall?
Yes.

>>Are you updating your remote Ip address using link from freemyip.com (if needed).  Does it return "OK"?
It returns Ok.

Title: Re: Using SQLitening Over The Internet
Post by: Fredrick Ughimi on June 12, 2018, 12:19:11 pm
>>So you bypass the router when using wifi?

Not always. Especially when I am away. The wifi is connected to the router now

>>Is your server running right now?

It could not start Eror TCP Open timeout for 169.168.10.110

Still trying to make it start.
Title: Re: Using SQLitening Over The Internet
Post by: Fredrick Ughimi on June 12, 2018, 12:33:19 pm
Quote
Please type IPCONFIG at command line and see if you have two IpV4 addresses.


Wireless LAN adapter Local Area Connection* 2:

   Media State . . . . . . . . . . . : Media disconnected
   Connection-specific DNS Suffix  . :

Wireless LAN adapter Wi-Fi:

   Connection-specific DNS Suffix  . :
   Link-local IPv6 Address . . . . . : fe80::69e7:bff9:aa6c:d85f%16
   IPv4 Address. . . . . . . . . . . : 192.168.10.100
   Subnet Mask . . . . . . . . . . . : 255.255.255.0
   Default Gateway . . . . . . . . . : 192.168.10.1

Quote
I would think in the router software the address reservation would be extremely helpful in that
it would use the MAC address of the wifi device to always use the same local ip address.


Ok.
Title: Re: Using SQLitening Over The Internet
Post by: Fredrick Ughimi on June 12, 2018, 01:01:36 pm
>>Please go into port forwarding in the router software

I am using a TP-LINK TL-MR3420 3G/4G Wireless N Router and I don't think it came with a driver or software.
Title: Re: Using SQLitening Over The Internet
Post by: Fredrick Ughimi on June 12, 2018, 01:07:23 pm
>>I do go through a router for wif from laptop to the router.  Everything internet goes through the router.

Like this?

Computer - Wifi - Router

Mine is like that.
Title: Re: Using SQLitening Over The Internet
Post by: Fredrick Ughimi on June 12, 2018, 01:19:10 pm
I revised the connection like this:

Computer -> Wireless Router -> Wifi

using IPCONFIG I got:

Wireless LAN adapter Wi-Fi:

   Connection-specific DNS Suffix  . :
   Link-local IPv6 Address . . . . . : fe80::69e7:bff9:aa6c:d85f%16
   IPv4 Address. . . . . . . . . . . : 192.168.1.101
   Subnet Mask . . . . . . . . . . . : 255.255.255.0
   Default Gateway . . . . . . . . . : 192.168.1.1

SQLitening Server is running now. I guess this is right arrangement.
Title: Re: Using SQLitening Over The Internet
Post by: Fredrick Ughimi on June 12, 2018, 02:05:17 pm
Still trying to configure the router. Trying to figure out how to fix this:

Error code: 5708 WAN IP cannot be on the same subnet with the LAN IP.

Title: Re: Using SQLitening Over The Internet
Post by: Fredrick Ughimi on June 12, 2018, 02:32:35 pm
Successfully configured the router.

ternet Status: 
Connected
Connection Type: 
Dynamic IP
IP Address: 
192.168.10.105
DNS Server: 
192.168.10.1 0.0.0.0
Gateway: 
192.168.10.1


What next?

Title: Re: Using SQLitening Over The Internet
Post by: Fredrick Ughimi on June 12, 2018, 03:18:25 pm
>>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.

Title: Re: Using SQLitening Over The Internet
Post by: Fredrick Ughimi on June 12, 2018, 03:23:35 pm
>>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.


Title: Re: Using SQLitening Over The Internet
Post by: Fredrick Ughimi on June 12, 2018, 03:38:50 pm
My Router is no longer connecting the internet. Shows red light. I am trying all I can to get it back up.
Title: Re: Using SQLitening Over - Port Forwarding TPLink router/Reset Router
Post by: cj on June 12, 2018, 04:03:38 pm
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 (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 (https://www.tp-link.com/ae/faq-182.html)

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

QuoteAll 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 (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://setuprouter.com/router/tp-link/tl-mr3420/login.htm)
http://www.cfos.de/en/cfos-personal-net/port-forwarding/tp-link-tl-mr3420.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 (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.
Title: Re: Using SQLitening Over The Internet
Post by: Fredrick Ughimi on June 18, 2018, 07:55:39 pm
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.
Title: Re: Using SQLitening Over The Internet
Post by: Fredrick Ughimi on September 21, 2018, 06:50:08 am
Hello CJ,

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

Quote
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.
Title: Re: Using SQLitening Over The Internet
Post by: cj on September 21, 2018, 07:49:43 am
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
Title: Re: Using SQLitening Over The Internet
Post by: Fredrick Ughimi on September 21, 2018, 01:46:25 pm
Thanks.
Title: Re: Using SQLitening Over The Internet
Post by: cj on September 21, 2018, 01:47:43 pm
Welcome.  Be sure to encrypt and hmac over the internet unless you figured out how to use certificates with SQLitening.
Title: Re: Using SQLitening Over The Internet
Post by: Fredrick Ughimi on September 23, 2018, 08:29:06 am
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 . . . . . . . . . :

Quote
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

Title: Re: Using SQLitening Over The Internet
Post by: Fredrick Ughimi on September 23, 2018, 11:08:17 am
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.
Title: Re: Using SQLitening with WIFI
Post by: cj on September 23, 2018, 07:59:57 pm
QuoteHow 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"
Title: Re: Using SQLitening Over The Internet
Post by: Fredrick Ughimi on September 23, 2018, 09:33:55 pm
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
Title: Re: Using SQLitening Over The Internet
Post by: cj on September 23, 2018, 09:36:49 pm
Hopefully a cable connection.
Good luck, talk tomorrow if you need help.