etherpad.wikimedia.org
etherpad.wikimedia.org.
Contents |
Hardware
About
The Etherpad app is currently hosted on hooper.wikimedia.org. It is version 1.1 of the Etherpad software. We built our own package. The only modification is that it is running on open-jdk instead of sun-jdk. Oh, and it's been haxz0red to remove the pro account shtuff.
The database that it uses is on db9. db source is defined in /etc/etherpad/etherpad.local.properties, which is pushed out by puppet from sockpuppet:/root/puppet/templates/etherpad/etherpad.local.properties.erb
The app runs on port 9000. Hooper also has apache running as a reverse-proxy to forward requests on 80 to 9000, as defined by /etc/apache2/sites-available/etherpad.proxy and /etc/apache2/mods-available/proxy.conf which are both pushed out by puppet. If you restart the etherpad app, you will probably also have to do a graceful on apache as well.
Database layout
Yes, one of the top voted questions is/was for a schema, but even there you still find "There does not seem to be much documentation of their table schema" quotes.
First steps understanding etherpad
find out the numeric ID of a pad from the text title
mysql> select NUMID from PAD_REVMETA_META where ID like "%<title>%";
get pad content with numeric ID
mysql> select data from PAD_REVS_TEXT where NUMID=<myid>;
mysql> select data from PAD_REVMETA_TEXT where NUMID=<myid>;
v1.1
- yes, we have 1.1, and watch the embedded youtube video for new features it has: -> [2]
- easier upgrade, we _could_ embed images, upload files...
site admin page
There is an admin interface, the site admin page, at:
http://etherpad.wikimedia.org:9000/ep/admin/
The password can be found in /h/w/docs/etherpad or /etc/etherpad/etherpad.local.properties
This interface offers features like "Pad Broadcast", "Pad Inspector", "Pad Connection Diagnosis" and much more, but also has some server error issues.
deleting old posts (the old version discussion)
deleting pads via site admin (new)
Even though we have 1.1 and the release notes and video mention the new feature to delete pads, we had to patch in this to get it:
add function to delete public pads as etherpad admin
So in the site admin page above you can now use "Delete pad" and enter the id/name. Note: this completely wipes a pad, picking certain revisions is not possible.
how to list all pads
Mediawiki extension
Yes, don't we want to use that and embed in a wiki?
