This Help forum is for issues relates to the latest release (1.7.10/11/12). For issues related to development versions please use their own Help forum.
Before asking for help please read "How to request help" by clicking on that tab above here."

TOPIC: [SOLVED] Can't View Site - MariaDB Updated

Can't View Site - MariaDB Updated 2 weeks 3 days ago #1

  • richard
  • richard's Avatar
  • Offline
  • New
  • Posts: 15
On my underwoodfamilytree.com site I have been successfully running webtrees 1.7.11 software. I've not been on the site for just over a week and today when I tried to access the site all I could get is 404 not found messages.

The believe when I installed the site a few months ago the site was running on site was using 10.1.35-MariaDB that has been recently upgraded to 10.2.18.

According to the webtrees spec the webtrees software should run OK on the current spec wiki.webtrees.net/en/System_requirements but I am wondering if the recent MariaDB update has caused my difficulty.

I have other sites running WordPress OK, including a including a Wordpress sub-domain of the webtrees site genealogy.underwoodfamilytree.com/ that also runs OK.

Can anyone offer any advice or guide me in the right direction for getting my site back online?
Have been dabbling in my family tree for years but had never used Webtrees until I used Webtrees 1.7.11 to to created my first Webtrees site in September 2018
underwoodfamilytree.com
Hosted on Linux server with PHP 7.0.32 and
10.1.35-MariaDB (updated to 10.2.18)
The administrator has disabled public write access.

Can't View Site - MariaDB Updated 2 weeks 3 days ago #2

  • fisharebest
  • fisharebest's Avatar
  • Online
  • Administrator
  • Posts: 10573
The usage statistics show that about 6% of all sites use Maria 10.2 (and 1.5% use 10.3), so this shouldn't be an issue.
dev.webtrees.net/statistics.html

In any case, a 404 is the last error I would expect from a database problem.

> Can anyone offer any advice or guide me in the right direction for getting my site back online?

1) check that the webtrees files still exist on your server (e.g. using FTP)

2) check your webserver config, and that it will link your URL to this location. I see you use lightspeed. I'm afraid I'm unfamiliar with this server.

BTW - I note also that your SSL certificate (from letsencrypt) has expired a few weeks ago. Is this something you maintain, or does your web-provider do it for you?
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net
The administrator has disabled public write access.

Can't View Site - MariaDB Updated 2 weeks 2 days ago #3

  • richard
  • richard's Avatar
  • Offline
  • New
  • Posts: 15
1. can view all the files and folders on cpanel - They all seem to be there.

2. config is correct and links to correct location.

SSL - Using Letsencrypt in cpanel. When I try to issue new certificate I get following error:

There was a problem processing your request
Error issuing certificate
Failed to issue certificate
Error connecting to service: acme: error code 0 "urn:acme:error:serverInternal": The service is down for maintenance or had an internal error.
Have been dabbling in my family tree for years but had never used Webtrees until I used Webtrees 1.7.11 to to created my first Webtrees site in September 2018
underwoodfamilytree.com
Hosted on Linux server with PHP 7.0.32 and
10.1.35-MariaDB (updated to 10.2.18)
The administrator has disabled public write access.

Can't View Site - MariaDB Updated 2 weeks 2 days ago #4

  • fisharebest
  • fisharebest's Avatar
  • Online
  • Administrator
  • Posts: 10573
> 1. can view all the files and folders on cpanel - They all seem to be there.
> 2. config is correct and links to correct location.

So, you are saying that the file index.php exists, and that your webserver config will connect the URL underwoodfamilytree.com/index.php to this file, yet your webserver gives a 404 for this URL.

Check your webserver error logs?
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net
Last Edit: 2 weeks 2 days ago by fisharebest.
The administrator has disabled public write access.

Can't View Site - MariaDB Updated 2 weeks 2 days ago #5

  • richard
  • richard's Avatar
  • Offline
  • New
  • Posts: 15
Yes, index.php exists at /underwoodfamilytree.com/webtrees

The document root for the site is /underwoodfamilytree.com/webtrees

The directory where the files exist for the underwoodfamilytree.com is at Underwoodfamilytree.com/webtrees and that is the directory in which the index.php and all the other webtrees files are located. That's never been changed since my first setup.

No error file has been created at that location error in the file immediately above.

The only errors available to me in cpanel are similar to: File not found [/home/username/underwoodfamilytree.com/webtrees/]

I've taken out a ticket with my hosting company but they've not got back to me yet.
Have been dabbling in my family tree for years but had never used Webtrees until I used Webtrees 1.7.11 to to created my first Webtrees site in September 2018
underwoodfamilytree.com
Hosted on Linux server with PHP 7.0.32 and
10.1.35-MariaDB (updated to 10.2.18)
The administrator has disabled public write access.

Can't View Site - MariaDB Updated 2 weeks 2 days ago #6

  • richard
  • richard's Avatar
  • Offline
  • New
  • Posts: 15
My hosting company haven't found any configuration errors.

Everything points to where it should point to, and the site root is listed correctly on cPanel. There are no errors logged apart from multiple 404 errors to say that the content isn't there, which is odd as all the files and folders are in their correct place.

This is completely weird and both my hosting company and myself are stumped. Even installing a full backup has not cured things.

I have several other sites on the same server, all working correctly and with no errors. What is really weird is that even a reinstall to a time before I last accessed the site without problems has not solved the problem.

Hosting company are still working on it, and I'll let you know what the problem was if I ever get it sorted. At the end of the day I may have to delete the site, do a completely fresh install, and download a fresh gedcom file. Only want to do that as a last resort though.

A better option would be to find out what has caused the problem in case the same thing happens again. Hosting company still working on there end. Anyone else got any suggestions?
Have been dabbling in my family tree for years but had never used Webtrees until I used Webtrees 1.7.11 to to created my first Webtrees site in September 2018
underwoodfamilytree.com
Hosted on Linux server with PHP 7.0.32 and
10.1.35-MariaDB (updated to 10.2.18)
The administrator has disabled public write access.

Can't View Site - MariaDB Updated 2 weeks 2 days ago #7

  • kcshaw
  • kcshaw's Avatar
  • Offline
  • New
  • Posts: 7
There's got to be a typo or permission something somewhere. Try putting the site in a different subfolder or subdomain, maybe? If that works, backtrack from there. Something is likely pointing wrong, maybe a whitespace or something.
The administrator has disabled public write access.

Can't View Site - MariaDB Updated 2 weeks 2 days ago #8

  • fisharebest
  • fisharebest's Avatar
  • Online
  • Administrator
  • Posts: 10573
I have never used lightspeed, but when other webservers (nginx and apache) give a 404 error, they include a message in their error log saying exactly which URL and which file gave the error.

Here's one from the webtrees.net server.
2018/11/30 15:50:52 [error] 19264#19264: *7779174 open() "/home/webtrees/dev.webtrees.net/demo-dev/themes/webtrees/css-2.0.0/favicon192.png" failed (2: No such file or directory), client: 78.246.175.5, server: dev.webtrees.net, request: "GET /demo-dev/themes/webtrees/css-2.0.0/favicon192.png HTTP/2.0", host: "dev.webtrees.net"

Does lightspeed give anything similar?

It would tell you whether it was configured to look in the right place....
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net
The administrator has disabled public write access.
Do you need a web hosting solution for your webtrees site?
If you prefer a host that specialises in webtrees, the following page lists some suppliers able to provide one for you: 

Can't View Site - MariaDB Updated 2 weeks 2 days ago #9

  • richard
  • richard's Avatar
  • Offline
  • New
  • Posts: 15
It gives something similar. It lists time and date, the address to the file and a 'file not found' message.

There are a whole load of 'file not found' messages.

The weird thing is that in every message, the route to the file is correct, and my file manager confirms that the file in question is at that location.
Have been dabbling in my family tree for years but had never used Webtrees until I used Webtrees 1.7.11 to to created my first Webtrees site in September 2018
underwoodfamilytree.com
Hosted on Linux server with PHP 7.0.32 and
10.1.35-MariaDB (updated to 10.2.18)
The administrator has disabled public write access.

Can't View Site - MariaDB Updated 2 weeks 2 days ago #10

  • richard
  • richard's Avatar
  • Offline
  • New
  • Posts: 15
kcshaw wrote:
There's got to be a typo or permission something somewhere. Try putting the site in a different subfolder or subdomain, maybe? If that works, backtrack from there. Something is likely pointing wrong, maybe a whitespace or something.

I'm thinking along the same lines, but I have checked (and my hosting company have also checked) that the correct folder is being posted to.

I do have a sub-domain that works fine (Wordpress) genealogy.underwoodfamilytree.com but the main domain with webtrees on it doesn't work despite the sub-domain working. It has got to be (I think) something that is pointing incorrectly, but neither myself nor my hosting company can find anything that is not pointing correctly.

Hosting company tecs are usually excellent, thorough and quick. They are still looking but stumped at present.
Have been dabbling in my family tree for years but had never used Webtrees until I used Webtrees 1.7.11 to to created my first Webtrees site in September 2018
underwoodfamilytree.com
Hosted on Linux server with PHP 7.0.32 and
10.1.35-MariaDB (updated to 10.2.18)
The administrator has disabled public write access.

Can't View Site - MariaDB Updated 2 weeks 1 day ago #11

  • richard
  • richard's Avatar
  • Offline
  • New
  • Posts: 15
Sorted.

My site had been running on [/home/username/underwoodfamilytree.com/webtrees/]

All the correct files were in place there, just as they always have been.

The route to those files were correctly formed just as they always have been.

THEN: My hosting company upgraded to the latest version of CPanel/WHM

The new CPanel/WHM had a new setting that is not in the previous version, activated by default, that restricts document roots to public_html - It automatically blocks access to sites where the root was not in public_html

My site worked correctly again as soon as my files were moved

from [/home/username/underwoodfamilytree.com/webtrees/]

to [/home/username/public_html/underwoodfamilytree.com/webtrees/]

Thank you to all those who made suggestions. Like we all thought, it was a routing problem. The site had always run correctly using the old route, but would not run on that route after the update to the latest CPanel/WHM

Richard
Have been dabbling in my family tree for years but had never used Webtrees until I used Webtrees 1.7.11 to to created my first Webtrees site in September 2018
underwoodfamilytree.com
Hosted on Linux server with PHP 7.0.32 and
10.1.35-MariaDB (updated to 10.2.18)
The administrator has disabled public write access.

[SOLVED] Can't View Site - MariaDB Updated 2 weeks 1 day ago #12

  • richard
  • richard's Avatar
  • Offline
  • New
  • Posts: 15
Problem solved.
Have been dabbling in my family tree for years but had never used Webtrees until I used Webtrees 1.7.11 to to created my first Webtrees site in September 2018
underwoodfamilytree.com
Hosted on Linux server with PHP 7.0.32 and
10.1.35-MariaDB (updated to 10.2.18)
The administrator has disabled public write access.

Can't View Site - MariaDB Updated 2 weeks 1 day ago #13

  • kcshaw
  • kcshaw's Avatar
  • Offline
  • New
  • Posts: 7
Awesome. Well, not "awesome" it happened, just that you got it figured out. Thanks for the follow-up.
The administrator has disabled public write access.
Powered by Kunena Forum