AS/400 >> 425 Not able to open data connection

by Andy M » Mon, 12 Dec 2005 09:49:29 GMT

Scenario :

1. Small LAN of 1 x 4 port hub, 1 Laptop, 1 Desktop, 1 x AS400 model
270 all connected through the hub.

2. IP address of Desktop is 192.168.0.1

3. Cable modem connected to desktop and internet connection is shared.

4. AS400 fixed to IP address 192.168.0.66

5. Laptop gets its IP address from the desktop.

6. Port mapper used to map requests for ports 20, 21, 23, 5042 to AS400

7. Re-director used to resolve external requests from internet to my
LAN when request is to "fantasyfootball.no-ip.info" ..... minus the
quotes of course. Feel free to point a 5250 emulator to this - you will
get a sign on screen.

Problem - FTP from Desktop and Laptop to AS400 works perfect. However,
external requests get connection and can log on, but PUT or GET
commands are met with "425 not able to open data connection" even when
all local firewalls are turned off.

Any ideas ?

Thanks,
Andy M.


AS/400 >> 425 Not able to open data connection

by Mark » Mon, 12 Dec 2005 17:43:35 GMT


Try sending the command SENDPASV from the client.

AS/400 >> 425 Not able to open data connection

by Andy M » Mon, 12 Dec 2005 18:53:23 GMT

Hi Mark,

Thanks for the reply. Can you expand on this for me please. I'm trying
to ftp the SERVER from a Window's client FTP (command prompt) and there
is no SENDPASV command.

AS/400 >> 425 Not able to open data connection

by 400_newbie » Mon, 12 Dec 2005 20:30:59 GMT


The issue has to do with the way FTP handles data communications, Back in
the day, when firewalling was a lower priority and NATted connections were
unknown, The ftp client would send a request to the remote host telling it
what its IP it is and an available incoming port. The server will then
initiate a connection to that port.

The problem is that the local system only knows its local address
192.168.1.x and the remote host only knows of its internet address
66.124.x.x (or whatever). So the local client is telling the remote host
'please contact me for data transfer at 192.168.1.x at port 5678" and the
remote can't connect to that.

Logins work because they occur on the same TCP session that you connected
on, data transfers do not.

The solution, and nearly every FTP server supports this, is to use PASV
mode. This forces the remote FTP to transfer on a session that the client
establishes..

do a help or remote help at the ftp prompt after being logged in to the site
to find the proper PASV command. you may need to issue it with "site quote
<command>

Chris

AS/400 >> 425 Not able to open data connection

by Mark » Mon, 12 Dec 2005 21:21:41 GMT

Try entering "quote site sendpasv" without the quotes as command.

AS/400 >> 425 Not able to open data connection

by Ren?H. Hartman » Tue, 13 Dec 2005 01:34:15 GMT

May I recommend searching the newsgroup before posting?
The issue is indeed most likely Active vs. Passive FTP. A short while
ago (two to three weeks) an almost identical question was posted and you
should be able to find it. It clearly states that MS FTP (the one that
comes with Windows) does NOT support passive mode. If you want a command
line client, use NcFTP, if you want graphical, use FileZilla. If you're
on V5R3, get 5733SC1 (free) and implement OpenSSH. You can then use
WinSCp, a PuTTY-based graphical sFTP client, or, again, FileZilla. Nice
and secure.

--
Best regards,

Ren?H. Hartman
www.hac-maarssen.nl

Similar Threads

1. FTP - 425 Data connection failed - AS/400

2. Pinout for Compaq Presario 425 modding

3. Looking for flat n loose love (Amp 425-3006-068)

4. FS 2004 and CH USB Pedals - problem not being able to release brakes

problem: I cannot get the brakes to unlock even after tweaking the
sensitivities sliders. I've already calibrated
the pedals in the control panel->game controllers utility in WinXP. I've
removed the old drivers and installed
the latest CM software from chproducts.com and still the same problem
occurs. What could be the problem?

This is what happens: I start off on the ground, press cntrl+. to release
parking brakes. Immediately after that,
the brakes kick in (as indicated in red on the bottom right of the screen).
Note it is not a differential braking
or a toe braking, it's as if the period key has been pressed down. I notice
that if I PERFECTLY align the
pedals to neutral and push down (towards me) both pedals perfectly, the
brakes release...but the moment I
take my feet off the pedals, brakes kick in again.

This doesn't happen in real life! Also is there a way to tighten the CH Yoke
and pedals? They are wayy too
loose in my opinion and I'm sure other real pilots out there knows this.

-manko lover


5. not able to run from instance home directory

6. db2advis giving errors - not able to INSERT into ADVISE_INST

This was fixed in FP9. The problem was that the userid in the rea
user'
id was being used as the explain table schema name instead of eithe
SYSTOOLS or the new -user userid. In FP8, the workaround is to ad
th
option: -* <explain table schema

E.g., If the userid is Bill and logging into userid Jim, then use
db2advis -d XX -a Jim  -i filein -* Ji

(-* is a minus sign followed by the asterisk
Note that the explain tables need to be created under the Jim schem

Dann

7. Not able to connect to db !

8. db2advis giving errors - not able to INSERT into ADVISE_INSTANCE table

I have been given the daunting task of sql query tuning. I am looking
for ways to get started with that. I am on DB2 UDB 8.2 (8.1 with Fixpak
8) on Windows. One point which I could think about starting from is the
db2 design advisor. However,  whenever I try to execute the db2advis
utility I get the following error:

C:\db_tuning>db2advis -d DB_TEST1 -user db2admin/db2admin -i
query_1.sql

Using user id as default schema name. Use -n option to specify schema

SQL1042C  An unexpected system error occurred.  SQLSTATE=58004

*************************************
*         CONTENTS OF SQLCA         *
*************************************

SQLCABC  = 136
SQLCODE  = -1042
SQLERRMC =
SQLERRP  = SQLERFME
sqlerrd[0] = 0
sqlerrd[1] = 0
sqlerrd[2] = 0
sqlerrd[3] = 0
sqlerrd[4] = 0
sqlerrd[5] = 0
SQLWARN  =
SQLSTATE = 58004
Critical SQLCODE.  Exiting db2advis ...
The insert into the ADVISE_INSTANCE table has failed.

0 solutions were evaluated by the advisor

exiting with error code [-1042]

C:\db_tuning>

I can see the table ADVISE_INSTANCE in the database, but I don't know
what is preventing the db2advis utility from inserting the rows in that
table.

The db2diag.log has the following information:

2005-04-20-13.19.42.875000-240 E2119721H402       LEVEL: Error
PID     : 2816                 TID  : 2836        PROC : db2advis.exe
INSTANCE: DB2                  NODE : 000
APPID   : *LOCAL.DB2.050420171942
FUNCTION: DB2 UDB, User Application, User Function, probe:0
DATA #1 : String, 22 bytes
Design Advisor Message
DATA #2 : String, 48 bytes

***   Error at line 1362, in file db2advio.SQC

2005-04-20-13.19.42.875000-240 E2120125H401       LEVEL: Error
PID     : 2816                 TID  : 2836        PROC : db2advis.exe
INSTANCE: DB2                  NODE : 000
APPID   : *LOCAL.DB2.050420171942
FUNCTION: DB2 UDB, User Application, User Function, probe:0
DATA #1 : String, 22 bytes
Design Advisor Message
DATA #2 : String, 47 bytes

***   Error at line 945, in file db2advis.SQC

2005-04-20-13.19.42.890000-240 E2120528H402       LEVEL: Error
PID     : 2816                 TID  : 2836        PROC : db2advis.exe
INSTANCE: DB2                  NODE : 000
APPID   : *LOCAL.DB2.050420171942
FUNCTION: DB2 UDB, User Application, User Function, probe:0
DATA #1 : String, 22 bytes
Design Advisor Message
DATA #2 : String, 48 bytes

***   Error at line 1396, in file db2advis.SQC

2005-04-20-13.19.42.890000-240 E2120932H404       LEVEL: Error
PID     : 2816                 TID  : 2836        PROC : db2advis.exe
INSTANCE: DB2                  NODE : 000
APPID   : *LOCAL.DB2.050420171942
FUNCTION: DB2 UDB, User Application, User Function, probe:0
DATA #1 : String, 22 bytes
Design Advisor Message
DATA #2 : String, 50 bytes

***   Error at line 2456, in file db2advmisc.SQC

2005-04-20-13.19.42.906000-240 E2121338H367       LEVEL: Error
PID     : 2816                 TID  : 2836        PROC : db2advis.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, User Application, User Function, probe:0
DATA #1 : String, 22 bytes
Design Advisor Message
DATA #2 : String, 48 bytes

Any help would be much appreciated.

regards,
dotyet