Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
0 registered members (), 48 guests, and 217 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
PianoWorld
PianoWorld
Parsonsfield, Maine (U.S.)
Posts: 80
Joined: October 2008
Show All Member Profiles 
Top Posters(30 Days)
isaac 20
Gizmo 13
Ruben 11
Morgan 3
BB 2
Abbott 2
Latest Photos
Testing to drag photos
Comfortable Cats
Test
BSA photos
Chinese Buddhist temple.
Previous Thread
Next Thread
Print Thread
Database Error after update #257972
01/16/16 08:43 AM
01/16/16 08:43 AM
Joined: Sep 2008
Posts: 2
D
designer Offline OP
stranger
designer  Offline OP
stranger
D
Joined: Sep 2008
Posts: 2
We have UBB.Threads version 7.5.3
We get error database connection only visible to administrator

after change the 0 to 1 in my mysql.inc.php i see the following error :

Script:
Line#:
SQL Error: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)
SQL Error #: 2049
Query: Unable to connect to the database!

Please click back to return to the previous page.

Please help to solve the problem

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: Database Error after update [Re: designer] #257973
01/16/16 12:53 PM
01/16/16 12:53 PM
Joined: Dec 2003
Posts: 5,898
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,898
Lutz,FL
It sounds like your host has updated your mysql version.
Which means that your old encrypted password can't be converted to the new version.
First thing is to confirm what version of mysql you have now.
with a older version of ubb it may not be compatible with the mysql version.
Second if it is then you probably just need to re-enter a user name and password for the database.
If you can't keep the old username and password you will need to edit your config.inc.php file for ubb and make the changes.


Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Re: Database Error after update [Re: designer] #257974
01/16/16 08:13 PM
01/16/16 08:13 PM
Joined: Jun 2006
Posts: 16,930
Portland, OR; USA
Gizmo Offline
UBB.threads Developer
Gizmo  Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,930
Portland, OR; USA
More specifically, it sounds like your host upgraded the MySQL server and didn't request clients update their passwords; mysql_upgrade cannot and does not upgrade passwords, nor does it warn about them needing updated in some versions.

I'm thinking that if you access your hosting control panel and update your password that it'd likely start working again. Basically, older passwords on the machine are stored with a different/shorter hash than what newer passwords are generated as, and in the latest upgrade they're now longer allowing the shorter hash to be used (I believe your host could "fix" this if they'd use the "useLegacyAuth" setting in MySQL).


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!

Shout Box
Today's Birthdays
No Birthdays
Recent Topics
Custom Insert won't save
by Baldeagle. 06/18/18 07:44 PM
New Image capabilities ver 7.6.1
by Abbott. 06/14/18 02:28 PM
Thread deleted?
by Lisanne. 06/05/18 11:13 AM
random 500 server errors on post
by Bad Frog. 05/31/18 09:34 AM
Upgraded from 7.6.0 to 7.6.1.1
by BB. 05/30/18 12:33 PM
Forum Statistics
Forums36
Topics35,121
Posts191,324
Members12,085
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.2
(Preview build 20180524)