On 2019/03/27 17:10, Mark Rotteveel mark@... [firebird-support] wrote:

 

On 27-3-2019 13:01, 'Stellarancia.com' niobi@...
[firebird-support] wrote:
> Good morning,
> My clients use an application written with Delphi that use a Firebird
> Database 2.5 (business accounting).
> Necessity has risen to access the same database from more subjects that
> uses the same application.
> I was thinking of moving the database Firebird from the computer to a
> Web site, to allow all one connection directed by app.
> Ithink this is possible for Firebird, but I have not succeeded in
> finding the way to install Firebird on a site or to find a site that can
> manage the Firebird driver.
> Obviously I could move the database to a MySql or similar already
> existing on a site, but it should be managed with Php and medium Web pages.
> Is the question first of all: it is possible to install Firebird on
> Web?And how? Looking for documentation, I have found only instructions
> of installation and problem list of connection, but for local computer
> or in an intranet.
> Does documentation exist related to my problem?
> I thank for a possible answer.
> Antonio BIANCA

You don't install Firebird on a website (nor do you install MySQL on a
website for that matter). A website is a thing accessed through HTTP.

Given your application uses Delphi, you either need to allow those
multiple parties to be able to securely access your Firebird server (eg
through a VPN), or maybe you need to build a webservice that replaces
your direct database access.

Building a webservice to replace direct database access is an extremely
broad topic, where accessing the Firebird database is probably the least
of your worries.

In any case, your question is quite vague to actually answer. You may
want to clarify exactly what you're looking for and why.

Mark

--
Mark Rotteveel

Mark is 100% correct, but I think I understand your question.  You want to access FB database remotely from applications. 
To do that on your "website" which are actually just a virtual pc that provides certain services like a "website", will imply that you need access to that "pc", install Firebird and and configure FB and the Pc to allow remote access, etc.  There are many pitfalls this way.  Web providers regular change their rules, antivirus etc and any one of them may suddenly prevent access to your DB.

After many trails, I found that are only two solutions that work.  A virtual server  provided by a service provider where you can install your own software and manage it.  Due to a lack of knowledge, I only use Windows based servers, but I see no reason why Linux will not work.  The second option is open your Firebird server for remote access.  This has nothing to do with Firebird and general means you have setup your internet router to forward request on port 3050/3060 to your FB Server with a few changes to Firebird.conf.  That server must have a fix local IP and router internet connection must have a fix IP or you can use DDNS.

Clearly there are security issues with this, as it gives people with the right info direct access to your DB's from virtually any software that can access a FDB database. 

Cornie