To install Mantis, you need an account which has sufficient privileges on your database (see http://www.mantisbt.org/docs/master-1.2.x/en/administration_guide/admin.install.new.html)

Alternatively, you might be able to generate the SQL from the install script and run that through your interface.

As this is not a technical issue with MantisBT, but you are asking how to set it up, I am resolving this issue now. Please use the Forums for further support.

Hmm, I think this is a technical issue, and you have to check installation on PostgreSQL, because I have found the reason.
The problem is in \admin\install.php, line 304.
$t_result = @$g_db->Connect( $f_hostname, $f_admin_username, $f_admin_password );
This does not work for PostgreSQL without database name. The command:
$t_result = @$g_db->Connect( $f_hostname, $f_admin_username, $f_admin_password, $f_database_name );
works fine.
This trick helps me to pass this check and successfully install Mantis.
The only warning I have got is
"POSSIBLE PROBLEM: change php.ini to disable register_globals setting"
Is this critical?

The 'register_globals' message is just a warning, so it's up to you to ignore it (or not). It is recommended to have it OFF for security reasons [1].

With regards to the main problem, can you please confirm which version of MantisBT you're working with, as the '$g_db->Connect' statement is actually at line 303 in 1.2.10.

Anyway I believe that your proposed fix could potentially break the installation process for other RDBMS. To make sure I have a good understanding of your usage scenario, can you please clearly explain your DB setup (i.e. what input parameters you provide to install.php)

Can you also have a look at 0009951 and tell me whether that is the same issue you are facing, and if information provided there is of any help.

[1] http://php.net/security.globals.php

Maybe a better fix (not tested)

diff --git a/admin/install.php b/admin/install.php

index 548cd79..a2a438c 100644

--- a/admin/install.php

+++ b/admin/install.php

@@ -292,6 +292,10 @@ if( 2 == $t_install_state ) {

$g_db = ADONewConnection( $f_db_type );

$t_result = @$g_db->Connect( $f_hostname, $f_admin_username, $f_admin_password );


if( !$t_result ) {
$t_result = @$g_db->Connect( $f_hostname, $f_admin_username, $f_admin_password, $f_database_name );
}

if( $t_result ) {

        # check if db exists for the admin

I use 1.2.10. May be I have shifted the line during my experiments with code.

My setup scenario:
First I have created manually the database "ppp_mantis" and user for it with full rights (this was done by script of my provider, so I do not know the exact details).

The paramenters for install.php:
Type of Database : PGSQL
Hostname (for Database Server) : pg.sweb.ru (localhost did not worked for some reason, I do not know why)
Username (for Database) : mantisuser
Password (for Database) : mantisuserpw
Database name (for Database) : ppp_mantis
Admin Username (to create Database if required) : mantisuser
Admin Password (to create Database if required) : mantisuserpw

Yes, I know, that my fix works only if DB already exists. But I have done some experiments and found that ADO command:
$t_result = @$g_db->Connect( $f_hostname, $f_admin_username, $f_admin_password );
fail withot DB name in my case.
May be the problem is connected with some options of PostgreSQL, otherwise I do not know how to create a new DB via ADO.

0009951 describes a little other problem with DB OWNER setting

Thanks for feedback.

I assume then that "mantisuser" has fullrights on ppp_mantis schema. Will try to make some tests later on as time allows.

In the meanwhile, can you confirm if my suggested alternate fix works for you ?

Where to find your alternate fix? In you comment it is not complete.

Copy/paste error. Apologies.

Hello,

I made the following test on my local dev box.

1. Initial setup, using pgadmin (trying to emulate what your provider's script does):
   • created new login role 'test14151' with password 'test', with no special privileges
   • created new, empty db 'db14151' with login role 'test14151' as owner
2. Mantis install
   • ran install.php with
   • hostname: localhost
   • username: test14151, password: test
   • database: db14151
   • admin user: test14151, password: test

The install script ran fine, and the schema was created successfully. I am therefore not able to reproduce your problem with the information provided

Without additional details as to how your host has setup your DB and user account in terms of privileges, I'm afraid I will not be able to help you more. Can you provide the SQL scripts used to create your setup, or a configuration report ?

It looks like this is a configuration option.
I ask my provider for details.

My provider said, that this behaviour is managed by user configuration options in Postgress. I failed to get more information ((

In that case, I am afraid that there is no chance for me to troubleshoot this problem.

Since you were able to create your database in the end, then I am again resolving this issue. Feel free to reopen it (again) if you are able to get more info on the detailed PostgreSQL setup they are using.

The only thing that they have said, was: each user have access to only one database (db name coincides with user login).
And forwarded me to Postgress docs!!!
Is this enough information?

Not really no, I'm sorry.