EDIT - information

This tutorial is supposed to be published by the tutorial profile of this server.
It is designed to have several chapters, each being distinctively seperated by an own titel. In total as of now there are like besides this introduction like 6 chapters.
posting and edition time of and by this EDIT profileof ver05 as of now 1hs
mastodon review contact: @mʕ•ﻌ•ʔm bitPickup

--
Categories:

---

@helpers@forum.friendi.ca

SPOILER - click to open/close || Introduction

This tutorial is an adaption of the tutorial "creating a friendica server - ubuntu" by @Hank G ☑️ based on the experience of the installation report by @…ᘛ⁐̤ᕐᐷ jesuisatire bitPickup:
https://squeet.me/display/962c3e10-5765-2e86-4a15-589579746174
and specific help by @Raroun.

Server specs and friendica version used:
VPS server | Ubuntu 22.04 LTS
PHP Version 8.1.2-1ubuntu2.14
4 Core CPU, 8 GB Ram with 300GB NVME Disk
Friendica [STABLE] | 'Giant Rhubarb' 2023.05 - 1518

SPOILER - click to open/close || Installation environment and HowTo

The only reasonable way to work with a VPSserver on the web is using the console.
If you are not familiar with that don't worry, it is easy and the only thing you have to do is being able to copy/paste the commands displayed:
¡Copy/paste only the codeBoxes like this one, located outside of the spoilers of this tutorial one after another without altering the sequence!
Of course it is necessary to change the specific file names and passwords for you indiviual site, but that's all. promise!
On the console you wont be able to copy/paste with the keyboard ctrl-C/ctrl-V technique, you'll have to use the mouse "right click, chose option" technique.
This tutorial was created on a #debian #linux desktop environment.
There shouldn't be differences if you want to do this from a #windows machine.
The method used for communication between your local computer and the VPS server is called #SSH:
Wikipedia - Secure Shell:
"Cryptographic network protocol for secure data communication, remote shell services or command execution and other secure network services between two networked computers."

#linux #debian #ubuntu #friendica #fediVerse #fediTutorial #tutorial #fediHelp #fediTips #activityPub #HowTo #DIY #VPS #server #selfHosting
@admin@tupambae.org @tutorial@tupambae.org

Ihr habt vielleicht gemerkt, dass ich seit gestern um die Mittagszeit nicht aktiv war.

Grund ist, dass ich mir einen neuen #vServer #VPS hochgezogen und meine #Friendica #Instanz dorthin migriert habe.

Neben dem Aufwand, den man mit der kompletten #Neuinstallation und #Einrichtung eines Servers from Scratch hat (#SSH mit #Zertifikat, #PHP, #MySQL, #Apache, #LetsEncrypt / #Certbot, #Fail2Ban, #Firewall / #UFW, ...) , kam dann das Backupen von Friendica samt #Datenbank und das Neueinrichten auf dem neuen Server hinzu.

Dabei diverse kleinere Unwegsamkeiten wie dass sich das Datenverzeichnis geändert hat (anderer Apache-Hauptordner) und damit eine weiße Seite beim Aufrufen der Administration --> Speicher kam.
(BTW: Das habe ich durch einen temporären symbolischen Link gelöst).

Und schwups, ist ein guter halber Tag weg 🙈

Übrigens waren nach dem Umzug auf den neuen Server wieder diverse Emoticons aus Profilnamen weg (also lauter ?????).
Durch "Kontaktdaten neu laden" wurden und werden sie wieder korrekt dargestellt.
Dieses Problem verstehe ich noch immer nicht 🤔🤷‍♂️

Was bei den nun ersten Nutzungstests deutlicih besser respektive bislang verschwunden ist, ist das Problem fehlender Profilbilder oder ganzer Fehldarstellung der Seite beim Laden.

Hier war wahrscheinlich mein Webspace, auf dem Friendica bis gestern lief, doch einfach nicht leistungsfähig genug: 1024 MB RAM und 16 Kunden pro CPU-Kern für Mail, 2x #Joomla,1x große #Nextcloud und dann noch Friendica.

Der vServer hat nun 8 Kerne und 12 GB RAM und dümpelt (mit bislang nur Friendica darauf installiert) bei einer Load von < 1.

@Friendica Support

The creation of th DB apparently worked as expected.

The problem I now ran into is that I can't upload the backup sql DB I donwloaded from the old hosting.

I did this using the hints of the following stackoverflow description:
importing-a-database-using-ssh
but somehow this doesn't work.

I created a folder in my home directory for to log into the VPS via ssh where I placed the privkey.pem and the backupname.sql

This is the command sequence I execute:
cd hostingfolder
/hostingfolder ssh -i privkey.pem rootname@00.000.00.000
Enter passphrase for key 'privkey.pem':
Welcome to Ubuntu ..
..
rootname@ubuntu:~# mysql -u friendica@localhost -ppassword friendicadb < backupname.sql

The response by the server is:
-bash: backupname.sql: No such file or directory

I also tried:
rootname@ubuntu:~# mysql -u friendica -ppassword friendicadb < backupname.sql
with the same result

Of course the file backupname.sql does exist and is located in /hostingfolder
I also copied it to the folder /home/username/ just to make sure.

I searched for the error message and found:
stackoverflow | remote mysql import no such file or directory

so I tried:
mysql -u 'friendica'@'localhost' -ppassword friendicadb < '/home/username/hostingfolder/backupname.sql'
and
mysql -u 'friendica'@'localhost' -ppassword friendicadb < "/home/username/backupname.sql"
but that didn't do the trick either.

Any ideas?

#fediHelp #mysql #mariadb #ssh #linux