How to Install SheetAble on OpenSUSE Latest

SheetAble is an open-source web-based software that allows users to work with spreadsheets on their web browsers. In this tutorial, we will guide you through the process of installing SheetAble on the latest version of OpenSUSE.

Prerequisites

Before we proceed, make sure that you have the following:

OpenSUSE Latest installed on your system
A user account with sudo privileges
Access to the internet

Step 1: Install Apache, PHP and MariaDB

SheetAble uses Apache, PHP, and MariaDB to work correctly. To install these dependencies, issue the following commands:

sudo zypper refresh
sudo zypper install apache2 php7 php7-mysqlnd mariadb

Once the installation is complete, start and enable Apache and MariaDB at system boot.

sudo systemctl start apache2
sudo systemctl enable apache2

sudo systemctl start mariadb
sudo systemctl enable mariadb

Step 2: Create a Database for SheetAble

Next, we need to create a database for SheetAble. Log in to MariaDB as the root user:

sudo mysql -u root -p

Enter your MariaDB root password when prompted.

Create a new database and user for SheetAble:

CREATE DATABASE sheetable_db;
CREATE USER 'sheetable_user'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON sheetable_db.* TO 'sheetable_user'@'localhost';
FLUSH PRIVILEGES;
EXIT;

Replace password with a strong password for the user.

Step 3: Download SheetAble

Download the latest version of SheetAble from the official website. You can use the wget command:

sudo wget https://sheetable.net/files/latest.zip

Extract the downloaded file:

sudo unzip latest.zip -d /var/www/html/

Set the correct permissions for the SheetAble files:

sudo chown -R apache:apache /var/www/html/
sudo chmod -R 755 /var/www/html/

Step 4: Configure SheetAble

Copy the default configuration file and create a new one that we will modify:

sudo cp /var/www/html/sheetable/inc/config.default.php /var/www/html/sheetable/inc/config.php
sudo nano /var/www/html/sheetable/inc/config.php

Modify the following lines to match your MariaDB database and user:

...
define('DB_SERVER', 'localhost');
define('DB_USERNAME', 'sheetable_user');
define('DB_PASSWORD', 'password');
define('DB_NAME', 'sheetable_db');
...

Save and exit the file.

Step 5: Access SheetAble

Restart the Apache web server to make the changes take effect:

sudo systemctl restart apache2

You can now access SheetAble in your web browser by entering http://<your-server-ip>/sheetable/. Replace <your-server-ip> with the IP address of your OpenSUSE server.

Username: sheetable
Password: sheetable

Conclusion

That's it! You have successfully installed SheetAble on OpenSUSE Latest. You can now start creating and editing your spreadsheets directly from your web browser.