Server/srs20

"Spielwiese!"

Export

Daten von limesurvey sichern

mysqldump --version

mysqldump  Ver 10.13 Distrib 5.5.35, for FreeBSD8.2 (amd64)

cat /usr/local/www/limesurvey/config.php

mysqldump -u root -h localhost --all-databases -p > /tmp/dump.`date "+%Y-%m-%d"`.sql

tar -vczf /tmp/archiv.tar.gz /usr/local/www/limesurvey

gesicherte Daten von limesurvey auf die neue Instanz kopieren

Installation der benötigten Software

pauschale Aktualisieren

pkg upgrade -y

ergänzende gängige Werkzeuge zum Administrieren installieren

pkg install -y vim-lite nano bash zsh tmux mc

New packages to be INSTALLED:
        vim-lite: 7.4.1743
        nano: 2.4.3
        bash: 4.3.42_1
        zsh: 5.2_1
        tmux: 2.1_1
        mc: 4.8.16_1
        libevent2: 2.0.22_1
        libssh2: 1.7.0,2
        libX11: 1.6.3,1
        xproto: 7.0.28
        libXdmcp: 1.1.2
        libxcb: 1.11.1
        libxml2: 2.9.3
        libpthread-stubs: 0.3_6
        libXau: 1.0.8_3
        kbproto: 1.0.7
        libslang2: 2.3.0
        png: 1.6.21
        pcre: 8.38_1
        glib: 2.46.2
        libXext: 1.3.3_1,1
        xextproto: 7.3.0

Message from bash-4.3.42_1:
======================================================================

bash requires fdescfs(5) mounted on /dev/fd

If you have not done it yet, please do the following:

        mount -t fdescfs fdesc /dev/fd

To make it permanent, you need the following lines in /etc/fstab:

        fdesc   /dev/fd         fdescfs         rw      0       0

======================================================================

LimeSurvey installieren

pkg install -y limesurvey

New packages to be INSTALLED:
        limesurvey: 1.91_1
        php56-simplexml: 5.6.21
        php56: 5.6.21
        php56-session: 5.6.21
        php56-iconv: 5.6.21
        php56-gd: 5.6.21
        libXpm: 3.5.11_4
        libXt: 1.1.5,1
        libSM: 1.2.2_3,1
        libICE: 1.0.9_1,1
        t1lib: 5.1.2_4,1
        libXaw: 1.0.13,2
        printproto: 1.0.5
        libXmu: 1.1.2_3,1
        libXp: 1.0.3,1
        freetype2: 2.6.3
        jpeg-turbo: 1.4.2
        mysql56-client: 5.6.30
        libedit: 3.1.20150325_2
        php56-xmlwriter: 5.6.21
        php56-ctype: 5.6.21
        php56-mbstring: 5.6.21
        oniguruma5: 5.9.6_1
        php56-json: 5.6.21
        php56-dom: 5.6.21
        php56-mysql: 5.6.21

Message from mysql56-client-5.6.30:
* * * * * * * * * * * * * * * * * * * * * * * *

Please be aware the database client is vulnerable
to CVE-2015-3152 - SSL Downgrade aka "BACKRONYM".
You may find more information at the following URL:

http://www.vuxml.org/freebsd/36bd352d-299b-11e5-86ff-14dae9d210b8.html

Although this database client is not listed as
"affected", it is vulnerable and will not be 
receiving a patch. Please take note of this when
deploying this software.

* * * * * * * * * * * * * * * * * * * * * * * *

Message from limesurvey-1.91_1:
----------------------------------------------------------------------------
limesurvey has been installed, but is not quite ready to be used yet!

You have to ensure that you have a mysql server installed and configured. 
Further information on these installation procedures may 
be found in:

  /usr/local/www/limesurvey/docs/manual.html

Once these steps have been taken, you may connect to the following URL to
configure your installation of limesurvey:

  http://localhost/limesurvey/

----------------------------------------------------------------------------

• Zum "Gegenprüfen" kann das Manual von LimeSurvey für die Installationdeutschsparachig herangezogen werden.

Webserver (hier Apache 2.4) installieren und in die Umgebung einfügen

pkg install -y apache24 mod_php56

        apache24: 2.4.20_1
        mod_php56: 5.6.21

Message from apache24-2.4.20_1:
To run apache www server from startup, add apache24_enable="yes"
in your /etc/rc.conf. Extra options can be found in startup script.

Your hostname must be resolvable using at least 1 mechanism in
/etc/nsswitch.conf typically DNS or /etc/hosts or apache might
have issues starting depending on the modules you are using.

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

- apache24 default build changed from static MPM to modular MPM
- more modules are now enabled per default in the port
- icons and error pages moved from WWWDIR to DATADIR

   If build with modular MPM and no MPM is activated in 
   httpd.conf, then mpm_prefork will be activated as default
   MPM in etc/apache24/modules.d to keep compatibility with 
   existing php/perl/python modules!

Please compare the existing httpd.conf with httpd.conf.sample
and merge missing modules/instructions into httpd.conf!

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Message from mod_php56-5.6.21:
***************************************************************

Make sure index.php is part of your DirectoryIndex.

You should add the following to your Apache configuration file:

<FilesMatch "\.php$">
    SetHandler application/x-httpd-php
</FilesMatch>
<FilesMatch "\.phps$">
    SetHandler application/x-httpd-php-source
</FilesMatch>

***************************************************************

$EDITOR /usr/local/etc/apache24/Includes/php.conf

DirectoryIndex index.php index.html
<FilesMatch "\.php$">
        SetHandler application/x-httpd-php
</FilesMatch>
<FilesMatch "\.phps$">
        SetHandler application/x-httpd-php-source
</FilesMatch>

rm -rf /usr/local/www/apache24/data

ln -s /usr/local/www/limesurvey /usr/local/www/apache24/data

$EDITOR /usr/local/etc/apache24/httpd.conf

#ServerName www.example.com:80
ServerName umfragen.stura.htw-dresden.de

sysrc apache24_enable=yes

apache24_enable:  -> yes

service apache24 start

Datenbank (hier MYSQL 5.6) installieren und in die Umgebung einfügen

pkg install -y mysql56-server

New packages to be INSTALLED:
        mysql56-server: 5.6.30

Message from mysql56-server-5.6.30:
************************************************************************

Remember to run mysql_upgrade the first time you start the MySQL server
after an upgrade from an earlier version.

************************************************************************

sysrc mysql_enable=yes

mysql_enable:  -> yes

service mysql-server start

mysql_secure_installation

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!

In order to log into MySQL to secure it, we'll need the current
password for the root user.  If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none): 

OK, successfully used password, moving on...

Setting the root password ensures that nobody can log into the MySQL
root user without the proper authorisation.

Set root password? [Y/n] y

New password: 

Re-enter new password: 

Password updated successfully!
Reloading privilege tables..
 ... Success!


By default, a MySQL installation has an anonymous user, allowing anyone
to log into MySQL without having to have a user account created for
them.  This is intended only for testing, and to make the installation
go a bit smoother.  You should remove them before moving into a
production environment.

Remove anonymous users? [Y/n] y

 ... Success!

Normally, root should only be allowed to connect from 'localhost'.  This
ensures that someone cannot guess at the root password from the network.

Disallow root login remotely? [Y/n] y

 ... Success!

By default, MySQL comes with a database named 'test' that anyone can
access.  This is also intended only for testing, and should be removed
before moving into a production environment.

Remove test database and access to it? [Y/n] y

 - Dropping test database...
 ... Success!
 - Removing privileges on test database...
 ... Success!

Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.

Reload privilege tables now? [Y/n] y

 ... Success!




All done!  If you've completed all of the above steps, your MySQL
installation should now be secure.

Thanks for using MySQL!


Cleaning up...

Mail-Ausgang (nahezu pauschal) aktivieren

sysrc sendmail_enable=yes

sendmail_enable: NO -> yes

service sendmail start

Import

Migrieren

mkdir -p ~/import/`date "+%Y-%m-%d"`

mv /tmp/dump.`date "+%Y-%m-%d"`.sql ~/import/`date "+%Y-%m-%d"`

mv /tmp/archiv.`date "+%Y-%m-%d"`.tar.gz ~/import/`date "+%Y-%m-%d"`

mv /tmp/config.php ~/import/`date "+%Y-%m-%d"`

Datenbank importieren

mysql -u root -p < ~/import/`date "+%Y-%m-%d"`/dump.`date "+%Y-%m-%d"`.sql

Enter password: 

ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.or' at line 1

Datenbank aktualisieren

mysql_upgrade -u root -p

Enter password: 

Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck with default connection arguments
Warning: Using a password on the command line interface can be insecure.
Running 'mysqlcheck with default connection arguments
Warning: Using a password on the command line interface can be insecure.
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.general_log                                  OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.innodb_index_stats                           OK
mysql.innodb_table_stats                           OK
mysql.ndb_binlog_index                             OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.servers                                      OK
mysql.slave_master_info                            OK
mysql.slave_relay_log_info                         OK
mysql.slave_worker_info                            OK
mysql.slow_log                                     OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
Running 'mysql_fix_privilege_tables'...
Warning: Using a password on the command line interface can be insecure.
Running 'mysqlcheck with default connection arguments
Warning: Using a password on the command line interface can be insecure.
Running 'mysqlcheck with default connection arguments
Warning: Using a password on the command line interface can be insecure.
OK

mysql_upgrade -u root -p

Enter password: 

Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
This installation of MySQL is already upgraded to 5.6.30, use --force if you still need to run mysql_upgrade

Datei zur Konfiguration von LimeSurvey einrichten

cp /usr/local/www/limesurvey/config.php-dist /usr/local/www/limesurvey/config.php

cat ~/import/config.php

$EDITOR /usr/local/www/limesurvey/config.php

//$databasetype       =   'mysql';
$databasetype       =   'mysql';

//$databaselocation   =   'localhost';
//$databasename       =   'limesurvey';
//$databaseuser       =   'root';
//$databasepass       =   '';
//$dbprefix           =   'lime_';
$databaselocation   =   'localhost';
$databasename       =   'limesurvey';
$databaseuser       =   'databaseuser';
$databasepass       =   'databasepass';
$dbprefix           =   'lime_';

//$rooturl            =   "http://{$_SERVER['HTTP_HOST']}/limesurvey";
//$rootdir            =   dirname(__FILE__);
$rooturl            =   "http://{$_SERVER['HTTP_HOST']}";
$rootdir            =   dirname(__FILE__);

//$defaultuser        =   'admin';
//$defaultpass        =   'password';
$defaultuser        =   'admin';
$defaultpass        =   'defaultpassword';

$siteadminemail     =   'umfragen@stura.htw-dresden.de';
$siteadminbounce    =   'umfragen@stura.htw-dresden.de';
$siteadminname      =   'Umfragen StuRa HTW Dresden';