Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread Deployment EWB3 Apps – Problems with Socket Error 10061
Mon, Jul 12 2021 8:21 PMPermanent Link

Richard Harding

Wise Nutrition Coaching

Greetings

I have a network of 2 computers:
* wck: Running ElevateDB Server, EWB Server and EWB3 DB apps
* wck3: Client machine

My client (Eyre and Smith) has a network of 4 computers:
* ServerPC: Running Elevate DB Server
* Accounts: Running EWB Server and the EWB3 eyreandsmith DB app
* Snoopy: Client machine running EWB3 eyreandsmith app
* Charlie: Client machine running EWB3 eyreandsmith app

In the Server Manager, I have 3 EWB3 servers defined for:
* Internal – unsecured port 8300 and secured port 8440
* wck (my PC) – unsecured port 8301 and secured port 8441
* EyreAndSmith (EWB3 Server at customer site) – unsecured port 8302 and secured port 8442

The three EWB3 Servers are:
* EWBSRVR3 listening on port 8300
* EWBSRVR3Number2 listening on port 8301
* EWBSRVR3Number3 listening on port 8302

All my EWB3 DB apps have application html parameters that are parsed to give hostname, portnumber and default port.

?hostname=<hostname>&port=<portnumber>&defaultport=<defaultport>
This allows the base URL to be defined.

The Session.BaseURL is defined as:
'http://' + HostName + ':' + IntToStr(PortNumber)

In all cases, the user has been authenticated and the applications are attempting to load rows in the Session.OnComplete event. If I use an invalid password, I receive an error so I know there is communication with the server. I do not try to Load Rows until the Session Complete event has been called.

wck and Accounts PCs execute the Load Rows, send a request to the server and receive the expected rows as a response.

Doing the same on wck3, snoopy and charlie results in a “Dataset load response error.”
(ElevateDB Error #1100 A connection to the server at <hostname> cannot be established  (socket error no connection could be made because the target machine actively refused it (10061) on the API ‘connect’))

I can run EDB applications in the IDE – this load rows OK.

I can run applications in an external browser – Firefox, Chrome, Microsoft Edge and Opera with the following URL.

http://<hostname>:8301/<project>.html?hostname=<hostname>&port=8301&defaultport=8301
on the PCs: localhost, wck, accounts which loads the rows OK.


All machines run the EWB2 DB applications without problems.

If someone can offer advice on how to proceed, it would be much appreciated.

Richard
Wed, Aug 4 2021 8:25 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Richard,

<< In all cases, the user has been authenticated and the applications are attempting to load rows in the Session.OnComplete event. If I use an invalid password, I receive an error so I know there is communication with the server. I do not try to Load Rows until the Session Complete event has been called.

wck and Accounts PCs execute the Load Rows, send a request to the server and receive the expected rows as a response.

Doing the same on wck3, snoopy and charlie results in a “Dataset load response error.”
(ElevateDB Error #1100 A connection to the server at <hostname> cannot be established  (socket error no connection could be made because the target machine actively refused it (10061) on the API ‘connect’)) >>

This normally indicates that there isn't anything listening on that IP address/port, or that the firewall is blocking any access to the same.  Did you check the firewall log ?

Tim Young
Elevate Software
www.elevatesoft.com
Thu, Aug 12 2021 2:39 PMPermanent Link

Richard Harding

Wise Nutrition Coaching

Tim

<<This normally indicates that there isn't anything listening on that IP address/port, or that the firewall is blocking any access to the same.  Did you check the firewall log ?>>

Yes - the firewall log has been checked and the firewall has been disabled.  EWB2 continues to work OK and I cannot see any differences between EWB2 and EWB3.

Richard
Tue, Aug 17 2021 7:07 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Richard,

<< Yes - the firewall log has been checked and the firewall has been disabled.  EWB2 continues to work OK and I cannot see any differences between EWB2 and EWB3. >>

The error message is an *ElevateDB* error, so the problem is between the EWB 3 Web Server and the ElevateDB Server, not between the EWB application and the EWB 3 Web Server.  You might need to check your ElevateDB connection settings for the database definition on the EWB 3 Web Server.  You can do this remotely in the EWB 3 IDE by using the Server Manager (although, you will probably need to confirm some of the settings locally on the server machine).

Tim Young
Elevate Software
www.elevatesoft.com
Thu, Aug 19 2021 1:44 AMPermanent Link

Richard Harding

Wise Nutrition Coaching

<<The error message is an *ElevateDB* error, so the problem is between the EWB 3 Web Server and the ElevateDB Server, not between the EWB application and the EWB 3 Web Server.  You might need to check your ElevateDB connection settings for the database definition on the EWB 3 Web Server.  You can do this remotely in the EWB 3 IDE by using the Server Manager (although, you will probably need to confirm some of the settings locally on the server machine).>>

Thank you Tim.
Image