Golfvilla Posted February 23, 2015 Report Share Posted February 23, 2015 I just recently instaled Blesta on my In Motion Hosting Virtual LAMP server. I am in the process of setting up Blesta. I followed the instructions in the User Manual for setting up a secure FTP: http://docs.blesta.com/display/user/Important+Settings#ImportantSettings-SystemSpecific When I test the settings, I get the following: SFTP connection was successful! When I go back to On Demand backup and click on Force Offsite Backup, I get the following message: The SFTP backup failed. Any thoughts on why I am getting the failed message? Thanks! Quote Link to comment Share on other sites More sharing options...
0 Michael Posted February 23, 2015 Report Share Posted February 23, 2015 It depends on your set-up is there a firewall blocking the connections or timing it out. It could be the location is invalid on the settings under (Path) I use a backup server with TheSkySpace with the UBuntu OS and it works fine? Quote Link to comment Share on other sites More sharing options...
0 Golfvilla Posted February 23, 2015 Author Report Share Posted February 23, 2015 Thank you for your reply Licensecart. I setup a backup folder under the blesta folder on the same server as the website. It tested successfully on the setup. Quote Link to comment Share on other sites More sharing options...
0 Paul Posted February 23, 2015 Report Share Posted February 23, 2015 The backup uses the mysqldump binary, which must exist on your system. If you have SSH access, you can type "whereis mysqldump" to see if it exists. While Blesta may be able to make the SFTP connection successfully, it may not be able to generate the backup file if mysqldump is not available. Michael 1 Quote Link to comment Share on other sites More sharing options...
0 Golfvilla Posted February 24, 2015 Author Report Share Posted February 24, 2015 Thank you Paul! I have to request SSH access. I will check with support about the existance of mysqldump. Quote Link to comment Share on other sites More sharing options...
0 Golfvilla Posted February 25, 2015 Author Report Share Posted February 25, 2015 mysql dump is installed on the server. Quote Link to comment Share on other sites More sharing options...
0 Paul Posted February 25, 2015 Report Share Posted February 25, 2015 mysql dump is installed on the server. Where is it? Is it in the environment variables? I forget if Blesta simply tries to execute mysqldump, or if it includes the path. I believe the default path on most systems is /usr/bin/mysqldump. Also, are there any commands disabled in your php.ini? It probably uses exec() or shell_exec() Quote Link to comment Share on other sites More sharing options...
0 Golfvilla Posted February 25, 2015 Author Report Share Posted February 25, 2015 Thanks Paul, Here is the output of the command: # whereis mysqldumpmysqldump: /usr/bin/mysqldump /usr/share/man/man1/mysqldump.1.gz php.ini diabled commands: asp_tags = Offoutput_buffering = Offzlib.output_compression = Offimplicit_flush = Offsafe_mode = Offsafe_mode_gid = Offexpose_php = Offdisplay_startup_errors = Offignore_repeated_errors = Offignore_repeated_source = Offtrack_errors = Offregister_globals = Offmagic_quotes_gpc = Offmagic_quotes_runtime = Off magic_quotes_sybase = Offdefine_syslog_variables = Offsql.safe_mode = Offmysql.trace_mode = Offpgsql.auto_reset_persistent = Offsybase.compatability_mode = Offmssql.compatability_mode = Offmssql.secure_connection = Off Quote Link to comment Share on other sites More sharing options...
0 Golfvilla Posted February 25, 2015 Author Report Share Posted February 25, 2015 correction: disabled commands: Quote Link to comment Share on other sites More sharing options...
0 Paul Posted February 25, 2015 Report Share Posted February 25, 2015 Let's see if you can run mysqldump via the command line (SSH), try executing this command: mysqldump -u USER -p DATABASENAME -r dump.sql Replace USER and DATABASENAME with the proper values. You will be prompted for the password after you run the command. You can check your Blesta config at /config/blesta.php for your database details. Do you have a dump.sql after running the command? How large is it? Open it up and see if it looks right. Quote Link to comment Share on other sites More sharing options...
0 Golfvilla Posted February 25, 2015 Author Report Share Posted February 25, 2015 Thank you Paul, I will try that. I was just thinking, I am setting up my Blesta per the manual procedures, I haven't set up packages, modules, etc. yet. Would that have anything to do with the error message? Thanks! Quote Link to comment Share on other sites More sharing options...
0 Paul Posted February 26, 2015 Report Share Posted February 26, 2015 Thank you Paul, I will try that. I was just thinking, I am setting up my Blesta per the manual procedures, I haven't set up packages, modules, etc. yet. Would that have anything to do with the error message? Thanks! Nope, the backup should work with a fresh install and is not dependent on a certain level of configuration -- except configuring the backups themselves! Curious the result of running mysqldump manually per above. Quote Link to comment Share on other sites More sharing options...
0 Golfvilla Posted February 27, 2015 Author Report Share Posted February 27, 2015 4,200 KB. Contains a lot of tables. Looks like everything is there. Quote Link to comment Share on other sites More sharing options...
0 Paul Posted February 27, 2015 Report Share Posted February 27, 2015 4,200 KB. Contains a lot of tables. Looks like everything is there. So running the command via SSH worked, but not so much within Blesta? Does your cron run as the same user as your SSH user? Unusual Quote Link to comment Share on other sites More sharing options...
0 Golfvilla Posted February 28, 2015 Author Report Share Posted February 28, 2015 I do not have SSH access with my virtual account. I had to submit a support ticket to do the dump but the cron is running successfully. Quote Link to comment Share on other sites More sharing options...
Question
Golfvilla
I just recently instaled Blesta on my In Motion Hosting Virtual LAMP server. I am in the process of setting up Blesta. I followed the instructions in the User Manual for setting up a secure FTP:
http://docs.blesta.com/display/user/Important+Settings#ImportantSettings-SystemSpecific
When I test the settings, I get the following:
SFTP connection was successful!
When I go back to On Demand backup and click on Force Offsite Backup, I get the following message:
The SFTP backup failed.
Any thoughts on why I am getting the failed message? Thanks!
Link to comment
Share on other sites
14 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.