Alfresco discussion and collaboration. Stick around a few hours after asking a question.
Official support for Enterprise subscribers: support.alfresco.com.
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.
More help is available in this list of resources.
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
The other logs are at http://esplins.org/hash_alfresco