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-09-15 07:14:43 GMT <DarkStar1> Good morning everyone
2017-09-15 07:21:28 GMT <yreg> Morning everyone !
2017-09-15 07:21:32 GMT <yreg> Morning Lanre
2017-09-15 08:54:24 GMT *** angelborroy_ is now known as angelborroy
2017-09-15 10:23:33 GMT <mp_> hello
2017-09-15 10:24:34 GMT <mp_> have question abot hard/soft links - scriptNode.addNode() create relations that is analogue of hard link?! how create something simmilar to softlink?
2017-09-15 10:43:32 GMT <AFaust> mp_: Alfresco really doesn't have something that can be considered a "soft link", e.g. that links only based on path and not a reference. Basically Alfresco has a "consistent, transparent hard link" and a "breakable, proxy hard link". With addNode() you are creating the first. The second type is possible by creating a node of type cm:link that has a property cm:destination that refers to the identity of the target.
2017-09-15 10:44:37 GMT <AFaust> The advantage of the second type is that you can restrict the visibility on the link separately from the permissions of the actual target, e.g. you can add additional restrictions that you might not want to set on the target itself.
2017-09-15 10:45:02 GMT <mp_> I
2017-09-15 10:46:16 GMT <mp_> I trying find the way to block removing original node form the not primary parent( not sure decription will help)
2017-09-15 10:46:55 GMT <mp_> But tnx. Your explanation have clarifyed fiew points for me
2017-09-15 12:40:52 GMT *** hobzalud is now known as nsoft
2017-09-15 12:42:38 GMT *** hobzalud is now known as tar
2017-09-15 12:44:06 GMT *** DragiBus_ is now known as DragiBus
2017-09-15 13:05:00 GMT <douglascrp> good morning
2017-09-15 13:08:05 GMT <DarkStar1> douglascrp: howdy
2017-09-15 13:08:17 GMT <MTielemans> hey there
2017-09-15 13:14:28 GMT <douglascrp> DarkStar1, fine
2017-09-15 13:14:30 GMT <douglascrp> you?
2017-09-15 14:07:47 GMT <DarkStar1> douglascrp: Hey dude. Sorry for the late response. I'm quite busy here.
2017-09-15 14:08:27 GMT <DarkStar1> but I do have to go now. :(
2017-09-15 14:08:36 GMT <DarkStar1> douglascrp: will ping uou later on WA
2017-09-15 14:33:11 GMT <MTielemans> ~since
2017-09-15 14:33:11 GMT <alfbot> MTielemans: Either MTielemans didn't leave, or no messages were sent while MTielemans was gone.
2017-09-15 15:55:57 GMT <eswbitto> I'm getting a server error that the DB connection pool is depleted.
2017-09-15 15:56:52 GMT <eswbitto> Would changing the settings in alfresco-global.properties create any issues with regard? to something much higher than 275
2017-09-15 16:03:05 GMT <yregaieg> eswbitto, as long as your DB server can handle that many connection (spec + config) it should be fine
2017-09-15 16:04:00 GMT <eswbitto> yregaieg what spec just number of cpu's?
2017-09-15 16:05:06 GMT <yregaieg> it is good practice to set the pool size to the maximum number of threads that theoretically can co-exist on your instance on a certain point in time (max number of HTTP worker threads + max number of async actions + max number of worker threads in scheduled jobs ... etc)
2017-09-15 16:05:57 GMT <yregaieg> eswbitto, you can not expect a server with 2 CPUs and 4 G of ram to be able to handle 10000 connections simultaneously, your hard need to be able to survive the load
2017-09-15 16:06:31 GMT <yregaieg> plus depending on DB server there should be some config to set the maximum number of connections
2017-09-15 16:06:51 GMT *** yregaieg is now known as yreg
2017-09-15 16:09:38 GMT <eswbitto> I have 8 cpu's and 18 GB of total Ram on the server...I have 12 GB set for java
2017-09-15 16:10:14 GMT <yreg> was referring to the hard for DB server not application server, or is it the same host ?
2017-09-15 16:10:33 GMT <eswbitto> its on the same host.....its the built in postgresql
2017-09-15 16:10:51 GMT <yreg> not a good idea if you want to scale up
2017-09-15 16:11:05 GMT <eswbitto> hmm
2017-09-15 16:11:21 GMT <eswbitto> so I should move my DB server to another host?
2017-09-15 16:12:32 GMT <eswbitto> yreg the problem I'm running into is that the growth is rapidly overtaking the available hardware.
2017-09-15 16:12:59 GMT <yreg> not sure what is the default setting for maximum number of connections on shipped postgres, but by default docs says it is 100
2017-09-15 16:13:25 GMT <yreg> https://www.postgresql.org/docs/9.6/static/runtime-config-connection.html
2017-09-15 16:13:26 GMT <alfbot> Title: PostgreSQL: Documentation: 9.6: Connections and Authentication (at www.postgresql.org)
2017-09-15 16:14:19 GMT <yreg> eswbitto, could it be that postgres max_connections is the real limitation
2017-09-15 16:14:55 GMT <eswbitto> yreg well I didn't change the max_connections setting in the alfresco-global.properties I left it when I did the install
2017-09-15 16:15:28 GMT <yreg> max_connections should be on the postgres side of things
2017-09-15 16:15:29 GMT <eswbitto> yreg I want to start there and raise the limit, but finding a good number will be tricky I think.
2017-09-15 16:15:33 GMT <fwu> hello all
2017-09-15 16:15:36 GMT <MarkTielemans> hi
2017-09-15 16:15:37 GMT <yreg> not alfresco-global.properties
2017-09-15 16:16:14 GMT <eswbitto> yreg you wouldn't configure postgres settings there?
2017-09-15 16:17:32 GMT <yreg> eswbitto, AFAIK postgres is not even aware that it is serving alfresco
2017-09-15 16:17:50 GMT <yreg> how would it pick up config enteries from an alfresco config file ?
2017-09-15 16:19:13 GMT <eswbitto> yreg well I thought that alfresco-global.properties was the one config file where you would make "most" of your config changes. Its a little confusing to have config setup there in the default.
2017-09-15 16:19:19 GMT <yreg> eswbitto, check for instance https://stackoverflow.com/a/32584211/2307988
2017-09-15 16:19:20 GMT <alfbot> Title: postgresql - How to increase the max connections in postgres? - Stack Overflow (at stackoverflow.com)
2017-09-15 16:20:00 GMT <yreg> eswbitto, it is, for the alfresco side of things, but definitely not for DB, not for Share, not for Solr !
2017-09-15 16:20:18 GMT <yreg> HEy MarkTielemans !
2017-09-15 16:20:29 GMT <eswbitto> yreg good to know...
2017-09-15 16:27:49 GMT <yreg> I was browsing around the alfresco SVN and couldn't find any customization to the OOTB postgres max_connections, so your alfresco must be trying to create new connections but is getting blocked by DB server limitation
2017-09-15 16:28:25 GMT <eswbitto> yreg I looked the postgres.conf and the max connections is set at 300 with the buffer set at 128mB
2017-09-15 16:28:49 GMT <eswbitto> that is default cause I haven't messed with this config file
2017-09-15 16:29:30 GMT <yreg> ok then if you increase the value on the alfresco side, you need to make sure the same increase reflect on postgres side
2017-09-15 16:32:01 GMT <eswbitto> yreg so alfresco side defaults to 275 postgres defaults to 300 I guess they didn't want to utilize the full amount maybe?.....Too early on a Friday to contemplate that....So I think the next step if finding that magic number that doesn't destroy alfredo
2017-09-15 16:32:46 GMT <yreg> eswbitto, I suppose there is a reserved number of connections on postgres side for super user in order to do maintainance tasks .. etc
2017-09-15 16:33:07 GMT <eswbitto> yreg that makes sense
2017-09-15 16:33:08 GMT <fwu> ppl, in a java web script, im trying to write to the log file using System.out.println but nothing is written. Why may be this happening?
2017-09-15 16:33:17 GMT <yreg> eswbitto, check the superuser_reserved_connections config entry in postgres.conf
2017-09-15 16:33:58 GMT <eswbitto> the default is 3, but its not enabled.
2017-09-15 16:35:19 GMT <yreg> fwu, AFAIK you need to properly use apache common logging https://github.com/Alfresco/community-edition-old/blob/2c1eff9953d3105e738f7b06ba9ba8a079ca4c24/projects/web-client/source/java/org/alfresco/web/app/servlet/AuthenticationHelper.java#L101 fo example
2017-09-15 16:35:20 GMT <alfbot> Title: community-edition-old/AuthenticationHelper.java at 2c1eff9953d3105e738f7b06ba9ba8a079ca4c24 · Alfresco/community-edition-old · GitHub (at github.com)
2017-09-15 16:35:57 GMT <yreg> what you are using now is considered a quick and dirty way of spitting messages to stdout
2017-09-15 16:36:25 GMT <fwu> yreg, yes I know, I just want to make a first debug. I then replace it.
2017-09-15 16:36:38 GMT <fwu> let me see the link. thank you
2017-09-15 16:37:27 GMT <eswbitto> yreg ok so I understand the correlation between postgres max connections and alfresco's as well....I don't believe I need to change the shared_buffers because that is just the amount of memory given to each connection right?
2017-09-15 16:38:12 GMT <yreg> eswbitto, I haven't checked, just guessing, might be as well a reserved number of connections for all kinds of other stuff (alfresco analytics, Desktop sync ... at least these two are known to require direct connection to DB) it might as well be something else
2017-09-15 16:38:33 GMT <yreg> I am not a DB expert, but I assume what you are saying is right
2017-09-15 16:40:16 GMT <eswbitto> yreg no worries...I will look into making these changes...if you want me to follow up with you I can just for poops and giggles......The one big gripe I have is that...I have a staging server that is identical to production, but I don't get the same usage from users to trouble shoot and fix on staging rather than a live server.
2017-09-15 17:00:08 GMT <fwu> ppl, is there any difference/problem making this in 5.2: "extends AbstractWorkflowWebscript"
2017-09-15 17:00:35 GMT <fwu> I used to do this in 4.2.f to implement a java backed webscript, but now it seems it is not working
2017-09-15 17:07:29 GMT <fwu> while extending the abstractworkflowwebscript I can reach the workflowService
2017-09-15 17:07:40 GMT <fwu> in a declarative webscript, can I also get it?
The other logs are at http://esplins.org/hash_alfresco