View Issue Details

IDProjectCategoryView StatusLast Update
0015589mantisbtdb postgresqlpublic2014-12-08 00:34
Reportervilarion Assigned Todregad  
PrioritynormalSeveritycrashReproducibilityalways
Status closedResolutionfixed 
Product Version1.2.14 
Target Version1.3.0-beta.1Fixed in Version1.3.0-beta.1 
Summary0015589: Upgrade fails with postgresql
Description

There are two issues when upgrading to version 1.2.14 when using a postgresql database. All these errors occur in admin/install.php

First the system prevents you from having an empty hostname, which is what you need when connecting via unix sockets and it gives you an incorrect error message:
"database connection settings do not exist?"
(probably this check is made more than once in different places)

Second, the connection fails, because you need to supply the database name in line 302: $t_result = @$g_db->Connect( $f_hostname, $f_admin_username, $f_admin_password )
(as fourth parameter)
This error probably also occurs somewhere else in admin/install.php
(e.g. installation)
The (incorrect) error message here is: "Does administrative user have access to the database?"

TagsNo tags attached.

Relationships

related to 0017627 closeddregad Unable to upgrade to 1.2.17 from 1.2.16 (and to 1.2.16 from 1.2.15) using PostgreSQL 
child of 0014398 closeddregad Support for PostgreSQL broken in 1.3 

Activities

dregad

dregad

2014-02-24 15:24

developer   ~0039513

First the system prevents you from having an empty hostname, which is what you need when connecting via unix sockets

I suggest you use 'localhost'

and it gives you an incorrect error message: "database connection settings do not exist?"

In current master branch, the message states "BAD host name is blank"

There have been many improvement and fixes for Postgres support; I will therefore resolve this now.

If you are willing to test, please try to upgrade using a nightly build from master and report a new issue if you are still experiencing errors.