This is the procedure I follow to install CMBuild from scracth.
Required software
CMDBuild 3.2.1
CentOS 8.2.2004
Postgres 10.14
TomCat 9.0.37
| CentOS 8.2.2004 USE ADMIN ACCOUNT |
|
| Server Install |
CentOS-8.2.2004-x86_64-dvd1 / Server no GUI |
| Add admin to sudo |
visudo |
|
admin ALL=(ALL) ALL |
| Activate web console |
systemctl enable --now cockpit.socket |
| Update server |
ip:9090 |
| Change host name |
hostnamectl set-hostname cmdbuild |
| Start Network Manager |
systemctl start NetworkManager |
| Identify Interface |
nmcli device |
| Down interface if active |
ifdown ens32 |
| Create a Connection Profile |
nmcli connection add type ethernet ifname ens32 con-name cmdb |
| Configuring Static IP Address |
nmcli connection modify cmdb ipv4.addresses 192.168.17.128/24 ipv4.gateway 192.168.107.2 |
| Make the Connection to Start Persistently |
nmcli connection modify cmdb ipv4.method manual ipv6.method ignore autoconnect yes |
| Verify the New Connection Profile |
nmcli connection |
| Bring the interface Offline |
nmcli connection down cmdb |
| Bring the interface Online |
nmcli connection up cmdb |
| Verify configuration file saved settings |
cat /etc/sysconfig/network-scripts/ifcfg-cmdb |
| Postgres 10.14 |
|
| Install Repository RPM |
sudo dnf install https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
|
| Disable Builtin PostgreSQL |
sudo dnf -qy module disable postgresql |
| Install PostgreSQL |
sudo dnf install postgresql10-server |
| initialize the database and enable automatic start |
sudo /usr/pgsql-10/bin/postgresql-10-setup initdb |
|
sudo systemctl enable postgresql-10 |
|
sudo systemctl start postgresql-10 |
| Edit postgres conf files |
sudo vi /var/lib/pgsql/10/data/postgresql.conf |
| Set the local host to password and your host to trust |
sudo vi /var/lib/pgsql/10/data/pg_hba.conf |
| Reset postgres user |
sudo su postgres -c psql postgres |
|
postgres=# ALTER USER postgres WITH PASSWORD ‘cmdbuild’; |
|
postgres=# \q |
|
sudo passwd -d postgres |
|
sudo su postgres -c passwd |
|
sudo systemctl restart postgresql-10 |
| TomCat 9.0.37 |
|
| Prepare Tomcat 9 install |
yum search java |
| Install JDK 1.11 |
sudo yum install java-11-openjdk.x86_64 |
| Verify Java |
java -version |
| Create tomcat user and group |
sudo groupadd --system tomcat |
|
sudo useradd -d /usr/share/tomcat -r -s /bin/false -g tomcat tomcat |
| Install Tomcat 9 |
sudo yum -y install wget |
|
export VER=9.0.37 |
|
wget https://archive.apache.org/dist/tomcat/tomcat-9/v${VER}/bin/apache-tomcat-${VER}.tar.gz
|
| Extract downloaded file |
sudo tar xvf apache-tomcat-${VER}.tar.gz -C /usr/share/ |
| Create symlink to extracted tomcat data |
sudo ln -s /usr/share/apache-tomcat-$VER/ /usr/share/tomcat |
| Set proper directory permissions |
sudo chown -R tomcat:tomcat /usr/share/tomcat |
|
sudo chown -R tomcat:tomcat /usr/share/apache-tomcat-$VER/ |
| Configure Tomcat 9 Systemd service |
sudo vim /etc/systemd/system/tomcat.service |
| Start and enable service |
sudo systemctl daemon-reload |
|
sudo systemctl start tomcat |
|
sudo systemctl enable tomcat |
| Check service status |
systemctl status tomcat |
| Configure Firewall |
sudo firewall-cmd --permanent --add-port=8080/tcp |
|
sudo firewall-cmd --reload |
| CMDBuild 3.2.1 |
|
| Stop tomcat |
systemctl stop tomcat |
| Copy files with WinSCP |
CMDBuild and conectors as described on the technical manual |
| Copy connector |
sudo cp postgresql-1.12.3.jar /usr/share/tomcat/lib |
| Copy connector |
sudo cp postgresql-42.2.5.jar /usr/share/tomcat/lib |
| Copy cmdbuild.war |
sudo mv cmdbuild-3.2.1.war /usr/share/tomcat/webapps/cmdbuild.war |
| create shark user |
sudo su postgres -c psql postgres |
|
postgres=# create user shark; |
| Create cmdbuild folder on tomcat |
sudo mkdir /usr/share/tomcat/conf/cmdbuild |
| Change owner |
sudo chown tomcat:tomcat /usr/share/tomcat/conf/cmdbuild |
| Change to tomcat directory |
cd /usr/share/tomcat/conf/cmdbuild/ |
| Change conf files ownership |
chown tomcat:tomcat * |
| Restart postgres Service |
sudo systemctl restart postgresql-10.service |
| Start tomcat service |
sudo systemctl start tomcat |
| Test cmdb page |
http://192.168.1.4:8080/cmdbuild-3.2.1 |
| Stop tomcat |
sudo systemctl stop tomcat |
| Rename cmdbuild directory |
sudo mv /usr/share/tomcat/conf/cmdbuild /usr/share/tomcat/conf/cmdbuildv2 |
| Start tomcat service |
sudo systemctl start tomcat |