Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 10 of 11 total
Thread Database access in Version 3
Fri, Jan 15 2021 2:44 PMPermanent Link

KimHJ

Comca Systems, Inc

I just upgraded to version 3 I'm using EDB for database.
I'm trying to get my version 2 projects to build in version 3. It looks like some functions is no longer there like Init before Find.

I understand that I have to take all my database modules over in a server project. It would have been nice if there was a example either YouTube or in writing that just contained one dataset and how to make the client application connect to the server application.

I assume that the Server "Application" have to have the same name as the client application and the .wba file have to be in the same folder as the .html and .js

In my application the database change arcording to the login, but I see that in the Server part of the musiccollection that the Databasename is hardcode in onCreate.

I can run the local server in the IDE, but I have been unable to start the webserver outside the ide, if I try to start the CMDline I get this error: (Socket Error: An attempt was made to access a socket in a way forbidden by  its access premissions. (10013), on API 'bind')

Kim
Sat, Jan 16 2021 11:40 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Kim,

<< I just upgraded to version 3 I'm using EDB for database.
I'm trying to get my version 2 projects to build in version 3. It looks like some functions is no longer there like Init before Find. >>

Yes, please be sure to read the release notes, which contains a list of all of the breaking changes.

<< I understand that I have to take all my database modules over in a server project. It would have been nice if there was a example either YouTube or in writing that just contained one dataset and how to make the client application connect to the server application. >>

I'm doing videos for the database access and the native server modules this week, and those should cover any questions you may have.

<< I assume that the Server "Application" have to have the same name as the client application and the .wba file have to be in the same folder as the .html and .js >>

No, the two are not connected at all.  The client applications don't have any knowledge of server applications, and vice-versa.

<< In my application the database change arcording to the login, but I see that in the Server part of the musiccollection that the Databasename is hardcode in onCreate. >>

There isn't currently a way to handle dynamic database connections based upon user login with the built-in database access API or the server applications.  You'll need to stick with the native server modules in order to do that.

<< I can run the local server in the IDE, but I have been unable to start the webserver outside the ide, if I try to start the CMDline I get this error: (Socket Error: An attempt was made to access a socket in a way forbidden by  its access premissions. (10013), on API 'bind') >>

I forgot to add an aggregate link to the "Getting Started" section for this, but it's up on the site now:

https://www.elevatesoft.com/manual?action=viewtopic&id=ewb3&topic=Before_Using_Product

and will be available in the next build/release as part of the manual.

Tim Young
Elevate Software
www.elevatesoft.com
Sat, Jan 16 2021 12:11 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Kim,

BTW, if you haven't already, please read these topics in the manual.  They will help with some of your questions:

Background web server info:

https://www.elevatesoft.com/manual?action=viewtopic&id=ewb3&topic=Server_Authentication
https://www.elevatesoft.com/manual?action=viewtopic&id=ewb3&topic=Server_Database_Access

Client application info:

https://www.elevatesoft.com/manual?action=viewtopic&id=ewb3&topic=Database_Architecture

Tim Young
Elevate Software
www.elevatesoft.com
Tue, Jan 19 2021 12:35 PMPermanent Link

KimHJ

Comca Systems, Inc

Tim Young [Elevate Software] wrote:

>>BTW, if you haven't already, please read these topics in the manual.  They will help with some of your questions:

Thanks, I should be able to run the same way as in EWB 2, I do not have to create a Server application for each client app?

Kim
Tue, Jan 19 2021 12:50 PMPermanent Link

KimHJ

Comca Systems, Inc

Tim Young [Elevate Software] wrote:

>><< I can run the local server in the IDE, but I have been unable to start the webserver outside the ide, if I try to start the CMDline I get this error: (Socket Error: An attempt was made to access a socket in a way forbidden by  its access premissions. (10013), on API 'bind') >>

I forgot to add an aggregate link to the "Getting Started" section for this, but it's up on the site now:

https://www.elevatesoft.com/manual?action=viewtopic&id=ewb3&topic=Before_Using_Product

and will be available in the next build/release as part of the manual.<<

Tim,

I have a in house Windows Server 2012R2 and I use to have EWB 2 server running on it for testing the application over the local network, the Server have no Certificate installed since it's not accessible from the internet. Is't not possible to run the server with out a SSL Certificate?
I did run the ewbcert localhost –c as an administrator and it intalled fine, but I get the above error when starting the EWB3 server.

Kim
Fri, Jan 22 2021 12:26 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Kim,

<< Thanks, I should be able to run the same way as in EWB 2, I do not have to create a Server application for each client app? >>

Correct.

Tim Young
Elevate Software
www.elevatesoft.com
Fri, Jan 22 2021 12:32 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Kim,

<< I have a in house Windows Server 2012R2 and I use to have EWB 2 server running on it for testing the application over the local network, the Server have no Certificate installed since it's not accessible from the internet. Is't not possible to run the server with out a SSL Certificate? >>

No.

<< I did run the ewbcert localhost –c as an administrator and it intalled fine, but I get the above error when starting the EWB3 server. >>

You can't use the "localhost" certificate name for a remote server.  Instead, use the Windows computer name instead of "localhost" when creating the certificate using the ewbcert utility.  Also, make sure that you remove the "localhost" certificate using the ewbcert utility *before* you create the certificate for the computer name.

You *will* receive some funky security messages from browsers when running with such a setup, but you can bypass them in the browser when you encounter them.  The browser will just complain by putting up a bunch of security warnings in the browser URL bar.

Tim Young
Elevate Software
www.elevatesoft.com
Tue, Jan 26 2021 3:45 AMPermanent Link

Matthew Jones

Tim Young [Elevate Software] wrote:

>  Is't not possible to run the server with out a SSL Certificate? >>
>
> No.

I run all my servers behind a proxy which handles the certificates with Let's Encrypt. When you create your certificates, what lifetime do they have?

I'd like an option to not have to have a certificate, but I can understand the reason you'd enforce it. But I also don't want to have to maintain it, and also need some way to know that it is going to expire sometime in the next 90 days and how to update it without disrupting service. If you could document this somewhere, this would be ideal.

--

Matthew Jones
Tue, Jan 26 2021 9:06 AMPermanent Link

Raul

Team Elevate Team Elevate

On 1/26/2021 3:45 AM, Matthew Jones wrote:
> I run all my servers behind a proxy which handles the certificates with Let's Encrypt. When you create your certificates, what lifetime do they have?

Default localhost is 10 years so i assume same for any other generated one.

If you already have your own certs why not use those for any deployed
ewb web server ?

> I'd like an option to not have to have a certificate, but I can understand the reason you'd enforce it. But I also don't want to have to maintain it, and also need some way to know that it is going to expire sometime in the next 90 days and how to update it without disrupting service. If you could document this somewhere, this would be ideal.

I'm with Tim on making https the only option these days - certs are
trivially accessible and we have to stop using http.

Outside IDE i would suggest use your own certs then (self signed or lets
encrypt etc). 100% under your control then.

Rau
Tue, Jan 26 2021 9:40 AMPermanent Link

Matthew Jones

Raul wrote:

> If you already have your own certs why not use those for any deployed ewb web server ?

Because I don't have ready access to them. Let's Encrypt needs http access to allow the validation to work. I use certbot and nginx to act as the external proxy, and that forwards to services. Internally, http is fine.

I agree though (and said so) that https is understandable - in this case it stops anyone taking an easy route to insecurity. And 10 years is good enough for me on an internally generated cert.

--

Matthew Jones
Page 1 of 2Next Page »
Jump to Page:  1 2
Image