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-02-28 06:38:24 GMT <alicia_> hi all! I am new to alfresco but i have wanted to ask if anyone knows how to have 3 parts of the inbound email be as on e

2018-02-28 06:38:30 GMT <alicia_> one*

2018-02-28 07:56:46 GMT <yreg> Morning

2018-02-28 07:59:51 GMT <MorganP> Morning yreg

2018-02-28 09:16:45 GMT <DarkStar1> Morning everyone

2018-02-28 09:42:31 GMT <angelborroy> morning

2018-02-28 09:43:12 GMT <angelborroy> I’m inspecting a server with Alfresco 3.3 (looks CE) and Oracle

2018-02-28 09:43:47 GMT <angelborroy> It looks like iBatis scripts were added to default alfresco.war but I’m not sure how

2018-02-28 09:44:03 GMT <angelborroy> Did it exist an “Oracle DB” addon for Alfresco 3.3. CE?

2018-02-28 09:52:02 GMT <angelborroy> It looks like it was a project from the Community

2018-02-28 09:52:03 GMT <angelborroy> https://web.archive.org/web/20100828233315/http://forge.alfresco.com/projects/oracle

2018-02-28 09:52:05 GMT <alfbot> Title: AlfrescoForge: Oracle for ALFRESCO Community: Project Info (at web.archive.org)

2018-02-28 10:00:13 GMT <yreg> angelborroy, interesting setup :D

2018-02-28 10:00:36 GMT <yreg> I wouldn't recommend Oracle even for new clients on EE

2018-02-28 10:00:40 GMT <angelborroy> I have to say that I’m learning a lot, but this migration is going to be a pain in the ass, you know

2018-02-28 10:00:53 GMT <yreg> even if they already have their license paid for <grin>

2018-02-28 10:01:04 GMT <yreg> angelborroy, I am sure

2018-02-28 10:01:14 GMT <yreg> how big is that repository

2018-02-28 10:01:15 GMT <yreg> ?

2018-02-28 10:01:20 GMT <angelborroy> not that big

2018-02-28 10:01:37 GMT <angelborroy> But I have 2 sources: 3.3 CE and 4.0 EE

2018-02-28 10:01:48 GMT <angelborroy> And I have to “create” a new beast from these

2018-02-28 10:01:56 GMT <yreg> IMHO it's probably better to export it and re-import it in a vanilla Alfresco

2018-02-28 10:02:04 GMT <angelborroy> probably

2018-02-28 10:02:13 GMT <angelborroy> But I have to know what’s exactly installed

2018-02-28 10:02:13 GMT <yreg> possibly doing some mojo to preserve noderefs inchanges

2018-02-28 10:02:17 GMT <yreg> inchanged*

2018-02-28 10:02:25 GMT <yreg> definitely move away from oracle

2018-02-28 10:02:41 GMT <angelborroy> I can choose MySQL or Oracle

2018-02-28 10:02:48 GMT <angelborroy> both are a bad choice IMO

2018-02-28 10:03:27 GMT <IanW1> Back in the day we were only allowed Oracle or SQLServer...

2018-02-28 10:05:35 GMT <yreg> angelborroy, agreed

2018-02-28 10:05:50 GMT <yreg> MySQL has issues with locks

2018-02-28 10:06:17 GMT <yreg> lots of them plus sometimes it tries to optemize and end up messing up the query plan

2018-02-28 10:06:25 GMT <yreg> we have seen a lot of that lately

2018-02-28 10:08:44 GMT <yreg> angelborroy, mariadb doesn't help much either

2018-02-28 10:09:08 GMT <angelborroy> I’ve been using PostgreSQL for years

2018-02-28 10:09:21 GMT <angelborroy> even replacing previous Oracle DBs with PostgreSQL

2018-02-28 10:09:29 GMT <angelborroy> No customer complains by now

2018-02-28 10:14:36 GMT <MorganP> Wasn't that one of the projects which basically just took the EE code and put it in the CE?

2018-02-28 10:46:15 GMT <alicia_> hi guys

2018-02-28 10:46:51 GMT <alicia_> can anyone help with this ?

2018-02-28 10:46:52 GMT <alicia_> https://community.alfresco.com/thread/202483-best-way-to-parse-inbound-email

2018-02-28 10:46:54 GMT <alfbot> Title: Best way to parse inbound email | Alfresco Community (at community.alfresco.com)

2018-02-28 11:16:50 GMT *** ChanServ sets mode: +o fcorti

2018-02-28 11:17:04 GMT *** fcorti changes topic to "Alfresco discussion and collaboration. Stick around a few hours after asking a question. Logs: http://chat.alfresco.com Channel help: https://community.alfresco.com/ Official support for Enterprise subscribers: http://support.alfresco.com. Next event is Tech Talk Live #114, the 14th of March with D.Anton about generating docs from temples and F.Malagrino with APS integration with Salesfo"

2018-02-28 11:17:45 GMT *** fcorti changes topic to "Alfresco discussion and collaboration. Stick around a few hours after asking a question. Logs: http://chat.alfresco.com Channel help: https://community.alfresco.com/ Official support for Enterprise subscribers: http://support.alfresco.com. Next event is Tech Talk Live #114, the 14th of March with D.Anton - Generating docs from templates and F.Malagrino - APS & Salesforce. https://youtu.b"

2018-02-28 11:18:18 GMT *** fcorti changes topic to "Alfresco discussion and collaboration. Stick around a few hours after asking a question. Logs: http://chat.alfresco.com Channel help: https://community.alfresco.com/ Official support for Enterprise subscribers: http://support.alfresco.com. Next event is Tech Talk Live #114, the 14th of March with Generating docs from templates and APS & Salesforce. https://youtu.be/TIupPLk8pUo"

2018-02-28 11:18:25 GMT <IanW1> alicia_: I've posted a reply in the community with a link to project that parses inbound email

2018-02-28 11:18:27 GMT <bmejias> angelborroy interesting project. So, you have to merge 3.3 CE and a 4.0 EE into a new instance?

2018-02-28 11:18:42 GMT <angelborroy> It looks like this, yes

2018-02-28 11:18:56 GMT <angelborroy> In fact, I have to decide if this is advisable or not

2018-02-28 11:22:03 GMT <bmejias> if you are merging instances, I guess the best is to do everything through Alfresco API

2018-02-28 11:22:11 GMT <bmejias> instead of trying to migrate databases.

2018-02-28 11:22:24 GMT <angelborroy> I’ve done this before

2018-02-28 11:22:44 GMT <angelborroy> We are using standard ACP import/export procedure with enhancements

2018-02-28 11:23:31 GMT <bmejias> that sounds reasonable.

2018-02-28 12:15:14 GMT <yreg> bmejias, until some UUID / PATH collides with something from the other instance

2018-02-28 12:15:30 GMT <yreg> s/PATH/name path/

2018-02-28 12:20:50 GMT <angelborroy> yreg this is why we have and “enhanced” import procedure ;-)

2018-02-28 12:37:46 GMT <bmejias> I'm not surprised angelborroy already thought about this :D

2018-02-28 12:47:21 GMT <yreg> bmejias, me neither (honestly, I remember him having a very long discussion with AFaust about the "enhanced" procedure.. so I know that he has already covered all/most angles ... :P )

2018-02-28 13:14:14 GMT <douglascrp> morning guys

2018-02-28 13:14:18 GMT <douglascrp> hey yreg

2018-02-28 13:14:24 GMT <douglascrp> have you seen my message yesterday?

2018-02-28 13:14:34 GMT <DarkStar1> morning douglascrp

2018-02-28 13:15:35 GMT <douglascrp> DarkStar1, morning dude

2018-02-28 13:15:39 GMT <douglascrp> what's up?

2018-02-28 14:03:56 GMT <bmejias> Hi douglascrp, hi DarkStar1

2018-02-28 14:04:26 GMT <douglascrp> bmejias, hey man

2018-02-28 14:04:28 GMT <hi-ko> Q: Has Admin-toos console change for synced users in 5.2? For any reason I only find internal users in user admin. From permission dialog I can find any user ...

2018-02-28 14:04:29 GMT <bmejias> DarkStar1, were you aware that fcorti join the club of young parents?

2018-02-28 14:04:49 GMT <douglascrp> bmejias, how are you?

2018-02-28 14:04:55 GMT * DarkStar1 was not aware of this

2018-02-28 14:05:06 GMT <fcorti> DarkStar1... ah

2018-02-28 14:05:08 GMT <fcorti> I am!

2018-02-28 14:05:14 GMT <fcorti> Congrats to us! :-)

2018-02-28 14:05:15 GMT <DarkStar1> @fcorti My congratulations.

2018-02-28 14:05:17 GMT <bmejias> douglascrp, I'm good... preparing a course I will give next week in London

2018-02-28 14:05:27 GMT <hi-ko> @fcorti My congratulations too!

2018-02-28 14:05:29 GMT <fcorti> well, to you too DarkStar1

2018-02-28 14:05:32 GMT <angelborroy> hi-ko are you using SOLR 6?

2018-02-28 14:05:37 GMT <fcorti> thank you hi-ko

2018-02-28 14:05:51 GMT <hi-ko> angelborroy: no default 4

2018-02-28 14:06:09 GMT <angelborroy> anyway, I think SOLR 4 is also affected

2018-02-28 14:06:12 GMT <DarkStar1> fcorti: Wear t-shirts you don't care about so much all the time. You'll smell like baby puke a lot for the next few months :)

2018-02-28 14:06:19 GMT <DarkStar1> fcorti: boy or girl?

2018-02-28 14:07:01 GMT <angelborroy> hi-ko check this page https://community.alfresco.com/docs/DOC-7294-devcon-2018-presentations

2018-02-28 14:07:02 GMT <fcorti> DarkStar1 I usually released software... now I'm release diapers!

2018-02-28 14:07:03 GMT <alfbot> Title: DevCon 2018 Presentations | Alfresco Community (at community.alfresco.com)

2018-02-28 14:07:19 GMT <angelborroy> hi-ko Talk by AFaust about Important work-arounds for making ASS multi-lingual

2018-02-28 14:07:30 GMT <fcorti> DarkStar1 boy! like yours, if I'm not wrong.

2018-02-28 14:07:33 GMT <angelborroy> I guess you are using a browser in German or so, right?

2018-02-28 14:07:59 GMT <DarkStar1> fcorti: The diapers thing you'll get used to, the throwing up thing is what people never warn you about.

2018-02-28 14:08:10 GMT <DarkStar1> fcorti: I have a girl.

2018-02-28 14:08:41 GMT <fcorti> DarkStar1: ah!!

2018-02-28 14:08:57 GMT <DarkStar1> fcorti: So never hold him for more than a few seconds after you're dressed to leave the house :)

2018-02-28 14:09:07 GMT <hi-ko> angelborroy: person opbject are not multilangual, right?

2018-02-28 14:09:15 GMT <angelborroy> right

2018-02-28 14:09:17 GMT <fcorti> eh eh

2018-02-28 14:09:30 GMT <angelborroy> so when you use a browser in non-English you don’t find users

2018-02-28 14:09:38 GMT <angelborroy> is a “new classic” issue

2018-02-28 14:09:41 GMT <hi-ko> i check

2018-02-28 14:09:50 GMT <angelborroy> Just make a simple test

2018-02-28 14:09:57 GMT <angelborroy> Use a browser in Engilsh and other in German

2018-02-28 14:10:11 GMT <angelborroy> If results are different, then you are affected by the issue

2018-02-28 14:11:52 GMT <hi-ko> <angelborroy> no: same results for english and german browser locale

2018-02-28 14:12:06 GMT <angelborroy> upload a file in German

2018-02-28 14:12:11 GMT <angelborroy> and the find the file from English

2018-02-28 14:13:31 GMT <bmejias> angelborroy "making ASS multi-lingual".... that didn't sound right to me...

2018-02-28 14:13:42 GMT <hi-ko> I'm quite pretty aware with that ugly locale rubbish but don't see the connection to the user search in Admin-Tools

2018-02-28 14:14:14 GMT <angelborroy> Default users are created associated to server locale

2018-02-28 14:14:33 GMT <angelborroy> But new users (LDAP) can be created associated to other locale

2018-02-28 14:14:47 GMT <angelborroy> This was the first problem I detected when I deployed SOLR 6 + Alfresco 5.2

2018-02-28 14:15:34 GMT <hi-ko> Alfresco and multi-lingual content properties are a long, long story of not working aproaches

2018-02-28 14:16:19 GMT <hi-ko> user search in gerneral is working from people search or permissions dialog. It's only from Admin-tools which is not working

2018-02-28 14:17:14 GMT <hi-ko> so I have to check the web scripts and what kind of pseudo logic they introduced in 5.2 ...

2018-02-28 14:17:50 GMT <angelborroy> hi-ko are you referring default Admin-Tools?

2018-02-28 14:18:05 GMT <hi-ko> yes

2018-02-28 14:18:30 GMT <angelborroy> I wasn’t aware about that bug

2018-02-28 14:18:43 GMT <angelborroy> Ok, just let us know if we can help

2018-02-28 14:19:14 GMT <hi-ko> wait: you may be right: user pref content property has : contentUrl=store://2018/2/19/15/38/e2a247cd-4f18-4a6c-978a-7683610580ec.bin|mimetype=text/plain|size=214|encoding=UTF-8|locale=de_|id=3110

2018-02-28 14:19:27 GMT <angelborroy> Ha!

2018-02-28 14:20:00 GMT <hi-ko> so what the hack - damn!

2018-02-28 14:20:16 GMT <angelborroy> If it’s a test server, deploy https://github.com/keensoft/alf-21940-repo

2018-02-28 14:20:17 GMT <alfbot> Title: GitHub - keensoft/alf-21940-repo (at github.com)

2018-02-28 14:20:25 GMT <angelborroy> Just to be sure that you are affected by the problem

2018-02-28 14:20:36 GMT <angelborroy> And then read AFaust presentation to decide how to fix it

2018-02-28 14:21:00 GMT <hi-ko> <angelborroy> thank you so much so far - I will do!

2018-02-28 14:21:10 GMT <angelborroy> you’re welcome ;-)

2018-02-28 14:46:15 GMT <yreg> hi-ko, please keep us posted with your findings

2018-02-28 14:48:23 GMT <hi-ko> It's not locale related. I found https://community.alfresco.com/thread/230023-user-search-not-working-alfresco-community-edition

2018-02-28 14:48:25 GMT <alfbot> Title: User search not working alfresco community edition | Alfresco Community (at community.alfresco.com)

2018-02-28 14:49:06 GMT <hi-ko> which gives a hint to a not working CQ if First or Last name is not synced for any user.

2018-02-28 14:49:48 GMT <hi-ko> I'chek my users and the canned query

2018-02-28 14:52:22 GMT <yreg> interesting

2018-02-28 15:07:01 GMT <douglascrp> hi-ko, I believe I faced that once

2018-02-28 15:07:26 GMT <douglascrp> if LDAP does not have some properties filled, then the search stops working

2018-02-28 15:07:29 GMT <angelborroy> yep, dougulascrp in fact he’s referring your thread :D

2018-02-28 15:07:40 GMT <douglascrp> I mean, the admin tools searching

2018-02-28 15:07:42 GMT <douglascrp> really?

2018-02-28 15:08:03 GMT <douglascrp> :D

2018-02-28 15:08:10 GMT <douglascrp> I had not checked the link

2018-02-28 15:08:13 GMT <hi-ko> douglascrp: I also remember that I hit somthing like this years ago and I bet I crated a jiira for 3.x version

2018-02-28 15:08:21 GMT <douglascrp> ok, so, now you know what I mean :D

2018-02-28 15:09:27 GMT <hi-ko> in query-people-common-SqlMap.xml I see the abscract query but it's not so easy to log the real query ...

2018-02-28 15:09:55 GMT <douglascrp> hi-ko, in order to log the real query, it is better to use a jdbc logger

2018-02-28 15:10:08 GMT <douglascrp> let me see if I can find a thread where axel gave some ideas for someone

2018-02-28 15:10:41 GMT <douglascrp> hi-ko, here https://community.alfresco.com/message/741409-re-sql-query-debug?commentID=741409#comment-741409

2018-02-28 15:10:43 GMT <alfbot> Title: sql query debug | Alfresco Community (at community.alfresco.com)

2018-02-28 15:10:53 GMT <douglascrp> p6spy is nice

2018-02-28 15:10:55 GMT <douglascrp> I tried it once

2018-02-28 15:13:04 GMT <hi-ko> Thanks2all: After fixing first and last names in AD user search is working again. I create a ticket in our support system and I will check later when I have mor time for reseach ...

2018-02-28 15:23:52 GMT <hi-ko> I will report later and dumped knoledge in an issue: https://github.com/ecm4u/alfresco-ce-repository/issues/4

2018-02-28 15:23:53 GMT <alfbot> Title: User search broken if an ldap user has no first, last name or email entry · Issue #4 · ecm4u/alfresco-ce-repository · GitHub (at github.com)

2018-02-28 16:24:34 GMT *** DragiBus_ is now known as DragiBus

2018-02-28 16:50:23 GMT <david_____> hello! is there any way to know programmatically the workspace ref from the webdav path?

2018-02-28 16:55:37 GMT <angelborroy> https://dev.alfresco.com/resource/docs/java/org/alfresco/service/cmr/model/FileFolderService.html#resolveNamePath-org.alfresco.service.cmr.repository.NodeRef-java.util.List-

2018-02-28 16:55:38 GMT <alfbot> Title: FileFolderService (Alfresco 5.3.a-SNAPSHOT API) (at dev.alfresco.com)

2018-02-28 17:01:08 GMT <david_____> thanks!

2018-02-28 17:01:44 GMT <MorganP> 5.3.a-SNAPSHOT API???

2018-02-28 17:02:00 GMT <MorganP> Wasn't the 5.2 supposed to be the latest of the Alfresco 5?

End of Daily Log

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