[FIXED] How to solve "sign_and_send_pubkey: signing failed: agent refused operation"?

Issue

Configuring a new Digital Ocean droplet with SSH keys. When I run ssh-copy-id this is what I get:

ssh-copy-id user@012.345.67.89
/usr/bin/ssh-copy-id: INFO: attempting to log in with the new key(s), to filter out any that are already installed
/usr/bin/ssh-copy-id: INFO: 1 key(s) remain to be installed -- if you are prompted now it is to install the new keys
sign_and_send_pubkey: signing failed: agent refused operation
user@012.345.67.89's password: 

Number of key(s) added: 1

Now try logging into the machine, with:   "ssh 'user@012.345.67.89'"
and check to make sure that only the key(s) you wanted were added.

However, when I then attempt to ssh in, this happens:

ssh user@012.345.67.89
sign_and_send_pubkey: signing failed: agent refused operation
user@012.345.67.89's password: 

Upon entering the password, I am logged in just fine, but this of course defeats the purpose of creating the SSH key in the first place. I decided to take a look at the ssh-agent server-side and here's what I get:

user@012.345.67.89:~# eval `ssh-agent -s`
Agent pid 5715
user@012.345.67.89:~# ssh-add -l
The agent has no identities.

user/.ssh/authorized_keys does contain an ssh-rsa key entry, as well, but find -name "keynamehere" returns nothing.

Solution

Run ssh-add on the client machine, that will add the SSH key to the agent.

Confirm with ssh-add -l (again on the client) that it was indeed added.

Answered By - Oliver

Answer Checked By - David Goodson (PHPFixing Volunteer)

Read More

[FIXED] How can I tell if someone else is logged into my Windows 10 PC?

Issue

Three or four times recently, I've tried shutting down my Windows 10 PC, only for it (mysteriously) to instead go back to the normal Windows login screen. And when I then try to shut the PC down from there, it (again mysteriously) warns me that this will shut down any connected users' sessions (but without giving any useful details).

All of which makes suspect (in a slightly paranoid, but probably justified way) that someone else might possibly now be logging in to my PC from time to time.

So: is there anything (i.e. application / trick / hack / whatever) I can use to find out / track who (or what) is currently (remotely) logged in to my Windows 10 PC?

Because I work from home, I guess it's conceivable that a client company's firewall / antivirus bot is doing something nasty (but legit) that I'm unaware of. But... I'd just like to know. Thanks!

Solution

Type query user in a command prompt. No need for elevation.

Answered By - Wisblade

Answer Checked By - Clifford M. (PHPFixing Volunteer)

Read More

[FIXED] How to access virtualbox with more then 1 pc

Issue

1st PC easily access virtual box. but when i access with 2nd PC,1st PC automatically logout from virtual box. using virtual box with remote access. If anyone knows then please guide me. Thanks

Solution

If your logging on as the same user on a server you are probably kicking yourself off with the second pc, try making another user account and logging on via it.

Answered By - user284635

Answer Checked By - Mary Flores (PHPFixing Volunteer)

Read More

[FIXED] How do I allow secure remote connections to a local MySQL database using Nginx?

Issue

Opening the default port 3306 to the outside world is something I would like to avoid if possible. We have Nginx running for reverse proxy purposes for other applications. The goal here is to access the MySQL databases with clients such as MySQL Workbench from outside the local network, in a secure way. The MySQL server runs on a Debian (Linux) Virtual Machine.

I configured a server block as described below. Connecting to mysql.domain.com, port 80, with a non-root user in MySQL Workbench results in a failure.

Server block:

server {

    server_name mysql.domain.com;

    location / {
        proxy_pass http://localhost:3306/;
        proxy_http_version 1.1;
        proxy_set_header Upgrade $http_upgrade;
        proxy_set_header Connection "upgrade";
        proxy_set_header Host $host;
    }
}

Error message:

Failed to Connect to MySQL at mysql.domain.com:80 with user non-root. 
Lost connection to MySQL at 'waiting for initial communication packet', system error: 10060

Solution

The goal here is to access the MySQL databases with clients such as MySQL Workbench from outside the local network

All modern MySQL GUI clients support SSH tunneling. This is the most secure approach to connect and requires zero configuration on the server-side: if you can connect via SSH, then you can connect to MySQL on that host.

In MySQL Workbench, while creating a connection, select "Standard TCP/IP over SSH" as the connection method, then fill out SSH connection details and MySQL connection details. The key point is putting MySQL server as 127.0.0.1 as you typically want to connect to MySQL instance which is running on the machine you SSH into. That's all there is to it.

Answered By - Danila Vershinin

Answer Checked By - Cary Denson (PHPFixing Admin)

Read More

[FIXED] PhpMyAdmin remote access denied but command cli granted

Issue

I have 2 mariadb servers :

• server1 is public (with apache, php, etc... and a public ip)
• server2 is private (only with mariadb, and only a private ip)

server2 is accessible by ssh only via server1

i installed phpmyadmin on server1, and i want to manage dbs on server2 with it

i already followed this : remote phpmyadmin

i granted all privileges on server2 to server1's mariadb root user

i can access it with mysql cli from server1 to server2 ('mysql --host=server2ip -u root -p'), but i get 'access denied' when using phpmyadmin... any idea ?

even if i used 'config' auth_type in config.inc.php, i still have the login form on phpmyadmin when i switch to remote host, is it normal ? (i have to give username, password and to select the host : localhost or remote host)

Solution

Solved... the answer was... SELinux !

I installed the last version of phpMyadmin, which gave me more details about the error (#2002), then after a search on SO :

Error 2002

Maybe it'll help someone !

Answered By - sylvain

Read More