r3 - 19 Jul 2007 - 06:24:00 - MimiYinYou are here: OSAF >  Journal Web  >  QualityAssuranceTeam > AdamChristianNotes > AdamChristianQACosmoSetup

Setting up QA Cosmo

Steps:

  1. We are assuming there is already a Cosmo instance running if there isn't skip to 3, then move to 6
    If there is do:
    sudo bin/cosmo_ctrl_sudo stop
    
  2. Login to qacosmo.osafoundation.org as osafuser ( ssh -losafuser qacosmo.osafoundation.org )
  3. wget newCosmoBundle
  4. mv OldCosmoBundle? into oldBundles folder
  5. Remove old symlink
    rm cosmo
    
  6. Recreate symlink to cosmo
    ln -s newBundle cosmo
    
  7. edit newBundle/etc/cosmo.properties to look like:
    #cosmo.hibernate.dialect=org.hibernate.dialect.DerbyDialect
     cosmo.hibernate.dialect=org.osaf.cosmo.hibernate.CosmoMySQL5InnoDBDialect
    #cosmo.hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
    
  8. edit newBundle/tomcat/conf/server.xml

    Database Section: (Tell it to use mySQL)

    <!-- Derby configuration
             The default configuration has Cosmo running against
             and embedded Derby database -->
    <!--    <Resource name="osafsrv/db"
                  type="javax.sql.DataSource"
                  maxActive="100"
                  maxIdle="30"
                  maxWait="10000"
                  username="sa"
                  password=""
                  driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
                  url="jdbc:derby:db;create=true"/>
       -->
        <!-- MySQL configuration
             Comment the above Resource and uncomment the following
             Resource to configure Cosmo to run against a MySQL DB   -->
            <Resource name="osafsrv/db"
                 type="javax.sql.DataSource"
                 maxActive="100"
                 maxIdle="30"
                 maxWait="10000"
                 username="root"
                 password="osafuser"
                 defaultAutoCommit="false"
                 driverClassName="com.mysql.jdbc.Driver"
                 url="jdbc:mysql://localhost:3306/cosmo?useUnicode=true&amp;characterEncoding=UTF-8"/>
    

    Port Configuration: (we want it running on port 80)

      <Service name="Catalina">
        <Connector port="80" enableLookups="false"
                   minSpareThreads="4" maxSpareThreads="50"
                   maxThreads="200"/>
    
  9. Clear out the db
    mysql -uroot -posafuser
     drop database cosmo;
    create database cosmo default character set utf8;
    
  10. Start the Cosmo bundle running:
    cd ~/
    sudo bin/cosmo_ctrl_sudo start
    

You should now be able to goto qacosmo.osafoundation.org on port 80 and use the app! Yahoo.

Edit | WYSIWYG | Attach | Printable | Raw View | Backlinks: Web, All Webs | History: r3 < r2 < r1 | More topic actions
 
Open Source Applications Foundation
Except where otherwise noted, this site and its content are licensed by OSAF under an Creative Commons License, Attribution Only 3.0.
See list of page contributors for attributions.