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.
Before we proceed, make sure that you have the following:
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
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.
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/
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.
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.
Log in using the default credentials:
Username: sheetable
Password: sheetable
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.
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!
