{"id":959,"date":"2021-07-19T21:09:03","date_gmt":"2021-07-19T20:09:03","guid":{"rendered":"https:\/\/www.netexpertise.eu\/fr\/?p=959"},"modified":"2021-07-19T21:09:05","modified_gmt":"2021-07-19T20:09:05","slug":"comment-acceder-a-linterface-web-proxysql-sur-kubernetes","status":"publish","type":"post","link":"http:\/\/www.netexpertise.eu\/fr\/docker\/kubernetes\/comment-acceder-a-linterface-web-proxysql-sur-kubernetes.html","title":{"rendered":"Comment Acc\u00e9der \u00e0 l&rsquo;Interface Web ProxySQL sur Kubernetes"},"content":{"rendered":"\n<p>J&rsquo;ai pr\u00e9sent\u00e9 dans un article pr\u00e9c\u00e9dent le <a href=\"\/fr\/docker\/kubernetes\/chart-helm-proxysql-charger-les-requetes-sql-au-demarrage.html\">chart Helm ProxySQL<\/a> dans lequel j&rsquo;expliquais comment configurer le pod \u00e0 partir de requ\u00eates SQL. Le chart inclus un ingress pour atteindre le serveur de stats sur le port 6080. Voici quelques d\u00e9tails pour le rendre fonctionnel.<\/p>\n\n\n\n<p><br>L&rsquo;ingress doit \u00eatre activ\u00e9 dans le fichier Values et le serveur web ProxySQL demande aussi que la variable admin admin-web_enabled soit param\u00e9tr\u00e9e.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"yaml\" class=\"language-yaml\">ingress:\n  enabled: true\n  annotations:\n    kubernetes.io\/ingress.class: nginx\n  hosts:\n    - host: proxy.domaine.lan\n      paths:\n        - \/\n\nsqlqueries: |\n  SET admin-web_enabled='true';\n  LOAD ADMIN VARIABLES TO RUNTIME;\n  -- autres requetes<\/code><\/pre>\n\n\n\n<p><br>Si vous le laissez tel quel, les connexions HTTP \u00e0 l&rsquo;interface web retourneront l&rsquo;erreur suivante:<br><em>Error: received handshake message out of context<\/em><br>L&rsquo;interface web ProxySQL n&rsquo;accepte que les <a href=\"https:\/\/github.com\/sysown\/proxysql\/issues\/2550\" target=\"_blank\" rel=\"noreferrer noopener\">connexions HTTPS<\/a> &#8211; m\u00eame si les exemples fournis dans la documentation utilisent le HTTP &#8211; et il n&rsquo;y a pas d&rsquo;alternative.<\/p>\n\n\n\n<p><br>L&rsquo;ingress doit se connecter au backend avec le protocole HTTPS. Nginx permet de sp\u00e9cifier le protocole utilis\u00e9 avec l&rsquo;<a href=\"https:\/\/kubernetes.github.io\/ingress-nginx\/user-guide\/nginx-configuration\/annotations\/#backend-protocol\" target=\"_blank\" rel=\"noreferrer noopener\">annotation backend-protocol<\/a>. Vous avez toujours le choix de laisser l&rsquo;acc\u00e8s \u00e0 l&rsquo;ingress depuis l&rsquo;ext\u00e9rieur en HTTP, mais ne le faites pas sur une interface publique.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"yaml\" class=\"language-yaml\">nginx.ingress.kubernetes.io\/backend-protocol: \"HTTPS\"<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>J&rsquo;ai pr\u00e9sent\u00e9 dans un article pr\u00e9c\u00e9dent le chart Helm ProxySQL dans lequel j&rsquo;expliquais comment configurer le pod \u00e0 partir de requ\u00eates SQL. Le chart inclus un ingress pour atteindre le serveur de stats sur le port 6080. Voici quelques d\u00e9tails pour le rendre fonctionnel. L&rsquo;ingress doit \u00eatre activ\u00e9 dans le fichier Values et le serveur [&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":[458,459,4],"tags":[460,461,404,462],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.13 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Netexpertise - Comment Acc\u00e9der \u00e0 l&#039;Interface Web ProxySQL sur Kubernetes<\/title>\n<meta name=\"description\" content=\"Installer le chart Helm ProxySQL sur Kubernetes, activer l&#039;interface web, et donner acc\u00e8s via l&#039;ingress Nginx de Kubernetes\" \/>\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\/docker\/kubernetes\/comment-acceder-a-linterface-web-proxysql-sur-kubernetes.html\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Netexpertise - Comment Acc\u00e9der \u00e0 l&#039;Interface Web ProxySQL sur Kubernetes\" \/>\n<meta property=\"og:description\" content=\"Installer le chart Helm ProxySQL sur Kubernetes, activer l&#039;interface web, et donner acc\u00e8s via l&#039;ingress Nginx de Kubernetes\" \/>\n<meta property=\"og:url\" content=\"http:\/\/www.netexpertise.eu\/fr\/docker\/kubernetes\/comment-acceder-a-linterface-web-proxysql-sur-kubernetes.html\" \/>\n<meta property=\"og:site_name\" content=\"Netexpertise\" \/>\n<meta property=\"article:published_time\" content=\"2021-07-19T20:09:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-07-19T20:09:05+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\/docker\/kubernetes\/comment-acceder-a-linterface-web-proxysql-sur-kubernetes.html\",\"url\":\"http:\/\/www.netexpertise.eu\/fr\/docker\/kubernetes\/comment-acceder-a-linterface-web-proxysql-sur-kubernetes.html\",\"name\":\"Netexpertise - Comment Acc\u00e9der \u00e0 l'Interface Web ProxySQL sur Kubernetes\",\"isPartOf\":{\"@id\":\"http:\/\/www.netexpertise.eu\/fr\/#website\"},\"datePublished\":\"2021-07-19T20:09:03+00:00\",\"dateModified\":\"2021-07-19T20:09:05+00:00\",\"author\":{\"@id\":\"http:\/\/www.netexpertise.eu\/fr\/#\/schema\/person\/e398f0307e2b167f6b884c4953be2632\"},\"description\":\"Installer le chart Helm ProxySQL sur Kubernetes, activer l'interface web, et donner acc\u00e8s via l'ingress Nginx de Kubernetes\",\"breadcrumb\":{\"@id\":\"http:\/\/www.netexpertise.eu\/fr\/docker\/kubernetes\/comment-acceder-a-linterface-web-proxysql-sur-kubernetes.html#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/www.netexpertise.eu\/fr\/docker\/kubernetes\/comment-acceder-a-linterface-web-proxysql-sur-kubernetes.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/www.netexpertise.eu\/fr\/docker\/kubernetes\/comment-acceder-a-linterface-web-proxysql-sur-kubernetes.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"http:\/\/www.netexpertise.eu\/fr\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Comment Acc\u00e9der \u00e0 l&rsquo;Interface Web ProxySQL sur Kubernetes\"}]},{\"@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 - Comment Acc\u00e9der \u00e0 l'Interface Web ProxySQL sur Kubernetes","description":"Installer le chart Helm ProxySQL sur Kubernetes, activer l'interface web, et donner acc\u00e8s via l'ingress Nginx de Kubernetes","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\/docker\/kubernetes\/comment-acceder-a-linterface-web-proxysql-sur-kubernetes.html","og_locale":"fr_FR","og_type":"article","og_title":"Netexpertise - Comment Acc\u00e9der \u00e0 l'Interface Web ProxySQL sur Kubernetes","og_description":"Installer le chart Helm ProxySQL sur Kubernetes, activer l'interface web, et donner acc\u00e8s via l'ingress Nginx de Kubernetes","og_url":"http:\/\/www.netexpertise.eu\/fr\/docker\/kubernetes\/comment-acceder-a-linterface-web-proxysql-sur-kubernetes.html","og_site_name":"Netexpertise","article_published_time":"2021-07-19T20:09:03+00:00","article_modified_time":"2021-07-19T20:09:05+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\/docker\/kubernetes\/comment-acceder-a-linterface-web-proxysql-sur-kubernetes.html","url":"http:\/\/www.netexpertise.eu\/fr\/docker\/kubernetes\/comment-acceder-a-linterface-web-proxysql-sur-kubernetes.html","name":"Netexpertise - Comment Acc\u00e9der \u00e0 l'Interface Web ProxySQL sur Kubernetes","isPartOf":{"@id":"http:\/\/www.netexpertise.eu\/fr\/#website"},"datePublished":"2021-07-19T20:09:03+00:00","dateModified":"2021-07-19T20:09:05+00:00","author":{"@id":"http:\/\/www.netexpertise.eu\/fr\/#\/schema\/person\/e398f0307e2b167f6b884c4953be2632"},"description":"Installer le chart Helm ProxySQL sur Kubernetes, activer l'interface web, et donner acc\u00e8s via l'ingress Nginx de Kubernetes","breadcrumb":{"@id":"http:\/\/www.netexpertise.eu\/fr\/docker\/kubernetes\/comment-acceder-a-linterface-web-proxysql-sur-kubernetes.html#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["http:\/\/www.netexpertise.eu\/fr\/docker\/kubernetes\/comment-acceder-a-linterface-web-proxysql-sur-kubernetes.html"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/www.netexpertise.eu\/fr\/docker\/kubernetes\/comment-acceder-a-linterface-web-proxysql-sur-kubernetes.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"http:\/\/www.netexpertise.eu\/fr"},{"@type":"ListItem","position":2,"name":"Comment Acc\u00e9der \u00e0 l&rsquo;Interface Web ProxySQL sur Kubernetes"}]},{"@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\/959"}],"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=959"}],"version-history":[{"count":0,"href":"http:\/\/www.netexpertise.eu\/fr\/wp-json\/wp\/v2\/posts\/959\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.netexpertise.eu\/fr\/wp-json\/wp\/v2\/media?parent=959"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.netexpertise.eu\/fr\/wp-json\/wp\/v2\/categories?post=959"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.netexpertise.eu\/fr\/wp-json\/wp\/v2\/tags?post=959"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}