Zikula Community

Frustrating problems while trying to install PN ver.726 on my Windows 2003 server. If I try the default install I get an error stating unable to make database. If I create the database and try it after checking the "Intranet" option I get this error:
No database made.Error connecting to DB
Program: E:\webdev\nubiint\install\db.php - Line N.: 45
Database: nubiint
Error (1250) : Client does not support authentication protocol requested by server; consider upgrading MySQL client

I've also gotten this error:
No database made.Error connecting to DB
Program: E:\webdev\nubiint\install\db.php - Line N.: 45
Database: nubiint
Error (1045) : Access denied for user: 'root\@\localhost' (Using password: NO)

I've created 3 accounts in MySQLCC that are all able to connect to the localhost and have all grant permissions on the databases I create. I've also used the MySQl ADmin tool to make sure all table permissions were granted to these users.

Can someone let me know what exactly I'm missing? This is my own server that I'm hosting my site on.
I'm using php4.3.4, mysql 5, and IIS6 on w2k3 WE.

I'd appreciate any response I can get on this.

THanks

Searching...

Turns out I was using a password that wasn't recognized by MySQL and needed to configure the server to use old passwords. So following documentation located here:
http://www.mysql.com…/en/Old_client.html
and entering this command into a dos prompt:
mysql> SET PASSWORD FOR
-> 'some_user\@\some_host' = OLD_PASSWORD('mypass');

I was able to get PN installed on my w2k3 server without any problems. I still had to edit the config.php file afterwards, but it's now working.

This is a PN ver.726 install with MySQL5.0 and PHP4.3.4.
Hopefully this will be of use to someone.