{"id":43,"date":"2020-02-29T17:06:43","date_gmt":"2020-02-29T17:06:43","guid":{"rendered":"https:\/\/nissel.it\/?p=43"},"modified":"2020-12-30T15:16:36","modified_gmt":"2020-12-30T14:16:36","slug":"moddle-einstellungen-in-plesk","status":"publish","type":"post","link":"https:\/\/nissel.it\/index.php\/2020\/02\/29\/moddle-einstellungen-in-plesk\/","title":{"rendered":"Moddle Einstellungen in Plesk"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">MySQL Einstellungen<\/h2>\n\n\n\n<p>MySQL Anpassungen f\u00fcr Moodle in der Datei \/etc\/mysql\/mariadb.conf.d\/50-server.cnf<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>innodb_file_format = Barracuda\ninnodb_file_per_table = 1\ninnodb_large_prefix\ncharacter-set-server = utf8mb4\ncollation-server = utf8mb4_unicode_ci\nskip-character-set-client-handshake<\/code><\/pre>\n\n\n\n<!--more-->\n\n\n\n<p>Danach die Datenbank neu starten &#8222;service mariadb restart&#8220;<\/p>\n\n\n\n<p>Anscheinend erstellt Plesk die Datenbank trotzdem mit einem anderen encoding. Deswegen muss die Datenbank nach der Installation konvertiert werden. Dazu stellt Moodle ein Skript bereit.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\/opt\/plesk\/php\/7.4\/bin\/php admin\/cli\/mysql_collation.php --collation=utf8mb4_unicode_ci<\/code><\/pre>\n\n\n\n<p>\u00dcberpr\u00fcft werden kann das mit folgendem SQL:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT SCHEMA_NAME, default_character_set_name FROM information_schema.SCHEMATA;<\/code><\/pre>\n\n\n\n<p>In der offiziellen Dokumentation wird empfohlen folgenden Befehl danach auszuf\u00fchren:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysqlcheck -u root -p --auto-repair --optimize --all-databases<\/code><\/pre>\n\n\n\n<p>Wenn die Datenbank \u00fcber docker wie in <a href=\"https:\/\/nissel.it\/index.php\/2020\/12\/26\/maradb-ueber-docker-compose-installieren-und-in-plesk-integrieren\/\" data-type=\"post\" data-id=\"294\">Maradb \u00fcber docker (compose) installieren und in Plesk integrieren<\/a> installiert wurde muss dieser Befehl angepasst werden:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysqlcheck -u root --port 3316 --port=3316 -p --protocol=TCP --auto-repair --optimize --all-databases<\/code><\/pre>\n\n\n\n<p>Zus\u00e4tzlich muss dann in der config.php von Moodle das encoding angepasst werden:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$CFG-&gt;dboptions = array(\n  \u2026\n  'dbcollation' =&gt; 'utf8mb4_unicode_ci',\n  \u2026\n);<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Cronjob<\/h2>\n\n\n\n<p>F\u00fcr Moodle muss ein cronjob eingerichtet werden der unter den Rechten des Benutzer der Webseite laufen sollte.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"256\" height=\"266\" src=\"https:\/\/nissel.it\/wp-content\/uploads\/2020\/04\/01-cronjob.png\" alt=\"\" class=\"wp-image-211\"\/><figcaption>Auswahl der Benutzer cronjobs<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"835\" height=\"864\" src=\"https:\/\/nissel.it\/wp-content\/uploads\/2020\/04\/02-cronjob.png\" alt=\"\" class=\"wp-image-213\" srcset=\"https:\/\/nissel.it\/wp-content\/uploads\/2020\/04\/02-cronjob.png 835w, https:\/\/nissel.it\/wp-content\/uploads\/2020\/04\/02-cronjob-290x300.png 290w, https:\/\/nissel.it\/wp-content\/uploads\/2020\/04\/02-cronjob-768x795.png 768w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><figcaption>Konfiguration des conjobs<\/figcaption><\/figure>\n\n\n\n<p>F\u00fcr Moodle soll jede Minute ein cronjob ausgef\u00fchrt werden. Hier muss der Pfad zum script angegeben werden. Laut Dokumentation soll der Job jede Minute ausgef\u00fchrt werden. Etwas resourcen schonender w\u00e4re z.B. alle 10 Minuten:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>*\/10 * * * *<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>\/var\/www\/vhosts\/domain.de\/httpdocs\/admin\/cli\/cron.php<\/code><\/pre>\n\n\n\n<p>Linux: Ubuntu 18.04.4<br>Plesk: Obsidian 18.0.26<\/p>\n\n\n\n<p>Quelle:  <a href=\"https:\/\/docs.moodle.org\/37\/en\/MySQL_full_unicode_support\">https:\/\/docs.moodle.org\/37\/en\/MySQL_full_unicode_support<\/a> <br><a href=\"https:\/\/docs.moodle.org\/38\/de\/Cron-Job\">https:\/\/docs.moodle.org\/38\/de\/Cron-Job<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/www.a2hosting.com\/kb\/developer-corner\/mysql\/convert-mysql-database-utf-8\">https:\/\/www.a2hosting.com\/kb\/developer-corner\/mysql\/convert-mysql-database-utf-8<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/docs.moodle.org\/37\/en\/MySQL_full_unicode_support\">https:\/\/docs.moodle.org\/37\/en\/MySQL_full_unicode_support<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/moodle.org\/mod\/forum\/discuss.php?d=401739\">https:\/\/moodle.org\/mod\/forum\/discuss.php?d=401739<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL Einstellungen MySQL Anpassungen f\u00fcr Moodle in der Datei \/etc\/mysql\/mariadb.conf.d\/50-server.cnf<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[6,4],"class_list":["post-43","post","type-post","status-publish","format-standard","hentry","category-webserver","tag-moodle","tag-plesk"],"_links":{"self":[{"href":"https:\/\/nissel.it\/index.php\/wp-json\/wp\/v2\/posts\/43","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nissel.it\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nissel.it\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nissel.it\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nissel.it\/index.php\/wp-json\/wp\/v2\/comments?post=43"}],"version-history":[{"count":15,"href":"https:\/\/nissel.it\/index.php\/wp-json\/wp\/v2\/posts\/43\/revisions"}],"predecessor-version":[{"id":316,"href":"https:\/\/nissel.it\/index.php\/wp-json\/wp\/v2\/posts\/43\/revisions\/316"}],"wp:attachment":[{"href":"https:\/\/nissel.it\/index.php\/wp-json\/wp\/v2\/media?parent=43"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nissel.it\/index.php\/wp-json\/wp\/v2\/categories?post=43"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nissel.it\/index.php\/wp-json\/wp\/v2\/tags?post=43"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}