Home

Welcome to the vslAdmin wiki!

From development machine

• Update data in the application using the loadCsvController

• Export with:
  mysqldump vermontDev > /Users/paulw/dev/vtgov/vslAdmin/mysql/vermontDev.dmp

• Import with: mysql -u ptwebb -p vermontDev < /Users/paulw/dev/vtgov/vslAdmin/mysql/vermontDev.dmp

• grails war

• scp -i ~/.ssh/LincolnEC2key.pem ~paulw/dev/vtgov/vslAdmin/target/vslAdmin-0.1.war [email protected]:

###From ec2:

• Install mySql and load initial database sudo yum install mysql-server sudo yum install mysql-devel sudo service mysqld start /usr/bin/mysql_secure_installation mysql -u root -p CREATE USER 'ec2-user'@'localhost' IDENTIFIED BY ''; GRANT ALL PRIVILEGES ON * . * TO 'ec2-user'@'localhost'; mysql -u ec2-user -p create database Vermont; wget https://raw.github.com/paultwebb/vslAdmin/master/mysql/vermontDev.dmp mysql -u ec2-user -p Vermont < vermontDev.dmp mysql -u ec2-user -p show sessions

Install tomcat and deploy sudo yum install tomcat6 sudo service tomcat6 start sudo usermod -a -G tomcat ec2-user cd /usr/share/tomcat6/conf cat tomcat6.conf > tomcat6.conf.orig vi tomcat.conf add JAVA_OPTS="-XX:MaxPermSize=128M" sudo chgrp tomcat /usr/share/tomcat6/ sudo service tomcat6 stop sudo service tomcat6 start

scp [email protected]:VermontHouse-0.1.war . mv vslAdmin-0.1.war /usr/share/tomcat6/webapps/

http://ec2-54-224-96-62.compute-1.amazonaws.com:8080/vslAdmin