• Welcome, Guest. Please login.
 
May 11, 2021, 08:42:20 PM

News:

Welcome to the SQLitening support forums!


Works over the internet with or without installing

Started by mikedoty, August 26, 2008, 07:45:31 PM

Previous topic - Next topic

mikedoty

August 26, 2008, 07:45:31 PM Last Edit: August 28, 2008, 07:08:39 PM by mikedoty
Test client with or without installing:  updated 8/28/08 4:21 PM CST
http://www.dotysoftware.com/sqlite/fredpaul.exe

Source of entire project:
http://planetsquires.com/support/index.php?topic=2556.0

What would it take to modify the latest example to connect over the internet?
I would like to see an example running over the internet or on another computer.

slAttach     (rsFileName String, rsAsName String, [rsModChars String])


Paul Squires

I think Fred was testing Internet connections at one point. I'm not sure where it stands at this point. I'll wait for Fred to weigh in on this thread.

Fred Meier

Attached is new SQLitening ExampleC.Bas and ExampleC.Exe. 

It will ask if you want to run in Local or Remote Mode.  If Remote Mode then will ask for server and port.  Also if Remote Mode, will inform you when done, that there were two databases created on your server (can not delete them like we can in Local Mode). 

Remote Mode was tested to a LocalHost and to a different computer on a local area network.   I am still working on getting access to an internet server to test with. 

Has anyone run in Remote Mode to an internet server?  Would like to know results.  Thanks

mikedoty

August 27, 2008, 03:44:34 PM #3 Last Edit: August 28, 2008, 02:14:39 PM by mikedoty
I will download and test, now.

Product announcement and download:
http://planetsquires.com/support/index.php?topic=2556.0

mikedoty

August 27, 2008, 04:02:04 PM #4 Last Edit: August 28, 2008, 02:14:59 PM by mikedoty
SqLite or SQLitening returned the following unexpected message
-16 Can not connect
Statement = Connect -- 192.168.0.100 Port=51234

Is server name an IP address?
Also tried on the internet with same result.

Product announcement and download:
http://planetsquires.com/support/index.php?topic=2556.0

Fred Meier

The value of the Server parm passed to slConnect can be either a name or an IP address.  I have updated the doc to show that.

I believe you entered an IP address.  An error in slConnect will always display the value of the Server parm you passed as part of the error message.

Does Remote Mode work OK with LocalHost? 

Check the SQLiteningServer.Log on your remote server to see what IP address your server is.  The Host entry written when the server was started will show it.

A firewall on server will also cause that error.    I have to tell the firewall on the server I test on to allow for SQLiteningServer.Exe.

mikedoty

August 27, 2008, 05:33:29 PM #6 Last Edit: August 28, 2008, 02:15:17 PM by mikedoty
080827131951 Admn Strt ==========<[ Start Server ]>==========
080827131951 Admn Flgs TrimLogManually=No
080827131951 Admn Flgs LogConnDcon=Yes
080827131951 Admn Flgs LogUser=Yes
080827131951 Admn Flgs CreateDatabaseAllowed=Yes
080827131951 Admn FACT Loaded
080827131951 Host LocalHost(127.0.0.1) Socket=140 Port=51234
080827132632 Conn #3 SK 140

From a work station 127.0.0.1 or local 192.168.0.100 does not work.
Firewall is off on all machines.

Rechecked router is port 51234 to 192.168.0.100 (which is the server)

--> When running remote on the server 127.0.0.1 DOES work to its own machine.


Directory of C:\sql\SQLitening_004\Bin

08/26/2008  12:04 AM            12,800 ExampleA.Exe
08/26/2008  12:04 AM             8,704 ExampleB.Exe
08/27/2008  11:58 AM            31,744 ExampleC.Exe
08/27/2008  03:08 PM             5,120 ExampleC_Archive.Sld
08/27/2008  03:08 PM           114,688 ExampleC_Main.Sld
08/26/2008  12:04 AM         1,915,904 sample.db3
05/14/2008  12:21 PM           441,705 SQLite3.Dll
08/26/2008  12:04 AM            51,712 SQLitening.Dll
08/26/2008  12:04 AM            25,600 SQLiteningAuxRuts.Dll
08/26/2008  12:04 AM            37,888 SQLiteningClient.Dll
08/26/2008  12:04 AM             2,476 SQLiteningServer.Cfg
08/26/2008  12:04 AM            65,024 SQLiteningServer.Exe
08/27/2008  03:08 PM               637 SQLiteningServer.Log
08/26/2008  12:04 AM            45,056 SQLiteningServerAdmin.Exe
08/27/2008  01:19 PM    <DIR>          Temp
07/18/2005  05:46 PM            74,240 Zlib.Dll


Product announcement and download:
http://planetsquires.com/support/index.php?topic=2556.0


Fred Meier

You need to add the name (or IP Address) of your remote server to the Hosts entry in the SQLiteningServer.Cfg file.  The only one you have now is LocalHost. Example below.

QuoteHosts = LocalHost, YourServerNameHere (or IP Address)

LocalHost is optional.  If you never plan on actually running a program on the server then remove it.

You will have to Stop and Start the service.  Refresh will not change the Hosts.

Below is the doc about the config file.  This resides as the last section in the config file.

Quote[Documentation of Sections and Entities]
   General
      Port = number  ---   if omitted or value is empty or Default then will use 51234
      Hosts = host1, host2, host3, ... --- at least one host is required,
                                           can be LocalHost, a host name, or n.n.n.n
      LogConnDcon = Yes or No  ---  Controls the logging of connect and disconnect. If Yes then each connect
                                    and disconnect will be logged. If omitted then will default to No
      LogUser = Yes or No  ---   Controls the logging of user name, computer name, and IP address on connect. 
                                 If Yes then user data will be logged. If omitted then will default to No
      CreateDatabaseAllowed = Yes or No  ---  Controls the creation of new databases.  If Yes then clients are
                                              allowed to create new databases on the server.  If omitted then
                                              will default to No
      TrimLogManually = Yes or No  ---  Controls the trimming of the log when it becomes large (> 600K).  If Yes
                                        then no automatic trimming will occur.  If no then will automatically
                                        trim 100K from front of log when it becomes large. If omitted then will
                                        default to No
   FACT --- File Access Control Table
      filename = password, password, ... --- Password of * will match any password(same as removing file).
                                             Password of ! will refuse access to all, protected file.
                                             Password of blank will match a blank password or no password.
                                             Password containing one or more percent sign(%) characters will
                                                      require the file to be opened as read-only.  Attaching a
                                                      file with a read-only password will fail if the slOpen was
                                                      not read-only.

mikedoty

August 27, 2008, 07:09:58 PM #8 Last Edit: August 28, 2008, 02:15:50 PM by mikedoty
I did something really dumb.  I didn't read enough and saw the word hosts and looked for the old hosts file in \windows\system32\drivers\etc and it didn't make any sense.
Just updated YOUR .cfg file and it worked immediately!
Really cool!

Should it also work over the internet?
Update, yes, yes, it does!

Product announcement and download:
http://planetsquires.com/support/index.php?topic=2556.0

Fred Meier

I am not an Internet expert and as I said in the previous post I still have not obtained access to an Internet server to test. So the following is not a matter of fact. 

You will have to modify the server name when you do the slConnect.  If for example your host name was "MyHostName" and that works OK on local area network then using the Internet, server name would have to be something like "MyHostName.MyInternetName.Com"

We use MySql at work on a server named Gold.  Our Internet name is XYZLing.Com.  To connect to MySql over Internet we use Gold.XYZLing.Com (names are phoney).

Let us know how it works.

mikedoty

August 27, 2008, 08:59:25 PM #10 Last Edit: August 28, 2008, 02:16:14 PM by mikedoty
I have it working over the net!
Just needed to change a router setting.

Product announcement and download:
http://planetsquires.com/support/index.php?topic=2556.0

Fred Meier

Thats great ;D

What did you use for server name in slConnect when using Internet?

Can we also test to your Internet server?

mikedoty

August 27, 2008, 09:33:57 PM #12 Last Edit: August 28, 2008, 02:16:32 PM by mikedoty
Just used the IP that I sent you.
Please don't make it public, at least not right now.
Give it a try and see if you can get in.
I left the port 51234.
Would sure like to see if you get in so I'm sure that I'm going down the net.
Faster response may2007@cox.net

Product announcement and download:
http://planetsquires.com/support/index.php?topic=2556.0

Paul Squires

This is fantastic! This was the one really untested area that Fred and I wanted to conquer. This should open the door to allowing SQLitening applications to be web aware.

Fred Meier

Mike,

It worked FINE from here.  Response time was good.

Thanks a bunch cause now I can stop trying to get access to an Internet server.


Thanks again