Forums / Install & configuration / Problem working with Postgres

Problem working with Postgres

Next topic

Author	Message
Mazin Mustafa	Thursday 01 July 2004 8:50:39 am I'm trying to perform a fresh install on eZ publish 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=ezpublish 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 ez Publish 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 eZ Publish 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

Thursday 01 July 2004 8:50:39 am

I'm trying to perform a fresh install on eZ publish 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=ezpublish 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 ez Publish 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 eZ Publish 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.