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-02-13 04:49:53 GMT <grendal_prime> ok i tried to add an amp and now i cant login any more.

2017-02-13 04:50:01 GMT <grendal_prime> the log file seems to be totally useless

2017-02-13 04:51:03 GMT <grendal_prime> i removed the amp and reran the setup script and still nothing . "Your authentication details have not been recognized or Alfresco may not be available at this time."

2017-02-13 06:03:31 GMT <Lostculture> hi there, i just want to find out, im using ldap authentication on my alfresco, everyone can log in fine,but i cant search for any of my contacts in user management

2017-02-13 06:43:30 GMT <grendal_prime> this blows

2017-02-13 07:40:32 GMT <grendal_prime> I just went through 2 days of hell because of a bad amp file. I wish there was a better way to install these damn things.

2017-02-13 07:43:29 GMT <grendal_prime> good news was i was able to get everything back...but my underware was in a bunch for some time.

2017-02-13 07:48:07 GMT <yreg> Morning guys

2017-02-13 07:49:56 GMT <grendal_prime> its looking better thats for sure

2017-02-13 07:53:39 GMT <yreg> ~later tell AFaust first feedback about your suggested jvm config : It is definitely not faster at first, but it looks steady and stable, and it does not slow down after a while like Alfresco's recommended settings

2017-02-13 07:53:39 GMT <alfbot> yreg: The operation succeeded.

2017-02-13 08:05:40 GMT <Lostculture> hi there, i just want to find out, im using ldap authentication on my alfresco, everyone can log in fine,but i cant search for any of my contacts in user management

2017-02-13 08:07:59 GMT <yreg> Lostculture, not even the ones that have already authenticated t oalfresco ?

2017-02-13 08:08:55 GMT <Lostculture> nope only the default one

2017-02-13 08:09:09 GMT <Lostculture> but users can log in and so on

2017-02-13 08:10:33 GMT <grendal_prime> alright things are working again for me, i need to get some sleep...try and forget what the president has done and try and not to speculate on how much more worse he could do.

2017-02-13 08:10:44 GMT *** marsv024_ is now known as marsv024

2017-02-13 08:27:23 GMT <alfbot> AFaust: Sent 33 minutes ago: <yreg> first feedback about your suggested jvm config : It is definitely not faster at first, but it looks steady and stable, and it does not slow down after a while like Alfresco's recommended settings

2017-02-13 08:29:12 GMT <AFaust> yreg: Yeah - JVM settings can't really make things "faster" in general, and I always prefer "steady & stable" without degradation

2017-02-13 08:30:04 GMT <AFaust> Even in cases where the configuration may be <= 20% slower

2017-02-13 08:44:56 GMT <yreg> Can not agree more

2017-02-13 08:45:39 GMT <yreg> AFaust, I was not complaining, I just wanted to give you feed back

2017-02-13 08:46:29 GMT <AFaust> That's how I understood it...

2017-02-13 08:46:54 GMT <AFaust> Never assume someone's complaining unless it becomes irritating...

2017-02-13 08:56:24 GMT <Lostculture> yreg, any idea why im not able to see my users

2017-02-13 09:16:25 GMT <yreg> nope

2017-02-13 09:42:51 GMT * IanW1 wonders whether it is ever a good idea to have the create.missing.person property set to true (default)?

2017-02-13 09:44:26 GMT <IanW1> (context is that I am trying to allow ldap users to log in using their email address instead of Alfresco ID and am troubled by the creation of phantom users when using IMAP (at least...))

2017-02-13 09:49:15 GMT <bhagyas> AFaust: Do you have any updates on the theming stuff you were working on?

2017-02-13 09:50:15 GMT <AFaust> Still working on these customer requirements for their specific theme. Basically fine tuning my LESS-processed presentation.css for various corner cases

2017-02-13 09:50:49 GMT <AFaust> i.e. consistent styled behaviour of YUI vs. Aikau drop-downs / buttons etc.

2017-02-13 09:51:27 GMT <AFaust> And of course handling this in different YUI contexts with different base styling (calendar vs. blog vs. anything else)

2017-02-13 09:51:52 GMT <bhagyas> Were you able to try out the LXThemes pack?

2017-02-13 09:53:45 GMT <AFaust> Not really, yet... juggling 2,5 - 3,5 projects currently

2017-02-13 09:54:52 GMT <bhagyas> ah okay - felt like you're about to redo stuff - since we've done mapping the YUI to Aikau edge cases

2017-02-13 10:00:29 GMT <yreg> fcorti, QQ: if in the report dimension I do include a path that does not exist on the FTP server, would that path be created automatically, or should I tweak the report job for that ?

2017-02-13 10:00:29 GMT <AFaust> Well - you have all the !important overrides for a lot Aikau CSS with hardcoded color values.

2017-02-13 10:00:59 GMT <AFaust> What I am doing is creating an Aikau-like CSS for the global theme which uses the LESS variables from the theme XML

2017-02-13 10:01:35 GMT <AFaust> and which tries to use proper CSS rule nesting / selectors to avoid !important

2017-02-13 10:01:57 GMT <fcorti> yreg: no, the path won't be created automatically. I usually use this together with a rule in the drop zone (an Alfresco space).

2017-02-13 10:02:18 GMT <AFaust> So far I only really needed 2 !important rules (*crosses fingers*)

2017-02-13 10:02:56 GMT <yreg> fcorti, aha, so the rule would move the file to the correct path and create it if necessary !

2017-02-13 10:05:10 GMT <fcorti> yreg: exactly, this is the idea

2017-02-13 10:05:25 GMT <fcorti> you could play also extracting informations from the documents (like metadata, for example)

2017-02-13 10:05:36 GMT <yreg> easiest way would be to create an execute script action

2017-02-13 10:05:42 GMT <fcorti> if you export a report in csv/xml format

2017-02-13 10:05:48 GMT <AFaust> bhagyas: I am working on this particular project for only about 1 - 2 days a week - so progress is not as significant as it could be

2017-02-13 10:06:06 GMT <AFaust> Also focussed on TinyMCE editor / preview styling last week

2017-02-13 10:06:15 GMT <AFaust> specifically for the wiki

2017-02-13 10:07:06 GMT <yreg> Aha, you have a switch case on extension to determine which format to use for publishing

2017-02-13 10:08:53 GMT <fcorti> yreg: exactly and you can very easily enrich the supported formats, for specific needs

2017-02-13 10:23:52 GMT <bhagyas> AFaust: The color !importants you have probably seen are within the generated CSS files, but the actual theme contains LESS variables

2017-02-13 10:23:52 GMT <bhagyas> :D

2017-02-13 10:24:25 GMT <AFaust> My approach is for runtime LESS...

2017-02-13 10:24:27 GMT <bhagyas> instead of relying on the kindness of the strangers/Aikau/Runtime LESS compilers, we take a early approach

2017-02-13 10:24:42 GMT <yreg> Guys, is there any reason why would this statement run very slowly on an MSSQL server : http://pastebin.com/qPH2fs2t

2017-02-13 10:24:43 GMT <alfbot> Title: [SQL] SQL Statement - Pastebin.com (at pastebin.com)

2017-02-13 10:24:47 GMT <bhagyas> because runtime LESS doesn't sound like a great idea, considering the performance we've seen with Aikau

2017-02-13 10:25:13 GMT <bhagyas> and the lack of investment in terms of runtime compilation performance

2017-02-13 10:28:02 GMT <AFaust> yreg: Because MSSQL is crap?

2017-02-13 10:29:00 GMT <bhagyas> yreg: You have many CASE WHEN's within the SELECT block

2017-02-13 10:29:05 GMT <bhagyas> which might not be a very good idea

2017-02-13 10:29:36 GMT <bhagyas> try running the query without them

2017-02-13 10:29:42 GMT <AFaust> Recently had a customer with performance degradation for DB FTS queries on MS SQL, and their query plan re-use doesn't even take parameters into account by default and for some reason "recompilation" could not be enabled globally as per the documentation...

2017-02-13 10:32:16 GMT <bhagyas> Also try a SQL Query analyser

2017-02-13 10:32:22 GMT <bhagyas> I think MSSQL ships with one

2017-02-13 10:32:39 GMT * IanW1 *fond* memories of comparing mssql vs oracle performance with FTS... (one was somewhat quicker)

2017-02-13 10:33:06 GMT <bhagyas> It's been more than 6 years since I was at regular Microsoft SQL Server meetups

2017-02-13 10:33:09 GMT <bhagyas> :D

2017-02-13 10:34:18 GMT <yreg> AFaust, IanW1 this is an OOTB query used heavily when tracking changes

2017-02-13 10:34:33 GMT <yreg> and it takes 6-20 s to run

2017-02-13 10:34:39 GMT <yreg> according to my profiler

2017-02-13 10:44:56 GMT <AFaust> bhagyas: BTW - using a properly written, pure Java LESS processor, I have close-to eliminated the runtime LESS overhead

2017-02-13 10:45:17 GMT <Loftux> Any information on how to configure CSRF for repo in 201701GA? I cannot use the workflow console :(

2017-02-13 10:45:38 GMT <AFaust> Integrated JLessC into my utility module during the weekend (https://github.com/i-net-software/jlessc) - only waiting for 1.6 with a fix for the only issue I could find

2017-02-13 10:45:39 GMT <alfbot> Title: GitHub - i-net-software/jlessc: Less CSS compiler written in Java (at github.com)

2017-02-13 10:45:52 GMT <AFaust> Loftux: Did you see the post on community.alfresco.com?

2017-02-13 10:46:01 GMT <AFaust> https://community.alfresco.com/thread/228162-hitting-csrf-when-trying-to-use-the-workflow-admin-console

2017-02-13 10:46:03 GMT <alfbot> Title: Hitting CSRF when trying to use the workflow ad... | Alfresco Community (at community.alfresco.com)

2017-02-13 10:46:19 GMT <AFaust> Configuration is exactly the same as for Share-tier - they just copied the filter

2017-02-13 10:46:45 GMT <AFaust> web-scripts-config-custom.xml is the file in extension-path for overrides

2017-02-13 10:48:02 GMT <AFaust> Loftux: For some reason I did not encounter any issues with 201612 GA and could not reproduce the problem. And based on the config files I grep'ed this weekend the CSRF filter is already active there and I was even able to breakpoint into it...

2017-02-13 10:49:19 GMT <Loftux> csrf token is set to null -> /alfresco/s/admin/admin-workflowconsole?t=%2Fadmin%2Fadmin-workflowconsole&alf-csrftoken=null

2017-02-13 10:52:04 GMT <AFaust> I know - because for non-Enterprise admin console the default rules do not specify to re-generate the token

2017-02-13 10:52:36 GMT <AFaust> Default rules only aim for Enterprise Admin Console (for some strange reason that will likely turn out to be "tunnel vision")

2017-02-13 11:00:13 GMT <Loftux> AFaust: So the only solution to use wf console is to turn off csrf then?

2017-02-13 11:01:00 GMT <AFaust> No - again, the CSRF filter is active on my system and I did not have any issues.

2017-02-13 11:01:43 GMT <AFaust> I also believe the more correct solution would be to add the rule to re-generate the token for the Community admin console to the default config...

2017-02-13 11:01:52 GMT <AFaust> Just to be sure a valid token exists

2017-02-13 11:03:03 GMT <Loftux> AFaust: No time for digging into that, after an upgrade broken activity wf breaks invites. Have to quickly see if I can delete.

2017-02-13 11:04:58 GMT <AFaust> Ok - so then the "quick and dirty" solution is to disable CSRF, yes

2017-02-13 13:56:52 GMT <douglascrp> has anyone seen this error message on 5.2:

2017-02-13 13:56:57 GMT <douglascrp> Error querying database. Cause: java.lang.IllegalStateException: Received resultset tuples, but no field structure for them

2017-02-13 13:57:13 GMT <douglascrp> it appears when the user clicks the link to change the document library items' order

2017-02-13 13:57:25 GMT <douglascrp> if you click more than once

2017-02-13 13:58:24 GMT <douglascrp> the stack trace http://pastebin.com/dGpVABaV

2017-02-13 13:58:25 GMT <alfbot> Title: 2017-02-13 14:55:15,943 ERROR [extensions.webscripts.AbstractRuntime] [http-nio - Pastebin.com (at pastebin.com)

2017-02-13 13:59:28 GMT <AFaust> douglascrp: Not seen this so far...

2017-02-13 13:59:38 GMT <douglascrp> weird

2017-02-13 13:59:59 GMT <douglascrp> this one is running with postgresql

2017-02-13 14:00:27 GMT <AFaust> I am always running with postgresql locally - is this with 201701 GA or 201612 GA?

2017-02-13 14:03:34 GMT <douglascrp> alfresco-platform-5.2.e.war and share-5.2.d.war

2017-02-13 14:04:10 GMT <douglascrp> so, 201601-ga equivalent

2017-02-13 14:07:41 GMT <AFaust> you mean 201701 GA

2017-02-13 14:08:00 GMT <douglascrp> AFaust, yes, sorry

2017-02-13 14:08:00 GMT <AFaust> 201601 was 5.1 ...

2017-02-13 14:08:21 GMT <douglascrp> you are right... I have to get used with the 2017 year :D

2017-02-13 14:10:12 GMT <douglascrp> I was reading some messages somewhere, and now I'm in doubt about what repository I should be using to get a alfresco-community repo clone

2017-02-13 14:10:18 GMT <douglascrp> github is obsolete

2017-02-13 14:16:33 GMT <douglascrp> never mind... found it https://community.alfresco.com/docs/DOC-4874-source-code

2017-02-13 14:16:36 GMT <alfbot> Title: Source Code | Alfresco Community (at community.alfresco.com)

2017-02-13 14:53:36 GMT <yreg> douglascrp, ping

2017-02-13 15:27:36 GMT <Vasquez> hi guys, can someone take a look on this log, and tell me what whould cause this warn to appear, almost daily

2017-02-13 15:27:40 GMT <Vasquez> http://pastebin.com/bYRHpjWL

2017-02-13 15:27:41 GMT <alfbot> Title: [Apache Log] 2017-01-10 12:08:55,776 WARN [webscripts.connector.RemoteClient] [http-apr-80 - Pastebin.com (at pastebin.com)

2017-02-13 15:29:02 GMT <AFaust> Vasquez: The error is exactly what it says it is - a "ClientAbortException", meaning that a client aborted the connection before the server had a chance to send a respone back

2017-02-13 15:29:49 GMT <AFaust> This can happen if a user cancels a page load, closes a browser while a load is in progress or any kind of request timeout feature automatically cancels HTTP requests (e.g. for Xhr)

2017-02-13 15:32:01 GMT <Vasquez> ok, i thought similar but the fact that it appeared for 130 times over month looked a bit strange to me, i guess they have very impatient user :D

2017-02-13 16:01:51 GMT <douglascrp> yreg, pong

2017-02-13 16:01:53 GMT <douglascrp> hey dude

2017-02-13 16:40:12 GMT <douglascrp> yreg, you around?

2017-02-13 16:56:11 GMT <douglascrp> AFaust, hey

2017-02-13 16:56:18 GMT <AFaust> ho

2017-02-13 16:56:20 GMT <douglascrp> I'm almost done with the portuguese translation for support-tools

2017-02-13 17:12:59 GMT <AFaust> douglascrp: cool

2017-02-13 17:15:27 GMT <douglascrp> I hope to be able to finish it tomorrow or the day after

2017-02-13 19:31:33 GMT <jpotts> Does anyone know if the out-of-the-box LDAP config can be set to only allow a subset of users to authenticate? I'm not talking about sync'ing a subset of users/groups, I'm talking about denying authentication to users who don't match an LDAP query

2017-02-13 19:31:48 GMT <jpotts> Use case would be allowing only members of certain groups to authenticate, for example

2017-02-13 19:51:09 GMT <yregaieg> jpotts, I can think of one way to do that, but it is a bit tricky

2017-02-13 19:51:36 GMT <yregaieg> you will need to setup sync for the required subset of users/groups

2017-02-13 19:51:46 GMT <jpotts> _nods_

2017-02-13 19:51:57 GMT <yregaieg> and set authentication subsystem to not automatically create missing accounts

2017-02-13 19:52:08 GMT <jpotts> yes, that's what I was thinking

2017-02-13 19:52:39 GMT <jpotts> okay, I'll give that a shot. thanks yregaieg

2017-02-13 19:54:16 GMT <AFaust> jpotts: Why not simply have two LDAP subsystems? One for synchronization (with broader query) and one for authentication (using a narrower lookup query and no configured userNameFormat to force DN resolution as part of login) - all configured against the same LDAP...

2017-02-13 19:54:55 GMT <AFaust> There is no requirement that the user being authentication must have been synchronized by the same subsystem...

2017-02-13 19:55:37 GMT <jpotts> That would have the advantage of being able to have the entire set of users and groups in Alfresco while still restricting those who can authenticate

2017-02-13 19:55:47 GMT <AFaust> Exactly

2017-02-13 19:56:14 GMT <jpotts> Okay, I'll look at that. Those are two workable options. Thanks guys.

2017-02-13 20:03:46 GMT <bmejias> interesting solution AFaust. I have to use something similar for authenticating users from different domains on the same LDAP

2017-02-13 20:04:07 GMT <bmejias> adent@cibg.brussels and proche@cirb.brussels

2017-02-13 20:04:19 GMT <bmejias> but they just log in with either adent or proche

2017-02-13 20:08:48 GMT <yreg_> ~flushlog

2017-02-13 20:08:48 GMT <alfbot> yreg_: Woooosh, your log has been flushed...

2017-02-13 20:10:09 GMT <yreg_> bmejias, Did I already say thank you ?

2017-02-13 20:10:33 GMT <bmejias> yreg_ for what?

2017-02-13 20:10:47 GMT <bmejias> I do remember I thank you some days ago

2017-02-13 20:11:07 GMT <bmejias> but following the conversation I thought it was for someone else :)

2017-02-13 20:11:10 GMT <yreg_> For a very cool tradition we have @ Xenit we call Plofball <grin>

2017-02-13 20:11:26 GMT <bmejias> ah... hahaha... you guys are still playing that?

2017-02-13 20:11:34 GMT <yreg_> and I have been told it was you and toon who started it !

2017-02-13 20:11:36 GMT <bmejias> we should do a tournament at BeeCon

2017-02-13 20:11:40 GMT <yreg_> On a daily basis

2017-02-13 20:11:47 GMT <yreg_> we have tournaments for that :D

2017-02-13 20:11:55 GMT <bmejias> Toon and Thijs

2017-02-13 20:12:07 GMT <bmejias> we had a poweroutage

2017-02-13 20:12:18 GMT <bmejias> and carried on working without electricity of internet...

2017-02-13 20:12:23 GMT <bmejias> until we ran out of batteries...

2017-02-13 20:12:54 GMT <bmejias> then we started thinking about fun stuff, and that's how we created the plofball.

2017-02-13 20:13:11 GMT <yreg_> Yeah, heard the story

2017-02-13 20:15:23 GMT <bmejias> https://www.youtube.com/watch?v=nEK6lkqzNMY

2017-02-13 20:21:41 GMT <yreg_> hehe, I have been told you were really good! but if that's how you play, I can easily win against you <grin>

2017-02-13 20:22:39 GMT <douglascrp> I'll have to watch that :D

2017-02-13 20:22:41 GMT <douglascrp> later

2017-02-13 20:22:52 GMT <douglascrp> guys, is anyone of you using ADF in production:

2017-02-13 20:23:00 GMT <douglascrp> I am thinking about trying it

2017-02-13 20:23:16 GMT <douglascrp> I have a requirement to create a custom application where the users will be able to only read content

2017-02-13 20:23:26 GMT <douglascrp> no content update at all will be allowed

2017-02-13 20:23:38 GMT <douglascrp> the users that are going to create or change content will use share

2017-02-13 20:29:19 GMT <bmejias> yreg_ that was a tutorial

2017-02-13 20:29:33 GMT <bmejias> the pace it's slowed down... hahaha

2017-02-13 20:29:50 GMT <bmejias> no, really, I used to be good... but Toon and Thijs were the best....

2017-02-13 20:30:06 GMT <bmejias> and not playing in more than three years probably put me back to the second divison.

2017-02-13 20:30:49 GMT <yreg_> I can easily win against Toon, but Thijs is still very good

2017-02-13 20:31:08 GMT <yreg_> he usually wins with 3-5 points difference against me

2017-02-13 20:31:33 GMT <yreg_> douglascrp, I would've opted for Aikau, not ADF, but that's just me :)

2017-02-13 20:31:47 GMT <AFaust> douglascrp: I'd be surprised if anyone is using ADF in production at this point. It still is for early adopters...

2017-02-13 20:32:05 GMT <yreg_> in Aikau, such an app shouldn't be more than a couple of days of work

2017-02-13 20:32:19 GMT <bmejias> we will see in Zaragoza...

2017-02-13 20:32:32 GMT <bmejias> gotta go now... have fun guys...

2017-02-13 20:32:32 GMT <bmejias> cheers

2017-02-13 20:38:41 GMT <douglascrp> AFaust, yreg_ yes, I have to agree on that

2017-02-13 20:38:52 GMT <douglascrp> maybe a custom app just like the one created in the tutorial will be enough

2017-02-13 20:39:32 GMT <yreg_> douglascrp, and you will always have the source-code from Alfresco Share to get some inspiration hehe

2017-02-13 20:43:05 GMT <douglascrp> yreg_, yes, that's right

2017-02-13 20:43:15 GMT <douglascrp> ok, thank you guys for the idea

2017-02-13 20:43:29 GMT <douglascrp> I completely forgot about aikau

End of Daily Log

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