{"id":205,"date":"2011-07-26T15:10:25","date_gmt":"2011-07-26T15:10:25","guid":{"rendered":"http:\/\/www.extradrm.com\/?p=205"},"modified":"2011-07-26T15:10:25","modified_gmt":"2011-07-26T15:10:25","slug":"configuration-unicode-des-serveurs-koha","status":"publish","type":"post","link":"https:\/\/www.extradrm.com\/?p=205","title":{"rendered":"Configuration Unicode des serveurs Koha"},"content":{"rendered":"<p>L&#8217;installation du logiciel Koha n\u00e9cessite l&#8217;ajout de programmes suppl\u00e9mentaires \u00e0 votre syst\u00e8me linux bas\u00e9e sur une installation standard. Cette liste peut \u00eatre l\u00e9g\u00e8rement diff\u00e9rente suivant la version et le support (CD Live ou DVD).<br \/>\n<span style=\"text-decoration: underline;\">Liste indicative des logiciels \u00e0 ajouter<\/span><br \/>\nlibxml2-devel<br \/>\nlibxslt-devel<br \/>\ntcl<br \/>\nbzip2-devel<br \/>\ngcc<br \/>\nperl-CPAN<br \/>\nperl-ExtUtils-AutoInstall<br \/>\nncftp<br \/>\nwget<br \/>\ngdbm-devel<br \/>\nexpat-devel<br \/>\ntcp_wrappers-devel<br \/>\nlibicu<br \/>\ngit-1.5.3.7-1.fc8<br \/>\nPhPMyAdmin<br \/>\nlibicu<br \/>\nlibicu-devel<\/p>\n<p><strong><!--more--><br \/>\n<\/strong><\/p>\n<p><strong>Param\u00e9trage pour l&#8217;utilisation de l&#8217;unicode<\/strong><\/p>\n<p><em>Le param\u00e9trage pour l&#8217;utilisation de la codification des caract\u00e8res au format unicode doit \u00eatre<\/em><br \/>\n<em>fait AVANT l&#8217;installation du logiciel koha.<\/em><\/p>\n<p><strong>1. Le syst\u00e8me Linux est-il configur\u00e9 pour utiliser la codification des caract\u00e8res en unicode ?<\/strong><\/p>\n<p>Pour le v\u00e9rifier, ouvrir une fen\u00eatre Terminal et taper la commande :<\/p>\n<blockquote><p>locale<\/p><\/blockquote>\n<p>Vous devez obtenir :<br \/>\nLANG=fr_FR.UTF-8 &#8230;.<\/p>\n<p><strong>2. Le serveur web Apache 2 est-il configur\u00e9 pour utiliser la codification des caract\u00e8res en unicode ?<\/strong><br \/>\nPour le v\u00e9rifier, \u00e0 l&#8217;aide d&#8217;un \u00e9diteur de texte, ouvrir le fichier httpd.conf situ\u00e9 dans<br \/>\n\/etc\/httpd\/conf et rechercher s&#8217;il contient la directive :<br \/>\nAddDefaultCharset UTF-8<\/p>\n<p><strong>3. Le serveur MySQL est-il configur\u00e9 pour utiliser la codification des caract\u00e8res en unicode ?<\/strong><\/p>\n<p>NB : le service mysqld doit \u00eatre d\u00e9marr\u00e9.<\/p>\n<p>Dans une fen\u00eatre Terminal, taper la commande mysql, puis faire une requ\u00eate SQL pour afficher le<br \/>\ncontenu des variables de configuration du serveur.<br \/>\nTexte de la requ\u00eate :<\/p>\n<blockquote><p>show variables where variable_name like &#8216;char%&#8217;;<\/p><\/blockquote>\n<p>******************************************************************<br \/>\nCapture d&#8217;\u00e9cran<br \/>\nmysql&gt; show variables where variable_name like &#8216;char%&#8217;;<br \/>\n+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-+<br \/>\n| Variable_name | Value |<br \/>\n+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-+<br \/>\n| character_set_client | latin1 |<br \/>\n| character_set_connection | latin1 |<br \/>\n| character_set_database | latin1 |<br \/>\n| character_set_filesystem | binary |<br \/>\n| character_set_results | latin1 |<br \/>\n| character_set_server | latin1 |<br \/>\n| character_set_system | utf8 |<br \/>\n| character_sets_dir | \/usr\/share\/mysql\/charsets\/ |<br \/>\n+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-+<br \/>\n8 rows in set (0.00 sec)<br \/>\n******************************************************************<br \/>\nCertaines variables ne sont pas correctement configur\u00e9es (latin1), nous devons donc modifier le<br \/>\nfichier de configuration du serveur MySQL.<br \/>\nQuitter le client mysql par la commande <strong>quit<\/strong>.<\/p>\n<p>A l&#8217;aide d&#8217;un \u00e9diteur de texte, ouvrir le fichier my.cnf situ\u00e9 dans le r\u00e9pertoire \/etc et ajouter ces 3<br \/>\nlignes dans la section [mysqld] :<\/p>\n<blockquote><p>default-character-set=utf8<br \/>\ncharacter-set-server=utf8<br \/>\nskip-character-set-client-handshake<\/p><\/blockquote>\n<p>Afin que cette modification soit prise en compte, red\u00e9marrer le serveur Mysql en utilisant la<br \/>\ncommande suivante dans une fen\u00eatre Terminal :<\/p>\n<blockquote><p>service <strong>mysqld<\/strong> restart (Fedora \/ Redhat)<\/p>\n<p>service <strong>mysql<\/strong> restart (Debian \/ Ubuntu)<\/p>\n<p>ou bien<\/p>\n<p>\/etc\/init.d\/mysql restart (Debian \/ Ubuntu)<\/p><\/blockquote>\n<p>V\u00e9rifier que la modification des param\u00e8tres a \u00e9t\u00e9 prise en compte en se reconnectant au serveur<br \/>\nMySQL par la commande mysql, puis en tapant la requ\u00eate :<br \/>\nshow variables where variable_name like &#8216;char%&#8217;;<br \/>\nLes variables contiennent bien utf8\/<br \/>\nQuitter MySQL par la commande quit<br \/>\n******************************************************************<br \/>\nCapture d&#8217;\u00e9cran<\/p>\n<p>mysql<br \/>\nWelcome to the MySQL monitor. Commands end with ; or g.<br \/>\nYour MySQL connection id is 2<br \/>\nServer version: 5.0.45 Source distribution<br \/>\nType &#8216;help;&#8217; or &#8216;h&#8217; for help. Type &#8216;c&#8217; to clear the buffer.<br \/>\nmysql&gt; show variables where variable_name like &#8216;char%&#8217;;<br \/>\n+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-+<br \/>\n| Variable_name | Value |<br \/>\n+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-+<br \/>\n| character_set_client | utf8 |<br \/>\n| character_set_connection | utf8 |<br \/>\n| character_set_database | utf8 |<br \/>\n| character_set_filesystem | binary |<br \/>\n| character_set_results | utf8 |<br \/>\n| character_set_server | utf8 |<br \/>\n| character_set_system | utf8 |<br \/>\n| character_sets_dir | \/usr\/share\/mysql\/charsets\/ |<br \/>\n+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-+<br \/>\n8 rows in set (0.00 sec)<br \/>\nmysql&gt; quit<br \/>\nBye<br \/>\n******************************************************************<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>L&#8217;installation du logiciel Koha n\u00e9cessite l&#8217;ajout de programmes suppl\u00e9mentaires \u00e0 votre syst\u00e8me linux bas\u00e9e sur une installation standard. Cette liste peut \u00eatre l\u00e9g\u00e8rement diff\u00e9rente suivant la version et le support (CD Live ou DVD).&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":2855,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[],"youtube_video":null,"_links":{"self":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts\/205"}],"collection":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=205"}],"version-history":[{"count":0,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts\/205\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/media\/2855"}],"wp:attachment":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=205"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=205"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=205"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}