Editing HomePCNew (section)

===MyProgs===
* see /myprogs/
* DisAndEnableUweHeuer.bat for UweHeuer App

====MySQL====
* Ubuntu Software-Center -> MySQL Server
* mysql --user=root works
* decommend bind-address in /etc/mysql/mysql.conf.d/mysqld.cnf
* change root password by
 mysql --user=root
 UPDATE mysql.user SET Password = PASSWORD("root") WHERE user = "root";
 FLUSH PRIVILEGES;
* to avoid login conflicts for different root user, delete all root user except the one with host = %

====Nemo====
* install Nemo via Ubuntu Software-Center
* top element in left icon bar
* set Nemo as default by editing /usr/share/applications/nemo.desktop and extend exec command to
 Exec=gksudo -k -u root nemo
 xdg-mine default nemo.desktop inode/directory application/x-gnome-saved-search
* set Nemo as start as root by 
* set default view by Bearbeiten -> Einstellungen -> Ansichten -> Select Listenansicht
* set split view by Bearbeiten -> Einstellungen -> Verhalten -> Immer in Zweispaltenansicht starten

=====Operation=====
* F3 creates split screen
* SSH: Menu->Datei->Mit Server verbinden ...->Select SSH

====OpenSSH====
* to enable login via SSH
 apt-get install openssh-server
* check if ssh is running by 
 sudo netstat -tuplen | grep 22
* login e.g. by WinSCP with uwe and halloo

* to enable root login give root a password by
 sudo passwd root
* in /etc/ssh/sshd_config change 
 PermitRootLogin yes
* restart ssh service
 service ssh restart

====PHP====
* Ubuntu Software-Center -> PHP5

====PHPMyAdmin====
* Ubuntu Software-Center -> phpmyadmin
* add to /etc/apache2/apache2.conf
 Include /etc/phpmyadmin/apache.conf
* /etc/init.d/apache2 reload
* sudo dpkg-reconfigure phpmyadmin
 DB-User: root
 DP-PWD: root
 PHPMyAdmin DB Name: phpmyadmin
* decommend line with AllowNoPassword in /etc/phpmyadmin/config.inc.php

====Postfix====
* installation according to [http://wiki.ubuntuusers.de/Postfix here]
 sudo apt-get install postfix libsasl2-modules bsd-mailx 
 ubuntu-64bit.uweheuer
 [smtp.gmail.com]:587
 uwe.heuer@gmx.de
 ubuntu-64bit, localhost.localdomain, localhost
 ::ffff:127.0.0.0]/104 [::1]/128
 +
 alle
* goes to /etc/postfix/main.cf
* add to it
 smtp_sasl_auth_enable = yes
 # noplaintext weglassen, wenn Passwörter im Klartext übertragen werden müssen:
 # (nicht empfohlen, nur wenn's anders nicht funktioniert)
 smtp_sasl_security_options = noplaintext noanonymous
 smtp_sasl_password_maps = hash:/etc/postfix/sasl_password
* create /etc/postfix/sasl_password by
 sudo touch /etc/postfix/sasl_password
* and add to it
 [smtp.gmail.com]:587 uwe.heuer@gmail.com:Halloo0@1
* secure it by
 sudo chmod 600 /etc/postfix/sasl_password 
* and create db
 sudo postmap hash:/etc/postfix/sasl_password 
* and restart postfix
 sudo /etc/init.d/postfix restart
* add correct sender address by adding /etc/postfix/main.cf
 sender_canonical_maps = hash:/etc/postfix/sender_canonical
* create db by
 postmap /etc/postfix/sender_canonical
* and restart postfix
* add to /etc/postfix/main.cf
 smtp_tls_security_level = may
* restart postfix
* test it by
 mail -s "testbetreff" uwe.heuer@gmx.de < /tmp/testmail.txt
* create /etc/init.d/SendMailAtStartup and chmod +x SendMailAtStartup
* /etc/init.d/sudo update-rc.d SendMailAtStartup start 20 2 3 4 5 .
* /etc/init.d/sudo update-rc.d SendMailAtShutdown stop 20 0 1 6 .

To see the mail in queue use
 mailq

If many mails have been queued e.g. because of an error than you can delete all queued mails by
 su
 postsuper -d ALL

'''Logs''' are in /var/log/mail.err and /var/log/mail.log

====Putty====
* installed via Ubuntu Software-Center

====Samba====
* configuration of shares via Samba (use general ubuntu search with 'Samba' to get the configuration app)
* the configuration goes to /etc/samba/smb.conf
* Share name is UBUNTU64_ROOT, users are (see Einstellungen -> Samba-Benutzer) are 'root' and 'uwe' (! case-sensitive!) with pwd 'Kose059XX'
* to workaround the general error of sharing the root directory ([https://stackoverflow.com/questions/35120186/samba-cannot-access-sub-directories see here]) added to /etc/samba/smb.conf
 # 2017_11_04 UH begin: added to workaround for root sharing
    wide links = yes
    unix extensions = no
 # 2017_11_04 UH end:
* the old workaround to share the backup directory via UBUNTU64_BACKUP share is not needed anymore
* restart of samba server can be done by 
 sudo /etc/init.d/smbd restart
* or
 sudo service smbd restart

====Spotify====
* installed according https://wiki.ubuntuusers.de/Spotify#source-2 (in tip for 15.04 change 1.5.4 to 1.5.3 and 1.1. to 4.2)

====UweHeuer====
* create DB table mysql505 in mysql client with 
 CREATE DATABASE mysql505;
* copy data by
 C:\Uwes\Batches>CopyMySQL505To192.168.178.202.bat
* create sub directory 'uweheuer' in JBoss data directory
* add ProxyPass entry in /etc/apache2/sites-enabled/000-default.conf
* sudo a2enmod proxy_ajp (creates /etc/apache2/mods-enabled/proxy.conf und proxy_ajp.conf)
* edit /etc/apache2/mods-enabled/proxy.conf (Deny from all to Allow from all)
* service apache2 restart
* deploy mysql-connector-java-5.1.36.jar via JBoss Admin Console -> Deployments
* add Datasources via JBoss -> Admin Console -> Configuration -> Connector -> Datasources -> Add
 Name: '''MySQLDS'''
 JNDI: java:jboss/datasources/MySQLDS
 Driver: mysql-connector-java-5.1.36.jarcom.mysql.jdbc.Driver_5_1
 Connection URL: jdbc:mysql://localhost/mysql505?autoReconnect=true
 User: root
 Password: root
 Name: '''UwesWikiDS'''
 JNDI: java:jboss/datasources/UwesWikiDS
 Driver: mysql-connector-java-5.1.36.jarcom.mysql.jdbc.Driver_5_1
 Connection URL: jdbc:mysql://localhost/mediawiki
 User: root
 Password: root
* disable datasource MySQLDS and set Validation
 Valid Connection Checker: org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLValidConnectionChecker
 Check Valid Sql:
 Background Validation: true
 Validation Millis: 36000
 Exception Sorter: org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLExceptionSorter
* deployed via Eclipse ant target 'deploy_home'
* data files in .../standalone/data/uweheuer
** abc.tmp
** Configuration.properties
* copy <code>C:\Uwes\Batches\DisAndEnableUweHeuer.bat</code> to <code>/myprogs</code> which is called from the management service

====VLC====
* install by
 sudo apt-get install vlc
* to avoid teletext decoder error message install VBI teletext plugin for VLC

====Wake up on LAN (WOL) ====
* in /etc/rc.local '''add ethtool -s eth0 wol g''' and in /etc/init.d/halt change '''NETDOWN=no''' and in /etc/default/acpi-support change '''STOP_SERVICES="networking"'''

====WinSCP====
* download and extracted WinSCP to /myprogs/winscp/
* in shell do
 sudo su
 wine WinSCP.exe // there will be errors but it will start eventually