[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: FTPAPI quit working
I changed the settings on that vendor to passive mode.� Next purchase
order will be placed tomorrow.
On Tue, Nov 8, 2016 at 3:23 PM, Michael Ryan <[1]michaelrtr@xxxxxxxxx>
wrote:
Try changing passive mode with FTPAPI. I don't know the default.
Sent from my iPhone
> On Nov 8, 2016, at 3:08 PM, Jeff Crosby
<[2]jlcrosby@xxxxxxxxxxxxxxxx> wrote:
>
>� �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][3]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][4]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][5]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][6]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
>� � �� � ��� �GhlpA1wIVDd6WXFUYWorNVFaTTM5TU
pDRWY2SnF4MjJrPQ]
>� � �� � ��� �Jeff Crosby
>� � �� � ��� �VP Information Systems
>� � �� � ��� �UniPro FoodService/Dilgard
>� � �� � ��� �P.O. Box 13369
>� � �� � ��� �Ft. Wayne, IN 46868-3369
>� � �� � ��� �[2]260-422-7531
>� � �� � ��� �[3][3][5][7]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
>� � �� � ��� �GhlpA1wIVDd6WXFUYWorNVFaTTM5TU
pDRWY2SnF4MjJrPQ]
>� � �� � ��� �Jeff Crosby
>� � �� � ��� �VP Information Systems
>� � �� � ��� �UniPro FoodService/Dilgard
>� � �� � ��� �P.O. Box 13369
>� � �� � ��� �Ft. Wayne, IN 46868-3369
>� � �� � ��� �260-422-7531
>� � �� � ��� �[4][4][6][8]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][9]jlcrosby@
dilgardfoods.com
>� � �� � ��� �2. tel:[6]260-422-7531
>� � �� � ��� �3. [7][8][10]http://www.dilgardfoods.com/
>� � �� � ��� �4. [8][9][11]http://www.dilgardfoods.com/
>� � �� � �------------------------------
------------------------------
>� � �� � �-----------
>� � �� � �This is the FTPAPI mailing list.�� To
unsubscribe, please
>� � �go to:
>� � �� � �[9][10][12]http://www.scottklement.com/mailman/
listinfo/ftpapi
>� � �� � �------------------------------
------------------------------
>� � �� � �-----------
>� � �References
>� � �� �1. mailto:[11][13]jlcrosby@xxxxxxxxxxxxxxxx
>� � �� �2. mailto:[12][14]jlcrosby@xxxxxxxxxxxxxxxx
>� � �� �3. [13][15]http://www.dilgardfoods.com/
>� � �� �4. [14][16]http://www.dilgardfoods.com/
>� � �� �5. mailto:[15][17]jlcrosby@xxxxxxxxxxxxxxxx
>� � �� �6. tel:[16]260-422-7531
>� � �� �7. [17][18]http://www.dilgardfoods.com/
>� � �� �8. [18][19]http://www.dilgardfoods.com/
>� � �� �9. [19][20]http://www.scottklement.
com/mailman/listinfo/ftpapi
>� � �------------------------------
------------------------------
>� � �-----------
>� � �This is the FTPAPI mailing list.� To unsubscribe, please
go to:
>� � �[20][21]http://www.scottklement.com/mailman/listinfo/ftpapi
>� � �------------------------------
------------------------------
>� � �-----------
>
>� �--
>� �[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
>� �[22]260-422-7531
>� �[21][23]www.dilgardfoods.com
>� �The opinions expressed are my own and not necessarily the
opinion of my
>� �company.� Unless I say so.
>
> References
>
>� �1. [24]http://blahblahblah.net/
>� �2. mailto:[25]michaelrtr@xxxxxxxxx
>� �3. mailto:[26]jlcrosby@xxxxxxxxxxxxxxxx
>� �4. mailto:[27]jlcrosby@xxxxxxxxxxxxxxxx
>� �5. [28]http://www.dilgardfoods.com/
>� �6. [29]http://www.dilgardfoods.com/
>� �7. mailto:[30]jlcrosby@xxxxxxxxxxxxxxxx
>� �8. [31]http://www.dilgardfoods.com/
>� �9. [32]http://www.dilgardfoods.com/
>� 10. [33]http://www.scottklement.com/mailman/listinfo/ftpapi
>� 11. mailto:[34]jlcrosby@xxxxxxxxxxxxxxxx
>� 12. mailto:[35]jlcrosby@xxxxxxxxxxxxxxxx
>� 13. [36]http://www.dilgardfoods.com/
>� 14. [37]http://www.dilgardfoods.com/
>� 15. mailto:[38]jlcrosby@xxxxxxxxxxxxxxxx
>� 16. tel:[39]260-422-7531
>� 17. [40]http://www.dilgardfoods.com/
>� 18. [41]http://www.dilgardfoods.com/
>� 19. [42]http://www.scottklement.com/mailman/listinfo/ftpapi
>� 20. [43]http://www.scottklement.com/mailman/listinfo/ftpapi
>� 21. [44]http://www.dilgardfoods.com/
> ------------------------------------------------------------
-----------
> This is the FTPAPI mailing list.� To unsubscribe, please go to:
> [45]http://www.scottklement.com/mailman/listinfo/ftpapi
> ------------------------------------------------------------
-----------
-----------------------------------------------------------------------
This is the FTPAPI mailing list.� To unsubscribe, please go to:
[46]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
[47]www.dilgardfoods.com
The opinions expressed are my own and not necessarily the opinion of my
company.� Unless I say so.
References
1. mailto:michaelrtr@xxxxxxxxx
2. mailto:jlcrosby@xxxxxxxxxxxxxxxx
3. http://blahblahblah.net/
4. mailto:michaelrtr@xxxxxxxxx
5. mailto:jlcrosby@xxxxxxxxxxxxxxxx
6. mailto:jlcrosby@xxxxxxxxxxxxxxxx
7. http://www.dilgardfoods.com/
8. http://www.dilgardfoods.com/
9. mailto:jlcrosby@xxxxxxxxxxxxxxxx
10. http://www.dilgardfoods.com/
11. http://www.dilgardfoods.com/
12. http://www.scottklement.com/mailman/listinfo/ftpapi
13. mailto:jlcrosby@xxxxxxxxxxxxxxxx
14. mailto:jlcrosby@xxxxxxxxxxxxxxxx
15. http://www.dilgardfoods.com/
16. http://www.dilgardfoods.com/
17. mailto:jlcrosby@xxxxxxxxxxxxxxxx
18. http://www.dilgardfoods.com/
19. http://www.dilgardfoods.com/
20. http://www.scottklement.com/mailman/listinfo/ftpapi
21. http://www.scottklement.com/mailman/listinfo/ftpapi
22. tel:260-422-7531
23. http://www.dilgardfoods.com/
24. http://blahblahblah.net/
25. mailto:michaelrtr@xxxxxxxxx
26. mailto:jlcrosby@xxxxxxxxxxxxxxxx
27. mailto:jlcrosby@xxxxxxxxxxxxxxxx
28. http://www.dilgardfoods.com/
29. http://www.dilgardfoods.com/
30. mailto:jlcrosby@xxxxxxxxxxxxxxxx
31. http://www.dilgardfoods.com/
32. http://www.dilgardfoods.com/
33. http://www.scottklement.com/mailman/listinfo/ftpapi
34. mailto:jlcrosby@xxxxxxxxxxxxxxxx
35. mailto:jlcrosby@xxxxxxxxxxxxxxxx
36. http://www.dilgardfoods.com/
37. http://www.dilgardfoods.com/
38. mailto:jlcrosby@xxxxxxxxxxxxxxxx
39. tel:260-422-7531
40. http://www.dilgardfoods.com/
41. http://www.dilgardfoods.com/
42. http://www.scottklement.com/mailman/listinfo/ftpapi
43. http://www.scottklement.com/mailman/listinfo/ftpapi
44. http://www.dilgardfoods.com/
45. http://www.scottklement.com/mailman/listinfo/ftpapi
46. http://www.scottklement.com/mailman/listinfo/ftpapi
47. http://www.dilgardfoods.com/
-----------------------------------------------------------------------
This is the FTPAPI mailing list. To unsubscribe, please go to:
http://www.scottklement.com/mailman/listinfo/ftpapi
-----------------------------------------------------------------------