View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0014720 | mantisbt | db postgresql | public | 2012-09-19 10:29 | 2015-03-25 17:50 |
Reporter | peeter | Assigned To | dregad | ||
Priority | normal | Severity | block | Reproducibility | always |
Status | closed | Resolution | unable to reproduce | ||
Platform | PC | OS | Ubuntu Linux | OS Version | 12.04 LTS |
Product Version | 1.2.10 | ||||
Summary | 0014720: install.php: INSERT INTO mantis_config_table fails | ||||
Description | APPLICATION ERROR 0000401 | ||||
Steps To Reproduce | Install mantis package 1.2.10-1. $ diff -c install.php install.php.orig * 776,787 **
! $t_query_create ="CREATE USER ".$f_db_username." WITH PASSWORD '".$f_db_password."' ";
! $t_query_grant ="GRANT ALL PRIVILEGES ON DATABASE ".$f_database_name." TO ".$f_db_username." ";
--- 776,787 ----
! $t_query_create ="CREATE USER '".$f_db_username."' WITH PASSWORD '".$f_db_password."' ";
! $t_query_grant ="GRANT ALL PRIVILEGES ON DATABASE '".$f_database_name."' TO '".$f_db_username."' ";
(The change in both cases is to remove some single quotes.) Running the modified install.php, I get success with the two early errors, but now I get the following error: APPLICATION ERROR 0000401 | ||||
Additional Information | PostgreSQL 9.1.5 on i686-pc-linux-gnu, compiled by gcc (Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3, 32-bit PostgreSQL error log says: With regard to the “authentication failed for user mantis_user” error, I am still able to log in as mantis_user using psql and with the same password I supplied to install.php: | ||||
Tags | No tags attached. | ||||
The mantis-2.x development branch removes the direct INSERT query and offers the user to create a admin user at the end of the install, which avoids this issue. |
|
Marking as 'acknowledged' not resolved/closed to track that change gets ported to master-2.0.x branch |
|
MantisBT currently supports Mysql and has support for other database engines. The support for other databases is known to be problematic. Having implemented the current database layer into Mantis 10 years ago, I'm currently working on replacing the current layer. If you are interested in using Mantis with non-mysql databases - for example, Oracle, PGSQL or MSSQL, and would be willing to help out testing the new database layer, please drop me an email at paul@mantisforge.org In the meantime, I'd advise running Mantis with Mysql Only to avoid issues. Thanks |
|
Reminder sent to: dregad, grangeway Not sure, maybe this issue should be moved back to project mantis. |
|
The referenced code does not exist in any official release of Mantis. Looking at steps to reproduce
Leads me to believe that this refers to the debian package, so it's likely that the installer's code has been modified by the package maintainer. Please report the issue on the debian issue tracker https://packages.debian.org/wheezy/mantis |
|