Evaske Posted October 10, 2013 Report Share Posted October 10, 2013 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? Quote Link to comment Share on other sites More sharing options...
0 Tyson Posted October 10, 2013 Report Share Posted October 10, 2013 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. Quote Link to comment Share on other sites More sharing options...
0 Evaske Posted October 10, 2013 Author Report Share Posted October 10, 2013 Hey, I don't have a backup log under cron. Quote Link to comment Share on other sites More sharing options...
0 Paul Posted October 10, 2013 Report Share Posted October 10, 2013 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. Quote Link to comment Share on other sites More sharing options...
0 Evaske Posted October 11, 2013 Author Report Share Posted October 11, 2013 Yeah linux server. mysqldump binary is there and exec() and system() are not being disabled in the php.ini Quote Link to comment Share on other sites More sharing options...
0 Paul Posted October 11, 2013 Report Share Posted October 11, 2013 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. Quote Link to comment Share on other sites More sharing options...
0 Cody Posted October 13, 2013 Report Share Posted October 13, 2013 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. Quote Link to comment Share on other sites More sharing options...
0 Evaske Posted October 13, 2013 Author Report Share Posted October 13, 2013 I can connect and upload to the folder with no problems through an SFTP client. Quote Link to comment Share on other sites More sharing options...
0 liveuserlb Posted October 24, 2013 Report Share Posted October 24, 2013 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 ErrorThe 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. Quote Link to comment Share on other sites More sharing options...
0 ross@inpresence.us Posted October 28, 2014 Report Share Posted October 28, 2014 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 Quote Link to comment Share on other sites More sharing options...
0 Tyson Posted October 28, 2014 Report Share Posted October 28, 2014 Have you tried to force the backup manually through the interface? Does it encounter an error then? Michael 1 Quote Link to comment Share on other sites More sharing options...
0 ross@inpresence.us Posted October 28, 2014 Report Share Posted October 28, 2014 No, I am able to download a backup to my local machine just fine! Quote Link to comment Share on other sites More sharing options...
0 Michael Posted October 28, 2014 Report Share Posted October 28, 2014 No, I am able to download a backup to my local machine just fine! There's a Force backup Quote Link to comment Share on other sites More sharing options...
0 ross@inpresence.us Posted October 28, 2014 Report Share Posted October 28, 2014 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. Quote Link to comment Share on other sites More sharing options...
0 Michael Posted October 28, 2014 Report Share Posted October 28, 2014 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? Quote Link to comment Share on other sites More sharing options...
0 ross@inpresence.us Posted October 28, 2014 Report Share Posted October 28, 2014 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/# Quote Link to comment Share on other sites More sharing options...
0 Michael Posted October 28, 2014 Report Share Posted October 28, 2014 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? Quote Link to comment Share on other sites More sharing options...
0 Cody Posted October 28, 2014 Report Share Posted October 28, 2014 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. Quote Link to comment Share on other sites More sharing options...
0 ross@inpresence.us Posted October 28, 2014 Report Share Posted October 28, 2014 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. Quote Link to comment Share on other sites More sharing options...
0 ross@inpresence.us Posted October 28, 2014 Report Share Posted October 28, 2014 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 Quote Link to comment Share on other sites More sharing options...
0 Michael Posted October 28, 2014 Report Share Posted October 28, 2014 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. Quote Link to comment Share on other sites More sharing options...
0 Cody Posted October 28, 2014 Report Share Posted October 28, 2014 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. Michael 1 Quote Link to comment Share on other sites More sharing options...
Question
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?
Link to comment
Share on other sites
21 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.