Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread Authentication loop on external server
Wed, Jul 20 2022 3:34 PMPermanent Link

Ralf Mimoun

Hi,

I wrote a nice app that connects to a database. Everything runs smooth in the IDE with the integrated web server.

Then I tried to deploy it on a Windows machine. Installing the DBISAM and EWB server was easy. Calling the url, I get the UI. But the first database access starts an authentication loop.

So I wrote s demo app, almost no code, just some init stuff and a multiline edit for logging. Works perfectly on the internal server, authentication loop in the external server.

Why do I call it a loop? Because in Session.OnComplete, Session.RequestStatusCode is 200, and Session.Authenticated is True. But OnComplete is called over and over and over again.

Checking the console while calling the web site with Chrome brings up a ton of errors like

GET http://85.215.171.212:8088/databases/DB_CAW/WaegescheinHash/data?DACID=%7B0004B99A-E8AC-44CE-B33C-6D55326C4297%7D 403 (Access denied, connection not authenticated)

I use the user Anonymous (more exactly, I don't touche the default Session properties), I have that user in the external web server (role Public), I have no privileges on the server side database or datasets.

Why on earth is the GET not authenticated when I get a Authenticated=True in my app?
Wed, Jul 20 2022 6:20 PMPermanent Link

Ralf Mimoun

It's getting stranger. When I try to view a dataset from the server in the Sever Manager area, I get a "Dataset load response error (Cannot connect to server)" message. Interestingly, the Test button for the database says that everything is perfekt: "Database connection/disconnection completed successfully".

Did anyone experienced the same?
Wed, Jul 20 2022 7:15 PMPermanent Link

Ralf Mimoun

IT IS ALIVE!

After installing the certificate on the server, everything worked like a charm. I haven't found any info that database access is only possible via https, but that seems to be the case.

Well, it runs. Tim, thank you for this great product!
Thu, Jul 21 2022 3:18 PMPermanent Link

Raul

Team Elevate Team Elevate

On 7/20/2022 7:15 PM, Ralf Mimoun wrote:
> IT IS ALIVE!
>
> After installing the certificate on the server, everything worked like a charm. I haven't found any info that database access is only possible via https, but that seems to be the case.
>

I thought you can access it over http as well.

One thing to check in your ewbsrvr ini file is the "Redirect to Secure"
setting since that could cause this (and might be enabled by default).

Raul

Thu, Jul 21 2022 5:26 PMPermanent Link

Ralf Mimoun

Thanks for the advice. "Redirect to Secure" was switched off. I have to / want to finish this thing asap, so no time to dive deep into the problem. Especially because I found a new one Smile




Raul wrote:

On 7/20/2022 7:15 PM, Ralf Mimoun wrote:
> IT IS ALIVE!
>
> After installing the certificate on the server, everything worked like a charm. I haven't found any info that database access is only possible via https, but that seems to be the case.
>

I thought you can access it over http as well.

One thing to check in your ewbsrvr ini file is the "Redirect to Secure"
setting since that could cause this (and might be enabled by default).

Raul
Image