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-03-14 06:56:03 GMT <kkore> Hi all, how to create audit details on noderef ??.I enabled audits and able to see the audit details in http://localhost:8080/alfresco/service/api/audit/query/alfresco-access?verbose=true now how to use this details to show users on file and folder actions??

2018-03-14 07:05:19 GMT <yreg> Morning all !

2018-03-14 07:05:31 GMT <yreg> mbui, define at the same time ?

2018-03-14 07:05:44 GMT <yreg> do you mean within the scope of the same transaction ?

2018-03-14 07:11:40 GMT <MorganP> Hi guys, I have a customer that absolutely want to use MariaDB for Alfresco. Any issues seen with this DB? Like issues with lock or stuff like that?

2018-03-14 07:15:50 GMT <Loftux> MorganP: No problem at all with Community Edition

2018-03-14 07:17:02 GMT <Loftux> (not to say that there will be with Enterprise, just haven't tested)

2018-03-14 07:19:34 GMT <Loftux> MorganP: MariaDB is on supported platforms for enterprise 5.1.x https://www.alfresco.com/services/subscription/supported-platforms

2018-03-14 07:19:36 GMT <alfbot> Title: Supported Platforms and Languages | Alfresco (at www.alfresco.com)

2018-03-14 07:20:41 GMT <MorganP> Yes I know, for 5.2 too

2018-03-14 07:20:53 GMT <MorganP> but I remembered some discussions here about lock issues

2018-03-14 07:21:07 GMT <MorganP> but don't remember if it was talking about Oracle or MariaDB

2018-03-14 07:21:30 GMT <MorganP> Ah found it, it was MySQL

2018-03-14 07:22:14 GMT <MorganP> and yreg mentioned that MariaDB wasn't much better

2018-03-14 07:24:28 GMT <Loftux> MorganP: Yes I had issues about a year ago, but that was an Alfresco thumbnail transaction issue we fixed

2018-03-14 07:30:47 GMT <yreg> MorganP, I can confirm the issue with transactions lock to be present in mariadb as well as mysql

2018-03-14 07:30:51 GMT <MorganP> Thanks for the feedback Loftux

2018-03-14 07:30:56 GMT <yreg> even with Alfresco 5.2.2

2018-03-14 07:31:17 GMT <MorganP> Ok thanks yreg!

2018-03-14 07:31:50 GMT <yreg> We were able to tune MariaDB config to make it non blocking, but still it was not performant (as it was waiting for a lock to timeout)

2018-03-14 07:32:42 GMT <yreg> MorganP, an easy reproducer would be to try to create a node in a transaction, then try to create a child node to it within a child transaction

2018-03-14 07:33:20 GMT <yreg> default mariadb config wont work unless you change transaction isolation strategy to REPEATED-READ

2018-03-14 07:33:58 GMT <yreg> and once you do that, the child transaction will take relatively long time (will wait for the lock to expire)

2018-03-14 07:34:13 GMT <yreg> that's confirmed for EE as well as CE

2018-03-14 07:35:16 GMT <Loftux> yreg: But is that an issue with the db or Alfresco transaction handling code? I understand that there seem to be a workaround by setting REPEATED-READ.

2018-03-14 07:36:09 GMT <yreg> loftux the problem is simply not there at all with postgres

2018-03-14 07:38:08 GMT <yreg> with mysql and mariadb the default transaction isolation is different, and even after we change that to repeadable read, the child transaction won't commit until locks from parent transaction expire (that is if it does depend on data altered/added in parent transaction)

2018-03-14 08:35:31 GMT <hi-ko> good morning!

2018-03-14 08:37:04 GMT <hi-ko> Should we say goodbye to the Alfresco Cloud? The system is unusable slow and sometime even not available at least since several days.

2018-03-14 08:43:58 GMT <hi-ko> angelborroy: Did you find a work around for 5.2 to support basic auth on webdav in SSO config or are you not running 5.2 in production yet?

2018-03-14 08:45:03 GMT <angelborroy> I think I have a Kerberos SSO running in 5.2 and also a CAS

2018-03-14 08:45:06 GMT <angelborroy> Let me check

2018-03-14 08:47:07 GMT <angelborroy> hi-ko Kerberos working with https://github.com/keensoft/alf-21757-repo

2018-03-14 08:47:08 GMT <alfbot> Title: GitHub - keensoft/alf-21757-repo: Patch to ALF-21757 and ALF-21521 (at github.com)

2018-03-14 08:47:51 GMT <angelborroy> CAS working with https://github.com/wrighting/alfresco-cas/

2018-03-14 08:47:52 GMT <alfbot> Title: GitHub - wrighting/alfresco-cas: A project designed to show how to integrate Alfresco with CAS single sign on (at github.com)

2018-03-14 08:48:15 GMT <angelborroy> Both seems to work find with basic auth in WebDAV, but I haven’t check with the users as they don’t use WebDAV

2018-03-14 08:48:15 GMT <hi-ko> angelborroy: I know this one but this seems not to work for 5.2.

2018-03-14 08:48:23 GMT <angelborroy> Kerberos?

2018-03-14 08:48:45 GMT <angelborroy> I have a Docker Compose for 5.2 and Kerberos

2018-03-14 08:48:51 GMT <angelborroy> I could check it later

2018-03-14 08:49:18 GMT <hi-ko> The changes you made in web.xml doesn't result in a working webdav auth when kerberos sso is configured.

2018-03-14 08:49:32 GMT <hi-ko> thanks

2018-03-14 08:55:41 GMT <MorganP> yreg: I had a chat with a colleague of mine (a DBA) which is heavily working with MySQL and MariaDB. He told me to change the isolation level to committed read. Maybe you can try it out?

2018-03-14 09:08:13 GMT <hi-ko> MorganP: I don't have any context of your previous discussion but READ COMMITTED or even READ UNCOMMITTED is bad design and breaks RDBMS transaction concepts.

2018-03-14 09:34:50 GMT <yreg> MorganP, I think that was the default... and in that case, due to transaction isolation the child transaction won't be able to detect the present of the parent node that was created in the parent transaction from the example usecase I explained earlier

2018-03-14 09:35:12 GMT <yreg> s/thepresent/the presence/

2018-03-14 09:40:36 GMT <yreg> MorganP, I am not referring to tickets / support cases... so I might have actually swapped the default level/the one that actually works... let me confirm that by diving into my Jira

2018-03-14 09:45:00 GMT <MorganP> don't bother too much about it yreg ^^

2018-03-14 09:45:19 GMT <MorganP> I will still try to sell my PostgreSQL but I still prefer it to MySQL or MariaDB

2018-03-14 09:45:25 GMT <MorganP> but the customer will choose in fine.

2018-03-14 09:45:44 GMT <MorganP> So if I face this, I will reach out to our DBAs and they will do the tests

2018-03-14 09:47:15 GMT <yreg> ok

2018-03-14 10:06:53 GMT <twen> Good morning !

2018-03-14 10:15:14 GMT <bhagyas> Good morning

2018-03-14 10:44:30 GMT <mbui> yreg: Yes, I want it to behave similarly to when you submit a form with properties and associations. I guess wrapping it in a transaction does it? Basically what I want to achieve is to write an integration test which triggers my policy where I assume an association is created aswell.

2018-03-14 10:48:41 GMT <kkore> hi how to create audit details on noderef ??.I enabled audits and able to see the audit details in http://localhost:8080/alfresco/service/api/audit/query/alfresco-access?verbose=true now how to use this details to show users on file and folder actions??

2018-03-14 12:05:08 GMT <douglascrp> morning

2018-03-14 14:06:05 GMT <LMattioli> Anyone attending the Tech Talk?

2018-03-14 14:09:30 GMT <yreg> mbui, it should be enough for your case

2018-03-14 14:12:04 GMT <fcorti> LMattioli me for sure! :-)

2018-03-14 14:23:30 GMT *** DragiBus_ is now known as DragiBus

2018-03-14 14:35:13 GMT <kgastaldo> Tech Talk Live starts in 25 min! https://www.youtube.com/watch?v=TIupPLk8pUo

2018-03-14 14:48:00 GMT <bmejias> thanks kgastaldo

2018-03-14 14:59:33 GMT <fcorti> Tech Talk Live is starting now... join us at https://www.youtube.com/watch?v=TIupPLk8pUo

2018-03-14 15:00:07 GMT <bmejias> it's funny that the hour of the video seems to be like 7 minutes delayed.

2018-03-14 15:00:26 GMT <bmejias> currently it still says: waiting for Alfresco

2018-03-14 15:00:33 GMT <bmejias> ah, now is live

2018-03-14 15:03:55 GMT <fcorti> delays always suck....

2018-03-14 15:06:35 GMT <fcorti> as usual, if you have questions, feel free to ask here and I'll forward the questions to the presenters.

2018-03-14 15:08:07 GMT <bmejias> thanks fcorti... it seems that only the "waiting time" was out of sync. Things are cool now

2018-03-14 15:09:25 GMT <fcorti> bmejias ... when you will come to show something Alfresco + PostgreSql for advanced use cases in a Tech Talk Live?

2018-03-14 15:09:26 GMT <fcorti> :-)

2018-03-14 15:16:37 GMT <LMattioli> I would watch a teck talk about PostgreSql... even at the last presentation I've made the Customer IT Manager said "Our policy denies any DBMS but Oracle or MS Sql Server"

2018-03-14 15:18:42 GMT <LMattioli> ...even if at....

2018-03-14 15:24:51 GMT <bmejias> fcorti that's a good idea, and thanks LMattioli for that feedback... we will work on iy.

2018-03-14 15:24:56 GMT <bmejias> s/iy/it/

2018-03-14 15:25:55 GMT <kgastaldo> don't we know a PostgreSql guy, now @fcorti? ;)

2018-03-14 15:26:20 GMT <fcorti> kgastaldo mmm... let me think... don't have no-one in mind...

2018-03-14 15:26:48 GMT <fcorti> would be great to have someone that knows very well Alfresco AND postgresql both

2018-03-14 15:26:54 GMT <fcorti> it's hard to find on the market

2018-03-14 15:26:59 GMT <bmejias> LMattioli, you can show the latest StackOverflow survey to the Customer IT Manager: https://insights.stackoverflow.com/survey/2018/#technology-most-loved-dreaded-and-wanted-databases

2018-03-14 15:27:00 GMT <alfbot> Title: Stack Overflow Developer Survey 2018 (at insights.stackoverflow.com)

2018-03-14 15:28:03 GMT <yreg> bmejias, +1

2018-03-14 15:28:11 GMT <bmejias> You can see PostgreSQL is the most loved RDBMS. Redis is favourite one, but it's not RDBMS

2018-03-14 15:29:03 GMT <yreg> hehe

2018-03-14 15:30:07 GMT <LMattioli> Thanks bmejias but you don't have to convince me about open source :)

2018-03-14 15:31:10 GMT <LMattioli> I usually reply to these managers with "So the last time Word didn't work Bill Gates came to fix it?"

2018-03-14 15:31:12 GMT <bmejias> too true too true.... but it's an argument for the customer IT manager: If you want loved software, so that your engineers are happier... check the list

2018-03-14 15:31:56 GMT <bmejias> the stackoverflow is also interesting in terms of programming languages and frameworks.

2018-03-14 15:38:34 GMT <bmejias> yeah, sorry fcorti I didn't want to take the attention out of the TTL

2018-03-14 15:38:52 GMT <fcorti> welll... I asked you... was kidding (as usual), you know

2018-03-14 15:42:47 GMT <bmejias> but you see, I'm still listening the TTL

2018-03-14 15:44:25 GMT <bmejias> fcorti... I probably completely missed it because the girls are jumping all around over here. But I might have a question for David

2018-03-14 15:44:43 GMT <bmejias> so, all the interaction with templates was done through Alfresco Share

2018-03-14 15:45:05 GMT <bmejias> is there an API if I want to work with templates independently from Alfresco Share?

2018-03-14 15:45:50 GMT <bmejias> or is it completely up to the already provided API in Alfresco.... it just integrates to that?

2018-03-14 15:46:13 GMT <fcorti> got it... will ask asap

2018-03-14 15:46:18 GMT <bmejias> thanks

2018-03-14 15:46:47 GMT <yreg> bmejias, it looks like it is all setup using actions

2018-03-14 15:47:08 GMT <yreg> share is only calling APIs to trigger those actions

2018-03-14 15:48:22 GMT <yreg> it seems also that there is a few behaviours as well

2018-03-14 15:48:59 GMT <fcorti> yreg... you wins|

2018-03-14 15:49:00 GMT <fcorti> :-)

2018-03-14 15:52:36 GMT <bmejias> thanks fcorti

2018-03-14 15:52:51 GMT <bmejias> and thanks to the TTL panellists

2018-03-14 15:57:57 GMT <fcorti> Thank you all for attending the TTL

2018-03-14 16:14:11 GMT <angelborroy> hi-ko Confirmed that WebDav user/pass auth is not working with Kerberos SSO enabled

2018-03-14 17:55:37 GMT <hi-ko> ~later tell angelborroy Thanks for testing and your feedback. Anyone who find a solution to separate auth mechanisms per protocol should raise hands

2018-03-14 17:55:37 GMT <alfbot> hi-ko: The operation succeeded.

2018-03-14 18:20:49 GMT <hi-ko> douglascrp: do you have use cases with 5.2 SSO on Share and CIFS but basic auth on webdav or similar? With other words: does CAS integration work with webdav with fallback?

2018-03-14 18:22:53 GMT <douglascrp> hi-ko, hey

2018-03-14 18:23:01 GMT <douglascrp> no, I haven't

2018-03-14 18:23:08 GMT <douglascrp> I don't use SSO at all

2018-03-14 18:23:35 GMT <hi-ko> ~later tell fcorti: I missed ttl but watched it now. I like David's use case. Are there any artefacts to share except the youtube video?

2018-03-14 18:23:36 GMT <alfbot> hi-ko: The operation succeeded.

2018-03-14 18:23:42 GMT <douglascrp> I used CAS once, where share and liferay were able to login, but nothing more than that

2018-03-14 18:23:56 GMT <douglascrp> hi-ko, I was going to ask the same thing

2018-03-14 18:24:02 GMT <douglascrp> I have just finished watching it

2018-03-14 18:24:14 GMT <douglascrp> I searched for any github project, but I found nothing

2018-03-14 18:24:17 GMT <hi-ko> douglascrp: ;-)

2018-03-14 18:24:35 GMT <douglascrp> neither in David's page, and not in mimecom's

2018-03-14 18:24:37 GMT <hi-ko> douglascrp: so CAS is mostly for internet users?

2018-03-14 18:24:48 GMT <douglascrp> hi-ko, that was how I used it

2018-03-14 18:25:10 GMT <douglascrp> the idea at the time was just to let user go from one application to the other without having to type the user and password again

2018-03-14 18:25:58 GMT <hi-ko> understand - so we try to find other work arounds since not having SSO _and_ external dav excess at the same time is show stopper for a lot of our customers ...

2018-03-14 18:27:22 GMT <hi-ko> concerning David's presentation: I wouldn't expect something like a github project but at least some more examples which we all could work on to make it more generic

2018-03-14 18:29:19 GMT <hi-ko> We implemented a new versioning behavior for Alfresco to be able separate lifecycles and workflows on versions but don't have that nice docx integration for metadata

2018-03-14 18:31:38 GMT <hi-ko> cas: but what you describe is also the same mimik like sso in general but CAS may not be the right aproach for protocols like cmis, dav, cifs, ...

2018-03-14 18:51:58 GMT *** ed__ is now known as Popochon2

2018-03-14 18:52:51 GMT <Popochon2> Hi, the tech talk #114 about salesforce is the published one in youtube?

2018-03-14 18:54:07 GMT <Popochon2> uhmm no... hhehehe

2018-03-14 18:54:17 GMT <Popochon2> its re-scheduled?

2018-03-14 20:38:34 GMT <hi-ko> <Popochon2> yes sf integration is subject of the second part in ttl #114

End of Daily Log

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