Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
3 registered members (JAISP, id242, Ruben), 20 guests, and 36 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Pilgrim
Pilgrim
NH, USA
Posts: 227
Joined: December 2003
Show All Member Profiles 
Top Posters(30 Days)
id242 142
Bad Frog 106
Gizmo 101
JAISP 33
Morgan 33
teamzr1 26
Ruben 25
driv 15
JPG 11
Latest Photos
Some pictures for fun
test for attachment sizes
A gallery with animated GIFs
Lazy fox, drops, and a light house.
Welcome to poet
Previous Thread
Next Thread
Print Thread
#258891 - 01/11/17 03:37 PM Lost access to database following server restore  
Joined: Jul 2005
Posts: 137
Crasher Offline
member
Crasher  Offline
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."
#258892 - 01/11/17 04:51 PM Re: Lost access to database following server restore [Re: Crasher]  
Joined: Jun 2006
Posts: 16,555
Gizmo Offline
UBB.threads Developer
Gizmo  Offline
UBB.threads Developer

Joined: Jun 2006
Posts: 16,555
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.


Forums: A Gardeners Forum
UBB.Threads: UBBWiki, UBBSkins, UBB.Sitemaps
Longtime Supporter & Beta Tester & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
#258893 - 01/12/17 07:06 AM Re: Lost access to database following server restore [Re: Gizmo]  
Joined: Jul 2005
Posts: 137
Crasher Offline
member
Crasher  Offline
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

#258895 - 01/12/17 10:33 PM Re: Lost access to database following server restore [Re: Crasher]  
Joined: Jun 2006
Posts: 16,555
Gizmo Offline
UBB.threads Developer
Gizmo  Offline
UBB.threads Developer

Joined: Jun 2006
Posts: 16,555
Portland, OR; USA
:snicker: no problem, just writing documentation and coding; ask Isaac, I go overboard with it.


Forums: A Gardeners Forum
UBB.Threads: UBBWiki, UBBSkins, UBB.Sitemaps
Longtime Supporter & Beta Tester & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
#258896 - 01/13/17 05:39 AM Re: Lost access to database following server restore [Re: Crasher]  
Joined: Jul 2005
Posts: 137
Crasher Offline
member
Crasher  Offline
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

#258897 - 01/13/17 12:08 PM Re: Lost access to database following server restore [Re: Crasher]  
Joined: Jun 2006
Posts: 16,555
Gizmo Offline
UBB.threads Developer
Gizmo  Offline
UBB.threads Developer

Joined: Jun 2006
Posts: 16,555
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).


Forums: A Gardeners Forum
UBB.Threads: UBBWiki, UBBSkins, UBB.Sitemaps
Longtime Supporter & Beta Tester & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
#258898 - 01/13/17 12:38 PM Re: Lost access to database following server restore [Re: Gizmo]  
Joined: Jul 2005
Posts: 137
Crasher Offline
member
Crasher  Offline
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
Fatal error using the new version 7.6
by ehm1. 02/28/17 08:58 PM
UBB.threads System Requirements Test
by Gizmo. 02/28/17 01:30 AM
Update to 7.6; mb_convert_case fatal error
by Z65Paul. 02/27/17 11:16 PM
V 7.60 Icon and no new posts issues
by teamzr1. 02/27/17 08:15 PM
UBB.threads v7.6.x Language Pack
by Gizmo. 02/27/17 03:32 PM
Forum Statistics
Forums36
Topics34,879
Posts189,543
Members11,967
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.0