How to Install NocoDB on Fedora Server

In this tutorial, we will walk you through the process of installing NocoDB on a Fedora Server machine. NocoDB is an open-source Airtable alternative, a cloud-based database platform.

Prerequisites

Before we begin, make sure you have the following:

• A Fedora Server machine
• A non-root user account with sudo privileges
• Access to the internet

Step 1: Update Your System

We'll start by updating the packages and repositories of our system:

sudo dnf update

Step 2: Install the Required Dependencies

NocoDB requires two dependencies: Node.js and MariaDB. We'll install them using the following command:

sudo dnf install nodejs mariadb-server

After installing MariaDB, you should start and enable it using:

sudo systemctl start mariadb
sudo systemctl enable mariadb

Step 3: Create a MariaDB Database

Now that we have installed MariaDB, we need to create a new database for NocoDB. Open the MariaDB prompt using the following command:

sudo mariadb -u root

Once you're in the MariaDB prompt, execute the following commands to create a new database and a new user with appropriate permissions:

CREATE DATABASE nocodb;
GRANT ALL PRIVILEGES ON nocodb.* TO 'nocodb_user'@'localhost' IDENTIFIED BY 'a_strong_password';
FLUSH PRIVILEGES;
exit

Step 4: Install NocoDB

We are now ready to install NocoDB using npm (Node.js Package Manager). Run the following command:

sudo npm install -g nocodb

Once NocoDB is installed, you should see a success message.

Step 5: Configure NocoDB

To configure NocoDB, we need to create a new configuration file config.yaml. Navigate to the home directory of your non-root user and create a new file as follows:

cd ~
nano config.yaml

Use the following sample configuration and modify it with your own database information:

dbClient: mysql
dbconnection:
  host: localhost
  user: nocodb_user
  password: a_strong_password
  database: nocodb
server:
  port: 8080

Once you have finished editing the configuration file, save and exit the editor.

Step 6: Start NocoDB

Now that our system is set up, we need to start NocoDB. Use the following command to start it:

sudo nocodb

If everything is configured correctly, you should see a message saying that the server is running on port 8080.

Step 7: Access NocoDB

To access NocoDB, open your web browser and go to your machine's IP address with port 8080, for example:

http://your_server_ip:8080

You will be prompted to create an admin account to access NocoDB's web interface.

Congratulations! You have successfully installed and configured NocoDB on your Fedora Server machine.