You are browsing a read-only backup copy of Wikitech. The live site can be found at wikitech.wikimedia.org

Difference between revisions of "Etherpad.wikimedia.org"

From Wikitech-static
Jump to navigation Jump to search
imported>Alexandros Kosiaris
 
imported>Alexandros Kosiaris
Line 3: Line 3:
 
: '''Note''' etherpads are 100% public and open.  Anyone can read them.  "Obscure names" are never as obscure as you think and are NOT security.  Also the etherpad database is not suitable for any long-term storage — don't expect important data to stay there.
 
: '''Note''' etherpads are 100% public and open.  Anyone can read them.  "Obscure names" are never as obscure as you think and are NOT security.  Also the etherpad database is not suitable for any long-term storage — don't expect important data to stay there.
 
=== Hardware ===
 
=== Hardware ===
* [[zirconium]] (was [[hooper]])
+
* on a etherpad1001, a VM on ganeti01.svc.eqiad.wmnet cluster
  
 
=== About ===
 
=== About ===
The Etherpad app is currently hosted on zirconium.wikimedia.org. It is version 1.3 of the Etherpad-lite software. We built our own package dependant on our own nodejs packages. Everything is puppetized
+
We built our own package dependant on our own nodejs packages. Everything is puppetized
  
 
The database that it uses is on db1001.  
 
The database that it uses is on db1001.  
Line 21: Line 21:
 
=== Deleting pads via site admin ===
 
=== Deleting pads via site admin ===
  
A variety of ways exist:
+
A variety of ways supposedly exist:
  
 
#Deletion through admin and a plugin(we do not have admin and users on purpose for now) so this is ruled out
 
#Deletion through admin and a plugin(we do not have admin and users on purpose for now) so this is ruled out
 
#Deletion through the API https://github.com/ether/etherpad-lite/wiki/HTTP-API (we do not have users and admins on purpose for now so this is ruled out)
 
#Deletion through the API https://github.com/ether/etherpad-lite/wiki/HTTP-API (we do not have users and admins on purpose for now so this is ruled out)
 +
# Deletion through the CLI https://github.com/ether/etherpad-lite/wiki/Getting-to-know-the-tools-in-bin. Supposedly this should work but it doesn't
 
#Deletion through the DB (this seems to be the only viable option at the time of this writing)
 
#Deletion through the DB (this seems to be the only viable option at the time of this writing)
  

Revision as of 10:08, 26 November 2015

etherpad.wikimedia.org.

Note etherpads are 100% public and open. Anyone can read them. "Obscure names" are never as obscure as you think and are NOT security. Also the etherpad database is not suitable for any long-term storage — don't expect important data to stay there.

Hardware

  • on a etherpad1001, a VM on ganeti01.svc.eqiad.wmnet cluster

About

We built our own package dependant on our own nodejs packages. Everything is puppetized

The database that it uses is on db1001.

The app runs on port 9000 and requests are reverse proxied by apache which also terminates SSL

The EtherpadLite extension allows embedding it into wiki pages.

Database layout

Etherpad-lite has decided to implement a key/value store on top of a RDBMS for some reason. Well it is an abstraction layer so they can work with other backends as well but it seems like the recommended option is an RDDBS (MySQL). http://etherpad.org/doc/v1.2.1/#index_database_structure seems to be the official documentation (version dependent obviously)

Deleting pads via site admin

A variety of ways supposedly exist:

  1. Deletion through admin and a plugin(we do not have admin and users on purpose for now) so this is ruled out
  2. Deletion through the API https://github.com/ether/etherpad-lite/wiki/HTTP-API (we do not have users and admins on purpose for now so this is ruled out)
  3. Deletion through the CLI https://github.com/ether/etherpad-lite/wiki/Getting-to-know-the-tools-in-bin. Supposedly this should work but it doesn't
  4. Deletion through the DB (this seems to be the only viable option at the time of this writing)

Suppose DELETEME is the pad id of the pad you want to remove (pad id can be taken from the url)

 delete from store where `key` like '%DELETEME%'; 

how to list all pads

Two different plugins existed at the time of investigation, one was not installing correctly, one was not of any decent quality

Mediawiki extension

Yes, don't we want to use that and embed in a wiki?

Extension:EtherpadLite

See also