My site down - Apache is functioning normally message

[bigo22924]

Hi, I believe the migration is now completed, now able to login to directadmin but my site http://speedwayworld.x10host.com/ changes to https://speedwayworld.x10host.com/ & displays a blank page with message;
"Apache is functioning normally" message this seems to be a common issue after migration from cpanel to directadmin.

Do i now wait for this issue to be resolved or is there anything i can do in directadmin btw my site was running wordpress

Thanks

 

[Anna]

You will need to tell wordpress to not use https (it is not supported on free hosting, and apache doesn't like https without a certificate and thus gives that message)

There are a couple options for doing that, see this article for how to do it by editing a file: https://wordpress.org/support/article/changing-the-site-url/

Optionally if you are comfortable with it you can edit the values for "siteurl" and "home" in the database, you'll find them in the table xx_options (where xx represents the prefix you have, often wp).

 

[bigo22924]

Hi Anna, i have viewed article https://wordpress.org/support/article/changing-the-site-url/ as recommended & was able to login to wp-admin & went to Administration > Settings > General & verified WordPress Address (URL) &
Site Address (URL) they were both correctly set as http://speedwayworld.x10host.com.

I then checked the database with phpmyadmin and went to wp_options & checked siteurl & home again both were set to http://speedwayworld.x10host.com.

I then entered first http://speedwayworld.x10host.com & then after speedwayworld.x10host.com into the browser both times it redirected to https://speedwayworld.x10host.com again.

Any suggestions

bigo22924

 

[bigo22924]

Hi , i just cleared my browser cache & site now appears but all my images do not as they all have https instead of http
will i have to edit all images in wordpress by hand.

bigo22924

 

[bigo22924]

Also some links on site have https instead of http so will i have to change the links in wordpress

bigo22924

 

[spacresx]

you only have to edit https links if they are related to your x10 website,
example: you can still have links like https://www.google.com
as long as they do not point to your x10 website.

if you installed any wordpress extensions or plugins before when you had https
you might need to check those to to make sure they use http instead.

 

[Anna]

Hi , i just cleared my browser cache & site now appears but all my images do not as they all have https instead of http
will i have to edit all images in wordpress by hand.

bigo22924

It might be well enough if you go into wordpress admin area, go to settings->permalinks and resave those to automatically sort all images and internal links.

 

[bigo22924]

Hi anna
i ran a backup from december 2019 to restore my site but it appears that the database was corrupted do you still have a copy of my site backup you made before the migration to restore my site

Many Thanks

bigo22924

 

[fitwebde]

Are you using cloudflare for https?

 

[Anna]

Hi anna
i ran a backup from december 2019 to restore my site but it appears that the database was corrupted do you still have a copy of my site backup you made before the migration to restore my site

Many Thanks

bigo22924

I have uploaded a copy of the database from the old server to the root of your account.

However, for support requests it is advised to use the forum account that is actually linked with the hosting account you want support for, this makes it easier for us to find your account as well as verify that you have the rights to that account.

Since the forum account is similar enough that I feel it reasonable that it is yours as well as the fact that the backup is uploaded to its own account I went ahead with the request this time.

For future requests, please use the forum account that is associated with your hosting, the username is bigo299x and password should be the same as you use to login on our mainpage.

 

[bigo22924]

Hi, The only forum account i have is this one i am logged into with i do not have a forum username as bigo299x
i can no longer log in to direct admin & getting the following error after clicking on cpanel button at login

Sign in Successful
Please standby while transfer you to your web hosting account.

An error has occurred forwarding your sign in. Retry

It redirects me to https://x10hosting.com/sso/main/caf

bigo22924

 

[bigo22924]

Also website blank page http://speedwayworld.x10host.com/

 

[bigo22924]

Hi anna, i can now login to directadmin but unable to access phpmyadmin, webmail, mysql manager

Webmail is giving this error in directadmin

DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database!
Please contact your server-administrator.


Phpmyadmin is giving this error in directadmin

YOUR CONNECTION HAS TIMED OUT
Either your request was invalid or the program hasn't completed your request.
Please notify the server admin

Thanks

bigo22924 http://speedwayworld.x10host.com/

 

[Anna]

Hi, The only forum account i have is this one i am logged into with i do not have a forum username as bigo299x
bigo22924

You do indeed have that forum account, it was created when you set up hosting back in 2013 for support purposes, same password as for SSO page should work.

Mysql for your server was just dealt with as it was misbehaving and should now work again.

 

[bigo22924]

Hi Anna,

the forum account you said was created when you set up hosting back in 2013 for support purposes, same password as for SSO page should work did not work so can only now login to forum as bigo22924.

Thanks for sending the database backup that go it mostly working but my wordpress website was blank & i found my wp-config file was blank, i entered my database info (reset mysql password in directadmin) & tested.

The site then gave the original error http://speedwayworld.x10host.com/ changes to https://speedwayworld.x10host.com/ & displays a blank page with message;
"Apache is functioning normally" which i have now corrected apart from some links & images diverting https instead of http.

Many Thanks

bigo22924

 

[Anna]

Hi Anna,

the forum account you said was created when you set up hosting back in 2013 for support purposes, same password as for SSO page should work did not work so can only now login to forum as bigo22924.

Thanks for sending the database backup that go it mostly working but my wordpress website was blank & i found my wp-config file was blank, i entered my database info (reset mysql password in directadmin) & tested.

The site then gave the original error http://speedwayworld.x10host.com/ changes to https://speedwayworld.x10host.com/ & displays a blank page with message;
"Apache is functioning normally" which i have now corrected apart from some links & images diverting https instead of http.

Many Thanks

bigo22924

As for images/links, try re-saving permalinks in wordpress.

Ok, if you can't get to that forum account that means you'll have to remember to always include information that allows us to look the account up, and depending on what is needed you would need to verify yourself as owner in some way (sending an email or providing information only owner would know would be possible solutions). With the backup I saw no issue with providing as I was uploading it to the account it belongs.

 

[bigo22924]

Hi Anna,

Thanks for all your help, for images/links, try re-saving permalinks in wordpress did not work have manually changed links in the pages or posts with the issues.

Hopefully i should have no further issues.

bigo22924