Openbravo Issue Tracking System - Openbravo ERP | |||||||||||||||||||
View Issue Details | |||||||||||||||||||
ID | Project | Category | View Status | Date Submitted | Last Update | ||||||||||||||
0045385 | Openbravo ERP | A. Platform | public | 2020-11-05 15:52 | 2020-11-27 07:23 | ||||||||||||||
Reporter | shuehner | ||||||||||||||||||
Assigned To | shuehner | ||||||||||||||||||
Priority | normal | Severity | major | Reproducibility | have not tried | ||||||||||||||
Status | closed | Resolution | fixed | ||||||||||||||||
Platform | OS | 5 | OS Version | ||||||||||||||||
Product Version | |||||||||||||||||||
Target Version | PR21Q1 | Fixed in Version | PR21Q1 | ||||||||||||||||
Merge Request Status | |||||||||||||||||||
Review Assigned To | |||||||||||||||||||
OBNetwork customer | |||||||||||||||||||
Web browser | |||||||||||||||||||
Modules | Core | ||||||||||||||||||
Support ticket | |||||||||||||||||||
Regression level | |||||||||||||||||||
Regression date | |||||||||||||||||||
Regression introduced in release | |||||||||||||||||||
Regression introduced by commit | |||||||||||||||||||
Triggers an Emergency Pack | No | ||||||||||||||||||
Summary | 0045385: Cannot run and create.database twice against AWS RDS database: ERROR: must be owner of database openbravo | ||||||||||||||||||
Description | Using Amazon RDS postgres variant running ant create.database a second time fails with error /opt/OpenbravoERP/src-db/database/build-create.xml:104: org.postgresql.util.PSQLException: ERROR: must be owner of database openbravo Cause is the 'postgres' aka masteruser from RDS with role rds_superuser does not allow 'drop database' if a database not owned by this user. That is different behavior from 'postgres' superuser in standard PostgreSQL which allows doing that. | ||||||||||||||||||
Steps To Reproduce | Create Amazon RDS environment (i.e. v12) configure Openbravo.properties: - bbdd.url to point to 'endpoint' for RDS instance - user + userPassword i.e. tad/tad (not important) - systemUser = <username of masteruser on RDS creation> - systemPassword = <password of masteruser> ant create.database (first time) ant create.database (2nd time) Observe the permissions error on 2nd run when the 'drop database openbravo' SQL command is executed. | ||||||||||||||||||
Proposed Solution | |||||||||||||||||||
Additional Information | |||||||||||||||||||
Tags | No tags attached. | ||||||||||||||||||
Relationships |
| ||||||||||||||||||
Attached Files | |||||||||||||||||||
Issue History | |||||||||||||||||||
Date Modified | Username | Field | Change | ||||||||||||||||
2020-11-05 15:52 | shuehner | New Issue | |||||||||||||||||
2020-11-05 15:52 | shuehner | Assigned To | => shuehner | ||||||||||||||||
2020-11-05 15:52 | shuehner | Modules | => Core | ||||||||||||||||
2020-11-05 15:52 | shuehner | Triggers an Emergency Pack | => No | ||||||||||||||||
2020-11-25 18:23 | shuehner | Status | new => scheduled | ||||||||||||||||
2020-11-25 18:27 | hgbot | Note Added: 0124621 | |||||||||||||||||
2020-11-27 07:23 | hgbot | Note Added: 0124638 | |||||||||||||||||
2020-11-27 07:23 | hgbot | Resolution | open => fixed | ||||||||||||||||
2020-11-27 07:23 | hgbot | Status | scheduled => closed | ||||||||||||||||
2020-11-27 07:23 | hgbot | Fixed in Version | => PR21Q1 | ||||||||||||||||
2020-11-27 07:23 | hgbot | Note Added: 0124639 | |||||||||||||||||
2023-02-28 12:27 | shuehner | Relationship added | causes 0051718 |
Notes | |||||
|
|||||
|
|
||||
|
|||||
|
|
||||
|
|||||
|
|