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

2018-07-25 06:35:42 GMT <alfresco-discord> <yreg> Good morning everyone !

2018-07-25 07:56:34 GMT <dgradecak> hi AFaust : just ready your message from yesterday evening

2018-07-25 07:56:47 GMT <dgradecak> yes there is some new apis in v1 for audit

2018-07-25 07:57:18 GMT <dgradecak> and they are not at all 1 to 1 conversion since all the response has been changed. however I do agree that if you talk about the same features than yes, it is 1 to 1

2018-07-25 07:58:02 GMT <AFaust> Yeah, that's what I meant. Request / response format mapping is usually a trivial exercise...

2018-07-25 08:00:58 GMT <dgradecak> well it is if you do not have a framework that uses the old response. Not saying it is hard to do it, but there might be some kind of notices. And I guess if the new apis are here, than the old ones will go away soon?

2018-07-25 08:07:12 GMT *** DragiBus_ is now known as DragiBus

2018-07-25 08:21:30 GMT <AFaust> dgradecak: Again, I have not seen any announcements regarding API deprecation and since Share UI stuff (from Governance Services) relies on this, I doubt they would be gone any time soon

2018-07-25 08:22:00 GMT <AFaust> You could say the same thing about a lot of other old ReST API that could now be replaced / removed due to existence of new one

2018-07-25 08:22:37 GMT <AFaust> But as long as Share exists, I do not expect any of them to just vanish without UI features in Share being removed (i.e. like is the case for data lists, discussions etc.)

2018-07-25 08:23:24 GMT <AFaust> Since Alfresco invests almost next to nothing in Share efforts, I also doubt there would be a refactoring of existing UI to make use of the new APIs

2018-07-25 09:05:32 GMT <dgradecak> AFaust: for share you are probably right

2018-07-25 09:06:07 GMT <dgradecak> but for auditing it is a bit another beast, since the output format of data is changing

2018-07-25 09:07:21 GMT <hi-ko> SDK question: since we don't use Alfresco SDK: is it possible to integrate already existing/comiled jar modules in integration tests? From the docs it looks like alfresco doesn't ...

2018-07-25 09:07:46 GMT <hi-ko> s/comiled/compiled/

2018-07-25 09:19:26 GMT <alfresco-discord> <mbui> The alf_prop_link has grown very big (520GB or 80% of the database size). Any ideas how to reduce the size of this table?

2018-07-25 09:20:55 GMT <angelborroy> @mbui probably AFaust can help you: https://gist.github.com/AFaust/7513792

2018-07-25 09:20:57 GMT <alfbot> Title:SQL script for properly clearing Alfresco unused audit data / property values (NOT node properties, but the property tables used for AuditComponent and AttributeService functionality) for PostgreSQL / MySQL.NOTE: Only run when the Alfresco Repository is NOT running as values kept in in-memory caches will otherwise result in constraint violations. · GitHub (at gist.github.com)

2018-07-25 09:22:28 GMT <alfresco-discord> <mbui> angelborroy: I've ran the script explained in https://docs.alfresco.com/5.1/concepts/prop-tables.html Or are these scripts different?

2018-07-25 09:22:30 GMT <alfbot> Title:Scheduling cleanup of database tables | Alfresco Documentation (at docs.alfresco.com)

2018-07-25 09:23:00 GMT <angelborroy> @mbui I don’t know, I’ve been using AFaust ones

2018-07-25 09:28:30 GMT <alfresco-discord> <yreg> hi-ko if I understand your question right, there shouldn't be any problem with that

2018-07-25 09:29:20 GMT <alfresco-discord> <yreg> in practice I have even seen people using separate projects repo/share amps to develop features and then on li use an AIO project for integration tests

2018-07-25 09:29:45 GMT <alfresco-discord> <yreg> obviously in that one they do rely on compiled assets from other projects$

2018-07-25 09:30:37 GMT <hi-ko> yreg: we set this up for ourself using "provided" in pom.xml and getting the jars from our own artefact server but there is no support from the Alfresco SDK, right?

2018-07-25 10:15:44 GMT <AFaust> mbui: The scripts are only slightly different in that Alfresco is using some looping constructs in their own SQLs, but the basic concept is the same.

2018-07-25 10:16:35 GMT <AFaust> mbui / angelborroy: I have since built a more efficient cleanup mechanism which runs as a scheduled job and works better with runtime caches: https://github.com/Acosix/alfresco-audit#incremental-cleanup-of-alf_prop_-tables

2018-07-25 10:16:36 GMT <alfbot> Title:GitHub - Acosix/alfresco-audit: Addon to add audit-related utilities and/or common definitions (at github.com)

2018-07-25 10:17:58 GMT <AFaust> The problem with my old script and the Alfresco cleanup is that both are brute-force "do everything in one huge transaction" processes.

2018-07-25 10:18:26 GMT <AFaust> They create temporary tables which may - while the process is running - inflate your DB further.

2018-07-25 10:19:24 GMT <AFaust> And due to the complexity of looking up references, the queries in the DB tend to be very expensive full table scans

2018-07-25 10:22:09 GMT <AFaust> mbui: Since you say your alf_prop_link table is that large, that means all of your audit entries are still "live", i.e. not ready to be cleaned up by either my old cleanup script, the Alfresco version of it, nor my new, incremental cleanup.

2018-07-25 10:22:37 GMT <AFaust> You first need to find and delete the audit entries that are no longer required from a business perspective before you can actually run any cleanup.

2018-07-25 10:22:47 GMT <alfresco-discord> <yreg> @hi-ko not sure if provided would be enough for dependencies in your integration tests pom. I think you at leas need to add proper overlays on you parent (AIO) pom as well for them to function correctly

2018-07-25 10:25:27 GMT <AFaust> mbui: I would also have expected the other alf_prop_* tables to be larger than alf_prop_link, since alf_prop_link is only for cross-referencing the data structure in an audit entry, while alf_prop_*_value actually holds the data, which typically is way more expensive (often text/string based) than simple reference IDs

2018-07-25 10:26:27 GMT <AFaust> ..unless your audit data is extremely suitable for deduplication, which again, would be a bit surprising, since audit data contains stuff like the NodeRef, which - as UUIDs - are bad for deduplication

2018-07-25 10:26:48 GMT <AFaust> ... unless (again) you only have a few nodes but thousands upon thousands of audit entries per node

2018-07-25 10:29:08 GMT <hi-ko> yreg: I don't like AOI at all because it's a mess in maintenance (every module has it's own lifecycle). Customers don't want to rebuild their war files just because an external provided module has been updated. So we are happy just to use "provided" to write integration tests for every indepandant module package

2018-07-25 10:34:58 GMT <alex_> hi, how can i disable the create folder from non-admin users of alfresco-community 5.2, let me know .....?

2018-07-25 10:48:47 GMT <alfresco-discord> <yreg> hi-ko I do not think the SDK supports integration tests outside of AIO projects

2018-07-25 10:49:12 GMT <alfresco-discord> <yreg> as I said, I have seen people making separate standalone projects for modules

2018-07-25 10:49:38 GMT <alfresco-discord> <yreg> and then an AIO project (just for integration tests + possibly building the final war)

2018-07-25 10:55:04 GMT <alex_> hi, how can i disable the create folder from non-admin users of alfresco-community 5.2, let me know .....?

2018-07-25 10:58:22 GMT <angelborroy> alex_ afaik NodeService_security has no permission for “folders”, as everything is a node

2018-07-25 10:59:07 GMT <angelborroy> they only way I’m seeing is to build a behaviour

2018-07-25 11:04:40 GMT <alex_> how can i build a behaviour,send me any link for that.....

2018-07-25 11:05:39 GMT <angelborroy> alex_ you can start learning at https://ecmarchitect.com/alfresco-developer-series-tutorials/behaviors/tutorial/tutorial.html

2018-07-25 11:05:40 GMT <alfbot> Title:Implementing Custom Behaviors in Alfresco | ECM Architect | Alfresco Developer Tutorials (at ecmarchitect.com)

2018-07-25 11:11:41 GMT <alex_> thank you

2018-07-25 11:26:38 GMT <dgradecak> hi-ko: I do exactly the same thing as you with my poms and I use the SDK to run the tests and samples

2018-07-25 11:28:30 GMT <dgradecak> mainly all my "amps" are just jar files and if you execute the "start-alfresco" execution, than alfresco picks them up and all works just fine

2018-07-25 11:28:52 GMT <dgradecak> just use the alfresco-maven-plugin artifact

2018-07-25 11:29:20 GMT <dgradecak> talking about sdk 3.0.1

2018-07-25 11:30:44 GMT <Astley> Hello All, I'm using APS, i am new to this. I have group, in that have a sub group. When i give subgroup as process initiator, the process should go to main main group administrator as well. Can you please guide me how i can achieve this.

2018-07-25 11:37:22 GMT <hi-ko> dgradecak: using the alfresco-maven-plugin you bake everything into the war, right? That's what I try to avoid.

2018-07-25 11:40:34 GMT <dgradecak> well indeed, however it is the "easiest" way to launch alfresco with h2, solr/share ... if required

2018-07-25 11:40:53 GMT <dgradecak> for me it is a perfect fit as someone can checkout my samples and just run them

2018-07-25 11:41:28 GMT <dgradecak> for integration or in container tests also

2018-07-25 11:45:17 GMT <AFaust> Astley: You would need to write a TaskListener for this to act on task creation / assignment, and then look up the group adminsitrator of the (potentially many) parent group(s)

2018-07-25 11:45:57 GMT <AFaust> This requires Java implementation as I am not aware that the group administrator lookup operations are available to JavaScript

2018-07-25 11:52:18 GMT <dgradecak> Astley: not really following but you could build a list of groups previously and pass it as a variable to the proces?

2018-07-25 12:35:11 GMT <Astley> @Afaust, @dgradecak, thanks and can you please provide any useful link.

2018-07-25 12:43:43 GMT <alfresco-discord> <mbui> AFaust: Thanks for the answer

2018-07-25 12:44:30 GMT <Arun__> I have integrated alfresco content service with alfresco process service using share connector.I have started a workflow in alfresco content service when i am assigning to a user i cant see my task in alfresco process service and also in content service.

2018-07-25 12:44:37 GMT <alfresco-discord> <douglascrp> good morning

2018-07-25 12:48:21 GMT <Arun__> Please if anyone knows help me or send any link.

2018-07-25 12:52:41 GMT <alfresco-discord> <Popochon> Astley https://pastebin.com/rS2khKQZ In this I merge one WF metadata with an existing list of users in JS... in a listner. Maybe it could help you 😃

2018-07-25 12:52:42 GMT <alfbot> Title:[JavaScript] alfresco - Pastebin.com (at pastebin.com)

2018-07-25 12:54:08 GMT <alfresco-discord> <digcat> morning all

2018-07-25 12:55:11 GMT <Arun__> \

2018-07-25 13:34:51 GMT <angelborroy> Wasn’t Tech Talk live now?

2018-07-25 13:35:07 GMT <alfresco-discord> <douglascrp> seems so

2018-07-25 13:35:17 GMT <alfresco-discord> <douglascrp> but I won't be able to watch it now 😦

2018-07-25 13:36:28 GMT <alfresco-discord> <Francesco Corti> Hello

2018-07-25 13:36:38 GMT <alfresco-discord> <Francesco Corti> Tech Talk LIve will start in 24 minuts

2018-07-25 13:37:47 GMT <angelborroy> have you made some re-arrangement?

2018-07-25 13:38:05 GMT <alfresco-discord> <Francesco Corti> About timing, you mean?

2018-07-25 13:38:10 GMT <alfresco-discord> <Francesco Corti> Nope, 4pm as usual...

2018-07-25 13:38:21 GMT <angelborroy> it’s announced for 15:30

2018-07-25 13:38:24 GMT <alfresco-discord> <douglascrp> I have just received a message from youtube saying that Alfresco is live

2018-07-25 13:38:26 GMT <alfresco-discord> <Francesco Corti> the announcement is wrong; i think

2018-07-25 13:38:32 GMT <angelborroy> yep

2018-07-25 13:38:34 GMT <angelborroy> that is

2018-07-25 13:38:34 GMT <alfresco-discord> <douglascrp> @angel.borroy that is what I saw

2018-07-25 13:38:43 GMT <angelborroy> there were 15 people waiting just a moment ago

2018-07-25 13:39:24 GMT <alfresco-discord> <Francesco Corti> @kgastaldo is checking nbow

2018-07-25 13:39:48 GMT <alfresco-discord> <kgastaldo> Apologies - I don't know why it had 9:30. We will start at 10 (in 20 min)

2018-07-25 13:43:59 GMT <alfresco-discord> <kgastaldo> Well, I know WHY it had 9:30. I put the wrong time in. Sorry about that. Starting at 10!

2018-07-25 13:55:20 GMT <alfresco-discord> <digcat> hey @Francesco Corti or @kgastaldo will TTL be recorded ? and do you have the link handy

2018-07-25 13:55:33 GMT <alfresco-discord> <Francesco Corti> Yes, it will be.

2018-07-25 13:55:39 GMT <alfresco-discord> <digcat> cool

2018-07-25 13:55:42 GMT <alfresco-discord> <Francesco Corti> https://youtu.be/bEU7Lt5yebA

2018-07-25 13:55:48 GMT <alfresco-discord> <digcat> thank you

2018-07-25 13:56:01 GMT <alfresco-discord> <Francesco Corti> you are welcome 😃

2018-07-25 14:00:09 GMT <alfresco-discord> <Francesco Corti> We are going to start the Tech Talk Live... now. Join us!

2018-07-25 14:04:01 GMT <angelborroy> all of we are hearing the echo...

2018-07-25 14:04:25 GMT <alfresco-discord> <kgastaldo> Gone now?

2018-07-25 14:04:27 GMT <alfresco-discord> <Francesco Corti> Are you hearing the echo now?

2018-07-25 14:04:34 GMT <alfresco-discord> <kgastaldo> I think it is gone now ...

2018-07-25 14:04:34 GMT <angelborroy> nope, now it’s gone

2018-07-25 14:05:10 GMT <angelborroy> now I loose the video signal

2018-07-25 14:05:18 GMT <angelborroy> is it working fine for others?

2018-07-25 14:05:36 GMT <alfresco-discord> <yreg> not for me

2018-07-25 14:05:45 GMT <alfresco-discord> <Francesco Corti> I can see it

2018-07-25 14:05:51 GMT <angelborroy> The signal come back again

2018-07-25 14:06:24 GMT <angelborroy> frozen video again

2018-07-25 14:07:07 GMT <alfresco-discord> <kgastaldo> Everything is continuing in the hangout - hopefully YouTube catches up.

2018-07-25 14:07:25 GMT <alfresco-discord> <Francesco Corti> It is frozen for me too

2018-07-25 14:07:35 GMT <alfresco-discord> <Francesco Corti> back now

2018-07-25 14:07:46 GMT <alfresco-discord> <kgastaldo> Yes, back for me as well

2018-07-25 14:09:22 GMT <alfresco-discord> <Francesco Corti> Seems to be better now

2018-07-25 14:12:16 GMT <angelborroy> Also for Community?

2018-07-25 14:12:26 GMT <alfresco-discord> <Francesco Corti> Asking soon

2018-07-25 14:12:27 GMT <angelborroy> It looks like de-composing services is only for Enteprise?

2018-07-25 14:14:06 GMT <angelborroy> nope

2018-07-25 14:14:17 GMT <angelborroy> as Spring Boot Applications are not available for Community

2018-07-25 14:14:25 GMT <angelborroy> SBA for ImageMagick and so

2018-07-25 14:14:26 GMT <angelborroy> right

2018-07-25 14:25:41 GMT <angelborroy> Docker 101! :D

2018-07-25 14:27:29 GMT <alfresco-discord> <Francesco Corti> Basic suggestions for the best results 😃

2018-07-25 14:38:50 GMT <angelborroy> In fact, it was a quick patch

2018-07-25 14:39:02 GMT <angelborroy> probably the better is to way for an official release

2018-07-25 14:47:14 GMT <alfresco-discord> <Francesco Corti> I see as freezed now

2018-07-25 14:47:20 GMT <angelborroy> the same here

2018-07-25 14:47:31 GMT <alfresco-discord> <Francesco Corti> 💩

2018-07-25 14:48:06 GMT <alfresco-discord> <Francesco Corti> The broadcast is going well, hopefully the recording will be fine

2018-07-25 14:48:07 GMT <angelborroy> it was starting the interesting part

2018-07-25 14:49:00 GMT <alfresco-discord> <Francesco Corti> We are continuing to record without issues... hopefully the recording will be fine

2018-07-25 14:50:30 GMT <alfresco-discord> <Francesco Corti> I manually moved the video pointer and it works fine now

2018-07-25 14:50:41 GMT <alfresco-discord> <Francesco Corti> Youtube broadcasting seems to be the issue

2018-07-25 14:54:25 GMT <alfresco-discord> <Francesco Corti> Yes confirmed: each time youtube freezes the image, move thee pointer of the advancement of the video ahead and it works again.

2018-07-25 14:56:59 GMT <angelborroy> all these “good practices” are fine, but how to apply this to Alfresco released Docker Images?

2018-07-25 14:57:30 GMT <angelborroy> Alfresco is doing this kind of things for their images but we (as integrators) need to work from this images...

2018-07-25 14:57:44 GMT <angelborroy> … so what are the advices for this use case=

2018-07-25 14:58:01 GMT <angelborroy> It looks a “general” talk about Docker good practices but not oriented to Alfresco

2018-07-25 14:59:00 GMT <angelborroy> And also looks like Docker Compose is missing

2018-07-25 14:59:20 GMT <angelborroy> there will be a second TTL extending contents from this one?

2018-07-25 14:59:36 GMT <alfresco-discord> <Francesco Corti> Don't want to take the question and answer but maybe those tips are valuable if you build your own image, instead of suing an existing one.

2018-07-25 15:00:12 GMT <angelborroy> As Alfresco I’d not advise the people to build their own images...

2018-07-25 15:00:20 GMT <angelborroy> … this will be a nightmare for everyone

2018-07-25 15:01:06 GMT <alfresco-discord> <Francesco Corti> A second TTL on this is not planned yet, but it is a suggestion. If you think it would be valuable... I'm happy to suggest it to be done.

2018-07-25 15:07:42 GMT <angelborroy> +1 to Sergiu

2018-07-25 15:11:08 GMT <angelborroy> Is it Michael Suzuki out there?

2018-07-25 15:11:18 GMT <angelborroy> Just for the Demo Gods, you know :)

2018-07-25 15:11:23 GMT <alfresco-discord> <Francesco Corti> 😄

2018-07-25 15:11:45 GMT <alfresco-discord> <Francesco Corti> Micheal is the closest one to the demo gods...

2018-07-25 15:12:31 GMT <alfresco-discord> <Francesco Corti> If you want to check the source code Sujay is showing... check it here: https://gist.github.com/sujaypillai/fbbeae67ca96e85a018a5743625e7edd

2018-07-25 15:12:32 GMT <alfbot> Title:acs-docker-compose · GitHub (at gist.github.com)

2018-07-25 15:12:46 GMT <angelborroy> Why Docker Swarm?

2018-07-25 15:12:55 GMT <angelborroy> Who is using that tool nowadays?

2018-07-25 15:13:15 GMT <angelborroy> And even Alfresco is going for Kubernetes...

2018-07-25 15:13:20 GMT <angelborroy> … this makes no sense to me

2018-07-25 15:13:37 GMT <alfresco-discord> <Francesco Corti> well, it's an altrnative

2018-07-25 15:13:43 GMT <alfresco-discord> <Francesco Corti> they are covering it...

2018-07-25 15:14:01 GMT <angelborroy> an alternative not recommended by Alfresco

2018-07-25 15:18:24 GMT <alfresco-discord> <mikel_asla> I really think that swarm fits better than kubernetes for community deployments

2018-07-25 15:18:40 GMT <alfresco-discord> <mikel_asla> and it's great to use the same docker-compose file for dev, stage, prod, ...

2018-07-25 15:18:53 GMT <alfresco-discord> <mikel_asla> no ugly helm charts 😛

2018-07-25 15:19:13 GMT <angelborroy> you can use only Docker Compose for Community

2018-07-25 15:19:27 GMT <angelborroy> Swarm is not providing you any feature you need for a Community deployment

2018-07-25 15:19:46 GMT <alfresco-discord> <mikel_asla> high availability, restart policy, and so on

2018-07-25 15:20:02 GMT <alfresco-discord> <mikel_asla> resource limitation

2018-07-25 15:20:04 GMT <angelborroy> both can be obtained with Docker Compose

2018-07-25 15:20:16 GMT <angelborroy> and the last also can be obtained with Docker Compose

2018-07-25 15:20:54 GMT <alfresco-discord> <mikel_asla> yes with that '--compatibility flag'

2018-07-25 15:21:20 GMT <angelborroy> no, just including limitations to postgre, tomcat, jetty and so on

2018-07-25 15:21:36 GMT <angelborroy> that limitation will work without orchestrator tool

2018-07-25 15:22:06 GMT <alfresco-discord> <mikel_asla> but compose version 3 ignores deploy part of compose, it only works with swarm mode or compatibility flag, afaik

2018-07-25 15:22:19 GMT <angelborroy> buf…

2018-07-25 15:22:25 GMT <angelborroy> ok, let it go

2018-07-25 15:22:43 GMT <angelborroy> I’m not talking about limiting resources in Docker Containers but in software

2018-07-25 15:22:59 GMT <angelborroy> -Xmx means something for you?

2018-07-25 15:23:10 GMT <alfresco-discord> <mikel_asla> sure 😛

2018-07-25 15:23:25 GMT <angelborroy> I’ve tested this approach internally and it works fine

2018-07-25 15:23:38 GMT <angelborroy> the same (similar) for PostgresSQL and Jetty

2018-07-25 15:25:19 GMT <angelborroy> https://gist.github.com/sujaypillai/fbbeae67ca96e85a018a5743625e7edd#file-acs-docker-compose-L29

2018-07-25 15:25:20 GMT <alfbot> Title:acs-docker-compose · GitHub (at gist.github.com)

2018-07-25 15:39:15 GMT <AFaust> angelborroy: +1 on the Xmx argument - I could never understand the big deal made about controlling memory when your app can already be configured properly. Though CPU / thread limitation for GC is another matter not easily dealt with using JVM parameters

2018-07-25 15:39:43 GMT <angelborroy> thanks, AFaust! It looks like I was the one on that side ;-)

2018-07-25 15:44:31 GMT <alfresco-discord> <Francesco Corti> https://youtu.be/bEU7Lt5yebA

2018-07-25 15:44:51 GMT <alfresco-discord> <Francesco Corti> https://gph.is/2eD4Xzc

2018-07-25 15:44:53 GMT <alfbot> Title:Dark Side GIF - Find & Share on GIPHY (at giphy.com)

2018-07-25 20:21:25 GMT <mark_____> Hi Guys, how do I fully disable webdav? I've added "system.webdav.servlet.enabled=false" to alfresco-global.properties but there's still a login prompt on /alfresco/webdav

End of Daily Log

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