DSpace/C2/Setting-up-Tomcat-and-Postgresql-on-Windows-OS/English

Script: Setting Tomcat and Postgresql on Windows 10

Author : Pankaj Patil

Keywords: Tomcat Installation, Tomcat8 installation on Windows 10, postgresql installation, Configure tomcat server, Create DSpace database

Visual Cue	Narration
Slide : Title	Welcome to this spoken tutorial on Setting up Tomcat and Postgresql on Windows 10.
Slide: Learning Objectives Slide	In this tutorial, we will learn to Install and configure Tomcat 8 Install Postgresql 11 Create dspace database in Postgresql 11
Slide: System requirements	This tutorial is recorded using Windows 10 64 bit OS WordPad and Firefox web browser However you may use any other editor or browser of your choice.
Slide: Pre-requisites	To practice this tutorial, You should have an internet connection to install the necessary packages You should also have installed 7Zip file archiver
Slide: Pre-requisites	Environment Variables for Java, Ant, and Maven should be set as well If not then please go through the prerequisite tutorials on this website.
Slide : Code files	The commands used in this tutorial are in a file in the Code Files link on this tutorial page. Please download and extract the file before practicing.
Switch to WordPad and open the file	I have opened the commands file in WordPad editor on my machine. And I will use the same file to copy-paste the commands during the demonstration. The shortcut to paste on the Command Prompt is Ctrl and V keys.
Narration only	Generally, DSpace is deployed on Tomcat8 server. Let us now install Apache tomcat 8. Open a web browser.
[Browser] Type: https://downloads.apache.org/tomcat/tomcat-8/v8.5.60/bin/apache-tomcat-8.5.60.exe	In the address bar, type the URL as shown to download Apache tomcat 8 installer.
Click on the Save file	If prompted, click on the Save file button to download the installer. The download begins in the default downloads folder.
Open Downloads folder Double click on Tomcat installer	Go to the place where you have downloaded the file on your machine. In my case it is in the Downloads folder. Double-click on the Tomcat installer file.
Click on Yes	In the User Account Control dialog box, click on Yes or Run button.
Click Next button	In the Setup dialog box, click on the Next button to continue.
Click I Agree button	Click on the I Agree button to accept the terms of agreement.
Click Next button	To proceed with the default components selection, click the Next button.
Click Next button	Click the Next button to continue the installation with basic configurations.
Click Next button	Keep the default path of JRE and click on the Next button to continue.
Click Install button	Keep the default path for Tomcat installation and click on the Install button.
Narration only	The installation is successfully completed.
Uncheck checkbox of Show Readme and click Finish button	Uncheck the Show Readme option. And click on the Finish button to close the dialog box.
Narration only	Apache Tomcat service begins. Now let us configure Tomcat to start on system restart.
Type Control Panel in search box of taskbar	Go to the search bar located at the bottom left of the taskbar. Then type “Control Panel”.
Click on Control Panel Application	Click on the Control Panel application.
Click System and Security settings -> Administrative Tools	Next, go to System and Security settings and then on the Administrative Tools menu.
Point to Administrative Tools	Administrative Tools dialog box opens up.
Double Click on Services	Double-click on Services.
Locate Apache Tomcat service and Right click on it Select Properties	Locate Apache Tomcat service. Then right-click and select Properties.
Point to Window	Apache Tomcat8 properties dialog box opens up.
Click on dropdown of Startup type -> Choose Automatic	Click on the Startup type drop-down and select Automatic from the list.
Click Apply button	Click the Apply button and then on the OK button at the bottom right corner of the window.
Close Service, Administrative Tools, Control Panel window	Now, close the Services, Administrative Tools, and Control Panel windows.
Narration only	So, we have installed Tomcat and configured it. Next let us install postgresql. Switch back to the browser.
[Browser] Type: https://www.enterprisedb.com/downloads/postgres-postgresql-downloads https://www.enterprisedb.com/downloads/postgres-postgresql-downloads	In the address bar type the URL as shown to view the installer packages of postgresql.
Click download button for version 11.10 and 64 bit OS	Download the postgresql version 11.10 for Windows 64 bit OS.
Click on the Save file	If prompted, click on the Save file button to download the installer.
Open Downloads folder	Once again go to the Downloads folder.
Right-click on the postgresql installer and select Run as administrator	Right-click on the postgresql installer and select Run as administrator.
Click on Yes	In the User Account Control dialog box, click on Yes or Run button.
Click Next to begin installation process	Click on the Next button to begin the installation process.
Click Next button	Keep the default settings for Installation location and click on the Next button.
Click Next button	Keep the default selected components and click on the Next button.
Click Next button	Keep the default Data directory and click on the Next button.
Only narration Enter the Password as ‘root’ Retype the same password	In the password setup page, set the root user password. I will type my password as ‘root’. Retype the same password to confirm it.
Click Next button repeatedly	Then, Click the Next button repeatedly to install postgresql with the default configuration.
Uncheck Checkbox of View release notes	Once the installation is over, uncheck the checkbox of “stack builder”.
Click Finish button	Then click the Finish button.
Narration only	Now let us create a database and a user for it.
Type pgadmin4 in search box of taskbar	Go to the search bar located at the bottom left of the taskbar. Then type pgadmin4.
Click on pgadmin4	Click on the pgadmin4 application.
Narration only	pgAdmin is a management tool for PostgreSQL.
Point t o the pgAdmin page in the browser	pgAdmin page opens in the default web browser.
Point to Set Master Password	It might prompt us to set the master password for pgAdmin.
Type password as ‘root’ and Click OK button	I will set the password as ‘root’ and click on the OK button
Double click on Servers in the left panel	On the left panel, double-click on Servers.
Enter password of the postgres user: root Click OK button	Type the postgres user password to connect to the database server and click on the OK button.
Narration only	Now let us create a user for the database.
Right click on Login/Group Roles under PostgreSQL 11	In the left panel, under PostgreSQL 11 right-click on the Login/Group Roles.
Select Create option -> Login/Group Roles option	From the context menu, select Create and then on Login/Group Roles option.
Point to Create- Login/Group Roles	A Pop-up window opens up to create a user for the database.
Enter Name dspace	Under General tab, type the name of the database user in the Name field. So, I will type dspace.
Click Definition tab	Click on the Definition tab.
Enter Password dbuserpass	In the Password field, type the password for the database user. I will type dbuserpass.
Click Privileges tab	Now, go to the Privileges tab.
Toggle buttons to change all values to Yes	To provide all privileges to the user, toggle the buttons and change all the values to Yes.
Click Save button	Then click on the Save button and close the pop-up window.
Narration only	Now let us create a database named dspace.
Right click on Login/Group Roles under Databases	In the left panel, under PostgreSQL 11 right-click on the Databases.
Select Create option -> Database option	From the context menu, select Create and then on Database option.
Point to Create- Database	A pop-up window opens up to create a database.
Enter name of the database Type: dspace	Under the General tab, type the name of the database. I will type dspace.
Click on dropdown next to owner field	Click on the drop-down next to the owner field. A list of database users is seen.
Select dspace	Select dspace as the owner to this database.
Click Definition tab	Go to the Definition tab.
Click on dropdown next to Tablespace field -> Select pg_default	Click on the drop-down next to the Tablespace field and select pg_default
Click Save button	Then click on the Save button and close the pop-up window.
Point to dspace under Databases.	In the left panel, under PostgreSQL 11, under Databases, we see the newly created database dspace.
Click on dspace database.	Click on the dspace database.
Slide: pgcrypto extension	We will now add a pgcrypto extension to the DSpace database. pgcrypto extension allows DSpace to create universally unique identifiers for all objects in DSpace.
Click on the arrow adjacent to the dspace database	If submenus are not shown, Expand the dspace database by clicking on the arrow adjacent to it.
Right click on Extensions Create -> Extensions	Right-click on Extensions. Then from the context menu, select Create and then click on Extensions.
Point to Create Extensions	The Create Extensions pop-up opens up.
Click on dropdown next to Name field	Under the General tab, click on the drop-down next to the Name field.
Select pgcrypto	Scroll and select pgcrypto as an Extension.
Click Save button	Then click on the Save button and close the pop-up window.
Narration only	Pgcrypto extension is created.
Close the pgAdmin4 tab Restart the System	Close the pgAdmin4 tab and restart the system to bring all configurations into effect.
Only narration	So now, we have installed postgresql and created a dspace database. Let us summarize.
Slide : Summary	In this tutorial, we learnt to- Install and configure Tomcat 8 Install Postgresql 11 Create dspace database in Postgresql 11
Slide : About Spoken Tutorial project	The video at the following link summarises the Spoken Tutorial project. Please download and watch it.
Slide : Spoken Tutorial workshops	The Spoken Tutorial Project team conducts workshops and gives certificates. For more details, please write to us.
Slide: Answers for THIS Spoken Tutorial	Please post your timed queries in this Forum.
Slide: Acknowledgement -I	Spoken Tutorial project is funded by Ministry of Education (MoE), Government of India.
Slide: Acknowledgement -II	DSpace spoken tutorial series is funded by the National Virtual Library of India, Ministry of Culture, Government of India.
Narration only	This script and video for this tutorial was contributed by Pankaj Patil from IIT Bombay. And this is Nancy Varkey signing off. Thanks for joining.

Contributors and Content Editors

Pankajpatil694, Pravin1389