Previous Thread
Next Thread
Print Thread
Hop To
#168050 11/10/2006 6:58 PM
Joined: Nov 2006
Posts: 3,095
Likes: 1
Carpal Tunnel
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095
Likes: 1
Wondering if anyone knows the proper steps for doing an
upgrade of MySQL and PHP for use with the new UBBT 7.01?

I have UBBT 6.5.1.1 MySQL 3.23.58 and PHP 4.4.1

I updated MySQL to 5.0.27 but now I get errors on UBBT 6.5.1.1

Quote
Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client

Quote
Warning: table_wrapper(c:/data/www/sitename/html/ubbthreads/templates//tbopen.tmpl): failed to open stream: No such file or directory in c:\data\www\sitename\html\ubbthreads\ubbt.inc.php on line 1419

What is the appropriate way to upgrade to the latest versions
of MySQL and PHP in order to use with UBBT 7.01 on Windows Server 2003 and then run the import scripts to bring over my older posts.
 

 

Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Simply put, the way that MySQL stores user passwords changed in version 4.0; you have a couple of choices:
1. Reset your password, all is well.
2. Set MySQL to run passwords how it used to; its again fairly easy and an edit in the my.cnf, although I'm not sure of the exact steps, just google it for a full answer.

As for the PHP error, I'm not entirely sure off hand, but I'm guessing its due to the double // before tbopen.tmpl


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!
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Some quick googling on the password format returns:
1. Edit /etc/my.cnf (in *nix), or C:\my.cnf (in Win)
2. Under [mysqld] add: old-passwords

Note that I would more recommend you reset your password than change the password type; but its your choice how to repair the issue.


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!
Joined: Nov 2006
Posts: 3,095
Likes: 1
Carpal Tunnel
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095
Likes: 1
Thanks.

Option 1 sounds fine.

Not sure exactly though what you mean.

The config.inc.php file has the password already.
I dropped my user and recreated and gave a password with Grant
in MySQL and gave all permissions to the local database
after upgrading to 5.027

Thanks
 

Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Your config.inc.php doesn't need updating unless you change what it is, the password in MySQL has to be updated as they changed the format of how passwords are stored in MySQL4.

If you really want to read about the password changes you should take a gander at the following two links:
http://dev.mysql.com/doc/refman/5.0/en/set-password.html
http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html


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!
Joined: Nov 2006
Posts: 3,095
Likes: 1
Carpal Tunnel
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095
Likes: 1
Thanks for the links.

I read the first link before, will read up on the 2nd link.

Thanks again.


Joined: Nov 2006
Posts: 3,095
Likes: 1
Carpal Tunnel
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095
Likes: 1
Update:

worked a treat thanks. 2nd link also has other PHP issues that may affect some users.

Code
SET PASSWORD FOR
'user_account'@'localhost' = OLD_PASSWORD('yourpassword');
 
Thanks again Gizmo.
 

Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Lol not a problem wink


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
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
0 members (), 744 guests, and 147 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)