Running the installer

Heads up! These docs are for Portofino 3, which is a legacy product. Check out Portofino 4!

The first time you run Portofino, it automatically starts in "installer" mode (if you have Oracle, before you proceed, read the the notes at the end of the page)

Simply connect to http://127.0.0.1:8080/portofino. The following page should appear.

Click on "Proceed". Portofino will connect to the database you've provided in the basic configuration and create the basic metadata structures it need to run.

If everything works correctly, you'll see this confirmation page.

Click on the link. Now you can start using Portofino!

Oracle Notes

Portofino needs two Oracle users to be installed: "meta" and "model". Before you can start the installation you have to create them.

For instance, you can use the following commands:

CREATE USER "model" IDENTIFIED BY password DEFAULT TABLESPACE USERS QUOTA UNLIMITED ON USERS;
CREATE USER "meta" IDENTIFIED BY password DEFAULT TABLESPACE USERS QUOTA UNLIMITED ON USERS;
GRANT CREATE SESSION, CREATE TABLE, CREATE VIEW TO "model";
GRANT CREATE SESSION, CREATE TABLE, CREATE VIEW TO "meta";

Now you can start your installation connecting as User "meta" in your portofino-custom.properties.

database.jdbc.driverClass=oracle.jdbc.driver.OracleDriver
database.jdbc.connectionURL=jdbc:oracle:thin:@localhost:1521:portofinoDB
database.jdbc.username="meta" 
database.jdbc.password=password

Follow the instructions at the top of the page to run the installer.

After the installation, give the privileges to "model" for the "meta" schema

grant all on "meta"."0DPrpt" to "model";
grant all on "meta"."1DPrpt" to "model";
grant all on "meta"."1DPrptType" to "model";
grant all on "meta"."2DPrpt" to "model";
grant all on "meta"."2DPrptType" to "model";
grant all on "meta"."Actor" to "model";
grant all on "meta"."ActorHd" to "model";
grant all on "meta"."Actor_Attr" to "model";
grant all on "meta"."Actor_ObjOp" to "model";
grant all on "meta"."Actor_WfTran" to "model";
grant all on "meta"."Attr" to "model";
grant all on "meta"."AttrCalc" to "model";
grant all on "meta"."AttrVis" to "model";
grant all on "meta"."BlobAttr" to "model";
grant all on "meta"."BoolConstCalc" to "model";
grant all on "meta"."BooleanAttr" to "model";
grant all on "meta"."Calc" to "model";
grant all on "meta"."ClOpVisibilit" to "model";
grant all on "meta"."Cls" to "model";
grant all on "meta"."ClsListener" to "model";
grant all on "meta"."ClsOp" to "model";
grant all on "meta"."DateAttr" to "model";
grant all on "meta"."DateConstCalc" to "model";
grant all on "meta"."DecConstCalc" to "model";
grant all on "meta"."DecimalAttr" to "model";
grant all on "meta"."DnRelSeg" to "model";
grant all on "meta"."DncastSeg" to "model";
grant all on "meta"."FilterOp" to "model";
grant all on "meta"."FuncCalc" to "model";
grant all on "meta"."FuncCalcType" to "model";
grant all on "meta"."GlOpVisibilit" to "model";
grant all on "meta"."GlobalOp" to "model";
grant all on "meta"."GrpActor" to "model";
grant all on "meta"."HtmlPortlet" to "model";
grant all on "meta"."Instance" to "model";
grant all on "meta"."IntConstCalc" to "model";
grant all on "meta"."IntegerAttr" to "model";
grant all on "meta"."JavaClsLst" to "model";
grant all on "meta"."JavaWfAction" to "model";
grant all on "meta"."Jrpt" to "model";
grant all on "meta"."JrptPar" to "model";
grant all on "meta"."JrptVisibilit" to "model";
grant all on "meta"."MetaUserGrp" to "model";
grant all on "meta"."ObjOp" to "model";
grant all on "meta"."ObjSetOp" to "model";
grant all on "meta"."ObjSetOpVis" to "model";
grant all on "meta"."Op" to "model";
grant all on "meta"."Orientation" to "model";
grant all on "meta"."PathActor" to "model";
grant all on "meta"."PathEl" to "model";
grant all on "meta"."PathHd" to "model";
grant all on "meta"."PathSeg" to "model";
grant all on "meta"."Portlet" to "model";
grant all on "meta"."PortletVis" to "model";
grant all on "meta"."Portlet_Cls" to "model";
grant all on "meta"."Prpt" to "model";
grant all on "meta"."Prpt_WfState" to "model";
grant all on "meta"."RAC" to "model";
grant all on "meta"."RACPathHd" to "model";
grant all on "meta"."RelAttr" to "model";
grant all on "meta"."ScriptClsLst" to "model";
grant all on "meta"."ScriptWfAct" to "model";
grant all on "meta"."StrConstCalc" to "model";
grant all on "meta"."TextAttr" to "model";
grant all on "meta"."TimeFilterTyp" to "model";
grant all on "meta"."TimeUnit" to "model";
grant all on "meta"."UpRelSeg" to "model";
grant all on "meta"."User" to "model";
grant all on "meta"."UserGrp" to "model";
grant all on "meta"."User_UserGrp" to "model";
grant all on "meta"."Visibility" to "model";
grant all on "meta"."WfAction" to "model";
grant all on "meta"."WfAttr" to "model";
grant all on "meta"."WfGuard" to "model";
grant all on "meta"."WfNot" to "model";
grant all on "meta"."WfState" to "model";
grant all on "meta"."WfTran" to "model";
grant all on "meta"."WfTran_WfActi" to "model";

Now change your portofino-custom.properties (see below) to connect as the user "model" and you can start using Portofino.

database.jdbc.driverClass=oracle.jdbc.driver.OracleDriver
database.jdbc.connectionURL=jdbc:oracle:thin:@localhost:1521:portofinoDB
database.jdbc.username="model" 
database.jdbc.password=password

Previous: Deploying on OC4J
Next: Optimizing the configuration