Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [ssh]

The tag has no usage guidance.

-1
votes
0answers
15 views

Is there any other reason why I can't login to MySQL using SSH on my VPS? [duplicate]

I'm not sure why I can't log to MySQL using SSH credentials. I tried to use the solution in this article but it didn't work. I have already changed the username 'root' to 'jed' and set password. I ...
0
votes
2answers
42 views

pg_dump: Write failed: Connection reset by peer

we are trying to move all database data to other location. we chose to perform pg_dump and we encountered few problems: first was out of memory problem: during pg_dump initialization we get an error: ...
0
votes
1answer
844 views

SSH Tunnel option of PgAdmin4 not working

I am using PgAdmin4 3.3, and I am trying to setup a server connection to a database through an SSH tunnel. My database runs on port 30000 on the host. Setting it to 5432 is unfortunately not possible....
2
votes
0answers
191 views

Mariadb connection fails through tunnel when bind address = localhost

I have a MariaDB 10.1.26 virtual server running on Debian 9. It is connected to via ssh tunnel and the bind address = localhost. It has been working without fail untill recently. Now when I connect ...
1
vote
1answer
176 views

how to 'flush hosts' via ssh

I have a MySQL db hosted on a commercial server as a shared account. Recently I have been getting an error: 'DBI connect('xxxxxx',...) failed: Host 'xxx.xxx.xxx.xxx' is blocked because of many ...
0
votes
2answers
83 views

slave mysql configuration is not stored

EDIT It seems that the problem is with my SSH connection, so I created a different question on serverfault. From what I understand so far, it that this problem is caused from the fact that the port ...
2
votes
1answer
11k views

pgAdmin 4: How to establish a connection through an SSH tunnel/interface in Windows

I installed the latest pgAdmin 4 (v2.1) but I found out that (related thread), for the moment, the only way to establish a connection through an SSH tunneling is using another outside process, an ...
0
votes
1answer
39 views

MySQL time_zone = SYSTEM not getting correct date on CURRENT_TIME

Via SSH I print the current date of my server, which is correct based on my location: When I run SHOW GLOBAL VARIABLES on MySQL, I have time_zone = SYSTEM - which makes me think MySQL will be using ...
0
votes
1answer
527 views

MySQL Workbench SSH to Google Compute Fails with “Authentication error opening SSH tunnel” - but Putty works

I am trying to connect to MySQL server hosted on google cloud compute server. I believe the issue is not MySQL authentication related, but rather SSH. MySQL workbench seems to be unable to connect on ...
0
votes
2answers
149 views

TNS connection forward

There are 3 machines as follows: Machine A - Remote Exadata DB machine Machine B - Remote machine from which only I can connect to port 1521 of Machine A Machine C - Local Machine (To run SQL ...
2
votes
1answer
506 views

PostgreSQL 10 - secure remote logical replication (SSH?)

I am exploring Postgresql for a new project, and the upcoming logical replication feature in version 10 interests me. I would like to use it to have a remote server automatically hold an up-to-date ...
0
votes
1answer
21 views

getting mysql error when running the query alognwith ssh

I am getting " You have an error in your SQL syntax; check the manual that corresponds to your MySQL server" error when running alongwith ssh command : ssh user@localhost echo "delete from ...
1
vote
1answer
6k views

Access denied for user 'root'@'localhost' using Password NO

I have enabled SQL SLOW LOG Queries in my.cnf file but i need to restart mysql and when i try to run this command sudo /etc/init.d/mysql restart for restarting it throws this error. Stopping MySQL ...
1
vote
1answer
675 views

Connection reset to SQL Server when using SSH Tunnel

I am trying to connect to an MS SQL Server database through DBeaver via an SSH tunnel but am getting the following error message when I "Test Connection...": I/O Error: Connection reset ...
3
votes
2answers
2k views

MongoDB replica set over ssh tunnels

I'm trying to archive something like this The MongoDB instance on dc1.com is currently a standalone, and On-Site periodically pulls a backup via mongodump over a ssh tunnel. I now want to create two ...
6
votes
1answer
16k views

DBeaver: connecting to a PostgreSQL database server through SSH: can't initialize tunnel, auth fail

I am trying to use DBeaver to connect to a PostgreSQL database server through SSH: can't initialize tunnel cannot establish tunnel com.jcraft.jsch.JSchException: auth fail I am sure the SSH server ...
1
vote
1answer
286 views

my ssh is ok but masterha_check_ssh is fail

my environment is vmware12 + centos6.6 + mysql5.5 + mha4mysql-manager-0.53-0.noarch.rpm + mha4mysql-node-0.53-0.noarch.rpm my structure is one master three slaves master 192.168.233.135 node ...
1
vote
1answer
546 views

Will a mysql db import be interrupted if my ssh session times out?

I have a large-ish (several GB) mysql DB that I'm planning to import via mysql -u root -p mydb < mydb.sql in a SSH session. What would happen if my SSH connection drops? Is it safer to run ...
3
votes
1answer
2k views

Connect to PostgreSQL via a ssh tunnel using Cygwin

I would like to connect to a Postgres server installed on a remote server using an ssh tunnel. I have Windows so I use cygwin for SSH. I do the following on cygwin: # Create the tunnel ssh -f user@...