Help

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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
marat
Active Member
‎8 Jun 2021 7:34 AM

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.

0 Kudos
8 Replies
angelborroy
Alfresco Employee
‎8 Jun 2021 8:38 AM

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
‎8 Jun 2021 9:13 AM

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?

0 Kudos
angelborroy
Alfresco Employee
‎8 Jun 2021 10:20 AM

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
0 Kudos
marat
Active Member
‎8 Jun 2021 10:49 AM

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

0 Kudos
angelborroy
Alfresco Employee
‎8 Jun 2021 11:25 AM

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
‎8 Jun 2021 3:16 PM

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
‎17 Jun 2021 8:48 AM

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.

 

 

 

0 Kudos
marat
Active Member
‎17 Jun 2021 8:52 AM

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 ?

 

 

  

0 Kudos
Alfresco Content Services Forum

Ask for and offer help to other Alfresco Content Services Users and members of the Alfresco team.

Related links:

We use cookies on this site to enhance your user experience

By using this site, you are agreeing to allow us to collect and use cookies as outlined in Alfresco’s Cookie Statement and Terms of Use (and you have a legitimate interest in Alfresco and our products, authorizing us to contact you in such methods).   If you are not ok with these terms, please do not use this website.