Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0014787Openbravo ERPK. Packagingpublic2010-10-06 12:102018-04-06 18:09
Reporterrafaroda 
Assigned Togorka_gil 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionout of date 
PlatformOS20OS VersionProfessional Appliance
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0014787: 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).
Steps To Reproduce
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 [^]
Additional Information
TagsOB3 Documentation
Relationships
related to feature request 0014788 new Triage Platform Base ant install.source without Oracle user creation 
Attached Filespng DBUserRoles.png (28,063) 2010-10-06 12:10
https://issues.openbravo.com/file_download.php?file_id=3168&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2010-10-06 12:10rafarodaNew Issue
2010-10-06 12:10rafarodaAssigned To => jpabloae
2010-10-06 12:10rafarodaFile Added: DBUserRoles.png
2010-10-06 12:18rafarodaRelationship addedrelated to 0014788
2010-10-06 16:26rafarodaDescription Updatedbug_revision_view_page.php?rev_id=1006#r1006
2011-08-24 12:58jpabloaeAssigned Tojpabloae => gorka_gil
2013-06-12 14:57psanjuanProjectDocumentation => Openbravo ERP
2013-06-12 14:58psanjuanModules => Core
2013-06-12 14:58psanjuanTriggers an Emergency Pack => No
2013-06-12 14:58psanjuanCategoryERP Installation Guide => K. Packaging
2013-06-12 14:58psanjuanTag Attached: OB3 Documentation
2018-04-06 18:09shuehnerStatusnew => closed
2018-04-06 18:09shuehnerResolutionopen => out of date

There are no notes attached to this issue.