v.02
@Tutorial
@Friendica Developers and @Friendica Admins.

#howTo change a single #friendica domain #debian #ubuntu 2022.04lts VPS #hosting setup into a single IP multi domain VPS server.

This tutorial builds on the install and/or move friendica to ubuntu 22.04 LTS VPS server howTo with the intention to change the main setup into a domain name-based virtual hosting.

The folder name in the VPS folder structure in /var/www/for the domains can be choosen as you like, for example:

• /var/www/domaincom/
  All apache tutorials found in a quick search do choose the domain or subdomain name including the respective dot's like this:
• /var/www/domain.com/

Both options are possible for a correct working environment.
@Ⓜ3️⃣3️⃣ 🌌 pointed out that for automatization scripts it's usefull to keep that consistent and there for to use FQDN (Fully Qualified Domain Name) as part of the path.
Never the less, to keep the concepts of domain URL's and folder names seperate and to prevent the notion that the domain name syntax is mandatory we will stick with simple folder names in this #tutorial.

The naming of the .conf files in /etc/apache2/sites-available/ refer to the actual domain names and their settings. Even tho these .conf file names also could be chosen probably at will, as the definitions about the actual domains refereed are given inside those files, we'll stick to the real sub/domain names in this case as it's quite reasonable and logical to do so.

We will address the details for a step by step change from a single VPS single IP domain hosting to a multiple name-based single IP virtual hosting in answers to this topic:

• Inicial VPS domain hosting served at:
  /var/www/html/
• Name-based virtual hosting domain VPS where several domains are served by one IP, leaving /html in place if a client request doesn’t match any other sites, like proposed in this digitalOcean tutorial:
  /var/www/html/ as fall back option
  /var/www/domaincom/index.html
/var/www/subdomaincom/index.html
/var/www/domainorg/ original friendica installation
  /var/www/subdomainorg/index.html

Any comments hints and observations are really appreciated!
#admin #fediAdmin

EDITion | EN

2025-02-25 23:16:52

v.0x Creating several friendica instances as sub/domains on one VPS with one IP

backup thread for previous versions of this howTo

Fehler 1050 beim Update der Datenbank aufgetreten Table './k145584_dfriendica/notify@002dthreads' already exists Fehler 1050 beim Update der Datenbank aufgetreten Table './k145584_dfriendica/post@002dcategory' already exists
Das Update 1384 der Struktur der Datenbank schlug mit folgender Fehlermeldung fehl: Fehler beim Ändern der Datenbank aufgetretenALTER TABLE `notify-threads` MODIFY `master-parent-item` int unsigned COMMENT '', ADD INDEX `master-parent-item` (`master-parent-item`), ADD FOREIGN KEY (`master-parent-item`) REFERENCES `item` (`id`) ON UPDATE RESTRICT ON DELETE CASCADE, ADD FOREIGN KEY (`master-parent-uri-id`) REFERENCES `item-uri` (`id`) ON UPDATE RESTRICT ON DELETE CASCADE;
Fehler beim Ändern der Datenbank aufgetretenALTER TABLE `post-category` ADD INDEX `uid` (`uid`), ADD FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON UPDATE RESTRICT ON DELETE CASCADE;

Das Update der Datenbank ist fehlgeschlagen. Bitte führe 'php bin/console.php dbstructure update' in der Kommandozeile aus und achte auf eventuell auftretende Fehlermeldungen.
Das letzte Update ist fehlgeschlagen. Bitte führe "php bin/console.php dbstructure update" auf der Kommandozeile aus und werfe einen Blick auf eventuell auftretende Fehler. (Zusätzliche Informationen zu Fehlern könnten in den Logdateien stehen.)

php bin/console.php dbstructure update

[Error] Missing database structure config file static/dbstructure.config.php