<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="en">
	<id>https://ciapini.wiki.esiliati.org/index.php?action=history&amp;feed=atom&amp;title=Indimedia</id>
	<title>Indimedia - Revision history</title>
	<link rel="self" type="application/atom+xml" href="https://ciapini.wiki.esiliati.org/index.php?action=history&amp;feed=atom&amp;title=Indimedia"/>
	<link rel="alternate" type="text/html" href="https://ciapini.wiki.esiliati.org/index.php?title=Indimedia&amp;action=history"/>
	<updated>2026-04-13T22:58:22Z</updated>
	<subtitle>Revision history for this page on the wiki</subtitle>
	<generator>MediaWiki 1.43.6</generator>
	<entry>
		<id>https://ciapini.wiki.esiliati.org/index.php?title=Indimedia&amp;diff=1175&amp;oldid=prev</id>
		<title>Cesco at 16:19, 23 April 2015</title>
		<link rel="alternate" type="text/html" href="https://ciapini.wiki.esiliati.org/index.php?title=Indimedia&amp;diff=1175&amp;oldid=prev"/>
		<updated>2015-04-23T16:19:35Z</updated>

		<summary type="html">&lt;p&gt;&lt;/p&gt;
&lt;table style=&quot;background-color: #fff; color: #202122;&quot; data-mw=&quot;interface&quot;&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;tr class=&quot;diff-title&quot; lang=&quot;en&quot;&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #202122; text-align: center;&quot;&gt;← Older revision&lt;/td&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #202122; text-align: center;&quot;&gt;Revision as of 18:19, 23 April 2015&lt;/td&gt;
				&lt;/tr&gt;&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot; id=&quot;mw-diff-left-l88&quot;&gt;Line 88:&lt;/td&gt;
&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot;&gt;Line 88:&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;SELECT ( host . space_capacity - SUM ( site . space_weight ) )&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;SELECT ( host . space_capacity - SUM ( site . space_weight ) )&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;FROM site , host , hosts_sites&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;FROM site , host , hosts_sites&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;−&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;WHERE &quot;&lt;del style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;pippo&lt;/del&gt;.ortiche.net&quot; = hosts_sites . host AND hosts_sites . site = site . site AND hosts_sites . host = host . host&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;WHERE &quot;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;nodo&lt;/ins&gt;.ortiche.net&quot; = hosts_sites . host AND hosts_sites . site = site . site AND hosts_sites . host = host . host&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;lt;/source&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;lt;/source&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;br&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;br&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot; id=&quot;mw-diff-left-l97&quot;&gt;Line 97:&lt;/td&gt;
&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot;&gt;Line 97:&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;SELECT ( host . bw_capacity - SUM ( site . bw_weight ) )&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;SELECT ( host . bw_capacity - SUM ( site . bw_weight ) )&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;FROM site , host , hosts_sites&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;FROM site , host , hosts_sites&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;−&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;WHERE &quot;&lt;del style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;pippo&lt;/del&gt;.ortiche.net&quot; = hosts_sites . host AND hosts_sites . site = site . site AND hosts_sites . host = host . host  &lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;WHERE &quot;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;nodo&lt;/ins&gt;.ortiche.net&quot; = hosts_sites . host AND hosts_sites . site = site . site AND hosts_sites . host = host . host  &lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;lt;/source&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;lt;/source&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;br&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;br&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot; id=&quot;mw-diff-left-l127&quot;&gt;Line 127:&lt;/td&gt;
&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot;&gt;Line 127:&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;SELECT site.site&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;SELECT site.site&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;FROM site , hosts_sites&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;FROM site , hosts_sites&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;−&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;WHERE &quot;&lt;del style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;pippo&lt;/del&gt;.ortiche.net&quot; = hosts_sites . host AND hosts_sites . site = site.site  &lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;WHERE &quot;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;nodo&lt;/ins&gt;.ortiche.net&quot; = hosts_sites . host AND hosts_sites . site = site.site  &lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;lt;/source&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;lt;/source&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;br&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;br&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;/table&gt;</summary>
		<author><name>Cesco</name></author>
	</entry>
	<entry>
		<id>https://ciapini.wiki.esiliati.org/index.php?title=Indimedia&amp;diff=5&amp;oldid=prev</id>
		<title>Admin: Created page with &quot;media individuale incensurabile  == &#039;&#039;&#039;tipi di nodo&#039;&#039;&#039; ==  &#039;&#039;dio&#039;&#039;: un nodo nascosto (hidden service tor), con copia autoritativa di tutti i siti esistenti. dio da accesso via...&quot;</title>
		<link rel="alternate" type="text/html" href="https://ciapini.wiki.esiliati.org/index.php?title=Indimedia&amp;diff=5&amp;oldid=prev"/>
		<updated>2012-06-11T14:48:41Z</updated>

		<summary type="html">&lt;p&gt;Created page with &amp;quot;media individuale incensurabile  == &amp;#039;&amp;#039;&amp;#039;tipi di nodo&amp;#039;&amp;#039;&amp;#039; ==  &amp;#039;&amp;#039;dio&amp;#039;&amp;#039;: un nodo nascosto (hidden service tor), con copia autoritativa di tutti i siti esistenti. dio da accesso via...&amp;quot;&lt;/p&gt;
&lt;p&gt;&lt;b&gt;New page&lt;/b&gt;&lt;/p&gt;&lt;div&gt;media individuale incensurabile&lt;br /&gt;
&lt;br /&gt;
== &amp;#039;&amp;#039;&amp;#039;tipi di nodo&amp;#039;&amp;#039;&amp;#039; ==&lt;br /&gt;
&lt;br /&gt;
&amp;#039;&amp;#039;dio&amp;#039;&amp;#039;: un nodo nascosto (hidden service tor), con copia autoritativa di tutti i siti esistenti. dio da accesso via http su hidden service al pannello di admin dei cms e in caso di modifiche a questi ultimi scrive via rete tor il contenuto sui credenti. &amp;#039;&amp;#039;dio&amp;#039;&amp;#039; non esiste.&lt;br /&gt;
implementato come macchina fisica con tor + VM con apache + php con accesso alla rete esclusivamente via tor&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&amp;#039;&amp;#039;credente&amp;#039;&amp;#039;: nodo non-affidabile, di contenuto pubblico, a perdere. credente permette l&amp;#039;accesso in sola lettura via http rete pubblica ai cms e in scrittura via rsync hidden service da parte di dio.&lt;br /&gt;
VPS con apache + php.&lt;br /&gt;
&lt;br /&gt;
== &amp;#039;&amp;#039;&amp;#039;installazione nodo credente:&amp;#039;&amp;#039;&amp;#039; ==&lt;br /&gt;
Si compra una VPS x, con Debian Squeeze (32 o 64 bit). Ci si logga sulla macchina, si aggiunge una riga a /etc/apt/sources.list, per esempio:&lt;br /&gt;
&lt;br /&gt;
&amp;#039;&amp;#039;apt http://ajdklajsdklasd.onion/debian squeeze main&amp;#039;&amp;#039;&lt;br /&gt;
&lt;br /&gt;
e un altro file in /etc/apt/apt.conf.d/30proxy:&lt;br /&gt;
&lt;br /&gt;
&amp;#039;&amp;#039;Acquire::http::Proxy &amp;quot;http://localhost:8118/&amp;quot;;&amp;#039;&amp;#039;&lt;br /&gt;
&lt;br /&gt;
e si installa il pacchetto indimedia_base + hosting + dns (facoltativo).&lt;br /&gt;
Il pacchetto deve essere dipendente da:&lt;br /&gt;
*Tor&lt;br /&gt;
*Polipo&lt;br /&gt;
*rsync&lt;br /&gt;
*ntp&lt;br /&gt;
*unattended-upgrades&lt;br /&gt;
*sqlite3&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
[hosting]&lt;br /&gt;
*apache + mod_macro&lt;br /&gt;
*php&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
[dns]&lt;br /&gt;
*powerdns (senza recursor) + sqlite.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Inoltre, il pacchetto fara&amp;#039; certe azioni:&lt;br /&gt;
*creare un utente indimedia.&lt;br /&gt;
*Copia la chiave pubblica in /home/indimedia/.ssh/authorized_keys&lt;br /&gt;
*Aggiunge un paio di script in /etc/cron.d (da definire).&lt;br /&gt;
*Crea un tor hidden service.&lt;br /&gt;
*Callback dell&amp;#039;hidden service a &amp;#039;dio&amp;#039;.&lt;br /&gt;
&lt;br /&gt;
== &amp;#039;&amp;#039;&amp;#039;Gestione dei credenti:&amp;#039;&amp;#039;&amp;#039; ==&lt;br /&gt;
Dio non controlla direttamente i credenti, ma fornisce loro dei semplici file di configurazione via rsync. &lt;br /&gt;
Un demone controlla ogni x minuti lo stato dei file e fa&amp;#039; una comparazione con lo stato attuale della macchina. Ogni volta che vengono trovate delle discrepazione, il demone riallinea la configurazione della macchine con i file forniti.&lt;br /&gt;
&lt;br /&gt;
== &amp;#039;&amp;#039;I file di configurazione:&amp;#039;&amp;#039; ==&lt;br /&gt;
[hosting]&lt;br /&gt;
*sites.txt: Contiene i siti attivi su questa macchina. (letto da mod_macro)&lt;br /&gt;
[dns]&lt;br /&gt;
*zone.sqlite: Contiene tutti i sottodomini attivi.&lt;br /&gt;
*domains.txt: Contiene tutti i domini attivi.&lt;br /&gt;
&lt;br /&gt;
Da questi files, vengono generati:&lt;br /&gt;
*La configurazione di Apache (domains X (zone contenuti in sites) ).&lt;br /&gt;
*La configurazione di powerdns (domains X zone).&lt;br /&gt;
&lt;br /&gt;
== &amp;#039;&amp;#039;&amp;#039;strutture dati:&amp;#039;&amp;#039;&amp;#039; ==&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&amp;#039;&amp;#039;&amp;#039;host&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
&lt;br /&gt;
host active bw_capacity space_capacity host_onion_hostname(24)&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&amp;#039;&amp;#039;&amp;#039;site&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
&lt;br /&gt;
site active bw_weight space_weight site_onion_hostname(24) site_onion_private_key(1024)&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&amp;#039;&amp;#039;&amp;#039;hosts_sites&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
&lt;br /&gt;
site host&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== &amp;#039;&amp;#039;&amp;#039;queryez&amp;#039;&amp;#039;&amp;#039; ==&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
spazio in libero su un host:&lt;br /&gt;
&lt;br /&gt;
&amp;lt;source lang=&amp;quot;sql&amp;quot;&amp;gt;&lt;br /&gt;
SELECT ( host . space_capacity - SUM ( site . space_weight ) )&lt;br /&gt;
FROM site , host , hosts_sites&lt;br /&gt;
WHERE &amp;quot;pippo.ortiche.net&amp;quot; = hosts_sites . host AND hosts_sites . site = site . site AND hosts_sites . host = host . host&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
banda libera su un host:&lt;br /&gt;
&lt;br /&gt;
&amp;lt;source lang=&amp;quot;sql&amp;quot;&amp;gt;&lt;br /&gt;
SELECT ( host . bw_capacity - SUM ( site . bw_weight ) )&lt;br /&gt;
FROM site , host , hosts_sites&lt;br /&gt;
WHERE &amp;quot;pippo.ortiche.net&amp;quot; = hosts_sites . host AND hosts_sites . site = site . site AND hosts_sites . host = host . host &lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
sito con meno istanze:&lt;br /&gt;
&lt;br /&gt;
versione sqlite&lt;br /&gt;
&amp;lt;source lang=&amp;quot;sql&amp;quot;&amp;gt;&lt;br /&gt;
SELECT site . site , COUNT ( hosts_sites . host ) AS &amp;#039;count&amp;#039;&lt;br /&gt;
FROM site , host&lt;br /&gt;
LEFT OUTER JOIN hosts_sites ON ( site . site = hosts_sites . site AND site . active = 1 AND host . host = hosts_sites . host AND host . active = 1 )&lt;br /&gt;
GROUP BY site . site&lt;br /&gt;
ORDER BY COUNT ASC &lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
comando di sync:&lt;br /&gt;
&lt;br /&gt;
&amp;lt;source lang=&amp;quot;sql&amp;quot;&amp;gt;&lt;br /&gt;
SELECT &amp;quot;rsync - avzHx /var/www/vhosts/&amp;quot; || site . site || &amp;quot;/ rsync : //&amp;quot; || host . onion_hostname || &amp;quot;/&amp;quot; || site . site , &amp;quot;/&amp;quot;&lt;br /&gt;
FROM site , host , hosts_sites&lt;br /&gt;
WHERE hosts_sites . site = &amp;#039;beppe.indimedia.net&amp;#039; AND site . site = hosts_sites . site AND host . host = hosts_sites . host AND host . active = 1&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
siti istanziati su un host:&lt;br /&gt;
&lt;br /&gt;
&amp;lt;source lang=&amp;quot;sql&amp;quot;&amp;gt;&lt;br /&gt;
SELECT site.site&lt;br /&gt;
FROM site , hosts_sites&lt;br /&gt;
WHERE &amp;quot;pippo.ortiche.net&amp;quot; = hosts_sites . host AND hosts_sites . site = site.site &lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
comando di update dimensione siti:&lt;br /&gt;
&lt;br /&gt;
&amp;lt;source lang=&amp;quot;sql&amp;quot;&amp;gt;&lt;br /&gt;
SELECT &amp;quot;du - s /var/www/vhosts/&amp;quot; || site . site&lt;br /&gt;
FROM site &lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
blocco degli HS in torrc:&lt;br /&gt;
&lt;br /&gt;
&amp;lt;source lang=&amp;quot;sql&amp;quot;&amp;gt;&lt;br /&gt;
SELECT &amp;quot;HiddenServiceDir /etc/tor/indimedia/&amp;quot; || site . site || &amp;quot;/ \n HiddenServicePort 873 127 . 0 . 0 . 1 : 873 \n\n&amp;quot;&lt;br /&gt;
FROM site &lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&amp;#039;&amp;#039;&amp;#039;stat&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
&lt;br /&gt;
periodicamente ogni host comunica il consumo orario medio di banda per-sito a dio, che lo integra in bw_weight&lt;br /&gt;
&lt;br /&gt;
dio calcola periodicamente le dimensioni dei site copiati in locale, e segna in space_weight&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&amp;#039;&amp;#039;&amp;#039;coerenza&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
&lt;br /&gt;
dio confronta periodicamente e randomicamente l&amp;#039;hash di una pagina su una vps con l&amp;#039;hash della stessa pagina su dio. se non coincidono disabilita il sito.&lt;br /&gt;
&lt;br /&gt;
&amp;#039;&amp;#039;&amp;#039;trasferimento&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
&lt;br /&gt;
lato credente:&lt;br /&gt;
&lt;br /&gt;
in rsyncd.conf&lt;br /&gt;
&lt;br /&gt;
 [indimedia]&lt;br /&gt;
   list = no&lt;br /&gt;
   path = /var/www/vhosts&lt;br /&gt;
   write only = yes&lt;br /&gt;
&lt;br /&gt;
in torrc&lt;br /&gt;
&lt;br /&gt;
 HiddenServiceDir /usr/pkg/etc/tor/hidden/rsync/&lt;br /&gt;
 HiddenServicePort &amp;#039;&amp;#039;host.local_port&amp;#039;&amp;#039; 127.0.0.1:873&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== &amp;#039;&amp;#039;&amp;#039;procedure&amp;#039;&amp;#039;&amp;#039; ==&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&amp;#039;&amp;#039;&amp;#039;istanziazione:&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
&lt;br /&gt;
il site con meno istanze attive viene istanziato sull&amp;#039;host che ha il rapporto space/bw piu simile  E che ha bw_capacity e space_capacity sufficienti&lt;br /&gt;
&lt;br /&gt;
viene creato un A sito.indimedia -&amp;gt; host&lt;br /&gt;
&lt;br /&gt;
&amp;#039;&amp;#039;&amp;#039;replicazione&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
&lt;br /&gt;
via fileschanged &amp;#039;&amp;#039;dio&amp;#039;&amp;#039; conserva una lista degli eventi di modifica dei file dei siti. dopo un numero random di modifiche (e dopo un tempo non superiore ai 5 minuti) scrive via rsync le modifiche sull&amp;#039;host&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== &amp;#039;&amp;#039;&amp;#039;cms&amp;#039;&amp;#039;&amp;#039; ==&lt;br /&gt;
&lt;br /&gt;
* http://habariproject.org/en/&lt;br /&gt;
pro: amministrazione intuitiva, pdo, multisite nativo&lt;br /&gt;
cons: plugin un po scassi&lt;br /&gt;
&lt;br /&gt;
* http://www.wolfcms.org/&lt;br /&gt;
pro: plugin fighi, sviluppo attivo&lt;br /&gt;
cons: un po obeso, non troppo intuitivo&lt;br /&gt;
&lt;br /&gt;
* http://phpsqlitecms.net/&lt;br /&gt;
pro: db separati (content.sqlite entries.sqlite userdata.sqlite)&lt;br /&gt;
&lt;br /&gt;
* http://pivotx.net/&lt;br /&gt;
db su file, buona gestione immagini, multiuser, multisite, auto-ravanabile&lt;br /&gt;
&lt;br /&gt;
== &amp;#039;&amp;#039;&amp;#039;letture&amp;#039;&amp;#039;&amp;#039; ==&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
* http://www.sqlite.org/wal.html&lt;br /&gt;
* http://www.theprivacyguy.com/anonymous-credit-debit-cards/&lt;br /&gt;
* http://fileschanged.sourceforge.net/&lt;br /&gt;
* https://hackbloc.org/sites/hackbloc.org/files/hidsec.pdf&lt;/div&gt;</summary>
		<author><name>Admin</name></author>
	</entry>
</feed>