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

2019-09-02 07:26:07 GMT <anaverageuser> is it possible to generate automatic reports with Alfresco? I am a complete newbie, probably my question is too vague and simple. but i not even know how to formulate it

2019-09-02 07:28:05 GMT <anaverageuser> what i mean with that is, if it´s possible to create sort of a template and with the filled information, a document in doc, pdf, or something similar will be automatically created, best regards. i just need some hints, so i can start researching more about the topic. the problem now is that i not even know what to look for

2019-09-02 07:31:40 GMT <angelborroy> If you want to use Pentaho as report tool, check this

2019-09-02 07:31:41 GMT <angelborroy> https://github.com/fcorti/Alflytics

2019-09-02 07:31:43 GMT <alfbot> Title:GitHub - fcorti/Alflytics: The Open Source Business Intelligence solution over the Alfresco platform. (at github.com)

2019-09-02 07:34:16 GMT <anaverageuser> thanks @angelbooroy and @alfbot

2019-09-02 07:34:22 GMT <anaverageuser> i will check them

2019-09-02 08:49:40 GMT <alfresco-discord> <Loftux> A common issue with previews transformations is that the mime type is wrong, especially for Microsoft office documents. A doc is renamed docx and has the wrong mime type, or vice versa. Or users just choose the wrong one, because the newer format has 2007 in it. "Microsoft Word 2007", I use Word 201x, so let change this to the one without a year stamp. Time to change the mime type description in

2019-09-02 08:49:41 GMT <alfresco-discord> Alfresco?

2019-09-02 08:52:09 GMT <alfresco-discord> <Loftux> Maybe just use "Microsoft Word (docx)" and "Microsoft Word (doc)" and so on. Would help, but of course not for the case when user has changed the file ending incorrectly.

2019-09-02 09:15:41 GMT <AFaust> Loftux: The issues you describe have to do with the strict mimetype check in Alfresco transformations, right?

2019-09-02 09:16:51 GMT <AFaust> If so, you can just set transformer.strict.mimetype.check.whitelist.mimetypes property and list the mimetype pairs you consider to be "same", e.g. where an incorrect, accidental assignment of the mimetype due to user interference should not be cause for a problem.

2019-09-02 09:18:19 GMT <AFaust> In an ideal world, I would love to see a power-user setting disallowing upload of any Office <= 2003 formats (using TIKA content inspection)

2019-09-02 09:18:43 GMT <AFaust> Complete with a big fat popup telling users to "get with the time"

2019-09-02 09:40:10 GMT <alfresco-discord> <Loftux> AFaust: Thanks, yes that might possibly solve it. will give it a shot. The mime type naming is still a bit out of time, when you see "2007" you thing of that as the old version now.

2019-09-02 13:29:04 GMT <alfresco-discord> <Loftux> AFaust: Did some quick tests, and whitelisting mimetypes for Word et al seem to work. Thanks for your suggestion.

2019-09-02 15:35:38 GMT <grendal_prime> ok after all the rigaramole with docker i decided to just go with 5.2 (it has what i need and its has a pretty simple install script.) Everything is running but..office docs are not previewing.

2019-09-02 15:37:18 GMT <grendal_prime> im about ready to dig into logs as to why but realized i need to install imagemagic and ffmpeg so getting that done now. Im also adding another 4 gigs of ram and a processor to the vm to try and speed up reboot.

2019-09-02 15:46:53 GMT <grendal_prime> this is kinda a werid question but if i run the 5.2 installer does it contain its own java or do i need to install that seperately?

2019-09-02 15:48:27 GMT <grendal_prime> nevermind i found it in the install dir.

2019-09-02 15:53:05 GMT <grendal_prime> grrr...still no preview

2019-09-02 16:13:40 GMT <hi-ko> grendal_prime: did you check the alfresco.log and catalina.out? alfresco defined max sizes for converting and additionally has a wired guessing mapping whitlist to guess mimetype from suffix.

2019-09-02 16:16:11 GMT <grendal_prime> that log does not show any errors

2019-09-02 16:16:19 GMT <hi-ko> grendal_prime: we never used the installer to be able to update all dependancies. The installer just copies quiet outdated software and you will not get the OS support as expected.

2019-09-02 16:16:39 GMT <hi-ko> I'll check the log4j properties ...

2019-09-02 16:16:45 GMT <grendal_prime> ok maybe you can help me understand something here.

2019-09-02 16:17:44 GMT <grendal_prime> i was able to get this all working just fine with docker...however i just dont get docker. it makes no sence, I have to set up volumes and...then..where do i put the amps i need?

2019-09-02 16:17:46 GMT <hi-ko> https://docs.alfresco.com/5.2/references/dev-extension-points-content-transformer.html

2019-09-02 16:17:47 GMT <alfbot> Title:Content Transformers (and Renditions) | Alfresco Documentation (at docs.alfresco.com)

2019-09-02 16:19:59 GMT <hi-ko> we also don't use the docker thing. you have to build your own docker images containing your custom alfresco/share.war having the amps already applied

2019-09-02 16:20:49 GMT <hi-ko> or you define a docker filesystem mount to a directory containing jar modules wich don't require amp deployment

2019-09-02 16:21:08 GMT <grendal_prime> this is so frustrating.

2019-09-02 16:21:26 GMT <grendal_prime> Ive deployed 5.0 everyone is using it and starting to get the hang of it.

2019-09-02 16:22:14 GMT <grendal_prime> i need aos, i need 5.1 or higher for that to work. Iwould love to do 6+ but, i just cant seem to get this working, also i dont see a "comfortable" way to migrate to the new server.

2019-09-02 16:22:47 GMT <grendal_prime> its taken 2 years to start migrating our production data over and a new general manager give it an ok.

2019-09-02 16:23:58 GMT <grendal_prime> We were using this for all of our linux worstations and it is amazing how much easyer it is to locate things, but now management side wants this and they all have windows workstations.

2019-09-02 16:25:09 GMT <hi-ko> if you could afford a manday of our services you could get a one year subcription to our virtual appliance based on OVF (vm) and ubuntu lts for alfresco versions 4.2 to 6.1

2019-09-02 16:25:43 GMT <grendal_prime> I wish i could just get a vm that has this working. the one i got from bitnami worked ok...but..there were some issues with it as well

2019-09-02 16:25:53 GMT <grendal_prime> what do you guys charge for say 10 users?

2019-09-02 16:26:20 GMT <grendal_prime> the big thing we need is it has to be in house.

2019-09-02 16:26:47 GMT <hi-ko> we only charge time and say the effort to bake a new tested, supported, tuned vm is one day per company.

2019-09-02 16:27:31 GMT <grendal_prime> our backhaul in this area is...sketchy, and we need access to critical EAP documents that we make available in our closed network.

2019-09-02 16:27:53 GMT <grendal_prime> got a website?

2019-09-02 16:28:08 GMT <hi-ko> as long you could run a vm you could get latest version from our support portal which you could deploy to your own servers

2019-09-02 16:28:20 GMT <grendal_prime> kvm?

2019-09-02 16:28:50 GMT <hi-ko> esx(i) but you could uninstall open-vm-tools from the image

2019-09-02 16:29:06 GMT <grendal_prime> I think the only way they would go for it is if i was to get it up and running and then they would be interested in a maint contract.

2019-09-02 16:29:22 GMT <grendal_prime> otherwise they will just say...keep what we got.

2019-09-02 16:30:37 GMT <hi-ko> you could get both - https://www.ecm4u.de/en/index.php we just rebuilding the landing pages for the alfresco appliance, modules and services

2019-09-02 16:30:39 GMT <alfbot> Title:ecm4u Homepage (at www.ecm4u.de)

2019-09-02 16:38:49 GMT <hi-ko> grendal_prime: we did it the other way around: all of our customers migrated to our vm (virtual appliance) since this is far less support effort and better availability

2019-09-02 16:39:35 GMT <hi-ko> grendal_prime: and we don't like to fix the same stuff again and again ...

2019-09-02 16:40:21 GMT <grendal_prime> ya i know we are in a region that is plagued with downtime. wide area network...multiple nodes in remote areas, critical infrastructure. Federal Energy Regulations to meet.

2019-09-02 16:41:03 GMT <grendal_prime> we need to deploy updated information to the guys in the field by the hour some times...we have wildfires, crazy weather..you name it and the first thing down, internet.

2019-09-02 16:41:54 GMT <grendal_prime> there is comm with law enforcement, forestry, public util, and we are small agency.

2019-09-02 16:42:50 GMT <hi-ko> I know we could do a much better job in marketing but my presentaion in BCN https://www.youtube.com/watch?v=c5lBSyRPNmU is still valid (but updated, extended to the latest requirements)

2019-09-02 16:48:42 GMT <hi-ko> grendal_prime: just give me a call (ext. -72) or pm to have a chat more in detail if you like

2019-09-02 17:04:27 GMT <hi-ko> grendal_prime: to fix your preview problem please enable debug for transformation described in https://docs.alfresco.com/5.2/references/dev-extension-points-content-transformer.html and/or install latest ootb support-tools to check/debug transformations https://github.com/OrderOfTheBee/ootbee-support-tools/releases

2019-09-02 17:04:28 GMT <alfbot> Title:Content Transformers (and Renditions) | Alfresco Documentation (at docs.alfresco.com)

2019-09-02 17:09:56 GMT <grendal_prime> actually got that part working..was a dependency missing

2019-09-02 17:10:23 GMT <grendal_prime> libGLU

2019-09-02 17:10:52 GMT <grendal_prime> wich oddly enought was...named soemthing very different...like libGLU-mesa something or another

2019-09-02 17:11:21 GMT <grendal_prime> libglu1-mesa exactly...well on this distro anyway

2019-09-02 17:11:43 GMT <grendal_prime> need to get edit in libre office working for the linux workstations

2019-09-02 17:22:10 GMT <grendal_prime> should have that rangled in about 5 min...why tomcat take so long to boot?

2019-09-02 17:22:36 GMT <hi-ko> OpenGL required by libreoffice???

2019-09-02 17:22:46 GMT <grendal_prime> i mean...seriously...how many sanity checks that thing have to run?

2019-09-02 17:23:16 GMT <hi-ko> tomcat takes so long to start since it uses spring a lot

2019-09-02 17:23:29 GMT <grendal_prime> beats the hell out of me dude, that was the one with the closest name..i installed it and it started working, i didnt even have to restart alfresco service

2019-09-02 17:23:36 GMT <hi-ko> sorry - I meant since Alfresco uses spring

2019-09-02 17:24:26 GMT <grendal_prime> you know..i have to work with about 3 different tomcat based apps. And each one takes 5 min to shutdown and 5 min to bring back up.

2019-09-02 17:24:52 GMT <grendal_prime> when i develop php apps they do not take nearly as long..

2019-09-02 17:25:18 GMT <grendal_prime> and some of my apps are pretty complicated.

2019-09-02 17:26:57 GMT <hi-ko> sure - but alfresco delegates work to other framework classes which are connected dynamically on start whithout rebuild / linking just by editing xml files naming the clasess which should do the job. unfortunately this has a high price ...

2019-09-02 17:27:19 GMT <grendal_prime> one of the scada systems i maintain, it at least has the decency to tell you its starting up.

2019-09-02 17:28:08 GMT <hi-ko> the largest sysetems we support/maintain not alfresco but solr is the beast

2019-09-02 17:28:18 GMT <grendal_prime> if it didnt i would have operators holding me at knifepoint asking me..."when will i be able to start this power plant?"

2019-09-02 17:28:47 GMT <grendal_prime> ya..solar is the search componant correct?

2019-09-02 17:29:22 GMT <hi-ko> yes - running independant from alfresco but in alfresco 5.2 in the same tomcat by default.

2019-09-02 17:30:14 GMT <grendal_prime> hmm i just figured a full text indexing in postgresql would have been plenty fast.

2019-09-02 17:30:14 GMT <hi-ko> we hightly recommend to run solr in a separate tomcat - better in a sep. os

2019-09-02 17:30:46 GMT <grendal_prime> ya but then you have to set up all that ssl between the two..and i have to tell you that is sketch to me.

2019-09-02 17:30:53 GMT <hi-ko> haha - that would be so nice to use postgres for full text indexing ...

2019-09-02 17:33:26 GMT <hi-ko> ssl setup between repo and solr is just running a script in our appliance ;-) but if you understand the background also easy to move and generate by hand.

2019-09-02 17:45:25 GMT <hi-ko> If you have an issue you could nail down ask it here or in stack overflow or in https://community.alfresco.com/community/ecm. If you need remote services and support you may look for SIs in you area but we would be happy to help you also from our timezone (CET).

2019-09-02 17:48:42 GMT <hi-ko> grendal_prime: asuming you're from CA?

2019-09-02 17:56:51 GMT <grendal_prime> yep...sorry had to go surfing real quick.

2019-09-02 17:56:56 GMT <grendal_prime> hehehe

2019-09-02 18:07:06 GMT <grendal_prime> ok so seems i got everything working here on 5.2

2019-09-02 18:08:32 GMT <grendal_prime> now i need to try a data migration from 5.0.. im assuming i can mount my old alf_data dir to the new installation, and then do an dump from the 5.0 pg server and import that data into the new server.

2019-09-02 18:08:53 GMT <grendal_prime> is the indexing information in the same storage as the alf_data?

2019-09-02 18:10:17 GMT <hi-ko> yes - 5.0 and 5.2 use solr4 - so you can just reuse the index. I suggest to remove solr.war and set index to noindex during migration

2019-09-02 18:14:04 GMT <hi-ko> we recomend to mount alf_data/contentstore* by nfs but not alf_data/solr/index which requires to be stored on a local fs

2019-09-02 18:16:45 GMT <grendal_prime> so mount the content store...but copy over the solr/index

2019-09-02 18:17:40 GMT <grendal_prime> i think on the production env i have at work, i just mounted the entire alf_data.

2019-09-02 18:17:51 GMT <grendal_prime> seems to work just fine.

2019-09-02 18:18:34 GMT <grendal_prime> hey do you know if alfresco is planning on wrapping 6.1 into an install script like they did we previous versions?

2019-09-02 18:19:22 GMT <hi-ko> mounting whole alf_data using nfs/cifs does not work for solr/lucene which requires special locks

2019-09-02 18:20:00 GMT <grendal_prime> hmm

2019-09-02 18:20:05 GMT <grendal_prime> hold on let me check how i did that

2019-09-02 18:24:49 GMT <grendal_prime> hmm i dont know its working then, put the contentstore, keystore, oouser,contentstore.deleted, postgresql solar4. They are all on our filer and it is mounted on the alfresco server as a local dir.

2019-09-02 18:25:17 GMT <hi-ko> at least for nfsv3 you will get issues when lucene tries locking byte-ranges but nfs would be far to slow for the index which may be like the db your bottlenek

2019-09-02 18:25:48 GMT <grendal_prime> and..then i have an rsnapshot that backs that up 6 times a day.

2019-09-02 18:26:05 GMT <hi-ko> if you say mounted as a local dir you mean the whole virtual device as a block device or as a remote fs?

2019-09-02 18:26:47 GMT <hi-ko> you can't create a consistent index by rsnapshot from a running solr/lucene index

2019-09-02 18:27:06 GMT <grendal_prime> 192.168.20.2:/mnt/drive2/alfresco /mnt/uwpa-filer nfs rsize=8192,wsize=8192,timeo=14,intr

2019-09-02 18:27:43 GMT <hi-ko> thats like doing rsnapshot on a running postgres device

2019-09-02 18:28:06 GMT <grendal_prime> yep and that works actually

2019-09-02 18:28:49 GMT <grendal_prime> you have to stop them all for the first one..but then..the changes are typically so small its not a problem

2019-09-02 18:28:52 GMT <hi-ko> by accident. you could only rsnapshot solrbackupindex

2019-09-02 18:29:18 GMT <grendal_prime> ya thats on there as well.

2019-09-02 18:29:25 GMT <grendal_prime> but here is the question...

2019-09-02 18:29:33 GMT <grendal_prime> i mean the index can be rebuilt correct?

2019-09-02 18:30:07 GMT <hi-ko> sure but depending on the repo size this could last hours or days or weeks.

2019-09-02 18:30:25 GMT <grendal_prime> id say...hmm 4000 documents?

2019-09-02 18:30:48 GMT <grendal_prime> actually i can get a count of that somewhere right?

2019-09-02 18:31:07 GMT <hi-ko> thats nothing if you don't expect transformation like ocr

2019-09-02 18:31:28 GMT <hi-ko> so 4000 docs are easy and save just to reindex.

2019-09-02 18:32:11 GMT <hi-ko> in most prod systems we talk about millons

2019-09-02 18:33:25 GMT <hi-ko> but anyway - I would not rely on a backup done from a running index

2019-09-02 18:33:37 GMT <grendal_prime> one day..but most the gms im dealing with these days want an eol for paperwork believe it or not

2019-09-02 18:34:46 GMT <hi-ko> I belive of course - the bigger the organisations the less digital support in processes

2019-09-02 18:36:04 GMT <hi-ko> have to leave - have a good time with your updated alf!

2019-09-02 21:30:04 GMT <grendal_prime> tried to migrate data from 5.0 to 5.2 it did not work

End of Daily Log

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