+- Wight Support Forum (http://wightsupport.com/forum)
+-- Forum: Wightsupport Forums (http://wightsupport.com/forum/forumdisplay.php?fid=1)
+--- Forum: Ubuntu Server (http://wightsupport.com/forum/forumdisplay.php?fid=6)
+--- Thread: Sysaid Installation (/showthread.php?tid=3)
Sysaid Installation - wightsupport - 21-09-2014
Copied from http://www.sysaid.com/Sysforums/posts/list/8819.page
but amend to work on a non VM client and also using the free version
-----------------------------------------------------------------------------
SYSAID INSTALL
--------- USEFUL LINKS ----------------------------------------------------
sysaid full edition linux = http://cdn3.sysaid.com/sysaid-server-linux.tar.gz
sysaid free edition linux = http://cdn3.sysaid.com/sysaid-server-linux-free.tar.gz
sysaid release upgrade = http://www.sysaid.com/product/sysaid/release-upgrades
sysaid release patches = http://www.sysaid.com/product/sysaid/patches
sysaid free edition = http://www.sysaid.com/product/sysaid/free-edition
http://www.sysaid.com
http://www.sysaid.com/help-page.htm
http://www.sysaid.com/Sysforums/forums/home.page
http://www.sysaid.com/Sysforums/forums/list.page?listType=translations
https://help.ubuntu.com/12.04/serverguide/tomcat.html
https://help.ubuntu.com/12.04/serverguide/mysql.html
https://sites.google.com/site/sysaidwiki/integration/ssoldapintegration
--------- SYSTEM INFO -----------------------------------------------------
OS : Ubuntu Server 14.04 amd64
Sysaid : Sysaid 14.3 linux free version
Java : Oracle Java 7 build 1.7.0_40-b43 - ppa:webupd8team/java
Tomcat : Apache Tomcat 7.0.26
MySQL : MySQL Ver 14.14 Distrib 5.5.38
--------- UPGRADE OS TO LATEST VERSION ------------------------------------
$ sudo apt-get update
$ sudo apt-get dist-upgrade
$ mkdir $HOME/downloads
--------- INSTALL ORACLE JAVA ----------------------------------------------------
$ sudo apt-get install python-software-properties
$ sudo add-apt-repository ppa:webupd8team/java
$ sudo apt-get update
$ sudo apt-get install oracle-java7-installer
$ sudo update-java-alternatives -a
--------- INSTALL TOMCAT --------------------------------------------------
$ sudo apt-get install tomcat7
Now it's time to set some options for tomcat in /etc/default/tomcat7.
Change the JAVA_HOME option to the following and remove the starting #.
Change the JAVA_OPTS option to the following, if you don't do it you will most likely experience tomcat freezing and this error message "java.lang.OutOfMemoryError: PermGen space" in tomcat log.
view plaincopy to clipboardprint?
$ sudo nano /etc/default/tomcat7
JAVA_HOME=/usr/lib/jvm/java-7-oracle
JAVA_OPTS="-Djava.awt.headless=true -Xms1024m -Xmx2048m -XX
ermSize=128m -XX:MaxPermSize=256m -XX:+CMSClassUnloadingEnabled -XX:+CMSPermGenSweepingEnabled -XX:+UseConcMarkSweepGC" $ sudo service tomcat7 restart
--------- INSTALL MYSQL ---------------------------------------------------
$ sudo apt-get install mysql-server
$ mysql_secure_installation
Follow the instructions
Change the root password? [Y/n] Y
New password: ***PASSWORD***
Remove anonymous users? [Y/n] Y
Disallow root login remotely? [Y/n] Y
Remove test database and access to it? [Y/n] Y
Reload privilege tables now? [Y/n] Y
Enable remote access by editing the /etc/mysql/my.cnf file and commented out the line "bind-address = 127.0.0.1" by adding a # in front of it.
view plaincopy to clipboardprint?
$ sudo nano /etc/mysql/my.cnf
#bind-address = 127.0.0.1
$ sudo service mysql restart
Create users and databases in MySQL.
$ mysql -u root -p
mysql> CREATE USER 'yourusername'@'localhost' IDENTIFIED BY '***PASSWORD***';
mysql> GRANT ALL ON *.* TO yourusername@'localhost' IDENTIFIED BY '***PASSWORD***';
mysql> GRANT ALL ON *.* TO yourusername@'%' IDENTIFIED BY '***PASSWORD***';
mysql> CREATE DATABASE sysaiddb01;
mysql> CREATE USER 'sysaid'@'localhost' IDENTIFIED BY '***PASSWORD***';
mysql> GRANT ALL ON sysaiddb01.* TO sysaid@'localhost' IDENTIFIED BY '***PASSWORD***';
mysql> GRANT ALL ON sysaiddb01.* TO sysaid@'%' IDENTIFIED BY '***PASSWORD***';
mysql> FLUSH PRIVILEGES;
mysql> exit
MySQL can be managed with Oracle MySQL Workbench, http://www.mysql.com/products/workbench/.
--------- DEPLOY SYSAID ---------------------------------------------------
Download and extract SysAid.
$ cd $HOME/downloads
$ wget -v http://cdn3.sysaid.com/sysaid-server-linux-free.tar.gz
$ tar xzvf sysaid-server-linux-free.tar.gz
open a new ssh/terminal/shell/console and monitor the tomcat log with this command, in case of error during deploying sysaid.war:
$ tail -f /var/log/tomcat7/catalina.out
Deploy SysAid war-file to tomcat.
$ sudo service tomcat7 stop
$ sudo cp -v $HOME/downloads/sysaid-server-linux/sysaid.war /var/lib/tomcat7/webapps/
$ sudo chown tomcat7:tomcat7 /var/lib/tomcat7/webapps/sysaid.war
$ sudo service tomcat7 start
you can now see in tomcat log that tomcat is now deploying sysaid.war.
WAIT and read the tomcat log till the deployment is done.
It does not say when it is done so give it a couple of minutes till the log don't post more.
When the deployment is done, you can remove sysaid.war.
$ sudo rm /var/lib/tomcat7/webapps/sysaid.war
Prepare for SysAid initscript and add your SysAid activation.xml license file.
view plaincopy to clipboardprint?
$ sudo service tomcat7 stop
$ sudo cp -v $HOME/downloads/activation.xml /var/lib/tomcat7/webapps/sysaid/WEB-INF/conf/activation.xml
$ sudo chown tomcat7:tomcat7 /var/lib/tomcat7/webapps/sysaid/WEB-INF/conf/activation.xml
I have experienced problems running init-sysaid.sh because it had DOS/Windows newlines, do this to convert it to Unix newlines.
view plaincopy to clipboardprint?
$ cd $HOME/downloads/sysaid-server-linux/
$ cp init-sysaid.sh init-sysaid_old.sh && tr -d '\015' < init-sysaid_old.sh > init-sysaid.sh && rm init-sysaid_old.sh
Run the SysAid init script.
$ sudo sh $HOME/downloads/sysaid-server-linux/init-sysaid.sh /var/lib/tomcat7/webapps/sysaid
Follow the instructions in that initialization script
Please enter the host name or IP address of the MySQL server [localhost]: localhost
Please enter the database name that should contain the SysAid data (please create an empty database with this name) [ilient]: sysaiddb01
Please enter the database login user name [mysql]: sysaid
Please enter the database login password [mysql]: ***PASSWORD***
Would you like to proceed (y/n) ? y
Would you like to check connection (y/n) ? y
Please choose a main user name. Use this login for your first login into SysAid [sysaid]: sysaid
Please choose the password of the sysaid login [changeit]: ***PASSWORD***
$ sudo service tomcat7 restart
If tomcat7 failes to start, delete sysaid logs and try again.
$ sudo rm /var/lib/tomcat7/webapps/sysaid/WEB-INF/logs/*
$ sudo service tomcat7 restart
SysAid can now be accessed at http://<HOST>:8080/sysaid/ (username=sysaid).
IF TOMCAT LOG SHOWS THIS WARNING AND ERROR, JUST IGNORE IT!:
initSysAid is initializing log4j
Initializing log4j with: /var/lib/tomcat7/webapps/sysaid/./WEB-INF/log4j.properties
log4j:WARN No appenders could be found for logger (com.ilient).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
PANIC : error configuring SimpleLog4JLogSystem : java.io.FileNotFoundException: velocity.log (Permission denied)
PANIC : error configuring SimpleLog4JLogSystem : java.io.FileNotFoundException: velocity.log (Permission denied)
--------- MAKE SYSAID THE ROOT ON TOMCAT -------------------------------
$ sudo service tomcat7 stop
$ sudo mv /var/lib/tomcat7/webapps/ROOT /var/lib/tomcat7/webapps/tomcat
$ sudo ln -s /var/lib/tomcat7/webapps/sysaid /var/lib/tomcat7/webapps/ROOT
$ sudo service tomcat7 start
--------- EXTRAS FOR TOMCAT - DEBUG LOGGING -------------------------------
You can enable debug logging by adding "-Dlog4j.debug" at the end of your java options in /etc/default/tomcat7
$ sudo nano /etc/default/tomcat7
JAVA_OPTS="-Djava.awt.headless=true -Xmx128m -XX:+UseConcMarkSweepGC -Dlog4j.debug"
--------- EXTRAS FOR TOMCAT - TOMCAT7-ADMIN -------------------------------
$ sudo apt-get install tomcat7-docs tomcat7-admin tomcat7-examples
Added a user with admin-gui and manage-gui roles to /etc/tomcat7/tomcat-users.xml
$ sudo nano /etc/tomcat7/tomcat-users.xml
<role rolename="manager-gui"/>
<role rolename="admin-gui"/>
<user username="ausername" password="***PASSWORD***" roles="admin-gui,manager-gui"/>
If you want to use tomcat7-admin to deploy WAR-files larger than 50 MB, you have to modify the WAR file size limit in /usr/share/tomcat7-admin/manager/WEB-INF/web.xml
The value is in binary byte, use http://easycalculation.com/bandwidth-calculator.php as help.
$ sudo nano /usr/share/tomcat7-admin/manager/WEB-INF/web.xml
<!-- 200MB max -->
<max-file-size>209715200</max-file-size>
<max-request-size>209715200</max-request-size>
$ sudo service tomcat7 restart
tomcat7-admin can now be accessed at http://<HOST>:8080/ (username=yourusername).
--------- EXTRAS FOR MYSQL - PHPMYADMIN -----------------------------------
$ sudo apt-get install phpmyadmin
Configuration phpmyadmin -> web server to use -> apache2
phpMyAdmin can now be accessed at http://<HOST>/phpmyadmin/ (username=root).
--------- END -------------------------------------------------------------