Data Base Preparation

From MT Marvelit
(Redirected from Data Base Preparation MySQL)
Jump to: navigation, search

MARVELit DASH can obtain data from many types of data sources and use it in creating Charts, Meters and Reports. Additionally, Portal settings and other configuration information needs to be stored in a data base as well.

Apache Jetspeed 2.1 is the portal used in MARVELit DASH. Jetspeed supports several different database systems (mysql, postgres, hsql, derby, oracle, mssql) for storing portal configuration information.

Create Schema

SetPortalSchemaNEW.jpg

We will demonstrate creating a schema for Jetspeed using the MySQL Administration Manager application. You can choose many different tools to accomplish this. Use the one that you are most comfortable with.

We started the Administration application - clicked Catalogs - clicked the + icon at the bottom of the Schemata List and entered dash as our database. Any name can be used. Just remember it as you will need it during the configuration tasks.















Create User

SetPortalUserNEW.jpg

Once the schema is created, a user needs to be created that will have access to that schema. Once again we used the MySQL Administration application. We created a user named marvelit with access from localhost.















Set User Privliges

Finally the user needs to have full control over the schema. Once again we used the MySQL Administration application.

SetPortalPrivNEW.jpg



Once JAVA is installed and the data base is set up to receive the portal configuration tables - you can proceed to the next step.