error listeners on wrong ip
On AIX 5.3 with two IP addresses (myserver_boot and myserver) on one interface, IDS 10 logged listener errors "-956: informix@myserver_boot is not trusted", even though sqlhosts named only myserver. Suggestions were to verify sqlhosts/onconfig/hosts/services, check routing (netstat -r) and add a specific host route for the virtual address, or put the virtual IP on a separate subnet; adding the extra address to /etc/hosts.equiv was seen as a workable workaround. Checking netstat -an showed the listener was in fact bound to the correct IP; the poster concluded it was an IP routing issue (connections arriving via the other address), not an Informix one.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
We want to migrate from IDS7.31 to IDS 10.00.FC3R1 on AIX5.3
For the future implementation of HA/CMP there are 2 ip addresses on the same
device :
- myserver_boot for the initial boot
- myserver is added as second address.
The hostname is "myserver."
When we initialize informix : oninit -i
we have an error on ''myserver_boot' whilst the sqlhosts file mentioned
only 'myserver' :
(this error appears on starting the database, no one tries to connect)
12:02:45 listener-thread: err = -956: oserr = 4: errstr =
informix@myserver_boot: Client host or user informix@myserver_boot is not
trusted by the server. System error = 4.
We don't want that the listeners starts on myserver_boot !
Why the listeners wants to connect on ip.address that we didn't want to use
for it ?
Has someone experience with this ??
Thanks,
Yves & Willy
Below more config params :
onconfig :
NETTYPE onsoctcp,2,,CPU
>ifconfig en4
en4:
flags=5e080863,c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,
64BIT,CHECKSUM_OFFLOAD,PSEG,CHAIN>
inet 171.30.16.160 netmask 0xffffff80 broadcast 171.30.16.255
inet 171.30.16.161 netmask 0xffffff80 broadcast 171.30.16.255
>/etc/hosts
171.30.16.160 myserver_boot
171.30.16.161 myserver
>/usr/informix/etc/sqlhosts
oetraddev onsoctcp dvzoeds4 ontraddev
*****DISCLAIMER*****
Dit bericht en alle bijhorende zijn uitsluitend bestemd voor de geadresseerde
en vertrouwelijk.
Indien dit bericht niet voor U bestemd is, gelieve dit dan te vernietigen en
de verzender te verwittigen.
Openbaring, vermenigvuldiging, verspreiding en verstrekking aan derden is niet
toegestaan, tenzij anders vermeld.
Aangezien internet de integriteit van dit bericht niet kan verzekeren, kan de
Dienst Vreemdelingenzaken niet verantwoordelijk gesteld worden indien dit
bericht gewijzigd is.
Bezoek onze website: http://www.dofi.fgov.be
----------------------------------------
*****DISCLAIMER*****
Ce message et toutes les pieces jointes sont etablis a l'intention exclusive
de ses destinataires et sont confidentiels.
Si vous recevez ce message par erreur, merci de le detruire et d'en avertir
l'expediteur.
Toute utilisation de ce message non conforme a sa destination, toute diffusion
ou toute publication, totale ou partielle, est interdite, sauf autorisation
expresse.
L'internet ne permettant pas d'assurer l'integrite de ce message, l'Office des
Etrangers decline toute responsabilite au titre de ce message, dans
l'hypothese ou il aurait ete modifie.
Visiter notre site web: http://www.dofi.fgov.be
Hello,
I think you can compare this to a clustersolution, where IDS starts on a
virtual IP-address
And not on the address of the physical interface.
Please check sqlhosts, onconfig , hosts and services
Sqlhosts :
First field : must correspond with DBSERVERNAME entry in onconfig file
Second field : communication method (onsoctcp)
Third field : the "virtual hostname" , myserver in your case ? (if name
used, must be present in hosts)
Fourth field : the service ( defined in /etc/services)
Are your variables INFORMIXSERVER and ONCONFIG correctly defined ?
If all is correctly defined, you may have problems with the routing
(netstat -r)
I've had a problem before, when you connect to a virtual address, that
the physical address responds.
Best regards
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Support Inf....
Sent: dinsdag 1 augustus 2006 12:11
To: ids@iiug.org
Subject: error listeners on wrong ip [7182]
We want to migrate from IDS7.31 to IDS 10.00.FC3R1 on AIX5.3
For the future implementation of HA/CMP there are 2 ip addresses on the
same
device :
- myserver_boot for the initial boot
- myserver is added as second address.
The hostname is "myserver."
When we initialize informix : oninit -i
we have an error on ''myserver_boot' whilst the sqlhosts file mentioned
only 'myserver' :
(this error appears on starting the database, no one tries to connect)
12:02:45 listener-thread: err = -956: oserr = 4: errstr =
informix@myserver_boot: Client host or user informix@myserver_boot is
not
trusted by the server. System error = 4.
We don't want that the listeners starts on myserver_boot !
Why the listeners wants to connect on ip.address that we didn't want to
use
for it ?
Has someone experience with this ??
Thanks,
Yves & Willy
Below more config params :
onconfig :
NETTYPE onsoctcp,2,,CPU
>ifconfig en4
en4:
flags=5e080863,c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROU
PRT,
64BIT,CHECKSUM_OFFLOAD,PSEG,CHAIN>
inet 171.30.16.160 netmask 0xffffff80 broadcast 171.30.16.255
inet 171.30.16.161 netmask 0xffffff80 broadcast 171.30.16.255
>/etc/hosts
171.30.16.160 myserver_boot
171.30.16.161 myserver
>/usr/informix/etc/sqlhosts
oetraddev onsoctcp dvzoeds4 ontraddev
*****DISCLAIMER*****
Dit bericht en alle bijhorende zijn uitsluitend bestemd voor de
geadresseerde
en vertrouwelijk.
Indien dit bericht niet voor U bestemd is, gelieve dit dan te
vernietigen en
de verzender te verwittigen.
Openbaring, vermenigvuldiging, verspreiding en verstrekking aan derden
is niet
toegestaan, tenzij anders vermeld.
Aangezien internet de integriteit van dit bericht niet kan verzekeren,
kan de
Dienst Vreemdelingenzaken niet verantwoordelijk gesteld worden indien
dit
bericht gewijzigd is.
Bezoek onze website: http://www.dofi.fgov.be
----------------------------------------
*****DISCLAIMER*****
Ce message et toutes les pieces jointes sont etablis a l'intention
exclusive
de ses destinataires et sont confidentiels.
Si vous recevez ce message par erreur, merci de le detruire et d'en
avertir
l'expediteur.
Toute utilisation de ce message non conforme a sa destination, toute
diffusion
ou toute publication, totale ou partielle, est interdite, sauf
autorisation
expresse.
L'internet ne permettant pas d'assurer l'integrite de ce message,
l'Office des
Etrangers decline toute responsabilite au titre de ce message, dans
l'hypothese ou il aurait ete modifie.
Visiter notre site web: http://www.dofi.fgov.be
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
Hi,
Thanks for the response.
I didn't understand or see any routing problem ?
What do you mean ?
Yes it will be a clustersolution (High Availaibliy)
Our config is correct.
No DBSERVERALIASES. Only 1 line in SQLhosts
Problem is informix starts on another IP than hostname from SQLhosts.
Both IP on the same physical interface
The only solution I found out is to put that other IP in /etc/hosts.equiv
But I didn't know if it is a good idea for our cluster to work (HA/CMP)
Why would the informixs listeners work on the wrong IP ?
mvg,
Yves
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]
Sent: 01 August 2006 13:13
To: ids@iiug.org
Subject: RE: error listeners on wrong ip [7183]
Hello,
I think you can compare this to a clustersolution, where IDS starts on a
virtual IP-address
And not on the address of the physical interface.
Please check sqlhosts, onconfig , hosts and services
Sqlhosts :
First field : must correspond with DBSERVERNAME entry in onconfig file
Second field : communication method (onsoctcp)
Third field : the "virtual hostname" , myserver in your case ? (if name
used, must be present in hosts)
Fourth field : the service ( defined in /etc/services)
Are your variables INFORMIXSERVER and ONCONFIG correctly defined ?
If all is correctly defined, you may have problems with the routing
(netstat -r)
I've had a problem before, when you connect to a virtual address, that
the physical address responds.
Best regards
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Support Inf....
Sent: dinsdag 1 augustus 2006 12:11
To: ids@iiug.org
Subject: error listeners on wrong ip [7182]
We want to migrate from IDS7.31 to IDS 10.00.FC3R1 on AIX5.3
For the future implementation of HA/CMP there are 2 ip addresses on the
same
device :
- myserver_boot for the initial boot
- myserver is added as second address.
The hostname is "myserver."
When we initialize informix : oninit -i
we have an error on ''myserver_boot' whilst the sqlhosts file mentioned
only 'myserver' :
(this error appears on starting the database, no one tries to connect)
12:02:45 listener-thread: err = -956: oserr = 4: errstr =
informix@myserver_boot: Client host or user informix@myserver_boot is
not
trusted by the server. System error = 4.
We don't want that the listeners starts on myserver_boot !
Why the listeners wants to connect on ip.address that we didn't want to
use
for it ?
Has someone experience with this ??
Thanks,
Yves & Willy
Below more config params :
onconfig :
NETTYPE onsoctcp,2,,CPU
>ifconfig en4
en4:
flags=5e080863,c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROU
PRT,
64BIT,CHECKSUM_OFFLOAD,PSEG,CHAIN>
inet 171.30.16.160 netmask 0xffffff80 broadcast 171.30.16.255
inet 171.30.16.161 netmask 0xffffff80 broadcast 171.30.16.255
>/etc/hosts
171.30.16.160 myserver_boot
171.30.16.161 myserver
>/usr/informix/etc/sqlhosts
oetraddev onsoctcp dvzoeds4 ontraddev
*****DISCLAIMER*****
Dit bericht en alle bijhorende zijn uitsluitend bestemd voor de
geadresseerde
en vertrouwelijk.
Indien dit bericht niet voor U bestemd is, gelieve dit dan te
vernietigen en
de verzender te verwittigen.
Openbaring, vermenigvuldiging, verspreiding en verstrekking aan derden
is niet
toegestaan, tenzij anders vermeld.
Aangezien internet de integriteit van dit bericht niet kan verzekeren,
kan de
Dienst Vreemdelingenzaken niet verantwoordelijk gesteld worden indien
dit
bericht gewijzigd is.
Bezoek onze website: http://www.dofi.fgov.be
----------------------------------------
*****DISCLAIMER*****
Ce message et toutes les pieces jointes sont etablis a l'intention
exclusive
de ses destinataires et sont confidentiels.
Si vous recevez ce message par erreur, merci de le detruire et d'en
avertir
l'expediteur.
Toute utilisation de ce message non conforme a sa destination, toute
diffusion
ou toute publication, totale ou partielle, est interdite, sauf
autorisation
expresse.
L'internet ne permettant pas d'assurer l'integrite de ce message,
l'Office des
Etrangers decline toute responsabilite au titre de ce message, dans
l'hypothese ou il aurait ete modifie.
Visiter notre site web: http://www.dofi.fgov.be
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
*****DISCLAIMER*****
Dit bericht en alle bijhorende zijn uitsluitend bestemd voor de geadresseerde
en vertrouwelijk.
Indien dit bericht niet voor U bestemd is, gelieve dit dan te vernietigen en
de verzender te verwittigen.
Openbaring, vermenigvuldiging, verspreiding en verstrekking aan derden is niet
toegestaan, tenzij anders vermeld.
Aangezien internet de integriteit van dit bericht niet kan verzekeren, kan de
Dienst Vreemdelingenzaken niet verantwoordelijk gesteld worden indien dit
bericht gewijzigd is.
Bezoek onze website: http://www.dofi.fgov.be
----------------------------------------
*****DISCLAIMER*****
Ce message et toutes les pieces jointes sont etablis a l'intention exclusive
de ses destinataires et sont confidentiels.
Si vous recevez ce message par erreur, merci de le detruire et d'en avertir
l'expediteur.
Toute utilisation de ce message non conforme a sa destination, toute diffusion
ou toute publication, totale ou partielle, est interdite, sauf autorisation
expresse.
L'internet ne permettant pas d'assurer l'integrite de ce message, l'Office des
Etrangers decline toute responsabilite au titre de ce message, dans
l'hypothese ou il aurait ete modifie.
Visiter notre site web: http://www.dofi.fgov.be
Hi,
I dont think the listeners are on the wrong ip, but the requests come via
the other ip.
netstat -an | grep <ifxportno>
This should have a LISTEN line bound on the specific interface (not on *).
(services for all network interfaces show as *.service ...... LISTEN, bound
services show as IP.service .... LISTEN).
I don't think it is easily possible to bind the requesting program to a
specific interface in your environment. If the client does not support
shared memory access, I do not see any solution in your setup.
So, your choice to include the address in hosts.equiv is maybe the most
senseful approach.
Another approach I could think of is putting the virtual interface in a
totally different network. In this case, the client application should
directly reach the other interface (because the route points to it).
This is all not related to Informix, but IP routing.
Hope this helps.
Marcus
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Support Inf....
Sent: Wednesday, August 02, 2006 7:33 AM
To: ids@iiug.org
Subject: RE: error listeners on wrong ip [7199]
Hi,
Thanks for the response.
I didn't understand or see any routing problem ?
What do you mean ?
Yes it will be a clustersolution (High Availaibliy) Our config is correct.
No DBSERVERALIASES. Only 1 line in SQLhosts Problem is informix starts on
another IP than hostname from SQLhosts.
Both IP on the same physical interface
The only solution I found out is to put that other IP in /etc/hosts.equiv
But I didn't know if it is a good idea for our cluster to work (HA/CMP) Why
would the informixs listeners work on the wrong IP ?
mvg,
Yves
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]
Sent: 01 August 2006 13:13
To: ids@iiug.org
Subject: RE: error listeners on wrong ip [7183]
Hello,
I think you can compare this to a clustersolution, where IDS starts on a
virtual IP-address And not on the address of the physical interface.
Please check sqlhosts, onconfig , hosts and services
Sqlhosts :
First field : must correspond with DBSERVERNAME entry in onconfig file
Second field : communication method (onsoctcp) Third field : the "virtual
hostname" , myserver in your case ? (if name used, must be present in hosts)
Fourth field : the service ( defined in /etc/services)
Are your variables INFORMIXSERVER and ONCONFIG correctly defined ?
If all is correctly defined, you may have problems with the routing (netstat
-r) I've had a problem before, when you connect to a virtual address, that
the physical address responds.
Best regards
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Support Inf....
Sent: dinsdag 1 augustus 2006 12:11
To: ids@iiug.org
Subject: error listeners on wrong ip [7182]
We want to migrate from IDS7.31 to IDS 10.00.FC3R1 on AIX5.3
For the future implementation of HA/CMP there are 2 ip addresses on the same
device :
- myserver_boot for the initial boot
- myserver is added as second address.
The hostname is "myserver."
When we initialize informix : oninit -i
we have an error on ''myserver_boot' whilst the sqlhosts file mentioned only
'myserver' :
(this error appears on starting the database, no one tries to connect)
12:02:45 listener-thread: err = -956: oserr = 4: errstr =
informix@myserver_boot: Client host or user informix@myserver_boot is not
trusted by the server. System error = 4.
We don't want that the listeners starts on myserver_boot !
Why the listeners wants to connect on ip.address that we didn't want to use
for it ?
Has someone experience with this ??
Thanks,
Yves & Willy
Below more config params :
onconfig :
NETTYPE onsoctcp,2,,CPU
>ifconfig en4
en4:
flags=5e080863,c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROU
PRT,
64BIT,CHECKSUM_OFFLOAD,PSEG,CHAIN>
inet 171.30.16.160 netmask 0xffffff80 broadcast 171.30.16.255
inet 171.30.16.161 netmask 0xffffff80 broadcast 171.30.16.255
>/etc/hosts
171.30.16.160 myserver_boot
171.30.16.161 myserver
>/usr/informix/etc/sqlhosts
oetraddev onsoctcp dvzoeds4 ontraddev
*****DISCLAIMER*****
Dit bericht en alle bijhorende zijn uitsluitend bestemd voor de
geadresseerde en vertrouwelijk.
Indien dit bericht niet voor U bestemd is, gelieve dit dan te vernietigen en
de verzender te verwittigen.
Openbaring, vermenigvuldiging, verspreiding en verstrekking aan derden is
niet toegestaan, tenzij anders vermeld.
Aangezien internet de integriteit van dit bericht niet kan verzekeren, kan
de Dienst Vreemdelingenzaken niet verantwoordelijk gesteld worden indien dit
bericht gewijzigd is.
Bezoek onze website: http://www.dofi.fgov.be
----------------------------------------
*****DISCLAIMER*****
Ce message et toutes les pieces jointes sont etablis a l'intention exclusive
de ses destinataires et sont confidentiels.
Si vous recevez ce message par erreur, merci de le detruire et d'en avertir
l'expediteur.
Toute utilisation de ce message non conforme a sa destination, toute
diffusion ou toute publication, totale ou partielle, est interdite, sauf
autorisation expresse.
L'internet ne permettant pas d'assurer l'integrite de ce message, l'Office
des Etrangers decline toute responsabilite au titre de ce message, dans
l'hypothese ou il aurait ete modifie.
Visiter notre site web: http://www.dofi.fgov.be
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
*****DISCLAIMER*****
Dit bericht en alle bijhorende zijn uitsluitend bestemd voor de
geadresseerde en vertrouwelijk.
Indien dit bericht niet voor U bestemd is, gelieve dit dan te vernietigen en
de verzender te verwittigen.
Openbaring, vermenigvuldiging, verspreiding en verstrekking aan derden is
niet toegestaan, tenzij anders vermeld.
Aangezien internet de integriteit van dit bericht niet kan verzekeren, kan
de Dienst Vreemdelingenzaken niet verantwoordelijk gesteld worden indien dit
bericht gewijzigd is.
Bezoek onze website: http://www.dofi.fgov.be
----------------------------------------
*****DISCLAIMER*****
Ce message et toutes les pieces jointes sont etablis a l'intention exclusive
de ses destinataires et sont confidentiels.
Si vous recevez ce message par erreur, merci de le detruire et d'en avertir
l'expediteur.
Toute utilisation de ce message non conforme a sa destination, toute
diffusion ou toute publication, totale ou partielle, est interdite, sauf
autorisation expresse.
L'internet ne permettant pas d'assurer l'integrite de ce message, l'Office
des Etrangers decline toute responsabilite au titre de ce message, dans
l'hypothese ou il aurait ete modifie.
Visiter notre site web: http
Hello,
I just checked on one of our cluster environments. (on Solaris, not
using AIX)
The routing table contains specific entries for the virtual ip-addresses
and they are on top of the routing table.
Maybe a "route add host ......" can solve your problem (routing to the
virtual address via the virtual address)
Check your routes with netstat -r or netstat -rn
Once you have a specific route to the virtual host, try starting again.
Best regards,
Jacques
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Support Inf....
Sent: woensdag 2 augustus 2006 7:33
To: ids@iiug.org
Subject: RE: error listeners on wrong ip [7199]
Hi,
Thanks for the response.
I didn't understand or see any routing problem ?
What do you mean ?
Yes it will be a clustersolution (High Availaibliy)
Our config is correct.
No DBSERVERALIASES. Only 1 line in SQLhosts
Problem is informix starts on another IP than hostname from SQLhosts.
Both IP on the same physical interface
The only solution I found out is to put that other IP in
/etc/hosts.equiv
But I didn't know if it is a good idea for our cluster to work (HA/CMP)
Why would the informixs listeners work on the wrong IP ?
mvg,
Yves
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]
Sent: 01 August 2006 13:13
To: ids@iiug.org
Subject: RE: error listeners on wrong ip [7183]
Hello,
I think you can compare this to a clustersolution, where IDS starts on a
virtual IP-address
And not on the address of the physical interface.
Please check sqlhosts, onconfig , hosts and services
Sqlhosts :
First field : must correspond with DBSERVERNAME entry in onconfig file
Second field : communication method (onsoctcp)
Third field : the "virtual hostname" , myserver in your case ? (if name
used, must be present in hosts)
Fourth field : the service ( defined in /etc/services)
Are your variables INFORMIXSERVER and ONCONFIG correctly defined ?
If all is correctly defined, you may have problems with the routing
(netstat -r)
I've had a problem before, when you connect to a virtual address, that
the physical address responds.
Best regards
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Support Inf....
Sent: dinsdag 1 augustus 2006 12:11
To: ids@iiug.org
Subject: error listeners on wrong ip [7182]
We want to migrate from IDS7.31 to IDS 10.00.FC3R1 on AIX5.3
For the future implementation of HA/CMP there are 2 ip addresses on the
same
device :
- myserver_boot for the initial boot
- myserver is added as second address.
The hostname is "myserver."
When we initialize informix : oninit -i
we have an error on ''myserver_boot' whilst the sqlhosts file mentioned
only 'myserver' :
(this error appears on starting the database, no one tries to connect)
12:02:45 listener-thread: err = -956: oserr = 4: errstr =
informix@myserver_boot: Client host or user informix@myserver_boot is
not
trusted by the server. System error = 4.
We don't want that the listeners starts on myserver_boot !
Why the listeners wants to connect on ip.address that we didn't want to
use
for it ?
Has someone experience with this ??
Thanks,
Yves & Willy
Below more config params :
onconfig :
NETTYPE onsoctcp,2,,CPU
>ifconfig en4
en4:
flags=5e080863,c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROU
PRT,
64BIT,CHECKSUM_OFFLOAD,PSEG,CHAIN>
inet 171.30.16.160 netmask 0xffffff80 broadcast 171.30.16.255
inet 171.30.16.161 netmask 0xffffff80 broadcast 171.30.16.255
>/etc/hosts
171.30.16.160 myserver_boot
171.30.16.161 myserver
>/usr/informix/etc/sqlhosts
oetraddev onsoctcp dvzoeds4 ontraddev
*****DISCLAIMER*****
Dit bericht en alle bijhorende zijn uitsluitend bestemd voor de
geadresseerde
en vertrouwelijk.
Indien dit bericht niet voor U bestemd is, gelieve dit dan te
vernietigen en
de verzender te verwittigen.
Openbaring, vermenigvuldiging, verspreiding en verstrekking aan derden
is niet
toegestaan, tenzij anders vermeld.
Aangezien internet de integriteit van dit bericht niet kan verzekeren,
kan de
Dienst Vreemdelingenzaken niet verantwoordelijk gesteld worden indien
dit
bericht gewijzigd is.
Bezoek onze website: http://www.dofi.fgov.be
----------------------------------------
*****DISCLAIMER*****
Ce message et toutes les pieces jointes sont etablis a l'intention
exclusive
de ses destinataires et sont confidentiels.
Si vous recevez ce message par erreur, merci de le detruire et d'en
avertir
l'expediteur.
Toute utilisation de ce message non conforme a sa destination, toute
diffusion
ou toute publication, totale ou partielle, est interdite, sauf
autorisation
expresse.
L'internet ne permettant pas d'assurer l'integrite de ce message,
l'Office des
Etrangers decline toute responsabilite au titre de ce message, dans
l'hypothese ou il aurait ete modifie.
Visiter notre site web: http://www.dofi.fgov.be
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
****
***
Forum Note: Use "Reply" to post a response in the discussion forum.
*****DISCLAIMER*****
Dit bericht en alle bijhorende zijn uitsluitend bestemd voor de
geadresseerde
en vertrouwelijk.
Indien dit bericht niet voor U bestemd is, gelieve dit dan te
vernietigen en
de verzender te verwittigen.
Openbaring, vermenigvuldiging, verspreiding en verstrekking aan derden
is niet
toegestaan, tenzij anders vermeld.
Aangezien internet de integriteit van dit bericht niet kan verzekeren,
kan de
Dienst Vreemdelingenzaken niet verantwoordelijk gesteld worden indien
dit
bericht gewijzigd is.
Bezoek onze website: http://www.dofi.fgov.be
----------------------------------------
*****DISCLAIMER*****
Ce message et toutes les pieces jointes sont etablis a l'intention
exclusive
de ses destinataires et sont confidentiels.
Si vous recevez ce message par erreur, merci de le detruire et d'en
avertir
l'expediteur.
Toute utilisation de ce message non conforme a sa destination, toute
diffusion
ou toute publication, totale ou partielle, est interdite, sauf
autorisation
expresse.
L'internet ne permettant pas d'assurer l'integrite de ce message,
l'Office des
Etrangers decline toute responsabilite au titre de ce message, dans
l'hypothese ou il aurait ete modifie.
Visiter notre site web: http://www.dofi.fgov.be
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
Hi Marcus,
thanks, you are right.
The listener is on the right IP. "netstat -an"
It's no informix problem.
It's a routing problem.
Thanks
Yves
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]
Sent: 02 August 2006 09:23
To: ids@iiug.org
Subject: RE: error listeners on wrong ip [7201]
Hi,
I dont think the listeners are on the wrong ip, but the requests come via
the other ip.
netstat -an | grep <ifxportno>
This should have a LISTEN line bound on the specific interface (not on *).
(services for all network interfaces show as *.service ...... LISTEN, bound
services show as IP.service .... LISTEN).
I don't think it is easily possible to bind the requesting program to a
specific interface in your environment. If the client does not support
shared memory access, I do not see any solution in your setup.
So, your choice to include the address in hosts.equiv is maybe the most
senseful approach.
Another approach I could think of is putting the virtual interface in a
totally different network. In this case, the client application should
directly reach the other interface (because the route points to it).
This is all not related to Informix, but IP routing.
Hope this helps.
Marcus
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Support Inf....
Sent: Wednesday, August 02, 2006 7:33 AM
To: ids@iiug.org
Subject: RE: error listeners on wrong ip [7199]
Hi,
Thanks for the response.
I didn't understand or see any routing problem ?
What do you mean ?
Yes it will be a clustersolution (High Availaibliy) Our config is correct.
No DBSERVERALIASES. Only 1 line in SQLhosts Problem is informix starts on
another IP than hostname from SQLhosts.
Both IP on the same physical interface
The only solution I found out is to put that other IP in /etc/hosts.equiv
But I didn't know if it is a good idea for our cluster to work (HA/CMP) Why
would the informixs listeners work on the wrong IP ?
mvg,
Yves
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]
Sent: 01 August 2006 13:13
To: ids@iiug.org
Subject: RE: error listeners on wrong ip [7183]
Hello,
I think you can compare this to a clustersolution, where IDS starts on a
virtual IP-address And not on the address of the physical interface.
Please check sqlhosts, onconfig , hosts and services
Sqlhosts :
First field : must correspond with DBSERVERNAME entry in onconfig file
Second field : communication method (onsoctcp) Third field : the "virtual
hostname" , myserver in your case ? (if name used, must be present in hosts)
Fourth field : the service ( defined in /etc/services)
Are your variables INFORMIXSERVER and ONCONFIG correctly defined ?
If all is correctly defined, you may have problems with the routing (netstat
-r) I've had a problem before, when you connect to a virtual address, that
the physical address responds.
Best regards
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Support Inf....
Sent: dinsdag 1 augustus 2006 12:11
To: ids@iiug.org
Subject: error listeners on wrong ip [7182]
We want to migrate from IDS7.31 to IDS 10.00.FC3R1 on AIX5.3
For the future implementation of HA/CMP there are 2 ip addresses on the same
device :
- myserver_boot for the initial boot
- myserver is added as second address.
The hostname is "myserver."
When we initialize informix : oninit -i
we have an error on ''myserver_boot' whilst the sqlhosts file mentioned only
'myserver' :
(this error appears on starting the database, no one tries to connect)
12:02:45 listener-thread: err = -956: oserr = 4: errstr =
informix@myserver_boot: Client host or user informix@myserver_boot is not
trusted by the server. System error = 4.
We don't want that the listeners starts on myserver_boot !
Why the listeners wants to connect on ip.address that we didn't want to use
for it ?
Has someone experience with this ??
Thanks,
Yves & Willy
Below more config params :
onconfig :
NETTYPE onsoctcp,2,,CPU
>ifconfig en4
en4:
flags=5e080863,c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROU
PRT,
64BIT,CHECKSUM_OFFLOAD,PSEG,CHAIN>
inet 171.30.16.160 netmask 0xffffff80 broadcast 171.30.16.255
inet 171.30.16.161 netmask 0xffffff80 broadcast 171.30.16.255
>/etc/hosts
171.30.16.160 myserver_boot
171.30.16.161 myserver
>/usr/informix/etc/sqlhosts
oetraddev onsoctcp dvzoeds4 ontraddev
*****DISCLAIMER*****
Dit bericht en alle bijhorende zijn uitsluitend bestemd voor de
geadresseerde en vertrouwelijk.
Indien dit bericht niet voor U bestemd is, gelieve dit dan te vernietigen en
de verzender te verwittigen.
Openbaring, vermenigvuldiging, verspreiding en verstrekking aan derden is
niet toegestaan, tenzij anders vermeld.
Aangezien internet de integriteit van dit bericht niet kan verzekeren, kan
de Dienst Vreemdelingenzaken niet verantwoordelijk gesteld worden indien dit
bericht gewijzigd is.
Bezoek onze website: http://www.dofi.fgov.be
----------------------------------------
*****DISCLAIMER*****
Ce message et toutes les pieces jointes sont etablis a l'intention exclusive
de ses destinataires et sont confidentiels.
Si vous recevez ce message par erreur, merci de le detruire et d'en avertir
l'expediteur.
Toute utilisation de ce message non conforme a sa destination, toute
diffusion ou toute publication, totale ou partielle, est interdite, sauf
autorisation expresse.
L'internet ne permettant pas d'assurer l'integrite de ce message, l'Office
des Etrangers decline toute responsabilite au titre de ce message, dans
l'hypothese ou il aurait ete modifie.
Visiter notre site web: http://www.dofi.fgov.be
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
*****DISCLAIMER*****
Dit bericht en alle bijhorende zijn uitsluitend bestemd voor de
geadresseerde en vertrouwelijk.
Indien dit bericht niet voor U bestemd is, gelieve dit dan te vernietigen en
de verzender te verwittigen.
Openbaring, vermenigvuldiging, verspreiding en verstrekking aan derden is
niet toegestaan, tenzij anders vermeld.
Aangezien internet de integriteit van dit bericht niet kan verzekeren, kan
de Dienst Vreemdelingenzaken niet verantwoordelijk gesteld worden indien dit
bericht gewijzigd is.
Bezoek onze website: http://www.dofi.fgov.be
----------------------------------------
*****DISCLAIMER*****
Ce message et toutes les pieces jointes sont etablis a l'intention exclusive
de ses destinataires et sont confidentiels.
Si vous recevez ce message pa