Questions tagged [ssh]
The ssh tag has no summary.
44 questions
0 votes
1 answer
73 views
mariadb remote access issues
Hello all my name is 0xNosaj I have a website I was given to control and move. It runs on PHP. I have only SSH access to it but I cannot seem to make the phpmyadmin site come up. How I've tried ...
1 vote
0 answers
248 views
executing mariadb-dump with password over ssh
I need to make backups of the remote machine mariadb database. My plan is to run ssh user@remoteip 'mariadb-dump -uuser -ppass --all-databases' > backup.sql from my local machine. I found that ...
- 285
0 votes
1 answer
103 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
44 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 ...
- 255
0 votes
1 answer
709 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
867 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
934 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]....
- 327
0 votes
0 answers
451 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
539 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 ...
- 444
1 vote
1 answer
673 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,403
0 votes
1 answer
327 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 ...
- 323
0 votes
0 answers
701 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:...
- 444
0 votes
1 answer
1k 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