different Webserver and Database-connection via Internet to MASTER-SERVER

[erich.wanker]

Hello,

 

STATUS: Working-uniGui-App on Apache Webserver - connected with a Firebird Database 2.5 (zeosLib for Connection)

 

Every client should  have his own webserver InHouse ...

 

BUT:  i want to store some Informations and Images on MY Webserver - and share this for all client machines

 

Can i connect a firebird Database stable via Internet ? 

 

Thanx for informations

 

Erich

 

 

 

[gerhard.kimmeringer]

Hi Erich,

 

direct connection via Internet is very slow. The only way is
to use zebedee.

http://www.firebirdsql.org/file/documentation/third_party_docs/firebird_zebedee.pdf

 

I have mutch good experience since many years with this tool.

 

The other way is to use datasnap, you can use it also with zeos.

 

best regards

 

Gerhard

[erich.wanker]

Thank you .. i will make a look at it :-)

 

nice greetings

Erich

[ZigZig]

If you can work with other DB than Firebird, you can try Azure SQL Database (from Microsoft) : it works in Delphi just like a Microsoft SQLServer, but it is located in the cloud (Microsoft Datacenter).  Performance is very good and pricing is correct.

[erich.wanker]

Hello Gerhard,

 

thanx for your suggestion -> Zebedee..

 

Now i have a little problem:  I can not connect to the remote Firebird DB

 

 

i have a connection in Mainmodule: -> it should connect to machine 192.158.0.10 where the database is stored (running FB 2.5)

 

            UniMainModule.ZConnection2.Disconnect;

            UniMainModule.ZConnection2.HostName:='localhost';

            UniMainModule.ZConnection2.Port:=3051;

            UniMainModule.ZConnection2.Database:='c:\VersatileServer\Database.fdb';

            UniMainModule.ZConnection2.User:='xxx';

            UniMainModule.ZConnection2.Password:='xxx';

            UniMainModule.ZConnection2.Connect;

 

in "start_client.cmd" (runs on UniGui-Webserver 192.168.0.110)

            Zebedee 3051:192.168.0.10:3050

 

in "start_server.cmd" (runs on 192.168.0.10)

            Zebedee –s localhost:3050

 

 

Firewall is on both machines OFF

 

What make i wrong ???

 

ThanX for help

Erich

 

 

P.S.:

On the UniGui Webserver - Zebedee-Window shows: 

Zebedee 3051:192.168.0.10:3050

Zebedee(19500/18120): Listening on local port 3051

 

On the Database-Machine - Zebedee-Window shows: 

Zebedee us localhost:3050

Zebedee (4420/5996): Listening on local port 4791

[gerhard.kimmeringer]

Hi Erich,

 

do you know that zebedee use as default Port 11965.

 

If you are behind a router you must forward this port to the server.

 

 

best regards

 

Gerhard

[erich.wanker]

Hello Gerhard,

Thanx for your answer :-)

 

I am in my local networt for testing .. no router ... no firewall .. nothing blocks tcp/ip- communication on any port

 

i think, i make something wrong with the settings .. but did not find a solution or what i make wrong ... 

 

machine A

IP 192.168.0.110

Apache Webserver with unigui

Local installed firebird on port 3050

 

machine B

IP 192.168.0.10

Local installed firebird on port 3050

 

UniGui-App

2 connections in the MainModule

1st connection to localhost - port 3050 (for the Firebird Database on machine A)

2nd connection to localhost - port 3051 (for the Firebird Database on machine B) - via Zebedee

 

 

the http://www.winton.org.uk/zebedee/manual.htmlinfos are very strange for me ..

 

hope somebody can help

Nice greetings

Erich

[Abaksoft]

Henceforth, you can use native compression on Firebird 3.0. (WireCompression = True).

http://fossies.org/linux/Firebird/doc/README.wire.compression.html

 

I think this is the most important setting we have to do, on Firebird conf, for web developpement.

 

See page 42 :

https://www.google.dz/url?sa=t&source=web&rct=j&url=http://firebirdsql.org/file/documentation/release_notes/Firebird-3.0.0-ReleaseNotes.pdf&ved=0ahUKEwjnuprm8I_PAhXDCBoKHZfgCDMQFggnMAU&usg=AFQjCNFW5hdS3BJg0osA77iNqyb12PjrBg&sig2=3M1seaO3UwxTrvPcndlisQ

 

See also :

https://ib-aid.com/en/articles/45-ways-to-speed-up-firebird-database/