Sftp Backup Failing

[Evaske]

Hey,

 

My SFTP backup keeps failing. I have checked the settings by clicking the "Test settings" option and that says success but then if I click force offsite backup it fails.

 

Is there a log of this somewhere so I can see the reason for the failure?

[Tyson]

Testing the settings only checks whether the credentials are valid for connecting to the server. You can check the cron logs under [Tools] -> [Logs] -> [Cron] for the backup log to see if any information is available that describes why it failed to backup.

[Evaske]

Hey,

 

I don't have a backup log under cron.

[Paul]

Linux server? mysqldump binary exist? exec() and system() functions allowed in PHP? mysqldump is executed to create the database dump, and then it's SFTP'd over.. it may be that it's failing before it gets to the that point.

[Evaske]

Yeah linux server. mysqldump binary is there and exec() and system() are not being disabled in the php.ini

[Paul]

If you SSH in as your cron user, are you able to execute mysqldump? I'm not sure what else it could be, might require some debugging.

[Cody]

Another issue might be that the SFTP user doesn't have permission to write to the directory where the backups are going, but then I would expect you'd see something in the cron log about that.

[Evaske]

I can connect and upload to the folder with no problems through an SFTP client.

[liveuserlb]

need help I clicked on <Test These Settings> to test my sftp didn't receive any message and when clicking on <Download Backup> receieved this error and inside the log file nothing important more the message received/

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@ddddddd.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

[ross@inpresence.us]

Hello

 

Reviving an old thread here: I am not able to back up to my remote server, and there are no errors in the cron log. I have all the settings for SFTP properly configured, and the account can create and edit directories in the FTP receiving server. Nothing in the logs, am able to compete mysqldump as cron user. Please advise

 

Blesta Version 3.3.1

[Tyson]

Have you tried to force the backup manually through the interface? Does it encounter an error then?

[ross@inpresence.us]

No, I am able to download a backup to my local machine just fine!

[Michael]

No, I am able to download a backup to my local machine just fine!

 

There's a Force backup

[ross@inpresence.us]

There's a Force backup

 

Correct. When I try to use Force Offsite Backup, it spins forever and does not create the file on the external server.

[Michael]

Correct. When I try to use Force Offsite Backup, it spins forever and does not create the file on the external server.

 

There's something wrong with your set-up then. Have you gone to the SFTP page and click test?

 

[ross@inpresence.us]

Yes

 

There's something wrong with your set-up then. Have you gone to the SFTP page and click test?

 

backup-test.PNG

 

Yes, nothing happens when I click on the button. No reload or refresh. No action at all. The link address is http://mysite.com/blesta/admin/settings/system/backup/ftp/#

[Michael]

Yes

 

 

Yes, nothing happens when I click on the button. No reload or refresh. No action at all. The link address is http://mysite.com/blesta/admin/settings/system/backup/ftp/#

 

Can you post a screenshot of what you have? Do you have a Firewall which is blocking any connections?

 

Edit: Any cron job locks settings > company > automation > any locked?

[Cody]

 

 

Yes, nothing happens when I click on the button. No reload or refresh. No action at all. The link address is http://mysite.com/blesta/admin/settings/system/backup/ftp/#

 

The test makes an AJAX request. Sounds like your server is choking on the request.

 

Could be your server is missing or has an outdated version of the openssl or curl PHP extensions.

[ross@inpresence.us]

The test makes an AJAX request. Sounds like your server is choking on the request.

 

Could be your server is missing or has an outdated version of the openssl or curl PHP extensions.

 

This is my setup of the sftp page. Please excuse my rude black ink.

[ross@inpresence.us]

The test makes an AJAX request. Sounds like your server is choking on the request.

 

Could be your server is missing or has an outdated version of the openssl or curl PHP extensions.

 

There are a lot of AJAX requests sitewide, though, and my server is able to handle them. It also uses cURL and SSL tools on other applications installed in the same account. It's a VPS with plenty of updated tools (such has been my experience).

 

Locked cron tasks: exchange rate updates & deliver reports are not enabled.

Exchange Rate Updates

[Michael]

Locked cron tasks: exchange rate updates & deliver reports are not enabled.

Exchange Rate Updates

 

Sorry I mean they have spinners with a link to unlock the cron job.

[Cody]

 

There are a lot of AJAX requests sitewide, though, and my server is able to handle them.

 

 

Has nothing to do with the AJAX request, rather you don't see the result of the AJAX request because your server chokes on the actual SFTP action.

 

If you're familiar with browser inspectors you could see the result returned from the server (if it returns anything).

 

You should enable PHP error logging on your server and log all PHP errors. You can also open the /config/blesta.php config and change the error reporting value from 0 to -1 at the top of that file.