Can you please test against the latest development snapshot of 1.2.x? There have been a couple changes targetting Postgres recently.

http://git.mantisbt.org/

Thank you.

Hi, sorry for delay. I was not monitoring this issue :/

No. It's not working yet. I've tried using the yesterday's nightly build.

The problem is that the database is owned by the administrator account instead of being owned by the mantis user account. The same applies to tables and other objects.

Below you see an example where we could immediately assign the correct owner to the database and other objects. The mantis account ("mantisuser" in the example) must be used instead the database administrator.

CREATE DATABASE bugtracker
WITH OWNER = mantisuser
ENCODING = 'UTF8';

CREATE TABLE mantis_bug_file_table
(
id serial NOT NULL,
bug_id integer NOT NULL DEFAULT 0,
title character varying(250) NOT NULL DEFAULT ''::character varying,
description character varying(250) NOT NULL DEFAULT ''::character varying,
diskfile character varying(250) NOT NULL DEFAULT ''::character varying,
filename character varying(250) NOT NULL DEFAULT ''::character varying,
folder character varying(250) NOT NULL DEFAULT ''::character varying,
filesize integer NOT NULL DEFAULT 0,
file_type character varying(250) NOT NULL DEFAULT ''::character varying,
date_added timestamp without time zone NOT NULL DEFAULT '1970-01-01 00:00:01'::timestamp without time zone,
"content" bytea NOT NULL,
CONSTRAINT mantis_bug_file_table_pkey PRIMARY KEY (id)
)
WITH (OIDS=FALSE);
ALTER TABLE mantis_bug_file_table OWNER TO mantisuser;

Cheers :)

Richard Gomes
http://www.jquantlib.org/index.php/User:RichardGomes

It looks like the ADODB Datadict doesn't support the "OWNER" clauses directly. I'll have to look into this more. As I recall, if you create the database first the "mantis user" can create the rest of the information.

Hi,

There's another strategy which is trying to use a superuser account if provided. These are the steps:

1. Try to create a 'mantisuser' using the superuser account. This command eventually will fail if 'mantisuser' was already created. This failure can be safely ignored.

2. If step (1) succeded, superuser must assign the informed password to 'mantisuser' account. Abort if fails.

3. If step (1) succeded (yes, step 1!), enough rights must be granted to 'mantisuser'. Abort if fails.

4. Create 'mantisdb' using the superuser account, if it was provided. Otherwise, try to create the database using 'mantisuser' account. This step eventually will fail if superuser account is not provided but 'mantisuser' exists but does not have enough rights to create the database. Abort if fails.

5. Superuser change database ownership to 'mantisuser'. Abort if fails.

6. Create all database objects using 'mantisuser' account and provided passord. This step eventually will fail if provided 'mantisuser' does not have enough rights to create database objects. Abort if fails.

A good source of information is Mediawiki. It does exactly like this, I mean: you have the possibility of creating the 'wikiuser' account and 'wikidb' database in one go and everything runs smoothly.

Thanks

We are resolving this issue as "no change required", because it was reported against an old version of MantisBT which is no longer supported.

We recommend that you upgrade to the latest stable version [1]; if after doing so the problem still exists, do not hesitate to reopen the issue.

[1] http://www.mantisbt.org/download.php