IDS under RedHat Linux with a onsoctcp listener ne
IDS 10 on RHEL 4 started fine with one onsoctcp listener, but adding more DBSERVERALIASES failed with "Network driver cannot bind a name to the port" (error -25572, oserr 13). The aliases used ports 1001-1007; netstat showed nothing listening there. The cause was that ports below 1024 are privileged and the engine's listener threads run as user informix, not root, so bind was denied (permission, not a conflict). Moving the aliases to ports 1531-1537 fixed it; running listeners on NET VPs was also mentioned as an alternative.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Good afternoon,
I could use some advice with IDS under RedHat Linux with a onsoctcp listener
network binding problem / error.
I'm testing IDS 10.00.FC9 under RedHat Linux AS 4.8. I have multiple tcp ports
I use with onsoctcp listeners. IDS seems to start just fine with a single
onsoctcp listener. However, I as soon as I try to add another, the IDS engine
won't start and complains " Network driver cannot bind a name to the port".
There's not much out there for this error on IBM site, nor with a Google
search for that error message.
SQLHOSTS:
cxdb3 onsoctcp cxdb3.cx.claremont.edu 1530
cxdb3lhn onipcshm localhost cxdb3lhn
coistarcars onsoctcp cxdb3.cx.claremont.edu 1001
scistarcars onsoctcp cxdb3.cx.claremont.edu 1002
poistarcars onsoctcp cxdb3.cx.claremont.edu 1003
piistarcars onsoctcp cxdb3.cx.claremont.edu 1004
hmistarcars onsoctcp cxdb3.cx.claremont.edu 1005
cmistarcars onsoctcp cxdb3.cx.claremont.edu 1006
cgistarcars onsoctcp cxdb3.cx.claremont.edu 1007
ONCONFIG:
DBSERVERNAME cxdb3lhn # Name of default database server
DBSERVERALIASEScxdb3,coistarcars,scistarcars,poistarcars,piistarcars,hmistarcars,cmistarcars,cg
istarcars
Error messages:
listener-thread: err = -25572: oserr = 13: errstr = : Network driver cannot
bind a name to the port. System error = 13. sql_listener: ASF_LISTEN failed
When I have only one DBSERVERLIASES with 'cxdb3' then IDS starts up just fine.
As soon as I add another alias like 'coistarcars' or any other, IDS fails to
start.
If you have any knowledge of this issue under Linux, I would be very grateful
for any insight.
Thank-you.
Jonathan B. Smaby
Pomona College
phone: (909) 621-8506
email: jonathan.smaby@pomona.edu
web: http://www.facebook.com/jonathan.smaby
-------------------------------------------------------------
This message has been scanned by Postini anti-virus software.
What happens if you use port 1531 for: coistarcars onsoctcp
cxdb3.cx.claremont.edu 1001?
Thanks,
*******************************************************************
Ernie Knox
IT Database Administrator Specialist
Sears Holdings
3333 Beverly Rd., B4-266A
Hoffman Estates, IL. 60179
Office: (847) 286-5735
Email: Ernest.Knox@searshc.com
Blackberry: 2244650553@messaging.sprintpcs.com
Page via Skytel: 2244650553@sprint.skytel.com
Informix or MySQL Primary: 9110210@skytel.com
Informix or MySQL Secondary: 7276872@skytel.com
" Yes we can make a Change! "
" It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS!
"
" Lets not forget - GO Pistons and Red Wings! "
GSU
*******************************************************************
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Jonathan Smaby
Sent: Wednesday, October 14, 2009 2:00 PM
To: ids@iiug.org
Subject: IDS under RedHat Linux with a onsoctcp listene.... [17550]
Good afternoon,
I could use some advice with IDS under RedHat Linux with a onsoctcp
listener
network binding problem / error.
I'm testing IDS 10.00.FC9 under RedHat Linux AS 4.8. I have multiple tcp
ports
I use with onsoctcp listeners. IDS seems to start just fine with a
single
onsoctcp listener. However, I as soon as I try to add another, the IDS
engine
won't start and complains " Network driver cannot bind a name to the
port".
There's not much out there for this error on IBM site, nor with a Google
search for that error message.
SQLHOSTS:
cxdb3 onsoctcp cxdb3.cx.claremont.edu 1530
cxdb3lhn onipcshm localhost cxdb3lhn
coistarcars onsoctcp cxdb3.cx.claremont.edu 1001
scistarcars onsoctcp cxdb3.cx.claremont.edu 1002
poistarcars onsoctcp cxdb3.cx.claremont.edu 1003
piistarcars onsoctcp cxdb3.cx.claremont.edu 1004
hmistarcars onsoctcp cxdb3.cx.claremont.edu 1005
cmistarcars onsoctcp cxdb3.cx.claremont.edu 1006
cgistarcars onsoctcp cxdb3.cx.claremont.edu 1007
ONCONFIG:
DBSERVERNAME cxdb3lhn # Name of default database server
DBSERVERALIASEScxdb3,coistarcars,scistarcars,poistarcars,piistarcars,hmistarcars,cmista
rcars,cgistarcars
Error messages:
listener-thread: err = -25572: oserr = 13: errstr = : Network driver
cannot
bind a name to the port. System error = 13. sql_listener: ASF_LISTEN
failed
When I have only one DBSERVERLIASES with 'cxdb3' then IDS starts up just
fine.
As soon as I add another alias like 'coistarcars' or any other, IDS
fails to
start.
If you have any knowledge of this issue under Linux, I would be very
grateful
for any insight.
Thank-you.
Jonathan B. Smaby
Pomona College
phone: (909) 621-8506
email: jonathan.smaby@pomona.edu
web: http://www.facebook.com/jonathan.smaby
-------------------------------------------------------------
This message has been scanned by Postini anti-virus software.
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
Are you sure that ports 1001-1007 aren't already being used by another app?
What does netstat say?
Art
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
On Wed, Oct 14, 2009 at 3:00 PM, Jonathan Smaby
<Jonathan.Smaby@pomona.edu>wrote:
> Good afternoon,
>
> I could use some advice with IDS under RedHat Linux with a onsoctcp
> listener
> network binding problem / error.
>
> I'm testing IDS 10.00.FC9 under RedHat Linux AS 4.8. I have multiple tcp
> ports
> I use with onsoctcp listeners. IDS seems to start just fine with a single
> onsoctcp listener. However, I as soon as I try to add another, the IDS
> engine
> won't start and complains " Network driver cannot bind a name to the port".
> There's not much out there for this error on IBM site, nor with a Google
> search for that error message.
>
> SQLHOSTS:
>
> cxdb3 onsoctcp cxdb3.cx.claremont.edu 1530
> cxdb3lhn onipcshm localhost cxdb3lhn
> coistarcars onsoctcp cxdb3.cx.claremont.edu 1001
> scistarcars onsoctcp cxdb3.cx.claremont.edu 1002
> poistarcars onsoctcp cxdb3.cx.claremont.edu 1003
> piistarcars onsoctcp cxdb3.cx.claremont.edu 1004
> hmistarcars onsoctcp cxdb3.cx.claremont.edu 1005
> cmistarcars onsoctcp cxdb3.cx.claremont.edu 1006
> cgistarcars onsoctcp cxdb3.cx.claremont.edu 1007>
> ONCONFIG:
>
> DBSERVERNAME cxdb3lhn # Name of default database server
> DBSERVERALIASES>
>
cxdb3,coistarcars,scistarcars,poistarcars,piistarcars,hmistarcars,cmistarcars,cg
istarcars
>
> Error messages:
>
> listener-thread: err = -25572: oserr = 13: errstr = : Network driver cannot
> bind a name to the port. System error = 13. sql_listener: ASF_LISTEN failed
>
> When I have only one DBSERVERLIASES with 'cxdb3' then IDS starts up just
> fine.
> As soon as I add another alias like 'coistarcars' or any other, IDS fails
> to
> start.
>
> If you have any knowledge of this issue under Linux, I would be very
> grateful
> for any insight.
>
> Thank-you.
>
> Jonathan B. Smaby
> Pomona College
> phone: (909) 621-8506
> email: jonathan.smaby@pomona.edu
> web: http://www.facebook.com/jonathan.smaby
>
> -------------------------------------------------------------
> This message has been scanned by Postini anti-virus software.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--0015175d046cce4a0a0475e9d96f
Hi Art. Yes.. I did a netstat -an and piped that to more.. I didn't see any tcp listeners on those port. But that is a good point, tcp ports below 1024 are suspect. Unfortunately, it's a scheme I inherited from a previous DBA's design. Lots of Apps want to talk to IDS on those port. I'll try moving those port up +530 (1001 = 1531.. etc. etc.) I'll let you know shortly. Jonathan B. Smaby Pomona College phone: (909) 621-8506 email: jonathan.smaby@pomona.edu web: http://www.facebook.com/jonathan.smaby -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel Sent: Wednesday, October 14, 2009 12:06 PM To: ids@iiug.org Subject: Re: IDS under RedHat Linux with a onsoctcp lis.... [17553] Are you sure that ports 1001-1007 aren't already being used by another app? What does netstat say? Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. ------------------------------------------------------------- This message has been scanned by Postini anti-virus software.
That did it. I guess there are more tcp ports < 1024 that are used by some
process that don't show up in 'netstat -an'.
My new testing with SQLHSOTS of:
cxdb3 onsoctcp cxdb3.cx.claremont.edu 1530
cxdb3lhn onipcshm localhost cxdb3lhn
coistarcars onsoctcp cxdb3.cx.claremont.edu 1531
scistarcars onsoctcp cxdb3.cx.claremont.edu 1532
poistarcars onsoctcp cxdb3.cx.claremont.edu 1533
piistarcars onsoctcp cxdb3.cx.claremont.edu 1534
hmistarcars onsoctcp cxdb3.cx.claremont.edu 1535
cmistarcars onsoctcp cxdb3.cx.claremont.edu 1536
cgistarcars onsoctcp cxdb3.cx.claremont.edu 1537
That did the trick, IDS starts just fine with more than one DBSERVERALIASES.
Thanks for the help and the 2nd pair of eyes..
Sincerely,
Jonathan B. Smaby
Pomona College
phone: (909) 621-8506
email: jonathan.smaby@pomona.edu
web: http://www.facebook.com/jonathan.smaby
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel
Sent: Wednesday, October 14, 2009 12:06 PM
To: ids@iiug.org
Subject: Re: IDS under RedHat Linux with a onsoctcp lis.... [17553]
Are you sure that ports 1001-1007 aren't already being used by another app?
What does netstat say?
Art
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
-------------------------------------------------------------
This message has been scanned by Postini anti-virus software.
I generally view the /etc/services file for available ports above 1500+.
Example in Linux:
Linux 2.6.18-128.1.1.el5 #1 SMP Mon Jan 26 13:59:00 EST 2009 i686 i686
i386 GNU/Linux
$cat $INFORMIXDIR/etc/sqlhosts
#***********************************************************************
***
#
# Licensed Material - Property Of IBM
#
# "Restricted Materials of IBM"
#
# IBM Informix Dynamic Server
# (c) Copyright IBM Corporation 1996, 2004 All rights reserved.
#
# Title: sqlhosts.demo
# Description:
# Default sqlhosts file for running demos.
#
#***********************************************************************
***
# IANA (www.iana.org) assigned port number/service names for Informix:
# sqlexec 9088/tcp
# sqlexec-ssl 9089/tcp
ifmx01100 onsoctcp www sqlexec
ifmx01100_ipc onipcshm www sqlexec
informix@wmw [/home/informix]:
$cat /etc/services | grep sqlexec
sqlexec 9088/tcp # IBM Informix SQL
Interface
sqlexec 9088/udp # IBM Informix SQL
Interface
sqlexec-ssl 9089/tcp # IBM Informix SQL
Interface - Encrypted
sqlexec-ssl 9089/udp # IBM Informix SQL
Interface - Encrypted
Thanks,
*******************************************************************
Ernie Knox
IT Database Administrator Specialist
Sears Holdings
3333 Beverly Rd., B4-266A
Hoffman Estates, IL. 60179
Office: (847) 286-5735
Email: Ernest.Knox@searshc.com
Blackberry: 2244650553@messaging.sprintpcs.com
Page via Skytel: 2244650553@sprint.skytel.com
Informix or MySQL Primary: 9110210@skytel.com
Informix or MySQL Secondary: 7276872@skytel.com
" Yes we can make a Change! "
" It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS!
"
" Lets not forget - GO Pistons and Red Wings! "
GSU
*******************************************************************
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Jonathan Smaby
Sent: Wednesday, October 14, 2009 2:18 PM
To: ids@iiug.org
Subject: RE: IDS under RedHat Linux with a onsoctcp lis.... [17555]
That did it. I guess there are more tcp ports < 1024 that are used by
some
process that don't show up in 'netstat -an'.
My new testing with SQLHSOTS of:
cxdb3 onsoctcp cxdb3.cx.claremont.edu 1530
cxdb3lhn onipcshm localhost cxdb3lhn
coistarcars onsoctcp cxdb3.cx.claremont.edu 1531
scistarcars onsoctcp cxdb3.cx.claremont.edu 1532
poistarcars onsoctcp cxdb3.cx.claremont.edu 1533
piistarcars onsoctcp cxdb3.cx.claremont.edu 1534
hmistarcars onsoctcp cxdb3.cx.claremont.edu 1535
cmistarcars onsoctcp cxdb3.cx.claremont.edu 1536
cgistarcars onsoctcp cxdb3.cx.claremont.edu 1537
That did the trick, IDS starts just fine with more than one
DBSERVERALIASES.
Thanks for the help and the 2nd pair of eyes..
Sincerely,
Jonathan B. Smaby
Pomona College
phone: (909) 621-8506
email: jonathan.smaby@pomona.edu
web: http://www.facebook.com/jonathan.smaby
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Art
Kagel
Sent: Wednesday, October 14, 2009 12:06 PM
To: ids@iiug.org
Subject: Re: IDS under RedHat Linux with a onsoctcp lis.... [17553]
Are you sure that ports 1001-1007 aren't already being used by another
app?
What does netstat say?
Art
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
-------------------------------------------------------------
This message has been scanned by Postini anti-virus software.
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
On Wed, Oct 14, 2009 at 12:00, Jonathan Smaby <Jonathan.Smaby@pomona.edu>wrote:
>
> I could use some advice with IDS under RedHat Linux with a onsoctcp
> listener
> network binding problem / error.
>
> I'm testing IDS 10.00.FC9 under RedHat Linux AS 4.8. I have multiple tcp
> ports
> I use with onsoctcp listeners. IDS seems to start just fine with a single
> onsoctcp listener. However, I as soon as I try to add another, the IDS
> engine
> won't start and complains " Network driver cannot bind a name to the port".
> There's not much out there for this error on IBM site, nor with a Google
> search for that error message.
>
> SQLHOSTS:
>
> cxdb3 onsoctcp cxdb3.cx.claremont.edu 1530
> cxdb3lhn onipcshm localhost cxdb3lhn
> coistarcars onsoctcp cxdb3.cx.claremont.edu 1001
> scistarcars onsoctcp cxdb3.cx.claremont.edu 1002
> poistarcars onsoctcp cxdb3.cx.claremont.edu 1003
> piistarcars onsoctcp cxdb3.cx.claremont.edu 1004
> hmistarcars onsoctcp cxdb3.cx.claremont.edu 1005
> cmistarcars onsoctcp cxdb3.cx.claremont.edu 1006
> cgistarcars onsoctcp cxdb3.cx.claremont.edu 1007
ONCONFIG:
>
> DBSERVERNAME cxdb3lhn # Name of default database server
> DBSERVERALIASES>
>
cxdb3,coistarcars,scistarcars,poistarcars,piistarcars,hmistarcars,cmistarcars,cg
istarcars
>
> Error messages:
>
> listener-thread: err = -25572: oserr = 13: errstr = : Network driver cannot
> bind a name to the port. System error = 13. sql_listener: ASF_LISTEN failed
>
> When I have only one DBSERVERLIASES with 'cxdb3' then IDS starts up just
> fine.
> As soon as I add another alias like 'coistarcars' or any other, IDS fails
> to
> start.
>
> If you have any knowledge of this issue under Linux, I would be very
> grateful
> for any insight.
Port numbers less than 1024 are 'reserved' for well-known services (on all
species of Unix). You should normally aim to use port numbers larger than
1024, therefore. That said, root privileged processes are normally able to
use those ports, I thought - but errno = 13 is ENOPERM (Permission denied)
on Solaris and probably on Linux too.
I suppose that if the listeners are running in the only CPU VP and that is
running as user informix, then it would lack the privilege to open those
ports. You might be able to fix that by running the listeners on one or
more NET VPs, instead of on the CPU VP.
Anyway, I suggest changing your 1001..1007 numbers to a different range
(2001..2007, or 10001..10007) and try again.
--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."
NB: Please do not use this email for correspondence.
I don't necessarily read it every week, even.
Ted Turner <http://www.brainyquote.com/quotes/authors/t/ted_turner.html>; -
"Sports is like a war without the killing."
--001636310583b7a83c0475ebf07c
On Wed, Oct 14, 2009 at 12:17, Jonathan Smaby <Jonathan.Smaby@pomona.edu>wrote:
> That did it. I guess there are more tcp ports < 1024 that are used by some
> process that don't show up in 'netstat -an'.
>
> My new testing with SQLHOSTS of:
>
> cxdb3 onsoctcp cxdb3.cx.claremont.edu 1530
> cxdb3lhn onipcshm localhost cxdb3lhn
> coistarcars onsoctcp cxdb3.cx.claremont.edu 1531
> scistarcars onsoctcp cxdb3.cx.claremont.edu 1532>
> [...]
>
As noted in my separate answer (still travelling, or only just arrived),
port numbers under 1024 are reserved and only a root-privileged process can
open them. You must have had the CPU VPs (which run as user informix, not
as user root) doing the listening. So it was not a question of the ports
being in use, but simply IDS did not have the privilege needed to use them.
Remapping the port numbers to values larger than 1023 should do the trick -
you confirmed that it does do the triwith this post.
--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."
NB: Please do not use this email for correspondence.
I don't necessarily read it every week, even.
Stephen
Leacock<http://www.brainyquote.com/quotes/authors/s/stephen_leacock.html>;
- "I detest life-insurance agents: they always argue that I shall some
day
die, which is not so."
--0016e6470eecad1cd20475ec073c
Thanks Jonathan...
See you at I.O.D. in a couple weeks?
Jonathan B. Smaby
Pomona College
phone: (909) 621-8506
email: jonathan.smaby@pomona.edu
web: http://www.facebook.com/jonathan.smaby
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Jonathan
Leffler
Sent: Wednesday, October 14, 2009 2:42 PM
To: ids@iiug.org
Subject: Re: IDS under RedHat Linux with a onsoctcp lis.... [17568]
On Wed, Oct 14, 2009 at 12:17, Jonathan Smaby
<Jonathan.Smaby@pomona.edu>wrote:
> That did it. I guess there are more tcp ports < 1024 that are used by some
> process that don't show up in 'netstat -an'.
>
> My new testing with SQLHOSTS of:
>
> cxdb3 onsoctcp cxdb3.cx.claremont.edu 1530
> cxdb3lhn onipcshm localhost cxdb3lhn
> coistarcars onsoctcp cxdb3.cx.claremont.edu 1531
> scistarcars onsoctcp cxdb3.cx.claremont.edu 1532>
> [...]
>
As noted in my separate answer (still travelling, or only just arrived),
port numbers under 1024 are reserved and only a root-privileged process can
open them. You must have had the CPU VPs (which run as user informix, not
as user root) doing the listening. So it was not a question of the ports
being in use, but simply IDS did not have the privilege needed to use them.
Remapping the port numbers to values larger than 1023 should do the trick -
you confirmed that it does do the triwith this post.
--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/
-------------------------------------------------------------
This message has been scanned by Postini anti-virus software.
On Wed, Oct 14, 2009 at 15:41, Jonathan Smaby <Jonathan.Smaby@pomona.edu>wrote: > Thanks Jonathan... > > See you at I.O.D. in a couple weeks? > I should be there, barring miracles... -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/ "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." NB: Please do not use this email for correspondence. I don't necessarily read it every week, even. Marie von Ebner-Eschenbach<http://www.brainyquote.com/quotes/authors/m/marie_von_ebneresch enbac.html> - "Even a stopped clock is right twice a day." --0016364edaa8fe323e0475eceac2
Related threads
- HELP- database won't start !!
- Network driver cannot bind a name to the port.
- Solaris 8, IDSWE 7.31, WARNING: Network Down
- Error 25572 using ESQL/Cobol
- Identically named instances, different hosts