topic ftp connection refused in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/ftp-connection-refused/m-p/311325#M264455 <HTML><HEAD></HEAD><BODY><SPAN>I thought I had A.A.A.R. all working… but something seems to have busted.</SPAN><BR /><BR /><SPAN>specifically, when attempting the AAAR_Publish.bat I am getting a problem, I believe, with uploading the reports to alfresco.</SPAN><BR /><BR /><SPAN>I've tested ftp and it is working on port 21 for user admin/admin.</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />…<BR />2014/11/04 10:28:19 - Set Variables.0 - Setting environment variables…<BR />2014/11/04 10:28:19 - Set Variables.0 - Set variable http_prpt to value [<A href="http://localhost:8081/penta" rel="nofollow noopener noreferrer">http://localhost:8081/penta</A><BR />ho/api/repo/files/:public:AAAR:Reports:audit_use.prpt]<BR />2014/11/04 10:28:19 - Set Variables.0 - Set variable http_login to value [admin]<BR />2014/11/04 10:28:19 - Set Variables.0 - Set variable http_password to value [password]<BR />2014/11/04 10:28:19 - Set Variables.0 - Set variable prpt_path to value [c:\temp\\audit_use.prpt]<BR />2014/11/04 10:28:19 - Set Variables.0 - Set variable extension to value [pdf]<BR />2014/11/04 10:28:19 - Set Variables.0 - Set variable report_regex to value [^audit_use(.+)pdf$]<BR />2014/11/04 10:28:19 - Set Variables.0 - Set variable alfresco_ftp to value [localhost]<BR />2014/11/04 10:28:19 - Set Variables.0 - Set variable alfresco_port to value [121]<BR />2014/11/04 10:28:19 - Set Variables.0 - Set variable alfresco_login to value [admin]<BR />2014/11/04 10:28:19 - Set Variables.0 - Set variable alfresco_password to value [admin]<BR />2014/11/04 10:28:19 - Set Variables.0 - Set variable alfresco_path to value [alfresco]<BR />2014/11/04 10:28:19 - Set Variables.0 - Set variable report_path to value [c:\temp\\audit_use.pdf]<BR />2014/11/04 10:28:19 - Set Variables.0 - Finished after 1 rows.<BR />2014/11/04 10:28:19 - Set Variables.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)<BR />2014/11/04 10:28:19 - Report - Starting entry [HTTP]<BR />2014/11/04 10:28:19 - HTTP - Start of HTTP job entry.<BR />2014/11/04 10:28:19 - HTTP - Connecting to URL: <A href="http://localhost:8081/pentaho/api/repo/files/:public" rel="nofollow noopener noreferrer">http://localhost:8081/pentaho/api/repo/files/:public</A><BR />:AAAR:Reports:audit_use.prpt<BR />2014/11/04 10:28:23 - HTTP - Resource type: application/vnd.pentaho.reporting.classic, last modified<BR /> on: Wed Dec 31 16:00:00 PST 1969.<BR />2014/11/04 10:28:24 - HTTP - Finished writing 77476 bytes to result file [c:\temp\\audit_use.prpt]<BR />2014/11/04 10:28:24 - Report - Starting entry [Create report]<BR />2014/11/04 10:28:24 - Create report - Dispatching started for transformation [Create report]<BR />2014/11/04 10:28:24 - Generate Rows.0 - Finished processing (I=0, O=0, R=0, W=1, U=0, E=0)<BR />2014/11/04 10:28:24 - Calculator.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)<BR />2014/11/04 10:28:24 - Select values 2.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)<BR />2014/11/04 10:28:24 - Switch / Case.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)<BR />2014/11/04 10:28:29 - Pentaho Reporting for pdf.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=<BR />0)<BR />2014/11/04 10:28:29 - Dummy (do nothing).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)<BR />2014/11/04 10:28:29 - Report - Starting entry [Delete prpt]<BR />2014/11/04 10:28:29 - Delete prpt - File [c:\temp\\audit_use.prpt] deleted!<BR />2014/11/04 10:28:29 - Report - Starting entry [Carica file con FTP]<BR />2014/11/04 10:28:29 - Carica file con FTP - Using PDIFTPClient override for exists() fix.<BR />2014/11/04 10:28:30 - Carica file con FTP - ERROR (version 5.2.0.0, build 1 from 2014-09-30_19-48-28<BR /> by buildguy) : Error putting to FTP : Connection refused: connect<BR />2014/11/04 10:28:30 - Carica file con FTP - ERROR (version 5.2.0.0, build 1 from 2014-09-30_19-48-28<BR /> by buildguy) : java.net.ConnectException: Connection refused: connect<BR />2014/11/04 10:28:30 - Carica file con FTP -&nbsp;&nbsp;&nbsp;&nbsp; at java.net.DualStackPlainSocketImpl.waitForConnect(<BR />Native Method)<BR />…<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>I've noticed the "alfresco_port to value [121]"… is that causing the problem? how can I adjust in my kitchen job?</SPAN><BR /><BR /><SPAN>thanks in advance.</SPAN></BODY></HTML> Tue, 04 Nov 2014 18:37:38 GMT rocketboy2000 2014-11-04T18:37:38Z ftp connection refused https://connect.hyland.com/t5/alfresco-archive/ftp-connection-refused/m-p/311325#M264455 I thought I had A.A.A.R. all working… but something seems to have busted.specifically, when attempting the AAAR_Publish.bat I am getting a problem, I believe, with uploading the reports to alfresco.I've tested ftp and it is working on port 21 for user admin/admin.…2014/11/04 10:28:19 - Set Variables Tue, 04 Nov 2014 18:37:38 GMT https://connect.hyland.com/t5/alfresco-archive/ftp-connection-refused/m-p/311325#M264455 rocketboy2000 2014-11-04T18:37:38Z Re: ftp connection refused https://connect.hyland.com/t5/alfresco-archive/ftp-connection-refused/m-p/311326#M264456 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>You can customize the FTP port the publish uses simply updating the AAAR_DataMart.dm_reports table.</SPAN><BR /><BR /><SPAN>As you can see here:</SPAN><BR /><SPAN>&lt;a href="</SPAN><A href="http://francescocorti.files.wordpress.com/2013/01/img20.png" rel="nofollow noopener noreferrer">http://francescocorti.files.wordpress.com/2013/01/img20.png</A><SPAN>"&gt;</SPAN><A href="http://francescocorti.files.wordpress.com/2013/01/img20.png" rel="nofollow noopener noreferrer">http://francescocorti.files.wordpress.com/2013/01/img20.png</A><SPAN>&lt;/a&gt;</SPAN><BR /><SPAN>The table has an 'alfresco_ftp' field.</SPAN><BR /><SPAN>Update that field and the port you want will be used. <span class="lia-unicode-emoji" title=":winking_face:">😉</span></SPAN></BODY></HTML> Tue, 04 Nov 2014 20:40:11 GMT https://connect.hyland.com/t5/alfresco-archive/ftp-connection-refused/m-p/311326#M264456 fcorti 2014-11-04T20:40:11Z Re: ftp connection refused https://connect.hyland.com/t5/alfresco-archive/ftp-connection-refused/m-p/311327#M264457 <HTML><HEAD></HEAD><BODY><SPAN>you rock! thanks for the info!</SPAN></BODY></HTML> Wed, 05 Nov 2014 01:12:32 GMT https://connect.hyland.com/t5/alfresco-archive/ftp-connection-refused/m-p/311327#M264457 rocketboy2000 2014-11-05T01:12:32Z