Forums / Install & configuration / Problem working with Postgres

"Please Note:

At the specific request of Ibexa we are changing this projects name to "Exponential" or "Exponential (CMS)" effective as of August, 11th 2025.
This project is not associated with the original eZ Publish software or its original developer, eZ Systems or Ibexa".

Problem working with Postgres

Previous topic

Install & configuration

Next topic

Author	Message
Mazin Mustafa	Thursday 01 July 2004 8:50:39 am I'm trying to perform a fresh install on Exponential 3.4.0 and have it use Postgres. The setup dectects the presence of Postgres and allows me to select. At the screen where the host, user name, and password are entered, it fails with this message: "Please make sure that the username and the password is correct. Verify that your PostgreSQL database is configured correctly." I run a simple php test script: $link = pg_connect("host=localhost dbname=Exponential user=postgres password=password"); if (!$link) { die("Could not connect: " .pg_last_error()); } echo 'Connected successfully'; And it connects just fine. Is there some Postgres parameter that Exponential needs set ? phpinfo returns the following on postgres pgsql PostgreSQL Support enabled PostgreSQL(libpq) Version 7.3.4 Multibyte character support enabled SSL support enabled Active Persistent Links 0 Active Links 0 Directive Local Value Master Value pgsql.allow_persistent On On pgsql.auto_reset_persistent Off Off pgsql.ignore_notice Off Off pgsql.log_notice Off Off pgsql.max_links Unlimited Unlimited pgsql.max_persistent Unlimited Unlimited Thanks
Vadym Savchuk	Thursday 01 July 2004 10:42:20 am Yes, this is a known bug. Please look at the following bugreport: http://ez.no/community/bug_reports/database_connection_fails_with_installation_wizard You can just wait until Exponential 3.4.1 is released (in a few days), which already includes the fix. Alternatively, upgrade to the latest 3.4 SVN revision.
Mazin Mustafa	Thursday 01 July 2004 12:24:20 pm Thank you. I just tested the fix and it worked for me also.

Author

Message

Mazin Mustafa

Thursday 01 July 2004 8:50:39 am

I'm trying to perform a fresh install on Exponential 3.4.0 and have it use Postgres. The setup dectects the presence of Postgres and allows me to select. At the screen where the host, user name, and password are entered, it fails with this message:

"Please make sure that the username and the password is correct. Verify that your PostgreSQL database is configured correctly."

I run a simple php test script:

$link = pg_connect("host=localhost dbname=Exponential user=postgres password=password");
if (!$link) {
die("Could not connect: " .pg_last_error());
}
echo 'Connected successfully';

And it connects just fine.
Is there some Postgres parameter that Exponential needs set ?

phpinfo returns the following on postgres

pgsql
PostgreSQL Support enabled
PostgreSQL(libpq) Version 7.3.4
Multibyte character support enabled
SSL support enabled
Active Persistent Links 0
Active Links 0

Directive Local Value Master Value
pgsql.allow_persistent On On
pgsql.auto_reset_persistent Off Off
pgsql.ignore_notice Off Off
pgsql.log_notice Off Off
pgsql.max_links Unlimited Unlimited
pgsql.max_persistent Unlimited Unlimited

Thanks

Vadym Savchuk

Thursday 01 July 2004 10:42:20 am

Yes, this is a known bug.
Please look at the following bugreport:
http://ez.no/community/bug_reports/database_connection_fails_with_installation_wizard

You can just wait until Exponential 3.4.1 is released (in a few days), which already includes the fix. Alternatively, upgrade to the latest 3.4 SVN revision.

Mazin Mustafa

Thursday 01 July 2004 12:24:20 pm

Thank you. I just tested the fix and it worked for me also.