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.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
There are two ways to add your keys to #FileZilla.
You can add your keys inside the "Site Manager":
Go to:
File -> Site manager ..
![Screen of FileZilla showing where to find the option Screen of FileZilla showing where to find the option](https://washington.communitynetwork.us/photo/media/1471)
Protocol:
In the settings panel for a given site select sFTP:
![Screen of FileZilla showing where to find the option Screen of FileZilla showing where to find the option](https://washington.communitynetwork.us/photo/media/1473)
Add domain IP or domain name:
![Screen of FileZilla showing where to find the option Screen of FileZilla showing where to find the option](https://washington.communitynetwork.us/photo/media/1475)
Logon Type:
Select "Key File"
![Screen of FileZilla showing where to find the option Screen of FileZilla showing where to find the option](https://washington.communitynetwork.us/photo/media/1477)
Add the user name to log onto the server:
![Screen of FileZilla showing where to find the option Screen of FileZilla showing where to find the option](https://washington.communitynetwork.us/photo/media/1479)
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.
![Screen of fileZilla showing where to find the option Screen of fileZilla showing where to find the option](https://washington.communitynetwork.us/photo/media/1483)
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 ..
![Screen of FileZilla showing where to find the option Screen of FileZilla showing where to find the option](https://washington.communitynetwork.us/photo/media/1485)
Choose SFTP and select the "Add key file" tab:
![Screen of FileZilla showing where to find the option Screen of FileZilla showing where to find the option](https://washington.communitynetwork.us/photo/media/1487)
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