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-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?
The other logs are at http://esplins.org/hash_alfresco