Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0037310Openbravo ERPA. Platformpublic2017-11-16 13:402018-01-03 12:39
Reportergorkaion 
Assigned Togorkaion 
PrioritynormalSeverityminorReproducibilityN/A
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR18Q1 
Merge Request Status
Review Assigned Toalostale
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0037310: Amazon RDS - Postgresql compatibility. Remove superuser role.
DescriptionCurrently it is not possible to build Openbravo using Amazon RDS with PostgreSQL as database.

It is required to remove superuser role from Openbravo database user.
Steps To ReproduceN/A
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0039273 closed alostale PG 11: NPE updating DB 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-11-16 13:40gorkaionNew Issue
2017-11-16 13:40gorkaionAssigned To => gorkaion
2017-11-16 13:40gorkaionModules => Core
2017-11-16 13:40gorkaionTriggers an Emergency Pack => No
2017-11-28 17:17caristuNote Added: 0100791
2017-11-28 17:18caristuNote Edited: 0100791bug_revision_view_page.php?bugnote_id=0100791#r16399
2017-11-28 17:22caristuNote Edited: 0100791bug_revision_view_page.php?bugnote_id=0100791#r16400
2017-11-28 17:36hgbotCheckin
2017-11-28 17:36hgbotNote Added: 0100793
2017-12-01 11:32hgbotCheckin
2017-12-01 11:32hgbotNote Added: 0100886
2017-12-01 11:32hgbotStatusnew => resolved
2017-12-01 11:32hgbotResolutionopen => fixed
2017-12-01 11:32hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/0247affd1bb7dbd9a6e0e265ee6aefd45d0a1211 [^]
2017-12-01 11:53gorkaionReview Assigned To => alostale
2017-12-19 08:01alostaleNote Added: 0101112
2017-12-19 08:01alostaleStatusresolved => closed
2017-12-19 08:01alostaleFixed in Version => 3.0PR18Q1
2018-01-03 12:39hudsonbotCheckin
2018-01-03 12:39hudsonbotNote Added: 0101493
2018-01-03 12:39hudsonbotCheckin
2018-01-03 12:39hudsonbotNote Added: 0101508
2018-09-20 13:39caristuRelationship addedrelated to 0039273

Notes
(0100791)
caristu   
2017-11-28 17:17   
(edited on: 2017-11-28 17:22)
Added changes into dbsm-main repository[1]. See changesets 08ee84691713:caaf4ec353b2


[1] https://code.openbravo.com/erp/devel/dbsm-main [^]
(0100793)
hgbot   
2017-11-28 17:36   
Repository: erp/devel/pi
Changeset: bc62b428fd985c1545ce8e90818221e95d1961cd
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Tue Nov 28 17:36:39 2017 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/bc62b428fd985c1545ce8e90818221e95d1961cd [^]

Related to issue 37310. New dbsourcemanager version to support rds.

To properly support Amazon RDS it is required to create a prescript that it is
executed with systemAdmin user. This new version of dbms enables that ability.

---
M src-db/database/lib/dbsourcemanager.jar
---
(0100886)
hgbot   
2017-12-01 11:32   
Repository: erp/devel/pi
Changeset: 0247affd1bb7dbd9a6e0e265ee6aefd45d0a1211
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Fri Dec 01 11:32:33 2017 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/0247affd1bb7dbd9a6e0e265ee6aefd45d0a1211 [^]

Fixed issue 37310. Add support for Amazon PG RDS database.

Changes required to support Amazon PG RDS.

*bbdd.user is no longer superuser
*new prescript added in postgresql to execute with bbdd.systemUser to create
requried pg extensions that need superuser privileges to execute.
*uuid_generate_v4 function is now created by creating the full uuid-ossp
instead of just the function.

---
M src-db/database/build-create.xml
M src-db/database/build.xml
M src-db/database/model/excludeFilter.xml
M src-db/database/model/postscript-PostgreSql.sql
M src-db/database/model/prescript-PostgreSql.sql
A src-db/database/model/prescript-systemuser-PostgreSql.sql
---
(0101112)
alostale   
2017-12-19 08:01   
reviewed
(0101493)
hudsonbot   
2018-01-03 12:39   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/c81e0d3cbab5 [^]
Maturity status: Test
(0101508)
hudsonbot   
2018-01-03 12:39   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/c81e0d3cbab5 [^]
Maturity status: Test