topic Re: Copy the JDBC drivers for the database you are using to the lib directory. in Alfresco Forum

Copy the JDBC drivers for the database you are using to the lib directory.

marat — Tue, 08 Jun 2021 06:34:07 GMT

Hello!I try to install alfresco manually using this manual

https://docs.alfresco.com/content-services/community/install/zip/tomcat/

Could you tell me the command in ubuntu to copy jdbc driver for the database to the lib directory ?

I don't know where are these drivers located.

Re: Copy the JDBC drivers for the database you are using to the lib directory.

angelborroy — Tue, 08 Jun 2021 07:38:15 GMT

tomcat/webapps/alfresco/WEB-INF/lib should be the target directory for the JDBC JAR file.

Re: Copy the JDBC drivers for the database you are using to the lib directory.

marat — Tue, 08 Jun 2021 08:13:56 GMT

Spoiler

/usr/lib/jvm/java-11-openjdk-amd64/lib/jrt-fs.jar

/usr/share/apport/apport.jar
/usr/share/apport/testsuite/crash.jar
/usr/share/ca-certificates-java/ca-certificates-java.jar
/usr/share/java/bsh-2.0b4.jar
/usr/share/java/bsh.jar
/usr/share/java/commons-logging-1.2.jar
/usr/share/java/commons-logging-adapters-1.2.jar
/usr/share/java/commons-logging-adapters.jar
/usr/share/java/commons-logging-api-1.2.jar
/usr/share/java/commons-logging-api.jar
/usr/share/java/commons-logging.jar
/usr/share/java/el-api-3.0.0.jar
/usr/share/java/el-api-3.0.jar
/usr/share/java/el-api.jar
/usr/share/java/hsqldb1.8.0-1.8.0.10+dfsg.jar
/usr/share/java/hsqldb1.8.0.jar
/usr/share/java/hsqldbutil1.8.0-1.8.0.10+dfsg.jar
/usr/share/java/hsqldbutil1.8.0.jar
/usr/share/java/java-atk-wrapper.jar
/usr/share/java/java_uno.jar
/usr/share/java/jsp-api-2.3.4-SNAPSHOT.jar
/usr/share/java/jsp-api-2.3.jar
/usr/share/java/jsp-api.jar
/usr/share/java/juh-6.4.7.jar
/usr/share/java/juh.jar
/usr/share/java/jurt-6.4.7.jar
/usr/share/java/jurt.jar
/usr/share/java/libintl.jar
/usr/share/java/ridl-6.4.7.jar
/usr/share/java/ridl.jar
/usr/share/java/servlet-api-3.1.jar
/usr/share/java/servlet-api-4.0.1.jar
/usr/share/java/servlet-api.jar
/usr/share/java/unoil-6.4.7.jar
/usr/share/java/unoil.jar
/usr/share/java/unoloader-6.4.7.jar
/usr/share/java/unoloader.jar
/usr/share/java/websocket-api-1.0.jar
/usr/share/java/websocket-api-1.1.jar
/usr/share/java/websocket-api.jar
/usr/share/java/websocket-client-api-1.1.jar
/usr/share/java/websocket-client-api.jar
/usr/share/libreoffice/program/classes/ScriptFramework.jar
/usr/share/libreoffice/program/classes/ScriptProviderForJava.jar
/usr/share/libreoffice/program/classes/XMergeBridge.jar
/usr/share/libreoffice/program/classes/commonwizards.jar
/usr/share/libreoffice/program/classes/form.jar
/usr/share/libreoffice/program/classes/query.jar
/usr/share/libreoffice/program/classes/report.jar
/usr/share/libreoffice/program/classes/sdbc_hsqldb.jar
/usr/share/libreoffice/program/classes/table.jar
/usr/share/libreoffice/program/classes/xmerge.jar
/usr/share/maven-repo/commons-logging/commons-logging/1.2/commons-logging-1.2.jar
/usr/share/maven-repo/commons-logging/commons-logging/debian/commons-logging-debian.jar
/usr/share/maven-repo/commons-logging/commons-logging-adapters/1.2/commons-logging-adapters-1.2.jar
/usr/share/maven-repo/commons-logging/commons-logging-adapters/debian/commons-logging-adapters-debian.jar
/usr/share/maven-repo/commons-logging/commons-logging-api/1.2/commons-logging-api-1.2.jar
/usr/share/maven-repo/commons-logging/commons-logging-api/debian/commons-logging-api-debian.jar
/usr/share/maven-repo/javax/el/javax.el-api/3.0/javax.el-api-3.0.jar
/usr/share/maven-repo/javax/el/javax.el-api/3.0.0/javax.el-api-3.0.0.jar
/usr/share/maven-repo/javax/el/javax.el-api/debian/javax.el-api-debian.jar
/usr/share/maven-repo/javax/servlet/javax.servlet-api/3.1/javax.servlet-api-3.1.jar
/usr/share/maven-repo/javax/servlet/javax.servlet-api/4.0.1/javax.servlet-api-4.0.1.jar
/usr/share/maven-repo/javax/servlet/javax.servlet-api/debian/javax.servlet-api-debian.jar
/usr/share/maven-repo/javax/servlet/jsp/javax.servlet.jsp-api/2.3/javax.servlet.jsp-api-2.3.jar
/usr/share/maven-repo/javax/servlet/jsp/javax.servlet.jsp-api/2.3.4-SNAPSHOT/javax.servlet.jsp-api-2.3.4-SNAPSHOT.jar
/usr/share/maven-repo/javax/servlet/jsp/javax.servlet.jsp-api/debian/javax.servlet.jsp-api-debian.jar
/usr/share/maven-repo/javax/servlet/jsp/jsp-api/debian/jsp-api-debian.jar
/usr/share/maven-repo/javax/servlet/servlet-api/debian/servlet-api-debian.jar
/usr/share/maven-repo/javax/websocket/javax.websocket-api/1.1/javax.websocket-api-1.1.jar
/usr/share/maven-repo/javax/websocket/javax.websocket-api/debian/javax.websocket-api-debian.jar
/usr/share/maven-repo/javax/websocket/javax.websocket-client-api/1.1/javax.websocket-client-api-1.1.jar
/usr/share/maven-repo/javax/websocket/javax.websocket-client-api/debian/javax.websocket-client-api-debian.jar
/usr/share/maven-repo/org/beanshell/bsh/2.0b4/bsh-2.0b4.jar
/usr/share/maven-repo/org/beanshell/bsh/debian/bsh-debian.jar
/usr/share/maven-repo/org/libreoffice/juh/6.4.7/juh-6.4.7.jar
/usr/share/maven-repo/org/libreoffice/juh/debian/juh-debian.jar
/usr/share/maven-repo/org/libreoffice/jurt/6.4.7/jurt-6.4.7.jar
/usr/share/maven-repo/org/libreoffice/jurt/debian/jurt-debian.jar
/usr/share/maven-repo/org/libreoffice/ridl/6.4.7/ridl-6.4.7.jar
/usr/share/maven-repo/org/libreoffice/ridl/debian/ridl-debian.jar
/usr/share/maven-repo/org/libreoffice/unoil/6.4.7/unoil-6.4.7.jar
/usr/share/maven-repo/org/libreoffice/unoil/debian/unoil-debian.jar
/usr/share/maven-repo/org/libreoffice/unoloader/6.4.7/unoloader-6.4.7.jar
/usr/share/maven-repo/org/libreoffice/unoloader/debian/unoloader-debian.jar

/usr/lib/jvm/java-11-openjdk-amd64/lib/jrt-fs.jar/usr/share/apport/apport.jar/usr/share/apport/testsuite/crash.jar/usr/share/ca-certificates-java/ca-certificates-java.jar/usr/share/java/bsh-2.0b4.jar/usr/share/java/bsh.jar/usr/share/java/commons-logging-1.2.jar/usr/share/java/commons-logging-adapters-1.2.jar/usr/share/java/commons-logging-adapters.jar/usr/share/java/commons-logging-api-1.2.jar/usr/share/java/commons-logging-api.jar/usr/share/java/commons-logging.jar/usr/share/java/el-api-3.0.0.jar/usr/share/java/el-api-3.0.jar/usr/share/java/el-api.jar/usr/share/java/hsqldb1.8.0-1.8.0.10+dfsg.jar/usr/share/java/hsqldb1.8.0.jar/usr/share/java/hsqldbutil1.8.0-1.8.0.10+dfsg.jar/usr/share/java/hsqldbutil1.8.0.jar/usr/share/java/java-atk-wrapper.jar/usr/share/java/java_uno.jar/usr/share/java/jsp-api-2.3.4-SNAPSHOT.jar/usr/share/java/jsp-api-2.3.jar/usr/share/java/jsp-api.jar/usr/share/java/juh-6.4.7.jar/usr/share/java/juh.jar/usr/share/java/jurt-6.4.7.jar/usr/share/java/jurt.jar/usr/share/java/libintl.jar/usr/share/java/ridl-6.4.7.jar/usr/share/java/ridl.jar/usr/share/java/servlet-api-3.1.jar/usr/share/java/servlet-api-4.0.1.jar/usr/share/java/servlet-api.jar/usr/share/java/unoil-6.4.7.jar/usr/share/java/unoil.jar/usr/share/java/unoloader-6.4.7.jar/usr/share/java/unoloader.jar/usr/share/java/websocket-api-1.0.jar/usr/share/java/websocket-api-1.1.jar/usr/share/java/websocket-api.jar/usr/share/java/websocket-client-api-1.1.jar/usr/share/java/websocket-client-api.jar/usr/share/libreoffice/program/classes/ScriptFramework.jar/usr/share/libreoffice/program/classes/ScriptProviderForJava.jar/usr/share/libreoffice/program/classes/XMergeBridge.jar/usr/share/libreoffice/program/classes/commonwizards.jar/usr/share/libreoffice/program/classes/form.jar/usr/share/libreoffice/program/classes/query.jar/usr/share/libreoffice/program/classes/report.jar/usr/share/libreoffice/program/classes/sdbc_hsqldb.jar/usr/share/libreoffice/program/classes/table.jar/usr/share/libreoffice/program/classes/xmerge.jar/usr/share/maven-repo/commons-logging/commons-logging/1.2/commons-logging-1.2.jar/usr/share/maven-repo/commons-logging/commons-logging/debian/commons-logging-debian.jar/usr/share/maven-repo/commons-logging/commons-logging-adapters/1.2/commons-logging-adapters-1.2.jar/usr/share/maven-repo/commons-logging/commons-logging-adapters/debian/commons-logging-adapters-debian.jar/usr/share/maven-repo/commons-logging/commons-logging-api/1.2/commons-logging-api-1.2.jar/usr/share/maven-repo/commons-logging/commons-logging-api/debian/commons-logging-api-debian.jar/usr/share/maven-repo/javax/el/javax.el-api/3.0/javax.el-api-3.0.jar/usr/share/maven-repo/javax/el/javax.el-api/3.0.0/javax.el-api-3.0.0.jar/usr/share/maven-repo/javax/el/javax.el-api/debian/javax.el-api-debian.jar/usr/share/maven-repo/javax/servlet/javax.servlet-api/3.1/javax.servlet-api-3.1.jar/usr/share/maven-repo/javax/servlet/javax.servlet-api/4.0.1/javax.servlet-api-4.0.1.jar/usr/share/maven-repo/javax/servlet/javax.servlet-api/debian/javax.servlet-api-debian.jar/usr/share/maven-repo/javax/servlet/jsp/javax.servlet.jsp-api/2.3/javax.servlet.jsp-api-2.3.jar/usr/share/maven-repo/javax/servlet/jsp/javax.servlet.jsp-api/2.3.4-SNAPSHOT/javax.servlet.jsp-api-2.3.4-SNAPSHOT.jar/usr/share/maven-repo/javax/servlet/jsp/javax.servlet.jsp-api/debian/javax.servlet.jsp-api-debian.jar/usr/share/maven-repo/javax/servlet/jsp/jsp-api/debian/jsp-api-debian.jar/usr/share/maven-repo/javax/servlet/servlet-api/debian/servlet-api-debian.jar/usr/share/maven-repo/javax/websocket/javax.websocket-api/1.1/javax.websocket-api-1.1.jar/usr/share/maven-repo/javax/websocket/javax.websocket-api/debian/javax.websocket-api-debian.jar/usr/share/maven-repo/javax/websocket/javax.websocket-client-api/1.1/javax.websocket-client-api-1.1.jar/usr/share/maven-repo/javax/websocket/javax.websocket-client-api/debian/javax.websocket-client-api-debian.jar/usr/share/maven-repo/org/beanshell/bsh/2.0b4/bsh-2.0b4.jar/usr/share/maven-repo/org/beanshell/bsh/debian/bsh-debian.jar/usr/share/maven-repo/org/libreoffice/juh/6.4.7/juh-6.4.7.jar/usr/share/maven-repo/org/libreoffice/juh/debian/juh-debian.jar/usr/share/maven-repo/org/libreoffice/jurt/6.4.7/jurt-6.4.7.jar/usr/share/maven-repo/org/libreoffice/jurt/debian/jurt-debian.jar/usr/share/maven-repo/org/libreoffice/ridl/6.4.7/ridl-6.4.7.jar/usr/share/maven-repo/org/libreoffice/ridl/debian/ridl-debian.jar/usr/share/maven-repo/org/libreoffice/unoil/6.4.7/unoil-6.4.7.jar/usr/share/maven-repo/org/libreoffice/unoil/debian/unoil-debian.jar/usr/share/maven-repo/org/libreoffice/unoloader/6.4.7/unoloader-6.4.7.jar/usr/share/maven-repo/org/libreoffice/unoloader/debian/unoloader-debian.jar

Could you tell me the exact name of the jar file?

Re: Copy the JDBC drivers for the database you are using to the lib directory.

angelborroy — Tue, 08 Jun 2021 09:20:13 GMT

If you are using Postgres as database, the JAR file is provided by default. In the path I provided before.

Re: Copy the JDBC drivers for the database you are using to the lib directory.

marat — Tue, 08 Jun 2021 09:49:07 GMT

Yes i use postgre.So i should copy the jar file from tomcat/webapps/alfresco/WEB-INF/lib

And where i should copy that file ?I created two folders.

shared/classes directory.

shared/lib directory

Re: Copy the JDBC drivers for the database you are using to the lib directory.

angelborroy — Tue, 08 Jun 2021 10:25:43 GMT

You don't need additional operations. The file is provided with default ZIP Distribution file and it's unzipped to the right folder.

Re: Copy the JDBC drivers for the database you are using to the lib directory.

abhinavmishra14 — Tue, 08 Jun 2021 14:16:39 GMT

@marat wrote:

Hello!I try to install alfresco manually using this manual

https://docs.alfresco.com/content-services/community/install/zip/tomcat/

Could you tell me the command in ubuntu to copy jdbc driver for the database to the lib directory ?

I don't know where are these drivers located.

Also checkout this post: https://hub.alfresco.com/t5/news-announcements/installing-alfresco-community-6-2-without-docker-or-ansible/ba-p/304808/jump-to/first-unread-message

There are posts to install acs using distribution packages.

Re: Copy the JDBC drivers for the database you are using to the lib directory.

marat — Thu, 17 Jun 2021 07:48:02 GMT

Hello!Could you help me ?

I use your guide to install alfresco.But when i try to install pgadmin using this command

sudo yum install pgadmin4 -y

then an error appears

[root@localhost admin]# sudo yum install pgadmin4 -y
Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
* base: mirror.corbina.net
* extras: mirror.yandex.ru
* updates: mirror.sale-dedic.com
No package pgadmin4 available.
Error: Nothing to do

When i use another command to install pgadmin

sudo yum -y install https://ftp.postgresql.org/pub/pgadmin/pgadmin4/yum/pgadmin4-redhat-repo-1-1.noarch.rpm

yum -y install epel-release policycoreutils-devel

yum -y install pgadmin4-web

sed -i 's/^Listen.*/Listen 81/' /etc/httpd/conf/httpd.conf

systemctl enable --now httpd

firewall-cmd --permanent --add-port=81/tcp

firewall-cmd --reload

/usr/pgadmin4/bin/setup-web.sh

i can install pgadmin and open it in a browser

And when i try to proceed using commands from your guide

sudo cp /etc/httpd/conf.d/pgadmin4.conf.sample /etc/httpd/conf.d/pgadmin4.conf

sudo vim /usr/lib/python3.6/site-packages/pgadmin4-web/config_distro.py

sudo python3 /usr/lib/python3.6/site-packages/pgadmin4-web/setup.py

there are no such files pgadmin4.conf.sample,config_distro.py,setup.py, and folder pgadmin4-web

But pgadmin4.conf is present there.

Re: Copy the JDBC drivers for the database you are using to the lib directory.

marat — Thu, 17 Jun 2021 07:52:56 GMT

Why the command sudo yum install pgadmin4 -y can't find pgadmin rpm

and files config_distro.py setup.py pgadmin4.conf.sample and folder pgadmin4-web could not be created when i use commands from your guide ?