RE: Informix Network Connection

Posted in 2004

Brian Minnick — Sat, 13 Mar 2004 12:25:46 -0500 — source: Usenet: comp.databases.informix

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C40920.383B4B70 Content-Type: text/plain; charset="iso-8859-1" The fourth column of your sqlhosts file for the shared memory connection should just be a unique identifier and not point to the etc/services port number. -----Original Message----- From: Thomas Ronayne [mailto:trona@REMOVETHISameritech.net] Sent: Saturday, March 13, 2004 10:03 AM To: informix-list@iiug.org Subject: Informix Network Connection I am unable to figure out how to make a network connection and would appreciate someone pointing me in the right direction. On my Slackware Linux 9.1 system, Informix Dynamic Server 7.30.U, I'm trying to get the network connection working (so I can use PHP with Informix). The shared memory connection works fine, but attempting to get the network connection started is an abject failure (and, yes, I've been through the Client/Server Communications section of the manual and I've tried everything I can think of). With onconfig entries SERVERNUM 1 # Unique id corresponding to a Dynamic Server instance DBSERVERNAME fubar_a # Name of default database server DBSERVERALIASES fubar_anet # Name of network database server NETTYPE ipcshm,1,100,CPU # Configure poll thread(s) for nettype NETTYPE soctcp,1,100,NET # Configure poll thread(s) for nettype DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env. RESIDENT 0 # Forced residency flag (Yes = 1, No = 0) and sqlhost entries fubar_a onipcshm fubar informixa fubar_anet onsoctcp fubar informixanet and /etc/services entries informixa 1625/tcp # IBM Informix 7.x engine shared informixanet 1725/tcp # IBM Informix 7.x engine network When I execute oninit the online log shows Sat Mar 13 09:38:53 2004 09:38:53 Event alarms enabled. ALARMPROG = '/opt/informix/etc/log_full.sh' 09:38:59 DR: DRAUTO is 0 (Off) 09:39:00 Informix Dynamic Server Version 7.30.U Software Serial Number AAC#A404657 09:39:00 listener-thread: err = -27100: oserr = 2: errstr = : Internal Communications Error: NSF subsystem error. System error = 2. 09:39:00 Attempting to bring listener thread down 09:39:00 PANIC: Attempting to bring system down If I comment out the DBSERVERALIASES and NETTYPE lines in onconfig, oninit starts fine and everything works as expected. Any help would be most appreciated. ------_=_NextPart_001_01C40920.383B4B70 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2654.45"> <TITLE>RE: Informix Network Connection</TITLE> </HEAD> <BODY> The fourth column of your sqlhosts file for the = shared memory connection should just be a unique identifier and not point to = the etc/services port number. -----Original Message----- From: Thomas Ronayne [<A = HREF=3D"mailto:trona@REMOVETHISameritech.net">mailto:trona@REMOVETHISame= ritech.net</A>] Sent: Saturday, March 13, 2004 10:03 AM To: informix-list@iiug.org Subject: Informix Network Connection I am unable to figure out how to make a network = connection and would appreciate someone pointing me in the right = direction. On my Slackware Linux 9.1 system, Informix Dynamic Server 7.30.U, = I'm trying to get the network connection working (so I can use PHP with = Informix). The shared memory connection works fine, but attempting to get = the network connection started is an abject failure (and, yes, = I've been through the Client/Server Communications section of the manual = and I've tried everything I can think of). With onconfig entries     = SERVERNUM       = 1           &nbsp= ;   # Unique id corresponding to a     Dynamic Server instance     DBSERVERNAME    = fubar_a         # Name of = default database server     = DBSERVERALIASES        = fubar_anet      # Name of network database = server     = NETTYPE         = ipcshm,1,100,CPU        # Configure = poll thread(s)     for nettype     = NETTYPE          &nbsp= ;     = soctcp,1,100,NET        # Configure = poll     thread(s) for nettype     DEADLOCK_TIMEOUT = 60           &nbs= p; # Max time to wait of lock in     distributed env.     = RESIDENT        = 0           &nbsp= ;   # Forced residency flag (Yes =3D 1, No     =3D 0) and sqlhost entries     = fubar_a         = onipcshm        = fubar           = informixa     = fubar_anet      = onsoctcp        = fubar           = informixanet and /etc/services entries     = informixa   &nbs

RE: Informix Network Connection

Related threads

Your privacy choices