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-05 06:31:15 GMT <alfresco-discord> <bhagyas> I used postgres, and got it to work!

2019-09-05 06:31:19 GMT <alfresco-discord> <bhagyas> @Thijs

2019-09-05 06:32:28 GMT <alfresco-discord> <bhagyas> Is there anyone working on building a hot reload function onto this?

2019-09-05 06:33:33 GMT <alfresco-discord> <Thijs> @bhagyas We use dynamic extensions for Alfresco.

2019-09-05 06:33:53 GMT <alfresco-discord> <Thijs> it has an http endpoint to upload a new jar

2019-09-05 06:35:23 GMT <alfresco-discord> <Thijs> so we use osgi for hot reloading

2019-09-05 06:35:50 GMT <alfresco-discord> <bhagyas> darn it!

2019-09-05 06:36:29 GMT <alfresco-discord> <bhagyas> I was wondering if the expanded WAR can be mapped into a docker volume and then mounted into the running container

2019-09-05 06:36:49 GMT <alfresco-discord> <Thijs> ofcourse, that can be done

2019-09-05 06:36:59 GMT <alfresco-discord> <bhagyas> Has anyone done that before?

2019-09-05 06:37:41 GMT <alfresco-discord> <Thijs> at Xenit, I don't think so, but maybe you have more luck in the tomcat world

2019-09-05 06:38:20 GMT <alfresco-discord> <bhagyas> btw, I also want to get the debugger running

2019-09-05 06:38:22 GMT <alfresco-discord> <Thijs> I think JRebel should be easily doable

2019-09-05 06:38:38 GMT <alfresco-discord> <bhagyas> if you have any pointers/tips let me know

2019-09-05 06:39:19 GMT <alfresco-discord> <Thijs> how does the Alfresco SDK do hot reloading with docker?

2019-09-05 06:41:34 GMT <alfresco-discord> <bhagyas> interesting question, @Loftux asked the same minutes ago

2019-09-05 06:41:39 GMT <alfresco-discord> <bhagyas> looking at Alf SDK Dockerfile now

2019-09-05 06:43:10 GMT <alfresco-discord> <bhagyas> They seem to include a hotswap agent and a jrebel config

2019-09-05 06:43:30 GMT <alfresco-discord> <bhagyas> that maps the output classes/resources against the source

2019-09-05 06:43:39 GMT <alfresco-discord> <Thijs> well, that's not tight to maven/gradle in any way

2019-09-05 06:43:45 GMT <alfresco-discord> <bhagyas> yup!

2019-09-05 06:44:57 GMT <alfresco-discord> <Thijs> I think you can just fix all that with mounts in a docker-compose file

2019-09-05 06:45:28 GMT <alfresco-discord> <bhagyas> so the Alf SDK is just using hot reload for classes, I don't think it provides a debugger port/endpoint, I also see the docker-compose mapping references to the Java debug port and exposing it

2019-09-05 06:45:43 GMT <alfresco-discord> <bhagyas> soooo debugging IS provided, via exposing the port

2019-09-05 06:46:32 GMT <alfresco-discord> <Thijs> well, that's how it works in java, some Java opts and a port

2019-09-05 06:46:56 GMT <alfresco-discord> <bhagyas> yeah, I've usually used Maven to automatically hook up the debugger xD

2019-09-05 06:47:15 GMT <alfresco-discord> <bhagyas> (Unless of course I had to remote debug)

2019-09-05 06:47:44 GMT <alfresco-discord> <Thijs> in our latest configs, we have a docker-compose-debug.yml on top of the docker-compose.yml containing the debug config

2019-09-05 06:48:13 GMT <alfresco-discord> <Thijs> you can do docker-compose -f docker-compose.yml -f docker-compose-debug.yml up -d

2019-09-05 06:48:37 GMT <alfresco-discord> <Thijs> so it is layered

2019-09-05 06:48:48 GMT <alfresco-discord> <Thijs> same for db configurations

2019-09-05 06:48:51 GMT <alfresco-discord> <bhagyas> That's pretty cool

2019-09-05 06:49:27 GMT <alfresco-discord> <Thijs> instead of calling your database service postgres

2019-09-05 06:49:34 GMT <alfresco-discord> <Thijs> you call it database

2019-09-05 06:49:47 GMT <alfresco-discord> <Thijs> and in another layer, you specify which one

2019-09-05 06:49:54 GMT <alfresco-discord> <bhagyas> yeah

2019-09-05 06:50:17 GMT <alfresco-discord> <bhagyas> so the JAVA_OPTS also get merged alongside driver configs?

2019-09-05 06:50:59 GMT <alfresco-discord> <Thijs> well, I think it is difficult to do with Alfresco's configuration

2019-09-05 06:51:10 GMT <alfresco-discord> <Thijs> because they put everything in JAVA_OPTS

2019-09-05 06:51:32 GMT <alfresco-discord> <Thijs> and then you have to copy paste and change the whole thing in another layer

2019-09-05 06:52:45 GMT <alfresco-discord> <Thijs> we have specific names for commonly used configurations

2019-09-05 06:52:52 GMT <alfresco-discord> <Thijs> like DB_DRIVER

2019-09-05 06:52:59 GMT <alfresco-discord> <Thijs> so you can override just that

2019-09-05 06:53:12 GMT <alfresco-discord> <Thijs> or use GLOBAL_nameofyourprop=....

2019-09-05 06:53:56 GMT <alfresco-discord> <Thijs> also JAVA_OPTS_someignoredkey=-Dhello=world

2019-09-05 06:57:03 GMT <alfresco-discord> <Thijs> @bhagyas docker-compose support is currently still an 'undocumented' feature, but we don't do much more than using the docker-compose plugin from avast

2019-09-05 07:10:13 GMT <grendal_prime> ok got that migration to work finally

2019-09-05 07:10:46 GMT <grendal_prime> it all would have been a hell of a lot easyer had i just gone with a seperate database server.

2019-09-05 07:11:54 GMT <grendal_prime> the process of upgrading from 9.3 to 9.4 is pretty damn dificult without all the tools that you usually have with a vanilla installation of postgresql.

2019-09-05 07:14:38 GMT <grendal_prime> I wound up just using a third machine that i set up as a db migration server. I installed both 9.3 and 9.4 servers on there and then ran the conversion on it, transfered the entire database to the new installation and then moved over the content and solar files and whammo done deal

2019-09-05 07:30:49 GMT <alfresco-discord> <Thijs> grendal_prime: using pg_upgrade?

2019-09-05 07:37:05 GMT <grendal_prime> yep

2019-09-05 07:40:03 GMT <alfresco-discord> <Thijs> grendal_prime: it was difficult because you used the Alfresco installer?

2019-09-05 07:40:43 GMT <alfresco-discord> <Thijs> grendal_prime: by the way, 9.4 is old, why don't you migrate to a recent version?

2019-09-05 07:42:38 GMT <grendal_prime> thats whats was werid... i thought that the version i had recently installed was 9.5 but i ran into an error that pointed out that 9.5 was not compatible with the version i had wich was 9.4

2019-09-05 07:43:10 GMT <grendal_prime> I dont know...ill probably do the same process again to 9.5 then i can go directly to 10.

2019-09-05 07:43:22 GMT <alfresco-discord> <Thijs> what Alfresco did you use?

2019-09-05 07:43:44 GMT <grendal_prime> i just needed to do a poc to make sure it was actually doable..took me 2 days banging away at it.

2019-09-05 07:43:58 GMT <grendal_prime> 5.2

2019-09-05 07:44:58 GMT <alfresco-discord> <Thijs> you can run any Alfresco from 4.2 -> 6.1 on Postgres 11 (although not officially in the supported stack of Alfresco), but you need to use an updated jdbc driver

2019-09-05 07:46:06 GMT <grendal_prime> all i know is it is working great now..and I got to get some sleep.

2019-09-05 07:46:26 GMT <alfresco-discord> <Thijs> happy for you

2019-09-05 07:46:35 GMT <grendal_prime> I havent tested it with microsoft office..but ill do that tomorrow at some point

2019-09-05 07:46:53 GMT <grendal_prime> works great with libre,

2019-09-05 07:47:08 GMT <grendal_prime> there is a few little things i have to test but for the most part it seems to be working great

2019-09-05 07:47:26 GMT <grendal_prime> peace love and BBQ... IM OUT!!

2019-09-05 07:48:26 GMT <alfresco-discord> <Thijs> ok, it's just that postgres 9.4 will stop to receive maintenance as soon as 12 is out, expected end of this year I think

2019-09-05 09:41:11 GMT <hi-ko> hi guys, has anybody already implemented something like a permission voter which dynamically grants a permission based on external context like network the request comes from or type of authentication (2FA)?

2019-09-05 09:44:02 GMT <alfresco-discord> <yreg> Yep, I contributed to something like that

2019-09-05 09:45:10 GMT <alfresco-discord> <Thijs> @yreg alfresco-metadata-permissions?

2019-09-05 09:45:20 GMT <hi-ko> yreg: something which is public available?

2019-09-05 09:45:41 GMT <alfresco-discord> <yreg> relying on extra claims coming from an IdP to grant extra rights on extra services

2019-09-05 09:45:47 GMT <alfresco-discord> <yreg> unfortunately not

2019-09-05 09:46:30 GMT <alfresco-discord> <yreg> @Thijs not only that one ๐Ÿ˜‰

2019-09-05 09:46:47 GMT <alfresco-discord> <Thijs> well, we still plan to open source our alfresco-metadata-permissions, that mainly Axel implemented for us

2019-09-05 09:46:53 GMT <alfresco-discord> <Thijs> but I don't have a timeline on that yet

2019-09-05 09:47:55 GMT <alfresco-discord> <bhagyas> @Thijs Diving into the Docker plugin, where can I fetch the WAR files generated?

2019-09-05 09:48:11 GMT <alfresco-discord> <bhagyas> I tried getting through the MergeWarTask, but it has some issues with resolving deps

2019-09-05 09:48:15 GMT <alfresco-discord> <yreg> @Thijs That would be really nice !

2019-09-05 09:49:20 GMT <alfresco-discord> <yreg> @bhagyas AFAIK, it's not inside the image, in order to make smaller layers, that plugin always puts in wars in exploded format if I remember right

2019-09-05 09:49:25 GMT <alfresco-discord> <bhagyas> I'm looking at expanding the WAR files to a custom location (to mount on docker)

2019-09-05 09:50:01 GMT <hi-ko> I've no idea about the mechanism on your metadata permissions but I would expect something like defining rules a specific context (IP range, authentication method) gets access or veto on which could be combined with aspects.

2019-09-05 09:50:33 GMT <alfresco-discord> <Thijs> @bhagyas you should be able to use the output of the mergeAlfrescoWar task

2019-09-05 09:50:53 GMT <alfresco-discord> <Thijs> and then you can unzip that somewhere

2019-09-05 09:50:58 GMT <hi-ko> today, if Alfresco is exposed to the internet username and password is no longer secure

2019-09-05 09:51:01 GMT <alfresco-discord> <bhagyas> task extractWar(type: eu.xenit.gradle.tasks.WarOutputTask){ group 'loftux-build-beta' // dependsOn 'mergeAlfrescoWar' println outputWar }

2019-09-05 09:51:08 GMT <alfresco-discord> <bhagyas> Doesn't seem to work, throws a NPE

2019-09-05 09:51:31 GMT <alfresco-discord> <bhagyas> :[

2019-09-05 09:54:16 GMT <hi-ko> yreg, Thijs: I think this permission thing based on context like network or auth method is a bigger issue due to missing concepts in Alfresco. I will report back once we have a sponsor for a starting point ...

2019-09-05 09:55:39 GMT <alfresco-discord> <IanW> Can you configure identity services/keycloak for this?

2019-09-05 09:57:49 GMT <alfresco-discord> <yreg> hi-ko, that scenario seemed to be slightly different from what I have seen

2019-09-05 09:57:58 GMT <alfresco-discord> <bhagyas> task extractWar(){ group 'loftux-build-beta' dependsOn 'mergeAlfrescoWar' def warFile = file("$buildDir/xenit-gradle-plugins/mergeAlfrescoWar/mergeAlfrescoWar.war") if(!warFile.exists()) {println "no war file"; return} println 'hey!' }

2019-09-05 09:58:15 GMT <alfresco-discord> <bhagyas> this seems to work, it would be awesome if i could extract the path from the plugin instead

2019-09-05 09:58:41 GMT <alfresco-discord> <Thijs> yes, you should not use the file location

2019-09-05 09:59:18 GMT <alfresco-discord> <Thijs> I'm trying something right now

2019-09-05 10:03:34 GMT <alfresco-discord> <bhagyas> Got it using tasks['mergeAlfrescoWar'].outputs.files.asPath

2019-09-05 10:03:37 GMT <alfresco-discord> <bhagyas> ๐Ÿ™‚

2019-09-05 10:16:19 GMT <alfresco-discord> <Thijs> we put a method on that task for getting the file

2019-09-05 10:16:23 GMT <alfresco-discord> <Thijs> getOutputWar()

2019-09-05 10:22:58 GMT <alfresco-discord> <Thijs> @bhagyas this is the most elegant I could think of:

2019-09-05 10:23:02 GMT <alfresco-discord> <Thijs> task unpack(type: Copy) { dependsOn mergeAlfrescoWar from zipTree(mergeAlfrescoWar.outputWar) into "$buildDir/myunpacklocation" }

2019-09-05 10:23:43 GMT <alfresco-discord> <Thijs> I tested it

2019-09-05 11:17:10 GMT <alfresco-discord> <bhagyas> yeah, that's what I ended up with

2019-09-05 11:17:15 GMT <alfresco-discord> <bhagyas> Sorry, just logged back in

2019-09-05 11:17:23 GMT <alfresco-discord> <bhagyas> def wars = ["Alfresco", "Share"] wars.each { warName -> tasks.create(name: "${warName.toLowerCase()}ExtractWar", type: Copy) { group 'loftux-build-beta' dependsOn "merge${warName}War" tasks["merge${warName}War"].outputs.files.each { from zipTree(it) into "$buildDir/expanded${warName}War" } } }

2019-09-05 11:20:42 GMT <alfresco-discord> <Thijs> @bhagyas use mergeAlfrescoWar.outputWar instead of mergeAlfrescoWar.outputs.files

2019-09-05 11:21:13 GMT <alfresco-discord> <bhagyas> I wanted to write one code for both ๐Ÿ˜‰

2019-09-05 11:21:28 GMT <alfresco-discord> <bhagyas> This handles both Alfresco and Share, hope it looks alright

2019-09-05 11:21:29 GMT <alfresco-discord> <Thijs> ok, but the point is .outputWar

2019-09-05 11:21:43 GMT <alfresco-discord> <Thijs> not outputs.files.each

2019-09-05 11:22:34 GMT <alfresco-discord> <sumit> Hi All, I am unable to delete the user if user has logged in at least once in my instance. While user can be deleted if never logged in. It throws ConcurrencyFailedException.

2019-09-05 11:23:23 GMT <alfresco-discord> <sumit> I assume that this may happening because some of latest customization on the instance.

2019-09-05 11:23:26 GMT <alfresco-discord> <bhagyas> def wars = ["Alfresco", "Share"] wars.each { warName -> tasks.create(name: "${warName.toLowerCase()}ExtractWar", type: Copy) { group 'loftux-build-beta' dependsOn "merge${warName}War" from zipTree(tasks["merge${warName}War"]['outputWar']) into "$buildDir/expanded${warName}War" } }

2019-09-05 11:23:28 GMT <alfresco-discord> <bhagyas> updated

2019-09-05 11:23:56 GMT <alfresco-discord> <bhagyas> Wish if I could get hold of it before the WAR compression comes along

2019-09-05 11:24:02 GMT <alfresco-discord> <bhagyas> then it would be even faster

2019-09-05 11:24:33 GMT <alfresco-discord> <sumit> My one finding is that there is no CascadeUpdate aspect on the user node

2019-09-05 11:25:30 GMT <alfresco-discord> <sumit> If anyone knows that this aspect can impact user deletions, i request you plz guide me.

2019-09-05 12:05:42 GMT <hi-ko> are there any relase notes about changes from search services 1.3.0 to 1.3.6 (1.4.IE)? What stands IE for?

2019-09-05 12:15:12 GMT <angelborroy> IE is Insight Engine, the name of the Enterprise Product

2019-09-05 12:16:29 GMT <angelborroy> There is no release notes for 1.3.0.x as these versions include only hot fixes

2019-09-05 12:17:16 GMT <angelborroy> This is the version we are releasing these days

2019-09-05 12:17:17 GMT <angelborroy> https://github.com/Alfresco/SearchServices/tree/1.4.0

2019-09-05 12:17:18 GMT <alfbot> Title:GitHub - Alfresco/SearchServices at 1.4.0 (at github.com)

2019-09-05 12:17:19 GMT <angelborroy> 1.4.0

2019-09-05 12:17:28 GMT <angelborroy> Probably it will become public next week

2019-09-05 12:23:20 GMT <hi-ko> angelborroy: thanks. And 1.4 will get a release note and why we should update even on CE? ;-)

2019-09-05 12:23:41 GMT <angelborroy> 1.4 will include a release note

2019-09-05 12:23:49 GMT <angelborroy> But there is no new feature for Community

2019-09-05 12:24:01 GMT <angelborroy> As it only includes improvements for Sharding and fixes

2019-09-05 12:24:17 GMT <hi-ko> @sumit: the strange CascadeUpdate is something angelboroy described here: https://angelborroy.wordpress.com/2016/09/20/alfresco-what-happens-when-a-folder-is-moved/

2019-09-05 12:24:18 GMT <alfbot> Title:Alfresco: what happens when a folder is moved | Programming and So (at angelborroy.wordpress.com)

2019-09-05 12:25:01 GMT <hi-ko> I suspect this is the reason of your trouble. I guess there are some policies, references, missing models?

2019-09-05 12:26:10 GMT <hi-ko> angelborroy. so we stay compfortable by using 1.3.6 - thanks.

2019-09-05 12:26:18 GMT <angelborroy> sure

2019-09-05 12:28:29 GMT <hi-ko> angelborroy: but I would help if your friends write at least minimalistic release notes on github. On top they should release the alfresco parts only to make updates easier

2019-09-05 12:28:50 GMT <angelborroy> I know and I agree

2019-09-05 13:55:49 GMT <hi-ko_> angelborroy: shouldn't it be sufficient to just replace alfresco-search-services/solr/server/solr-webapp/webapp/WEB-INF/lib/*alfresco*.jar to update search services?

2019-09-05 13:56:19 GMT <angelborroy> I donโ€™t know

2019-09-05 13:56:23 GMT <angelborroy> I didnโ€™t test that

2019-09-05 13:56:41 GMT <angelborroy> If there is no changes in XML / Properties configuration or shell scripts, that should work

2019-09-05 13:57:03 GMT <angelborroy> We are also patching solr-6.6.5 libraries, so this also should be updated

2019-09-05 13:58:19 GMT <hi-ko_> you mean xercesImpl-2.11.0-alfresco-patched-20180402.jar?

2019-09-05 14:27:03 GMT <alfresco-discord> <LuisColorado> Does Solr6 support the same actions available in Solr4 (for example, FIX, RETRY, REINDEX, etc.)?

2019-09-05 14:27:31 GMT <angelborroy> Mostly, yes

2019-09-05 14:27:54 GMT <angelborroy> hi-ko, I mean every solr JAR library

2019-09-05 14:39:04 GMT <angelborroy> hi-ko_ We are using Solr building the libraries from https://github.com/Alfresco/lucene-solr

2019-09-05 14:39:05 GMT <alfbot> Title:GitHub - Alfresco/lucene-solr: Mirror of Apache Lucene + Solr (at github.com)

2019-09-05 15:12:41 GMT <alfresco-discord> <dgradecak> angel, any plan to move to a more recent solr version?

2019-09-05 15:17:59 GMT <grendal_prime> alfresco-discord: you mentioned that i can run a newer database on alfresco? how would i go about doing that? i dont see any way of installing a new one seperate from the installation that i have.

2019-09-05 15:18:49 GMT <grendal_prime> should i just install the distro available one..upgrade my data and then adjust the configs in alfresco to point to the database outside of alfresco?

2019-09-05 15:22:50 GMT <alfresco-discord> <dgradecak> sure grendal_prime

2019-09-05 15:23:43 GMT <grendal_prime> ?

2019-09-05 15:25:08 GMT <alfresco-discord> <Thijs> grendal_prime: You can install Postgres seperately. From your questions I suppose you are using the Alfresco installer?

2019-09-05 15:26:04 GMT <grendal_prime> ya

2019-09-05 15:26:24 GMT <alfresco-discord> <Thijs> you can choose to install without postgres I think

2019-09-05 15:26:29 GMT <alfresco-discord> <Thijs> I never use the installer

2019-09-05 15:27:07 GMT <grendal_prime> i would like to be all the way to version 6 however... i have not had any luck installing without the installer, and...that entire process of docker is just goofy.

2019-09-05 15:27:23 GMT <alfresco-discord> <Thijs> windows/linux?

2019-09-05 15:28:07 GMT <grendal_prime> linx..havnet owned a windows machine in over 10 years

2019-09-05 15:28:34 GMT <grendal_prime> i have to say im a little disenchanted with the documentation for alfresco.

2019-09-05 15:29:29 GMT <grendal_prime> i just upgradding my database (and im pretty familar with postgresql) took me about 3 days to figure this out and get it working..with just one version upgrade

2019-09-05 15:30:14 GMT <grendal_prime> I was going to make a video..but right after i did this my orginal vm..stoped working..and i cannot figure out as to why.

2019-09-05 15:35:34 GMT <alfresco-discord> <Thijs> if you know how to run a postgres, then you can install a recent pg and dump restore, configure the db connection ...

2019-09-05 15:37:15 GMT <alfresco-discord> <Thijs> Alfresco documentation will not help you with that, because they don't officially support newer versions of postgres on 5.2

2019-09-05 15:40:23 GMT <grendal_prime> well im running 5.2 now...finally

2019-09-05 15:41:19 GMT <grendal_prime> i guess i could try it, not sure how to disable the embeded postgresql server though...ill have to look more into it.

2019-09-05 15:41:36 GMT <grendal_prime> you have any advice on a alfresco 6 build?

2019-09-05 15:42:07 GMT <alfresco-discord> <Thijs> use docker-compose

2019-09-05 15:43:19 GMT <grendal_prime> i got it working like that but thats a joke..you have to create all these volumes for it? wich i dont get. I see the point of docker from a developer aspect but production...there is just another layer of bs i have to deal with.

2019-09-05 15:46:16 GMT <grendal_prime> I learned a lot from this last migration foray but...well it seems to me a bit.."sketchy?" for a production environment. I implemented a standard flat file rsync backup via a smb mount to the alfresco server...just incase this server fails and i cant get to the data via alfresco...

2019-09-05 15:47:35 GMT <grendal_prime> that might seem a bit paranoid..but...hell "Just because your paranoid doesn't mean their not out to get you."

2019-09-05 16:19:53 GMT <alfresco-discord> <Alberto Rugnone> Hi guys, hello everybody. I have a question and I hope someone can help me. I am sorry for the long text. They load spring context and a particular alfresco-global.properties with h2 configured. Error creating bean with name 'org.springframework.beans.factory.config.PropertyPathFactoryBean#2a1debfa' defined in class path resource [alfresco/ibatis/ibatis-context.xml]: Initialization of bean

2019-09-05 16:19:54 GMT <alfresco-discord> failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dialect': FactoryBean threw exception on object creation; nested exception is java.lang.IllegalArgumentException: Dialect must be explicitly set for database: H2 Here my global properties aboud DB db.driver=org.h2.jdbcx.JdbcDataSource

2019-09-05 16:19:54 GMT <alfresco-discord> db.url=jdbc:h2:${alfresco.data.location}/h2_data/alf_dev;AUTO_SERVER=TRUE;DB_CLOSE_ON_EXIT=FALSE;LOCK_TIMEOUT=10000;MVCC=FALSE;LOCK_MODE=0 db.username=alfresco db.password=alfresco db.pool.initial=10 db.pool.max=100 hibernate.dialect=org.hibernate.dialect.H2Dialect I noted that dialects are defined in DialectFactory#MAPPERS a static map with all dialect but from 5.0.d to alfresco-repository:7.43 that I am using

2019-09-05 16:19:55 GMT <alfresco-discord> H2 dialect has been deleted (and in the next versions the dialects are even less) There is someone that can help me?

2019-09-05 16:29:35 GMT <alfresco-discord> <Alberto Rugnone> I see there is a post con alfresco community with a similar problem https://community.alfresco.com/thread/241949-dialect-database-mariadb

2019-09-05 16:29:37 GMT <alfbot> Title:Dialect Database MariaDB | Alfresco Community (at community.alfresco.com)

2019-09-05 16:34:25 GMT <AFaust> H2 is not supported as a database for Alfresco 6.x - Alfresco used to sort-of support H2 for development environments in earlier versions, but even that was always "at your own risk".

2019-09-05 16:35:29 GMT <AFaust> H2 has never been supported for test / production uses..

2019-09-05 16:37:54 GMT <alfresco-discord> <Alberto Rugnone> thank you Faust :), how I can set an in memory db for my junit test (possibly without docker)

2019-09-05 16:38:27 GMT <alfresco-discord> <Alberto Rugnone> they are a lot and I can throw them away

2019-09-05 16:39:30 GMT <alfresco-discord> <Alberto Rugnone> However DialectFactory in 5.0.d had that H2 dialect, you can check

2019-09-05 17:35:25 GMT <AFaust> There is no support for any in-memory DB in the newest Alfresco versions. Even Alfresco are running their unit tests against Postgres.

2019-09-05 17:36:14 GMT <AFaust> Sure, DialectFactory in 5.0.d had the H2 dialect, but Alfresco did not have any SQL mapping files by default without adding a special (non-production) dependency for H2 scripts.

2019-09-05 17:39:48 GMT <AFaust> That's what I meant with it was "sort-of supported"

2019-09-05 18:29:55 GMT <alfresco-discord> <dgradecak> You can still check if testcontainers fits your needs. Although testing with a db is not really unit testing

2019-09-05 18:30:06 GMT <alfresco-discord> <dgradecak> I run testcontainers for anything I need, solr for instance

End of Daily Log

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