All toolserver users have:
- Shell account accessible via SSH
- Public web space
- MySQL account
- MySQL database
SSH and authentication
To access the shell account, use an SSH client to connect to login-services.zedler.knams.wikimedia.org (tools.wikimedia.org is a convenient alias) for this. When logging in, check that the client uses the correct private key to authenticate.
Public web space
Your public web space is accessible via http://tools.wikimedia.de/~username. The contents can be altered via ~/public_html.
Do not place large applications, e.g. MediaWiki in this space. Do not host porn or warez, etc. Be sensible about what goes here.
Access MySQL from the shell in the usual fashion; your credentials are stored in ~/.my.cnf to make life easier. When accessing MySQL from web applications, use sql as the server name.
Each public wiki has a corresponding database, named XXYYYY_pub where XX is the language code (usually 2 or 3 letters) such as fr and YYYY is the project name, e.g. wiktionary.
Watch out for some special cases. The project component of all Wikipedia database is wiki, e.g. enwiki_p. Meta, Commons and Incubator are all considered to be Wikipedias, and so exist in metawiki_p etc.
These databases contain views, in most case, direct copies of the standard tables in a MediaWiki installation. Some views contain less data or are restricted, and there are one or two special views. Remember that you cannot write to a view, so all this data is read-only.
- The user view contains user_id, user_name and user_registration columns
- The user_ids view contains user_id and user_name columns
- The recentchanges view does not contain the data from the rc_ip column
- The archive view does not contain the data from the ar_text column
You have been allocated a database, the contents of which are private except for tables prefixed with pub_. You can use this for storing and caching data, etc. for scripts or web applications.
- There is a database, toolserver, which contains tables holding useful information about the databases stored on the toolserver
- When performing SELECTS with a WHERE condition referencing a timestamp column, remember that the timestamp is in MediaWiki's internal format, YYYYMMDDHHMMSS and is a variant character field, so surround values in quotes
- Newcomers to Unix are advised to read a tutorial on Unix basics, such as http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/basics.html
- Documentation on specifics of the Sun Solaris shell, etc. can be found at http://docs.sun.com/app/docs/prod/solaris.8#hic
- MySQL documentation is available at http://dev.mysql.com/doc/refman/5.0/en/index.html