Does Postgresql Support really work?! Can't get it up

bierstuebl · Post by **bierstuebl** » 01 Jun 2007, 15:28

Hello there,

I just tried to install Version 1.0.7 of Mantis with a Postres Database 8.1 on Windows XP.

Unfortunately, the install-script can't connect to the database. I read tons of posts where people entered the wrong administrative user with no database-access etc.

However, all the data I enter on the installation page seem correct to me. It seems like it all hangs on the pgsql-support. The Database user exists and has full access, in fact it is even the database root user. The database connection check of the mantis installer ALWAYS fails without ANY error message (like "connection refused" or similar) , regardless of what user etc. I specify. I got the feeling that the script doesn't even try to connect to the database! What kind of driver is used fpr Postgresql support?

In fact, it is the same problem someone described in http://www.mantisbt.org/forums/viewtopi ... ight=pgsql(without answer). I'd really like to use mantis, but I must use it with postgres here at work, mysql is not an option.

Any helpful comments are appreciated.
Greetz,
Bierstuebl

gerb42 · Post by **gerb42** » 04 Jun 2007, 14:29

bierstuebl,

first check whether pgSQL is enabled in your php config. To do so, create a .php file in your mantis directory with the following contents:

<?php
phpinfo();
?>

If you open this page in a browser, it should give you some information about the pgSQL module. If not, pgSQL is not installed.

regards,
Gerd

bierstuebl · Post by **bierstuebl** » 05 Jun 2007, 14:40

Hi there,

pgsql-module is installed. The following info is displayed:

PostgreSQL(libpq) Version 8.2.3
Multibyte character support enabled
SSL support disabled
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

I can also connect to the database using normal pg_connect(...) and the same user/password in a little php-script I call in the browser. As I said, it seems to me that hte install-script doesn't even try to connect to the database and there is no Error-Message at all when the check fails.

Has anyone ever managed to run mantis woth postgresql? I mean what does experimental mean?

Any Help welcome,
Bierstuebl

gerb42 · Post by **gerb42** » 05 Jun 2007, 18:27

Hmm, sounds strange to me. We have a 1.0.6 running on postgres and creation was not a problem. Have you tried creating the database before installation (only the database, no tables)?