Re: 908: Attempt to connect to database server (online2, conerr=-908, oserr=13)
--------------436F1155CF81A1DAF09D0844
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
To your questions:
The default user name on all machines and onlines is "informix". The
password for informix is the same. The onlines, the dbspaces and the
databases are created by the user "informix". There is a different hostname
for each machine, and different ip addresses. There is also a different
servicename and port for each online.
I do not use a shared memory connection. I always use "adler01", "adler01_2"
or "adler02" and so on.
There is one "sqlhosts" for each machine.
The globale configuration is the same on UnixWare / SCO, and the problem
lays only on UnixWare.
# sqlhosts configuration from the unixware machine 1
#### online 1 on unixware 1
online1 onipcshm TQM00245 onlshm71
adler01 ontlitcp TQM00245 onlnet71
#### online 2 on unixware 1
online1_2 onipcshm TQM00245 onlshm71_2
adler01_2 ontlitcp TQM00245 onlnet71_2
#### online 1 on unixware 2
#online2 onipcshm TQM00246 onlshm72
adler02 ontlitcp TQM00246 onlnet72
#### online 2 on unixware 2
#online2_2 onipcshm TQM00246 onlshm72_2
adler02_2 ontlitcp TQM00246 onlnet72_2
#### onlines on sco
fuchs72 ontlitcp TQM00244 onlnet73
online241 ontlitcp TQM00241 onlnet74
# sqlhosts configuration from the unixware machine 2
#### online 1 on unixware 1
#online1 onipcshm TQM00245 onlshm71
adler01 ontlitcp TQM00245 onlnet71
#### online 2 on unixware 1
#online1_2 onipcshm TQM00245 onlshm71_2
adler01_2 ontlitcp TQM00245 onlnet71_2
#### online 1 on unixware 2
online2 onipcshm TQM00246 onlshm72
adler02 ontlitcp TQM00246 onlnet72
#### online 2 on unixware 2
online2_2 onipcshm TQM00246 onlshm72_2
adler02_2 ontlitcp TQM00246 onlnet72_2
#### onlines on sco
fuchs72 ontlitcp TQM00244 onlnet73
online241 ontlitcp TQM00241 onlnet74
services configuration from unixware / sco
onlshm71 16000/tcp
onlnet71 16001/tcp
onlshm71_2 16002/tcp
onlnet71_2 16003/tcp
onlshm72 16004/tcp
onlnet72 16005/tcp
onlshm72_2 16006/tcp
onlnet72_2 16007/tcp
onlshm73 16008/tcp
onlnet73 16009/tcp
onlshm74 16010/tcp
onlnet74 16011/tcp
Helmut Strauss
Art S. Kagel wrote:
> Helmut Strauss wrote:
>
> > My problem is always still alive.
> > I have now further notes to my problem.
> > On all data base servers with the entry "127.0.0.1 localhost" in
> > "/etc/host" I do not have an access.
> > What is to be modified on my system (Unixware) that I can access other
> > Onlines?
> > It cannot be the solution the entry everywhere to remove.
> > With SCO this problem does not occur.
>
> > Helmut Strauss wrote:
>
> > Hello,
> > who can help me or give tips?
>
> > Every time I try to access from a Online1 to a Online2, I
> > receive the following error message:
> > "908: Attempt to connect to database server (online2,
> > conerr=-908, oserr=13)."
>
> > In the online.log of the Online2 I receive the following
> > message:
> > "23:24:14 listener-thread: err = -27001: Read error
> > occurred during connection attempt."
>
> > Both Onlines are situated on the same machine and operate in
> > itself without problems.
>
> > My system:
> > UnixWare 2.02 and Informix 7.13 (or 7.10)
> > The entries in the host, services and sqlhosts are correct.
>
> > If I try to access from SCO Unix 5.0.0 with Informix 7.10,
> > 7.20 or 7.23 to Unixware have I no problems.
>
> > I cannot access however from Unixware to SCO. There is the
> > same problem.
>
> Are the two instances on that machine using the same service? What
> hostname, protocol, and service are you using in the sqlhosts files for
> each? You cannot use a shared memory connection between engines on the
> same machine or to access a server on another host. Are you using the
> same sqlhosts file for both instances? What about for the remote
> instance? Please post all of the relevent sqlhosts entries, I suspect
> this is your problem.
>
> Art S. Kagel
>
> access
--------------436F1155CF81A1DAF09D0844
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit
<HTML>
<B><U>To your questions:</U></B><B><U></U></B>
<P>The default user name on all machines and onlines is "informix". The
password for informix is the same. The onlines, the dbspaces and the databases
are created by the user "informix". There is a different hostname for each
machine, and different ip addresses. There is also a different servicename
and port for each online.
<BR>I do not use a shared memory connection. I always use "adler01", "adler01_2"
or "adler02" and so on.
<BR>There is one "sqlhosts" for each machine.
<BR>The globale configuration is the same on UnixWare / SCO, and the problem
lays only on UnixWare.
<BR>
<P><B><I><TT># sqlhosts configuration from the unixware machine 1</TT></I></B>
<BR><TT><U>#### online 1 on unixware 1</U></TT>
<BR><TT>online1 onipcshm
TQM00245 onlshm71</TT>
<BR><TT>adler01 ontlitcp
TQM00245 onlnet71</TT>
<BR><TT><U>#### online 2 on unixware 1</U></TT>
<BR><TT>online1_2 onipcshm
TQM00245 onlshm71_2</TT>
<BR><TT>adler01_2 ontlitcp
TQM00245 onlnet71_2</TT>
<BR><TT><U>#### online 1 on unixware 2</U></TT>
<BR><TT>#online2 onipcshm
TQM00246 onlshm72</TT>
<BR><TT>adler02 ontlitcp
TQM00246 onlnet72</TT>
<BR><TT><U>#### online 2 on unixware 2</U></TT>
<BR><TT>#online2_2 onipcshm
TQM00246 onlshm72_2</TT>
<BR><TT>adler02_2 ontlitcp
TQM00246 onlnet72_2</TT>
<BR><TT><U>#### onlines on s