Server4You

General Data

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

Operation

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

reboot

Installation

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

Java

• 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

JBoss

• 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

<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. 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