|
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 Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client 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,303 Likes: 116
|
Joined: Jun 2006
Posts: 16,303 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
|
|
|
|
Joined: Jun 2006
Posts: 16,303 Likes: 116
|
Joined: Jun 2006
Posts: 16,303 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.
|
|
|
|
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: 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. SET PASSWORD FOR
'user_account'@'localhost' = OLD_PASSWORD('yourpassword'); Thanks again Gizmo.
|
|
|
|
Joined: Jun 2006
Posts: 16,303 Likes: 116
|
Joined: Jun 2006
Posts: 16,303 Likes: 116 |
Lol not a problem
|
|
|
|
|
Test
by Phun - 05/28/2024 7:31 PM
|
|
0 members (),
315
guests, and
334
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|