Jump to content

Recommended Posts

Posted

I know enough PHP and MySQL to be dangerous and have configured a few PHP-based blogs on my accounts here.

 

I'd like to get this software installed:

 

http://www.theospi.org/

 

and can't make heads or tails out of these directions. WTF is Tomcat? Do we have it here at TCH? Can anyone help?

 

Thanks, kj

 

>>>>>

Guide for getting OSP 1.5 up and running

Software requirements

 

* tomcat 4.1.18+ (we've done some limited testing on tomcat 5, without any issue)

* java 1.4.1+

* access to mysql, oracle, or postgresql database

 

Introduction

 

Setup can now be completely performed from the web interface. No more modifying config files, and running ant tasks. The web interface will create your database connection, create your tables, allow you to configure common properties, manage users, and more.

Follow these instructions

 

* copy the portfolio.war into the $TOMCAT_HOME/webapps directory

*

 

copy your database driver into $TOMCAT_HOME/common/lib

o The database driver is a JAR file located somewhere in your database directory hierarchy, or available for download from your database vendor

o Oracle: Typically this is at $ORACLE_HOME/jdbc/lib/ojdbc14.jar or similar

o MySQL: You can download the my SQL driver at http://dev.mysql.com/downloads/connector/j/3.0.html

* start tomcat

* point a browser to http://localhost:8080/portfolio

* login with admin/admin

* goto admin menu/database

*

 

setup your database properties

o For Oracle: Database Class Name: oracle.jdbc.driver.OracleDriver; JDBC URL: jdbc:oracle:thin:@localhost:1521:foliotst (if the database is named "foliotst" and lives on your local machine)

* after database properties validate, create tables

* restart tomcat

* logon again with admin/admin

* goto admin menu/authentication

* select 'Database' authentication type

* check validate, click submit

* goto admin menu/properties

* configure properties, validate, and submit

* goto admin menu/add user, create a user with user type of admin

* restart tomcat

* relogon with user you created in step 16, admin/admin will not work anymore

 

You are done.

Notes

 

The database connection pool is no longer setup in tomcat's server.xml. Following the process above will create a $TOMCAT_HOME/webapps/portfolio.xml file with the portfolio context definition automatically. The context definition includes the database connection pool properties. Do not include a portfolio context in your server.xml you will have problems. If you are using tomcat 5, the context file will be created as $TOMCAT_HOME/conf/Catalina/localhost/portfolio.xml

 

While you can still use the 'db' ant task to create and populate the database, using the web interface will save you the pain of having to create db-type-mappings in your dbloader.xml. The web interface reads the properties from your driver and does this all for you.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...