1 reply to this topic

[charlie]

I am trying to set up a fresh install on Win7/IIS but cannot get past the Server Test in the server admin.

I've searched around the forums, see other people having the same problem but no solutions.

I have PHP 5.3.2 with phpinfo is coming up with mysql, and it's working fine with other sites on my dev machine. I have enabled full permissions on the directory.

What I don't understand is that the "server.php" that gets called by the server admin calls various functions that try to access the database, but that doesn't even get set up till the next step in the admin. It just seems to barf at that point and so couldn't possibly continue.

Any suggestions?

cheers.

-c.

Update: Finally found a workaround. The problem seems that there are the calls to mysql_real_escape_string() that needs an existing database connection, and there is no database connection set up yet when the admin tries to test the server.

I had to edit the /_config/config.inc.php file after the files were copied over and change these:


$CONFIG["gl_datprov"] = "MQ=="; // this is "1" in Base64
$CONFIG["gl_db_host"] = "MTI3LjAuMC4x"; // this is "127.0.0.1" in base64
$CONFIG["gl_db_user"] = "username-in-base64";
$CONFIG["gl_db_pass"] = "password-in-base-64";
$CONFIG["gl_db_name"] = "dbname-in-base64";

You need to put in values that are base64 coded.

It can then connect to a blank database and let you proceed so you can add the tables in the next admin step.

[Patrick Keil]

Quote

Update: Finally found a workaround. The problem seems that there are the calls to mysql_real_escape_string() that needs an existing database connection, and there is no database connection set up yet when the admin tries to test the server.

Yes, we know about that problem and it will be fixed in the next update. Most servers have a valid default mysql host so this problem hasn't been noticed in the beginning.

Thanks for reporting and sorry for wasting your time.