PartDB: Difference between revisions

From FlowerHouseWiki
 
(41 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{ContainerInfo
{{ContainerInfo
|image = Froeling.jpg
|Domain = [https://parts.flowerhouse.at parts.flowerhouse.at]
|Domain = [https://parts.flowerhouse.at parts.flowerhouse.at]
|IP = 192.168.88.??
|IP = 192.168.88.16
|MAC = ??
|MAC = 32:22:DA:F2:39:1B
|Privileged = No
|Privileged = No
|OS = Debian Buster
|OS = Debian Bullseye
|RAM = 512MB
|RAM = 512MB
|Cores = 1
|Cores = 1
}}
}}


<p>The PartDB-LXC is reachable under <syntaxhighlight lang="Bash" inline>192.168.88.??</syntaxhighlight> which is located in the ServerVLAN.</p>
<p>The PartDB-LXC is reachable under <syntaxhighlight lang="Bash" inline>192.168.88.16</syntaxhighlight> which is located in the ServerVLAN.</p>
<p>The subdomain is [https://parts.flowerhouse.at parts.flowerhouse.at] which is handled by the [[ReverseProxy]].</p>
<p>The subdomain is [https://parts.flowerhouse.at parts.flowerhouse.at] which is handled by the [[ReverseProxy]].</p>
__TOC__
__TOC__
== Basic Setup ==
== Installation ==
<p>Install the required packages:</p>
[https://docs.part-db.de/installation/installation%20guide-debian.html Installation Guide]
 
== Update ==
[https://docs.part-db.de/installation/installation_guide-debian.html#update-part-db Update Guide]
 
Move into Part-DB folder
<syntaxhighlight lang="console">
<syntaxhighlight lang="console">
apt install git zip apache2 php php-mysql php-curl libapache2-mod-php php-opcache php-gettext
cd /var/www/partdb
</syntaxhighlight>
</syntaxhighlight>


<p>Configure locales:</p>
Checkout master branch
<syntaxhighlight lang="console">
<syntaxhighlight lang="console">
dpkg-reconfigure locales
git checkout master
</syntaxhighlight>
</syntaxhighlight>


=== Configure Apache ===
Pull latest Part-DB version from GitHub
<p>Open the following file:</p>
<syntaxhighlight lang="console">
<syntaxhighlight lang="console">
nano /etc/apache2/apache2.conf
git pull
</syntaxhighlight>
</syntaxhighlight>


<p>And change this part:</p>
Checkout the latest version (or use a specific version, like described above)
<syntaxhighlight lang="console" line>
<syntaxhighlight lang="console">
<Directory /var/www/>
git checkout $(git describe --tags $(git rev-list --tags --max-count=1))
        Options Indexes FollowSymLinks
        AllowOverride None
        Require all granted
</Directory>
</syntaxhighlight>
</syntaxhighlight>


<p>to this:</p>
Apply correct permission
<syntaxhighlight lang="console" line>
<syntaxhighlight lang="console">
<Directory /var/www/>
chown -R www-data:www-data .
        Options -Indexes
        AllowOverride All
        Require all granted
</Directory>
</syntaxhighlight>
</syntaxhighlight>


<p>Restart the apache service:</p>
Install new composer dependencies
<syntaxhighlight lang="console">
<syntaxhighlight lang="console">
systemctl restart apache2
sudo -u www-data composer install --no-dev -o
</syntaxhighlight>
</syntaxhighlight>


=== Configure PHP ===
Install yarn dependencies and build new frontend
<p>Edit ''php.ini'':</p>
<syntaxhighlight lang="console" line>
sudo yarn install
sudo yarn build
</syntaxhighlight>
 
Apply new database schemas (you should do a backup of your database file /var/www/partdb/var/app.db before)
<syntaxhighlight lang="console">
<syntaxhighlight lang="console">
nano /etc/php/7.3/apache2/php.ini
sudo -u www-data php bin/console doctrine:migrations:migrate
</syntaxhighlight>
</syntaxhighlight>


<p>Change the following settings:</p>
Clear Part-DB cache
<syntaxhighlight lang="console">
<syntaxhighlight lang="console">
memory_limit = 128M
sudo -u www-data php bin/console cache:clear
upload_max_filesize = 100M
post_max_size = 100M
</syntaxhighlight>
</syntaxhighlight>


=== PartDB ===
<p>Download and unpack:</p>
<syntaxhighlight lang="console" line>
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
</syntaxhighlight>


<p>Change folder name to root directory:</p>
<syntaxhighlight lang="console">
<syntaxhighlight lang="console" line>
cd /var/www
rm -r html
mv Part-DB-master html
</syntaxhighlight>


<p>Generate composer files:</p>
<syntaxhighlight lang="console" line>
cd /var/www/html
php composer.phar install -o --no-dev
</syntaxhighlight>
</syntaxhighlight>


Latest revision as of 08:28, 24 August 2023


Network

IP: 192.168.88.16
MAC: 32:22:DA:F2:39:1B
Domain: parts.flowerhouse.at

System

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

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

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

Installation

Installation Guide

Update

Update Guide

Move into Part-DB folder 

cd /var/www/partdb

Checkout master branch 

git checkout master

Pull latest Part-DB version from GitHub 

git pull

Checkout the latest version (or use a specific version, like described above) 

git checkout $(git describe --tags $(git rev-list --tags --max-count=1))

Apply correct permission 

chown -R www-data:www-data .

Install new composer dependencies 

sudo -u www-data composer install --no-dev -o

Install yarn dependencies and build new frontend 

sudo yarn install
sudo yarn build

Apply new database schemas (you should do a backup of your database file /var/www/partdb/var/app.db before) 

sudo -u www-data php bin/console doctrine:migrations:migrate

Clear Part-DB cache 

sudo -u www-data php bin/console cache:clear


Sources

Retrieved from "https://wiki.flowerhouse.at/index.php?title=PartDB&oldid=1025"