in

ASP.NET Weblogs

A Recipe for New Media

WIPP (Windows IIS PostgreSQL PHP)

Here's a fun one for all you LAMP fans out there.  I have inherited a PHP/PostgreSQL based website from another company.  Scenario:

  • UBuntu Linux 7.02
  • PHP 5
  • PostgreSQL 8.2
  • Apache 2.2

Beautiful setup, works great.  Problem.  I need PHP 4.4 for this project.  I figured, no problem, just revert to PHP 4.4. No go. UBuntu doesn't do PHP 4.X anymore and PHP 5 breaks the code.  I figured I would download and compile PHP 4.4.  Stonewalled again.  Apache 2.2 is not supported by PHP 4.X (or posssibly more accurately, Apache doesn't support PHP 4.X?)  So now I have to revert the webserver.  I realized that this was getting a little crazy.  Since I dual boot my computer with Windows XP, I jumped over the XP, installed PHP 4.4 and PostgreSQL 8.2 had the site up in less than an hour.  It was far simpler than trying to deal with Linux and the fact I would have to recompile PHP 4.X (and hope that I didn't miss a required module and have to re-configure / compile / install or get a configuration switch wrong, and other such problems).  So I guess you could say I WIPP'd the LAMP. Yes, that's a bad joke, I'm a programmer not a comedian.

 On a positive note though, I am quite impressed with Aptana for PHP editing.  It is well done and made my work a lot easier.  Now if only they could fix Ruby code completion (see previous articles about my adventures with Ruby on Rails).  I am also trying to convince the stakeholders in the project that ASP.NET would be a better platform, but that will take time...

Published Nov 06 2007, 02:12 PM by ccm682
Filed under: , , , , ,

Comments

 

Chris Martin said:

It would help to know what problems you were having with PHP 5. It could be something very simple.

November 7, 2007 2:04 AM
 

daniel brughera said:

Hi, maybee you can help me, im trying to do something like that, but i can´t connect to pgsql.

I already test the remote connection to pgsql and it works using php from another Linux location, but when I try to do the same connection from php on IIS, it doesnt connect it...

What can i do

November 23, 2007 2:01 PM
 

ccm682 said:

Yeah, I had the same problem with PostgreSQL, turned out firewall on windows was the problem.

December 5, 2007 2:58 PM
 

ccm682 said:

Issues with PHP 5.  I have no issues with PHP 5, I think it is a pretty descent web scripting language. I have issues with the fact that between version 4 and version 5 they changed the way things worked, which broke so many things the site doesn't work right!!  I have a page that displays fine, but as soon as I try to submit any forms or use database stuff, all I get is blank areas of the page where there should be content.  I'm not a hard core PHP programmer and don't really want to be, so I don't know really what broke.  I'm in the middle of a proposal to get away from PHP anyways and to something that better fits the requirements (it must integrate tightly with Java and the client doesn't like the fact that PHP-Java bridge is "beta".  It must integrate with a ESB, with BizTalk-like backend system, etc)

December 5, 2007 3:03 PM

Leave a Comment

(required)  
(optional)
(required)  
Add
Terms of Use