On 2019/03/27 17:10, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
On 27-3-2019 13:01, 'Stellarancia.com' ni...@stellarancia.com
[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
