I no longer have access to my site's administration

[joaquiman]

Hello,
I no longer have access to my site's administration (https://teamoptc.com/administrator/) -> Forbidden
You don't have permission to access this resource. or error 404. Who knows a solution? please

ps: I've already restored the database from 2 weeks ago (as much as possible)

[toivo]

Forbidden
You don't have permission to access this resource.

That message does not come from Joomla 4. Please contact your host for an explanation.

The frontend of your site displays the message "The server returned a "500 - Whoops, looks like something went wrong."

Go to File Manager in the cPanel or a similar page, provided by your host, and write-enable the file configuration.php in the main Joomla folder. Edit the file and make the following modifications:

Code: Select all

	public $debug = true;
	public $error_reporting = 'maximum';

Joomla will now display a detailed error message, showing the name and line number of the script where the error occurs, followed by the PHP call stack. Copy and paste those lines into your reply.

[Webdongle]

...

ps: I've already restored the database from 2 weeks ago (as much as possible)

That's the cause.
1. Why did you have to 'restore the database
2. Do you have a complete backup (N.B. a database and files that belong to each other?

[joaquiman]

Forbidden
You don't have permission to access this resource.

That message does not come from Joomla 4. Please contact your host for an explanation.

The frontend of your site displays the message "The server returned a "500 - Whoops, looks like something went wrong."

Go to File Manager in the cPanel or a similar page, provided by your host, and write-enable the file configuration.php in the main Joomla folder. Edit the file and make the following modifications:

Code: Select all

	public $debug = true;
	public $error_reporting = 'maximum';

Joomla will now display a detailed error message, showing the name and line number of the script where the error occurs, followed by the PHP call stack. Copy and paste those lines into your reply.

Thank you for your message.


app.engine=php
app.engine.version=7.4
http.firewall=none
environment=production
container.image=stable64

[joaquiman]

...

ps: I've already restored the database from 2 weeks ago (as much as possible)

That's the cause.
1. Why did you have to 'restore the database
2. Do you have a complete backup (N.B. a database and files that belong to each other?

Thank you for your message.

1. Ovh ask me to do this...
2. No

[Webdongle]

1. Ovh?
2. You could ask the Host to roll back the server. If not there is a possibility your site is broke

[joaquiman]

1. Ovh?
2. You could ask the Host to roll back the server. If not there is a possibility your site is broke

1. https://www.ovhcloud.com/fr/

2. [censored]

[toivo]

app.engine=php
app.engine.version=7.4

That information is not the detailed PHP error message and a call stack. Are you sure you modified those two lines in the file configuration.php?

[joaquiman]

app.engine=php
app.engine.version=7.4

That information is not the detailed PHP error message and a call stack. Are you sure you modified those two lines in the file configuration.php?

It is ?

[toivo]

It is ?

No.

The website is now unable to connect to the database:

Code: Select all

Joomla\Database\Exception\
ConnectionFailureException
Could not connect to database: Access denied for user [ redacted ] (using password: YES)

Contact the support team of your host and find out the reason why the backend is unavailable. Go to the cPanel or a similar page, provided by your host, and set the username and password for the database, then use the File Manager from the cPanel to write-enable and edit the file configuration.php in the main Joomla folder and modify the lines containing the database connection details, for example:

Code: Select all

        public $dbtype = 'mysqli';
	public $host = 'localhost';
	public $user = 'mydbuser';
	public $password = 'mydbpassword';
	public $db = 'mydbname';

[joaquiman]

Thank you so much for your help!

There was a problem with the ‘index’ file which was renamed ‘iindex’ with 2 ‘i’.

However, I'm now looking for the identifiers. Jsp si vous avec une technique pour récupérer ça ?

[joaquiman]

I don't have user line. Can you help me ? please

[toivo]

Cheers, good to hear that the site is now working!

I'm now looking for the identifiers. Jsp si vous avec une technique pour récupérer ça ?

Not sure what you mean. Can you please explain what is meant by 'identifiers' and say it in English in this forum.

[joaquiman]

I'm trying to reset my login but it doesn't work, even when I create a new line in the table. I used https://www.danielmorell.com/tools/joom ... -generator

[toivo]

That is the first page in the list of database tables in phpMyAdmin. Browse to the next pages and you will find lm2vw_users.

[joaquiman]

That is the first page in the list of database tables in phpMyAdmin. Browse to the next pages and you will find lm2vw_users.

I changed my email address with the generator. On the login page it said it was invalid. So I created another user and another password and it was still invalid.

[toivo]

Follow this tutorial, if you need to reset your backend password or create a new user as a member of the Super Users usergroup:
How do you recover or reset your admin password?

[Webdongle]

...
ps: I've already restored the database from 2 weeks ago (as much as possible)

If something broke in the database and you 'restored' it "from 2 weeks ago (as much as possible)" then the chances are you have irrevocably broke your site.

With no backup your only hope (imho) is to get your Host to roll back to a time when your site was working.

[joaquiman]

Follow this tutorial, if you need to reset your backend password or create a new user as a member of the Super Users usergroup:
How do you recover or reset your admin password?

I've run the tutorial several times and always get the same error message. I can't see what the problem is.

[joaquiman]

Do I recreate a topic now that my initial problem has been solved?

[Webdongle]

Your initial problem has not been solved.

[joaquiman]

Hello,
I followed this tutorial to get new login details but it doesn't work. Does anyone know a solution?

https://docs.joomla.org/How_do_you_reco ... assword%3F

[AMurray]

The methods outlined in https://docs.joomla.org/How_do_you_reco ... assword%3F are the only methods for resetting a Super User password.

Which of the two methods were you using?

Method 1 escalates another existing administrator-level user to "Super User" temporarily (the docs say this works for users with "Author" permissions or higher (i.e. Publisher, Manager, Administrator in a default install)

Method 2 has two options - (a) directly edit the database user record, and copy in the example password in the above docs (in hashed format not 'real text') or to (b) add a new super user.

Which of these (Option 1 or Option 2a or Option 2b) were you trying and failed?

[Webdongle]

@AMurray

Those methods aren't working for the OP because he has broke his database.

... I've already restored the database from 2 weeks ago (as much as possible)

The clue is in the phrase '(as much as possible)'

[joaquiman]

Maybe my translation isn’t accurate. Following the initial error: "Forbidden You don't have permission to access this resource" or "Error 404", the OVH Cloud team advised me to restore a backup, but it didn’t work. Then I discovered that a file had been renamed incorrectly: the index file had been renamed to iindex (with two "i"s). After fixing this, I was able to access the login page.

However, I now have another issue: I can’t log in, even after creating new users using both methods described in the tutorial.

[joaquiman]

The methods outlined in https://docs.joomla.org/How_do_you_reco ... assword%3F are the only methods for resetting a Super User password.

Which of the two methods were you using?

Method 1 escalates another existing administrator-level user to "Super User" temporarily (the docs say this works for users with "Author" permissions or higher (i.e. Publisher, Manager, Administrator in a default install)

Method 2 has two options - (a) directly edit the database user record, and copy in the example password in the above docs (in hashed format not 'real text') or to (b) add a new super user.

Which of these (Option 1 or Option 2a or Option 2b) were you trying and failed?

Option 2a and 2b

[Webdongle]

... Following the initial error: "Forbidden You don't have permission to access this resource" or "Error 404", the OVH Cloud team advised me to restore a backup, but it didn’t work....

From your first post it appears that you didn't restore the backup correctly. The database and the files must be from when the site was working. Also the broken site files/database must be removed/emptied before restoring a backup.

If you did not do that then fiddling about with a 'patchwork quilt approach is (imho) a waste of time. You might as well use wamp on localhost to start from scratch. You can copy/paste from the database to recreate Articles in your new site.