• Welcome to SQLitening Support Forum.
 

News:

Welcome to the SQLitening support forums!

Main Menu

FreeMyIp.Com very simple free DNS routing

Started by cj, June 20, 2017, 03:42:11 AM

Previous topic - Next topic

cj

http://freemyip.com  Type in a name and it creates a link to your remote Ip address
Save the link provided and execute the link anytime to route to your current Ip or edit to go to another IP address.
If you are behind a VPN, please turn if off when visiting freemyip.com so it receives your "true" remote ip address.

Modified filename to "temp.txt" so it loads as a text file.
In "Wordpad" wordwrap should be turned off
This code assumes you have a SQLiteningServer.exe running

#INCLUDE "sqlitening.inc"

FUNCTION PBMAIN () AS LONG 'QuickTest2.bas 6/20/17
 slconnect "NameYouUsed.freemyip.com",PortNumber
 slOpen "sample.db3"
 ViewFile "select rowid,manuf,redref,product from parts limit 20"
 slDisconnect
END FUNCTION

FUNCTION ViewFile(SQL AS STRING) AS LONG
 LOCAL hFile AS LONG, sTempfile, sArray() AS STRING
 IF slSelAry(sql,sArray(),"Q9 E2") THEN EXIT FUNCTION
 sTempFile="temp.txt"
 hFile = FREEFILE
 OPEN sTempFile FOR OUTPUT AS #hFile
 IF ERR THEN ? ERROR$,,FUNCNAME$:EXIT FUNCTION
 PRINT #hFile,"SQLitening Test"
 IF ERR THEN
  ? ERROR$,,"Could not write heading " + FUNCNAME$
  EXIT FUNCTION
 END IF
 PRINT #hFile
 PRINT #hFile, sArray()
 IF ERR THEN ? ERROR$,,FUNCNAME$:EXIT FUNCTION
 CLOSE #hFile
 SHELL "write.exe " + sTempfile
 SLEEP 500
 KILL sTempfile
 IF ERR THEN ? ERROR$,,FUNCNAME$
END FUNCTION



Fredrick Ughimi

Hello CJ,

I tried running the code above twice and I got error -16 twice. My internet is up and SQLitening Server is running.

Is there something I am missing?
Fredrick O. Ughimi<br /><br />fughimi@gmail.com<br />- Freedom lies in being bold -- Robert Frost, Poet

cj

#2
Setup machine running SQLiteningServer.exe
1 type ipconfig at command prompt
2 look for IpV4 address under ethernet adapter, example 192.168.0.2
3 router software, port forward 51234 to 192.168.0.2
4 allow an app through windows firewall, click change settings, add sqliteningserver

Create shortcut
1 https://freemyip.com
2 enter unique word "klum", check availability, claim it and copy link provided
3 create new shortcut and paste link provided into location and name it "remote"
4 click "remote" shortcut and browser must return "Ok"
5 slconnect "klum.freemyipcom",51234

Execute "remote" shortcut at Windows startup if remote ip address changes

Fredrick,
I didn't see this old thread.
Hope you are doing great!!







Fredrick Ughimi

Hello CJ,

Thank you for putting your last response here.

I now have serious need to use SQLitening remotely.

QuoteFredrick,
I didn't see this old thread.
Hope you are doing great!!

I am doing fine. Thank you.
Fredrick O. Ughimi<br /><br />fughimi@gmail.com<br />- Freedom lies in being bold -- Robert Frost, Poet

Fredrick Ughimi

Hello CJ,

QuoteSetup machine running SQLiteningServer.exe
1 type ipconfig at command prompt
2 look for IpV4 address under ethernet adapter, example 192.168.0.2
3 router software, port forward 51234 to 192.168.0.2
4 allow an app through windows firewall, click change settings, add sqliteningserver

Create shortcut
1 https://freemyip.com
2 enter unique word "klum", check availability, claim it and copy link provided
3 create new shortcut and paste link provided into location and name it "remote"
4 click "remote" shortcut and browser must return "Ok"
5 slconnect "klum.freemyipcom",51234

Execute "remote" shortcut at Windows startup if remote ip address changes

I guess all these processes will be done on the server computer.

No configuration has to be done on the client computer?


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

cj

#5
Correct, client only needs to slConnect.
In Windows 11 I have not been able to get the service SQLiteningServer.exe to autostart
even with delay.  I added an entry in task scheduler to retry a couple of times.  Kludge, but works.
The internet is not available for about a minute even after reaching the desktop.
This may be a problem only on my machine.

Note:  I also run a program named "filewatcher" from the PowerBASIC site.
I set it to monitor the file "sqliteningserver.log".  It displays every logon/logoff and select.
I also modified the server to update the log with every select command.
I can monitor what people are doing.
It also shows incorrect http requests. Might just filter them out, someday.

So freemyip.com always has your remote ip address (if it changes.)
1 Create a shortcut to freemyip.com with link provided for word selected onto desktop
2 Also copy the link to clipboard.  Use properties of shortcut to get it if needed.
3 Press Windows key + R
4 Type  shell:common startup 
5 Create new shortcut in startup folder
6 Paste in the link to freemyip.com
7 Save shortcut as some name like FreeMyIP
Link looks something like:https://freemyip.com/update?token=YOUR_UNIQUE_TOKEN
"YOUR_UNIQUE_TOKEN" links the word chosen by you at freemyip.com so they route to your current remote address.

I also have a shortcut on the windows desktop with the link and token to freemyip.com
I added it as above step number 1
The word "OK" is returned from freemyip.com if it is working.
Be sure to immediately save the link with unique token from freemyip.com.
There is no recovery process if it is lost.

It is also nice to put a link to \bin\filewatcher.exe in common startup folder.

Another thing is be sure if you are using a VPN to disconnect when connecting to freemyip.com
so they get your actual remote ip addresss.  With a good VPN service you can then turn it back on.
If using a VPN you may have to enable remote access (or some such setting) to allow inbound connections.

SQLitening encryption can only be used on the database.  It does not encrypt TCP transmissions.





Fredrick Ughimi

Hello CJ,

Thank you as always for your detailed response.

The autostart feature will be great to implement. I guess that is what you added in the task scheduler?

>>I also modified the server to update the log with every select command.
I can monitor what people are doing.

This will be good to have as well

There is a lot to do here. I will get down to this in a couple of days time.

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

cj

#7
Hopefully, we both have RECEIVE EMAILS AND ALERTS turned on!
If not, click on "Not Following" and change it.

I only needed to use task scheduler on my Windows 11 machine.
The sqliteningserver.exe service auto starts on other computers.

cj