Comments in line

Regards

gk

>------------------Original Message-----------
>
>From : Helen Borrie <helebor@...>
>To : firebird-support@yahoogroups.com
>Date : 10/03/2004 7:04:48 AM
>Subject : Re: [firebird-support] Even with NIC to NIC connection network request to host failed
>
>At 12:40 PM 9/03/2004 +0530, you wrote:
>>Hi,
>>
>>I have been posting on and off about a network request to host error when
>>connection from Windows to Classic server running on Linux.
>>
>>Finally we tried this configuration
>>
>>Linux Server - 2 NIC Cards.
>>Windows 2000 Desktop connecting to the server on one of the NIC cards
>>directly with a Patch cord which has some wires switched around to make
>>direct connection.
>>Other NIC card from Linux server connecting to switch.
>>
>>Still getting occasionally. (Maybe once or twice a day But when it happens
>>this problem goes on for around 10 min)
>>ISC ERROR MESSAGE:
>>Unable to complete network request to host "192.168.1.202".
>>Failed to establish a connection.
>>The system could not find the environment
>>option that was entered.
>>
>>(Note this environment option portion of the message did not come before
>>we did this NIC to NIC connection)
>>
>>During this time other (single threaded)clients are able to connect
>>through the switch.
>>
>>Only this multi thread client which is connecting NIC TO NIC is giving a
>>problem
>>
>>This is
>>$00551C56 PlasmaServer.exe IB_Session 1107
>>TIB_SessionBase.HandleException
>>$004FDFEE PlasmaServer.exe IB_Components 1859 TIB_Connection.API_Connect
>>$004FC517 PlasmaServer.exe IB_Components 1159 TIB_Connection.SysConnect
>>$004F9EC1 PlasmaServer.exe IB_Components 295 TIB_Connection.Connect
>>$00749C5D PlasmaServer.exe JLDBConnectionPool 56
>>TJL_DBConnectionPool.GetConnection
>>$0074AE2D PlasmaServer.exe Downloadmultifrm 331
>>TfrmMultiDownload.downLoadNext
>>
>>Any ideas. The client is about to cancel my contract.
>
>At least your NIC test proves there's something wrong with the network
>configuration. Have you eliminated DHCP?

Hmm, No Not with certainity. There were some problems initially with the
configuration. This was resulting in very long connection times on this machine.
But we isolated that and made the changes.

When I say not with certainity I mean I dont know what test to run to be
certain that DHCP is not causing the problems

>
>>I have tried every possible thing under the sun to try to isolate this
>>problem.
>>Is there some tuning I have to do
>
>>either in ibconfig
>
>there is no ibconfig on Linux. The configuration file for IB 6 and
>Firebird 1 is isc_config. Consider the possibility that the server is
>crashing because you haven't configured any temp space and/or that the
>default temp space (the filesystem /tmp on Linux) is missing.

Actually when i was lurking I saw a post to this effect and checked that. I also
in my mind classified this as an unlikely reason, because in that thread server
was crashing when running large sorted queries, but here we seem to be having
trouble establishing the connection.

>
>
>>or on the linux system
>
>Hmmm, so you are configuring this Linux server yourself? Have you thought
>about enlisting the help of someone who understands network services on
>Linux? Or buying a book on the subject?
>

No I am not maintaining the Linux system. The person maintaining the Linux
system is reasonably competent on Linux. He maintains Linux systems on a number
of customer places. He is maintaining at least 40 to 50 servers.

But the trouble is I dont know what questions to ask. If there was some sort of
checklist somewhere I could ask the person to check it out.

With troubleshooting like this you need intution. I have good intuition on
windows, hardly any with Linux

>
>>Both of these have been left more or less at the default.
>>Could it be that the server is running out of memory and thus unable to
>>create a new process on the server ??
>
>That depends on which server you are running. If it's Classic then, yes,
>it's a very real possibility that 512 Mb is going to get used up if you are
>allowing unlimited connections. If it's Superserver, who knows?

It is Firebird Classic 1.0.3. There are roughly 90 single threaded connections which are
running. 30 will be seeing lots of activity, 60 mainly on timer tick for a few
seconds (But the connections dont get closed).
The multithreading app opens one thread in the main thread and is holding it
open. Around once in 10 mins it tries to open 10 connections one after the other
for use in threads.

This is always the place where the trouble starts.

So what do I ask the Linux guy to check? Any hints

>
>The error message you are getting ("The system could not find the
>environment option that was entered") looks like a custom message. Is it
>one you made up yourself to respond to a specific ISC error code? Have you
>explored the conditions that cause that ISC error code?

Hmm, Not it is not. That is the most puzzling thing. I am using an exception
logger. Originally the message would say

ISC ERROR MESSAGE:
Unable to complete network request to host "192.168.1.202".
Failed to establish a connection.

After this NIC to NIC experiment.This system could not find the environment
option that was entered is appended

>
>If you're trying to run IB 6 SS for Linux then anything is possible. It is
>very-very beta.

Nope this is Firebird 1.0.3 Classic

Thanks for all the support.

>>> This mail is created in Hamsa (www.jlmatrix.com) <<<