User:Daveh

The UESPWiki – Your source for The Elder Scrolls since 1995
 
Jump to: navigation, search
  • Real Name: Dave Humphrey
  • Who Am I: Original founder and webmaster of the UESP since its creation in 1995 (and the Daggerfall text FAQ before that)
  • Where Am I: Currently living and working in Toronto, Canada though I do a lot of travelling throughout North America (for work)
  • What I Do: Full time employee for the UESP
  • Current Interests: Besides the usual ES stuff, I'm lately doing a lot of woodworking and ultimate frisbee
  • Age: Born in 1973 I am 39 at this edit
  • What I'm Playing: EverQuest (RoF expansion), MineCraft
  • Where I've Been Lately: San Diego, New Jersey
  • Where I'm Going Soon: Israel


Contents

[edit] Site ToDo List

The following are tasks specifically needed to be done myself, either because I'm the site admin or simply because its something I'm interested in. Also see the UESPWiki:Task List page for general tasks which can be done by any editor.

  • Backups
  • Regular monitoring
  • Setup some forms of automatic monitoring
  • Test backups
  • Monitoring
  • Complete basic monitoring of all essential services using Zabbix
  • Cache
  • Get Squid to cache the content pages
  • Setup a Squid server on top of each content server
  • Investigate an external CDN
  • Performance
  • Improve overall loading time of pages (particularly for logged in users)
  • Benchmark basic settings on content3
  • Investigate lighttpd serving Wiki/Php content
  • Upgrade content servers to use Apache 2.0
  • Look into single rack servers from iWeb
  • Database
  • Upgrade databases to MySQL v5.0
  • Wiki
  • Off-line downloadable versions
  • Upgrade version
  • Create upgrade procedure related to UespCustomCode and other modifications
  • Security
  • Install DenyHosts on all servers
  • Check patch levels of items on all servers and update if required
  • Misc
  • Blue water on maps
  • Daggerfall online map
  • Tamriel online map
  • Interior online maps
  • Bug fix uesp-setup-server and other scripts
  • Finalize/document source code repository

[edit] Ideas/Notes

Just a place for me to jot down some general ideas:

  • Mod Ideas
  • Faction with semi-random quests (ala Daggerfall), many medium-large pre-randomly generated dungeons
  • In-game strategy (ala Civilization). Build 'cities' within the game, gather resources to create buildings, gain prestige to get involved with the province politics (quest line).
  • Luggage (ala Pratchett's Disc World). A large trunk follows you around with a mind, and set of sharp teeth, of its own.


[edit] Handy MediaWiki Queries

  • Count of Daily Edits
     SELECT COUNT( * ) , LEFT( rev_timestamp, 8 ) AS revdate
     FROM `revision` 
     GROUP BY revdate
Add a WHERE rev_minor_edit=0 to not count minor edits.
  • Count of Daily Edits from a Given Date by User
     SELECT COUNT(*) as cnt, rev_user, rev_user_text, LEFT(rev_timestamp, 8) as revdate 
     FROM revision 
     WHERE rev_timestamp > "20121101" 
     GROUP BY rev_user
     ORDER by cnt;

[edit] Useful Commands

  • List Processes Using Port 80
 fuser 80/tcp
  • Memory Usage
 free -m
 top
  • Disk Usage
 df
 du
  • Group Apache Log Errors
  egrep "\[.*\] \[error\] \[client .*\]" error_log | gawk -F ']' '{print $4}' | sort | uniq -c | sort > errors.txt
  • Extract Database from Full Dump File
  sed -n '/^-- Current Database: `dbname`/,/^-- Current Database: `/p' alldbs.sql > dbname.sql
  • Extract Pages from Squid Log and Purge
  awk '{print $7}' access.log > allpages.txt
  grep  "/wiki/" allpages.txt > mainpages.txt
  grep "www.uesp.net" mainpages.txt > wwwpages.txt
  egrep "m.uesp.net|mobile.uesp.net" mainpages.txt > mobilepages.txt
  sort wwwpages.txt > wwwpagesort.txt
  uniq wwwpagesort.txt > wwwpagesuniq.txt
  php purgeList.php --purge < wwwpagesuniq.txt

[edit] Links

Links I always seem to need but never remember...

Wiki Related

Server Architecture:

Retrieved from "http://uesp.net/w/index.php?title=User:Daveh&oldid=1150278"
Personal tools
What is this Ad?
Report Ad