Hello!

I am currently trying to install SilverStripe with PostgreSQL 9.0 database on Mac OS X with MAMP. I created the database with pgAdmin3 and installed and placed the postgresql module in the SilverStripe directory. The only thing left is to enter the details about the database.

When I enter this:
Database server: localhost:5432
Database username: postgres
Password: (not going to show this here :P)
Database name: SS_Test

I get the following message...
"I couldn't find a database server on 'localhost:5432': PostgreSQL requires a valid username and password to determine if the server exists."

I am sure that the database properties are alright (I have looked at the properties in pgAdmin3) and that my username and password are alright (I am able to connect to the server with those credentials with pgAdmin3).

So... Am I doing something wrong?

Thanks for any help!

Try setting the server to "localhost" (lose the ":5432" port bit).

I'm pretty sure 5432 is the default port, anyway.

Sean

It worked! Thank you!

When I clicked the install button at the end I got the following error... :S

Setting up 'mysite/_config.php'...
Setting up /Applications/MAMP/htdocs/SilverStripe/mysite/_config.php
Setting up '.htaccess' file...
Setting up /Applications/MAMP/htdocs/SilverStripe/.htaccess
Building database schema...
[Warning] pg_query() [function.pg-query]: Query failed: ERROR: relation "SiteTree_versions" does not exist LINE 2: FROM "SiteTree_versions" GROUP BY "RecordID", "Version... ^
POST /SilverStripe/install.php

Line 174 in /Applications/MAMP/htdocs/SilverStripe/postgresql/code/PostgreSQLDatabase.php

Source

165 if(isset($_REQUEST['previewwrite']) && in_array(strtolower(substr($sql,0,strpos($sql,' '))), array('insert','update','delete','replace'))) {
166 Debug::message("Will execute: $sql");
167 return;
168 }
169
170 if(isset($_REQUEST['showqueries'])) {
171 $starttime = microtime(true);
172 }
173
174 $handle = pg_query($this->dbConn, $sql);
175
176 if(isset($_REQUEST['showqueries'])) {
177 $endtime = round(microtime(true) - $starttime,4);
178 Debug::message("\n$sql\n{$endtime}ms\n", false);
179 }
180

Trace

pg_query(Resource id #753,SELECT MIN("ID") AS "ID", "RecordID", "Version" FROM "SiteTree_versions" GROUP BY "RecordID", "Version" HAVING COUNT(*) > 1)
Line 174 of PostgreSQLDatabase.php
PostgreSQLDatabase->query(SELECT MIN("ID") AS "ID", "RecordID", "Version" FROM "SiteTree_versions" GROUP BY "RecordID", "Version" HAVING COUNT(*) > 1,256)
Line 127 of DB.php
DB::query(SELECT MIN("ID") AS "ID", "RecordID", "Version" FROM "SiteTree_versions" GROUP BY "RecordID", "Version" HAVING COUNT(*) > 1)
Line 303 of Versioned.php
Versioned->augmentDatabase(,,,,,,)
Line 963 of Object.php
Object->extend(augmentDatabase,)
Line 3012 of DataObject.php
DataObject->requireTable()
Line 209 of DatabaseAdmin.php
DatabaseAdmin->doBuild(1)
Line 1026 of install.php
Installer->install(Array)
Line 190 of install.php

Please try using the trunk version of the postgresql module instead of the stable version. I think the "stable" one doesn't work with 2.4.2. You can grab the trunk release on the PostgreSQL page in the Extensions area of this site.

Thank you again Sean! That worked!

Please try using the trunk version of the postgresql module instead of the stable version.

I installed SS-2.4.5 with the trunk of Postgresql module on my localhost, but it fails on my 'production' server.

Installer says:

I couldn't find a database server on 'localhost': PostgreSQL requires a valid username and password to determine if the server exists.

The settings for 'database server' is localhost. Username, database name & password are OK since I can access database via cli:

[gour@s9 gour] psql -U gour -h localhost gour_ss
Password for user gour: 
Welcome to psql 8.3.14, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)

gour_ss=> \q
[gour@s9 gour] 

Any hint?

Is it maybe problem due to encryption?

Edit: My localhost postgresql is 9.x, while the error is on the server with 8.3.