Hi everyone,

I'm installing Vanilla on IIS and have got PHP working (see test page here), but when I try and load Vanilla it just returns a blank page. I've got the permissions right, I think, and the MySQL database is setup correctly, I think.

Anyone got any suggestions?

Paul.

Okay, I did a bit of digging, and you're not the first person this has happened to. Sadly, however, I couldn't find a quick resolution for you.

Others that have had problems like this have found that it might be due to their ftp programs messing up the files as they upload them. If I were to guess, I'd say that it has something to do with the fact that you're running php 5 and it hasn't been configured to work with php 4.x class definitions. I can't remember what the php.ini configuration setting is, but it's something like php4.compatibility... sorry - swamped with work and can't figure it out for you right now.

Anyone else have any ideas?

Could be the header problem... WordPress had the same problem with IIS

It could be fixed by replacing header("Location: )" by this code:
if( strstr($_SERVER['SERVER_SOFTWARE'], 'Microsoft-IIS'))
header("Refresh: 0;url=$location");
else
header("Location: $location");

But that's a nasty fix... Maybe Mark should look into it ;)

I don't think it's MySQL related... everytime data is saved, you're getting redirected and that's were it goes wrong :)

But then again... I'm also hosting on an IIS install.... could be the PHP version...

I have Windows Server 2003 with IIS, but I use an older PHP version 4.3.11 and MySQL version 4.1

Doing basic connection tests with mysql is pretty easy. Create a new blank text file called mysqltest.php and put this inside:

<?php
// Turn on all errors
error_reporting(E_ALL);

// Customize your database connection
$Host = "Your MySQL Host Name";
$User = "Your MySQL Username";
$Password = "Your MySQL Password";
$Database = "Your MySQL database name";

// Open a database connection (you may see some errors here)
$Connection = mysql_connect($Host, $User, $Password);

// Attempt to select your database
if ($Connection && !mysql_select_db($Database, $Connection)) echo("Failed to connect to the '".$Database."' database.");
?>

Give that a go and see what happens.

according to the textpattern folks, it's a hosting company problem:

http://textpattern.com/faq/96/client-does-not-support-authentication-protocol-requested-by-server

I downgraded to MySQL 4.1 and PHP 4.4.1 and get the same error:

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

What version combination does Vanilla Recommend?