Previous Thread
Next Thread
Print Thread
Hop To
#257972 01/16/2016 8:43 AM
Joined: Sep 2008
Posts: 2
stranger
OP Offline
stranger
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

Joined: Dec 2003
Posts: 6,222
Likes: 32
Online Yawn
Joined: Dec 2003
Posts: 6,222
Likes: 32
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
Joined: Jun 2006
Posts: 15,976
Likes: 41
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,976
Likes: 41
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.
Do you need Forum Install or Upgrade Services?
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!

Link Copied to Clipboard
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Quick Help on issue changing forum styles
by Mors - 09/29/2020 7:59 PM
Individual Post Count Adjustments?
by FREAK - 09/25/2020 11:17 PM
Like unlike bug?
by Morgan - 09/24/2020 5:03 PM
looking to renew :)
by Mors - 09/23/2020 7:52 PM
test
by Mors - 09/23/2020 7:51 PM
Who's Online Now
2 members (Ruben, JAISP), 72 guests, and 57 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
gallery test
gallery test
by Mors, September 23
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Powered by UBB.threads™ PHP Forum Software 7.7.5
(Snapshot build 20200925)