• Welcome, Guest. Please login.
 
January 27, 2020, 05:29:43 pm

News:

Welcome to the SQLitening support forums!


Some progress, but no brass ring

Started by ken_anthony, August 10, 2016, 05:16:21 pm

Previous topic - Next topic

ken_anthony

This runs both locally on my computer (and its IP) and my server and works, but when I try to connect from my computer to the server it fails. I did open port using the bat provided. I don't know what else to try.

QuoteSub Say(s1 As String)
    MsgBox s1, %MB_TaskModal Or %MB_IconInformation, "Information"
End Sub

Function PBMain () As Long
    slConnect "192.169.142.164", 51234
    slOpen "data\gqH_01_01.db"
    slSel "select * from stars where rowID =1;"
    If slGetRow Then
        say "record found."
    End If
    slClose
End Function


This is my CFG file...

Quote[General]
ServiceNameSuffix=
Port = 51234
Hosts = LocalHost, 192.169.142.164
LogConnDcon=No
LogInvalidInMessage=No
CreateDatabaseAllowed=No
TrimLogManually=Yes
MaxChunkSize=
MaxConnections=10000
ConnectionTimeOut=

[FACT]
Test.Sld = Goffy, AnotherPassWord,   ReadOnly%Password,
TestX.Sld = Goffy, AnotherPassWord,  ReadOnly%Password
>AEntry1 = pass
TestData\NewspaperNew.Jpg = *
Test1.Dat =
Test1A.Dat   =*
Test1X.Dat  =!
Test - Copy.Sld=
Test Or Retired\CopyDatabase\New.Sld =
RemoteFileUploadDownloadExample.Txt =

ken_anthony

QuoteWhat does open the port using a BAT mean?


I created a bat file using the link you provided full of netsh commands which ran without error. I just got off the phone with godaddy support and apparently they have multiple levels of firewall protection. I have to wait until payday two weeks from now before I can afford the two minutes of support I need from them to solve the problem. At this point patience is all I can afford.

Just to reiterate my status. The service installs and runs fine. My test program has no problem selecting a record when run on the server. I know my test program is using the remote call even when run on the server because when I stop the service it reports no connection as it should. Restart the service and it pulls up a record.

So in 2 weeks I'll pay them 8% of my income and get the problem solved. Then I'll report my success right here.

Thanks for your support. Hopefully one day it will be more than just thanks.

ken_anthony

One horrible thought I just had...When I follow slConnect with slOpen how do I know it's actually using the service rather than just working locally? Is it possible for it to connect but not use the connection?

ken_anthony

I've got the files. I will run some tests and report the results.

ken_anthony

This are file sizes...
                      yours      mine
slClient.Dll                   54,784            missing
sqlite3.dll                         829,669            599,419
sqlite3.exe                        575,488            missing
SQLitening.dll            93,184            91,648
SQLiteningAuxRuts.dll        30,208            same
SQLiteningClient.dll              54,784            same
SQLiteningS.dll                   11,776            same
SQLiteningServer.exe             128,512            124,928
SQLiteningServerAdmin.exe     93,696      same
SQLiteningU.dll                    15,360       same
SQLiteningZlib.dll                    74,240       same
SQLiteningProcsA.Dll            missing      15,872
SQLiteningProcsB.Dll            missing      8,192
SQLiteningServerExits.Dll       missing      21,504
SQLiteningServerMonitor.Exe  missing     12,288

Mine are from 170 zip.

I get error 16 testing against your files.

ken_anthony

I'm on a virtual w2012r2 server. I will make the changes so I can see the log. I'm not comfortable making ad hoc changes to code without thoroughly understanding them. Could you put together a new package (version 171?)

It's good that you've been able to establish a connection. Gives me hope.

ken_anthony

cj, If you're using Godaddy be aware they have 2 firewalls. One you have access to and the other only they have access to. They will open those ports for you. On the lower cost unmanaged system I have, I have to pay them a fee for any changes they make for me. Since I feel confident I can manage everything I need to with RDP I thought I'd save some of my pitiful income that way. My hope is for this project to change pitiful to plentiful.

ken_anthony

Reinstalled with LogConnDcon=Yes.

Also removed LocalHost from list. Still getting error 16.

Quote160811131114 Admn Strt ==========<[ Start Server 1.70.0.0 ]>==========
160811131114 Admn Flgs TrimLogManually=Yes
160811131114 Admn Flgs LogConnDcon=Yes
160811131114 Admn Flgs LogInvalidInMessage=No
160811131114 Admn Flgs CreateDatabaseAllowed=No
160811131114 Admn Data MaxChunkSize=500
160811131114 Admn Data MaxConnections=10000
160811131114 Admn Data ConnectionTimeout=30
160811131114 Admn FACT Loaded
160811131114 Host 192.169.142.164(192.169.142.164)  Socket=412  Port=51234  ServiceNameSuffix=
160811131130 Conn #3 SK 412 kjmortensonS192-169-142-16192.169.142.164
160811131134 Dcon #3 Dropped

ken_anthony

Yes! Your connections did show up in my log. Now if I can just get there as well.

I did further testing and it appears I only connect to LocalHost. I thought perhaps my wifi IP changed, but that wasn't it.

cj


cj

August 14, 2016, 10:25:16 am #10 Last Edit: August 14, 2016, 10:55:26 am by cj
The Hosts line must = the IP address given by godaddy.
Also added inbound rule using Server Manager icon next to Start button, Tools at top, select Windows firewall

I can connect to your server and get invalid version so the problem appears to be an old file in the bin directory.

I reinstalled using the attachment at the bottom to SQLitening_150_5.zip. (1,616,182 bytes.)



cj

January 07, 2020, 08:13:42 pm #11 Last Edit: January 08, 2020, 02:09:12 pm by cj
This is an old post brought back to life from 2016

Hosts = LocalHost, 192.169.142.164
Hosts = CompuName, 192.169.142.164
 
Use the computer name of the server and not "LocalHost".
This allows connecting by local ip,remote ip and computer name.



Quote from: undefinedOne horrible thought I just had...When I follow slConnect with slOpen how do I know it's actually using the service rather than just working locally? Is it possible for it to connect but not use the connection?

Yes it is possible, but error 18 transmission errors should occur because remote routines are loaded.

slConnect sHost,PortNumber,"E0"
IF slGetErrorNumber THEN
 ? "Don't continue  if connect failed"
 EXIT FUNCTION
END IF
slSetProcessMods "L0" 'if continuing switch back to local routines



? "Hosts=" + GetComputerNameAndIPAddress  'hosts line allowing connecting with all 3-methods. IP,ComputerName,RemoteIP
FUNCTION PBMAIN () AS LONG
 sComputerName$ = PARSE$(GetComputerNameAndIPAddress,1)
 sIpAddress$    = PARSE$(GetComputerNameAndIPAddress,2)
END FUNCTION

FUNCTION GetComputerNameAndIPAddress AS STRING
 LOCAL sComputerName, sIpAddress AS STRING 'return "computername" + "," + "ipaddress"
 LOCAL ip AS LONG, p AS BYTE PTR
 HOST NAME TO sComputerName
 HOST ADDR TO ip
 p = VARPTR(ip)
 sIPAddress = USING$("#_.#_.#_.#", @p, @p[1], @p[2], @p[3])
 FUNCTION = CHR$(sComputerName,",",sIPAddress)
END FUNCTION