[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: FTPAPI quit working
I made this script:
dilgard <password>� � � � � � � � � � � � � � � sendepsv 0 � � � � � � � � � � � � � � � � � �� cwd In � � � � � � � � � � � � � � � � � � � �� namefmt 1 � � � � � � � � � � � � � � � � � � � put //UserFolders/PurchaseOrders/PO02376452.csv
quit � � � � � � � � � � � � � � � � � � � � �� which gave me these result messages:
Output redirected to a file. � � � � � � � � � � � � � � � � � � � � � � � � � �� Input read from specified override file. � � � � � � � � � � � � � � � � � � � �� Connecting to host�[1]blahblahblah.net�at address 111.222.333.444
using port 21.
220 blahblahblah, Inc. FTP Server � � � � � � � � � � � � � � � � � � � � � � � � �� Enter login ID (jeff): � � � � � � � � � � � � � � � � � � � � � � � � � � � � �� 331 Password required for dilgard. � � � � � � � � � � � � � � � � � � � � � � �� 230 User logged in. � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � Windows_NT � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �� Enter an FTP subcommand. � � � � � � � � � � � � � � � � � � � � � � � � � � � �� > sendepsv 0 � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �� SENDEPSV is off. � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �� Enter an FTP subcommand. � � � � � � � � � � � � � � � � � � � � � � � � � � � �� > cwd In � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �� 250 CWD command successful. � � � � � � � � � � � � � � � � � � � � � � � � � � � Enter an FTP subcommand. � � � � � � � � � � � � � � � � � � � � � � � � � � � �� > namefmt 1 � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � 500 'SITE NAMEFMT 1': command not understood � � � � � � � � � � � � � � � � � �� Client NAMEFMT is 1. � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �� Enter an FTP subcommand. � � � � � � � � � � � � � � � � � � � � � � � � � � � �� > put //UserFolders/PurchaseOrders/PO02376452.csv � � � � � � � � � � � 227 Entering Passive Mode (206,71,212,2,221,48). � � � � � � � � � � �� 125 Data connection already open; Transfer starting. � � � � � � � � �� 226 Transfer complete. � � � � � � � � � � � � � � � � � � � � � � � �� � �326 bytes transferred in 0.015 seconds. Transfer rate 22.255
KB/sec.
Enter an FTP subcommand. � � � � � � � � � � � � � � � � � � � � � � �� > quit � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �� 221 Goodbye.
I then used FileZilla and "saw" it in their In directory.� Within a
few minutes it disappeared, meaning they processed it.� I sent an
email and am waiting to hear all is well with the file.
But that proves that it can be sent from the IBM i.
On Tue, Nov 8, 2016 at 2:17 PM, Michael Ryan <[2]michaelrtr@xxxxxxxxx>
wrote:
� �Can you use FTP from the i command line? Try that, and if you
can't
� �connect, try setting (or unsetting) passive mode.
� �On Tue, Nov 8, 2016 at 1:51 PM, Jeff Crosby
� �<[1][3]jlcrosby@xxxxxxxxxxxxxxxx> wrote:
� � �� �Forgot to add one thing.
� � �� �There is a 3rd place we use FTPAPI.�� We FTP files
to a couple
� � �of
� � �� �workstations on the LAN (i.e., inside the firewall)
and that
� � �works.
� � �� �On Tue, Nov 8, 2016 at 1:12 PM, Jeff Crosby
� � �� �<[1][2][4]jlcrosby@xxxxxxxxxxxxxxxx> wrote:
� � �� �All,
� � �� �IBM i 7.1, up to date on PTFs.
� � �� �We've been using FTPAPI for 8+ years for 2 purposes:
� � �� �1) FTP purchase orders to a single vendor several
times per
� � �week
� � �� �2) FTP a sales report once a week to a totally
unrelated vendor
� � �� �Starting last Wednesday, the FTPing of those purchase
orders
� � �stopped
� � �� �working.�� What happens is the connection is made,
sign on
� � �occurs, and
� � �� �when the "STOR" command is issued, it just stops. �It
� � �literally sat
� � �� �there from 8:12am to almost 5pm.�� The reason I saw
it is that
� � �it
� � �� �started interfering with end-of-day activities.
� � �� �Here is the IBM i joblog of a retry attempt of mine:
� � �� �Job . . : �� JLCROSBYC1 �� �User . . : �� JEFF
�� �� �
� � ��� �Number .
� � �� �. . : �� 170213
� � �� ��� �� �� �� �� �� �� �� �� �� �� �� �� �� �� �
� � ��� �� �� �� �� �� �� � � � �� ��� �� �� �� �� �� �� �� �� �� �� �� �� �� � � �� �3>> PO09 VNDNR(02378) WEEK(44) DIGIT(1) POSTYLE(*DOT)
�� �
� � ��� �� �� � � � �� ��� �� �� �� �� � � �� ��� �� �� �143 - CALL PGM(PO09) �� �� �� �� �/* The
� � �CALL command
� � �� �contains parameters
� � �� ��� �� �� */ �� �� �� �� �� �� �� �� �� �� �� �
� � ��� �� �� �� �� �� �� � � � �� ��� �� �� �� �� �� �� �� �� �� �� �� �� � � � �� ��� �� Object PO02378441 in QTEMP type *FILE
created. �� �
� � ��� �� �� � � � �� ��� �� �� �� �� �� � � � �� ��� �� 1 objects duplicated. �� �� �� �� �� �� �� �
� � ��� �� �� �� �� � � � �� ��� �� �� �� �� �� �� �� �� �� �� � � �� ��� �� Ownership of object QCPEXTEMPS in QTEMP type
*USRSPC
� � �changed. � � � �� ��� �� �� �� � � �� ��� �� Ownership of object QACP170213 in QTEMP type
*USRSPC
� � �changed. � � � �� ��� �� �� �� � � �� ��� �� Ownership of object QACEXFLD12 in QTEMP type
*USRSPC
� � �changed. � � � �� ��� �� �� �� � � �� ��� �� Ownership of object Q4T9TT02 in QTEMP type
*FILE
� � �changed. �� � � � �� ��� �� �� �� �� � � �� ��� �� All records copied from file PO02378441 in
QTEMP. �
� � ��� �� �� � � � �� ��� �� �� �� �� �� � � �� ��� �� Object changed. �� �� �� �� �� �� �� �� �� �
� � ��� �� �� �� �� � � � �� ��� �� �� �� �� �� �� �� �� �� �� �� � � �� ��� �� Object changed. �� �� �� �� �� �� �� �� �� �
� � ��� �� �� �� �� � � � �� ��� �� �� �� �� �� �� �� �� �� �� �� � � �� ��� �� Object PO02378441 in QTEMP type *FILE
deleted. �� �
� � ��� �� �� � � � �� ��� �� �� �� �� �� � � � �� ��� �� 0: FTPAPI version 2.2 released on 2005-09-20
�� �
� � ��� �� �� �� � � � �� ��� �� �� �� �� �� � � � �� ��� �� �0: 220 **********, Inc. FTP Server �� �� �� �� � � � �� ��� �� �0: > USER dilgard �� �� �� �� �� �� �� �� �
� � ��� �� �� � � � �� ��� �� �0: 331 Password required for dilgard. �� �� � � � �� ��� �� �0: > PASS ********** �� �� �� �� �� �� �� �
� � ��� �� �� � � �� ��� �� �0: 230 User logged in. �� �� �� �� �� �� �
� � ��� �� �� � � �� ��� �� �0: > CWD In �� �� �� �� �� �� �� �� �� �
� � ��� �� �� �� �� � � � �� ��� �� �0: 250 CWD command successful. �� �� �� �� �� � � � �� � � �� ��� �� �0: > TYPE I �� �� �� �� �� �� �� �� �� �
� � ��� �� �� �� �� � � � �� ��� �� �0: 200 Type set to I. �� �� �� �� �� �� �� �
� � ��� �� � � � �� ��� �� �0: > PORT 192,168,0,1,74,7 �� �� �� �� �� �
� � ��� �� � � �� ��� �� �0: 200 PORT command successful. �� �� �� �� �� � � � �� ��� �� �0: > STOR PO02378441.csv �� �� �� �� �� �� �
� � ��� �� � � �� ��� �� �0: 150 Opening BINARY mode data
connection.
� � �� �and that's it.�� That was last Wednesday.�� The
WRKACTJOB
� � �display of
� � �� �that job is this:
� � �� ��� �� �� �� �� �� �� �� �� �� � Current �� �� �
� � ��� �� �� �� �� �� � � � �� ��� �� �� �� �� �� �� �� �� � � � �� ��Opt �Subsystem/Job �User �� �� �� �Type � CPU % � � � �Function �� � � � �� ��� �Status
� � �� ��� �� �� �� JLCROSBYC1 �� JEFF �� �� �� �INT �� �� � � � �.0 �CMD-PO09 � � � �� ��� �� �� TIMW� � � �� �The help text for status TIMW says:
� � �� �TIMW �� �� �� �� �� �� �� �� �� �� �� �� �� �
� � ��� �� �� �� �� �� �� � � � �� ��� � � �� ��� �� The initial thread of the job is waiting for
a� � � �� ��� �� time interval to end.
� � �� �What the IBM i job does is 1) build a file in library
QTEMP, 2)
� � �copy
� � �� �that file to the IFS as a .csv file, and 3) FTP that
.csv file
� � �to the
� � �� �vendor.
� � �� �We successfully sent one Tuesday morning (the day
before) from
� � �the IBM
� � �� �i.
� � �� �Tuesday night the firmware was updated in the Meraki
MX60
� � �router.�� So
� � �� �that was the first place we thought of.�� But�I
copied the
� � �.csv file
� � �� �to my desktop and was able to send it via FileZilla
through
� � �that same
� � �� �router.
� � �� �The once a week sales report gets FTP'ed on
Fridays.�� It also
� � �failed,
� � �� �but at least the joblog had this: �"425 Unable to
build data
� � �� �connection: Connection refused".�� I copied that
file to my PC
� � �and was
� � �� �able to send it via FileZilla as well.
� � �� �We upgraded to FTPAPI 2.3 and it still fails.�� The
IBM i was
� � �rebooted
� � �� �Saturday as part of a SAVE 21 and it still fails. � (Not that I
� � �think
� � �� �reboots help the IBM i like it does Windows.)
� � �� �We send/receive files from/to the IBM i via FTP every
day and
� � �every
� � �� �night.�� The ONLY ones failing are those being sent
via
� � �FTPAPI.
� � �� �Any suggestions?
� � �� �Thanks.
� � �� �--
� � �� �[uc?export=download&id=
0B0OlGhlpA1wISUpiZ2FfSGYxb28&
� � �amp;revid=0B0Ol
� � �� �GhlpA1wIVDd6WXFUYWorNVFaTTM5TUpDRWY2SnF4MjJrPQ]
� � �� �Jeff Crosby
� � �� �VP Information Systems
� � �� �UniPro FoodService/Dilgard
� � �� �P.O. Box 13369
� � �� �Ft. Wayne, IN 46868-3369
� � �� �[2]260-422-7531
� � �� �[3][3][5]www.dilgardfoods.com
� � �� �The opinions expressed are my own and not necessarily
the
� � �opinion of my
� � �� �company.�� Unless I say so.
� � �� �--
� � �� �[uc?export=download&id=
0B0OlGhlpA1wISUpiZ2FfSGYxb28&
� � �amp;revid=0B0Ol
� � �� �GhlpA1wIVDd6WXFUYWorNVFaTTM5TUpDRWY2SnF4MjJrPQ]
� � �� �Jeff Crosby
� � �� �VP Information Systems
� � �� �UniPro FoodService/Dilgard
� � �� �P.O. Box 13369
� � �� �Ft. Wayne, IN 46868-3369
� � �� �260-422-7531
� � �� �[4][4][6]www.dilgardfoods.com
� � �� �The opinions expressed are my own and not necessarily
the
� � �opinion of my
� � �� �company.�� Unless I say so.
� � �References
� � �� �1. mailto:[5][7]jlcrosby@xxxxxxxxxxxxxxxx
� � �� �2. tel:[6]260-422-7531
� � �� �3. [7][8]http://www.dilgardfoods.com/
� � �� �4. [8][9]http://www.dilgardfoods.com/
� � �------------------------------------------------------------
� � �-----------
� � �This is the FTPAPI mailing list.� To unsubscribe, please
go to:
� � �[9][10]http://www.scottklement.com/mailman/listinfo/ftpapi
� � �------------------------------------------------------------
� � �-----------
References
� �1. mailto:[11]jlcrosby@xxxxxxxxxxxxxxxx
� �2. mailto:[12]jlcrosby@xxxxxxxxxxxxxxxx
� �3. [13]http://www.dilgardfoods.com/
� �4. [14]http://www.dilgardfoods.com/
� �5. mailto:[15]jlcrosby@xxxxxxxxxxxxxxxx
� �6. tel:[16]260-422-7531
� �7. [17]http://www.dilgardfoods.com/
� �8. [18]http://www.dilgardfoods.com/
� �9. [19]http://www.scottklement.com/mailman/listinfo/ftpapi
------------------------------------------------------------
-----------
This is the FTPAPI mailing list.� To unsubscribe, please go to:
[20]http://www.scottklement.com/mailman/listinfo/ftpapi
------------------------------------------------------------
-----------
--
[uc?export=download&id=0B0OlGhlpA1wISUpiZ2FfSGYxb28&revid=0B0Ol
GhlpA1wIVDd6WXFUYWorNVFaTTM5TUpDRWY2SnF4MjJrPQ]
Jeff Crosby
VP Information Systems
UniPro FoodService/Dilgard
P.O. Box 13369
Ft. Wayne, IN 46868-3369
260-422-7531
[21]www.dilgardfoods.com
The opinions expressed are my own and not necessarily the opinion of my
company.� Unless I say so.
References
1. http://blahblahblah.net/
2. mailto:michaelrtr@xxxxxxxxx
3. mailto:jlcrosby@xxxxxxxxxxxxxxxx
4. mailto:jlcrosby@xxxxxxxxxxxxxxxx
5. http://www.dilgardfoods.com/
6. http://www.dilgardfoods.com/
7. mailto:jlcrosby@xxxxxxxxxxxxxxxx
8. http://www.dilgardfoods.com/
9. http://www.dilgardfoods.com/
10. http://www.scottklement.com/mailman/listinfo/ftpapi
11. mailto:jlcrosby@xxxxxxxxxxxxxxxx
12. mailto:jlcrosby@xxxxxxxxxxxxxxxx
13. http://www.dilgardfoods.com/
14. http://www.dilgardfoods.com/
15. mailto:jlcrosby@xxxxxxxxxxxxxxxx
16. tel:260-422-7531
17. http://www.dilgardfoods.com/
18. http://www.dilgardfoods.com/
19. http://www.scottklement.com/mailman/listinfo/ftpapi
20. http://www.scottklement.com/mailman/listinfo/ftpapi
21. http://www.dilgardfoods.com/
-----------------------------------------------------------------------
This is the FTPAPI mailing list. To unsubscribe, please go to:
http://www.scottklement.com/mailman/listinfo/ftpapi
-----------------------------------------------------------------------