半袖野郎 blog.hansode.org

時々出るPHPのWarning

 PHP Warning:  mysql_connect(): Lost connection to MySQL server at 'reading authorization packet', system error: 0 in /path/to/foo.php on line 123

再現出来ない

$ svn checkout $(repository)
svn: 'http' 用 RA のバージョンが一致しません: 実際 1.4.6, 期待 1.4.0

$ sudo apt-get update && sudo apt-get dist-upgrade

環境

$ cat /etc/debian_version
lenny/sid

珍しい現象に遭遇

ユーザーが所有している保障のないキー

$ gpg --version
gpg (GnuPG) 1.4.6

$ gpg -se -r foo@example.com -u bar@example.net --passphrase foobar hoge

You need a passphrase to unlock the secret key for
user: "foor bar <bar@example.net>"
1024-bit DSA key, ID 12345678, created 2008-01-01

gpg: CCCCCCCC: There is no assurance this key belongs to the named user

pub  1024g/CCCCCCCC 2007-12-19 foo <foo@example.com>
 Primary key fingerprint: ASDF ASDF ASDF ASDF ASDF  ASDF ASDF ASDF ASDF ASDF
      Subkey fingerprint: 3377 3377 3377 3377 3377  3377 3377 3377 3377 3377

It is NOT certain that the key belongs to the person named
in the user ID.  If you *really* know what you are doing,
you may answer the next question with yes.

Use this key anyway? (y/N)

どうしても、この鍵を使わないと行けない

$ gpg --always-trust -se -r foo@example.com -u bar@example.net --passphrase foobar hoge

ログインしようとしたら、反応が鈍い

「やばい…過負荷だ」

過負荷状態のapacheログ

Use of uninitialized value in string eq at /usr/share/perl5/Cache/Memcached.pm line 494.
Use of uninitialized value in string eq at /usr/share/perl5/Cache/Memcached.pm line 494.
Use of uninitialized value in string eq at /usr/share/perl5/Cache/Memcached.pm line 494.
Use of uninitialized value in string eq at /usr/share/perl5/Cache/Memcached.pm line 494.
Use of uninitialized value in string eq at /usr/share/perl5/Cache/Memcached.pm line 494.
Use of uninitialized value in string eq at /usr/share/perl5/Cache/Memcached.pm line 494.
Use of uninitialized value in string eq at /usr/share/perl5/Cache/Memcached.pm line 494.

バージョン情報

$ dpkg -l | awk '$1 == "ii" && $2 ~ "^(apache|mysql|memcached|libcache-memcached-perl|libapache-mod-perl)" {print $2, $3}'
apache 1.3.34-4.1
apache-common 1.3.34-4.1
apache2-mpm-prefork 2.2.6-3
apache2-utils 2.2.6-3
apache2.2-common 2.2.6-3
libapache-mod-perl 1.29.0.4-4.1
libcache-memcached-perl 1.24-1
memcached 1.2.2-1
mysql-client-5.0 5.0.51-2
mysql-common 5.0.51-2
mysql-server-5.0 5.0.51-2

$ telnet tr.whois-servers.net 43
Trying 144.122.95.42...
Connected to whois.nic.tr.
Escape character is '^]'.
php: error while loading shared libraries: libclntsh.so.9.0: cannot open shared object file: No such file or directory
Connection closed by foreign host.

# cd /etc/apache2/sites-available
# vi foo.example.com
# a2ensite foo.example.com
Site foo.example.com installed; run /etc/init.d/apache2
reload to enable.

# /usr/sbin/apache2ctl configtest
Syntax error on line 9 of /etc/apache2/sites-enabled/foo.example.com:
Invalid command 'RewriteEngine', perhaps misspelled or defined by a module not included in the server configuration

# a2enmod rewrite
Module rewrite installed; run /etc/init.d/apache2 force-reload to enable.
# /usr/sbin/apache2ctl configtest
Syntax OK

# cd /path/to/build/httpd-2.2.3/modules/proxy
# /usr/local/apache2/bin/apxs -i -c mod_proxy.c
# /usr/local/apache2/bin/apxs -i -c mod_proxy_http.c

# /usr/local/apache2/bin/apachectl configtest
httpd: Syntax error on line ... of /usr/local/apache2/conf/httpd.conf: Cannot load /usr/local/apache2/modules/mod_proxy.so into server: /usr/local/apache2/modules/mod_proxy.so: undefined symbol: proxy_lb_workers

# /usr/local/apache2/bin/apxs -i -c mod_proxy.c proxy_util.c
# /usr/local/apache2/bin/apxs -i -c mod_proxy_http.c proxy_util.c
# /usr/local/apache2/bin/apachectl configtest
Syntax OK