Subject RE: interclient, jdbc and linux subsystem
Author Mark O'Donohue
>
>
> ________________________________________________________________________
> Message: 8
> Date: Wed, 6 Dec 2000 08:40:48 +0100
> From: tengicki@...
> Subject: interclient, jdbc and linux subsystem
>
> Hello,
>
> I have some problem with interclient 1.6 and interbase 6.0 under
> Linux (FreeBSD).
>
> Our provider has organized the server in subsystems. Thats means
> that there are logical system with own ip-adresses and access
> rights on one physical system.

So persumably all three ip's below are on the same physical box.

> for example the server has the ip 1.2.3.1 (and can be called as
> localhost (127.0.0.1)
>
> an apache with jserv is runnung unser ip 1.2.3.2 on the same
> server and make a connect to interclient
> jdbc:interbase://localhost//usr/databases/db.gdb thats work fine
>
> now we have running a second apache with jserv under ip 1.2.3.3
> on this
> server. apache and jserv work well

Just to confirm, Apache is running twice, it's not listening on two
different ip addresses.
So each then starts up it's own seperate JVM,

> But if I try to connect the database from the second jserv
> environment the
> java statement
>
>
> java.sql.DriverManager.getConnection (databaseURL, user, password)
>
>
> didn't come back. No exception, or something like else.

I guess then you should be able to duplicate this problem by running the
connect from two seperate java programs running at the same time (it
might be worth trying just to get apache out of the picture for figuring
out the problem).

>
> Because of the fact that all subsystem has the same physical server localhost
> "pointed" to the same machine. If there is any call identification via localhost
> it must fail. What uses interclient to connect to interbase, what uses jdbc as
> local ip where the call come from. How can interclient make differences
> between the calls from subsystem on (1.2.3.2) and subsystem (1.2.3.3) if
> they have the same localhost (127.0.0.1).

If they are all on the same physical machine, then it doesn't matter
that apache

netstat may help at least in terms of working out the socket connections
between the client programs/ interserver/ and interbase. And that also
may help you with the problem.

Sorry I don't have a direct answer.

Cheers

Mark

--
Your database needs YOU!
http://firebird.sourceforge.net