PartDB

Network

---

IP:	192.168.88.??
MAC:	??
Domain:	parts.flowerhouse.at

System

---

OS:	Debian Bullseye
RAM:	512MB
Cores:	1
Privileged:	No

The PartDB-LXC is reachable under 192.168.88.?? which is located in the ServerVLAN.

The subdomain is parts.flowerhouse.at which is handled by the ReverseProxy.

Old version

Install the required packages:

apt install git zip apache2 php php-mysql php-curl libapache2-mod-php php-opcache php-gettext

Configure locales:

dpkg-reconfigure locales

Configure Apache

Open the following file:

nano /etc/apache2/apache2.conf

And change this part:

<Directory /var/www/>
        Options Indexes FollowSymLinks
        AllowOverride None
        Require all granted
</Directory>

to this:

<Directory /var/www/>
        Options -Indexes
        AllowOverride All
        Require all granted
</Directory>

Restart the apache service:

systemctl restart apache2

Configure PHP

Edit php.ini:

nano /etc/php/7.3/apache2/php.ini

Change the following settings:

memory_limit = 128M
upload_max_filesize = 100M
post_max_size = 100M

PartDB

Download and unpack:

wget -O part-db.tar.gz https://github.com/jbtronics/Part-DB/archive/master.tar.gz
tar -xzf part-db.tar.gz -C /var/www
rm part-db.tar.gz

Change folder name to root directory:

cd /var/www
rm -r html
mv Part-DB-master html

Set ownership:

chown -R www-data:www-data html

Generate composer files:

cd /var/www/html
php composer.phar install -o --no-dev

e]smoFA14yF1!.6A

New version

Install the required packages:

apt install git wget curl gnupg composer apache2 php php-mysql php-gd php-intl php-simplexml php-dom php-zip php-xsl php-bcmath php-curl

Install Symfony:

wget https://get.symfony.com/cli/installer -O - | bash

Install it globally:

mv /root/.symfony/bin/symfony /usr/local/bin/symfony

Install Node.js:

curl -fsSL https://deb.nodesource.com/setup_16.x | bash -
apt install -y nodejs

Install Yarn:

curl -sS https://dl.yarnpkg.com/debian/pubkey.gpg | apt-key add -
echo "deb https://dl.yarnpkg.com/debian/ stable main" | tee /etc/apt/sources.list.d/yarn.list
apt update
apt install yarn

Configure locales (languages you want to support):

dpkg-reconfigure locales

Clone PartDB repository:

cd /var/www
rm -r html
git clone https://github.com/Part-DB/Part-DB-symfony
mv ./Part-DB-symfony/* ./
rm -r Part-DB-symfony

Set permissions:

chown -R www-data:www-data /var/www
chmod -R 775 /var/www

Configure Apache

Change webroot:

nano /etc/apache2/sites-available/000-default.conf

Change:

/var/www/html -> /var/www/public

Open the following file:

nano /etc/apache2/apache2.conf

And change this part:

<Directory /var/www/>
        Options Indexes FollowSymLinks
        AllowOverride None
        Require all granted
</Directory>

to this:

<Directory /var/www/>
        Options -Indexes
        AllowOverride All
        Require all granted
</Directory>

Restart the apache service:

systemctl restart apache2

PartDB

Create file and paste this:

nano .env

Copy file:

cp .env .env.local

Add database to ".env.local":

DATABASE_URL=mysql://mysql_user_name:your_password@www.theHost.domainName:3306/your_database
DATABASE_URL=mysql://partdb:e]smoFA14yF1!.6A@192.168.88.13:3306/parts

Install composer dependencies and generate autoload files:

composer install --no-dev
npm install
composer recipes

Install client side dependencies and build it:

yarn upgrade
yarn add ts-loader@8.0.1 --exact
yarn install
yarn build

Warmup cache:

php bin/console cache:warmup

Sources

• Requirements
• Install PartDB