Questions tagged [ssh]
The ssh tag has no usage guidance.
45
questions
0
votes
1
answer
23
views
Using mysqldump on remote server in rsnapshot returns code 127 while the very same command used locally works fine
As said in the title, I want to backup my remote mysql database with rsnapshot, using mysqldump. I don't have any syntax error, but get a "WARNING 'command" returned 127", and the sql ...
0
votes
0
answers
28
views
faild to connect to Mysql at 192..x.x.x:3336 through ssh tunnel at [email protected]:22 ssh
enter image description here
"This is the result when I attempt to connect:
I'm trying to connect MySQL localhost to my session on the server. (I'm connected to my session on the server via SSH ...
abdo zer
0
votes
0
answers
27
views
Reconnect to SSH MYSQL workbench on device that's not always online
I use workbench on a device that is not always online, every time it goes offline the only way to continue using it is by closing and opening a new connection.
I use SSH connection to access MySQL on ...
- 133
0
votes
0
answers
38
views
MySQL transport protocol integrity check
I am interested whether low level transport protocol of MySQL has some checksums or other integrity check? If I use SSH tunnel with interruptions, is it safe that commands will be received intact and ...
- 245
0
votes
1
answer
498
views
Connecting to AWS RDS succeeds via terminal but fails in pgAdmin 4. Why?
I can establish an SSH tunnel using ssh -L 2222:<RDS-Endpoint>:5432 ec2-user@<EC2-IP> -i ~/.ssh/key.pem and then connect to my RDS using psql "host=localhost port=2222 user=postgres ...
- 103
0
votes
1
answer
745
views
sqlplus: command not found Using SSH on Windows to VMware linux
I have oracle Database 12c in a virtual machine with the database working normally in a linux environment (Centos).
Through windows, using ssh I was able to connect to the linux virtual machine. But ...
- 3
-1
votes
1
answer
778
views
Copy between database using pg_dump and SSH
I want to copy a tabel from one server to another using pg_dump and SSH.
Here is the script that I run from the source database :
pg_dump -h 127.0.0.1 -Fc --dbname=postgresql://postgres:[email protected]....
- 317
0
votes
0
answers
397
views
MySQL losing connection after few minutes while waiting
I have an annoying problem.
I think the connection is lost when there is no operation in mysql for a while. I've added a video to make it more explanatory. I tried the solutions on the internet but ...
- 1
0
votes
1
answer
3k
views
Communications link failure SSH Tunnel on Datagrip
I need to connect RDS through SSH for now(Local -> EC2 -> RDS).
So I tried to connect MySQL via SSH Tunnel option on Datagrip, however, It cannot connect to server.
[08S01] Communications link ...
- 127
0
votes
1
answer
456
views
pgpass entries for multiple SSH tunnels with randomly assigned local ports using the same credentials but different passwords
Let's say I have 4 SSH tunnels to different remote servers, each having different PostgreSQL databases up and running. Each tunnel is mapped to a specific port on my local machine (localhost) as ...
- 384
1
vote
1
answer
607
views
How to backup clickhouse over SSH?
In postgreSQL, I usually run this command to backup and compress (since my country have really low bandwidth) from server to local:
mkdir -p tmp/backup
ssh sshuser@dbserver -p 22 "cd /tmp; ...
- 1,373
0
votes
1
answer
233
views
How to restore MySQL DB via command line while closing the SSH session? [closed]
I am importing a large MySQL 8 database on Ubuntu 20.04 where the import takes > 24h. Unfortunatelly my provider reconnets every 24h which leads to a stop of the import.
I am issuing this command ...
- 313
0
votes
0
answers
565
views
Understanding how to set up the port value in pgadmin4 docker from the GUI and in the servers.json config file when using an SSH tunnel
This is extraordinary tricky but I just discovered that, when you first open an SSH tunnel manually in bash (and somehow, I hope that I'm wrong somewhere...);
user@localhost:~$ ssh -N -f -L 2345:...
- 384
0
votes
1
answer
975
views
Create LINKED SERVER to MYSQL using SSH
Is there any way to create a MS SQL Server Linked Server to connect to MySQL through SSH?
I managed to connect to MySQL through SSH using other database management tools like HeidiSQL or DBeaver, ...
- 41
2
votes
0
answers
4k
views
DBeaver connection via SSH tunnel
Using DBeaver, I'm trying to connect to my AWS ec2 instance where I've installed a MariaDB database.
I've created a new connection as:
Connection: AWS / Maria DB
Server Host: localhost (because I'm ...
- 121
-1
votes
1
answer
644
views
Problem with mysql/data folder is too big and took the whole place
for the first time I am faced with such a problem that has puzzled everyone.
I have all hosting busy (AWS lightsail) 78GB and after a few analyzes I realized that 90% of the memory is occupied in the ...
0
votes
1
answer
653
views
Proxying a Postgres connection
I have a client whose Postgres database I need to connect to periodically. This database is currently hosted on their server, let's call it psql.example.com, with standard port 5432. They have it ...
- 103
-1
votes
1
answer
3k
views
Problems with remote ssh access to mysql with Workbench MacOS
I am having problems connecting Workbench with Siteground.
All my connection settings are as instructed, however my question is do I have to open port 3306 on my Mac to connect to the Siteground ...
1
vote
1
answer
331
views
How to transfer postgres databases from one server to other
VPS server has old Debian 6 Squeeze with Postgres 9.1
It has 24 databases.
Every night backup copies are created using pg_dump to /root/backups directory for every database.
This directory has 24 ....
- 123
0
votes
1
answer
1k
views
How to setup an ssh connection to a postgres 12 db using dbeaver
I am currently in the process of trying to connect to my local postgres 12 db. In the past (9.3/9.6) you were able to edit the .pg_hba file to modify which connections were allowed but that file doesn'...
- 235
0
votes
0
answers
1k
views
SSHtunnelForwarder to Linux Box, then connect to Postgres RDS (AWS)
I'm trying to write a python script to update DDL in a Aurora RDS (postgres) on AWS. In Order to do this, I need to SSHTunnel to a linux box that sits at the edge of the VPC, then do another jump to ...
2
votes
1
answer
2k
views
Can't Connect to MySQL database through PuTTY [closed]
I have a database that runs on pythonanywhere.com, and am trying to connect Tableau to it, and need to set up an SSH Tunnel in order to do so.
The directions on pythonanywhere's website mention ...
0
votes
2
answers
455
views
Connecting to local database on Azure VM
Using DBforge to try and connect to a local MSSQL database on an Azure Ubuntu 18 VM, I am getting this error:
A network-related or instance-specific error occurred while establishing a connection to ...
- 135
6
votes
1
answer
960
views
pg_ctl hangs over ssh
I am designing a process to test my postgresql 10.8 backups by restoring them to a random point in time in a throwaway virtual machine. I have been unable to fully automate the process though. I am ...
- 4,861
0
votes
0
answers
114
views
How can I resolve the `package mysql-server is not installed` issue?
I have just upgraded MySQL from version 5.5.55 to version 5.6, via SSH. I have managed to successfully start the MySQL, however I am experiencing the 500 Internal Server Error when trying to access ...
- 119
1
vote
1
answer
2k
views
Unable to downgrade MySQL from version 8 to 5.6 nor start MySQL (MySQL Error Log Included) [closed]
I run a Plesk VPS (OS: Centos 6/Linux (Final)), whereby I recently tried to upgrade the MySQL from version 5.5.55 to version 5.6.
Being relatively new to this area, I strictly followed this Plesk ...
- 119
1
vote
0
answers
202
views
how to access hadoop slaves which have the same IP address but different port numbers
My question is, I'm wondering if it's possible Hadoop can do ssh access with a different port number(not 22) for slaves when it makes a Hadoop cluster.
Detail)
I tried to make Hadoop cluster with two ...
- 21
0
votes
2
answers
2k
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:
...
- 69
1
vote
0
answers
2k
views
SSH Tunnel option of PgAdmin4 not working [duplicate]
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....
- 111
2
votes
0
answers
3k
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 ...
- 21
2
votes
1
answer
551
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 ...
- 21
0
votes
2
answers
1k
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 ...
- 131
12
votes
3
answers
74k
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 ...
- 339
0
votes
1
answer
148
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 ...
- 123
0
votes
1
answer
2k
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 ...
- 111
0
votes
2
answers
715
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 ...
- 117
3
votes
1
answer
2k
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 ...
- 131
-1
votes
1
answer
47
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
1
answer
9k
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 ...
- 135
2
votes
1
answer
8k
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
...
- 21
5
votes
2
answers
5k
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 ...
- 313
10
votes
1
answer
36k
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 ...
- 2,085
1
vote
1
answer
662
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
...
- 321
7
votes
2
answers
3k
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 ...
- 617
3
votes
1
answer
3k
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@...
- 153