Setting up QA Cosmo

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.