WampServer

All,

Hey added WAMP to a new box and working on a site with PostGres instead of MySQL. I've gone into the php.ini file and uncommented the two postgres extensions of:

Quote

php_pgsql.dll
php_pdo_pgsql.dll

Now what I get, even though the files actually exist correctly in the /ext directory is the following errors in the log:

Quote

[04-Nov-2008 09:04:08] PHP Warning: PHP Startup: Unable to load dynamic library 'c:/program files/wamp/bin/php/php5.2.6/ext/php_pgsql.dll' - The specified module could not be found.

in Unknown on line 0

[04-Nov-2008 09:04:09] PHP Warning: PHP Startup: Unable to load dynamic library 'c:/program files/wamp/bin/php/php5.2.6/ext/php_pdo_pgsql.dll' - The specified module could not be found.

in Unknown on line 0

[04-Nov-2008 09:04:09] PHP Warning: PHP Startup: Unable to load dynamic library 'c:/program files/wamp/bin/php/php5.2.6/ext/php_pgsql.dll' - The specified module could not be found.

in Unknown on line 0

[04-Nov-2008 09:04:09] PHP Warning: PHP Startup: Unable to load dynamic library 'c:/program files/wamp/bin/php/php5.2.6/ext/php_pdo_pgsql.dll' - The specified module could not be found.

in Unknown on line 0

I've looked on-line, thinking my .dlls corrupt, found, downloaded and replace the .dlls but still same messages.

Anyone have a clue why this is occurring?

OMR

you edited wrong php.ini; open php.ini file through wamp tray icon for correct one ;-)

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Y,

Thanks for your comment, but you are wrong that is the one I opened. Been using WAMP for over 5 years, but just signed on to this board.

Doesn't mean I'm noobie, just cause I joined the board today. Been able to solve all my WAMP problems until today and even advanced enough to modify my own WAMP menu with the wampmanager.ini file adding all kinds of goodies and shortcuts to what I do.

Thanks, but need real help here.

OMR

did you already install it? you had good years experience w/ wampserver so I guess you've already knew that wamp only come w/ mysql and sqlite and in order to use other db such as ms sql, PostgreSQL, so on, you have to install them before enable extension ;-)

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

All,

Wondering if PostGres has to be up and running for this to work right?

Right now it is having install issues.

OMR



Edited 1 time(s). Last edit at 11/07/2008 08:14PM by OldManRiver.

All,

OK could never get the PostGres to install and run correctly. Have post on this at:

[www.postgresqlforums.com]

Will pop back in here when PG is up and see it these issues get resolved.

OMR

I just did a stupid solutions and it worked. But really. these are stupid ways..

1. Install WampServer 2.0c (with PHP 5.2.6 installed)
2. Install PostgreSQL 8.3
3. Install PHP 5.2.5 addon (http://www.wampserver.com/en/addons_php.php)
4. Rename folder C:\wamp\bin\php\php5.2.6 to whatever you like
5. Rename folder C:\wamp\bin\php\php5.2.5 to C:\wamp\bin\php\php5.2.6
6. In WampServer control panel, select PHP > PHP extensions, tick the php_pgsql extention.
7. Restart all services

Voila, the the php is now connected to PostgreSQL!

So far, this is the solution I found.. please don't laugh at me... ^_^

First off. I can't see why you need PostGres installed to have this extension load. The typical production environment has to assume that the database and the web app may lie on two different servers. The extension allows you to communicate with the postgres server (whether local or somewhere else on the network). If it needed postgres to be installed it would be stupid.

Second, I havn't yet tried ahsya's suggestion of reverting to php 5.2.5, and I am sure to give it a shot. However, I had had this extension in use with version 5.2.6 for several months now without any problems.

The problems seemed to start occurring when my machine did a windows update yesterday. This morning, postgres extension is broken and I have also tried replacing the dlls, reinstalling php and apache. I notice this thread started on the 4th of November.. since I don't update my windows too often, it might very well be that there was an update around that time that is messing things up.

This is a stab in the dark.. If anybody can confirm or eliminate this possibility, please let me know because it will help us get to the bottom of this.

Greetz

OK.. small update..

You don't need to swap your entire php version to 5.2.5. All that needs to be done is to copy the php_pgsql.dll from ver 5.2.5/ext into ver5.2.6/ext.

That sorted out the problem for me.

Thanx again ahsya - your contribution helped me a lot.

Greetz

ahsya Wrote:
-------------------------------------------------------
> I just did a stupid solutions and it worked. But
> really. these are stupid ways..
>
> 1. Install WampServer 2.0c (with PHP 5.2.6
> installed)
> 2. Install PostgreSQL 8.3
> 3. Install PHP 5.2.5 addon
> (http://www.wampserver.com/en/addons_php.php)
> 4. Rename folder C:\wamp\bin\php\php5.2.6 to
> whatever you like
> 5. Rename folder C:\wamp\bin\php\php5.2.5 to
> C:\wamp\bin\php\php5.2.6
> 6. In WampServer control panel, select PHP > PHP
> extensions, tick the php_pgsql extention.
> 7. Restart all services
>
> Voila, the the php is now connected to PostgreSQL!
>
>
> So far, this is the solution I found.. please
> don't laugh at me... ^_^

This would be great is #2 worked, but it doesn't

OMR

All,

Got the install fixed. See link at:

[www.postgresqlforums.com]

for fix details.

However clearing the PHP error log and restarting Apache, I still get the same error messages. Now assume it is related to UID/PWD login issues.

Need some help with figuring this out!

Thanks!

OMR

All,

OK found out I did not implement the .dlls from 5.2.5 correctly. Now is working OK.

Thanks All!

OMR