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

cancel
Showing results for 
Search instead for 
Did you mean: 
marat
Active Member

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

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.

8 Replies
angelborroy
Alfresco Employee

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

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

Hyland Developer Evangelist
marat
Active Member

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

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

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

angelborroy
Alfresco Employee

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

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

Hyland Developer Evangelist
marat
Active Member

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

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

angelborroy
Alfresco Employee

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

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

Hyland Developer Evangelist
abhinavmishra14
Advanced

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


@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-a...

There are posts to install acs using distribution packages.

~Abhinav
(ACSCE, AWS SAA, Azure Admin)
marat
Active Member

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

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.

 

 

 

marat
Active Member

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

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 ?