How to install the Shinobi database manually

A simple setup guide for people who missed the database setup or want to redo it.

By : Moe Alam

Date Added : Fri Feb 22 2019 09:05:00 GMT+0000 (Coordinated Universal Time)
Last Updated : Tue Mar 14 2023 19:19:36 GMT+0000 (Coordinated Universal Time)

For this article we will assume your Shinobi directory is found in the default location /home/Shinobi.

Installing the database for MariaDB/MySQL

1. Navigate to your Shinobi directory 

cd /home/Shinobi

2. Open the MariaDB/MySQL Terminal client. 

mysql

3. Load the SQL files. user.sql are the credentials for Shinobi to connect to the database. 

source sql/user.sql;

4. Exit the SQL client 

exit;

4. If you need to enable the mysql database type you can run the following. 

node tools/modifyConfiguration.js databaseType=mysql

5. Restart Shinobi. You should see a fresh log stream displaying Table creation notices. 

pm2 flush && pm2 restart all && pm2 logs

Looking for framework.sql?

This file is no longer in the respository. It is all now handled during Shinobi startup. As long as the connection credentials are good and a blank database exists; the tables will be created on Shinobi start.