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.

If you want to self-host in an easy, hands free way, need an external IP address, or simply want your data in your own hands, give IPv6.rs a try!

Alternatively, for the best virtual desktop, try Shells!