Insteresting installation issue with Revo and Wampserver

I thought I would post this for anyone having issues installing Revo on Wampserver. I’ve been fighting with this for a couple of weeks now and had almost despaired. Here’s my setup:

Windows Vista Ultimate on laptop/Windows 7 professional on Desktop
Wampserver 2.0i
- Apache Version 2.2.11
- MySQL versions 5.1.36 and 5.1.41 (I switch back and forth between them but my default is 5.1.36)
- PHP versions 5.2.11 and 5.3.0 (by default I use 5.2.11).

One of the reasons I like wampserver is that i can have several versions of mySQL and PHP installed and switch back and forth between them. My default setup is MySQL 5.1.36 and PHP 5.2.11

I have been trying to install Revo on my default setup with no success whatsoever. I would get all the way to the instruction summary and get the message:

Checking MySQL client version: Failed!
MODx will have issues on your MySQL version (5.0.51a), because of the many bugs related to the PDO drivers on this version.

Today I was playing around with a project that requires PHP 5.3.0 and so had my wampserver switched to run that with MySQL 5.1.36. I decided on a whim to try and install Revo and it worked. Now maybe this is because I am missing some piece of knowledge about MySQL client versions and PHP but this has had me pretty frustrated for a while and I thought I’d share what worked for me.

WAMPServer’s client MySQL version is 5.0.51a in that instance, and 5.0.51a has numerous bugs with regard to PDO support, hence why Revo has problems with it.

http://svn.modxcms.com/docs/display/revolution/MySQL+5.0.51+Issues

Quote from: splittingred at Jan 10, 2010, 12:47 PM

WAMPServer’s client MySQL version is 5.0.51a in that instance, and 5.0.51a has numerous bugs with regard to PDO support, hence why Revo has problems with it.

http://svn.modxcms.com/docs/display/revolution/MySQL+5.0.51+Issues

Hey Shaun
Thanks, yes I had read about this in the docs but wasn’t sure what the relationship was between the server version (5.1.36 and 5.1.41) and the client version. What I’m wondering is why switching to PHP 5.3 works. Maybe has something to do with the wampserver? I’m pretty clueless about this stuff at the moment.

It’s more than likely the WAMPServer build; they probably didnt build with matching client and server versions - which will create large numbers of problems, such as the one you had occur. Probably an oversight on WAMPServer’s authors.

did you resolve the problem with the mysql client?

if so, how?

i see another guy tried to resolve a similar issue but ran into (compatibility?) problems.

http://modxcms.com/forums/index.php/topic,44026.0.html

how do you handle/set file/directory permissions in wamp?

Quote from: xeeter at Jan 11, 2010, 07:03 PM

did you resolve the problem with the mysql client?

if so, how?

i see another guy tried to resolve a similar issue but ran into (compatibility?) problems.

http://modxcms.com/forums/index.php/topic,44026.0.html

how do you handle/set file/directory permissions in wamp?

With Wampserver you can have more than one version of PHP, MySQL or Apache running and you can switch between them. I have both PHP5.3 and 5.2.11 installed and I switch between them simply by clicking on the Wampserver icon in the tray, go to PHP->version, and click on 5.3, let Wampserver finish restarting and then install MODx Revo. This worked for me. So when I’m working with Revo I make sure PHP 5.3 is running and then I switch back to 5.2.11 if I need to.

I don’t need to do anything with file permissions so far, so not too sure what you mean.

some files need write perm. windows has no chmod (777 or whatever).

my wamp is ~ 18 months old.

guess what version of mysql it has? >> 5.0.51b. can u believe that?

what versiom mysql do i need to install to get client NOT 5.0.51.x?? (client)

Is Revo compatible with mysql 5.1.x?

The 5.1 upgrade is one-way.

My server is using 5.0.8x. (my production server)

Quote from: xeeter at Jan 11, 2010, 08:30 PM

some files need write perm. windows has no chmod (777 or whatever).

my wamp is ~ 18 months old.

guess what version of mysql it has? >> 5.0.51b. can u believe that?

what versiom mysql do i need to install to get client NOT 5.0.51.x?? (client)

Is Revo compatible with mysql 5.1.x?

The 5.1 upgrade is one-way.

My server is using 5.0.8x. (my production server)

Hmm, I Revo is working fine with my MySQL 5.1.36 on my setup, but to get rid of the client version issue with wampserver specifically you need to run PHP 5.3. This is what I have done and it works. When you load up, load your phpinfo() file, scroll down to MySQL info and it will tell you the client version. See also the post I did on this - http://bit.ly/7Dhf4E . As long as it’s not 5.0.51 or 5.0.51a I think you’re in business. I’m not very intelligent when it comes to this database version stuff so this has been trial and error for me

For file permissions, I really haven’t needed to change anything, and the install works fine, maybe because I’m working locally. If I ever do need to CHMOD files on Windows I simply fire up my FTP program (I use the fireftp plugin for firefox) and use that to CHMOD. Works fine!

Just installed to WAMP. No problem. Using WXP Home. Laptop. Took longer than installing to my prod server, tho.

I uninstalled old WAMP and installed newest version 2.0i

http://www.wampserver.com/en/download.php

Here’s my client: mysqlnd 5.0.5-dev - 081106 - $Revision: 1.3.2.27 $

You see no problem with that mismatch?

And you say your client = 5.0.51.x?? Why dif from mine?

I don’t know how to upgrade just client. I thought the client version usually matches the server version. No?

I am using PHP 5.3.0, which = default install on latest WAMP. Tho I see 5.3.1 is also available.

when they say >> "Configuration warning: Config file still writable"

what file are they talking about?

Quote from: xeeter at Jan 11, 2010, 09:49 PM

Just installed to WAMP. No problem. Using WXP Home. Laptop. Took longer than installing to my prod server, tho.

I uninstalled old WAMP and installed newest version 2.0i

http://www.wampserver.com/en/download.php

Here’s my client: mysqlnd 5.0.5-dev - 081106 - $Revision: 1.3.2.27 $

You see no problem with that mismatch?

This is what I was saying i don’t completely understand with server and client versions. I think it has to do with how wamp builds their stack.

And you say your client = 5.0.51.x?? Why dif from mine?

Because I was using PHP 5.2.11. Once I switched to 5.3 I have the same client version as you

I don’t know how to upgrade just client. I thought the client version usually matches the server version. No?

I am using PHP 5.3.0, which = default install on latest WAMP. Tho I see 5.3.1 is also available.

I don’t think there’s a way to upgrade just the client with wamp. Again, not too sure why their build looks like that.

when they say >> "Configuration warning: Config file still writable"

what file are they talking about?

I believe it’s core/config/config.inc.php