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.`date "+%Y-%m-%d"`.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/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> | | : <code>fetch --no-verify-hostname --no-verify-peer http://umfragen.stura.htw-dresden.de/archiv.`date "+%Y-%m-%d"`.tar.gz</code> |
|
| |
|
| |
| --> | | --> |
|
| |
|
Zeile 263: |
Zeile 259: |
| </pre> | | </pre> |
| : <code>service mysql-server start</code> | | : <code>service mysql-server start</code> |
|
| |
| : <code>mysql_secure_installation</code>
| |
| <pre>
| |
|
| |
|
| |
|
| |
| 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.
| |
|
| |
| </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 | | ; Mail-Ausgang (nahezu pauschal) aktivieren |
Zeile 375: |
Zeile 273: |
| : <code>mv /tmp/dump.`date "+%Y-%m-%d"`.sql ~/import/`date "+%Y-%m-%d"`</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/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 | | ; Datenbank importieren |
| : <code>mysql -u root -p < ~/import/`date "+%Y-%m-%d"`/dump.`date "+%Y-%m-%d"`.sql</code> | | : <code>mysql -u root -p < /tmp/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
| | * mysql_upgrade? |
| : <code>cp /usr/local/www/limesurvey/config.php-dist /usr/local/www/limesurvey/config.php</code>
| | ** mysql-server stoppen? |
| : <code>cat ~/import/config.php</code> | | **: <code>service mysql-server stop</code> |
| : <code>$EDITOR /usr/local/www/limesurvey/config.php</code> | | *: <code>mysql_upgrade -u root -p</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>
| |
| | |
| <!--
| |
| The LimeSurvey database does not exist. Please run the install script to create the necessary database.
| |
| !-->
| |
|
| |
|
| <!-- | | <!-- |