Previous Thread
Next Thread
Print Thread
Hop To
Lost access to database following server restore #258891 01/11/2017 3:37 PM
Joined: Jul 2005
Posts: 137
Crasher Offline OP
Member
OP Offline
Member
Joined: Jul 2005
Posts: 137
Hello all, its been a while since i was last here - a belated happy new year to you all.

Last weekend, the server my site is hosted on went belly-up, taking out all of the sites it was hosting. After many days of failed rebuilds and restores from backup, i now have access to my hosted account - allbeit on a different server name now.
However when you land on the website all you get is the following messages...
UBB Message
We encountered a problem. The reason reported was
Database error only visible to forum administrators

Please click [ Back ] to return to the previous page.

Its been a while since i last needed to tinker with my site (i like things when they are stable) - i seem to recall that there is a potential path to put in to get access to the admin page? Or if i've wrongly remembered, what files do i need to get at to re-jig?

Many thanks

Barry

Re: Lost access to database following server restore [Re: Crasher] #258892 01/11/2017 4:51 PM
Joined: Jun 2006
Posts: 15,848
Gizmo Online Tapedshut
UBB.threads Developer
Online Tapedshut
UBB.threads Developer
Joined: Jun 2006
Posts: 15,848
If you're on a different server now the paths to your hosting and the database access information are all likely different; follow the instructions in the UBBWiki Migration Guide to get yourself back up and running. In this case, since your host moved everything for you, start at the Config step.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Lost access to database following server restore [Re: Gizmo] #258893 01/12/2017 7:06 AM
Joined: Jul 2005
Posts: 137
Crasher Offline OP
Member
OP Offline
Member
Joined: Jul 2005
Posts: 137
Originally Posted by Gizmo
If you're on a different server now the paths to your hosting and the database access information are all likely different; follow the instructions in the UBBWiki Migration Guide to get yourself back up and running. In this case, since your host moved everything for you, start at the Config step.

Cheers Gizmo
Good to see some familiar faces still lurking here smile

Re: Lost access to database following server restore [Re: Crasher] #258895 01/12/2017 10:33 PM
Joined: Jun 2006
Posts: 15,848
Gizmo Online Tapedshut
UBB.threads Developer
Online Tapedshut
UBB.threads Developer
Joined: Jun 2006
Posts: 15,848
:snicker: no problem, just writing documentation and coding; ask Isaac, I go overboard with it.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Lost access to database following server restore [Re: Crasher] #258896 01/13/2017 5:39 AM
Joined: Jul 2005
Posts: 137
Crasher Offline OP
Member
OP Offline
Member
Joined: Jul 2005
Posts: 137
Okay i now have access (to a degree).
None of the formatting is present (ie looks like the landing page has escaped from the early 80's!) so i probably need to clear all the caches down (cached paths to the css perhaps?) However...

Next issue is that i get a forbidden error when i click on the login link - so obviously the restore has trashed the finely crafted (and specific) UBB file permissions.

Anyone have a handly list of what needs to be set to what? I have sever access so can go through and manually set them accordingly.

Cheers

Re: Lost access to database following server restore [Re: Crasher] #258897 01/13/2017 12:08 PM
Joined: Jun 2006
Posts: 15,848
Gizmo Online Tapedshut
UBB.threads Developer
Online Tapedshut
UBB.threads Developer
Joined: Jun 2006
Posts: 15,848
Have you updated the paths and urls? possible that something stale is just idling around; if you're going to purge caches via FTP you'll delete everything from templates/compile and /cache then run the content rebuilder in the Control Panel.

The UBB.threads System Requirements Test will report quite a bit of information about your hosting environment, including your full paths.

A rule of thumb about the permissions is 666 for files, 777 for directories; however, some environments are overzealous and will not let scripts execute from a directory that's chmodded 777 (in which case you'd chmod the directory that UBB.threads is in to 755).


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Lost access to database following server restore [Re: Gizmo] #258898 01/13/2017 12:38 PM
Joined: Jul 2005
Posts: 137
Crasher Offline OP
Member
OP Offline
Member
Joined: Jul 2005
Posts: 137
Thanks for the info (again)

After crawling through everything, the main culprit was the directory permissions on the top level ubbthreads7 directory - that was 750.
Quick change to 755 and i can log in.
Now to trawl through and sort out the minor issues smile

P.S. Site checker Test was most helpful - cheers


Forum Search
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Search feature encountering an Error message
by jorb - 11/20/2019 12:06 AM
Followed List v7.7.2 Question
by Ruben - 11/12/2019 12:22 PM
UBB Dev
by JAISP - 11/03/2019 11:01 AM
Exceeded Number of attachments
by rbrtgrmn - 11/02/2019 9:57 PM
Forum New User Registration
by kf6zpl - 10/25/2019 10:45 AM
Who's Online Now
3 registered members (JAISP, isaac, jorb), 51 guests, and 336 spiders.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Amusing Terain Scenics
Amusing Terain Scenics
by isaac, August 19
Sky places
Sky places
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Snapshot build 20191023)