Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Can't upload backup via SFTP #274

Closed
Philippians413 opened this issue Sep 23, 2021 · 4 comments
Closed

Can't upload backup via SFTP #274

Philippians413 opened this issue Sep 23, 2021 · 4 comments

Comments

@Philippians413
Copy link

Hello!
SFTP configs:

SFTP_PATH=backup/clickhouse/development
SFTP_PASSWORD=11223344
SFTP_USERNAME=username
SFTP_PORT=2232
SFTP_ADDRESS=x.x.x.x

clickhouse-backup create finished successfully, but upload not.

$ LATEST_BACKUP=$(clickhouse-backup list local latest)
$ echo $LATEST_BACKUP
2021-09-23T15-39-36
$ clickhouse-backup upload $LATEST_BACKUP
2021/09/23 16:00:41 error can't connect to SFTP: open 11223344: no such file or directory

I have no idea why password is reading as file.
Could you take a look, please?

Regards,
Bohdan

@Slach
Copy link
Collaborator

Slach commented Oct 14, 2021

Thanks a lot for reporting
I found root reason
image
as quick workaround could you define /etc/clickhouse-backup/config.yml with

general:
  remote_storage: sftp
sftp:
  password: 111223344
  username: username
...

@besteffects
Copy link
Member

@Slach Is there a typo?
remote_stroage: sftp
Did you mean remote_storage?

@Slach
Copy link
Collaborator

Slach commented Oct 14, 2021

@besteffects yep, sorry remote_storage: sftp

@Slach
Copy link
Collaborator

Slach commented Oct 24, 2021

fixed on #288

@Slach Slach closed this as completed Oct 24, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants