I an currently using a 9ir2 installed on a w2k machine.
I am having problems when attempting to access XDB via ftp using other cilents than the standard w2k ftp client.
From a linux box:
[sam@touzi sam]$ ftp portscenari03 2100
Connected to portscenari03 (192.168.2.9).
<font size="-1"><pre>
220 portscenari03 FTP Server (Oracle XML DB/Oracle9i Release 9.2.0.1.0 - Production) ready.
Name (portscenari03:sam): system
331 pass required for SYSTEM
Password:
230 SYSTEM logged in
Remote system type is Unix.
ftp> dir
227 Entering Passive Mode (9, 2, 168, 192, 9, 64)
ftp: connect: Connection timed out
ftp>
</pre></font>
XDB seems to want to turn passive mode off but it seems to be giving an inverted IP address to the client that it cannot find and times out. if one enters
<font size="-1"><pre>
ftp> passive
Passive mode off.
</pre></font>
before connecting then all goes well with the standard linux ftp client, (also OK with the ftp plugin in eclipe for example) things get a bit more tricky with other ftp clients such as ws_ftp etc where entering passive mode manually seems not possible, the result is a wait for a timeout at each server connection and in some clients a disconnect.
How come this behavior? is this a bug or an error usage on my part?
here is what happens with ws_ftp pro:
<font size="-1"><pre>
WINSOCK.DLL: WinSock 2.0
WS_FTP Pro 6.51 2000.05.15, Copyright ) 1992-2000 Ipswitch, Inc.
local chdir to C:\Home\Sam\
- -
connecting to 192.168.2.9:2100
Connected to 192.168.2.9 port 2100
220 portscenari03 FTP Server (Oracle XML DB/Oracle9i Release 9.2.0.1.0 - Production) ready.
USER system
331 pass required for SYSTEM
PASS (hidden)
230 SYSTEM logged in
PWD
257 "/" is current directory.
SYST
215 Unix Type:9.2.0.1 Version:Oracle XML DB
Host type (S): UNIX (standard)
PASV
227 Entering Passive Mode (9, 2, 168, 192, 10, 27)
connecting to 9.2.168.192:2587
- -
connecting to 9.2.168.192:2587
! Connection failed 9.2.168.192 - connection timed out
! connect: error 0
PORT 192,168,2,9,10,43
200 PORT Command successful
LIST
150 ASCII Data Connection
Received 256 bytes in 0.1 secs, (20.00 Kbps), transfer succeeded
226 ASCII Transfer Complete
QUIT
local chdir to C:\Home\Sam\
- -
connecting to 192.168.2.9:2100
Connected to 192.168.2.9 port 2100
220 portscenari03 FTP Server (Oracle XML DB/Oracle9i Release 9.2.0.1.0 - Production) ready.
USER system
331 pass required for SYSTEM
PASS (hidden)
230 SYSTEM logged in
PWD
257 "/" is current directory.
SYST
215 Unix Type:9.2.0.1 Version:Oracle XML DB
Host type (S): UNIX (standard)
PASV
227 Entering Passive Mode (9, 2, 168, 192, 9, 20)
connecting to 9.2.168.192:2324
- -
connecting to 9.2.168.192:2324
! Connection failed 9.2.168.192 - connection timed out
! connect: error 0
PORT 192,168,2,9,9,36
200 PORT Command successful
LIST
150 ASCII Data Connection
Received 256 bytes in 0.1 secs, (20.00 Kbps), transfer succeeded
226 ASCII Transfer Complete
</pre></font>