Daily Log for #alfresco IRC Channel

Alfresco discussion and collaboration. Stick around a few hours after asking a question.

Official support for Enterprise subscribers: support.alfresco.com.

Joining the Channel:

Join in the conversation by getting an IRC client and connecting to #alfresco at Freenode. Our you can use the IRC web chat.

More information about the channel is in the wiki.

Getting Help

More help is available in this list of resources.

Daily Log for #alfresco

2017-07-06 06:21:32 GMT <joyson> Hi, I want to remove few of the components from alfresco install, These are the components which are present in alfresco community javaalfresco, postgres, alfrescosharepoint, alfrescowcmqs, alfrescogoogledocs, libreofficecomponent what are the components required for alfresco to work properly ?

2017-07-06 07:41:09 GMT <marsjk> f

2017-07-06 07:49:23 GMT <yreg> joyson, Alfresco is mandatory, you will need java if you do not have a Java8 JVM present on your system, you will need postgres if you do not have a DB server accessible from your system, you will need the libreoffice if you count on previewing office documents in share, you will need imagemagic if you need to have thumbnail images for documents, you will need the sharepoint thing if you count on editing office documents online, you will need

2017-07-06 07:49:23 GMT <yreg> alfresco google docs integration if want to edit documents in google docs, alfrescowcmqs that is something I have never tried even though I have been working with alfresco for 3 years now

2017-07-06 07:49:45 GMT <yreg> and judging from the names you provided, you might want to switch to a newer alfresco

2017-07-06 08:21:57 GMT <fwu> hi all!

2017-07-06 08:37:54 GMT <iblanco> Hi everyone.

2017-07-06 08:39:05 GMT <iblanco> I've found a bug in Alfresco's patched freemarker version with js_string escaping

2017-07-06 08:39:30 GMT <iblanco> Are those patched version's source code available in the SVN server?

2017-07-06 08:39:52 GMT <iblanco> I need to "patch" the patched version

2017-07-06 08:40:04 GMT <iblanco> Anyone any experience with this.

2017-07-06 08:40:05 GMT <iblanco> ?

2017-07-06 08:42:19 GMT <yreg> iblanco, sounds hacky²

2017-07-06 08:42:20 GMT <Tichodroma> iblanco: which file is affected?

2017-07-06 08:43:12 GMT <yreg> iblanco, try applying thhis patch to freemarker 2.3.20 source code : https://svn.alfresco.com/repos/alfresco-open-mirror/alfresco/HEAD/root/projects/3rd-party/src/freemarker-2.3.20-patched.diff

2017-07-06 08:47:29 GMT <joyson> thanks yreg

2017-07-06 08:53:37 GMT <iblanco> Thanks yreg and Tichodroma but finally I found that although there is a bug I don't have to patch it because the use os js_string seems to be incorrect

2017-07-06 08:54:08 GMT <iblanco> Just in case you are curious the trouble is with Workflow url generation in document-details page.

2017-07-06 08:54:38 GMT <iblanco> It is being generated as: <a href="${siteURL("workflow-details?workflowId=" + workflow.id?js_string + "&nodeRef=" + (args.nodeRef!"")?js_string)}">

2017-07-06 08:54:54 GMT <iblanco> but I think it should be: <a href="${siteURL("workflow-details?workflowId=" + workflow.id?url + "&nodeRef=" + (args.nodeRef!"")?url)}">

2017-07-06 08:55:31 GMT <Tichodroma> how do these two functions differ on a nodeRef?

2017-07-06 08:55:54 GMT <iblanco> Tichodroma a lot

2017-07-06 08:56:05 GMT <Tichodroma> tell me :)

2017-07-06 08:56:33 GMT <yreg> Tichodroma, escaping is different

2017-07-06 08:56:40 GMT <iblanco> js_string: workspace:\/\/SpacesStore\/2a5b6f52-90e8-442a-89ff-d69cd9e8151f

2017-07-06 08:56:46 GMT <yreg> url encoding VS js encoding

2017-07-06 08:56:57 GMT <iblanco> url: nodeRef=workspace%3A%2F%2FSpacesStore%2F2a5b6f52-90e8-442a-89ff-d69cd9e8151f

2017-07-06 08:57:14 GMT <Tichodroma> I think you are correct, thanks

2017-07-06 08:57:15 GMT <iblanco> this is part of an url so it should be url encoded

2017-07-06 08:57:34 GMT <iblanco> url_path seems even a better option but this built-in is not available in freemarker 2.3.20

2017-07-06 08:58:04 GMT <iblanco> not only I think it is not correct but it causes issues with current versions of tomcat

2017-07-06 08:58:21 GMT <iblanco> \ is a forbidden char in a url

2017-07-06 08:58:53 GMT <iblanco> it must be encoded so when js_string adds the \ it causes issues if you have a security patched tomcat (for example Debian 8-s tomcat)

2017-07-06 08:59:06 GMT <iblanco> besides that js_string is not working as advertised

2017-07-06 08:59:30 GMT <iblanco> it should only escape / if it can not assure that it is not right behgin a "<" char.

2017-07-06 08:59:49 GMT <iblanco> But it might be a bug in Alfresco's patched version

2017-07-06 09:02:24 GMT <yreg> iblanco, no, it is supposed to generate escaped string content to be used in javascript objects respecting the Java Script Object Notation

2017-07-06 09:03:13 GMT <yreg> the only problem I see with it, is that it does not escape CR to \n or \r or \n\r

2017-07-06 09:04:10 GMT <iblanco> yreg: Yes, that's the use of js_string but the freemarker's documentation is quite clear about what it should do: http://freemarker.org/docs/ref_builtins_string.html#ref_builtin_js_string

2017-07-06 09:04:10 GMT <alfbot> Title: Built-ins for strings - Apache FreeMarker Manual (at freemarker.org)

2017-07-06 09:05:23 GMT <iblanco> In fact I'm not sure why it should escape / at all. Is / a special char in js literals? I wouldn't say so.

2017-07-06 09:07:51 GMT <AFaust> iblanco: There also is a Tomcat safeguard against the use of %2F in the URL path. So using ?url on a NodeRef to construct an URL path will result in issues as well. ?url on a NodeRef is only safe for URL parameters, though technically encoding / isn't even necessary there are all

2017-07-06 09:09:40 GMT <AFaust> js_string is only ever relevant if you really do generate JS code via FTL... I have used it myself about 0 times in 8 years...

2017-07-06 09:10:36 GMT <iblanco> AFAUST: %2F does not seems to create an issue in Debian 8's security patche tomcat version

2017-07-06 09:10:44 GMT <iblanco> Are you sure it is an issue?

2017-07-06 09:11:08 GMT <AFaust> Don't know what kind of patched Tomcat version Debian uses...

2017-07-06 09:12:01 GMT <AFaust> I am referring to http://tomcat.apache.org/security-6.html#Fixed_in_Apache_Tomcat_6.0.10

2017-07-06 09:12:02 GMT <alfbot> Title: Apache Tomcat® - Apache Tomcat 6 vulnerabilities (at tomcat.apache.org)

2017-07-06 09:12:46 GMT <AFaust> As far as I am aware this is still in place with Tomcat 8

2017-07-06 09:13:50 GMT <AFaust> So by default if Tomcat encounteres an encoded slash / backslash in the URL path it will reject to process the request

2017-07-06 09:15:13 GMT <iblanco> Could it refer just to the path but not the parameters?

2017-07-06 09:16:07 GMT <iblanco> I mean: /share/page%2Fwhatever is wrong but /share/page/whateer?myparam=%2F is right

2017-07-06 09:16:44 GMT <iblanco> I'll take a look in your linkgs

2017-07-06 09:19:48 GMT <iblanco> AFaust: The options that allow overriding the %2F limitation in tomcat always refer just to path delimiters so I think that the limitation applies only in the URL's path, not the parameters

2017-07-06 09:20:15 GMT <AFaust> That's what I said...

2017-07-06 09:20:53 GMT <AFaust> But again, in the URL parameters encoding a slash is not relevant anymore because you have left the path segment behind where / has a special meaning

2017-07-06 09:22:23 GMT <iblanco> a ok, sorry didn't understand your initial point right.

2017-07-06 09:42:58 GMT <fwu> ppl, can you give me your opinion about the following requirement?

2017-07-06 09:43:18 GMT <fwu> Imagine I have a workflow where I will associate invoices with document and workflow porperties live invoice amount, supplier, etc. What would be the best approach to get, for instance, a list of the amount in debt for each supplier by month?

2017-07-06 09:43:38 GMT <fwu> This seems more related with statistics and I dont know if a search to the repository based on the property values would perform well for this goal. Should I create a support sql table for this, or maybe use something like pentaho and maybe fcorti AARS?

2017-07-06 09:43:59 GMT <fwu> What is your opinion?

2017-07-06 09:44:07 GMT <fcorti> AAAR => Alflytics :-P

2017-07-06 09:44:50 GMT <fwu> fcorti, do you think Alflytics would be the best approach for this requirement?

2017-07-06 09:45:16 GMT <fwu> when someone ask me about this requirements I see it more as an ERP domain

2017-07-06 09:45:35 GMT <fwu> but sometimes customers dont have and dont want ERP

2017-07-06 09:45:43 GMT <fwu> like SAP, etc

2017-07-06 09:46:26 GMT <fcorti> fwu the real question I suggest to think about is the following

2017-07-06 09:46:39 GMT <fcorti> do you think you will need a BI environemnt?

2017-07-06 09:46:43 GMT <fcorti> I mean:ù

2017-07-06 09:47:36 GMT <fcorti> if your use case requires a single report (or query) and you are (quite sure) you will not require nothing more => go to a "hand made query" and report

2017-07-06 09:47:42 GMT <fwu> just for this I dont think so. But that doesnt mean they will not need it in the future...

2017-07-06 09:48:14 GMT <iblanco> In my experience trying to solve this kind of issues by searching and adding in the repo is usually a quite ugly thing and prone to issues. I don't usually like it a all. As you already pointed solving this issues does not seems like a requirement for a content manager but an ERP or relational databse. If AlfLytics is overkill for you I would think about the database table option.

2017-07-06 09:48:19 GMT <fwu> but a report inside Alfresco of this kind can be just based on a simple query to the model?

2017-07-06 09:48:32 GMT <fcorti> if you feel like in the future your customer will require others reporting/extrctions/aggregations... pay attention, you are reinventing the wheel

2017-07-06 09:49:07 GMT <fwu> fcorti, yes... thats right

2017-07-06 09:49:26 GMT <fwu> iblanco I think like you... so Im between a table and pentaho :)

2017-07-06 09:49:42 GMT <iblanco> To start with you should use transactional metadata queries to make sure that you get all the results, be careful with permissions and with result limits etc...

2017-07-06 09:50:08 GMT <iblanco> so I wouldn't do it in the repo. I have already done that mistake various times...

2017-07-06 09:50:40 GMT <fwu> iblanco, I was thinking a custom table created inside the Alfresco database

2017-07-06 09:50:50 GMT <iblanco> The table approach is not sweet either because you must someone detect when things are deleted or updated etc. but I think is a better option

2017-07-06 09:51:06 GMT <fwu> yes, I know I need to control that

2017-07-06 09:51:07 GMT <iblanco> fwu: I wouldn't pollute alfresco's databse create a new one

2017-07-06 09:51:41 GMT <fwu> iblanco, if I can yes. I dont have sure if I will be able to use another database... lets see

2017-07-06 09:51:54 GMT <fcorti> ...and you are landing on the Alflytics approach. ;-)

2017-07-06 09:52:08 GMT <fwu> fcorti, yes, indeed!

2017-07-06 09:53:03 GMT <fwu> fcorti, can I "easily" set my own queries using AAAR?

2017-07-06 09:53:32 GMT <fcorti> There isn't a precise limit within you ca say "let's have a customized approach" or "let's go with another solution"... and this is where our creativity as developer should help

2017-07-06 09:53:44 GMT <fwu> for this requirement the query would be based in the repo right? but in an "off-line mode"or somehting?

2017-07-06 09:54:13 GMT <fcorti> With AAAR/Alflytics you can analyze ALL the data that are extracted into the warehouse... this is the REAL limitation

2017-07-06 09:54:16 GMT <fcorti> queries...

2017-07-06 09:54:16 GMT <fwu> and a table would be populated from this data...

2017-07-06 09:54:20 GMT <fcorti> dashboards...

2017-07-06 09:54:22 GMT <fcorti> reports...

2017-07-06 09:54:25 GMT <fcorti> pivonting...

2017-07-06 09:54:37 GMT <fcorti> everything is doable... if you have the data

2017-07-06 09:54:45 GMT <fwu> ah!ok, so what is extracted is document properties and workflow properties? is that right?

2017-07-06 09:54:51 GMT <fcorti> yesp

2017-07-06 09:55:12 GMT <fwu> ok, once with the data then it comes pentaho features

2017-07-06 09:55:30 GMT <fcorti> exactly... let's use the sowftware for the reason they are developed

2017-07-06 09:55:35 GMT <fcorti> Pentaho = BI

2017-07-06 09:55:46 GMT <fwu> well, I believe I must try AAAR first.

2017-07-06 09:55:52 GMT <fcorti> http://fcorti.com/alfresco-audit-analysis-reporting/aaar-data-marts/

2017-07-06 09:55:56 GMT <alfbot> Title: A.A.A.R. data marts - Francesco Corti (at fcorti.com)

2017-07-06 09:56:12 GMT <fcorti> I suggest you to go through Alflytics

2017-07-06 09:56:21 GMT <fwu> one thing I have sure, if not for this use case, there will be additional uses cases in the future that will need it

2017-07-06 09:56:43 GMT <fcorti> But be aware that it requires time to make it work for the first time...

2017-07-06 09:56:45 GMT <fwu> ok, thnak yuo fcorti and iblanco

2017-07-06 09:56:57 GMT <fwu> I will read a little about it

2017-07-06 09:57:04 GMT <fcorti> It's all open source and custoimizable in extractions

2017-07-06 09:57:10 GMT <fwu> nice!

2017-07-06 09:57:18 GMT <fcorti> reporting

2017-07-06 09:57:25 GMT <fcorti> EVERYTHING

2017-07-06 09:58:04 GMT <fcorti> PLease consider this: http://fcorti.com/alflytics/#alflyticsEarlyAccessProgram

2017-07-06 09:58:07 GMT <alfbot> Title: Alflytics - The Open Source Business Intelligence solution over Alfresco - Francesco Corti (at fcorti.com)

2017-07-06 10:02:55 GMT <fwu> fcorti, so Alflytics is the last version of AAAR, right?

2017-07-06 10:03:14 GMT <fcorti> Alflytics = AAAR 5.0

2017-07-06 10:03:38 GMT <fcorti> It is in Early Access version and I'm lloking for uses cases and test to declare it stable

2017-07-06 10:03:44 GMT <fwu> ok, and I can use it in Alfresco >= 5 only?

2017-07-06 10:03:58 GMT <fcorti> everything is exaplained in the link I shared

2017-07-06 10:04:05 GMT <fcorti> Alflytics => Alfresco 5.2 +

2017-07-06 10:04:19 GMT <fcorti> it uses the latest REST api... ;-)

2017-07-06 10:04:57 GMT <fwu> ok, im using 5.2. Although I also need it in 4.2.f, but maybe for this I will use a table :)

2017-07-06 10:05:11 GMT <fwu> because soon I will then ,igrate to 5.2

2017-07-06 10:05:16 GMT <fwu> migrate

2017-07-06 10:05:21 GMT <fwu> so, yes, I will try it

2017-07-06 10:05:34 GMT <fcorti> you can also have a "incremental" approach

2017-07-06 10:05:46 GMT <fcorti> Starting with table and custom management on 4.2

2017-07-06 10:05:56 GMT <fcorti> then you can put Pentaho on top of the custom table...

2017-07-06 10:06:13 GMT <fcorti> And you will gain a lot of time to develop reporting and analytics

2017-07-06 10:06:18 GMT <fwu> yes. but I need to go for the 2 at the same time :)

2017-07-06 10:06:32 GMT <fwu> because they are different projects/customers

2017-07-06 10:06:39 GMT <fcorti> ok, fair enough :-P

2017-07-06 10:06:57 GMT <fwu> I will start intalling it today

2017-07-06 10:07:00 GMT <fwu> installing

2017-07-06 10:07:16 GMT <fwu> I never used pentaho, so I will read about it first

2017-07-06 10:07:32 GMT <fcorti> I will happy if you will share a feedback... good or bad it's relevant

2017-07-06 10:07:44 GMT <fcorti> Let me share a couple of links

2017-07-06 10:08:11 GMT <fcorti> http://fcorti.com/2016/12/05/install-pentaho-business-analytics-platform-7/

2017-07-06 10:08:11 GMT <fwu> fcorti, dont worry, I will

2017-07-06 10:08:11 GMT <alfbot> Title: How to install Pentaho Business Analytics platform 7 - Francesco Corti (at fcorti.com)

2017-07-06 10:08:27 GMT <fcorti> http://fcorti.com/2016/12/05/installing-pentaho-data-integration-7/

2017-07-06 10:08:28 GMT <alfbot> Title: How to install Pentaho Data Integration 7 (aka Kettle) - Francesco Corti (at fcorti.com)

2017-07-06 10:08:53 GMT <fcorti> https://github.com/fcorti/Alflytics/blob/master/documentation/Alflytics-Manual.pdf

2017-07-06 10:08:54 GMT <alfbot> Title: Alflytics/Alflytics-Manual.pdf at master · fcorti/Alflytics · GitHub (at github.com)

2017-07-06 10:09:29 GMT <fcorti> Please be aware that yreg developed a collection of containers for docker with Pentaho + Alflytics on board

2017-07-06 10:09:36 GMT <fcorti> ;-)

2017-07-06 10:10:30 GMT <fwu> fcorti, very nice. But for now I will try to install with my hand on my laptop. I never used docker also.

2017-07-06 10:11:08 GMT <fcorti> cool... in this case take a look at the PDF... ok, it's too long but I cannot write short documentation :-P

2017-07-06 10:16:48 GMT <fwu> fcorti, I like long documentation, dont worry :)

2017-07-06 10:17:03 GMT <fwu> im downloading now

2017-07-06 10:52:18 GMT <AFaust> fcorti: Did Samuel have a JIRA issue about dealing with the discrepencies / version inconsistencies between org.alfresco:alfresco:war and org.alfresco:alfresco-platform:war? Either that has gone into hiding or I am just to stupid to find it today...

2017-07-06 10:54:14 GMT <AFaust> There still are some confused people from time to time due to the "fuck-up" that was 201606 EA and the org.alfresco:alfresco:war:5.1.g artifact (https://community.alfresco.com/thread/232182-migrating-from-enterprise-edition-5114-to-community-edition)

2017-07-06 10:54:16 GMT <alfbot> Title: Migrating from Enterprise Edition ( to ... | Alfresco Community (at community.alfresco.com)

2017-07-06 10:58:13 GMT <fcorti> Hi AFaust... let me ask him

2017-07-06 10:58:48 GMT <AFaust> I remember him having one, that's why I am confused now not to find it

2017-07-06 10:59:08 GMT <AFaust> Maybe my keywords in JIRA search are just way off

2017-07-06 11:01:34 GMT <fcorti> Samuel says "again?" .-D

2017-07-06 11:02:05 GMT <fcorti> Probably we could write a blogpost with some thoughts on this and see if it will help

2017-07-06 11:02:11 GMT <fcorti> I will do it together with him

2017-07-06 11:02:23 GMT <fcorti> Do you think it will be helpuful?

2017-07-06 11:25:55 GMT <AFaust> No - I meant the old issue from last year

2017-07-06 11:26:19 GMT <AFaust> Or was he surprised that people still get confused?

2017-07-06 11:27:21 GMT <AFaust> That is no wonder given how the artifact is still there, contains 5.2.a stuff despite being labelled 5.1.g and there is no indication / documentation anywhere on how people should interpret / understand that artifact...

2017-07-06 11:27:56 GMT <AFaust> We know because we have lived through it, but anyone joining the community later (or not being active at all) will have totally missed the discussions back then...

2017-07-06 12:25:03 GMT <fcorti> So, a (short) blog post could have sense

2017-07-06 14:21:06 GMT <fwu> back

2017-07-06 14:21:50 GMT <fwu> fcorti, im a little stuck installing saiku...

2017-07-06 14:23:17 GMT <yreg> fwu what's your issue with saiku ?

2017-07-06 14:23:27 GMT <yreg> did you get a CE license from their website

2017-07-06 14:23:28 GMT <yreg> ?

2017-07-06 14:25:15 GMT <fwu> my screen in the marketplace looks like this: https://justpaste.it/18ncr

2017-07-06 14:26:00 GMT <fwu> it doesnt seems I can isntall it from my own install. I only get a link to the market place page, and then how I know if Im dowanloding the community version or enterprise?

2017-07-06 14:26:17 GMT <fwu> i just see one there

2017-07-06 14:26:50 GMT <fwu> yreg, that means im not in the licence step, yet :)

2017-07-06 14:28:21 GMT <yreg> are you behind a proxy

2017-07-06 14:28:23 GMT <yreg> ?

2017-07-06 14:28:24 GMT <fwu> I was expecting to get a list of apps inside my own application, right?

2017-07-06 14:28:36 GMT <fwu> I dont think so

2017-07-06 14:28:48 GMT <fwu> no, sorry, yes Iam

2017-07-06 14:30:06 GMT <fwu> yreg, could this related to the market place plugin that may be disable on my install?

2017-07-06 14:30:32 GMT <fwu> "If you're using Pentaho 6.0 Enterprise Edition or any above, you no longer need to download the Marketplace plugin. The reason for that? It's an OSGi plugin and you already have it, but it comes disabled by default. Here are the instructions on how to enable it:"

2017-07-06 14:30:46 GMT <fwu> im using community 7 so..

2017-07-06 14:30:54 GMT <fcorti> Which Pentaho version are you using?

2017-07-06 14:30:57 GMT <fcorti> 7.1?

2017-07-06 14:31:11 GMT <fwu> if fcorti is using the plugin on the manual, then I may have it disabled

2017-07-06 14:31:33 GMT <fwu> fcorti; pentaho-server-ce-

2017-07-06 14:32:23 GMT <fcorti> My fault, please use this

2017-07-06 14:32:23 GMT <fcorti> https://sourceforge.net/projects/pentaho/files/Business%20Intelligence%20Server/7.1/

2017-07-06 14:32:34 GMT <fcorti> the installation process is the same

2017-07-06 14:33:03 GMT <fcorti> The manual is done using 7.1 and 7.1 is the latest one ;-)

2017-07-06 14:33:13 GMT <fwu> ok!

2017-07-06 14:33:20 GMT <fwu> i will try that

2017-07-06 14:33:23 GMT <fwu> thank you

2017-07-06 14:33:56 GMT <fcorti> you are welcome... thank you yreg for supporting fwu

2017-07-06 19:41:45 GMT <douglascrp> AFaust, 515 points in one single day :o

2017-07-06 20:06:00 GMT <AFaust> douglascrp: Well, kgastaldo had been on vacation and marked a couple of responses as either helpful or correct today...

2017-07-06 20:06:28 GMT <douglascrp> nice

2017-07-06 20:06:34 GMT <douglascrp> you will reach 20k soon

2017-07-06 20:06:54 GMT <douglascrp> congrats

2017-07-06 20:26:14 GMT <douglascrp> yreg, hey ude

2017-07-06 20:26:15 GMT <douglascrp> dude

2017-07-06 20:26:20 GMT <douglascrp> are you working on a mac?

2017-07-06 20:28:45 GMT <douglascrp> yreg, have you found any good docs on hotswap configuration on mac?

End of Daily Log

The other logs are at http://esplins.org/hash_alfresco