• Welcome, Guest. Please login.
 
July 17, 2019, 04:41:56 pm

News:

Welcome to the SQLitening support forums!


Using SQLitening Over The Internet

Started by Fredrick Ughimi, May 29, 2018, 11:36:16 am

Previous topic - Next topic

Fredrick Ughimi

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.
Fredrick O. Ughimi<br /><br />fughimi@gmail.com<br />- Freedom lies in being bold -- Robert Frost, Poet

Fredrick Ughimi

Fredrick O. Ughimi<br /><br />fughimi@gmail.com<br />- Freedom lies in being bold -- Robert Frost, Poet

Fredrick Ughimi

Do I need a router? It seems so I guess, to do the port IP forwarding.
Fredrick O. Ughimi<br /><br />fughimi@gmail.com<br />- Freedom lies in being bold -- Robert Frost, Poet

Fredrick Ughimi

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.
Fredrick O. Ughimi<br /><br />fughimi@gmail.com<br />- Freedom lies in being bold -- Robert Frost, Poet

Fredrick Ughimi

June 11, 2018, 02:14:35 pm #4 Last Edit: June 11, 2018, 02:18:49 pm by Fredrick Ughimi
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.
Fredrick O. Ughimi<br /><br />fughimi@gmail.com<br />- Freedom lies in being bold -- Robert Frost, Poet

Fredrick Ughimi

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
Fredrick O. Ughimi<br /><br />fughimi@gmail.com<br />- Freedom lies in being bold -- Robert Frost, Poet

Fredrick Ughimi

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
                               



Fredrick O. Ughimi<br /><br />fughimi@gmail.com<br />- Freedom lies in being bold -- Robert Frost, Poet

Fredrick Ughimi

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.

Fredrick O. Ughimi<br /><br />fughimi@gmail.com<br />- Freedom lies in being bold -- Robert Frost, Poet

Fredrick Ughimi

>>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.
Fredrick O. Ughimi<br /><br />fughimi@gmail.com<br />- Freedom lies in being bold -- Robert Frost, Poet

Fredrick Ughimi

June 12, 2018, 12:33:19 pm #9 Last Edit: June 12, 2018, 12:35:51 pm by Fredrick Ughimi
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.
Fredrick O. Ughimi<br /><br />fughimi@gmail.com<br />- Freedom lies in being bold -- Robert Frost, Poet

Fredrick Ughimi

>>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.
Fredrick O. Ughimi<br /><br />fughimi@gmail.com<br />- Freedom lies in being bold -- Robert Frost, Poet

Fredrick Ughimi

>>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.
Fredrick O. Ughimi<br /><br />fughimi@gmail.com<br />- Freedom lies in being bold -- Robert Frost, Poet

Fredrick Ughimi

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.
Fredrick O. Ughimi<br /><br />fughimi@gmail.com<br />- Freedom lies in being bold -- Robert Frost, Poet

Fredrick Ughimi

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.

Fredrick O. Ughimi<br /><br />fughimi@gmail.com<br />- Freedom lies in being bold -- Robert Frost, Poet

Fredrick Ughimi

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?

Fredrick O. Ughimi<br /><br />fughimi@gmail.com<br />- Freedom lies in being bold -- Robert Frost, Poet