{"id":3136,"date":"2019-12-04T08:08:23","date_gmt":"2019-12-04T07:08:23","guid":{"rendered":"https:\/\/esferas.org\/msqlu\/?p=3136"},"modified":"2019-12-05T05:20:40","modified_gmt":"2019-12-05T04:20:40","slug":"awstats-de-nuevo","status":"publish","type":"post","link":"https:\/\/esferas.org\/msqlu\/2019\/12\/04\/awstats-de-nuevo\/","title":{"rendered":"awstats de nuevo"},"content":{"rendered":"<div class='__iawmlf-post-loop-links' style='display:none;' data-iawmlf-post-links='[{&quot;id&quot;:495,&quot;href&quot;:&quot;https:\\\/\\\/stackoverflow.com\\\/a\\\/14850083&quot;,&quot;archived_href&quot;:&quot;&quot;,&quot;redirect_href&quot;:&quot;https:\\\/\\\/stackoverflow.com\\\/questions\\\/13832701\\\/how-do-i-get-awstats-to-analyze-old-log-files\\\/14850083#14850083&quot;,&quot;checks&quot;:[],&quot;broken&quot;:false,&quot;last_checked&quot;:null,&quot;process&quot;:&quot;done&quot;}]'><\/div>\n<p>Con m\u00e1s emoci\u00f3n (y m\u00e1s datos) por el mismo precio. <\/p>\n\n\n\n<!--more-->\n\n\n\n<p>Usando <a href=\"https:\/\/esferas.org\/msqlu\/2014\/01\/02\/poniendo-en-marcha-awstats\/\">mi antigua entrada al respecto<\/a> y consultando la documentaci\u00f3n del paquete Debian, especialmente respeto a permisos de acceso y disposiciones para m\u00faltiples servidores virtuales, he conseguido que funcione correctamente para el servidor tal y como est\u00e1 ahora mismo. <\/p>\n\n\n\n<p>El acceso est\u00e1 protegido primero por una conexi\u00f3n segura al servidor virtual que empleo para estos casos y luego enlaz\u00e1ndolo al directorio LDAP de manera que sea obligatorio emplear una credencial existente para ver la informaci\u00f3n. Como tambi\u00e9n indico en esa entrada he tenido que apa\u00f1ar una p\u00e1gina de aterrizaje con una simple lista de sitios y aplicaciones web que me facilita las cosas. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"691\" height=\"538\" src=\"https:\/\/esferas.org\/msqlu\/wp-content\/uploads\/sites\/12\/2019\/12\/Screenshot_2019-12-04-https-admin-venexma-net.png\" alt=\"\" class=\"wp-image-3142\" srcset=\"https:\/\/esferas.org\/msqlu\/wp-content\/uploads\/sites\/12\/2019\/12\/Screenshot_2019-12-04-https-admin-venexma-net.png 691w, https:\/\/esferas.org\/msqlu\/wp-content\/uploads\/sites\/12\/2019\/12\/Screenshot_2019-12-04-https-admin-venexma-net-300x234.png 300w\" sizes=\"auto, (max-width: 691px) 100vw, 691px\" \/><\/figure>\n\n\n\n<p>La distinci\u00f3n entre sitios web y aplicaciones es puramente conceptual. La p\u00e1gina principal est\u00e1 hecha con WordPress pero para m\u00ed no es una aplicaci\u00f3n. Por contra las listas de correo (sympa) o las propias estad\u00edsticas web (awstats) no son p\u00e1ginas como tales a pesar de que en ambos casos el contenido se est\u00e1 construyendo al vuelo. <\/p>\n\n\n\n<p>Para alimentar con registros ya rotados la base de datos de awstats para un dominio concreto, el de la p\u00e1gina principal, empleo esta receta que he encontrado en <a href=\"https:\/\/stackoverflow.com\/a\/14850083\">stackoverflow<\/a> (para variar):<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># sudo -u www-data \/bin\/sh\n$ zcat access.log.1.gz > \/tmp\/access.log \n$ \/usr\/lib\/cgi-bin\/awstats.pl -update -config=\"zeine.es\" -LogFile=\"\/tmp\/access.log\"\nFrom data in log file \"\/tmp\/access.log\"...\nPhase 1 : First bypass old records, searching new record...\nDirect access to last remembered record has fallen on another record.\nSo searching new records from beginning of log file...\nJumped lines in file: 0\nParsed lines in file: 987161\n Found 16 dropped records,\n Found 0 comments,\n Found 0 blank records,\n Found 4635 corrupted records,\n Found 982510 old records,\n Found 0 new qualified records.<\/code><\/pre>\n\n\n\n<p>Y aunque es el m\u00e9todo recomendado en las respuestas tambi\u00e9n recuerdan que es posible que los registros no se incluyan dado que es una operaci\u00f3n de actualizaci\u00f3n. En ese caso basta con borrar el contenido del directorio de datos en <em>\/var\/lib\/awstats\/zeine.es<\/em> y volver a ejecutar el programa sin el par\u00e1metro <em>-update<\/em>. <\/p>\n\n\n\n<p>De tal manera que una nueva operaci\u00f3n de inserci\u00f3n de registros da el siguiente resultado:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Create\/Update database for config \"\/etc\/awstats\/awstats.zeine.es.conf\" by AWStats version 7.6 (build 20161204)\nFrom data in log file \"\/tmp\/access.log\"...\nPhase 1 : First bypass old records, searching new record...\nSearching new records from beginning of log file...\nPhase 2 : Now process new records (Flush history on disk after 20000 hosts)...\nReverse DNS lookup for ::1 not available without ipv6 plugin enabled.\nJumped lines in file: 0\nParsed lines in file: 987161\n Found 16 dropped records,\n Found 0 comments,\n Found 0 blank records,\n Found 4637 corrupted records,\n Found 0 old records,\n Found 982508 new qualified records.<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Con m\u00e1s emoci\u00f3n (y m\u00e1s datos) por el mismo precio.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","webmentions_disabled_pings":false,"webmentions_disabled":false,"footnotes":""},"categories":[2],"tags":[145],"class_list":["post-3136","post","type-post","status-publish","format-standard","hentry","category-software","tag-awstats"],"_links":{"self":[{"href":"https:\/\/esferas.org\/msqlu\/wp-json\/wp\/v2\/posts\/3136","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/esferas.org\/msqlu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/esferas.org\/msqlu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/esferas.org\/msqlu\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/esferas.org\/msqlu\/wp-json\/wp\/v2\/comments?post=3136"}],"version-history":[{"count":7,"href":"https:\/\/esferas.org\/msqlu\/wp-json\/wp\/v2\/posts\/3136\/revisions"}],"predecessor-version":[{"id":3150,"href":"https:\/\/esferas.org\/msqlu\/wp-json\/wp\/v2\/posts\/3136\/revisions\/3150"}],"wp:attachment":[{"href":"https:\/\/esferas.org\/msqlu\/wp-json\/wp\/v2\/media?parent=3136"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/esferas.org\/msqlu\/wp-json\/wp\/v2\/categories?post=3136"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/esferas.org\/msqlu\/wp-json\/wp\/v2\/tags?post=3136"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}