Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
2 registered members (isaac, mmkk), 61 guests, and 267 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
TGCsanderson
TGCsanderson
Hackelton U.K.
Posts: 67
Joined: September 2007
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 15
FREAK 11
M4TT 10
Ruben 5
mmkk 5
isaac 4
Latest Photos
Chinese Buddhist temple.
My buddha beads.
Rendered Walls
Multi-Screen wallpaper
Stockholm Metro
Previous Thread
Next Thread
Print Thread
Lost access to database following server restore #258891
01/11/17 03:37 PM
01/11/17 03:37 PM
Joined: Jul 2005
Posts: 137
Midlands, UK
Crasher Offline OP
member
Crasher  Offline OP
member
Joined: Jul 2005
Posts: 137
Midlands, UK
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

Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
Re: Lost access to database following server restore [Re: Crasher] #258892
01/11/17 04:51 PM
01/11/17 04:51 PM
Joined: Jun 2006
Posts: 16,785
Portland, OR; USA
Gizmo Offline
UBB.threads Developer
Gizmo  Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,785
Portland, OR; USA
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.
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/17 07:06 AM
01/12/17 07:06 AM
Joined: Jul 2005
Posts: 137
Midlands, UK
Crasher Offline OP
member
Crasher  Offline OP
member
Joined: Jul 2005
Posts: 137
Midlands, UK
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/17 10:33 PM
01/12/17 10:33 PM
Joined: Jun 2006
Posts: 16,785
Portland, OR; USA
Gizmo Offline
UBB.threads Developer
Gizmo  Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,785
Portland, OR; USA
: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.
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/17 05:39 AM
01/13/17 05:39 AM
Joined: Jul 2005
Posts: 137
Midlands, UK
Crasher Offline OP
member
Crasher  Offline OP
member
Joined: Jul 2005
Posts: 137
Midlands, UK
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/17 12:08 PM
01/13/17 12:08 PM
Joined: Jun 2006
Posts: 16,785
Portland, OR; USA
Gizmo Offline
UBB.threads Developer
Gizmo  Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,785
Portland, OR; USA
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.
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/17 12:38 PM
01/13/17 12:38 PM
Joined: Jul 2005
Posts: 137
Midlands, UK
Crasher Offline OP
member
Crasher  Offline OP
member
Joined: Jul 2005
Posts: 137
Midlands, UK
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


Shout Box
Today's Birthdays
No Birthdays
Recent Topics
Shout Box Sound Effect
by M4TT. 11/29/17 08:28 PM
Ad island
by TGCsanderson. 11/25/17 06:41 PM
Taking to long to connect to DB
by AstroCat. 11/24/17 12:34 PM
I want to update forum but can't find license
by dimaninc. 11/23/17 10:51 AM
Forum Statistics
Forums36
Topics35,014
Posts190,533
Members12,045
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.1
(Snapshot build 20171106)