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 [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
