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

2018-03-07 07:37:06 GMT <alfbot> hiten: Sent 1 week, 1 day, 18 hours, and 40 minutes ago: <yreg> when you use the SDK you do not have 3rd party libraries on board like if you have had actually used the installer to use alfresco; for that subsystem to work with the SDK you should pre-install the third libs on your system (in this case libreoffice) and configure your project correctly to point to them

2018-03-07 11:47:50 GMT <Ishika> I am exploring the addon https://github.com/fegorama/alfviral

2018-03-07 11:47:51 GMT <alfbot> Title: GitHub - fegorama/alfviral: Alfresco Virus Alert (at github.com)

2018-03-07 11:49:29 GMT <Ishika> I have uploaded a file of mimetype application/x-dosexec which is not virus infected.still it is showing that the file is infected.

2018-03-07 11:49:38 GMT <Ishika> I got the following logs for application/x-dosexec file

2018-03-07 11:52:24 GMT <Ishika> https://pastebin.com/LRdmXrH1

2018-03-07 11:52:25 GMT <alfbot> Title: 2018-03-07 17:10:45,596 DEBUG [alfresco.services.AntivirusServiceImpl] [http-apr - Pastebin.com (at pastebin.com)

2018-03-07 11:53:10 GMT <Tichodroma> try to scan the file with clam directly outside Alfresco

2018-03-07 11:54:28 GMT <Tichodroma> what does https://www.virustotal.com/ think of this file?

2018-03-07 12:24:35 GMT <Ishika> Tichodroma,when I have tried to scan the file of mimetype application/x-dosexec,it is showing that the file is not infected

2018-03-07 12:25:04 GMT <Ishika> ayushi@ayushi-GA-78LMT-S2PT:~/Downloads$ clamscan stepup.exe

2018-03-07 12:25:16 GMT <Ishika> stepup.exe: OK

2018-03-07 12:25:28 GMT <Ishika> ----------- SCAN SUMMARY -----------

2018-03-07 12:25:39 GMT <Ishika> Known viruses: 6429993

2018-03-07 12:25:48 GMT <Ishika> Engine version: 0.99.2

2018-03-07 12:25:56 GMT <Ishika> Scanned directories: 0

2018-03-07 12:26:06 GMT <Ishika> Scanned files: 1

2018-03-07 12:26:18 GMT <Ishika> Infected files: 0

2018-03-07 12:26:28 GMT <Ishika> Data scanned: 9.14 MB

2018-03-07 12:26:38 GMT <Ishika> Data read: 2.46 MB (ratio 3.72:1) Time: 13.793 sec (0 m 13 s)

2018-03-07 12:51:37 GMT <Tichodroma> Ishika: can you take the .bin file and scan it? /home/alfresco_installation/alfviral-1.4.0-snapshot/alf_data/contentstore/2018/3/7/17/10/650e9233-0a19-4c00-9e0a-e54c27e3b3f6.bin

2018-03-07 13:02:14 GMT <bhagyas> >>> what is the best to kill a rogue joblock?

2018-03-07 13:02:23 GMT <bhagyas> *way

2018-03-07 13:11:43 GMT <hi-ko> bhagyas: what is a rogue joblock??

2018-03-07 13:15:25 GMT <Ishika> Tichodroma,I will try this

2018-03-07 13:16:00 GMT <Ishika> Tichodroma,ya from virustotal mode,it is working correctly

2018-03-07 13:16:10 GMT <Ishika> but not with command mode

2018-03-07 13:25:25 GMT <kkore> Hi all how to hide site pages from non-admin users

2018-03-07 13:26:35 GMT <bhagyas> hi-ko: a joblock that exists due to a bug

2018-03-07 13:26:37 GMT <bhagyas> :D

2018-03-07 13:36:36 GMT <Ishika> Tichodroma,on scanning the /home/alfresco_installation/alfviral-1.4.0-snapshot/alf_data/contentstore/2018/3/7/17/10/650e9233-0a19-4c00-9e0a-e54c27e3b3f6.bin,it is showing that the file is not infected

2018-03-07 13:37:03 GMT <Ishika> but through the action,it is showing that the file is infected

2018-03-07 13:53:27 GMT <hi-ko> <bhagyas> job = database job or meant as order entry?

2018-03-07 13:53:38 GMT <angelborroy> kkore probably this can help: https://github.com/keensoft/alfresco-simplify-share

2018-03-07 13:53:39 GMT <alfbot> Title: GitHub - keensoft/alfresco-simplify-share: Share customisation to hide elements from Document Library (at github.com)

2018-03-07 13:55:18 GMT <hi-ko> Does anybody have experience with migration a ms-sql repo db to postgres? would you recommend dbloader or pgdump?

2018-03-07 14:00:06 GMT <bmejias> kkore you can set the site as private, and add only admin users as members of it

2018-03-07 14:00:18 GMT <bmejias> like that the site won't be visible for non-admin users

2018-03-07 14:04:11 GMT <kkore> right now site is private but it contains both admin and non-admin users so that's why it required for only admin users

2018-03-07 14:10:28 GMT <bmejias> then the non-admin users shouldn't be part of the site. Can you remove them from the list of site-members?

2018-03-07 14:21:55 GMT <kkore> bmejias but I think it's not right way to do it like that.

2018-03-07 14:24:42 GMT <AFaust> bmejias: only way to kill a rogue job lock is by doing this on DB / SQL. You can only use the API for this if you have the lock token at hand

2018-03-07 14:29:50 GMT <bmejias> AFaust I think that message was for bhagyas

2018-03-07 14:30:30 GMT <bmejias> kkore but why would you keep a non-admin user as member of a site if the pages should be hidden from them?

2018-03-07 14:31:24 GMT <bmejias> unless I'm not understanding what you want to achieve.

2018-03-07 14:32:19 GMT <kkore> reports page is there.want to hide from all users except admin-users

2018-03-07 14:32:30 GMT <kkore> Created**

2018-03-07 14:36:30 GMT <AFaust> bmejias: You are right - just scrolled over the chat of today with half an eye

2018-03-07 14:46:08 GMT <bmejias> kkore, OK, so you have a site, where admin, and non-admin are members of it. Then you have a set of files that you want to be visible only to the admins

2018-03-07 14:46:19 GMT <bmejias> so, a subset of the site.

2018-03-07 14:47:16 GMT <kkore> yes exactly

2018-03-07 14:48:15 GMT <bmejias> You have two choices: 1. you will have to manage the permissions of those reports individually, giving explicit permissions only to users that are admin

2018-03-07 14:48:32 GMT <bmejias> even better, use the group of admins for setting the permissions.

2018-03-07 14:48:53 GMT <bmejias> be careful not to inherit the site permissions for those reports.

2018-03-07 14:49:19 GMT <bmejias> It's easy to mess it up when you mix "site roles" with "individual permissions"

2018-03-07 14:49:53 GMT <bmejias> now, if those reports are going to be constantly updated, and adding more, because option 2 is better.

2018-03-07 14:50:14 GMT <bmejias> 2: Create a separate private site to allocate all those reports that should be visible only to admin users

2018-03-07 14:50:52 GMT <bmejias> Like that you don't have the risk of leaking some document by accident, because an non-admin user has "Site manager" role.

2018-03-07 15:02:03 GMT <bhagyas> Afaust

2018-03-07 16:05:23 GMT <Tichodroma> The REST API described on https://api-explorer.alfresco.com/ is only for documentation purposes, right? How can I access these URLs relative to my.alfresco.com (cloud)?

2018-03-07 16:05:25 GMT <alfbot> Title: Alfresco Content Services REST API Explorer (at api-explorer.alfresco.com)

2018-03-07 16:05:37 GMT <Tichodroma> A request like https://my.alfresco.com/alfresco/api/-default-/public/alfresco/versions/1/nodes/284473c0-2221-11e8-b566-0800200c9a66 return 503 Service Unavailable

2018-03-07 16:06:34 GMT <Tichodroma> in fact the response is 503 Forbidden!

2018-03-07 16:21:39 GMT <Tichodroma> Is there a Basic Auth way to access the REST API of the Alfresco Cloud? Or do I have to implement OAuth?

2018-03-07 16:29:39 GMT <AxelFaust> Tichodroma: Alfresco Cloud requires OAuth

2018-03-07 16:31:54 GMT <AxelFaust> i.e https://docs.alfresco.com/5.0/pra/1/concepts/pra-authentication-cloud.html

2018-03-07 16:31:55 GMT <alfbot> Title: Authentication for Alfresco Cloud | Alfresco Documentation (at docs.alfresco.com)

End of Daily Log

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