Choix socket PostgreSQL

Lorsque le client Postgresql se trouve sur la même machine que le serveur, les communications entre le client et le serveur s'effectuent soit via la boucle locale, soit le plus souvent à travers un fichier de type spécial appelé socket.<br />L'emplacement du socket peut se choisir au niveau du fichier postgresql.conf. Supposons que ce fichier contienne la sentence<br />unix_socket_directory='/run/postgresql'<br />Vérifions quel est alors le contenu du dossier /run/postgresql:<br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQt48-GMN0Oclikt31AsIFyxhn3swcabqdwALmbTwQVgCLemwp8jj0GBFtiEBhbj7AnMv1tmhnm9EpWXoJQBptbTfC2-xI8VZvpze4DkdumHyNOVmupwlO0wemzElvrXvZ4x51UTAYAA8/s1600/Capture+du+2012-11-28+16:50:18.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQt48-GMN0Oclikt31AsIFyxhn3swcabqdwALmbTwQVgCLemwp8jj0GBFtiEBhbj7AnMv1tmhnm9EpWXoJQBptbTfC2-xI8VZvpze4DkdumHyNOVmupwlO0wemzElvrXvZ4x51UTAYAA8/s1600/Capture+du+2012-11-28+16:50:18.png" /></a></div>Nous constatons que le dossier /run/postgresql possède les droits rwxrwsr-x (2775 en octal).<br />Il s'y trouve un fichier caché de type socket: celui avec la lettre s figurant en tête de la ligne le concernant.<br />Le choix de l'emplacement du socket tel que formulé dans le fichier postgresql.conf est inopérant pour une connexion vers le serveur postgresql depuis libreoffice base à l'aide du pilote natif sdbc.<br />Ainsi il se peut que la tentative de connexion échoue avec un message du genre:<br /><div style="background-color: #cfe2f3;"><span style="font-family: Courier New, Courier, monospace;">could not connect to server: Aucun fichier ou dossier de ce type </span><br /><span style="font-family: Courier New, Courier, monospace;">Is the server running locally and accepting </span><br /><span style="font-family: Courier New, Courier, monospace;">connections on Unix domain socket "/tmp/.s.PGSQL.5432"? </span></div>Ici le fichier socket est recherché dans /tmp alors qu'il se trouve dans /run/postgresql.<br />Une solution consite à modifier postgresql.conf de manière à ce que le socket soit effectivement dans /tmp.<br />Cependant il ne s'agit pas vraiment d'une bonne idée: en effet /tmp jouit de droits particuliers de type rwxrwxrwt (1777 en octal):<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi9Hzut8DvdlvvdqhMki3YpI37ckxuKSoSSkEeTb69WZzlwWmDROapvs1_WJzhRBchUTO2Jg_nrYsnwbuAW2agHXTYTBqOusNsbvDVLy83pfo5f3zRewzyaPnRQkjbWL2HAQ0Osm2mcdPA/s1600/Capture+du+2012-11-28+17:04:33.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi9Hzut8DvdlvvdqhMki3YpI37ckxuKSoSSkEeTb69WZzlwWmDROapvs1_WJzhRBchUTO2Jg_nrYsnwbuAW2agHXTYTBqOusNsbvDVLy83pfo5f3zRewzyaPnRQkjbWL2HAQ0Osm2mcdPA/s1600/Capture+du+2012-11-28+17:04:33.png" /></a></div><br />La lettre t qui figure en dernière position dans la chaîne des droits indique que le sticky bit est sur on, ce qui signifie que si chacun peut écrire dans le dossier, il ne peut modifier que les fichiers qui lui appartiennent.<br />Or il arrive que si postgresql.conf demande que le socket se trouve dans /tmp, alors les droits de /tmp soient modifiés de manière inopportune.<br />Une meilleure solution consiste à utiliser la variable d'environnement PGHOST.<br />Celle-ci peut avoir deux significations.<br />La plus évidente est que PGHOST contienne le nom du host, comme ici:<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiBCoNtLP3nvH2AbTtLOl_NI733KGrQ_aUwmvCwfzIDuInOcxEndNGHkSwB02uzLZH6qn14DM6Z4iI9Tl0aWpmMZm6alcYyhPx_9Hbv4b40pM7wb5J3DnykdP8PoXgLHJN2VlWea65aWnk/s1600/cipher.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiBCoNtLP3nvH2AbTtLOl_NI733KGrQ_aUwmvCwfzIDuInOcxEndNGHkSwB02uzLZH6qn14DM6Z4iI9Tl0aWpmMZm6alcYyhPx_9Hbv4b40pM7wb5J3DnykdP8PoXgLHJN2VlWea65aWnk/s1600/cipher.png" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"></div>Du fait que le nom du host est précisé, psql se connecte non pas à l'aide du fichier socket, mais via la boucle locale:<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjaB73UcfRATSMjhk24Li6dw5-HtDEF3WqHthCp-HmdGG8p3EtmFiahyphenhyphenX3pvHqw_TJZ9MvAW5SALOGxKkWLobsl267MyHYcGPpUtdig_2OgBJTgxkvx8aMar6e98b7Q8zUD2Ht-uSVMUaQ/s1600/Capture+du+2012-11-28+17:22:19.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjaB73UcfRATSMjhk24Li6dw5-HtDEF3WqHthCp-HmdGG8p3EtmFiahyphenhyphenX3pvHqw_TJZ9MvAW5SALOGxKkWLobsl267MyHYcGPpUtdig_2OgBJTgxkvx8aMar6e98b7Q8zUD2Ht-uSVMUaQ/s1600/Capture+du+2012-11-28+17:22:19.png" /></a></div><br />Mais si la valeur de PGHOST commence par une barre oblique (/), elle indique alors l'emplacement du socket:<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgNuFvJ8jH3aHnc3ifh8mhRfRmk-Umb2_5LNHNTVm7QrS0kmTU6FstBzklX98KrkCUAk68PccIGJN_aGVH7X01UIye1sN2QDcVM8cIq-rQ-COsctBaloGEULcem37nAd4sxMfUTQyOzZ7E/s1600/Capture+du+2012-11-28+17:26:18.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="93" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgNuFvJ8jH3aHnc3ifh8mhRfRmk-Umb2_5LNHNTVm7QrS0kmTU6FstBzklX98KrkCUAk68PccIGJN_aGVH7X01UIye1sN2QDcVM8cIq-rQ-COsctBaloGEULcem37nAd4sxMfUTQyOzZ7E/s640/Capture+du+2012-11-28+17:26:18.png" width="640" /></a></div><br />Voilà la solution: il suffit de s'arranger pour que PGHOST existe et contienne la bonne valeur, par exemple en plaçant dans /etc/profile.d un fichier postgresql.sh contenant:<br /><div style="background-color: #cfe2f3;"><span style="font-family: Courier New, Courier, monospace;">export PGHOST=/run/postgresql </span></div><br />

Choix socket PostgreSQL

Lorsque le client Postgresql se trouve sur la même machine que le serveur, les communications entre le client et le serveur s'effectuent...

Read more »

É quase que impossível "perder" o seu telefone agora.

<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzi0GRHfXUZ7TVKHzrtORNGdyVYZadQ6T7HS1B-FpKtIQdB_u-64XdLy-7lCWpP1d9AEQ_dN2mvDV2XcDK8dVTTM1rf7zWZ2TqQTcauhcHEQXTiemORDl-tC1E9cCt-iuimB7zh1kyoh0/s1600/AvastICO.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzi0GRHfXUZ7TVKHzrtORNGdyVYZadQ6T7HS1B-FpKtIQdB_u-64XdLy-7lCWpP1d9AEQ_dN2mvDV2XcDK8dVTTM1rf7zWZ2TqQTcauhcHEQXTiemORDl-tC1E9cCt-iuimB7zh1kyoh0/s1600/AvastICO.jpg" /></a></div><br /><div class="bb2" style="background-color: white; border-bottom-color: rgb(221, 221, 221); border-bottom-style: solid; border-bottom-width: 2px; color: #171b20; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; margin-bottom: 10px; padding: 0px 0px 15px; text-align: left;">As opções do avast! Anti-Theft podem ser controladas remotamente, ou <a href="https://my.avast.com/" style="color: #0091b7; cursor: pointer; margin: 0px; outline: none; padding: 0px;">via Web</a> ou via SMS enviados de outro telefone. Com os controles via Web, você simplesmente logon e faz com umas poucas clicadas de botões realizar um rastreamento e/ou efetuar comandos no seu telefone. Com controles via SMS, você pode fazer o rastreamento do seu telefone através de comandos específicos via SMS enviados de qualquer outro numero telefônico de que você tenha especificado.</div><h3 style="background-color: white; font-family: Arial, Helvetica, sans-serif; font-size: 14px; margin: 0px; padding: 0px; text-align: left;">Estrutura de comandos SMS</h3><div style="background-color: white; color: #171b20; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; padding: 0px 0px 15px; text-align: left;">Todos os comandos SMS devem começar com sua senha do avast!. Por exemplo, se sua senha avast! for 2222, o comando de bloqueio será: 2222 LOCK</div><div style="background-color: white; color: #171b20; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; padding: 0px 0px 15px; text-align: left;">Baixe <a href="https://www.box.com/s/r495324ncskyi7q3jpwc" target="_blank">AQUI</a> todas as Orientações sobre essa maravilhosa Ferramenta.</div><div style="background-color: white; color: #171b20; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; padding: 0px 0px 15px; text-align: left;"><br /></div><div style="background-color: white; color: #171b20; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; padding: 0px 0px 15px; text-align: left;"></div><h1 class="rotate" style="background-color: #ff9900; color: #ff9900; font-size: 26px; height: 60px; line-height: 26px; margin: 0px; min-height: 60px; padding: 0px;">Ladrões não têm a menor chance: TechHamlet</h1><div><br /></div><div>Mantenha o Poder em suas Mãos.    Ladrões não têm a menor chance!!</div><div><br /></div><div><br /></div><div><br /></div><br />

É quase que impossível "perder" o seu telefone agora.

As opções do avast! Anti-Theft podem ser controladas remotamente, ou  via Web  ou via SMS enviados de outro telefone. Com os controles via W...

Read more »

Linguagem de Programação II - JAVA

<br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0YlXcgdsVDZR9I1Qycplw6VYYykrO0bJ76kwbXTi5cp0Wc_ZRa7HrrNw5K45CcFDlw3qJi5vO6C-qt47DrEcnsSUhQuCJRPghSCAeRjglUJWUPV-L9z304pyZiMy5x40jvockfDgyV94/s1600/Programa%C3%A7%C3%A3o+JAVA.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="207" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0YlXcgdsVDZR9I1Qycplw6VYYykrO0bJ76kwbXTi5cp0Wc_ZRa7HrrNw5K45CcFDlw3qJi5vO6C-qt47DrEcnsSUhQuCJRPghSCAeRjglUJWUPV-L9z304pyZiMy5x40jvockfDgyV94/s400/Programa%C3%A7%C3%A3o+JAVA.jpg" width="400" /></a></div><br /><br /><div style="text-align: center;">Baixe aqui Material Linguagem de Programação <a href="https://www.box.com/s/anxejjq4nj5zme7qlouk" target="_blank">JAVA</a>.</div>

Linguagem de Programação II - JAVA

Baixe aqui Material Linguagem de Programação  JAVA .

Read more »

Exercícios Resolvidos de Redes 1

<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7w2Vh2ok598Rpnb8CRVvT7K38DDQGmdnGs6H-gaxNEqtScKiIAffBjSLyNwmSd4PjURllN6nl9DV-prKSOLx1RMo4y_8c6_Y6_qeawrRgKIQvVdghidSDSAq-N2NrSx9uva4L-MWyFXc/s1600/scm+redes.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="275" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7w2Vh2ok598Rpnb8CRVvT7K38DDQGmdnGs6H-gaxNEqtScKiIAffBjSLyNwmSd4PjURllN6nl9DV-prKSOLx1RMo4y_8c6_Y6_qeawrRgKIQvVdghidSDSAq-N2NrSx9uva4L-MWyFXc/s400/scm+redes.jpg" width="400" /></a></div><div class="separator" style="clear: both; text-align: center;">Baixar Arquivos Sobre Redes: <a href="https://www.box.com/s/bjsl8uu2ffao2jdcnstn" target="_blank">Clique Aqui</a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><div style="text-align: center;"><b><u>Exercícios </u></b></div></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoListParagraphCxSpFirst" style="margin-bottom: 0.0001pt; text-indent: -18pt;"><!--[if !supportLists]-->1)<span style="font-size: 7pt;">      </span><!--[endif]-->Defina camada de rede.<br /><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span> É o segmento de transporte do hospedeiro emissor ao receptor, o lado emissor encapsula segmentos em datagramas.<br /><!--[if !supportLineBreakNewLine]--><br /><!--[endif]--></div><div class="MsoListParagraphCxSpMiddle" style="margin-bottom: 0.0001pt; text-indent: -18pt;"><!--[if !supportLists]-->2)<span style="font-size: 7pt;">      </span><!--[endif]-->Quais são as funções mais importantes da camada de rede.  Explique cada uma. </div><div class="MsoListParagraphCxSpMiddle" style="margin-bottom: 0.0001pt;"> <span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span>Repasse e roteamento. Repasse: mover pacotes da entrada do roteador para a saída apropriada do roteador. Roteamento: determinar rota seguida pelos pacotes da origem ao destino.<br /><!--[if !supportLineBreakNewLine]--><br /><!--[endif]--></div><div class="MsoListParagraphCxSpMiddle" style="margin-bottom: 0.0001pt; text-indent: -18pt;"><!--[if !supportLists]-->3)<span style="font-size: 7pt;">      </span><!--[endif]-->Qual a terceira função mais importantes na camada de rede em algumas arquiteturas, segundo Kurose?<br /><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span> Estabelecimento de conexão: Algumas arquiteturas de rede exigem o estabelecimento de circuitos virtuais antes da transmissão de dados, por exemplo, ATM e Frame relay, x25.<br /><!--[if !supportLineBreakNewLine]--><br /><!--[endif]--></div><div class="MsoListParagraphCxSpMiddle" style="margin-bottom: 0.0001pt; text-indent: -18pt;"><!--[if !supportLists]-->4)<span style="font-size: 7pt;">      </span><!--[endif]-->Dê exemplos de:<br />a) Serviços para data gramas individuais.<br /> <span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span>Entrada garantida e entrada garantida com atraso limitado.<br /><br />b) Serviços para fluxo de data gramas.<br /><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span> Entrega de data grama na ordem, largura de banda mínima garantida e restrições sobre mudanças no espaçamento entre pacotes.<br /><!--[if !supportLineBreakNewLine]--><br /><!--[endif]--></div><div class="MsoListParagraphCxSpMiddle" style="margin-bottom: 0.0001pt; text-indent: -18pt;"><!--[if !supportLists]-->5)<span style="font-size: 7pt;">      </span><!--[endif]-->Defina a expressão circuitos virtuais.<br /><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span> Caminho da origem ao destino comporta-se como um circuito telefônico.<br /><!--[if !supportLineBreakNewLine]--><br /><!--[endif]--></div><div class="MsoListParagraphCxSpMiddle" style="margin-bottom: 0.0001pt; text-indent: -18pt;"><!--[if !supportLists]-->6)<span style="font-size: 7pt;">      </span><!--[endif]-->Em que consiste um circuito virtual?<br /><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span>Caminho da origem ao destino.<br /><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span>Números de VC um número para cada enlace ao longo do caminho. <br /><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span>Entradas  em tabelas de repasse nos roteadores ao longo do caminho.<br /><!--[if !supportLineBreakNewLine]--><br /><!--[endif]--></div><div class="MsoListParagraphCxSpMiddle" style="margin-bottom: 0.0001pt; text-indent: -18pt;"><!--[if !supportLists]-->7)<span style="font-size: 7pt;">      </span><!--[endif]-->Cite abaixo quais são as 2 funções mais importantes de um roteador.<br /><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span> Executar algoritmos/protocolos de roteamento (rip,ospf,bgp) e repasse de datagramas  de entrada para a saída.<br /><!--[if !supportLineBreakNewLine]--><br /><!--[endif]--></div><div class="MsoListParagraphCxSpMiddle" style="margin-bottom: 0.0001pt; text-indent: -18pt;"><!--[if !supportLists]-->8)<span style="font-size: 7pt;">      </span><!--[endif]-->Explique:<br />a) Comutação por memória.<br /><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span> A CPU tem o controle direto sobre os pacotes copiados para a  memória do sistema, e sua velocidade é limitada pela largura de banda da memória.<br /><br />b) Comutação por um barramento.<br /><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span> É um datagrama de memória por barramento compartilhado que possui a velocidade  da comutação limitada pela largura de banda do barramento.<br /><br />c) Comutação por uma rede de interconexão.<br /><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span> É uma comutação que contorna a largura de Banda do barramento, desenvolvido inicialmente para conectar processadores no multiprocessador, fragmentando os datagramas em tamanhos fixos, através do elemento de comutação.<br /><!--[if !supportLineBreakNewLine]--><br /><!--[endif]--></div><div class="MsoListParagraphCxSpMiddle" style="margin-bottom: 0.0001pt; text-indent: -18pt;"><!--[if !supportLists]-->9)<span style="font-size: 7pt;">      </span><!--[endif]-->Com relação as portas de saídas do roteador explique o que significa buffering e disciplina de escalonamento.<br /><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span> Buffering; Exigido quando os datagramas chegam ao elemento de comutação mais rápido do que a taxa de transmissão.<br /><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span> Disciplina de escalonamento: Escolhe entre os datagramas enfileirados para a transmissão.<br /><!--[if !supportLineBreakNewLine]--><br /><!--[endif]--></div><div class="MsoListParagraphCxSpMiddle" style="margin-bottom: 0.0001pt; text-indent: -18pt;"><!--[if !supportLists]-->10)<span style="font-size: 7pt;">   </span><!--[endif]-->Sobre a camada de rede, quais as funções na camada de rede do hospedeiro e roteador?<br /><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span> Escolha de caminhos (protocolo de roteamento).<br /><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span> Tabela de rotas.<br /><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span> Endereçamento, formato de datagramas, tratamento de pacotes (endereço IP)<br /><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span> Aviso de erros e sinalização de rotas (protocolo ICMP).<br /><!--[if !supportLineBreakNewLine]--><br /><!--[endif]--></div><div class="MsoListParagraphCxSpMiddle" style="margin-bottom: 0.0001pt; text-indent: -18pt;"><!--[if !supportLists]-->11)<span style="font-size: 7pt;">   </span><!--[endif]-->Como é o endereçamento no IPV4?<br /><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span> É um edereço IP de 32 bits representado por 4 números decimais.  É dividido em duas partes: Prefixo (Endereço da rede, administrado globalmente) e Sufixo (Endereços de hosts, administrados localmente).<br /><!--[if !supportLineBreakNewLine]--><br /><!--[endif]--></div><div class="MsoListParagraphCxSpMiddle" style="margin-bottom: 0.0001pt; text-indent: -18pt;"><!--[if !supportLists]-->12)<span style="font-size: 7pt;">   </span><!--[endif]-->Explique o conceito de sub-rede.<br /><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span> Uma sub-rede é uma divisão de uma rede de computadores, onde o dispositivo se conecta a mesma parte da sub-rede de endereço IP.<br /><!--[if !supportLineBreakNewLine]--><br /><!--[endif]--></div><div class="MsoListParagraphCxSpMiddle" style="margin-bottom: 0.0001pt; text-indent: -18pt;"><!--[if !supportLists]-->13)<span style="font-size: 7pt;">   </span><!--[endif]-->O que significa CIDR?<br /><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span> É o roteamento interdomínio sem classe, que tem parte de sub-rede do endereço de tamanho arbitrário.<br /><!--[if !supportLineBreakNewLine]--><br /><!--[endif]--></div><div class="MsoListParagraphCxSpMiddle" style="margin-bottom: 0.0001pt; text-indent: -18pt;"><!--[if !supportLists]-->14)<span style="font-size: 7pt;">   </span><!--[endif]-->Como uma máquina obtém um endereço IP?<br /><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span> É fornecido pelo administrador do sistema em um arquivo .<br /><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span> Windows -> painel de controle -> rede -> configuração -> TCP/IP -> Propriedades.<br /><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span> UNIX -> /etc/rc.config.<br /><!--[if !supportLineBreakNewLine]--><br /><!--[endif]--></div><div class="MsoListParagraphCxSpMiddle" style="margin-bottom: 0.0001pt; text-indent: -18pt;"><!--[if !supportLists]-->15)<span style="font-size: 7pt;">   </span><!--[endif]-->O que significa DHCP? Explique.<br /><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span> o DHCP é um protocolo dinâmico de configuração de endereço IP.  Seu objetivo é permitir que o hospedeiro obtenha dinamicamente seu endereço IP do servidor de rede quando se conectar à rede.<br /><!--[if !supportLineBreakNewLine]--><br /><!--[endif]--></div><div class="MsoListParagraphCxSpMiddle" style="margin-bottom: 0.0001pt; text-indent: -18pt;"><!--[if !supportLists]-->16)<span style="font-size: 7pt;">   </span><!--[endif]-->Como um ISP recebe um bloco de endereços?<br /><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span> Através da ICANN, que aloca endereços, administra o DNS  e atribui nomes de domínios e resolve disputas.<br /><!--[if !supportLineBreakNewLine]--><br /><!--[endif]--></div><div class="MsoListParagraphCxSpMiddle" style="margin-bottom: 0.0001pt; text-indent: -18pt;"><!--[if !supportLists]-->17)<span style="font-size: 7pt;">   </span><!--[endif]-->O que é NAT? Explique.<br /><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span> É um protocolo que faz a tradução dos endereços IP e portas TCP da rede local para a internet.<br /><!--[if !supportLineBreakNewLine]--><br /><!--[endif]--></div><div class="MsoListParagraphCxSpMiddle" style="margin-bottom: 0.0001pt; text-indent: -18pt;"><!--[if !supportLists]-->18)<span style="font-size: 7pt;">   </span><!--[endif]-->O que significa ICMP?  Qual a sua função?<br /><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span> É um protocolo usado pelos hospedeiros e roteadores para comunicar informações em nível de rede.  Funções: relatar erro de hospedeiro, rede, porta, protocolo incansável, e eco de solicitação/resposta.<br /><!--[if !supportLineBreakNewLine]--><br /><!--[endif]--></div><div class="MsoListParagraphCxSpMiddle" style="margin-bottom: 0.0001pt;"><br /></div><div class="MsoListParagraphCxSpMiddle" style="margin-bottom: 0.0001pt; text-indent: -18pt;"><!--[if !supportLists]-->19)<span style="font-size: 7pt;">   </span><!--[endif]-->Quais são os principais motivos que levaram a definição do protocolo IPv6?<br /><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span> Espaço de endereço de 32 bits logo estará completamente alocado.<br /><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span> Formato de cabeçalho ajuda agilizar processamento e repasse. Cabeçalho de 40 Bits, tamanho fixo e fragmentação não permitida.<br /><!--[if !supportLineBreakNewLine]--><br /><!--[endif]--></div><div class="MsoListParagraphCxSpMiddle"><br /></div><div class="MsoListParagraphCxSpMiddle" style="margin-bottom: 0.0001pt; text-indent: -18pt;"><!--[if !supportLists]-->20)<span style="font-size: 7pt;">   </span><!--[endif]-->Quais as principais diferenças entre o cabeçalho IPv4 e IPv6?<br /><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span>IPv4 : Os endereços tem 32 bits (4 bytes) de tamanho, registros de endereço no DNS            mapeiam nomes de hosts para endereços IPv4.<br /><br /><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span>  IPv6 : Os endereços tem 128 bits (16 bytes) de tamanho, registros de endereço no DNS mapeiam nomes de hosts para endereços IPv6, possui tamanho fixo de cabeçalho 40 bytes.<br /><!--[if !supportLineBreakNewLine]--><br /><!--[endif]--></div><div class="MsoListParagraphCxSpMiddle"><br /></div><div class="MsoListParagraphCxSpMiddle" style="margin-bottom: 0.0001pt; text-indent: -18pt;"><!--[if !supportLists]-->21)<span style="font-size: 7pt;">   </span><!--[endif]-->Como será a transição do IPv4 para o IPv6?<br /><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span> Através de implementação de túnel(tunelamento): IPv6 transportado como carga útil no datagrama IPv4 entre roteadores IPv4.<br /><!--[if !supportLineBreakNewLine]--><br /><!--[endif]--></div><div class="MsoListParagraphCxSpMiddle"><br /></div><div class="MsoListParagraphCxSpMiddle" style="margin-bottom: 0.0001pt; text-indent: -18pt;"><!--[if !supportLists]-->22)<span style="font-size: 7pt;">   </span><!--[endif]-->O que significa algoritmo de roteamento e tabela de roteamento?<br /><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span> Algoritmo de roteamento: Determina “bons” caminhos (seqüência de roteadores) de menor custo. <br /><br /><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span> Tabelas de roteamento : Arquivo de dados da RAM usada para armazenar informações  de rota sobre redes conectadas diretamente, indicando onde cada nó móvel está localizado.<br /><!--[if !supportLineBreakNewLine]--><br /><!--[endif]--></div><div class="MsoListParagraphCxSpMiddle"><br /></div><div class="MsoListParagraphCxSpMiddle" style="margin-bottom: 0.0001pt; text-indent: -18pt;"><!--[if !supportLists]-->23)<span style="font-size: 7pt;">   </span><!--[endif]-->Em qual camada de rede trabalha o roteador?<br /><span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span> Camada de Enlace.<br /><!--[if !supportLineBreakNewLine]--><br /><!--[endif]--></div><div class="MsoListParagraphCxSpLast"><br /></div><div class="MsoNormal" style="margin-bottom: 0.0001pt;"><br /></div><br /><br />

Exercícios Resolvidos de Redes 1

Baixar Arquivos Sobre Redes:  Clique Aqui Exercícios 1)       Defina camada de rede. à É o segmento de transporte do hospedeiro emissor ao ...

Read more »

Exercícios de Portas Lógicas - Arquitetura de computadores

<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjiecGPYSMWjUwYoAF14vYoMz2LtHeMNUwMaRknPUrC3cPNpfHszjvcwFcShr_Tfz-zSezxUdQS70LgSGhiYwBlbeN9QCoeLFTF5H2y0hz2_nLpwBZH8rM123VPdC2ydrmDyRfMajBhosM/s1600/Portas+l%C3%B3gitas.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="384" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjiecGPYSMWjUwYoAF14vYoMz2LtHeMNUwMaRknPUrC3cPNpfHszjvcwFcShr_Tfz-zSezxUdQS70LgSGhiYwBlbeN9QCoeLFTF5H2y0hz2_nLpwBZH8rM123VPdC2ydrmDyRfMajBhosM/s640/Portas+l%C3%B3gitas.jpg" width="640" /></a></div><div class="separator" style="clear: both; text-align: left;">Baixe aqui a lista de Exercícios: <a href="https://www.box.com/s/vxcs23dzpfj69sh6iaz5" target="_blank">Exercícios</a></div><div class="separator" style="clear: both; text-align: left;">Exercícios com Respostas para conferência: <a href="https://www.box.com/s/3lqn0wc7u2kyfyu1rafo" target="_blank">Operações lógicas</a></div><div class="separator" style="clear: both; text-align: left;">Descrição das Portas lógicas: <a href="https://www.box.com/s/k42viutzieg4u4a8y8re" target="_blank">Portas lógicas</a></div><div class="separator" style="clear: both; text-align: left;">Slide de conceitos: <a href="https://www.box.com/s/4eda4i047upqtj6ixdsl" target="_blank">Conceitos</a></div><div class="separator" style="clear: both; text-align: left;">Material completo livro Arquitetura - Stallings - 8ª Edição: <a href="https://www.box.com/s/vmmxx37k1kt9qxx6d4o9" target="_blank">Livro Stallings 8ª Edição - 18.6MB</a></div><div class="separator" style="clear: both; text-align: left;"><br /></div><br />

Exercícios de Portas Lógicas - Arquitetura de computadores

Baixe aqui a lista de Exercícios:  Exercícios Exercícios com Respostas para conferência:  Operações lógicas Descrição das Portas lógicas:  P...

Read more »

Ubuntu 12.10 et libreoffice base

La version 12.10 d'Ubuntu souffre du même mal que la version précédente: impossible dans libreoffice base d'exécuter un rapport réalisé avec ORB (Oracle Report Builder).<br />Rien de changé. On tombe sur le même message d'erreur que précédemment:<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbGbaqPdz0hL1K0_33dhx3rW0l2ZvZomWTAA4FwaNhGHMzanwrcnwAsx_v2YeqgHhEw6TRAv-DgbRvu25i5z5a2nNvyMXMncw8TN504KCqxbCtYMcCKO1WmX_U5FnTxbBBQVqFaaft8mI/s1600/Capture+du+2012-11-03+16:05:33.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbGbaqPdz0hL1K0_33dhx3rW0l2ZvZomWTAA4FwaNhGHMzanwrcnwAsx_v2YeqgHhEw6TRAv-DgbRvu25i5z5a2nNvyMXMncw8TN504KCqxbCtYMcCKO1WmX_U5FnTxbBBQVqFaaft8mI/s1600/Capture+du+2012-11-03+16:05:33.png" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: left;">Mais cette fois la solution présentée <a href="http://ipv4-ipv6.blogspot.com.blogspot.be/2012/05/ubuntu-1204-et-libreoffice-base.html">dans ce billet</a> conduit tout droit au crash.</div><div class="separator" style="clear: both; text-align: left;">Nous allons passer au plan B: ne plus utiliser la version packagée par Ubuntu et la remplacer par celle téléchargeable sur <a href="http://fr.libreoffice.org/">le site de libreoffice</a>.  <style type="text/css">P { margin-bottom: 0.21cm; }</style> </div><div style="background: #ffffcc; margin-bottom: 0cm;"><b>EDIT</b> : voir une autre solution en fin de billet</div><div class="separator" style="clear: both; text-align: left;">Donc nous téléchargeons les fichiers:</div><div class="separator" style="clear: both; text-align: left;">LibO_3.6.3_Linux_x86-64_install-deb_en-US.tar.gz</div><div class="separator" style="clear: both; text-align: left;">LibO_3.6.3_Linux_x86-64_langpack-deb_fr.tar.gz</div><div class="separator" style="clear: both; text-align: left;">LibO_3.6.3_Linux_x86-64_helppack-deb_fr.tar.gz</div><div class="separator" style="clear: both; text-align: left;">correspondant à notre architecture.</div><div class="separator" style="clear: both; text-align: left;">Et puis nous procédons depuis le dossier de téléchargement:</div><div class="separator" style="clear: both; text-align: left;"><span style="background-color: #e6e6ff; font-family: Courier New, Courier, monospace;">toto@rigel:~/Downloads</span><span style="background-color: #e6e6ff; font-family: 'Courier New', Courier, monospace;">$ </span><span style="background-color: #e6e6ff; font-family: 'Courier New', Courier, monospace;">sudo apt-get remove libreoffice* </span></div><div style="background-color: #e6e6ff;"><span style="font-family: Courier New, Courier, monospace;">toto@rigel:~/Downloads</span><span style="font-family: 'Courier New', Courier, monospace;">$ </span><span style="font-family: 'Courier New', Courier, monospace;">tar xzvf LibO_3.6.3_Linux_x86-64_install-deb_en-US.tar.gz </span><br /><span style="font-family: Courier New, Courier, monospace;">toto@rigel:~/Downloads$ tar xzvf LibO_3.6.3_Linux_x86-64_langpack-deb_fr.tar.gz </span><br /><span style="font-family: Courier New, Courier, monospace;">toto@rigel:~/Downloads$ tar xzvf LibO_3.6.3_Linux_x86-64_helppack-deb_fr.tar.gz  </span><br /><span style="font-family: Courier New, Courier, monospace;">toto@rigel:~/Downloads$ cd LibO_3.6.3.2_Linux_x86-64_install-deb_en-US/DEBS/ </span><br /><span style="font-family: Courier New, Courier, monospace;">toto@rigel:~/Downloads$ sudo dpkg -i *.deb </span><br /><span style="font-family: Courier New, Courier, monospace;">toto@rigel:~/Downloads$ cd desktop-integration/ </span><br /><span style="font-family: Courier New, Courier, monospace;">toto@rigel:~/Downloads$ sudo dpkg -i *.deb </span><br /><span style="font-family: Courier New, Courier, monospace;">toto@rigel:~/Downloads$ cd ../../../LibO_3.6.3.2_Linux_x86-64_langpack-deb_fr/DEBS/ </span><br /><span style="font-family: Courier New, Courier, monospace;">toto@rigel:~/Downloads$ sudo dpkg -i *.deb </span><br /><span style="font-family: Courier New, Courier, monospace;">toto@rigel:~/Downloads$ cd ../../LibO_3.6.3.2_Linux_x86-64_helppack-deb_fr/DEBS </span><br /><span style="font-family: Courier New, Courier, monospace;">toto@rigel:~/Downloads$ sudo dpkg -i *.deb </span></div>Et voilà!<br />L'extension ORB est déjà installée avec le paquet<br /><span style="font-family: Courier New, Courier, monospace;">libobasis3.6-extension-report-builder_3.6.3.2-2_amd64.deb</span><br />de même que le pilote sdbc pour une connexion à postgresql<br /><span style="font-family: Courier New, Courier, monospace;">libobasis3.6-postgresql-sdbc_3.6.3.2-2_amd64.deb</span><br />On ne doit plus s'occuper de rien de ce côté là: cool!<br />Il ne reste plus qu'à tenter l'exécution du fameux rapport.<br />Si nous travaillons avec la base de données intégrée à libreoffice, tout est OK.<br />Essayons maintenant avec une base de données postgresql.<br />Tout d'abord se connecter.<br />Aie:<br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2JjjWk1oxTxX3Jd7k5XNwWFxJcHLiUd9Jrjf6cfS6hwcmHOBtYgmgLKhw-UwvpVp_nTD_QP-wW__pTj_zZMDXjJUMZ4Pibb6xMyJCMr9oMubsuX8gRiuBMcJTP2Q3OwwR1Hrkb8HSppE/s1600/Capture+du+2012-11-03+22:15:21.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2JjjWk1oxTxX3Jd7k5XNwWFxJcHLiUd9Jrjf6cfS6hwcmHOBtYgmgLKhw-UwvpVp_nTD_QP-wW__pTj_zZMDXjJUMZ4Pibb6xMyJCMr9oMubsuX8gRiuBMcJTP2Q3OwwR1Hrkb8HSppE/s1600/Capture+du+2012-11-03+22:15:21.png" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: left;">Ça commence bien!</div><div class="separator" style="clear: both; text-align: left;">La réponse à la question posée</div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: Courier New, Courier, monospace;">Is the server running locally and accepting</span></div><div class="separator" style="clear: both;"><span style="font-family: Courier New, Courier, monospace;">connections on Unix domain socket "<span style="color: red;">/tmp/</span>.s.PGSQL.5432"?</span></div><div class="separator" style="clear: both; text-align: left;">est nécessairement positive puisque avec la version Ubuntu de libreoffice la connexion s'effectuait sans problèmes.</div><div class="separator" style="clear: both; text-align: left;">Du moins c'est ce que nous pensions mais avec la version Ubuntu de libreoffice le message en cas de problème aurait été:</div><div class="separator" style="clear: both; text-align: left;"></div><div class="separator" style="clear: both;"><span style="font-family: Courier New, Courier, monospace;">Is the server running locally and accepting</span></div><div class="separator" style="clear: both;"><span style="font-family: Courier New, Courier, monospace;">connections on Unix domain socket "<span style="color: red;">/var/run/postgresql/</span>.s.PGSQL.5432"?</span></div><div class="separator" style="clear: both;"><span style="font-family: inherit;">Et donc en fait la réponse est négative.</span></div><div class="separator" style="clear: both;"><span style="font-family: inherit;">Pour que le socket qui convient soit utilisé, il suffit de remplacer </span>dans le fichier /etc/postgresql/9.1/main/postgresql.conf</div><div class="separator" style="clear: both;">unix_socket_directory = '/var/run/postgresql'  </div><div class="separator" style="clear: both;">par</div><div class="separator" style="clear: both;">unix_socket_directory = '/tmp'  </div><div class="separator" style="clear: both;">et puis de redémarrer le serveur.</div><div class="separator" style="clear: both;">De la sorte tout est OK et le rapport s'exécute sans problèmes.</div><div class="separator" style="clear: both;">(<b>EDIT</b>: voir une meilleure solution <a href="http://ipv4-ipv6.blogspot.com/2012/11/choix-socket-postgresql.html">ici</a>.)</div>Il se peut que l'on ne souhaite pas changer l'emplacement du socket. Dans ce cas,  une façon de contourner le problème consiste à modifier les paramètres de connexion en ajoutant host=rigel à l'URL de la base de données (alors que ce n'est pas nécessaire puisque nous sommes sur la machine où tourne le serveur) de manière à forcer le passage par la boucle locale:<br /><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjLKR2oDb1g746fIhFlbJHOpLV0LrzNj4i0sNeVzi8v9PIoppLWsRcKwsPJcIWnc9t3xVJpELnMyAfXgmt95DliKTzmF2V9A5wJmHIZukLyQ_h_BLjbDlxffyRjFnOK0VeVy6W8xYhSqlo/s1600/Capture+du+2012-11-04+14:28:58.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjLKR2oDb1g746fIhFlbJHOpLV0LrzNj4i0sNeVzi8v9PIoppLWsRcKwsPJcIWnc9t3xVJpELnMyAfXgmt95DliKTzmF2V9A5wJmHIZukLyQ_h_BLjbDlxffyRjFnOK0VeVy6W8xYhSqlo/s1600/Capture+du+2012-11-04+14:28:58.png" /></a></div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: left;">Cette fois nous recevons le message:</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhe09HaWjDwxbB5Gq58zTbBmZAAwCLaXoqAO5CmEUn5CZQg5GaSk1sYNvocO-6DBXxmDu9Hb-3hi-SmVriIq4SQ6DkB_V1nqT4_HfhXxmYM0flkTI588kp9c2JJ4DqSDR9Wz3opNWHIPSM/s1600/Capture+du+2012-11-03+22:18:14.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhe09HaWjDwxbB5Gq58zTbBmZAAwCLaXoqAO5CmEUn5CZQg5GaSk1sYNvocO-6DBXxmDu9Hb-3hi-SmVriIq4SQ6DkB_V1nqT4_HfhXxmYM0flkTI588kp9c2JJ4DqSDR9Wz3opNWHIPSM/s1600/Capture+du+2012-11-03+22:18:14.png" /></a></div><div class="separator" style="clear: both; text-align: left;"><br /></div>C'est normal car nous ne passons plus par le <i>Unix domain socket</i> et d'après le contenu du fichier /etc/postgresql/9.1/main/pg_hba.conf un mot de passe est nécessaire pour une connexion via la boucle locale:<br /><div style="background-color: #cfe2f3;"><br /><span style="font-family: Courier New, Courier, monospace;"># "local" is for Unix domain socket connections only</span><br /><span style="font-family: 'Courier New', Courier, monospace;">local   all             titine                                  peer map=map01</span><br /><span style="font-family: Courier New, Courier, monospace;">local   all             all                                     peer</span><br /><span style="font-family: Courier New, Courier, monospace;"># IPv4 local connections:</span><br /><span style="font-family: Courier New, Courier, monospace;">host    all             all             127.0.0.1/32            <span style="color: red;">md5</span></span></div>Pour avoir l'opportunité de fournir un mot de passe, il suffit de cocher "Mot de passe requis".<br />Attention, il s'agit d'un mot de passe postgresql et non pas d'un mot de passe système.<br />Bien évidement, de nouveau tout fonctionne nickel et nous avons le plaisir de voir s'afficher à l'écran un magnifique rapport.<br /><br /><b>EDIT:</b><br />Une autre possibilité consiste à installer le dépôt 'libreoffice' qui permet actuellement d'avoir directement une solution fonctionnelle sans qu'il soit nécessaire de télécharger les paquets depuis le site de libreoffice.<br />Les commandes à exécuter sont:<br /><style type="text/css">P { margin-bottom: 0.21cm; }</style> <br /><div style="background: #cfe7f5; margin-bottom: 0cm;"><span style="font-family: Courier New, monospace;">toto@rigel:~$ sudo add-apt-repository ppa:libreoffice/ppa </span></div><div style="background: #cfe7f5; margin-bottom: 0cm;"><span style="font-family: Courier New, monospace;">toto@rigel:~$ sudo apt-get update</span></div><div style="background: #cfe7f5; margin-bottom: 0cm;"><span style="font-family: Courier New, monospace;">toto@rigel:~$ sudo apt-get dist-upgrade</span></div><br />Les fichiers dont l'absence rendait impossible la lecture des rapports, à savoir les fichiers<br /><br /><span style="font-family: Courier New, Courier, monospace;">.../program/librptlo.so</span><br /><span style="font-family: Courier New, Courier, monospace;">.../program/librptuilo.so</span><br /><span style="font-family: Courier New, Courier, monospace;">.../program/librptxmllo.so</span><br /><br />sont fournis avec le paquet libreoffice-report-builder-bin qui devra donc être installé avec le paquet libreoffice-report-builder.<br /><br />

Ubuntu 12.10 et libreoffice base

La version 12.10 d'Ubuntu souffre du même mal que la version précédente: impossible dans libreoffice base d'exécuter un rapport réal...

Read more »