Search
Items tagged with: Linux
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:
/hostingfolder
Enter passphrase for key 'privkey.pem':
Welcome to Ubuntu ..
..
rootname@ubuntu:~#
The response by the server is:
-bash: backupname.sql: No such file or directory
I also tried:
rootname@ubuntu:~#
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:
and
but that didn't do the trick either.
Any ideas?
#fediHelp #mysql #mariadb #ssh #linux
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.000Enter passphrase for key 'privkey.pem':
Welcome to Ubuntu ..
..
rootname@ubuntu:~#
mysql -u friendica@localhost -ppassword friendicadb < backupname.sqlThe response by the server is:
-bash: backupname.sql: No such file or directory
I also tried:
rootname@ubuntu:~#
mysql -u friendica -ppassword friendicadb < backupname.sqlwith 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
There are two ways to add your keys to #FileZilla.
You can add your keys inside the "Site Manager":
Go to:
File -> Site manager ..
Protocol:
In the settings panel for a given site select sFTP:
Add domain IP or domain name:
Logon Type:
Select "Key File"
Add the user name to log onto the server:
Browse for the .ppk you want to add and select it:
FileZilla offers you also to add .pem (privkey.pem) files, that's the #puTTy option for a file containing only the extracted private key of keyfile.ppk. At the same time FileZilla doesn't read/accept .pem files so it will prompt you to transform it into a .ppk file. If your .ppk is protected by a password (it should be), you get prompted to insert the password.
It is not clear if the newly created .ppk file from the .pem file by FileZilla is protected with the same password. It doesn't feel like that.
Save the changes and connect to your server.
The other option to add your key to FileZilla is by adding it directly to the main settings.
Go to:
Edit-> Settings ..
Choose SFTP and select the "Add key file" tab:
Add the key file and save.
If you use the input fields and quick connect options of the main FileZilla window, the keys saved in settings will be retrieved.
#linux #windows #howTo #fediVerse
You can add your keys inside the "Site Manager":
Go to:
File -> Site manager ..
Protocol:
In the settings panel for a given site select sFTP:
Add domain IP or domain name:
Logon Type:
Select "Key File"
Add the user name to log onto the server:
Browse for the .ppk you want to add and select it:
FileZilla offers you also to add .pem (privkey.pem) files, that's the #puTTy option for a file containing only the extracted private key of keyfile.ppk. At the same time FileZilla doesn't read/accept .pem files so it will prompt you to transform it into a .ppk file. If your .ppk is protected by a password (it should be), you get prompted to insert the password.
It is not clear if the newly created .ppk file from the .pem file by FileZilla is protected with the same password. It doesn't feel like that.
Save the changes and connect to your server.
The other option to add your key to FileZilla is by adding it directly to the main settings.
Go to:
Edit-> Settings ..
Choose SFTP and select the "Add key file" tab:
Add the key file and save.
If you use the input fields and quick connect options of the main FileZilla window, the keys saved in settings will be retrieved.
#linux #windows #howTo #fediVerse
friendica VPS setup on ubuntu 22.04 LTS
@Friendica Support
Hi,
I'm working on my first #friendica #VPS installation, here you'll find my initial post about general thoughts like what distro to use, size and costs.
I'm using the tutorial "creating a friendica server - ubuntu" by @Hank G ☑️.
As of now I'm doing well in the process and want to start this post to document differences and questions while installing the server.
This server is going to host an already existing friendica node I have to move from another hosting provider. That means that for example the DB doesn't have to be created from scratch but moved and other smaller details.
I will try to address the different steps of installation in answers to this post and appreciate help, ideas and observations.
I'm doing this from a #linux desktop environment from the console but there shouldn't be differences if you want to do this from a #windows machine.
#fediVerse #tutorial #fediHelp #activityPub
Hi,
I'm working on my first #friendica #VPS installation, here you'll find my initial post about general thoughts like what distro to use, size and costs.
I'm using the tutorial "creating a friendica server - ubuntu" by @Hank G ☑️.
As of now I'm doing well in the process and want to start this post to document differences and questions while installing the server.
This server is going to host an already existing friendica node I have to move from another hosting provider. That means that for example the DB doesn't have to be created from scratch but moved and other smaller details.
I will try to address the different steps of installation in answers to this post and appreciate help, ideas and observations.
I'm doing this from a #linux desktop environment from the console but there shouldn't be differences if you want to do this from a #windows machine.
#fediVerse #tutorial #fediHelp #activityPub
what VPS offer fits best for a small friendica instance?
@Friendica Support
@Friendica Admins
@Friendica Developers
Hi there,
in the end I want to try to setup my first own hosted friendica VPS on a small setup:
1gig RAM/1 Core/25gig
The idea is kinda single user instance with a few forum pages.
The hosting provider has the following options:
- debian bullsey - vpn server
- debian bookworm - wireguard server
- debian bookworm - bookworm 2023-07-03
- debian bookworm - bookworm 2023-07-03 LEMP (nginx+php8.2+mariaDB10.5)
- debian bookworm - nextcloud
- ubuntu 22.04.01LTS
- CENTOS8.1 - 2020-05-03
- cleanVPS to upload own ISO
I'm used to debian/devuan on PC, so am obviously inclined to go for debian but have no idea what version would be the best choice.
In the first place the debian LEMP option looks like the way to go.
Latest experience with a new friendica installation seemed to be in need of PHP8.1 instead of PHP8.2.
Is it difficult to downgrade that?
Also, I'm kinda worried about security in general, even tho the data exposed will only be my own, so there is no responsibility with others.
Are there more security risks than on a shared hosting with let's say a standard phpBB forum page?
The idea would be to point the IP from my existing hosting provider to the VPS.
- Do we have some general "how to setup" for a VPS setting from scratch?
- Anyone interested in creating such a "how to" in a conversation with me here to have a refence or base to sum that up for the frindica wiki?
- Could it even be of interest to create a "friendica VPS-ISO installation" with the help of git.friendi.ca for example?
@TupambAdmin
@bitPickup mʕ•ﻌ•ʔm