Aktuelle Version |
Dein Text |
Zeile 9: |
Zeile 9: |
| </pre> | | </pre> |
| : <code>cat /usr/local/www/limesurvey/config.php</code> | | : <code>cat /usr/local/www/limesurvey/config.php</code> |
| : <code>mysqldump -u root -h localhost --all-databases -p > /tmp/dump.`date "+%Y-%m-%d"`.sql</code><!--
| | : <code>mysqldump -u root -h localhost limesurvey -p > /tmp/dump.`date "+%Y-%m-%d"`.sql</code> |
| : <code>mysqldump -u root -h localhost limesurvey -p > /tmp/dump.`date "+%Y-%m-%d"`.sql</code>!--> | |
| : <code>tar -vczf /tmp/archiv.tar.gz /usr/local/www/limesurvey</code> | | : <code>tar -vczf /tmp/archiv.tar.gz /usr/local/www/limesurvey</code> |
|
| |
|
| ; gesicherte Daten von limesurvey auf die neue Instanz kopieren | | ; gesicherte Daten von limesurvey auf die neue Instanz kopieren |
| <!-- | | <!-- |
| : <code>scp /home/jails/srs20/tmp/dump.`date "+%Y-%m-%d.sql account@IP:/mnt/zroot/jails/srs20/tmp/</code> | | : <code>scp /tmp/dump.`date "+%Y-%m-%d.sql account@IP:/mnt/zroot/jails/srs20/tmp/</code> |
| : <code>scp /home/jails/srs20/tmp/archiv.`date "+%Y-%m-%d"`.tar.gz account@IP:/mnt/zroot/jails/srs20/tmp/</code> | | : <code>scp /tmp/archiv.tar.gz account@IP:/mnt/zroot/jails/srs20/tmp/</code> |
| : <code>scp /home/jails/srs20/usr/local/www/limesurvey/config.php account@IP:/mnt/zroot/jails/srs20/tmp/</code>
| |
| | |
| : <code>fetch --no-verify-hostname --no-verify-peer http://umfragen.stura.htw-dresden.de/dump.`date "+%Y-%m-%d"`.sql</code>
| |
| : <code>fetch --no-verify-hostname --no-verify-peer http://umfragen.stura.htw-dresden.de/archiv.`date "+%Y-%m-%d"`.tar.gz</code>
| |
| | |
| | |
| --> | | --> |
|
| |
|
Zeile 32: |
Zeile 25: |
| ; ergänzende gängige Werkzeuge zum Administrieren installieren | | ; ergänzende gängige Werkzeuge zum Administrieren installieren |
| : <code>pkg install -y vim-lite nano bash zsh tmux mc</code> | | : <code>pkg install -y vim-lite nano bash zsh tmux mc</code> |
| <pre></pre>
| |
| <pre>
| |
| 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
| |
| </pre>
| |
| <pre></pre>
| |
| <pre>
| |
| Message from bash-4.3.42_1:
| |
| ======================================================================
| |
|
| |
|
| bash requires fdescfs(5) mounted on /dev/fd
| | ; limesurvey installieren |
| | |
| 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
| |
| | |
| ======================================================================
| |
| </pre>
| |
| | |
| ; LimeSurvey installieren | |
| : <code>pkg install -y limesurvey</code> | | : <code>pkg install -y limesurvey</code> |
| <pre></pre>
| |
| <pre>
| |
| 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
| |
| </pre>
| |
| <pre></pre>
| |
| <pre>
| |
| 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.
| |
|
| |
| * * * * * * * * * * * * * * * * * * * * * * * *
| |
| </pre>
| |
| <pre>
| |
| 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/
| |
|
| |
| ----------------------------------------------------------------------------
| |
| </pre>
| |
| <pre></pre>
| |
|
| |
|
| * Zum "Gegenprüfen" kann das [https://manual.limesurvey.org/Installation Manual von LimeSurvey für die Installation]<small>[https://manual.limesurvey.org/Installation/de deutschsparachig]</small> herangezogen werden. | | * Zum "Gegenprüfen" kann das [https://manual.limesurvey.org/Installation Manual von LimeSurvey für die Installation]<small>[https://manual.limesurvey.org/Installation/de deutschsparachig]</small> herangezogen werden. |
|
| |
|
| ; Webserver (hier Apache 2.4) installieren und in die Umgebung einfügen | | ; Webserver (hier Apache 2.4) installieren und in die Umgebung einfügen |
| : <code>pkg install -y apache24 mod_php56</code> | | : <code>pkg install apache24 mod_php56</code> |
| <pre></pre>
| |
| <pre>
| |
| apache24: 2.4.20_1
| |
| mod_php56: 5.6.21
| |
| </pre>
| |
| <pre></pre>
| |
| <pre>
| |
| 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!
| |
| | |
| !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
| |
| </pre>
| |
| <pre>
| |
| 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>
| |
| | |
| ***************************************************************
| |
| </pre>
| |
| <pre></pre>
| |
|
| |
|
| : <code>$EDITOR /usr/local/etc/apache24/Includes/php.conf</code> | | : <code>$EDITOR /usr/local/etc/apache24/Includes/php.conf</code> |
| <pre>
| |
| DirectoryIndex index.php index.html
| |
| <FilesMatch "\.php$">
| |
| SetHandler application/x-httpd-php
| |
| </FilesMatch>
| |
| <FilesMatch "\.phps$">
| |
| SetHandler application/x-httpd-php-source
| |
| </FilesMatch>
| |
| </pre>
| |
| <!--
| |
| <pre> | | <pre> |
| <IfModule dir_module> | | <IfModule dir_module> |
Zeile 222: |
Zeile 46: |
| </IfModule> | | </IfModule> |
| </pre> | | </pre> |
| -->
| |
|
| |
|
| : <code>rm -rf /usr/local/www/apache24/data</code> | | : <code>rm -rf /usr/local/www/apache24/data</code> |
|
| |
|
| : <code>ln -s /usr/local/www/limesurvey /usr/local/www/apache24/data</code> | | : <code>ln -s /usr/local/www/limesurvey /usr/local/www/apache24/data</code> |
|
| |
| : <code>$EDITOR /usr/local/etc/apache24/httpd.conf</code>
| |
| <pre></pre>
| |
| <pre>
| |
| #ServerName www.example.com:80
| |
| ServerName umfragen.stura.htw-dresden.de
| |
| </pre>
| |
| <pre></pre>
| |
|
| |
| : <code>sysrc apache24_enable=yes</code>
| |
| <pre>apache24_enable: -> yes</pre>
| |
| : <code>service apache24 start</code>
| |
|
| |
|
| ; Datenbank (hier MYSQL 5.6) installieren und in die Umgebung einfügen | | ; Datenbank (hier MYSQL 5.6) installieren und in die Umgebung einfügen |
| : <code>pkg install -y mysql56-server</code> | | : <code>pkg install mysql56-server</code> |
| <pre></pre>
| |
| <pre>
| |
| New packages to be INSTALLED:
| |
| mysql56-server: 5.6.30
| |
| </pre>
| |
| <pre>
| |
| 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.
| |
| | |
| ************************************************************************
| |
| </pre>
| |
| <pre></pre>
| |
|
| |
|
| : <code>sysrc mysql_enable=yes</code> | | : <code>sysrc mysql_enable=yes</code> |
| <pre>
| |
| mysql_enable: -> yes
| |
| </pre>
| |
| : <code>service mysql-server start</code>
| |
|
| |
| : <code>mysql_secure_installation</code>
| |
| <pre>
| |
|
| |
|
| |
|
| |
|
| NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
| | ; Mail-Ausgang (nahezu pauschael) aktivieren |
| 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.
| |
| | |
| </pre>
| |
| <pre>
| |
| Enter current password for root (enter for none):
| |
| </pre>
| |
| <pre>
| |
| OK, successfully used password, moving on...
| |
| | |
| Setting the root password ensures that nobody can log into the MySQL
| |
| root user without the proper authorisation.
| |
| | |
| </pre>
| |
| <pre>
| |
| Set root password? [Y/n] y
| |
| </pre>
| |
| <pre>
| |
| New password:
| |
| </pre>
| |
| <pre>
| |
| Re-enter new password:
| |
| </pre>
| |
| <pre>
| |
| 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.
| |
| | |
| </pre>
| |
| <pre>
| |
| Remove anonymous users? [Y/n] y
| |
| </pre>
| |
| <pre>
| |
| ... Success!
| |
| | |
| Normally, root should only be allowed to connect from 'localhost'. This
| |
| ensures that someone cannot guess at the root password from the network.
| |
| | |
| </pre>
| |
| <pre>
| |
| Disallow root login remotely? [Y/n] y
| |
| </pre>
| |
| <pre>
| |
| ... 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.
| |
| | |
| </pre>
| |
| <pre>
| |
| Remove test database and access to it? [Y/n] y
| |
| </pre>
| |
| <pre>
| |
| - 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.
| |
| | |
| </pre>
| |
| <pre>
| |
| Reload privilege tables now? [Y/n] y
| |
| </pre>
| |
| <pre>
| |
| ... 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...
| |
| </pre>
| |
| | |
| ; Mail-Ausgang (nahezu pauschal) aktivieren | |
| : <code>sysrc sendmail_enable=yes</code> | | : <code>sysrc sendmail_enable=yes</code> |
| <pre>
| |
| sendmail_enable: NO -> yes
| |
| </pre>
| |
| : <code>service sendmail start</code>
| |
|
| |
|
| === Import === | | === Import === |
| : Migrieren | | : Migrieren |
|
| |
|
| : <code>mkdir -p ~/import/`date "+%Y-%m-%d"`</code>
| | : <code>mysql -u root -p < /tmp/dump.sql</code> |
| : <code>mv /tmp/dump.`date "+%Y-%m-%d"`.sql ~/import/`date "+%Y-%m-%d"`</code>
| |
| : <code>mv /tmp/archiv.`date "+%Y-%m-%d"`.tar.gz ~/import/`date "+%Y-%m-%d"`</code>
| |
| : <code>mv /tmp/config.php ~/import/`date "+%Y-%m-%d"`</code>
| |
| <!--
| |
| -->
| |
| | |
| ; Datenbank importieren
| |
| : <code>mysql -u root -p < ~/import/`date "+%Y-%m-%d"`/dump.`date "+%Y-%m-%d"`.sql</code> | |
| <pre>
| |
| Enter password:
| |
| </pre>
| |
| <pre>
| |
| 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
| |
| </pre>
| |
| ; Datenbank aktualisieren
| |
| : <code>mysql_upgrade -u root -p</code>
| |
| <pre>
| |
| Enter password:
| |
| </pre>
| |
| <pre>
| |
| </pre>
| |
| <pre>
| |
| 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
| |
| </pre>
| |
| : <code>mysql_upgrade -u root -p</code>
| |
| <pre>
| |
| Enter password:
| |
| </pre>
| |
| <pre>
| |
| 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
| |
| </pre>
| |
| | |
| ; Datei zur Konfiguration von LimeSurvey einrichten
| |
| : <code>cp /usr/local/www/limesurvey/config.php-dist /usr/local/www/limesurvey/config.php</code>
| |
| : <code>cat ~/import/config.php</code>
| |
| : <code>$EDITOR /usr/local/www/limesurvey/config.php</code>
| |
| <pre></pre>
| |
| <pre>
| |
| //$databasetype = 'mysql';
| |
| $databasetype = 'mysql';
| |
| </pre>
| |
| <pre>
| |
| //$databaselocation = 'localhost';
| |
| //$databasename = 'limesurvey';
| |
| //$databaseuser = 'root';
| |
| //$databasepass = '';
| |
| //$dbprefix = 'lime_';
| |
| $databaselocation = 'localhost';
| |
| $databasename = 'limesurvey';
| |
| $databaseuser = 'databaseuser';
| |
| $databasepass = 'databasepass';
| |
| $dbprefix = 'lime_';
| |
| </pre>
| |
| <pre></pre>
| |
| <pre>
| |
| //$rooturl = "http://{$_SERVER['HTTP_HOST']}/limesurvey";
| |
| //$rootdir = dirname(__FILE__);
| |
| $rooturl = "http://{$_SERVER['HTTP_HOST']}";
| |
| $rootdir = dirname(__FILE__);
| |
| </pre>
| |
| <pre>
| |
| //$defaultuser = 'admin';
| |
| //$defaultpass = 'password';
| |
| $defaultuser = 'admin';
| |
| $defaultpass = 'defaultpassword';
| |
| </pre>
| |
| <pre></pre>
| |
| <pre>
| |
| $siteadminemail = 'umfragen@stura.htw-dresden.de';
| |
| $siteadminbounce = 'umfragen@stura.htw-dresden.de';
| |
| $siteadminname = 'Umfragen StuRa HTW Dresden';
| |
| </pre>
| |
| <pre></pre>
| |
|
| |
|
| <!-- | | * mysql_upgrade? |
| The LimeSurvey database does not exist. Please run the install script to create the necessary database.
| | ** mysql-server stoppen? |
| !-->
| | **: <code>service mysql-server stop</code> |
| | *: <code>mysql_upgrade -u root -p</code> |
|
| |
|
| <!-- | | <!-- |