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

2017-12-20 08:14:33 GMT <twen> hello

2017-12-20 08:15:29 GMT <Tichodroma> Good Morning (UGT)

2017-12-20 08:16:48 GMT <yreg> MORNING !

2017-12-20 08:17:59 GMT <owerfelli> morning

2017-12-20 08:21:40 GMT <yreg> owerfelli, is Averroes getting a brand new face with angular/ADF ?

2017-12-20 08:24:34 GMT <owerfelli> Yreg we'll release 3.0 version by the end of the year, it has many new features

2017-12-20 08:26:45 GMT <owerfelli> but not yet with ADF

2017-12-20 08:27:25 GMT <yreg> That would be a nice thing to see

2017-12-20 08:27:43 GMT <yreg> did it finally catch up with latest alfresco version ?

2017-12-20 08:28:03 GMT <yreg> (at least last GA)

2017-12-20 08:29:26 GMT <DarkStar1> Morning everyone

2017-12-20 08:29:28 GMT <owerfelli> no no :/ we migrated repo to 5.0.d, but until know we can't migrate share

2017-12-20 08:31:11 GMT <MorganP> Hi all

2017-12-20 08:43:21 GMT <yreg> come on owerfelli I was the one who migrated repo to 5.0.d almost 2 years ago

2017-12-20 08:43:32 GMT <yreg> wasn't that released yet ?

2017-12-20 08:48:37 GMT <owerfelli> yep, but you know its a lot of work and there is many features

2017-12-20 08:52:17 GMT <owerfelli> but know we can migrate to new versions simply

2017-12-20 08:53:21 GMT <owerfelli> but problem still in share

2017-12-20 11:14:50 GMT <yreg> owerfelli, have you actually attempted that simple upgrade to versions newer than 5.0.d ?

2017-12-20 11:15:17 GMT <yreg> simply will turn out tyo be not as simple as perceived

2017-12-20 11:20:17 GMT <owerfelli> really ! I don't get tried that before!

2017-12-20 11:24:15 GMT <owerfelli> the version that will be released is CR, so we don't support data of earlier versions

2017-12-20 11:25:42 GMT <owerfelli> in the GA version we must support or migrate data of others versions

2017-12-20 12:24:07 GMT <bhuvana> hi all

2017-12-20 12:24:38 GMT <bhuvana> can we upgrade yui library in alfresco

2017-12-20 12:40:09 GMT <yreg> bhuvana, given the opensource nature of the project it is definitely possible, but probably doesn't worth the effort

2017-12-20 12:40:30 GMT <yreg> what do you need that for ?

2017-12-20 12:40:54 GMT <Tichodroma> hasn't YUI been deprecated for years?

2017-12-20 12:42:29 GMT <yreg> Tichodroma, that's one of the reasons I said it is probably not worth it

2017-12-20 12:43:09 GMT <bhuvana> yreg,The vulnerability is on the YUI [Framework] in Alfresco community edition, while displaying the files [video] YUI Java script library will render onto the browser by uploading video files.

2017-12-20 12:50:46 GMT <yreg> do you have a reference link ?

2017-12-20 12:51:03 GMT <yreg> if it is serious enough Alfresco would have done it themselves

2017-12-20 12:54:14 GMT <AFaust> Any MySQL experts here? My Google-Fu is failing me, and I refuse to believe that this is simply not possible.

2017-12-20 12:55:05 GMT <angelborroy> I’m not an expert, but you can try

2017-12-20 12:55:09 GMT <AFaust> I need a SQL query to parse an ISO8601 formatted date value (which is how Alfresco stores dates) as part of a selector condition (i.e. max(timestamp)), and then format it again as ISO8601

2017-12-20 12:56:24 GMT <AFaust> I cannot find a formatting symbol for milliseconds - only microseconds. And all the examples I find of ISO 8601 ignore the milliseconds

2017-12-20 12:56:35 GMT <angelborroy> obviously it’s not listed at https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html

2017-12-20 12:56:36 GMT <alfbot> Title: MySQL :: MySQL 5.7 Reference Manual :: 12.7 Date and Time Functions (at dev.mysql.com)

2017-12-20 12:58:13 GMT <angelborroy> it looks like is not available for MySQL

2017-12-20 12:58:15 GMT <angelborroy> https://prestodb.io/docs/current/functions/datetime.html

2017-12-20 12:58:16 GMT <alfbot> Title: 6.12. Date and Time Functions and Operators — Presto 0.191 Documentation (at prestodb.io)

2017-12-20 12:58:33 GMT <angelborroy> This is an extension with a from_iso8601_timestamp(string)

2017-12-20 13:01:09 GMT <AFaust> Oh boy - I just need a simple query to return min/max value of a specific date/datetime property, which is also capable of dealing with broken dates (some migration tools and Alfresco Outlook integration have created dates like 1-01-12T23:12:32.124Z)

2017-12-20 13:01:35 GMT <angelborroy> “simple query”

2017-12-20 13:01:47 GMT <angelborroy> probably this is not the case

2017-12-20 13:01:51 GMT <AFaust> Normal min/max on string values does not work, because due to the variable number of digits for year, a date in year 2018 would be sorted before year 210

2017-12-20 13:02:34 GMT <angelborroy> you need to parse the date and to transform it to a timestamp

2017-12-20 13:02:52 GMT <AFaust> right, that's why I am looking for a proper way to parse ISO dates

2017-12-20 13:03:09 GMT <AFaust> And then I need to format the min/max timestamp back to ISO 8601 date so I can work with it in Alfresco

2017-12-20 13:03:17 GMT <angelborroy> I see

2017-12-20 13:03:30 GMT <angelborroy> sorry, but I’m not so skilled (in general)

2017-12-20 13:03:48 GMT <AFaust> Of course without modifying the value i.e. by chopping of milliseconds

2017-12-20 13:04:05 GMT <AFaust> I'm just amazed that this is missing in MySQL...

2017-12-20 13:04:34 GMT <angelborroy> probably you can develop a function

2017-12-20 13:04:38 GMT <AFaust> Well, not "amazed" as I know MySQL has various drawbacks leading it to no longer be the prime choice for OSS databases...

2017-12-20 13:04:41 GMT <angelborroy> or took some function from Google

2017-12-20 13:06:11 GMT <AFaust> I'm considering a hack to simply add 3 0's before the Z in the ISO 8601 string, then parse it using the microseconds formatting symbold, format it back the same way and then strip out the 3 0's again. But I cannot imagine this to be efficient...

2017-12-20 13:14:06 GMT <yreg> AFaust, found this in the page listed by angelborroy : https://pastebin.com/d1iTrNDA

2017-12-20 13:14:07 GMT <alfbot> Title: [MySQL] ISO6801-MySQL - Pastebin.com (at pastebin.com)

2017-12-20 13:14:21 GMT <yreg> might help with some minor fiddling

2017-12-20 13:17:56 GMT <yreg> AFaust, PS UNIX_TIMESTAMP can handle microseconds

2017-12-20 13:18:28 GMT <AFaust> You mean milliseconds...

2017-12-20 13:18:45 GMT <yreg> exact

2017-12-20 13:19:17 GMT <AFaust> Too bad is I would still need some crazy date math to combine this with the rest of the ISO 8601 parsing to get something going.

2017-12-20 13:19:43 GMT <yreg> actually knowing that Alfresco only stores dataes in UTC that function can be optimized to only include the part before Z and to replace "T" with space

2017-12-20 13:23:15 GMT <AFaust> Problem is I need to avoid too much overhead due to String manipulation since this query may run on an arbitrarily large database / amount of property values (think cm:modified)

2017-12-20 13:26:04 GMT <yreg> AFaust, is this actually the value you have "1-01-12T23:12:32.124Z)" or is it "1-01-12T23:12:32.124Z" ?

2017-12-20 13:27:28 GMT <yreg> (I am referring to the broken dates)

2017-12-20 13:40:09 GMT <yreg> AFaust, is this actually the value you have "1-01-12T23:12:32.124Z)" or is it "1-01-12T23:12:32.124Z" ?

2017-12-20 13:40:12 GMT <yreg> (I am referring to the broken dates)

2017-12-20 13:41:10 GMT <AFaust> The second... why do you think there would be a )?

2017-12-20 13:41:45 GMT <AFaust> The ) in my statement was just the closing parantheses to mark the end of the additional remark

2017-12-20 13:42:06 GMT <AFaust> which I started with "(some migratoin tools ..."

2017-12-20 13:42:47 GMT <AFaust> I guess I am going to go with a replace-parse-min/max-format-replace hack, i.e.

2017-12-20 13:44:00 GMT <AFaust> select replace(date_format(max(str_to_date(replace(audit_creared, 'Z', '000Z'), '%Y-%m-%dT%T.%fZ')), '%Y-%m-%dT%T.%fZ'), '000Z', 'Z') ...

2017-12-20 13:44:58 GMT <AFaust> Which basically is what I mentioned earlier - insert 3 0's before the Zulu designator, parse that for the selector function, then format and remove 3 0's again

2017-12-20 13:48:48 GMT <yreg> is it less performant if you run min/max on strings ?

2017-12-20 13:49:29 GMT <yreg> I think a simple lpad would cost way less than a replace

2017-12-20 13:52:19 GMT <yreg> AFaust, regarding the ")" I forgot about it being opened earlier in the same phrase

2017-12-20 13:53:42 GMT <AFaust> yreg: problem with lpad is I'd need to do a complex logic function to determine how many 0's I need to pad, which requires I already know the max date

2017-12-20 13:54:15 GMT <yreg> afaust not sure about that

2017-12-20 13:54:34 GMT <AFaust> Well, if I have dates like

2017-12-20 13:55:01 GMT <AFaust> 1-01-12T23:12:32.124Z and biggest date is 1901-01-12T23:12:32.124Z I need to pad the first by 3 0's, but if I have 10001-01-12T23:12:32.124Z I need 4

2017-12-20 13:55:17 GMT <AFaust> Sure, it is academical in some parts because why would I have such dates?

2017-12-20 13:55:44 GMT <AFaust> But broken dates can be anything from 1 to 3 digit years, and what if I don't have a single correct date?

2017-12-20 13:57:46 GMT <yreg> AFaust, SELECT LPAD("1-01-12T23:12:32.124Z", 30, "0") AS LeftPadDat; <grin>

2017-12-20 13:58:49 GMT <yreg> this will probably still be way more performant, but I assume you would still skeptical as you might have dates such as 10000000001-01-12T23:12:32.124Z

2017-12-20 13:59:51 GMT <yreg> in that case, I would first run a query for the max str length for all dates, and use that as parameter to my query

2017-12-20 14:00:04 GMT <AFaust> Ok - I did not consider brute-force "just add crazy amounts of 0's" - I only considered the clean "add as many 0's as I need" approach

2017-12-20 14:00:12 GMT <yreg> no need to know the exact max upfront, only the max length is needed

2017-12-20 14:16:01 GMT <dgradecak> hi fcorti and all

2017-12-20 14:16:34 GMT <dgradecak> fcorti: I have 2 other guys willing to come to the devcon, but seems that there is a waiting list now?

2017-12-20 14:16:43 GMT <fcorti> Hi dgradecak

2017-12-20 14:16:55 GMT <fcorti> Yes, confirmed.

2017-12-20 14:17:06 GMT <fcorti> The DevCon is fully booked.

2017-12-20 14:17:08 GMT <fcorti> But...

2017-12-20 14:17:20 GMT <fcorti> Kristen is working hard to "clean" the list of registrations.

2017-12-20 14:17:49 GMT <dgradecak> ok, how to know for those two extra bookings than ?

2017-12-20 14:17:57 GMT <fcorti> I mean: considering that it is a free event, it's will probably happen that people registered but then they don't come.

2017-12-20 14:18:02 GMT <fcorti> We won't accept this.

2017-12-20 14:18:15 GMT <fcorti> So, we are going to ask to all the registered users a confirmations.

2017-12-20 14:18:36 GMT <fcorti> If the confirmation won't come, we will skip them and go to the waitlist.

2017-12-20 14:18:47 GMT <dgradecak> aha ok, because do not want to book plane tickets if there is no place

2017-12-20 14:19:15 GMT <fcorti> To your point: we cannot extend the people in the venue (we have a limited capacity).

2017-12-20 14:19:24 GMT <dgradecak> I know indeed

2017-12-20 14:19:54 GMT <dgradecak> could you somehow alert "us" if there is free places?

2017-12-20 14:20:24 GMT <dgradecak> should we put them on the waiting list already?

2017-12-20 14:20:26 GMT <fcorti> Kristen will do it, once someone will be moved from the witlist to the official registration.

2017-12-20 14:20:39 GMT <fcorti> And you can contact her (or me) for an update

2017-12-20 14:21:18 GMT <dgradecak> should I ping you tomorrow or later?

2017-12-20 14:21:19 GMT <fcorti> If you write to devcon@alfresco.com, both we will read the message.

2017-12-20 14:21:45 GMT <dgradecak> ok, I will pass this to someone than he could ping you about that, is that ok?

2017-12-20 14:21:52 GMT <fcorti> yep

2017-12-20 14:21:54 GMT <fcorti> no prob

2017-12-20 14:23:01 GMT <dgradecak> thank you

2017-12-20 14:23:10 GMT <fcorti> yw

2017-12-20 20:43:14 GMT <brian-int> hey guys, I am currently trying to apply a regular amp and an amps_share amp that are in their respective dirs, but when I run sudo apply_amps.sh, I get the following error:

2017-12-20 20:43:44 GMT <brian-int> ```

2017-12-20 20:43:44 GMT <brian-int> 11190001 An error was encountered during deployment of the AMP into the WAR: 11190000 ERROR: The amp will overwrite an existing file in the war '/WEB-INF/lib/commons-lang-2.6.jar'. Execution halted. By specifying -force , you can force installation of AMP regardless of the current war state.

2017-12-20 20:43:44 GMT <brian-int> ```

2017-12-20 20:49:03 GMT <brian-int> should I be using force? or do I want to manually install it using `java -jar alfresco-mmt.jar install ...`

2017-12-20 20:49:05 GMT <brian-int> ?

2017-12-20 20:54:16 GMT <brian-int> anyone?

2017-12-20 20:58:42 GMT <brian-int> also, I'm noticing slowness and seeing a few `ERROR [org.alfresco.filesys.auth.cifs.EnterpriseCifsAuthenticator] [AlfJLANWorker8] Unable to decode the SPNEGO token

2017-12-20 20:58:42 GMT <brian-int> java.io.IOException: ASN.1 type 0x0 decode not supported` exceptions in my alfresco.log, surely this isn't normal?

2017-12-20 21:56:36 GMT <AFaust> brian-int: You should not include any JARs in your AMPs that are already included / provided by Alfresco.

2017-12-20 21:57:06 GMT <AFaust> You can use -force to override such conflicts, but for clean module development, such conflicts should be avoided

2017-12-20 21:58:24 GMT <AFaust> I also recommend disabling CIFS. That feature will be / is being removed by Microsoft from Windows 10, and there is no point in keeping it enabled in Alfresco. Use AOS / WebDAV instead for network drive access.

2017-12-20 21:59:58 GMT <AFaust> I have not seen that particular SPNEGO error message before, so I cannot say anything as to its cause. But of course it is not normal and should not occur, though it does not matter if / when you disable CIFS altogether as an obsolete / unusable feature.

2017-12-20 22:05:49 GMT <brian-int> AFaust: thanks for the reply. Can CIFS be disabled from within the (admin) UI? or is this a conf file setting somewhere? Re. the .AMPs, they are not mine, but I can let upstream know to not do that (I assume they are overriding/extending the methods? what would be a good workaround?)

2017-12-20 23:36:33 GMT *** mmccarthy1 is now known as mmccarthy

End of Daily Log

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