• Welcome, Guest. Please login.
 
September 17, 2019, 02:19:40 pm

News:

Welcome to the SQLitening support forums!


Features missing in "local mode"

Started by Fim, May 20, 2017, 07:16:09 am

Previous topic - Next topic

Fim

Is there any compilation of features available in "remote mode" but missing in "local mode"?
/Fim W.
Fim W

cj

May 20, 2017, 10:45:20 pm #1 Last Edit: May 20, 2017, 11:28:32 pm by cj
I haven't seen any list of missing features in local mode so started a list

Single-writer service handling I/O for client/server mode
Connect over the internet

SQLiteningServer.Log:
Record login of users
Record logout of users

Some features in the SQLiteningServer.Cfg:
Require password
Only allow read-only
Maximum connections allowed
Disallow creating databases
Time-out users

Might be able to encrypt a folder making data only available to service
Server-side includes like security logon (such a big thing, but so little dicussion on the subject)
Reading and writing restricted to path under the server

slGet/slPut restricted to path under server and file names must be listed in SQLiteningServer.cfg
and reading/writing to files related to the server are not allowed

Fim

slSetRelNamedLocks:
"Named locks are only used in remote mode, ignored when running in local mode."
/Fim W.
Fim W

cj

Quote
--- Local Mode ---
If the FileName is not fully pathed then it is assumed to be relative to the current folder which is the same folder, unless changed by chdir, that the first .Exe was run from. If fully pathed then no assumptions are made. Since this running on a local computer SQLitening allows the files to be located anywhere on the local hard drives or local network drives.

Examples:
If your .Exe started in C:\Apps\MyApp then:
If FileName is X\Y\Able.Sld then will assume file is in C:\Apps\MyApp\X\Y.
If FileName is ..\Y\Able.Sld then will assume file is in C:\Apps\Y.
If FileName is C:\Able.Sld then no assumption.

--- Remote Mode ---
The FileName is assumed to be relative to the folder which the service is running from. Since this is running on a remote server SQLitening can not allow the user to access files anyplace on the server. Access is denied to any FileName that has a colon, a double dot, or begins with a backslash. This will insure that the file is in same folder as the service or below it.


Examples:
If your service is running from C:\SQLitening then:
If FileName is Data\Able.Sld then will assume file is in C:\SQLitening\Data.
If FileName is ..\Y\Able.Sld then will get error -8 Access Denied.
If FileName is C:\Able.Sld then will get error -8 Access Denied.

Code Example:

' Create a new database
slOpen "DBFirst.db3", "C"
slExe "Create Table If Not Exists Table1 (Field1, Field2, Field3)"
slClose

' Create a second database and attach the first
slOpen "DBSecond.db3", "C"
slExe "Create Table If Not Exists Table1 (Field1, Field2, Field3)"
slAttach "ExampleB_New1.Sld", "One"