[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&amp;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&amp;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&amp;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
   [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
-----------------------------------------------------------------------