Hello, I have a problem updating mantis from version 2.2.0 to current 2.23.0. I did all the steps in accordance with the upgrade procedure, but when I run the install.php script I have a problem connecting to the database (psql). Authorized user has full rights to the database. I am asking for help what can cause this problem.
-Attempting to connect to database as admin BAD
Does administrative user have access to the database? ( Database connection failed )
-Checking Database Server Version POSSIBLE PROBLEM
Unable to determine 'pgsql' version. ().
The other fields are verified correctly and I receive the information GOOD.
Best regards
Problem with upgrade
Moderators: Developer, Contributor
Re: Problem with upgrade
There is at least one problem in 2.30.0 installer, that will be fixed in 2.30.1 https://mantisbt.org/bugs/view.php?id=26596
I don't use psql and don't have time to have a deeper look, so I don't know if this bug is causing your problem.
You could try a nightly build to check if the problem is fixed in latest code https://www.mantisbt.org/builds.php
In case it's not fixed, open a bug report on https://www.mantisbt.org/bugs
I don't use psql and don't have time to have a deeper look, so I don't know if this bug is causing your problem.
You could try a nightly build to check if the problem is fixed in latest code https://www.mantisbt.org/builds.php
In case it's not fixed, open a bug report on https://www.mantisbt.org/bugs
Re: Problem with upgrade
Unfortunately, with version 2.24.0 is exactly the same situation. So I reported this problem to the "bugs" section. Thank you for your help.
Re: Problem with upgrade
Problem is that db_user must have access to template1 db. Check your psql logs.
Change (version 2.23.0 - row 404 in admin/install.php)
$t_result = @$g_db->Connect( $f_hostname, $f_admin_username, $f_admin_password);
to
$t_result = @$g_db->Connect( $f_hostname, $f_db_username, $f_db_password, $f_database_name );
and should be working - at least for me.
Change (version 2.23.0 - row 404 in admin/install.php)
$t_result = @$g_db->Connect( $f_hostname, $f_admin_username, $f_admin_password);
to
$t_result = @$g_db->Connect( $f_hostname, $f_db_username, $f_db_password, $f_database_name );
and should be working - at least for me.
-
- Posts: 1
- Joined: 17 Apr 2020, 18:25
Re: Problem with upgrade
I did all the steps in accordance with the upgrade procedure, but when I run the install.php script I have a problem connecting to the database (psql). Authorized user has full rights to the database. I am asking for help what can cause this problem.lampa wrote: ↑23 Jan 2020, 12:27 Problem is that db_user must have access to template1 db. Check your psql logs.
Change (version 2.23.0 - row 404 in admin/install.php)
$t_result = @$g_db->Connect( $f_hostname, $f_admin_username, $f_admin_password);
to
$t_result = @$g_db->Connect( $f_hostname, $f_db_username, $f_db_password, $f_database_name );
and should be working - at least for me.