30
votes
Remotely access postgresql database
This does not work anymore, if it ever did :
host all all * md5
The correct possible lines for this are :
host all all 0.0.0.0/0 md5 #ipv4 range
host all all ::0/0 md5 #ipv6 range
host all all all ...
15
votes
How do I delete ALL SSH known hosts?
First of all you should remember to verify ssh key finger prints when connecting to a remote computer for the first time, to avoid MITM attacks.
Having said that, first making a backup, and then ...
13
votes
Can't connect with VPS running Ubuntu server 16 with x2go
In your /home/user/.profile add the following line :
tty -s && mesg n
... and remove any other "mesg" line which is the root cause of the problem
13
votes
Can't set locales Ubuntu 16.04
Those steps work well.
apt-get update
apt-get install -y locales
locale-gen "en_US.UTF-8"
update-locale LC_ALL="en_US.UTF-8"
Log out and log in.
export LC_ALL=en_US.UTF-8
9
votes
Accepted
netplan gateway6 seems to have no effect
Subnets are (almost) always a /64. You configured your interface as a /128, which is only a single address. That means the gateway is on a different subnet and can't be reached.
What you probably ...
6
votes
Accepted
how to disable password and root ssh?
How to disable password and root ssh?
Let's rephrase it, and I expect you want
Deny all root login
Deny all password logins for all users
Allow other users with other authentication methods (...
4
votes
How do I add an SSH key to a google compute cloud VPS instance?
Probably a too late answer, but here it is
ssh-keygen -t rsa -f ~/.ssh/google_compute_engine -C <service-account>
Then
gcloud compute ssh <service-account> --command="bash xxxxxx"
4
votes
Accepted
Invisible processes using all of system memory
You have only 500 MB of RAM installed. I would not be surprised that most of it is in use, given those little resources.
On the other hand, htop sums up both the really used memory (allocated by ...
4
votes
Error | Failed to generate a seed from SecureRandom within 3 seconds. Not enough entrophy?
Installing rng-tools appears to have fixed the issue.
4
votes
Remotely access postgresql database
The highest-voted and accepted answer has serious security-impolications. This method is disabled by default for good reasons.
Better use local port forwarding with ssh:
ssh -L local_port:localhost:...
4
votes
Accepted
access to ... denied problem
[Sat Dec 15 17:05:08.000730 2018] [core:error] [pid 10465:tid 139960015378176] (13)Permission denied: [client 81.198.48.253:58347] AH00035: access to /favicon.ico denied (filesystem path '/home/chroot/...
4
votes
Accepted
Is the "linux-firmware" package actually required on a XEN VPS?
Followup much later...
I eventually purged all packages containing "firmware", "microcode", or "modules" in the name with no negative consequences and no known boot ...
3
votes
Accepted
Can't store passphrase in same session with eval $(ssh-agent) && ssh-add
Every time you do eval $(ssh-agent) && ssh-add, a new agent starts, so you need to re-authenticate yourself to it.
I think the best way is to store the SSH agent data permanently per session (...
3
votes
Remotely access postgresql database
Following configuration, you need to set:
In /etc/postgresql/10/main/postgresql.conf
# Connection Settings -
listen_addresses = '*' # what IP address(es) to listen on;
In /etc/postgresql/...
3
votes
Accepted
How to configure GRUB loader during apt-get upgrade on Ubuntu 12.04
From OP's comment, we came to know that, he solved the problem by installing GRUB on both /dev/sda and /dev/sdb. The comment reads as
FYI, I got it to work, installed GRUB on both /dev/sda and /dev/...
Community wiki
3
votes
Can't set locales Ubuntu 16.04
First, verify if your locate is installed, list the current locates:
locale -a
Then if your locate isn't installed, install it using this command:
sudo dpkg-reconfigure locales
Then set your ...
3
votes
Accepted
The 'proper' way to get ONLY my eth0 netmask via CLI in Ubuntu 18.04 on VPS?
Probably this is what you need (note this will not work on Ubuntu 16.04):
#!/bin/bash
IFACE='eth0'
ifconfig | grep -A 7 "$IFACE" | sed -nr 's/^.*netmask\s([0-9\.]+)\s\sbroadcast.*$/\1/p'
In the ...
2
votes
Change VPS root password
This is very vague... What are the circumstances? Does someone know your password?
Generally if you believe password to be:
Weak Password (Not very strong)
Known by someone else. (who is not ...
2
votes
How to create config files
To clarify, you are trying to create a root access file (because you are using sudo), inside a hidden directory under $HOME. Also, the directory may not exist yet, so first try:
cd ~/.yourcoin
If it ...
2
votes
Accepted
VPS IP address for local site
Step Six — Set Up Local Hosts File (Optional)
If you haven't been using actual domain names that you own to test
this procedure and have been using some example domains instead, you
can at ...
2
votes
Accepted
How to extend storage space on VPS (LVM) 9GB to 40GB
The procedure is rather easy and it should even work on a running system. Keep the word "should" in mind. Normally, the procedure is as following:
Start off with resizing the LVM you need to resize:...
2
votes
why is only one user challenged for an ssh password?
Fromm ssh-vvv ssh server is using keyboard interactive.
First make sure you can log in using a key.
Then, edit sshd_config and set the following to no
PasswordAuthentication no
...
2
votes
Ubuntu 16.04 - Couldn't find any package by glob and regex [VPS]
Finally got it working with the following command:
dpkg -i openvpn-as-2.1.4b-Ubuntu16.amd_64.deb
2
votes
Accepted
What does this permission rule mean
There are three different commands,
sudo chown -R "$USER":www-data /var/www changes the ownership of the /var/www folder to user=$USER and group=www-data.
find /var/www -type f -exec chmod 0660 {} \;...
2
votes
Can't store passphrase in same session with eval $(ssh-agent) && ssh-add
You need to detect if ssh-agent is already running via your .bashrc. If it is not running, then start it. If it is already running, then use it.
Here's a snippet from my .bashrc which sets up ...
2
votes
Accepted
Running LXD inside Viruozzo
Virtuozzo is based in OpenVZ (you can check https://wiki.openvz.org/FAQ). They use an old kernel (2.6 based) without cgroups functionality needed for Docker/LXC/LXD. So your attempt will not work. ...
2
votes
Accepted
Minimal Ubuntu server image and OpenVZ OS images
In general openvz guests are designed to be as small and lightweight as possible. I highly suggest you use the of the official templates and follow the advice on the openvz site if you are new to ...
2
votes
Running xdotool on VPS
Looks like a bug/incompatibility between xdotool and some VNC implementations, especially tightvnc. See this ~3 years old open GitHub issue on xdotool.
In the thread the xdotool developer mentions a ...
Only top scored, non community-wiki answers of a minimum length are eligible