Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

View ottomata's full-sized avatar

Andrew Otto ottomata

View GitHub Profile
#!/bin/bash
set -x
# Source function library
. /lib/lsb/init-functions
USER=varnishlog
PIDFILE=/tmp/varnishncsa.pid
DAEMON=/usr/bin/varnishncsa
DAEMON_OPTS='-w 127.0.0.1:8420 -m RxRequest:^(?!PURGE$) -F "%l %n %t %{Varnish:time_firstbyte}x %h %{Varnish:handling}x/%s %b %m http://%{Host}i%U%q - %{Content-Type}o %{Referer}i %{X-Forwarded-For}i %{User-agent}i"'
define virtual_host(
$enabled = true,
$ip_address = "*",
$port = "80",
$document_root,
$server_name,
$server_alias = false,
$server_admin = false,
$htpasswd = false,
$xcache = false,
mysql> show create table searchindex\G
*************************** 1. row ***************************
Table: searchindex
Create Table: CREATE TABLE `searchindex` (
`si_page` int(10) unsigned NOT NULL,
`si_title` varbinary(255) NOT NULL DEFAULT '',
`si_text` mediumblob NOT NULL,
UNIQUE KEY `si_page` (`si_page`)
) ENGINE=MyISAM DEFAULT CHARSET=binary
1 row in set (0.00 sec)
# NOTE: en.wikipedia.org has an entry in /etc/hosts to 127.0.0.1
# ======== nginx -> apache2 ========
# curl -k -H "Accept-Language: da, en-gb;q=0.8, en;q=0.7" -H "Referer: nginx spaces?" https://en.wikipedia.org/index.php/Main_Page
# apache2/access.log
127.0.0.1 - [09/May/2012:20:29:36 +0000] 2149279 127.0.0.1 200 12884 GET HTTP/1.0://127.0.0.1//index.php/Main_Page proxy_host text/html nginx spaces? 127.0.0.1 curl/7.19.7 (x86_64-pc-linux-gnu) libcurl/7.19.7 OpenSSL/0.9.8k zlib/1.2.3.3 libidn/1.15 da, en-gb;q=0.8, en;q=0.7 -|-|-
# nginx/access.log
root@log1:/var/www/mediawiki/core# ls -l LocalSettings.php
lrwxrwxrwx 1 root www-data 52 2012-05-10 17:13 LocalSettings.php -> /home/otto/wmf_log_tests/mediawiki.LocalSettings.php
# root can read, no problem (of course)
root@log1:/var/www/mediawiki/core# head -n 5 LocalSettings.php
<?php
# This file was automatically generated by the MediaWiki 1.19.0
# installer. If you make manual changes, please keep track in case you
# need to recreate them later.
#
/usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
120518 20:08:34 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120518 20:08:34 InnoDB: Initializing buffer pool, size = 8.0M
120518 20:08:34 InnoDB: Completed initialization of buffer pool
120518 20:08:34 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
root@stat1:/a# stat /a{,/*} /var/lib/mysql{,/*}
File: `/a'
Size: 84 Blocks: 0 IO Block: 4096 directory
Device: 803h/2051d Inode: 128 Links: 7
Access: (0775/drwxrwxr-x) Uid: ( 0/ root) Gid: ( 500/ wikidev)
Access: 2012-05-18 20:11:27.665255162 +0000
Modify: 2012-05-18 19:58:42.885255458 +0000
Change: 2012-05-18 19:58:42.885255458 +0000
File: `/a/build'
Size: 6 Blocks: 0 IO Block: 4096 directory
#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
# Enables a certain Lighttpd config
define lighttpd_config($install="false") {
if $install == "true" {
file { "/etc/lighttpd/conf-available/${title}.conf":
source => "puppet:///files/lighttpd/${title}.conf",
owner => root,
group => www-data,
mode => 0444,
before => File["/etc/lighttpd/conf-enabled/${title}.conf"];
}
class misc::contint::jdk {
# JDK for android continuous integration
# extra stuff for license agreement acceptance
# Based off of http://offbytwo.com/2011/07/20/scripted-installation-java-ubuntu.html
package { "debconf-utils":
ensure => installed
}
exec { "agree-to-jdk-license":