Problem installing phpbb

[Ninko]

Hi there,
I'm trying to install phpbb, but I keep getting the following message:

Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Intranet\forum\db\mysql4.php on line 48

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in C:\Intranet\forum\db\mysql4.php on line 330

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in C:\Intranet\forum\db\mysql4.php on line 331
phpBB : Critical Error

Could not connect to the database

I am using:
Apache 2.0.55
PHP 4.4.4
MySQL Server 5.0

Any ideas?

Thanks


Ninko

[chazzy]

Sounds like you didn't install the mysql client binaries properly.

[Ninko]

Oh, I'm new to this, what does that mean?

[chazzy]

Well, when you install mysql, you also need to install the client application so that whatever you have that tries to talk to mysql can speak the proper protocol to the mysql server.

It looks like you're running this on your desktop, right? How did you install mysql though?

http://dev.mysql.com/doc/refman/5.0/en/windows-installation.html

[Ninko]

I just downloaded Windows Essentials (x86) version 5.0.27 and went through the standard install process.

[chazzy]

is the server running on your desktop? are you installing this on your desktop?

what happens when you type in something like this:


mysql -u <<your user>> -p<<your password>>

[Ninko]

Yeah its installed on my desktop.

I can use the MySQL Command Line Client and when I enter my password I get:

Enter password: ********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 5.0.27-community-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

[chazzy]

did you install the mysql libraries in php's extensions directory? there's also another file in the package that needs to go windows\system32

[Ninko]

Erm... I don't think so, I just followed the install wizard lol.

[chazzy]

see this page:

http://dev.mysql.com/downloads/connector/php/

[Ninko]

Does that mean I need to upgrade to PHP 5.2.0?

[chazzy]

It should be backwards compatible. note that i say should.

is there a reason you don't want to upgrade to the current production version? is this to match what's running on a system you already have set up?

[Ninko]

I just tryed it without upgrading and it made no difference, so I'll try it again after upgrading in abit.

Theres no real reason I don't want to upgrade, just couldn't be bothered lol.

Thanks for your help so far!

[Ninko]

Hi there, I've upgraded and did what the link said again, now we have something new lol:

The PHP configuration on your server doesn't support the database type that you chose

Any ideas?

[chazzy]

I'd really recommend that you post on the phpBB forums, as they are much more familiar with their software than I am. I have never had an issue like you're describing.

[Ninko]

Leaving phpbb aside, I found these 2 scripts that tests to see if php_mysql.dll and php_mysqli.dll are loaded or not.

According to the 2 scripts, php_mysqli.dll is loaded, but not php_mysql.dll. That makes no sense to me, as their both in the same folder (extensions) and both are enabled:

extension=php_mysql.dll
extension=php_mysqli.dll

This might be why theres problems?

[chazzy]

you definitely can only have one installed at a time. comment out the extension for mysqli, move the libmysql.dll from the "mysql" package into c:\windows\system32 and c:\windows\system. as far as i am aware, the lib files probably aren't different, but both extensions shouldn't be enabled at once, its a windows thing as far as i know.

[Ninko]

Ok, I think its sorted now.

Thanks very much for your help!

Take care


Ninko

[chazzy]

Can you tell me what happened? I've never seen this before.

[Ninko]

The only way I can describe it, is it would seem that PHP only re-reads the php.ini file every now and then in which to update its self, because I restarted Apache (the only way I know of restarting PHP) and nothing changed, only php_mysqli.dll was loaded, yet when I tryed running both scripts again, like 15 mins later, both .dll's was loaded.

I'm not sure if PHP is meant to do that, but thats what it looked like it was doing to me, other then that, I have no idea lol.

In response to your message before, it would seem you can have both dll's loaded at the same time under Windows, again, I barely understand alot of this, so who am I to say anything, as long as it works :).


Ninko

[chazzy]

I guess it depends on if they can use the same lib file. My understanding is that they had two different libs, but obviously this is different now.

Also, about the restarts, typically the only time that the file is read in is when apache restarts (if you go down to the apache monitor, and click the restart button) so its odd that it was later on. Did you try clearing your cache?

[Ninko]

No i didn't clear the cache, didn't even occur to me to tell you the truth, maybe that had something to do with it.

As for the lib file, I did wonder if it was going to be the same from both connection packs, but I just went with it and again I can only assume they are.


Ninko