Server4You

General Data

• http://euve33303.vserver.de
• Ubuntu 12.04.5 LTS (see file /etc/issue)
• root Halloo0@1
• architecture 64bit

lscpu | grep Architecture
Architecture:          x86_64

• connect with Ubuntu

ssh root@euve33303.vserver.de
Nautilus->File->Connect to Server->SSH 

• connect with Windows

WinSCP

Operation

• Login with C:\Uwes\Programme\WinSCP\WinSCP.exe
• Reboot with

reboot

Installation

• apt-get install proftpd (but not used yet)

Java

Original

• java /usr/lib/jvm/jdk1.7.0
• JAVA_HOME variable set to /usr/lib/jvm/jdk1.7.0 in /etc/environment
• apt-get install unzip

Upgrade to Java 8

• following advice from here:

sudo apt-get install python-software-properties
sudo add-apt-repository ppa:webupd8team/java
sudo apt-get update
sudo apt-get install oracle-java8-installer
java -version // delivers java version "1.8.0_45"

JBoss

Upgrade to JBoss 6.4

• copy locally de-zipped file to /usr/local/share/jboss/jboss-eap-6.4/
• rename old installation directory to /usr/local/share/jboss/jboss-eap-6.1_obsolete/
• adjust /etc/init.d/jbossas7 to new path
• do ajp configuration, mysql deployment, data source configuration, DB validation like below
• log in /usr/local/share/jboss/jboss-eap-6.4/standalone/log/

JBoss 6.1

• JBoss by copying local Zip-file of EAP 6.1 to server to /usr/local/share/jboss/jboss-eap-6.1/bin and install according chapter 3.2.2 in https://access.redhat.com/site/documentation/en-US/JBoss_Enterprise_Application_Platform/6.1/pdf/Installation_Guide/JBoss_Enterprise_Application_Platform-6.1-Installation_Guide-en-US.pdf
• add administration user by /usr/local/share/jboss/jboss-eap-6.1/bin/add-user.sh with user UweHeuer and password Halloo0@1 according https://www.digitalocean.com/community/articles/how-to-install-jboss-on-ubuntu-12-10-64bit, server can be started and stopped by

./standalone.sh -Djboss.bind.address=80.86.91.46 -Djboss.bind.address.management=80.86.91.46 &
./jboss-cli.sh --connect --controller=80.86.91.46:9999 command=:shutdown

• add ajp to connect to http proxy for uweheuer and jboss console to /usr/local/share/jboss/jboss-eap-6.4/standalone/configuration/standalone.xml

<connector name="ajp" protocol="AJP/1.3" socket-binding="ajp" enabled="true"/>

• create MyUbuntuService.sh in HP Laptop JBoss bin directory as Unix file, copy to /usr/local/share/jboss/jboss-eap-6.1/bin and copy it to /etc/init.d/jbossas7 and

update-rc.d jbossas7 defaults

• copy mysql-connector-java-5.1.27-bin.jar to <JBOSS_HOME>\standalone\deployments or using deployment via Web console and enable it (e.g. on HomePC New)
• use Web console -> Profile (not Runtime) and add datasource MySQLDS with JNDI name java:jboss/datasources/MySQLDS and UwesWikiDS with JNDI name java:jboss/datasources/UwesWikiDS, select the MySQL Driver above, enter connection info user 'root' and pwd 'Halloo0@1' => configuration is saved in standalone configuration file <JBOSS_HOME>\standalone\configuration\standalone.xml
• in order to avoid connection loss to MySQL DB validation enabled for MySQLDS by setting background validation, time intervall and simple SQL statement SELECT 1(configuration is stored in standalone.xml). In the literature there is another validation approach by specifying a standard JBoss validation class.
• chmod +x /etc/rc.d/init.d/jbossas7

PHPMyAdmin

• set password for mysql user root@localhost according to http://www.unixmen.com/howto-install-amp-and-phpmyadmin-on-ubuntu/

SET PASSWORD FOR 'root@localhost' = PASSWORD('Halloo0@1');

• install phpmyadmin according http://www.unixmen.com/howto-install-amp-and-phpmyadmin-on-ubuntu/

Apache

• added to /etc/apache2/sites-enabled/000-default proxy configuration to JBoss for uweheuer application
• sudo a2enmod proxy_ajp (creates /etc/apache2/mods-enabled/proxy.conf und proxy_ajp.conf)
• cp /mods-enabled/proxy.conf as backup to proxy.conf.bak
• edit proxy.conf (Deny from all to Allow from all)
• cp /sites-enabled/000-default to 000-default.bak as backup
• edit 000-default (add ProxyPass und ProxyReversePass)
• restart apache with sudo /etc/init.d/apache2 restart

MySQL

• change /etc/mysql/my.conf bind-address to 0.0.0.0 to make mysql listen on all available IPs to enable remote access
• add user 'root' with host '%' and password 'Halloo0@1' to enable remote access
• /etc/init.d/mysql restart

UweHeuer

• edit /etc/mediawiki/apache.conf
• restart apache with sudo /etc/init.d/apache2 restart
• set in /etc/php5/apache2/php.ini and restart apache

safe_mode = Off

• copy content of mediawiki-1.25.1.tar.gz to /var/lib/mediawiki
• installation via first call http://localhost/mediawiki
  • Admin username: WikiSysop halloo
  • Database name: mediawiki
  • DB user: root
  • DB password: Halloo0@1
• all settings are stored in \var\lib\mediawikiLocalSettings.php
• copy from Laptop to New Home PC via CopyUwesWikiToVServer.bat