Downgrade to PHP 4.4.4 broke something

[Dabbler]

Was on PHP 5.1.6 (IIS6/MySQL 5.0.24)
Forums ran fine but was experiencing w3wp.exe errors (apparent PHP bug).

Decided to downgraded to PHP 4.4.4.
New php.ini

phpinfo.php comes up OK.

But trying to access vb results in "The database has encountered a problem" msg.

DB repairs/optimizes and dumps just fine.

Rebooted server and IIS.

Now what? Too tired to think right now.

[Marco van Herwaarden]

We will need to see the full DB error to be able to help.

Please provide the full error either from the webmaster mail or by choosing View Source on the error page.

[Dabbler]

Hmmm. I have about 6,000 of them. Howzabout:

Database error in vBulletin :

mysql_pconnect() [<a href='function.mysql-pconnect'>function.mysql-pconnect</a>]: Client does not support authentication protocol requested by server; consider upgrading MySQL client C:\caf\includes\class_core.php on line 271

MySQL Error  : 
Error Number : 
Date         : Friday, October 13th 2006 @ 02:41:12 AM
Script       : http://<<mydomain>>/index.php
Referrer     : 
IP Address   : 74.6.xx.xx
Username     : 
Classname    : vb_database

The Script, Referrer, and IP Address lines are different in each, but the "mysql_pconnect" business is all the same.

[Dabbler]

And for the record, I changed:

Environment Variables:
Path: C:\php-4.4.4-Win32 (added)
PHPRC: c:\php-4.4.4-Win32

Web Extensions:
php; c:\php-4.4.4-Win32\phpisapi.dll; allowed

IIS Properties:
ISAPI Filters: c:\php-4.4.4-Win32\phpisapi.dll; loaded
App Config Mappings: .php; c:\php-4.4.4-Win32\phpisapi.dll; GET,HEAD,POST

And I set all permissions on the new php folder to match those on the php5 folder.

[Marco van Herwaarden]

I would start by turning off persistent connections in your config.php

Also enable old-passwords in the MySQL config.

[Dabbler]

As in:
mysql.allow_persistent = Off

and
$config['MasterServer']['usepconnect'] = 0;

[Dabbler]

Also enable old-passwords in the MySQL config.

I don't see a setting for "old-passwords" in any mysql/php/vB ini/config file. Do you have more info?

[Marco van Herwaarden]

Add the following in your my.ini file under the [mysqld] heading:

#Use old password encryption method (needed for 4.0 and older clients).
old-passwords

[Dabbler]

As in:
mysql.allow_persistent = Off

and
$config['MasterServer']['usepconnect'] = 0;

bump

[Steve Machol]

mysql_pconnect() [<a href='function.mysql-pconnect'>function.mysql-pconnect</a>]: Client does not support authentication protocol requested by server; consider upgrading MySQL client

As far as I know this means you did not install PHP correctly.

[Dabbler]

As far as I know this means you did not install PHP correctly.

Yeah. But where did I go wrong?
phpinfo comes up ok.
Oh well. Back to square one.

__________________
Never enough time to do it right, but just enough time to do it over.

[Dabbler]

As in:
mysql.allow_persistent = Off

and
$config['MasterServer']['usepconnect'] = 0;

bump

[Steve Machol]

bump

Please wait at least 12 hours before bumping your posts.

From the forum rules:

http://www.vbulletin.com/forum/showthread.php?t=42918

Please wait a reasonable amount of time before bumping posts. For style changes and general 'how-to' questions this should be 24 hours. For specific troubleshooting issues, use 12 hours as a guideline.

For help installing PHP, check the PHP home page.

http://www.php.net