Finally, IT WORKED, I can't really blame you, to be honest,
There is a lot of stuff going on with James and you seem to be the only one around most times. I'll give a hand when I can. So I hope you enjoyed your holidays, Cheers, On Tue, Jan 4, 2022 at 2:18 PM Benoit TELLIER <btell...@linagora.com> wrote: > You are right. > > On upcoming 3.7.0/master JDBC the docker image is assembled using JIB > (wich brings in the /root/libs folder) > > Prior to this (3.6.1 included) we were running a java command inside > docker, you would need to override the CMD of the container to override > the classpath of the container, as in > > https://github.com/apache/james-project/tree/master/server/apps/jpa-app#using-alternative-jdbc-drivers > > > Example of Java command: > > java \ > -javaagent:james-server-jpa-app.lib/openjpa-3.1.2.jar \ > -Dworking.directory=. \ > -Djdk.tls.ephemeralDHKeySize=2048 \ > -Dlogback.configurationFile=conf/logback.xml \ > -cp > "james-server-jpa-app.jar:james-server-jpa-app.lib/*:jdbc-driver.jar" \ > org.apache.james.JPAJamesServerMain > > Best regards, > > I hope it helps, sorry for the misleading pointer... > > Benoit > > On 04/01/2022 18:06, Bs Serge wrote: > > Hi Benoit, > > > > Still, it does not work, the /root/libs folder does not by default exists > > in the 3.6.1 guice-jpa docker container, so I had to create it but even > it > > did not solve the issue coz I still get the same error : > > ClassNotFoundException: org.postgresql.Driver > > > > Below is every directory I have placed the Postgres jar in. > > > > # docker exec -it james_run sh > > # > > # find / -name post* > > /root/james-server-cli.lib/postgresql-42.3.1.jar > > /root/extensions-jars/postgresql-42.3.1.jar > > /root/libs/postgresql-42.3.1.jar > > /root/james-server-jpa-guice.lib/postgresql-42.3.1.jar > > /root/postgresql-42.3.1.jar > > # > > > > I still do not understand what it is going to take for the james jvm to > > pick up the jar file coz I have also used the jcmd tool to inspect the > > class hierarchy in the JVM and there is not any postgres class from the > > postgres jar. > > > > Kindly let me know your thoughts as well. > > > > Best regards, > > > > > > On Tue, Jan 4, 2022 at 3:46 AM Benoit TELLIER <btell...@linagora.com> > wrote: > > > >> Hello Serge, > >> > >> Sorry for jumping late on the topic to provide you help. > >> > >> /root/libs is the folder you need to put things in for them to be on the > >> classpath. > >> > >> extension-jars is a folder looked up when loading extensions (mailet, > >> matcher, listeners, webadmin routes etc...) and is not directly on the > >> classpath... > >> > >> I did put an example of setting up JPA app with an external DB: > >> > >> > https://github.com/apache/james-project/tree/master/server/apps/jpa-app#using-alternative-jdbc-drivers-with-docker > >> > >> > >> Best regards, > >> > >> Benoit TELLIER > >> > >> On 03/01/2022 20:43, Bs Serge wrote: > >>> # docker exec -it james_run sh > >>> # find -name post* > >>> ./james-server-cli.lib/postgresql-42.3.1.jar > >>> ./extensions-jars/postgresql-42.3.1.jar > >>> ./james-server-jpa-guice.lib/postgresql-42.3.1.jar > >>> ./postgresql-42.3.1.jar > >>> # > >>> > >>> I have included the Postgres jar file in every possible directory but > >>> still, I get the same error : ClassNotFoundException: > >> org.postgresql.Driver > >>> Regards, > >>> > >>> > >>> On Mon, Jan 3, 2022 at 2:03 PM Bs Serge <sergeb...@gmail.com> wrote: > >>> > >>>> Progress update : > >>>> > >>>> I added the Postgres jar file in the 'extensions-jars' folder and I > can > >>>> see it being loaded in the classpath in the logs : > >>>> > >>>> 11:41:55.472 [34m[INFO ] [0;39m o.a.j.u.ExtendedClassLoader - Loading > >>>> custom classpath resource > /root/./extensions-jars/postgresql-42.3.1.jar > >>>> > >>>> but I'm still getting the same error : > >> java.lang.ClassNotFoundException: > >>>> org.postgresql.Driver > >>>> > >>>> Below is the full logs > >>>> > >>>> Full logs: > >>>> > >> > https://paste.0xfc.de/?1df0ef907332046f#56txc688Yicbqgt84VFiaDJ6tvB3joLwoKDmE2wtxkvi > >>>> Any thoughts or comments would be appreciated! > >>>> > >>>> Best regards, > >>>> > >>>> On Fri, Dec 31, 2021 at 7:09 PM Bs Serge <sergeb...@gmail.com> wrote: > >>>> > >>>>> James 3.6.1 Guice+JPA in a docker container > >>>>> > >>>>> Hi all, > >>>>> > >>>>> I'm using this database configuration [1] in > james-database.properties > >>>>> file to connect to the Postgres server on the Linux host, > >>>>> > >>>>> I also added the Postgres JDBC driver version 42.3.1 jar file [2] in > >> the > >>>>> `james-server-cli.lib` folder inside the container, > >>>>> > >>>>> and when I restart the docker container, it give this error [3] > >>>>> `ClassNotFoundException: org.postgresql.Driver` > >>>>> > >>>>> I'm wondering what I did wrong > >>>>> > >>>>> Any thoughts or comments would be appreciated! > >>>>> > >>>>> [1] > >>>>> > >> > https://paste.0xfc.de/?d1c74b073c748f1a#88WJMDV1v3yg9Zd15zeXoyr3rM4BaCVZB7N5wxzRt9cY > >>>>> [2] https://jdbc.postgresql.org/download.html > >>>>> > >>>>> [3] > >>>>> > >> > https://paste.0xfc.de/?bb4c913bb483930a#FcHAonPNN9LQzfzkSFuQHjwTHT92VUdNswByeMjNSHza > >>>>> Best regards, > >>>>> > >> --------------------------------------------------------------------- > >> To unsubscribe, e-mail: server-user-unsubscr...@james.apache.org > >> For additional commands, e-mail: server-user-h...@james.apache.org > >> > >> >