• Welcome, Guest. Please login.
 
July 07, 2020, 03:55:55 am

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

Fred Meier

Mike

I ran ExampleC several times.  All OK.   I am curious, could you please post the contents of SQLiteningServer.Log.  I would like to see what gets logged.

Thanks

mikedoty

August 27, 2008, 10:10:58 pm #16 Last Edit: August 28, 2008, 02:13:03 pm by mikedoty
Sent log to you as an email.  I had it ready before you posted.
Is that the time after the date?  Could be parsed in a later version.

1) Looks like an auto-start option is needed.
2) I was probably running the example when it crashed, and looked at the log and saw you were in at that time.
3) Crash proofing.
4) I'll write a DDT sample, tomorrow to get rid of those message boxes.

I'm going to grab a sandwich.  If you crash the server, just
send me an email and I'll restart it.   I'll be back in 20-minutes.

Paul,
I sent you a private email with address so you can test against my server.

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



Paul Squires

Thanks Mike!

Access to your server worked perfectly. The example code executed with no problems and it was pretty damn fast too! This is very exciting!

:D


mikedoty

August 28, 2008, 02:06:37 pm #18 Last Edit: August 28, 2008, 02:18:27 pm by mikedoty
Modified example3 a little and put SUB's in the order they are mentioned.
This download "remote.bas" in "remote.zip" also embeds the include file.

I find it easier to get the big picture with all the source like this.
Can be downloaded at http://www.dotysoftware.com/sqlite/remote.zip

Great work!

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

Fred Meier

Mike
Thanks for sending me the log and thanks for allowing me to test to your
server.  The log pointed out that the TCP file number is needed on
the User log type (see below). 

QuoteIs that the time after the date?  Could be parsed in a later version.
The log layout is as follows:
    1 -  6 = Date as YYMMDD
    7 - 12 = Time as HHMMSS
   14 - 17 = Record Type as:
             Admn -- followed by a 4 byte message type of Strt, Stop, Flgs, or
                     FACT and then the message.
             Host -- followed by the host name, IP address, socket, and port.
             Conn -- followed by # and the TCP file number and "SK" and the socket number.
             Dcon -- followed by # and the TCP file number.
             User -- followed by # and the TCP file number and user data. User data consists
                     of user name, computes name, and IP address delimited by $BS.
                     Note: The TCP file number for User will be added in Version 5.
             Eror -- followed by the error message.
   19 - ?? = Data depending upon Record Type above.
The log was designed to be as compact as possible for space and speed
reasons and yet also be humanly readable.  The TCP file numbers in Conn,
User, and Dcon allow you to match up connects with disconnects and compute
elapsed time for a user.  This documentation will be included in
SQLitening.Txt starting with Version 5. 


Quote1) Looks like an auto-start option is needed.

The service name is "SQLitening Database & File Server".  The service
Startup Type is set to Automatic when it is installed.  It has always
started automatically for all of my testing on several different computers
(XP and Vista). 

Quote2) I was probably running the example when it crashed, and looked at the log and saw you were in at that time.
3) Crash proofing.

If you are getting GPF's can you help me recreate on my computer so I can fix?
I certainly want to eliminate any GPF's.

I appreciate all your help.

Fred

mikedoty

Have only had 1 GPF and that was when you first logged in at the same time I was using it.  Not sure what that was all about.
When you wrote the tests were multiple people hitting the databases at the
same time taken into account?
Oh, have you tried http://www.dotysoftware.com/sqlite/fredpaul.exe ?

Fred Meier

Yes, I have run FredPaul.Exe just fine.

No, ExampleC was not designed to be running more that once at same time.  I happen to run it just now, at same time you were running, and mine returned a valid error (Meno column already exists) but no GPF.  Check log and you can see how we overlapped.

ExampleC was designed for coding samples of SQLitening routines and probably is best if run in Local Mode.  Or it should be re-coded for multi-use.

By the way,  by using slGetFile I can read your log.  Very helpful.