Web based family history software

Question access of login page denied, wt 1.7.16 [SOLVED]

More
3 years 6 months ago #1 by MAV
Good evening,
today I had the need to clean up the table of access data which had grown so much. The thing went quite satisfactorily, but suddenly the editing stopped and only showed me the error message "You do not have permission to view this page".

It seems as if I had been logged out of the control panel. The automatic logoff should only take place after 7200 seconds. In my opinion, this time had not yet been reached. Especially since the count down should always be restarted by my ongoing work.

A new logon was not possible and only resulted in the same error message as described above. Also, other functions such as a new user request were no longer available. I was able to open the switch for changing the language, but it had no effect.

First of all I had backed up my database with phpMyAdmin. I hope that it is not corrupted. Is there a back door to get back into the control panel?

Any help is appreciated.
Nightly greetings from Micha

Productive: webtrees 2.1.16
justlight theme
php 7.4

Please Log in or Create an account to join the conversation.

  • fisharebest
  • Away
  • Administrator
  • Administrator
More
3 years 6 months ago #2 by fisharebest
Replied by fisharebest on topic access of login page denied, wt 1.7.16
This is caused by the "site access rules".

Your site thinks you are a search-engine. You will see "Search engine" in the title bar in your web-browser.

Therefore it does not allow you to access the login page.

These rules are stored in the table wt_site_access_rule.

Find the one that is blocking you and edit/delete it?

Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

More
3 years 6 months ago #3 by MAV
Replied by MAV on topic access of login page denied, wt 1.7.16
Hi Greg,

thank you for the hint.

I found in my data base backup this row:

(29665, '2020-09-20 17:42:05', 'error', '/var/www/web839/html/micha/micgen/app/Statement.php:85 SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ''4294967295-0-CCBot/2.0 ( commoncrawl.org/faq/ )-deny'' for key ''ahn_site_access_rule_ix1''\n#0 /app/Statement.php:85 PDOException("SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ''4294967295-0-CCBot/2.0 ( commoncrawl.org/faq/ )-deny'' for key ''ahn_site_access_rule_ix1''")\n#1 /admin_site_access.php:87 execute([array])\n', '87.123.206.253', 1, 1);

Could this be the suspected candidate?

Greetings from Stuttgart (Germany)
Micha

Productive: webtrees 2.1.16
justlight theme
php 7.4

Please Log in or Create an account to join the conversation.

  • fisharebest
  • Away
  • Administrator
  • Administrator
More
3 years 6 months ago #4 by fisharebest
Replied by fisharebest on topic access of login page denied, wt 1.7.16
> Could this be the suspected candidate?

Unlikely. This is blocking browsers/crawlers that identify as "CCBot/2.0".

You probably have an entry with '%' in the user-agent-pattern column.

Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

More
3 years 6 months ago #5 by MAV
Replied by MAV on topic access of login page denied, wt 1.7.16
Hi Greg,

Hello, Greg,

I have deleted all entries in the wt_site_access_rule, although new entries have of course been added automatically in the meantime. These entries cannot actually cause the fault. So the error has not yet been found.

Is an upgrade to 2.0 in the current version an option? And can the old database be connected to the new installation and converted?

Micha

Productive: webtrees 2.1.16
justlight theme
php 7.4

Please Log in or Create an account to join the conversation.

  • fisharebest
  • Away
  • Administrator
  • Administrator
More
3 years 6 months ago #6 by fisharebest
Replied by fisharebest on topic access of login page denied, wt 1.7.16
> have deleted all entries in the wt_site_access_rule

If you deleted them all, you would have deleted the rules that allow you access.

You can find the default values here:

github.com/fisharebest/webtrees/blob/1.7...hema/Migration17.php
github.com/fisharebest/webtrees/blob/1.7...hema/Migration25.php
github.com/fisharebest/webtrees/blob/1.7...hema/Migration27.php
github.com/fisharebest/webtrees/blob/1.7...hema/Migration29.php
github.com/fisharebest/webtrees/blob/1.7...hema/Migration33.php

> Is an upgrade to 2.0 in the current version an option?

Yes. In 2.0, we use a completely different technique to block search engines, and the site-access-rule table is deleted.

Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

More
3 years 6 months ago #7 by MAV
Thank you, Greg,

for your support. I did it and installed wt 2.0.7 in an empty directory and connected it to my data base. All individuals, families, sources, archives, media objects, and shared notes could be preserved.

The first action after the installation was a gedcom export of all data to import them into my local webtrees installation.

Greetings from Micha

Productive: webtrees 2.1.16
justlight theme
php 7.4

Please Log in or Create an account to join the conversation.

Moderators: makitso
Powered by Kunena Forum
}