SQLitening Support Forum

Please login or register.

Login with username, password and session length
Advanced search  

News:

Welcome to the SQLitening support forums!

Pages: [1] 2

Author Topic: Using SQLitening Over The Internet  (Read 1839 times)

Fredrick Ughimi

  • Master Geek
  • ****
  • Posts: 601
    • View Profile
    • Software Development Company
Using SQLitening Over The Internet
« on: May 29, 2018, 09:06: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.
Logged
Fredrick O. Ughimi

fughimi@yahoo.com
- Freedom lies in being bold -- Robert Frost, Poet

Fredrick Ughimi

  • Master Geek
  • ****
  • Posts: 601
    • View Profile
    • Software Development Company
Re: Using SQLitening Over The Internet
« Reply #1 on: June 01, 2018, 06:08:18 AM »

This is what I have been trying to understand:

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

Thanks CJ.
Logged
Fredrick O. Ughimi

fughimi@yahoo.com
- Freedom lies in being bold -- Robert Frost, Poet

Fredrick Ughimi

  • Master Geek
  • ****
  • Posts: 601
    • View Profile
    • Software Development Company
Re: Using SQLitening Over The Internet
« Reply #2 on: June 01, 2018, 10:44:24 AM »

Do I need a router? It seems so I guess, to do the port IP forwarding.
Logged
Fredrick O. Ughimi

fughimi@yahoo.com
- Freedom lies in being bold -- Robert Frost, Poet

Fredrick Ughimi

  • Master Geek
  • ****
  • Posts: 601
    • View Profile
    • Software Development Company
Re: Using SQLitening Over The Internet
« Reply #3 on: June 01, 2018, 01:25: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.
Logged
Fredrick O. Ughimi

fughimi@yahoo.com
- Freedom lies in being bold -- Robert Frost, Poet

Fredrick Ughimi

  • Master Geek
  • ****
  • Posts: 601
    • View Profile
    • Software Development Company
Re: Using SQLitening Over The Internet
« Reply #4 on: June 11, 2018, 11:44:35 AM »

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.
« Last Edit: June 11, 2018, 11:48:49 AM by Fredrick Ughimi »
Logged
Fredrick O. Ughimi

fughimi@yahoo.com
- Freedom lies in being bold -- Robert Frost, Poet

Fredrick Ughimi

  • Master Geek
  • ****
  • Posts: 601
    • View Profile
    • Software Development Company
Re: Using SQLitening Over The Internet
« Reply #5 on: June 11, 2018, 12:20: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
Logged
Fredrick O. Ughimi

fughimi@yahoo.com
- Freedom lies in being bold -- Robert Frost, Poet

Fredrick Ughimi

  • Master Geek
  • ****
  • Posts: 601
    • View Profile
    • Software Development Company
Re: Using SQLitening Over The Internet
« Reply #6 on: June 11, 2018, 01:05: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?

Code: [Select]
#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
                               


Logged
Fredrick O. Ughimi

fughimi@yahoo.com
- Freedom lies in being bold -- Robert Frost, Poet

Fredrick Ughimi

  • Master Geek
  • ****
  • Posts: 601
    • View Profile
    • Software Development Company
Re: Using SQLitening Over The Internet
« Reply #7 on: June 12, 2018, 09:28: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.

Logged
Fredrick O. Ughimi

fughimi@yahoo.com
- Freedom lies in being bold -- Robert Frost, Poet

Fredrick Ughimi

  • Master Geek
  • ****
  • Posts: 601
    • View Profile
    • Software Development Company
Re: Using SQLitening Over The Internet
« Reply #8 on: June 12, 2018, 09:49:11 AM »

>>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.
Logged
Fredrick O. Ughimi

fughimi@yahoo.com
- Freedom lies in being bold -- Robert Frost, Poet

Fredrick Ughimi

  • Master Geek
  • ****
  • Posts: 601
    • View Profile
    • Software Development Company
Re: Using SQLitening Over The Internet
« Reply #9 on: June 12, 2018, 10:03:19 AM »

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.
« Last Edit: June 12, 2018, 10:05:51 AM by Fredrick Ughimi »
Logged
Fredrick O. Ughimi

fughimi@yahoo.com
- Freedom lies in being bold -- Robert Frost, Poet

Fredrick Ughimi

  • Master Geek
  • ****
  • Posts: 601
    • View Profile
    • Software Development Company
Re: Using SQLitening Over The Internet
« Reply #10 on: June 12, 2018, 10:31:36 AM »

>>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.
Logged
Fredrick O. Ughimi

fughimi@yahoo.com
- Freedom lies in being bold -- Robert Frost, Poet

Fredrick Ughimi

  • Master Geek
  • ****
  • Posts: 601
    • View Profile
    • Software Development Company
Re: Using SQLitening Over The Internet
« Reply #11 on: June 12, 2018, 10:37:23 AM »

>>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.
Logged
Fredrick O. Ughimi

fughimi@yahoo.com
- Freedom lies in being bold -- Robert Frost, Poet

Fredrick Ughimi

  • Master Geek
  • ****
  • Posts: 601
    • View Profile
    • Software Development Company
Re: Using SQLitening Over The Internet
« Reply #12 on: June 12, 2018, 10:49:10 AM »

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.
Logged
Fredrick O. Ughimi

fughimi@yahoo.com
- Freedom lies in being bold -- Robert Frost, Poet

Fredrick Ughimi

  • Master Geek
  • ****
  • Posts: 601
    • View Profile
    • Software Development Company
Re: Using SQLitening Over The Internet
« Reply #13 on: June 12, 2018, 11:35:17 AM »

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.

Logged
Fredrick O. Ughimi

fughimi@yahoo.com
- Freedom lies in being bold -- Robert Frost, Poet

Fredrick Ughimi

  • Master Geek
  • ****
  • Posts: 601
    • View Profile
    • Software Development Company
Re: Using SQLitening Over The Internet
« Reply #14 on: June 12, 2018, 12:02: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?

Logged
Fredrick O. Ughimi

fughimi@yahoo.com
- Freedom lies in being bold -- Robert Frost, Poet
Pages: [1] 2