- Shell account accessible via SSH
- Public web space
- MySQL account
- MySQL database
SSH and authentication Edit
Public web space Edit
Do not place large applications, e.g. MediaWiki in this space. Do not host porn or warez, etc. Be sensible about what goes here.
Using MySQL Edit
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.
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
Your database Edit
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
Other documentation Edit
- 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