{"id":917,"date":"2021-05-16T14:51:25","date_gmt":"2021-05-16T13:51:25","guid":{"rendered":"https:\/\/www.netexpertise.eu\/fr\/?p=917"},"modified":"2021-05-16T14:51:27","modified_gmt":"2021-05-16T13:51:27","slug":"mysql-postgresql-sur-disques-iscsi-ne-demarre-pas-au-boot","status":"publish","type":"post","link":"http:\/\/www.netexpertise.eu\/fr\/systeme\/linux\/mysql-postgresql-sur-disques-iscsi-ne-demarre-pas-au-boot.html","title":{"rendered":"MySQL \/ PostgreSQL sur Disques iSCSI ne D\u00e9marre pas au Boot"},"content":{"rendered":"\n<p>Vous h\u00e9bergez les r\u00e9pertoires de donn\u00e9es Mysql ou PostgreSQL sur des disques <a href=\"\/fr\/systeme\/linux\/disques-san-iscsi-multipath-linux.html\">iSCSI<\/a> mais le service ne d\u00e9marre pas au boot du serveur. Le service ne trouve pas le r\u00e9pertoire. Pourtant, le service se lance manuellement apr\u00e8s s&rsquo;\u00eatre loggu\u00e9 en SSH d\u00e8s qu&rsquo;il est disponible.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img src=\"\/images\/iscsi_db_start.png\" alt=\"Mysql \/ PostgreSQL surr iSCSI ne d\u00e9marre pas\"\/><\/figure>\n\n\n\n<p>Voici les logs de Mariadb mais ils seraient similaires pour Mysql:<br><br><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"vim\" class=\"language-vim\">mariadbd[795]: 0 [Note] \/usr\/sbin\/mysqld (mysqld 10.5.9-MariaDB-1:10.5.9+maria~buster-log) starting as process 795 ...\nmariadbd[795]: 0 [Warning] Can't create test file \/opt\/db\/data\/database_server.lower-test\nmariadbd[795]: #007\/usr\/sbin\/mysqld: Cannot change dir to '\/var\/lib\/mysql\/data\/' (Errcode: 2 \"No such file or directory\")\nmariadbd[795]: 0 [ERROR] Aborting\nsystemd[1]: mariadb.service: Main process exited, code=exited, status=1\/FAILURE\nsystemd[1]: mariadb.service: Failed with result 'exit-code'.\nsystemd[1]: Failed to start MariaDB 10.5.9 database server.<\/code><\/pre>\n\n\n\n<p><br>Vous auriez des logs similaires pour PostgreSQL. J&rsquo;ai stock\u00e9 les donn\u00e9es PostgreSQL sur une partition XFS, elle-m\u00eame rr\u00e9sidant sur <a href=\"https:\/\/opensource.com\/business\/16\/9\/linux-users-guide-lvm\" target=\"_blank\" rel=\"noreferrer noopener\">LVM<\/a> pour une gestion de l&rsquo;espace disque plus flexible, comme l&rsquo;ajout d&rsquo;espace pendant que le syst\u00e8me de fichiers est mont\u00e9. C&rsquo;est probablement la raison principale qui fait que les disques iSCSI sont populaires.<br><br><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"vim\" class=\"language-vim\">systemd: mounting \/var\/lib\/pgsql\nstarting PostgreSQL database server\nsd 2:0:0:0: [sdb] attached SCSI disk\nxfs (dm-4): Mounting V4 Filesystem\npostgresql-check-db-dir: \"\/var\/lib\/pgsql\/data\" is missing or empty\npostgresql.service: control process exited, code=exited status=1\nFailed to start PostgreSQL database server.<\/code><\/pre>\n\n\n\n<p><br>La base de donn\u00e9es qui d\u00e9marre manuellement apr\u00e8s le boot indique certainement un probl\u00e8me d&rsquo;ordre de d\u00e9marrage des services. Les bases de donn\u00e9es doivent d\u00e9marrer <span style=\"text-decoration: underline;\">apr\u00e8s<\/span> que les disques iscsi sont disponibles. Cela peut \u00eatre r\u00e9solu en ajoutant \u00ab\u00a0<em>After=remote-fs.target<\/em>\u00a0\u00bb dans le fichier systemd du service comme \/usr\/lib\/systemd\/system\/postgresql-9.5.service pour PosgreSQL par exemple. C&rsquo;est un moyen de g\u00e9rer la pr\u00e9c\u00e9dence et les d\u00e9pendances des services.<br><br>Notez que vous pourriez perdre ces changement la prochaine fois que le paquet est mis \u00e0 jour. Systemd permet de cr\u00e9er un fichier suppl\u00e9mentaire o\u00f9 vous pouvez d\u00e9finir vos propres param\u00e8tres. Il ne sera jamais \u00e9cras\u00e9 puisque c&rsquo;est votre fichier, ind\u00e9pendant du paquet.<br>Cr\u00e9ez simplement \/etc\/systemd\/system\/mariadb.service.d\/override.conf comme ceci pour Mariadb, c&rsquo;est la m\u00eame proc\u00e9dure pour Mysql ou PostgreSQL:<br><br><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"vim\" class=\"language-vim\">[Service]\nEnvironment=\"UMASK_DIR=0750\"\n\n[Unit]\nAfter=remote-fs.target<\/code><\/pre>\n\n\n\n<p><br>Dans ce fichier, j&rsquo;ai aussi chang\u00e9 les droits par d\u00e9faut du r\u00e9pertoire de donn\u00e9es pour que les utilisateurs appartenant au groupe Mysql puissent le parcourir.<br>Ex\u00e9cutez <em>systemctl daemon-reload<\/em> pour que les nouveaux changements soient pris en compte et red\u00e9marrez le serveur. La base de donn\u00e9es devrait maintenant d\u00e9marrer.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Vous h\u00e9bergez les r\u00e9pertoires de donn\u00e9es Mysql ou PostgreSQL sur des disques iSCSI mais le service ne d\u00e9marre pas au boot du serveur. Le service ne trouve pas le r\u00e9pertoire. Pourtant, le service se lance manuellement apr\u00e8s s&rsquo;\u00eatre loggu\u00e9 en SSH d\u00e8s qu&rsquo;il est disponible. Voici les logs de Mariadb mais ils seraient similaires pour [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false},"categories":[10,4,5],"tags":[304,407,404,405],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.13 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Netexpertise - MySQL \/ PostgreSQL sur Disques iSCSI ne D\u00e9marre pas au Boot<\/title>\n<meta name=\"description\" content=\"Mysql \/ PostgreSQL sur disques iSCSI ne d\u00e9marre au boot. Avez-vous v\u00e9rifi\u00e9 les d\u00e9pendances et l&#039;ordre de d\u00e9marrage des services sous systemd?\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/www.netexpertise.eu\/fr\/systeme\/linux\/mysql-postgresql-sur-disques-iscsi-ne-demarre-pas-au-boot.html\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Netexpertise - MySQL \/ PostgreSQL sur Disques iSCSI ne D\u00e9marre pas au Boot\" \/>\n<meta property=\"og:description\" content=\"Mysql \/ PostgreSQL sur disques iSCSI ne d\u00e9marre au boot. Avez-vous v\u00e9rifi\u00e9 les d\u00e9pendances et l&#039;ordre de d\u00e9marrage des services sous systemd?\" \/>\n<meta property=\"og:url\" content=\"http:\/\/www.netexpertise.eu\/fr\/systeme\/linux\/mysql-postgresql-sur-disques-iscsi-ne-demarre-pas-au-boot.html\" \/>\n<meta property=\"og:site_name\" content=\"Netexpertise\" \/>\n<meta property=\"article:published_time\" content=\"2021-05-16T13:51:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-05-16T13:51:27+00:00\" \/>\n<meta name=\"author\" content=\"dave\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@netexpertise\" \/>\n<meta name=\"twitter:site\" content=\"@netexpertise\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"http:\/\/www.netexpertise.eu\/fr\/systeme\/linux\/mysql-postgresql-sur-disques-iscsi-ne-demarre-pas-au-boot.html\",\"url\":\"http:\/\/www.netexpertise.eu\/fr\/systeme\/linux\/mysql-postgresql-sur-disques-iscsi-ne-demarre-pas-au-boot.html\",\"name\":\"Netexpertise - MySQL \/ PostgreSQL sur Disques iSCSI ne D\u00e9marre pas au Boot\",\"isPartOf\":{\"@id\":\"http:\/\/www.netexpertise.eu\/fr\/#website\"},\"datePublished\":\"2021-05-16T13:51:25+00:00\",\"dateModified\":\"2021-05-16T13:51:27+00:00\",\"author\":{\"@id\":\"http:\/\/www.netexpertise.eu\/fr\/#\/schema\/person\/e398f0307e2b167f6b884c4953be2632\"},\"description\":\"Mysql \/ PostgreSQL sur disques iSCSI ne d\u00e9marre au boot. Avez-vous v\u00e9rifi\u00e9 les d\u00e9pendances et l'ordre de d\u00e9marrage des services sous systemd?\",\"breadcrumb\":{\"@id\":\"http:\/\/www.netexpertise.eu\/fr\/systeme\/linux\/mysql-postgresql-sur-disques-iscsi-ne-demarre-pas-au-boot.html#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/www.netexpertise.eu\/fr\/systeme\/linux\/mysql-postgresql-sur-disques-iscsi-ne-demarre-pas-au-boot.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/www.netexpertise.eu\/fr\/systeme\/linux\/mysql-postgresql-sur-disques-iscsi-ne-demarre-pas-au-boot.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"http:\/\/www.netexpertise.eu\/fr\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL \/ PostgreSQL sur Disques iSCSI ne D\u00e9marre pas au Boot\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/www.netexpertise.eu\/fr\/#website\",\"url\":\"http:\/\/www.netexpertise.eu\/fr\/\",\"name\":\"Netexpertise\",\"description\":\"Syst\u00e8mes \/ R\u00e9seaux \/ DevOps\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/www.netexpertise.eu\/fr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"http:\/\/www.netexpertise.eu\/fr\/#\/schema\/person\/e398f0307e2b167f6b884c4953be2632\",\"name\":\"dave\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"http:\/\/www.netexpertise.eu\/fr\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/1.gravatar.com\/avatar\/1129916e1f4955bd632f27f836f64e55?s=96&d=mm&r=g\",\"contentUrl\":\"http:\/\/1.gravatar.com\/avatar\/1129916e1f4955bd632f27f836f64e55?s=96&d=mm&r=g\",\"caption\":\"dave\"},\"sameAs\":[\"http:\/\/www.netexpertise.eu\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Netexpertise - MySQL \/ PostgreSQL sur Disques iSCSI ne D\u00e9marre pas au Boot","description":"Mysql \/ PostgreSQL sur disques iSCSI ne d\u00e9marre au boot. Avez-vous v\u00e9rifi\u00e9 les d\u00e9pendances et l'ordre de d\u00e9marrage des services sous systemd?","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/www.netexpertise.eu\/fr\/systeme\/linux\/mysql-postgresql-sur-disques-iscsi-ne-demarre-pas-au-boot.html","og_locale":"fr_FR","og_type":"article","og_title":"Netexpertise - MySQL \/ PostgreSQL sur Disques iSCSI ne D\u00e9marre pas au Boot","og_description":"Mysql \/ PostgreSQL sur disques iSCSI ne d\u00e9marre au boot. Avez-vous v\u00e9rifi\u00e9 les d\u00e9pendances et l'ordre de d\u00e9marrage des services sous systemd?","og_url":"http:\/\/www.netexpertise.eu\/fr\/systeme\/linux\/mysql-postgresql-sur-disques-iscsi-ne-demarre-pas-au-boot.html","og_site_name":"Netexpertise","article_published_time":"2021-05-16T13:51:25+00:00","article_modified_time":"2021-05-16T13:51:27+00:00","author":"dave","twitter_card":"summary_large_image","twitter_creator":"@netexpertise","twitter_site":"@netexpertise","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"http:\/\/www.netexpertise.eu\/fr\/systeme\/linux\/mysql-postgresql-sur-disques-iscsi-ne-demarre-pas-au-boot.html","url":"http:\/\/www.netexpertise.eu\/fr\/systeme\/linux\/mysql-postgresql-sur-disques-iscsi-ne-demarre-pas-au-boot.html","name":"Netexpertise - MySQL \/ PostgreSQL sur Disques iSCSI ne D\u00e9marre pas au Boot","isPartOf":{"@id":"http:\/\/www.netexpertise.eu\/fr\/#website"},"datePublished":"2021-05-16T13:51:25+00:00","dateModified":"2021-05-16T13:51:27+00:00","author":{"@id":"http:\/\/www.netexpertise.eu\/fr\/#\/schema\/person\/e398f0307e2b167f6b884c4953be2632"},"description":"Mysql \/ PostgreSQL sur disques iSCSI ne d\u00e9marre au boot. Avez-vous v\u00e9rifi\u00e9 les d\u00e9pendances et l'ordre de d\u00e9marrage des services sous systemd?","breadcrumb":{"@id":"http:\/\/www.netexpertise.eu\/fr\/systeme\/linux\/mysql-postgresql-sur-disques-iscsi-ne-demarre-pas-au-boot.html#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["http:\/\/www.netexpertise.eu\/fr\/systeme\/linux\/mysql-postgresql-sur-disques-iscsi-ne-demarre-pas-au-boot.html"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/www.netexpertise.eu\/fr\/systeme\/linux\/mysql-postgresql-sur-disques-iscsi-ne-demarre-pas-au-boot.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"http:\/\/www.netexpertise.eu\/fr"},{"@type":"ListItem","position":2,"name":"MySQL \/ PostgreSQL sur Disques iSCSI ne D\u00e9marre pas au Boot"}]},{"@type":"WebSite","@id":"http:\/\/www.netexpertise.eu\/fr\/#website","url":"http:\/\/www.netexpertise.eu\/fr\/","name":"Netexpertise","description":"Syst\u00e8mes \/ R\u00e9seaux \/ DevOps","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/www.netexpertise.eu\/fr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"http:\/\/www.netexpertise.eu\/fr\/#\/schema\/person\/e398f0307e2b167f6b884c4953be2632","name":"dave","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"http:\/\/www.netexpertise.eu\/fr\/#\/schema\/person\/image\/","url":"http:\/\/1.gravatar.com\/avatar\/1129916e1f4955bd632f27f836f64e55?s=96&d=mm&r=g","contentUrl":"http:\/\/1.gravatar.com\/avatar\/1129916e1f4955bd632f27f836f64e55?s=96&d=mm&r=g","caption":"dave"},"sameAs":["http:\/\/www.netexpertise.eu"]}]}},"_links":{"self":[{"href":"http:\/\/www.netexpertise.eu\/fr\/wp-json\/wp\/v2\/posts\/917"}],"collection":[{"href":"http:\/\/www.netexpertise.eu\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.netexpertise.eu\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.netexpertise.eu\/fr\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.netexpertise.eu\/fr\/wp-json\/wp\/v2\/comments?post=917"}],"version-history":[{"count":0,"href":"http:\/\/www.netexpertise.eu\/fr\/wp-json\/wp\/v2\/posts\/917\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.netexpertise.eu\/fr\/wp-json\/wp\/v2\/media?parent=917"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.netexpertise.eu\/fr\/wp-json\/wp\/v2\/categories?post=917"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.netexpertise.eu\/fr\/wp-json\/wp\/v2\/tags?post=917"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}