Support

Site Restoration

#37111 Workaround for db restoration error: "Restoring Database: Access denied; you need (at least one of) the SUPER privilege(s) for this operation"

Posted in ‘Site restoration’
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

PHP version
8.1
CMS Type
Joomla!
CMS Version
3.9
Backup Tool Version
n/a
Kickstart version
7.3.1

dgiaco

Hello, I'm posting this to give a hint on the problem showed up on the tickets https://www.akeeba.com/support/site-restoration/37003-restoring-database-access-denied-you-need-at-least-one-of-the-super-privilege-s-for-this-operation-1.html and https://www.akeeba.com/support/site-restoration/36772-restoring-database-access-denied-you-need-at-least-one-of-the-super-privilege-s-for-this-operation.html

I hope these infos can help you in debugging since I've already solved changing the PHP version:
the issue was happening when the selected PHP version was 8.1.3; switching back to 8.0.16 I was able to restore the database.

This was the environment as you requested in the previous ticket:
Mysql driver: Mysqli
DB server: Percona Server 5.7.32-35-log - Percona Server (GPL), Release 35, Revision 5688520
PHP: 8.1.3
Provider: Aruba, italian shared hosting company (imposed by the client)

I don't know at which point of restoration the error occurred since I don't have access to db logs, but it seems was happening at connection (no percentage of restoration was reached, and the error was quite immediate).

I hope this helps,
regards.

nicholas
Akeeba Staff
Manager

On your host create a database user, a database and assign the user to the database, giving it all the privileges. You have skipped one or all of these steps.

Then you can use the database username and password you created, the database name you created and the database hostname and port your host told you to use.

If you do not understand what that means please contact your host and show them this ticket. They will know how to help you do that or at least point you to the documentation describing how to do that.

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!

dgiaco

Hello Nicholas,

This host doesn't provide access to db user management, anyways the users have full privileges on their databases, in fact there's no issue in restoring the db UNLESS on PHP 8.1.

Don't you think there should be something related to the PHP version, since with PHP < 8.1 your restoring script works again fine, without touching the db and user priveleges of course?

Reporting you this just for your knowledge, if it can be useful for your debug or for other users, since as I stated I (like the user of the 25/4 ticket) already restored the db lowering the PHP version.

Regards.

Β 

nicholas
Akeeba Staff
Manager

I am developing and testing on PHP 8.1. Further to that, the actual error message does not even come from our software, it comes from the database server itself.

There is only one case where the database server would send this kind of error message and PHP 8.1 (and only PHP 8.1!) would report as an error. It also happened on very few server configurations. However, we have fixed that since February 16th with Akeeba backup for Joomla versions 8.1.1 and 9.1.1 and Akeeba Solo and Akeeba Backup for WordPress version 7.6.2.

Which is the exact version of the restoration script you are using? This is displayed at the very top of the page, the header reads something β€œAkeeba Backup Site Restoration Script 1.2.3”. In need those numbers after the Akeeba Backup Site Restoration Script text. I believe that you may have a very old version of Akeeba Backup which does not include this change. I am suspecting that because you say that you're using Joomla 3.9, a version of Joomla we have dropped support for since August 17th, 2021 and which of course does not support PHP 8.1 (PHP 8.1 was only released in December 2021!).

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!

dgiaco

The restoration script version is 7.3.1, I am aware is outdatet,
The actual situation is that I am installing for a client a joomla template quickstart package bought on themeforest, including Angie. So I am not using updated versions of softwares, but what it comes with the template installation bundle that I cannot change.

I am happy you have already solved this in next versions, I just thoughtΒ my test scenario could have been useful for your investigation, and as a reference for future users that may encounter this error in these particular situations. For me the ticket can be closed.

Regards.

nicholas
Akeeba Staff
Manager

Ah! That version was released in September 2020 and predates the entire PHP 8 family. No wonder it only works with PHP 7.4, we had not even added PHP 8.0 support just yet. It all makes sense. I agree, we can close this ticket, it's actually about a lot of PHP 8 compatibility issues we have already fixed in the past two years.

Have a great day!

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!

Support Information

Working hours: Typically we work Monday to Friday, 9am to 7pm Cyprus timezone (EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets, but we cannot respond to them, outside of our working hours.

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!