Error : 930 Cannot connect remote database

Posted in 2009

Summary

After a development server was re-imaged with a new IP and hostname (Informix 5.11 on HP-UX), remote connections via INFORMIX-STAR to production instances failed with "930: Cannot connect to database server (fieldp01)", even though /etc/hosts, hosts.equiv, .rhosts, sqlhosts and /etc/services all looked correct and rlogin/ftp worked. Suggestions included checking DNS/resolv.conf, using dbaccess/C-SDK, and verifying sqlexecd was running on the remote 5.x machines. The poster finally found nslookup failing from the production server, pointing to a DNS problem handed to the OS team (no confirmed fix posted).

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: Networking & sqlhosts Configuration, Migration, Import/Export & Data Conversion, Platform-Specific Issues

PRABAL DAS — Thu, 17 Dec 2009 11:20:56 — source: IIUG Forums & Mailing Lists

Hi, we had a migration of our development server ( thru imaging ). The O/S and informix version remains the same. Only the IP and hostname got changed. Informix 5.11 / HP-UX B.11.00 U After a little configuration change in /etc/hosts, /etc/hosts.equiv its up and running and there is no problem except -- while trying to connect from dev server to any instance on the production server using Informix STAR its failing. Earlier it was working. If I try to connect the remote database in production instance using isql dbname@<dbservername in sqlhosts> its returning 930: Cannot connect to database server (fieldp01). whereas fieldp01 is the FQN of the production server. checked all the config files /etc/hosts /etc/hosts.eqiv .rhosts sqlhosts /etc/services But nowhere I could find any old entry. All the dbservernames are listed in the sqlhosts of both the servers as well as nettype remains the same. and port numbers in services file are also remaining the same. Could it be due to some network configuration change or something else?

↪ replying to PRABAL DAS

Joerg Volz — Thu, 17 Dec 2009 12:14:38 — source: IIUG Forums & Mailing Lists

Did you check DNS Servers and the addresses returned to the client (order of DNS in /etc/resolv.conf)? Joerg Volz ------------------------------------------------------------------------ ----- -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of PRABAL DAS Sent: Thursday, December 17, 2009 12:21 PM To: ids@iiug.org Subject: Error : 930 Cannot connect remote database [18415] Hi, we had a migration of our development server ( thru imaging ). The O/S and informix version remains the same. Only the IP and hostname got changed. Informix 5.11 / HP-UX B.11.00 U After a little configuration change in /etc/hosts, /etc/hosts.equiv its up and running and there is no problem except -- while trying to connect from dev server to any instance on the production server using Informix STAR its failing. Earlier it was working. If I try to connect the remote database in production instance using isql dbname@<dbservername in sqlhosts> its returning 930: Cannot connect to database server (fieldp01). whereas fieldp01 is the FQN of the production server. checked all the config files /etc/hosts /etc/hosts.eqiv ..rhosts sqlhosts /etc/services But nowhere I could find any old entry. All the dbservernames are listed in the sqlhosts of both the servers as well as nettype remains the same. and port numbers in services file are also remaining the same. Could it be due to some network configuration change or something else? ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. IT Handel und Beratung Jorg Volz Bernhard-Fruh-Str. 7 77855 Achern GERMANY Tel: +49 (0)7841-681651 Fax: +49 (0)7841-681654 Mobil: +49 (0)170-2989757 VAT-ID: DE201383541 http://www.it-volz.de

↪ replying to Joerg Volz

PRABAL DAS — Thu, 17 Dec 2009 12:45:39 — source: IIUG Forums & Mailing Lists

/etc/resolv.conf seems to be okay ----------------------------- search us.abc.com cz.abc.com sd.abc.com abc.com net.abc.com dr.abc.com post.abc.com global.abc.com usae.abc.com abc.com nameserver 194.11.150.16 # nj300003-dns01-bb.abc.com nameserver 194.11.20.21 nameserver 194.152.7.12 domain us.abc.com --------------------------------- The full domain name of the dev server that was migrated is fieldd01.us.abc.com Earlier it was fieldd01.cz.abc.com

↪ replying to PRABAL DAS

Joerg Volz — Thu, 17 Dec 2009 13:21:23 — source: IIUG Forums & Mailing Lists

rlogin between the machines is fine in both directions? Joerg Volz ------------------------------------------------------------------------ ----- -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of PRABAL DAS Sent: Thursday, December 17, 2009 1:46 PM To: ids@iiug.org Subject: RE: Error : 930 Cannot connect remote database [18420] /etc/resolv.conf seems to be okay ----------------------------- search us.abc.com cz.abc.com sd.abc.com abc.com net.abc.com dr.abc.com post.abc.com global.abc.com usae.abc.com abc.com nameserver 194.11.150.16 # nj300003-dns01-bb.abc.com nameserver 194.11.20.21 nameserver 194.152.7.12 domain us.abc.com --------------------------------- The full domain name of the dev server that was migrated is fieldd01.us.abc.com Earlier it was fieldd01.cz.abc.com ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. IT Handel und Beratung Jorg Volz Bernhard-Fruh-Str. 7 77855 Achern GERMANY Tel: +49 (0)7841-681651 Fax: +49 (0)7841-681654 Mobil: +49 (0)170-2989757 VAT-ID: DE201383541 http://www.it-volz.de

↪ replying to Joerg Volz

PRABAL DAS — Thu, 17 Dec 2009 13:32:20 — source: IIUG Forums & Mailing Lists

Yes, rlogin and ftp is working from both the servers Thanks Prabal

↪ replying to PRABAL DAS

Joerg Volz — Thu, 17 Dec 2009 13:33:58 — source: IIUG Forums & Mailing Lists

Ok, then I am out of ideas. It´s been a long time since 5.1 and Star. Sorry. Joerg Volz ----------------------------------------------------------------------------- -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of PRABAL DAS Sent: Thursday, December 17, 2009 2:32 PM To: ids@iiug.org Subject: RE: Error : 930 Cannot connect remote database [18422] Yes, rlogin and ftp is working from both the servers Thanks Prabal ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. IT Handel und Beratung Jörg Volz Bernhard-Früh-Str. 7 77855 Achern GERMANY Tel: +49 (0)7841-681651 Fax: +49 (0)7841-681654 Mobil: +49 (0)170-2989757 VAT-ID: DE201383541 http://www.it-volz.de

↪ replying to Joerg Volz

ABDALLAH — Thu, 17 Dec 2009 18:31:35 — source: IIUG Forums & Mailing Lists

I'm not sure but I believe other clients that dbaccess must use C-SDK for connect. Try to connect with dbaccess from your client machine for valid the connection is OK. If it's true, so you must use C-SDK. syntax to connect : dbaccess database@informixserver

↪ replying to PRABAL DAS

Jonathan Leffler — Sat, 19 Dec 2009 05:12:24 — source: IIUG Forums & Mailing Lists

On Thu, Dec 17, 2009 at 03:20, PRABAL DAS <d.prabal@gmail.com> wrote: > Hi, we had a migration of our development server ( thru imaging ). The O/S > and > informix version remains the same. Only the IP and hostname got changed. > > Informix 5.11 / HP-UX B.11.00 U > > After a little configuration change in /etc/hosts, /etc/hosts.equiv its up > and > running and there is no problem except -- > > while trying to connect from dev server to any instance on the production > server using Informix STAR its failing. Earlier it was working. > > If I try to connect the remote database in production instance using > > isql dbname@<dbservername in sqlhosts> its returning > > 930: Cannot connect to database server (fieldp01).> > whereas fieldp01 is the FQN of the production server. > > checked all the config files > > /etc/hosts > /etc/hosts.eqiv > ..rhosts > sqlhosts > /etc/services > > But nowhere I could find any old entry. All the dbservernames are listed in > the sqlhosts of both the servers as well as nettype remains the same. > and port numbers in services file are also remaining the same. > > Could it be due to some network configuration change or something else? > Have you got the sqlexecd running on the remote machines? With IDS (6.00 or later), you don't need the separate daemon; with OnLine (5.x or earlier) you do. -- 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. Ogden Nash <http://www.brainyquote.com/quotes/authors/o/ogden_nash.html>; - "The trouble with a kitten is that when it grows up, it's always a cat." --000e0cd1391e9b13cf047b0de65d

↪ replying to Jonathan Leffler

PRABAL DAS — Mon, 21 Dec 2009 11:53:44 — source: IIUG Forums & Mailing Lists

Hi Joerg & all, Thanks for your input. I have just detected nslookup is failing from the production server. Most likely its a DNS issue and will be taken care by the o/s team. Prabal

Glossary

sqlhosts