Hi all:
I have to deploy an EWB application to run on port 443 (https).
For now I'm using the EWB Web Server, but does not have SSL, so I can not develop on that server the application in question.
In development projects with EWB, I use the DataSet Manager with ElevateDB, forcing me to use the EWB Web Server in the implementation of the project.  ......or so I think.

I know I can use the JSON interface to work with tables directly (without using DataSet Manager), but not how.
With Apache Server, I have implemented CGI applications with Delphi and MySQL, on port 443.

I need a "guide" on how to develop applications with EWB, Apache and ElevateDB. I do not understand even as complement the three platforms, especially about JSON.

Some time ago, Tim answered in the Forum plans to implement EWB Web Server with SSL.
It would be interesting to know when.

Thanks in advance.
Alvaro

Can I ask what OS your server will be on? And what database are you accessing
(assuming a database is needed)? What server side languages are you familiar with?
Would you be able to use a Delphi service installed on a Windows box?
Knowing these things may help get a better response.

/Matthew Jones/

Matthew Jones:
Thanks for responding

Regarding your questions answered as follows:

I'm using Apache on Windows, since I have experience on that platform. Apache lets me secure connections over SSL.

The database will be ElevateDB Unicode. (2.12b2)

The language I use server side was on Delphi 5 (WebModule VCL), very little HTML and PHP with MySQL.

Now I have developed with EWB, but I have very little knowledge of JS:

I develop with Delphi XE3 Pro, with ElevateDB Unicode.
With respect to a service of Delphi, you refer to a server build with Delphi using Indy libraries for example??

Thanks again....
Alvaro

You can use ElevateDB for PHP extension, if you have some PHP experience.

Ivan Mihailov

I wrote my own server with RealThinClient components - it servers the web pages and does I have code my own responses to EWB Commit and Load - so it can deliver JSON data and JSON Meta Data and do the Add,Insert and Deletes basically I guess doing what Elevates Server does - but - I use StreamSec's SSL for HTTPS.

Look into RealThinClient if you want to roll your own.

Walter

Ivan Mihailov and Walter Matte:
Thanks for contributing ideas. They are well received.
Regarding PHP, you should think about how to integrate PHP and EWB, all served by Apache. EWB really like me and has a lot of potential, I would not quit.
I think the solution is to develop an external server, SSL tunnel and interface with JSON.
I visited the site RealThinClient and what I read, it has some similar characteristics to François Piette ICS VCL. And others that make it much more versatile.
I was also analyzing the Indy components that brings Delphi XE3.

I want to continue using EWB, so I have to think about developing that server.
I think the demo "testserver" upload by Tim, is a good start.
I'll be back to forum for help with JSON.

We must also expect a response from Tim about EWB Web Server with SSL.
I look forward to new suggestions...

Thanks again
Best regards.
Alvaro

Alrvaro,

There are 2 steps here :

1. Serving up the EWB application with Apache and SSL : trivial since
EWB app is just some files (html, js) so any existing Apache install can
server up the EWB application itself.

2. Data - this is where you'd need to write your own web service to
handle the request, access tables and return JSON.
JSON is a fairly simple text format so writing your own back-end service
for this is quite trivial using PHP.
I ended up implementing the EWB JSON server side support in our product
in about 1/2 day for the basic data (handling inserts, edit. deletes
took bit longer cause we decided to do some it using web requests and
not ewb datasets).

See here for JSON reference:
http://www.elevatesoft.com/manual?action=viewtopic&id=ewb1&topic=JSON_Reference


Raul


On 5/29/2013 12:39 PM, Alvaro wrote:
> Hi all:
> I have to deploy an EWB application to run on port 443 (https).
> For now I'm using the EWB Web Server, but does not have SSL, so I can not develop on that server the application in question.
> In development projects with EWB, I use the DataSet Manager with ElevateDB, forcing me to use the EWB Web Server in the implementation of the project.  ......or so I think.
>
> I know I can use the JSON interface to work with tables directly (without using DataSet Manager), but not how.
> With Apache Server, I have implemented CGI applications with Delphi and MySQL, on port 443.
>
> I need a "guide" on how to develop applications with EWB, Apache and ElevateDB. I do not understand even as complement the three platforms, especially about JSON.
>
> Some time ago, Tim answered in the Forum plans to implement EWB Web Server with SSL.
> It would be interesting to know when.
>
> Thanks in advance.
> Alvaro
>

I'll just chip in that I used the RemObjects SDK to make a service that acts as a
web server and web service processor. RO-SDK uses Indy's SSL module. Obviously your
main aim here is to work out how to make a module that fits into Apache, so it
responds to requests. I'd be looking to do a REST or similar service that way. I
don't know how it would be done though.

The key is that because you are on Windows, you can use Delphi to write the
required parts, and that gives you quite a bit of control.

/Matthew Jones/

Alvaro,

<< I have to deploy an EWB application to run on port 443 (https).
For now I'm using the EWB Web Server, but does not have SSL, so I can not
develop on that server the application in question.
In development projects with EWB, I use the DataSet Manager with ElevateDB,
forcing me to use the EWB Web Server in the implementation of the project.
.......or so I think.

I know I can use the JSON interface to work with tables directly (without
using DataSet Manager), but not how.
With Apache Server, I have implemented CGI applications with Delphi and
MySQL, on port 443.

I need a "guide" on how to develop applications with EWB, Apache and
ElevateDB. I do not understand even as complement the three platforms,
especially about JSON. >>

The issue here is that you won't be able to do SSL, period, with the EWB Web
Server, so port 443/SSL is out with datasets, etc.  The best option here is
to use something like STunnel to front-end the EWB Web Server with an SSL
tunnel:

https://www.stunnel.org/index.html

<< Some time ago, Tim answered in the Forum plans to implement EWB Web
Server with SSL. It would be interesting to know when.  >>

When it gets done, that's about all I can say.  Scheduling really doesn't
work for me, because the schedule gets destroyed as soon as a I make it.
All it takes is one support issue taking too long, or some prior coding
taking longer than expected.  SSL in the EWB Web Server *is* a priority,
though.  It's the last thing preventing it being used exclusively for EWB
projects.

Tim Young
Elevate Software
www.elevatesoft.com

I thank all who have made contributions on this topic.
Later will study the integration of JSON with PHP.
And respond to the suggestion Tim provided.
I was testing with OpenSSH and OpenVPN the possibility of making an SSL tunnel.
Both options are not complicated for me. Although it is for users to connect to the server, even automating the installation on each of the remote PCs.
I will study STunnel to compare with the other options.
Thanks for your time and I look forward to the following:
                                                                                         << SSL in the EWB  Web Server * is * a priority >>
Best Regards
Alvaro