8 C
Texas

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

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

- Advertisement -

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 [email protected]
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

- Advertisement -
Everything Linux, A.I, IT News, DataOps, Open Source and more delivered right to you.
Subscribe
"The best Linux newsletter on the web"

LEAVE A REPLY

Please enter your comment!
Please enter your name here



Latest article