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.
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 firstname.lastname@example.org, 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
The other logs are at http://esplins.org/hash_alfresco