Support

Akeeba Backup for Joomla!

#38833 Restore fails because file could not be opened for writing

Posted in ‘Akeeba Backup for Joomla! 4 & 5’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

Joomla! version
3.10.11
PHP version
8.1.17
Akeeba Backup version
8.2.7

Latest post by tampe125 on Wednesday, 05 April 2023 08:39 CDT

DHMG GmbH

I want to migrate to Joomla 4 and was updating site components. After this went wrong (one of the components made part of the website unaccessable) I wanted to restore an automated backup. Immedeatly after starting the restoration process I get the error, that a readme file could not be opened for writing (screenshot1). I checked the permissions and the flags seem to be set correctly (screenshot2). Never had such a problem until now.

Can you help me?

 

Best regards,

Mario Hochschwarzer

tampe125
Akeeba Staff

Hello,

most likely your host is blocking the process. I'd suggest you to performing the restoration using Kickstart. Please download your backup archive, then upload it again on your site root, with Kickstart.

Start the extraction, if it fails, in the first page please set the minimum execution to 5 and the maximum one to 3 seconds. Yes, minimum is greater than maximum, that's not a typo. In this way the process will slow down, consuming fewer resources.

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!

DHMG GmbH

Tried it again today without changing anything and the restoration did start, but this time I got another (sadly familiar) error:

Akeeba claims that the provided database account does not have sufficient rights (see attached screenshot), which simply cant be true. I already filed a ticket last year because of the very same error (Ticket #37501). The solution last time was to downgrade and use Akeeba Core 7.0 and PHP 7.4.30, however this wont work this time. How am I supposed to migrate to Joomla 4 while being forced to use Akeeba 7?

The provided database account has full rights (see screenshot) so why does Akeeba show this error?

 

Hope you can help.

tampe125
Akeeba Staff

mhm.. that feels a bit strange.

Can you please provide access to your site so I can run some tests? Which backup ID you want to restore?

I have made this ticket private so that only you and me can see the information posted here.

Please provide me with the following information:

  1. The URL to your site's administrator login page
  2. Super User username and password
  3. FTP connection information


Please allow up to one business day (GMT+2 timezone) for me to log in to your site and debug this issue. When I'm done I will post back. Once the issue is fixed, you can revoke my access e.g. by changing the Super Administrator and FTP passwords.

IMPORTANT INFORMATION
In order for me to help you fast and accurately, please provide the information by copying the form below, paste it into your reply and fill in the information:

----- Access Information Form -- START -----
Super Administrator access

  • URL to site's administrator page (e.g. http://www.example.com/administrator?foobar):
  • Super User username:
  • Super User password:


FTP connection information

  • FTP methods supported (e.g. FTP, FTPS, SFTP):
  • FTP Hostname:
  • FTP Username:
  • FTP Password:
  • FTP Port (if other than 21 for FTP and 22 for SFTP, ask your host):


----- Access Information Form -- END -----

Please make sure that you have tested the Super Administrator connection using a different browser or machine than the one you are using daily. Double check that logging in is possible and that the user has Super User privileges, i.e. it's not a regular Administrator. Make sure that your site does not block whole countries or IP ranges which would make it impossible for me to log in / connect by FTP. Finally, please do make sure that the FTP connection works and that logging in to it I have access to your site's files.

Kindly note that your site connection information and your site content is handled in strict confidence. Not only we are a reputable development company, we are also bound by law (EU GDPR) to do so. After you file your reply, the connection information to your site will be stored in an encrypted, hidden storage area on our site and will be automatically deleted when this ticket is closed. Finally keep in mind that the people providing support to you are the same developers who wrote the software you're using on your site.

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!

DHMG GmbH

I want to restore backup #285. Here is the information you requested:

----- Access Information Form -- START -----
Super Administrator access

  • URL to site's administrator page (e.g. http://www.example.com/administrator?foobar): https://erdbau-braunhofer.at/administrator
  • Super User username: akeeba_davide
  • Super User password: plzhelp


FTP connection information

  • FTP methods supported (e.g. FTP, FTPS, SFTP): FTPS
  • FTP Hostname: ftps://390.hostserv.eu
  • FTP Username: akeeba_support
  • FTP Password: 2Bnjh2?37
  • FTP Port (if other than 21 for FTP and 22 for SFTP, ask your host):


----- Access Information Form -- END -----

The super User Account is tested and works - same with the FTP connection. The database connection should be saved inside the backup, but in case you need these as well:

host: localhost or 390.hostserv.eu:3306; both works

database name: sb_db_joomla1

user: sb_dbuser

password: liP7j5*9

This connection is also tested and verified as working.

tampe125
Akeeba Staff

Hello,

thank you for the access details. I was able to complete the restoration, I had to choose a different database driver, instead of MySQLi I choose MySQL (PDO).

I completed the restoration, can you please double check if everything is ok? I can't login anymore because the account you added is not inside the backup I restored.

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!

DHMG GmbH

Yes, that did the trick. The backup got restored successfully, however after trying it myself I get another error at the end of the restoration process when I click on the "Remove the installation directory" button.

It says: We could not remove your installation directory automatically. Please close this message box by clicking the × button on its top right corner. Then proceed to remove the installation directory manually, as per the last bullet point of the instructions found on this page.

 

Not a big problem, but you should probably know.

 

Thanks a lot for your help!

tampe125
Akeeba Staff

Yes, I had the same error, but when I checked with FTP, the folder was not there.

I'm going to review it, but for the moment the initial issue seems to be fixed.

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!

Support Information

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!