...

Make a note of the database host name, e.  This should be a CNAME in GoDaddy, not direct connection to RDS e.g. repo.c5sxx7pot9i8.us-east-1.rds.amazonaws.comsyndb-prod.sagebase.org

Download mysql-connector-java-5.1.16.tar.gz and copy it to /usr/local

...

Database: MySQL

JDBC URL:  jdbc:mysql://repo.c5sxx7pot9i8.us-east-1.rds.amazonaws.comsyndb-prod.sagebase.org/crowd?autoReconnect=true&characterEncoding=utf8&useUnicode=true

...

curl -u platform:[password] -H "Accept: application/xml" -H "Content-Type: application/xml" -v -k -d "<?xml version='1.0' encoding='UTF-8'?> <authentication-context> <username>[username]</username></authentication-context>" -X POST https://crowd.sagebase.org:8443/crowd/rest/usermanagement/latest/session?validate-password=false

Response should include a HTTP status of 201 and a session token

...

To check if Crowd is up, in web browser go to the appropriate URL as defined above. 
You should see Crowd log-in page.  If not then ssh in to xxx-crowd.sagebase.org as ec2-user, using the standard key for 'platform' owned ec2 instances, PlatformKeyPairEast

At the unix prompt:

      ps -efwww | grep java

Should show one java process, if not
      cd /usr/local/atlassian-crowd-2.2.7/

     ./start_crowd.sh

Now verify that the log-in page appears in your web browser.

If crowd is running and you feel the need to 'bounce' the server, make sure to stop crowd before running "start_crowd.sh".  To do this, run

    ./stop_crowd.sh

from /usr/local/atlasssian-crowd-2.2.7/.  Use the aforementioned "ps -ef..." command to make sure no Crowd java process is running.  If necessary, 'kill' lingering instances before running "start_crowd.sh".  It's important not to have multiple instances of the java process runnning.sudo reboot

The machine should restart keeping the existing elastic ip.

Changing Crowd Database URL

In order to change the database URL used by crowd, you will need to edit one of the configuration files:

Attempting to change the database url for Crowd

1. ssh into prod-crowd 
2. Made a copy of the config file:
   
   1. cp /var/crowd-home/crowd.cfg.xml /var/crowd-home/crowd.cfg-old.xml
   2. changed /var/crowd-home/crowd.cfg.xml:
      
      1. from: <property name="hibernate.connection.url">jdbc:mysql://<old_db_host>/crowd_prod?autoReconnect=true&amp;characterEncoding=utf8&amp;useUnicode=true</property> 
      2. to: <property name="hibernate.connection.url">jdbc:mysql://<new_db_host>/crowd_prod?autoReconnect=true&amp;characterEncoding=utf8&amp;useUnicode=true</propert>
3. Reboot the crowd machine:
   1. sudo reboot