How to Install PartKeepr on OpenSUSE Latest

PartKeepr is an open-source inventory management system designed to help individuals and companies keep track of their electronic components, tools, and other assets. In this tutorial, you will learn how to install PartKeepr on OpenSUSE Latest.

Prerequisites

Before you get started, you will need to make sure that the following prerequisites have been met:

You have access to an OpenSUSE Linux installation
You have root access or sudo privileges
You have a basic understanding of the Linux command line

Step 1: Install Required Dependencies

Open a terminal on your OpenSUSE system and run the following command to install the necessary dependencies:

sudo zypper install apache2 php7 php7-openssl php7-mysqlnd php7-pdo php7-mbstring php7-gd mariadb mariadb-client

Step 2: Install PartKeepr

Download the latest version of PartKeepr from https://www.partkeepr.org/download/ or run the following command to download it from the terminal:
```
wget https://github.com/partkeepr/PartKeepr/releases/download/1.7.0/partkeepr-1.7.0.zip
```
Once the download is complete, extract the downloaded file to the web server root directory using the following command.
```
sudo unzip partkeepr-1.7.0.zip -d /srv/www/htdocs/
```

Rename the extracted directory to partkeepr.

sudo mv /srv/www/htdocs/partkeepr-1.7.0/ /srv/www/htdocs/partkeepr/

Step 3: Configure Database

Start the mariadb service.
```
sudo systemctl start mariadb
```
Create a new database for PartKeepr.
```
mysql -u root -p
```
Enter the MySQL root password and press Enter to access the MySQL shell:
```
CREATE DATABASE partkeepr CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
```

Create a new database user and grant privileges to the user.

CREATE USER 'partkeepr'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON partkeepr.* TO 'partkeepr'@'localhost' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;

Import the database schema.

mysql -u partkeepr -p partkeepr < /srv/www/htdocs/partkeepr/etc/database/schema_mysql_5.7.sql

Step 4: Configure Apache

Create a new Apache configuration file for PartKeepr by executing the following command in the terminal.

```
sudo nano /etc/apache2/conf.d/partkeepr.conf
```

Add the following content to the file:

```
Alias /partkeepr /srv/www/htdocs/partkeepr/web
<Directory /srv/www/htdocs/partkeepr/web>
    Options FollowSymLinks
    AllowOverride all
    Require all granted
</Directory>
```

Save and close the file.

Step 5: Enable Required PHP Extensions

Run the following commands in the terminal to enable the php extensions required by PartKeepr:

sudo phpenmod pdo_mysql
sudo phpenmod mbstring
sudo phpenmod gd

Step 6: Restart Apache

After making all the changes to the Apache and PHP configurations, restart the Apache service by running the following command:

sudo systemctl restart apache2

Step 7: Access PartKeepr from Web Browser

Open a web browser and visit http://<Server_IP_Address>/partkeepr to access the PartKeepr installation page. Follow the instructions on the screen to complete the installation.

Congratulations! You have successfully installed PartKeepr on OpenSUSE Latest.