1.8 C
Amsterdam
Saturday, December 5, 2020

How To Install i-doit Asset Management Tool on Ubuntu 18.04

Must read

How To Install Docker Swarm On Ubuntu 20.04

In this tutorial, you'll learn that how to Install Docker Swarm on Ubuntu 20.04. Docker Swarm is most popular tool that can be used...

How To Install Keeweb Password Manager On Ubuntu 20.04

Today we are going to learn that how to install KeeWeb Passwrod Manager On Ubuntu 20.04. KeeWeb Password Manager provides the best and easy...

How to change the MAC address in Windows 10

Hello! How are you? Today we will see how to change the MAC address on a computer with Windows 10. In fact, it is...

How To Configure Slave BIND DNS Server On Ubuntu 20.04

In our previous guide we covered the setup of Master(Primary) DNS Server. Here we'll learn that how to configure slave bind dns server on...

What is I-doit?

Today we are going to Install i-doit tool on our Ubuntu 18.04. It has various features due to which we prefer it in our IT system. i-doit is Professional IT documentaion & CMDB tool that provides the way to manage the entire IT system.

With the help of this great tool you can easily create a detailed overview of the entire IT-infrastructure for all kind of assets.

System Requirements

  • 2 vCPUs
  • 2 GB RAM
  • 10 GB free disc space

As we will Install it on our dedicated Virtual Machine, LAMP Stack is required.

  • Apache Web Server 2.4
  • MariaDB 10.x or MySQL 5.6 or later
  • PHP 5.6(deprecated), 7.x
  • PHP extensions: bcmath, ctype, curl, fileinfo, gd, imagick, json, ldap, mbstring, memcached, mysqli, mysqlnd, pgsql, session, soap, xml, zip

Now, move toward the Installation of i-doit on our Ubuntu system

Step 1: Install Apache & PHP

Run the following command to Install Apache & required PHP extensions.

sudo apt -y install apache2 libapache2-mod-php
sudo apt -y install php-{bcmath,cli,common,curl,gd,json,ldap,mbstring,mysql,opcache,pgsql,soap,xml,zip,imagick,memcached}
sudo apt -y install memcached unzip moreutils

Create new php configuration file for i-doit

sudo tee /etc/php/7.2/mods-available/i-doit.ini<<EOF
allow_url_fopen = Yes
file_uploads = On
magic_quotes_gpc = Off
max_execution_time = 300
max_file_uploads = 42
max_input_time = 60
max_input_vars = 10000
memory_limit = 256M
post_max_size = 128M
register_argc_argv = On
register_globals = Off
short_open_tag = On
upload_max_filesize = 128M
display_errors = Off
display_startup_errors = Off
error_reporting = E_ALL & ~E_DEPRECATED & ~E_STRICT
log_errors = On
default_charset = "UTF-8"
default_socket_timeout = 60
date.timezone = Africa/Nairobi
session.gc_maxlifetime = 604800
session.cookie_lifetime = 0
mysqli.default_socket = /var/run/mysqld/mysqld.sock
EOF

session.gc_maxlifetime should be the same or greater than the Session Timeout in the System settings of i-doit.

Then activate the required PHP modules & restart Apache web server.

sudo phpenmod i-doit
sudo phpenmod memcached
sudo systemctl restart apache2.service

Step 2: Install MariaDB Server

Install MariaDB on your Ubuntu 18.04

After Installing MariaDB & configuring it login to it, & run the given command.

SET GLOBAL innodb_fast_shutdown = 0;
UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE User = 'root';
FLUSH PRIVILEGES;

Tune your server for Optimal Perfromance

sudo nano /etc/mysql/mariadb.conf.d/99-i-doit.cnf

Then add the below content:

[mysqld]
This is the number 1 setting to look at for any performance optimization
It is where the data and indexes are cached: having it as large as possible will
ensure MySQL uses memory and not disks for most read operations.
#
Typical values are 1G (1-2GB RAM), 5-6G (8GB RAM), 20-25G (32GB RAM), 100-120G (128GB RAM).
innodb_buffer_pool_size = 1G
Use multiple instances if you have innodb_buffer_pool_size > 10G, 1 every 4GB
innodb_buffer_pool_instances = 1
Redo log file size, the higher the better.
MySQL/MariaDB writes two of these log files in a default installation.
innodb_log_file_size = 512M
innodb_sort_buffer_size = 64M
sort_buffer_size = 262144 # default
join_buffer_size = 262144 # default
max_allowed_packet = 128M
max_heap_table_size = 32M
query_cache_min_res_unit = 4096
query_cache_type = 1
query_cache_limit = 5M
query_cache_size = 80M
tmp_table_size = 32M
max_connections = 200
innodb_file_per_table = 1
Disable this (= 0) if you have only one to two CPU cores, change it to 4 for a quad core.
innodb_thread_concurrency = 0
Disable this (= 0) if you have slow harddisks
innodb_flush_log_at_trx_commit = 1
innodb_flush_method = O_DIRECT
innodb_lru_scan_depth = 2048
table_definition_cache = 1024
table_open_cache = 2048
Only if your have MySQL 5.6 or higher, do not use with MariaDB!
table_open_cache_instances = 4
innodb_stats_on_metadata = 0
sql-mode = ""

When finished, restart mariadb

sudo systemctl restart mysql

Step 3: Download i-doit

Download & extract the open source version of i-doit

export LATEST="1.13.2"
wget https://sourceforge.net/projects/i-doit/files/i-doit/$LATEST/idoit-open-$LATEST.zip
sudo unzip idoit-open-$LATEST.zip -d /var/www/html/i-doit

Set permissions for the created directory to apache user

cd /var/www/html/i-doit
sudo chown www-data:www-data -R .
sudo find . -type d -name * -exec chmod 775 {} \;
sudo find . -type f -exec chmod 664 {} \;
sudo chmod 774 controller .sh setup/.sh

Then create Apache configuration file for i-doit.

sudo tee /etc/apache2/sites-available/i-doit.conf<
ServerAdmin admin@example.com
DirectoryIndex index.php DocumentRoot /var/www/html/ <Directory /var/www/html/> AllowOverride All Require all granted </Directory> LogLevel warn ErrorLog ${APACHE_LOG_DIR}/error.log CustomLog ${APACHE_LOG_DIR}/access.log combined

EOF

Enable site & rewrite module.

sudo chown www-data:www-data -R /var/www/html/
sudo chmod 755 /var/log/apache2
sudo chmod 664 /var/log/apache2/*
sudo a2ensite i-doit
sudo a2enmod rewrite
sudo systemctl restart apache2.service

Step 4: Run i-doit Setup

Launch the i-doit by opening http://idoit.example.com/i-doit/.

All system checks should show a pass.

Do the all steps as shown in screenshots below

  • Connection Settings
  • Host: localhost or 127.0.0.1
  • Port: default port of MySQL/MariaDB, so 3306
  • Username: User name of the database system user, usually root
  • Password: Password of the user
  • MySQL user settings
  • Username: User name of the i-doit databases owner, usually idoit
  • Password: Pass of the user
  • Database settings
  • System Database Name: Name of the system DB, usually idoit_system
  • Mandator Database Name: Name of the database for the first tenant, usually idoit_data
  • Mandator title: name of the organization that is focused on
  • Start value for object/configuration item IDs: Normally 1

Then finalize the configuration check & move to next step

After it login to the i-doit by providing your credentials.

You now have Installed i-doit on Ubuntu system.

Further Steps

More articles

LEAVE A REPLY

Please enter your comment!
Please enter your name here

-

Latest article

How To Install Docker Swarm On Ubuntu 20.04

In this tutorial, you'll learn that how to Install Docker Swarm on Ubuntu 20.04. Docker Swarm is most popular tool that can be used...

How To Install Keeweb Password Manager On Ubuntu 20.04

Today we are going to learn that how to install KeeWeb Passwrod Manager On Ubuntu 20.04. KeeWeb Password Manager provides the best and easy...

How to change the MAC address in Windows 10

Hello! How are you? Today we will see how to change the MAC address on a computer with Windows 10. In fact, it is...

How To Configure Slave BIND DNS Server On Ubuntu 20.04

In our previous guide we covered the setup of Master(Primary) DNS Server. Here we'll learn that how to configure slave bind dns server on...

Install Fossil on Linux – An alternative to Git

Hello, friends. In this post, we will talk about a serious alternative to Git. In a few words, we'll show you how to install...
x