Golfvilla Posted February 23, 2015 Report 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
0 Michael Posted February 23, 2015 Report 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
0 Golfvilla Posted February 23, 2015 Author Report 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
0 Paul Posted February 23, 2015 Report 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
0 Golfvilla Posted February 24, 2015 Author Report Posted February 24, 2015 Thank you Paul! I have to request SSH access. I will check with support about the existance of mysqldump. Quote
0 Golfvilla Posted February 25, 2015 Author Report Posted February 25, 2015 mysql dump is installed on the server. Quote
0 Paul Posted February 25, 2015 Report 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
0 Golfvilla Posted February 25, 2015 Author Report 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
0 Golfvilla Posted February 25, 2015 Author Report Posted February 25, 2015 correction: disabled commands: Quote
0 Paul Posted February 25, 2015 Report 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
0 Golfvilla Posted February 25, 2015 Author Report 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
0 Paul Posted February 26, 2015 Report 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
0 Golfvilla Posted February 27, 2015 Author Report Posted February 27, 2015 4,200 KB. Contains a lot of tables. Looks like everything is there. Quote
0 Paul Posted February 27, 2015 Report 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
0 Golfvilla Posted February 28, 2015 Author Report 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
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!
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.