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-11-28 07:11:24 GMT <alfresco-discord> <praveen> Hi

2018-11-28 07:12:35 GMT <alfresco-discord> <praveen> sorting functionality is not happening when i click on HeaderCell by using Aikau . Please help me on this

2018-11-28 07:14:58 GMT <alfresco-discord> <praveen> using Aikau version

2018-11-28 09:01:56 GMT <DarkStar1> Morning people

2018-11-28 09:08:24 GMT <alfresco-discord> <yreg> Morning everyone

2018-11-28 09:08:35 GMT <alfresco-discord> <yreg> Morning DarkStar1

2018-11-28 09:48:22 GMT <alfresco-discord> <MorganP> Morning everybody

2018-11-28 09:54:32 GMT <AFaust> praveen: So, first things first: Have you actually configured the sorting feature to be active? It is not enabled by default. Has the table been configured to support sorting? The default AlfList does not supporting sorting - you have to use the AlfSortablePaginatedList or a derivative of it and configure sortRequestTopic for the pubsub. Lastly, does the Aikau service targeted by the data load pubsub topic actually support sorting?

2018-11-28 09:54:32 GMT <AFaust> If not, it does not matter what you configure in the header cell / table...

2018-11-28 10:33:19 GMT <fwu2018> hi all

2018-11-28 11:35:28 GMT <Tichodroma> I vaguely remember that there was a special alfresco-global.properties setting to get around this error when sending an email: "javax.mail.MessagingException: Unknown encoding: ${mail.header}"

2018-11-28 11:35:41 GMT <Tichodroma> Which property was this?

2018-11-28 11:36:56 GMT <Tichodroma> I think it was this:

2018-11-28 11:37:00 GMT <Tichodroma> mail.header=

2018-11-28 11:37:05 GMT <Tichodroma> empty value!

2018-11-28 11:42:01 GMT <AFaust> Yes, some config XML used a placeholder without the placeholder being defined in a properties file

2018-11-28 11:55:05 GMT <alfresco-discord> <MorganP> Anyone knows what the alf_acl_member.pos is used for?

2018-11-28 11:55:30 GMT <alfresco-discord> <MorganP> It looks to me that it might be to know whether or not the acl is inherited

2018-11-28 11:55:39 GMT <alfresco-discord> <MorganP> but I'm not completely sure

2018-11-28 11:56:55 GMT <AFaust> it is for ordering permissions in ACL checks... If I remember correctly, pos is the offset in intermediary ACLs from where the permission has been actually set

2018-11-28 11:57:17 GMT <AFaust> So if you set "Read" on node A, the member for Read on A should have pos 0

2018-11-28 11:57:42 GMT <AFaust> If node B inherits from A and sets some other permissions (so that it defines its own ACL), then Read on B should have pos 1

2018-11-28 11:57:54 GMT <AFaust> ... and so on

2018-11-28 11:59:00 GMT <AFaust> You could also set Read on some other authority on B, then that would get pos 0

2018-11-28 11:59:38 GMT <alfresco-discord> <MorganP> So locally set permissions should always have 0 and inherited at least 1

2018-11-28 12:00:03 GMT <AFaust> That is my understanding, yes...

2018-11-28 12:00:09 GMT <alfresco-discord> <MorganP> That's what I was thinking as well

2018-11-28 12:00:15 GMT <alfresco-discord> <MorganP> I will do some tests

2018-11-28 12:13:15 GMT <alfresco-discord> <MorganP> Wow the value for the pos column is quite strange

2018-11-28 12:14:06 GMT <alfresco-discord> <MorganP> It was 2, then I changed the permissions on the parent, it went to 4, reverting the change, it's still 4

2018-11-28 12:14:43 GMT <alfresco-discord> <MorganP> adding a new doc in the same folder, it's 3, removing inheritance for this document it's empty obviously and then reactivating inheritance it's now 4

2018-11-28 12:15:24 GMT <alfresco-discord> <MorganP> I never saw 1 so far but one thing is for sure, it's 0 when it's local and higher for inheritance

2018-11-28 12:17:57 GMT <alfresco-discord> <Thijs> @MorganP I did some tests with support of Axel not so long ago, and if you remove inheritance, you create a new defining ACL, and if you enable inheritance again, even without having any local permissions set, that defining ACL is not automatically removed.

2018-11-28 12:19:39 GMT <alfresco-discord> <Thijs> so you can get a ton of acl members that are actually copied from a parent, but copied anyway

2018-11-28 12:20:56 GMT <alfresco-discord> <MorganP> Yeah sure

2018-11-28 12:21:08 GMT <alfresco-discord> <MorganP> but I don't see a link between ACL and position

2018-11-28 12:21:46 GMT <alfresco-discord> <MorganP> anyway it's not really important, I just wanted to ensure that 0 is always local in all cases

2018-11-28 12:22:06 GMT <alfresco-discord> <Thijs> if it is 1, it is inherited from a direct parent

2018-11-28 12:22:20 GMT <alfresco-discord> <Thijs> and if it is 2, it is inherited from a parent of a parent ...

2018-11-28 12:22:43 GMT <alfresco-discord> <MorganP> I don't think so

2018-11-28 12:22:59 GMT <alfresco-discord> <MorganP> let me do some other tests

2018-11-28 12:23:08 GMT <alfresco-discord> <MorganP> with newly created folders and not existing ones

2018-11-28 12:23:19 GMT <alfresco-discord> <MorganP> which might have higher positions already

2018-11-28 12:23:54 GMT <alfresco-discord> <Thijs> if you create a new folder, you do not create a new ACL, it reuses the ACL of the parent

2018-11-28 12:24:14 GMT <alfresco-discord> <Thijs> up until you add a local permission, or disable inheritance

2018-11-28 12:25:08 GMT <alfresco-discord> <MorganP> ok right it's 1 for a new folder

2018-11-28 12:25:18 GMT <alfresco-discord> <Thijs> I might be slightly wrong, observing what happens in the database while you change permissions is always a good idea to get to the bottom

2018-11-28 12:25:46 GMT <alfresco-discord> <MorganP> I meant create new folder, disabling inheritance and adding local permissions

2018-11-28 12:25:58 GMT <alfresco-discord> <MorganP> then adding content into that and check pos on the childs

2018-11-28 12:26:03 GMT <alfresco-discord> <MorganP> as a clean base

2018-11-28 12:26:07 GMT <alfresco-discord> <Thijs> yes, then it is 1

2018-11-28 12:26:43 GMT <alfresco-discord> <MorganP> 1 for sub-folder1

2018-11-28 12:26:55 GMT <alfresco-discord> <MorganP> 1 for sub-folder2 as well

2018-11-28 12:27:02 GMT <alfresco-discord> <MorganP> sub-folder2 being inside sub-folder1

2018-11-28 12:27:36 GMT <alfresco-discord> <Thijs> sub-folder2 has no local permissions nor inheritance disabled?

2018-11-28 12:28:11 GMT <alfresco-discord> <MorganP> just default folder created

2018-11-28 12:28:23 GMT <alfresco-discord> <MorganP> so it just has inheritance enabled

2018-11-28 12:28:46 GMT <alfresco-discord> <MorganP> file1 created here: folder > sub-folder1 > sub-folder2 > file1

2018-11-28 12:28:54 GMT <alfresco-discord> <MorganP> file1 also has 1 as pos

2018-11-28 12:29:15 GMT <alfresco-discord> <Thijs> well, sub-folder2 doesn't have it's own ACL

2018-11-28 12:29:22 GMT <alfresco-discord> <MorganP> yeah

2018-11-28 12:29:37 GMT <alfresco-discord> <MorganP> so it's just 1 for everything by default no matter where you are in the hierarchy

2018-11-28 12:29:49 GMT <alfresco-discord> <MorganP> and then when you start adding new ACL it starts increasing when needed

2018-11-28 12:30:51 GMT <alfresco-discord> <Thijs> if you set a local permission on sub-folder2, file1 has a permission with pos 2 and one with pos 1

2018-11-28 12:39:37 GMT <alfresco-discord> <MorganP> pos 1 for the local added to sub-folder2

2018-11-28 12:39:45 GMT <alfresco-discord> <MorganP> and pos 3 for the inheritances ones

2018-11-28 12:40:32 GMT <alfresco-discord> <MorganP> And on the sub-folder2, it's 0 for local and 2 for inheritances

2018-11-28 12:41:35 GMT <alfresco-discord> <Thijs> anyway, if you want really reset the permissions of a node (in java), you can use: permissionService.deletePermissions(nodeRef)

2018-11-28 12:46:24 GMT <alfresco-discord> <yreg> but you should avoid that as much as possible

2018-11-28 12:46:36 GMT <alfresco-discord> <yreg> be aware of that @Thijs

2018-11-28 12:46:54 GMT <alfresco-discord> <yreg> that method is a recipe for trouble

2018-11-28 12:47:55 GMT <alfresco-discord> <yreg> for some deep dark reason, it result in a duplication of data on solr -> a new document is created but the ald one does never get deleted/updated

2018-11-28 12:48:35 GMT <alfresco-discord> <yreg> resulting in : - possibly duplicates when you query for that document

2018-11-28 12:49:27 GMT <alfresco-discord> <Thijs> is there a JIRA issue for that?

2018-11-28 12:49:38 GMT <alfresco-discord> <yreg> - once metadata changes on the content/folder, the old solr document (which never gets updated/deleted) keeps holding the old outdated data and so results in false positives when you search on old outdated data

2018-11-28 12:49:44 GMT <alfresco-discord> <yreg> I have a support case 😄

2018-11-28 12:49:55 GMT <alfresco-discord> <Thijs> version of Alfresco?

2018-11-28 12:50:27 GMT <alfresco-discord> <yreg> it's present in ACS 5.1/5.2 , ASS 1.0, 1.1, 1.1.1 at least

2018-11-28 12:51:30 GMT <alfresco-discord> <Thijs> mmm, but it is the only way for us to fix some issues for a client that made there acl members explode

2018-11-28 12:51:44 GMT <alfresco-discord> <Thijs> Solr reindex helps?

2018-11-28 12:51:52 GMT <alfresco-discord> <MorganP> I would assume so

2018-11-28 12:51:56 GMT <alfresco-discord> <MorganP> since it removes everything

2018-11-28 12:52:15 GMT <alfresco-discord> <MorganP> but most probably not always an option unless you are using clustering

2018-11-28 12:53:16 GMT <alfresco-discord> <Thijs> @yreg good to know. I'm happy to vote for the JIRA issue if you can get Alfresco support to make one.

2018-11-28 12:54:02 GMT <alfresco-discord> <yreg> Yeah full re-index is the only solution for now AFAIK

2018-11-28 12:54:16 GMT <alfresco-discord> <yreg> at least that's how we worked around it

2018-11-28 12:54:30 GMT <alfresco-discord> <yreg> and we changed the code to never use that method again 😃

2018-11-28 12:55:11 GMT <alfresco-discord> <Thijs> but Alfresco does use it themselves

2018-11-28 12:55:51 GMT <alfresco-discord> <MorganP> No way to clean the index using Luke or something similar?

2018-11-28 12:56:01 GMT <alfresco-discord> <MorganP> but that's a manual thing though..

2018-11-28 13:01:26 GMT <alfresco-discord> <yreg> there is proper apis exposed in solr web interface

2018-11-28 13:01:39 GMT <alfresco-discord> <yreg> but I am afraid that would be a huge manual workload

2018-11-28 13:01:46 GMT <alfresco-discord> <yreg> to track and fix those

2018-11-28 13:02:29 GMT <alfresco-discord> <yreg> @Thijs don't kill the messenger, if it works for you without issues, please disregard my comments

2018-11-28 13:21:07 GMT <alfresco-discord> <new-user> Hello everyone

2018-11-28 13:21:26 GMT <alfresco-discord> <new-user> If I am trying to add alfresco repository jar to my project (I am not using alfresco sdk) and I perform node creation / deletion / update, I am not able to search for any created node..

2018-11-28 13:21:33 GMT <alfresco-discord> <new-user> Later I found out that I need to configure solr indexer!! (I'll go probably with solr6), If at all its possible what are the major changes I am lookin for ? Currently I am getting model tracking failed exception. Which is obvious because its trying to find solr end points. I have gone through these links https://docs.alfresco.com/5.2/tasks/solr6-install-withoutSSL.html,

2018-11-28 13:21:33 GMT <alfresco-discord> https://community.alfresco.com/docs/DOC-6556-using-solr-6-in-alfresco-community-edition-52-201612-ga

2018-11-28 13:21:35 GMT <alfbot> Title:Using SOLR 6 in Alfresco Community Edition 5.2 ... | Alfresco Community (at community.alfresco.com)

2018-11-28 13:28:34 GMT <AxelFaust> MorganP: Just catching up on the pos value confusion and I realise I forgot to mention the difference between DEFINING and SHARED ACLs. So pos = 0 is local, pos = 1 would be on child elements with inheritance enabled and NO custom permissions set (they use a SHARED ACL from the parent, which is a direct child of its DEFINING ACL). As soon as you add a local permission to a child, it gets its own DEFINING ACL inheriting from the

2018-11-28 13:28:34 GMT <AxelFaust> SHARED ACL of the parent, so the pos of the inherited permission should be 2...

2018-11-28 13:29:14 GMT <AxelFaust> ACL ID + member pos handling is really some low-level magic that no one should ever have to deal with in 99.9+ % of cases

2018-11-28 13:37:01 GMT <alfresco-discord> <MorganP> Yes that's what I understood

2018-11-28 13:37:12 GMT <alfresco-discord> <MorganP> After all the tests

2018-11-28 13:37:36 GMT <alfresco-discord> <MorganP> I just wanted an SQL query to check the permissions on a specific node from the DB so it's really 0 or else

2018-11-28 13:37:47 GMT <alfresco-discord> <MorganP> I don't really care if it's 1, 2 or 99 ^^

2018-11-28 15:12:49 GMT <alfresco-discord> <phisvuu-2> Has anyone implemented pagination for the documentlibrary? I.e. being able to select 5, 20, 50, 100 etc results per page?

2018-11-28 15:24:26 GMT <fwu2018> back

2018-11-28 18:35:37 GMT <alfresco-discord> <edw24> Hi, is there a way to search for specific cm:taggable via fts?

2018-11-28 20:22:49 GMT <alfresco-discord> <edw24> Is there a way to use fts-alfresco to search for cm:taggable?

End of Daily Log

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