Obsolete:Misc scripts
Jump to navigation
Jump to search
![]() | This page contains historical information. It is probably no longer true. |
![]() | For current information, you may be looking for Wikimedia binaries. |
Various misc useful scripts:
- upload a local file to the wiki as an edit:
/home/wikipedia/bin/upload en wikipedia /etc/passwd Wikipedia:Sandbox
- count the number of contributions from a user:
/home/wikipedia/bin/editcount en wikipedia Kate
- make a function for each hostname, so that e.g.: browne ps will connect to browne and perform ps:
ALLNG=/usr/local/dsh/node_groups/ALL if [ -r $ALLNG ]; then for host in $(<$ALLNG); $host() { ssh $0 $* }; fi
- count stuff in mailq :
$ /home/wikipedia/bin/mailqcount # of messages: 1584 # of errors : 1770 # of rcpt-to : 1790 $
- Get list of mysql servers according to db.php :
$ /home/wikipedia/bin/mysql-list adler samuel ariel ixia thistle lomaria $
- Get replication data for servers :
$ /home/wikipedia/bin/replication SERVER adler Position: 220761719 SERVER samuel Read_Master_Log_Pos: 220761719 Exec_master_log_pos: 220761719 SERVER ariel Read_Master_Log_Pos: 220761719 Exec_master_log_pos: 220761719 SERVER ixia Read_Master_Log_Pos: 220761719 Exec_master_log_pos: 220761719 SERVER thistle Read_Master_Log_Pos: 220761719 Exec_master_log_pos: 220761719 SERVER lomaria Read_Master_Log_Pos: 220763426 Exec_master_log_pos: 220763426 $