Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0014787
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] K. Packagingmajoralways2010-10-06 12:102018-04-06 18:09
ReporterrafarodaView Statuspublic 
Assigned Togorka_gil 
PrioritynormalResolutionout of dateFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionProfessional ApplianceDatabase version8.3.9Ant version1.7.1
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0014787: Document how to install OB from sources if no SID admin Oracle

DescriptionIf, for security reasons, one does not have the admin credentials of the Oracle SID where Openbravo will be installed, detail the steps to follow.

We did the following:
1) In a environment where you have the Oracle SID admin, configure your Openbravo.properties file http://wiki.openbravo.com/wiki/ERP/2.50/Openbravo.properties#Database [^]
2) Remove the content of referencedata/sampledata https://code.openbravo.com/erp/devel/pi/file/tip/referencedata/sampledata [^]
3) Launch: ant create.database
4) Export this schema to a DMP file http://wiki.openbravo.com/wiki/ERP/2.50/Developers_Guide/Concepts/Development_Model#Export [^] Download the result of the clean Openbravo ERP 2.50 MP21 DMP @ http://uploading.com/files/c424m43m/cleanmp21db_ora.dmp/ [^]
5) In the environment where you do not have Oracle SID admin, ask to create a user with the permissions shown in the image attached.
6) Configure Openbravo.properties in this new environment, leaving bbdd.systemUser and bbdd.systemPassword blank.
7) Import the DMP file into this schema http://wiki.openbravo.com/wiki/ERP/2.50/Developers_Guide/Concepts/Development_Model#Import [^]
8) Launch: ant core.lib wad.lib trl.lib compile.complete
9) Create a war file: ant war
10) Copy this war file into Tomcat webapps folder

(steps 8, 9 and 10 replace: ant install.source which can not be launched because not having SID admin credentials).
Proposed SolutionExplanation should be place somewhere between:
* http://wiki.openbravo.com/wiki/ERP/2.50/Openbravo_ERP_Installation/Custom_Installation [^]
* http://wiki.openbravo.com/wiki/ERP/2.50/Openbravo_environment_installation#Oracle_database [^]
TagsOB3 Documentation
Attached Filespng file icon DBUserRoles.png [^] (28,063 bytes) 2010-10-06 12:10

- Relationships Relation Graph ] Dependency Graph ]
related to feature request 0014788 newTriage Platform Base ant install.source without Oracle user creation 

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2010-10-06 12:10 rafaroda New Issue
2010-10-06 12:10 rafaroda Assigned To => jpabloae
2010-10-06 12:10 rafaroda File Added: DBUserRoles.png
2010-10-06 12:18 rafaroda Relationship added related to 0014788
2010-10-06 16:26 rafaroda Description Updated View Revisions
2011-08-24 12:58 jpabloae Assigned To jpabloae => gorka_gil
2013-06-12 14:57 psanjuan Project Documentation => Openbravo ERP
2013-06-12 14:58 psanjuan Modules => Core
2013-06-12 14:58 psanjuan Triggers an Emergency Pack => No
2013-06-12 14:58 psanjuan Category ERP Installation Guide => K. Packaging
2013-06-12 14:58 psanjuan Tag Attached: OB3 Documentation
2018-04-06 18:09 shuehner Status new => closed
2018-04-06 18:09 shuehner Resolution open => out of date


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker