Subject Re: [firebird-support] Install a DB Firebird on a web site
Author Stellarancia.com
He, Cornie,

what you suppose is true:

my intention is really that to directly connect a client on an internet
computer to the server (computer) with Firebird through the router,  for
me theoretically possible, and without the use of a VPN or webservice. 
With all the relative safety issues.

However it is a thing that can be done, if I've understood correctly: 
this was my doubt.

Then, my problem now is "how to set the forward router property": I
don't know.

I must study this argument.

Thanks very much

Antonio BIANCA








Il 27/03/2019 16:46, Cornie cornievs@... [firebird-support] ha
scritto:
>
> 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
>
>
>
>


---
Questa e-mail รจ stata controllata per individuare virus con Avast antivirus.
https://www.avast.com/antivirus