Restoration failed in a site in production. Big problem. Please send a solution asap. Log file 130Mb in link below
https://drive.google.com/file/d/1AAKWxylLy7r8_5laaC13Vdo5CtTqNM-R/view?usp=sharing
Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.
Latest post by nicholas on Friday, 16 June 2023 07:58 CDT
Restoration failed in a site in production. Big problem. Please send a solution asap. Log file 130Mb in link below
https://drive.google.com/file/d/1AAKWxylLy7r8_5laaC13Vdo5CtTqNM-R/view?usp=sharing
Hello,
we'd need more info about it and the error you got.
Please note that Akeeba Solo will only take care of creating a backup and move the files to the new location. When you're there you will have to configure your Prestashop installation to use the new values for new server. For example: https://classydevs.com/move-prestashop-from-localhost-to-server/
Davide Tampellini
Developer and Support Staff
🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!
We made a backup from our Prestashop website with akeeba solo and we restore the site in the same place. No new location. Now there is no products avalable. If Akeeba Solo don´t manage backup and restoration why it allows to do it.
We had an issue with the password of the database user in the first try. Apparently has characters not allowed. So we change the ftp user and set an easier password. When the installation finished the web doesn´t work properly and now customers cannot place orders
If Akeeba Solo don´t manage backup and restoration why it allows to do it.
I don't appreciate the allegation here. I understand you brought down production, but this feeble attempt at pawning off your responsibility to the software you used incorrectly does not exactly make you look stellar in your job.
Akeeba Solo does back up all your files and database contents. If it runs into a problem doing that, it tells you (warnings). If you tell it to do something else, it will do whatever you told it to do. I cannot tell you what it did and did not back up because the log file link is behind a login I do not have.
Akeeba Solo can reconfigure Joomla and WordPress upon restoration. For everything else, it provides the ANGIE For Miscellaneous PHP Applications installer which DOES NOT reconfigure the site upon restoration as explicitly stated in https://www.akeeba.com/documentation/akeeba-solo/angie-misc-setup.html.
To make this crystal clear: Solo cannot reconfigure software backed up and restored using the Miscellaneous PHP Applications installer. Since you changed your database password (it's different than what it was when you backed up your site) you need to change PrestaShop's configuration by hand. This is in the documentation and it was correctly diagnosed by Davide above, who also gave you a link to third party instructions which address this. It is step 5 in the link Davide already gave you above (https://classydevs.com/move-prestashop-from-localhost-to-server/).
We had an issue with the password of the database user in the first try. Apparently has characters not allowed. So we change the ftp user and set an easier password.
The problem you had with your database password IS NOT a limitation in Akeeba Solo or its restoration script and this was made perfectly clear to you in the message which reads:
Your database password contains special characters. Many web servers reject or modify these passwords, causing the database restoration to fail with a database connection error.
The problem is that some hosts enable the Apache mod_security2 module with the default OWASP Atomic ruleset. Certain combinations of punctuation and special characters trigger a false positive in one of these rules, preventing the form from submitting (the server typically returns an HTTP 403 Forbidden error). The correct but hard solution is to disable the rule which throws the false positive. The easy, temporary workaround is to change the database user's password. However, by doing so, you have necessitated changing your software's configuration with the new database connection information.
PrestaShop's documentation on the matter is scant but it does tell you that the database connection information is in /app/config/parameters.php
as per Davide's information to you.
If this is still not clear, see https://presta.site/blog/en/how-to-change-database-connection-settings-in-prestashop/ which tells you the same.
You need to change the database connection information.
Next time be more prepared. Remember what I have written in the documentation:
Test your backups periodically. Maybe you excluded a database table you didn't mean to. Maybe a folder was unreadable but you ignored the warning. Maybe the FTP program you are using to download your backups is broken. Maybe you accidentally set the temp-directory or logs file directory of your site to your site's root or another important system folder, ending up excluding it automatically in the process. Maybe there was a bug in the version of Akeeba Solo or Akeeba Backup you were using, it created a corrupt archive and you didn't update to the next version that fixed it (it happens once every 3-4 years, we usually fix the issue within 24 hours). No matter what happened, a corrupt backup can ruin your day. Test your backups periodically to make sure that they actually work.
https://www.akeeba.com/documentation/akeeba-solo/restoring-backups.html#general-guidelines
This is not something unique to our backup software. This is a universal truth applicable to ALL backup solutions. There are three rules about backups which have been true ever since the advent of generic computers in the 1950s:
Ask any serious sysadmin anywhere and they will tell you the same.
Nicholas K. Dionysopoulos
Lead Developer and Director
🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!
Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.
Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!