¥«¥ì¥ó¥À¡¼
Á°·î2023ǯ 12·îÍâ·î
Æü·î²Ð¿åÌÚ¶âÅÚ
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
   
WordPress ¥«¥Æ¥´¥ê°ìÍ÷
WordPress ºÇ¶á¤Î¥³¥á¥ó¥È
WordPress ºÇ¶á¤ÎÅê¹Æ
WordPress ·îÊ̲áµî¥í¥°

2012ǯ2·î13Æü(·îÍËÆü)

homebrew ¤Çsubversion1.7+perl¤ò¥¤¥ó¥¹¥È¡¼¥ë

¥«¥Æ¥´¥ê¡¼: - watanabe @ 22»þ28ʬ34ÉÃ
homebrew¤Çsubversion 1.7¤òperl¥â¥¸¥å¡¼¥ëÉÕ¤­¤Ç¥¤¥ó¥¹¥È¡¼¥ë¤·¤è¤¦¤È¤·¤¿¤é¤Ï¤Þ¤Ã¤¿¤Ç¤´¤¶¤ë¤Î´¬ ¢­ÉáÄ̤˥¤¥ó¥¹¥È¡¼¥ë¤ò»î¤¹
% brew install subversion --perl --python
==> Downloading http://www.apache.org/dyn/closer.cgi?path=subversion/subversion-1.7.2.tar.bz2
File already downloaded in /Users/watanabe/Library/Caches/Homebrew
==> ./configure --disable-debug --prefix=/usr/local/Cellar/subversion/1.7.2 --with-ssl --with-zlib=/usr --with-sqlite=/usr/local --disable-neon-version-check --disable-mod-act
==> make
==> make install
==> make swig-py
==> make install-swig-py
==> make swig-pl
==> make install-swig-pl
if test "`/usr/bin/perl -e 'use Cwd; print Cwd::realpath(shift)' /private/tmp/homebrew-subversion-1.7.2-gqXr/subversion-1.7.2/subversion/bindings/swig/perl`" != "`/usr/bin/perl -e 'use Cwd; print Cwd::realpath(shift)' /private/tmp/homebrew-subversion-1.7.2-gqXr/subversion-1.7.2/subversion/bindings/swig/perl`"; then 
       ln -sf /private/tmp/homebrew-subversion-1.7.2-gqXr/subversion-1.7.2/subversion/bindings/swig/perl/native/*.c /private/tmp/homebrew-subversion-1.7.2-gqXr/subversion-1.7.2/subversion/bindings/swig/perl/native; 
     fi
cd /private/tmp/homebrew-subversion-1.7.2-gqXr/subversion-1.7.2/subversion/bindings/swig/perl/native; make OPTIMIZE="" OTHERLDFLAGS="-L/usr/local/Cellar/readline/6.2.2/lib -L/usr/local/Cellar/neon/0.29.6/lib "
/usr/bin/install -c -d /usr/local/Cellar/subversion/1.7.2/lib
cd subversion/bindings/swig/perl/libsvn_swig_perl ; /bin/sh /private/tmp/homebrew-subversion-1.7.2-gqXr/subversion-1.7.2/libtool --mode=install /usr/bin/install -c libsvn_swig_perl-1.la /usr/local/Cellar/subversion/1.7.2/lib/libsvn_swig_perl-1.la
libtool: install: /usr/bin/install -c .libs/libsvn_swig_perl-1.0.dylib /usr/local/Cellar/subversion/1.7.2/lib/libsvn_swig_perl-1.0.dylib
libtool: install: (cd /usr/local/Cellar/subversion/1.7.2/lib && { ln -s -f libsvn_swig_perl-1.0.dylib libsvn_swig_perl-1.dylib || { rm -f libsvn_swig_perl-1.dylib && ln -s libsvn_swig_perl-1.0.dylib libsvn_swig_perl-1.dylib; }; })
libtool: install: /usr/bin/install -c .libs/libsvn_swig_perl-1.lai /usr/local/Cellar/subversion/1.7.2/lib/libsvn_swig_perl-1.la
libtool: install: /usr/bin/install -c .libs/libsvn_swig_perl-1.a /usr/local/Cellar/subversion/1.7.2/lib/libsvn_swig_perl-1.a
libtool: install: chmod 644 /usr/local/Cellar/subversion/1.7.2/lib/libsvn_swig_perl-1.a
libtool: install: ranlib /usr/local/Cellar/subversion/1.7.2/lib/libsvn_swig_perl-1.a
cd /private/tmp/homebrew-subversion-1.7.2-gqXr/subversion-1.7.2/subversion/bindings/swig/perl/native; make install
Files found in blib/arch: installing files in blib/lib into architecture dependent library tree
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
ERROR: Can't create '/Library/Perl/5.12/darwin-thread-multi-2level/SVN'
mkdir /Library/Perl/5.12/darwin-thread-multi-2level/SVN: Permission denied at /System/Library/Perl/5.12/ExtUtils/Install.pm line 494

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
 at -e line 1
make[1]: *** [pure_site_install] Error 13
make: *** [install-swig-pl] Error 2
==> Exit Status: 2
http://github.com/mxcl/homebrew/blob/master/Library/Formula/subversion.rb#L110
==> Environment
HOMEBREW_VERSION: 0.8.1
HEAD: bfe50e38d5ad8a8e1e1241b1982ed417ac6017db
HOMEBREW_PREFIX: /usr/local
HOMEBREW_CELLAR: /usr/local/Cellar
Hardware: quad-core 64-bit sandybridge
OS X: 10.7.3
Kernel Architecture: x86_64
Xcode: 4.2.1
GCC-4.0: N/A
GCC-4.2: N/A
LLVM: build 2336
Clang: 3.0 build 211
MacPorts or Fink? false
X11 installed? true
System Ruby: 1.8.7-249
/usr/bin/ruby => /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/bin/ruby
Which Perl:   /usr/bin/perl
Which Python: /usr/bin/python
Which Ruby:   /Users/watanabe/.rvm/rubies/ruby-1.9.2-p136/bin/ruby
==> Build Flags
CC: /usr/bin/llvm-gcc => /usr/llvm-gcc-4.2/bin/llvm-gcc-4.2
CXX: /usr/bin/llvm-g++ => /usr/llvm-gcc-4.2/bin/llvm-g++-4.2
LD: /usr/bin/llvm-gcc => /usr/llvm-gcc-4.2/bin/llvm-gcc-4.2
CFLAGS: -O3 -w -pipe -march=core2 -msse4
CXXFLAGS: -O3 -w -pipe -march=core2 -msse4
CPPFLAGS: -I/usr/local/Cellar/readline/6.2.2/include -I/usr/local/Cellar/neon/0.29.6/include
LDFLAGS: -L/usr/local/Cellar/readline/6.2.2/lib -L/usr/local/Cellar/neon/0.29.6/lib
PKG_CONFIG_PATH: /usr/local/Cellar/readline/6.2.2/lib/pkgconfig:/usr/local/Cellar/neon/0.29.6/lib/pkgconfig

Error: Failed executing: make install-swig-pl
If `brew doctor' does not help diagnose the issue, please report the bug:
    https://github.com/mxcl/homebrew/wiki/checklist-before-filing-a-new-issue
¤É¤¦¤â Perl¤Î¥â¥¸¥å¡¼¥ë¤ò¥·¥¹¥Æ¥àÎΰè¤Ë¥¤¥ó¥¹¥È¡¼¥ë¤·¤è¤¦¤È¤·¤Æ¤¤¤ëÌÏÍÍ ¢­brew¤¬¥À¥¦¥ó¥í¡¼¥É¤·¤¿¥Õ¥¡¥¤¥ë¤òŬÅö¤Ê¾ì½ê¤ËŸ³«¤·¤ÆÃæ¿È¤ò¸«¤ë
~/Library/Caches/Homebrew/subversion-1.7.2.tar.bz2 subversion/bindings/swig/INSTALL ¤Ëperl¥â¥¸¥å¡¼¥ë¤Î¥Ó¥ë¥ÉÊýË¡¤¬ºÜ¤Ã¤Æ¤¤¤¿¤Î¤ÇFormula¤òÊѹ¹
È´¿è
*  Perl

   Perl 5.8.0 is required.  You can specify the perl binary by passing
   PERL=/path/to/perl as part of the configure command in the top level
   of the Subversion source tree.  Make sure that the Perl version used
   is the same one that you configured SWIG to run against during the
   SWIG configure (see above).

   1.  Run `make swig-pl' from the top of the Subversion source tree.

   2.  Run `make check-swig-pl' from the top of the Subversion source
       tree, to test the bindings 

   3.  to install run `make install-swig-pl' from the top of the
       Subversion source tree.

   If you need to pass extra parameters to Perl build process (Makefile.PL),
   then you need to do this process somewhat different:

   1.  Run `make swig-pl-lib' from the top of the Subversion source tree.

   2.  Run `make install-swig-pl-lib'

   3.  cd subversion/bindings/swig/perl/native 

   4.  Run `perl Makefile.PL EXTRAOPTIONSHERE` 

   5.  Run `make install'

   To install the Perl bindings in a location other than the system
   Perl directory, use the above instructions with the extra option
   PREFIX=/your/prefix/here.

º¹Ê¬
diff --git a/Library/Formula/subversion.rb b/Library/Formula/subversion.rb
index 8bc206d..113af37 100644
--- a/Library/Formula/subversion.rb
+++ b/Library/Formula/subversion.rb
@@ -99,15 +99,16 @@ class Subversion < Formula
      if MacOS.leopard?
         perl_version = "5.8.8"
       else
-        perl_version = "5.10.0"
+        perl_version = "5.12"
       end

       inreplace "Makefile" do |s|
         s.change_make_var! "SWIG_PL_INCLUDES",
           "$(SWIG_INCLUDES) #{arches} -g -pipe -fno-common -DPERL_DARWIN -fno-strict-aliasing -I/usr/local/include -I/System/Library/Perl/#{perl_version}/darwin-thread-multi-2level/CORE"
       end
-      system "make swig-pl"
-      system "make install-swig-pl"
+      system "make swig-pl-lib"
+      system "make install-swig-pl-lib"
+      system "(cd subversion/bindings/swig/perl/native;perl Makefile.PL PREFIX=#{prefix};make install)"
     end

     if build_java?
̵»ö¥¤¥ó¥¹¥È¡¼¥ë¤Ç¤­¤Þ¤¹¤¿¡£

2011ǯ12·î22Æü(ÌÚÍËÆü)

ËÜÆü¤Î¥ï¥ó¥é¥¤¥Ê¡¼

¥«¥Æ¥´¥ê¡¼: - watanabe @ 23»þ51ʬ47ÉÃ
for d in $(find . -name .svn -prune -o -type d -print); do \
test -z "$(ls -A $d|grep -v .svn)" -a -d "$d/.svn" && (echo $d;svn rm $d); \
done
svn¤Î¶õ¥Ç¥£¥ì¥¯¥È¥ê¤òºï½ü¤¹¤ë git-svn»È¤Ã¤Æ¤ë¤È git¾å¤Ç¾Ã¤·¤¿¶õ¤Ë¤Ê¤Ã¤¿¥Ç¥£¥ì¥¯¥È¥ê¤¬svn¾å¤Ë»Ä¤Ã¤Æ¤·¤Þ¤¦¡£ ¤½¤ì¤òºï½ü¤¹¤ë¥ï¥ó¥é¥¤¥Ê¡¼ ¤Ç¤â¾å¤Î¥ï¥ó¥é¥¤¥Ê¡¼¤ÏºÆµ¢Åª¤Ë¶õ¤Ë¤Ê¤ë¥Ç¥£¥ì¥¯¥È¥ê¤ò¾Ã¤»¤Ê¤¤¤Î¤Ç ¤â¤¦¤Ò¤È¹©É×ɬÍ×

2011ǯ11·î22Æü(²ÐÍËÆü)

Scientific Linux 6.1¤Çlv¤òÆþ¤ì¤ë

¥«¥Æ¥´¥ê¡¼: - watanabe @ 17»þ55ʬ48ÉÃ
ºÇ¶á¤Îredhat·Ï¤Çlv¤òÆþ¤ì¤ëÊýË¡
Scientific Linux release 6.1 (Carbon)
$ sudo yum install compat-libtermcap
$ sudo rpm -ivh lv-4.51-8.1.x86_64.rpm
posted at 16:21:35
lv-4.51-8.1.x86_64.rpm ¤Ïscientificlinux 5.7 ¤Î¥¢¡¼¥«¥¤¥Ö¤È¤«¤«¤é¼è¤Ã¤Æ¤¯¤ë
¤³¤ì¤È¤«¢ªhttp://t.co/P2Po3uWS
posted at 16:25:00

2011ǯ8·î27Æü(ÅÚÍËÆü)

netbeans ʸ»ú¥³¡¼¥ÉÀßÄê

¥«¥Æ¥´¥ê¡¼: - watanabe @ 18»þ59ʬ37ÉÃ
twitter¤ËÒ줤¤¿È¯¸À¤ò¼êư¤Çžµ­¤¹¤ë¤È¤«¤ä¤Ã¤Æ¤ß¤ë
netbeansµ¯Æ°»þ¤Ë¥¨¥ó¥³¡¼¥É»ØÄêÊýË¡ netbeans.conf ¤Ë
export JAVA_TOOL_OPTIONS='-Dfile.encoding=UTF-8' netbeans_default_options¤ò¾å½ñ¤­¤·¤Ê¤¤°ÙJAVA_TOOL_OPTIONS¤ò»È¤¦

posted at 18:27:29
netbeansµ¯Æ°»þ¤Î¥ª¥×¥·¥ç¥ó¤Î»ØÄê¤Î¤·¤«¤¿
netbeans7 ¤Î¾ì¹ç ${HOME}/.netbeans/7.0/etc/netbeans.conf ¤ò½ñ¤¯¤Èµ¯Æ°»þ¤ËÆÉ¤ó¤Ç¤¯¤ì¤ë
netbeans.conf ¤ÏMacÈǤǤϤ¿¤À¤Î¥·¥§¥ë¥¹¥¯¥ê¥×¥È

posted at 18:25:34

2011ǯ1·î26Æü(¿åÍËÆü)

mac¤ËRuby/GTK2¤ò¥¤¥ó¥¹¥È¡¼¥ë¤·¤¿

¥«¥Æ¥´¥ê¡¼: - watanabe @ 16»þ06ʬ52ÉÃ
¤Ê¤ó¤«¤¤¤í¤¤¤í¥Ï¥Þ¤Ã¤¿¤Î¤Ç¥á¥â ¥Õ¥Ä¡¼¤ÎÊýË¡:
MacPortsÆþ¤ì¤Æsudo port install rb-gnome
»²¾È »ä¤Î´Ä¶­¤ÏMacPorts¤¸¤ã¤Ê¤¯¤Æfink¤À¤Ã¤¿¤Î¤Èruby¤òrvm¤Ç¥¤¥ó¥¹¥È¡¼¥ë¤·¤Æ¤¿¤Î¤Ç¼«Á°¤Ç¥Ó¥ë¥É¤¹¤ë¤³¤È¤Ë¤·¤¿
¥¨¥é¡¼¤ÎÆâÍÆ¤È¤«¥á¥â¤ë¤Î˺¤ì¤¿¤Î¤Ç³Ð¤¨¤Æ¤ë¸Â¤ê¤Î¥á¥â
´Ä¶­¤È¤«
ruby –version
ruby 1.9.2p136 (2010-12-25 revision 30365) [x86_64-darwin10.6.0]
gem –version
1.3.7
ºÇ½ªÅª¤Ê¼ê½ç
% fink -v install glib2-dev
% gem fetch glib2
% gem unpack glib2
% cd glib2-0.90.5
% ruby extconf.rb -C . --strict gtk2 --with-opt-include=/sw/include
% make
% cp ext/glib2/glib2.bundle lib
% gem install gemify
% ~/.rvm/gems/ruby-1.9.2-p136/gems/gemify-0.3/bin/gemify
% gem build glib2.gemspec
% gem install glib2-0.90.5.gem
% fink -v install pango1-xft2-ft219-dev
% fink -v install gtk+2-dev
% gem install gtk2
ºÇ½é¤Ëgem install gtk2¤·¤¿¤é¤Ê¤ó¤« gobject-2.0 ¤¬Ìµ¤¤¤È¤«¤¤¤¦¥¨¥é¡¼¤Ç»ß¤Ã¤¿
Ä´¤Ù¤Æ¤ß¤ë¤Ègobject-2.0¤Ïglib2¤Ë´Þ¤Þ¤ì¤Æ¤ë¤é¤·¤¤
¥é¥¤¥Ö¥é¥ê¤Ê¤Î¤Ç fink ¤Çglib2-dev¤ò¥¤¥ó¥¹¥È¡¼¥ë
¼¡ ruby¤Îglib2¤Î¥¤¥ó¥¹¥È¡¼¥ë¤Ç¥³¥±¤¿
¤É¤¦¤âlibintl.h¤¬¥¤¥ó¥¯¥ë¡¼¥É¤Ç¤­¤Ê¤¤¤é¤·¤¤
¸«³Ð¤¨¤Î¤¢¤ë¥Õ¥¡¥¤¥ë¤Ê¤Î¤ÇÄ´¤Ù¤Æ¤ß¤ë¤Ègettext¤Ë´Þ¤Þ¤ì¤ë¥Ø¥Ã¥À¡¼¤Ç¸µ¡¹¥¤¥ó¥¹¥È¡¼¥ë¤µ¤ì¤Æ¤¤¤¿(/sw/include¤Ë¸ºß¤·¤Æ¤¤¤¿)
¤¢¤ì¤ì??? ¤È»×¤Ã¤Æ¤¤¤¿¤é glib2¤Î¥Í¥¤¥Æ¥£¥Ö¥Ð¥¤¥Ê¥ê¤ò¥Ó¥ë¥É¤¹¤ë»þ¡¢¥¤¥ó¥¯¥ë¡¼¥É¥Ñ¥¹¤Î»ØÄ꤬ϳ¤ì¤Æ¤¤¤¿
¤·¤ç¤¦¤¬¤Ê¤¤¤Î¤Çbinary gem¤òÀ¸À®¤·¤Æ¥¤¥ó¥¹¥È¡¼¥ë¤¹¤ë¤³¤È¤Ë
extconf.rb¤ò¼Â¹Ô¤¹¤ë»þ with-opt-include¤ò»ØÄꤹ¤ë¤³¤È¤Ç¥Ó¥ë¥É¤Ï½ÐÍ褿
gemspec¤òºî¤ë¤Î¤¬¥á¥ó¥É¡¼¤Ê¤Î¤Çgemify¤È¸À¤¦gemspec¤òÀ¸À®¤·¤Æ¤¯¤ì¤ë¥Ä¡¼¥ë¤òÄɲÃ
¤Çglib2¤ògem¤Ç¥¤¥ó¥¹¥È¡¼¥ë¤·¤¿¸å¡¢gem install gtk2¤·¤ÆÉ¬ÍפȤ¤¤ï¤ì¤¿¥é¥¤¥Ö¥é¥ê¤¬Æþ¤Ã¤Æ¤¤¤ë¥Ñ¥Ã¥±¡¼¥¸
(pango1-xft2-ft219-dev,gtk+2-dev)¤ò¥¤¥ó¥¹¥È¡¼¥ë
̵»ö¥¤¥ó¥¹¥È¡¼¥ë´°Î»

2010ǯ10·î21Æü(ÌÚÍËÆü)

ÆüËܸì¥Õ¥¡¥¤¥ë̾¤Î¥À¥¦¥ó¥í¡¼¥É

¥«¥Æ¥´¥ê¡¼: - watanabe @ 22»þ32ʬ17ÉÃ
java¤È¤¤¤¦¤«servlet¤ÇÆüËܸì¥Õ¥¡¥¤¥ë̾¤ò¥À¥¦¥ó¥í¡¼¥É¤µ¤»¤ëÊýË¡¤Ë¤Ä¤¤¤ÆÄ´¤Ù¤Æ¤ß¤¿¡£ setCharacterEncoding() ¤ÏPOST¤Î»þ¤ËÍ­¸ú¤Ë¤Ê¤ë(Apache Tomcat,RFCŪ¤Ë¤ÏÀµ¤·¤¤»ÅÍÍ)
String#getBytes(String) ¤Ï»ØÄꤷ¤¿¥¨¥ó¥³¡¼¥É¤Î¥Ð¥¤¥ÈÇÛÎó¤òÊÖ¤·¤Æ¤ë ÆüËܸì¥Õ¥¡¥¤¥ë̾¤ò¥À¥¦¥ó¥í¡¼¥É¤µ¤»¤ë¤Ë¤Ï¢­¤³¤¦¤¹¤ë¤È³µ¤Í¾å¼ê¤¯Æ°¤¯
¤Ê¤ó¤Ç"ISO-8859-1″¤Ë¤¹¤ë¤Èư¤¯¤Î¤«¤ÏÄ´¤Ù¤Æ¤Ê¤¤w
(resp¤ÏHttpServletResponse)
resp.setContentType("application/octet-stream");
resp.setHeader("Content-Disposition", "attachment; filename=" + new String(fname.getBytes("MS932"), "ISO-8859-1"));
ưºî³Îǧ¤ò¤·¤¿¥Ö¥é¥¦¥¶¡¼¤ÏIE6,Firefox 3.6.11,opera 10.63,safari for windows 4.0.5 SJIS¤Î¾ì¹ç
OK -> ie,firefox,safari
NG -> opera
UTF-8¤Î¾ì¹ç
OK -> ie,firefox
NG -> opera,safari
°ø¤ß¤Ë¢­¤³¤¦¤¤¤¦¤Î¤â»î¤·¤Æ¤ß¤¿¤±¤É ¥À¥á¤À¤Ã¤¿¡£
resp.setContentType("application/octet-stream");
resp.setHeader("Content-Disposition", "attachment; filename*="Shift_JIS''" + URLEncoder.encode(fname, "MS932") + '"');

2010ǯ6·î30Æü(¿åÍËÆü)

¥Æ¡¼¥Ö¥ë¾ðÊó¤¤¤í¤¤¤í

¥«¥Æ¥´¥ê¡¼: - watanabe @ 20»þ07ʬ03ÉÃ
PostgreSQL¤Ç¥¤¥ó¥Ç¥Ã¥¯¥¹¤È¤«¥×¥é¥¤¥Þ¥ê¥­¡¼¤È¤«³°Éô¥­¡¼À©Ìó¤È¤«¥æ¥Ë¡¼¥¯À©Ìó¤Î³ÎǧÊýË¡ * ¥¤¥ó¥Ç¥Ã¥¯¥¹¤Î³ÎǧÊýË¡ Á´¥Æ¡¼¥Ö¥ë¤Î°ìÍ÷
psql# \di
¥Æ¡¼¥Ö¥ë¤ò»ØÄꤷ¤Æ°ìÍ÷
psql# \di ¥Æ¡¼¥Ö¥ë̾
* À©Ìó¤Î³Îǧ table_constraints¤ò»È¤¦ ¥×¥é¥¤¥Þ¥ê¥­¡¼
psql=# select constraint_name,table_name,constraint_type from information_schema.table_constraints 
psql-# where constraint_schema = 'public' and constraint_type = 'PRIMARY KEY';
³°Éô¥­¡¼À©Ìó
psql=# select constraint_name,table_name,constraint_type from information_schema.table_constraints 
psql-# where constraint_schema = 'public' and constraint_type = 'FOREIGN KEY';

2010ǯ4·î16Æü(¶âÍËÆü)

clamav¤Î¥Ó¥ë¥É¤Ç¥¨¥é¡¼

¥«¥Æ¥´¥ê¡¼: - watanabe @ 13»þ23ʬ52ÉÃ
clamav¤Î¥¢¥Ã¥×¥Ç¡¼¥È¤·¤è¤¦¤È¤·¤¿¤éÅܤé¤ì¤¿¡£
% sudo portupgrade security/clamav
** Makefile possibly broken: security/clamav:
  "Makefile", line 112: Could not find bsd.port.options.mk
  make: fatal errors encountered -- cannot continue
** Listing the failed packages (*:skipped / !:failed)
  ! security/clamav (clamav-0.94.1)   (Makefile broken)
--->  Packages processed: 0 done, 0 ignored, 0 skipped and 1 failed
¤¢¤ì¡©¤È»×¤Ã¤Æ ³Îǧ¤·¤Æ¤â bsd.port.options.mk ¤Ï¤¢¤ë
% ls /usr/ports/Mk/bsd.port.options.mk
º¤¤Ã¤¿»þ¤Î¥°¡¼¥°¥ëÀèÀ¸ Re: Could not find bsd.port.options.mk /usr/share/mk ³Îǧ¤·¤Æ¤â bsd.port.options.mk¤¬¤Ê¤¤¡£¡£¡£ ¤ó¤¸¤ã¥³¥Ô¡¼¤·¤è¤¦
% sudo cp /usr/ports/Mk/bsd.port.options.mk /usr/share/mk
ľ¤Ã¤¿¡£

2010ǯ1·î19Æü(²ÐÍËÆü)

sqlite¤¬¥í¥Ã¥¯¤µ¤ì¤¿

¥«¥Æ¥´¥ê¡¼: - watanabe @ 21»þ57ʬ17ÉÃ
SQL error: database is locked¤¬½Ð¤¿ ¤°¤°¤Ã¤¿¤±¤É ÂнèË¡¤¬¤ï¤«¤é¤ó¡£
* sqlite¤Î¥í¥Ã¥¯¤ÏFcntl¤ò»È¤Ã¤Æ¤¤¤ë * (¤¿¤Ö¤ó)¥í¥Ã¥¯¤ò¤«¤±¤¿¿Í¤¸¤ã¤Ê¤¤¤È¥í¥Ã¥¯¤ò³«Êü¤Ç¤­¤Ê¤¤ * (¤¿¤Ö¤ó)¥í¥Ã¥¯¤ò¤«¤±¤¿¿Í°Ê³°¤Çsqlite¤Î¥Õ¥¡¥¤¥ë¤Ë¥¢¥¯¥»¥¹¤¹¤ë¤Èdatabase is locked¤¬¤Ç¤ë colinux¤Îdebian¤Ç¥Æ¥¹¥È¤·¤Æ¤ß¤¿¡£
% sudo -u www-data perl -MDBI -le '$c = DBI->connect("dbi:SQLite:dbname=SQLite.db"); $c->begin_work; $s = $c->prepare("insert into MailQueue(sendTo,subject,body) values(?, ?, ?)"); $s->execute(q{watanabe@toshiki.net}, q{¥Æ¥¹¥È}, q{Á´³Ñ¤Î¥Æ¥¹¥È¡Á}); sleep 10; $c->commit;'
# Ctrl-C ¤Ç¥¹¥È¥Ã¥×
%
% sqlite3 SQLite.db
SQLite version 3.5.9
Enter ".help" for instructions
sqlite> select * from MailQueue;
SQL error: database is locked #¢« ¥í¥Ã¥¯¤µ¤ì¤Þ¤·¤¿
sqlite> .q
¥í¥Ã¥¯¤µ¤ì¤ë¤Þ¤Ç¡£ www-data¤Ïapache¤Î¥æ¡¼¥¶ INSERTʸ¤òÁö¤é¤»¤Æ¤ª¤¤¤ÆÅÓÃæ¤Ç¥×¥í¥°¥é¥à¤òÄä»ß¤µ¤»¤ë¤È¥í¥Ã¥¯¾õÂ֤ˤʤë
% sudo -u www-data perl -MDBI -le '$c = DBI->connect("dbi:SQLite:dbname=SQLite.db"); $c->begin_work; $c->rollback;'
#¢¬¤È¤ê¤¢¤¨¤º¥í¡¼¥ë¥Ð¥Ã¥¯¤·¤Æ¤ß¤ë
% sqlite3 SQLite.db
SQLite version 3.5.9
Enter ".help" for instructions
sqlite> select * from MailQueue;
SQL error: database is locked #¢« ¥À¥á
sqlite> .q
ñ½ã¤Ë¥È¥é¥ó¥¶¥ó¥¯¥·¥ç¥ó¤òÄ¥¤Ã¤Æ¥í¡¼¥ë¥Ð¥Ã¥¯¤Ç¤Ï¥À¥á¤À¤Ã¤¿
% sudo -u www-data perl -MDBI -le '$c = DBI->connect("dbi:SQLite:dbname=SQLite.db"); $c->begin_work; $s = $c->prepare("insert into MailQueue(sendTo,subject,body) values(?, ?, ?)"); $s->execute(q{watanabe@toshiki.net}, q{¥Æ¥¹¥È}, q{Á´³Ñ¤Î¥Æ¥¹¥È¡Á}); $c->rollback;'
#¢¬INSERT¤òÁö¤é¤»¤Æ¤«¤é¥í¡¼¥ë¥Ð¥Ã¥¯¤·¤Æ¤ß¤ë
% sqlite3 SQLite.db
SQLite version 3.5.9
Enter ".help" for instructions
sqlite> select * from MailQueue;
#¢¬ ¤ªk
sqlite> .q
%
INSERTʸ¤òÁö¤é¤»¤Æ¤ª¤¤¤Æ¥í¡¼¥ë¥Ð¥Ã¥¯¤¹¤ë¤È¥í¥Ã¥¯¤¬³«Êü¤µ¤ì¤ë¡£ ¤Ã¤Æ¤³¤È¤Ï ¥í¥Ã¥¯Ãæ¤Î¥ª¥Ö¥¸¥§¥¯¥È¤ò¥í¥Ã¥¯¢ª¥¢¥ó¥í¥Ã¥¯¤·¤Ê¤¤¤Èdatabase is locked¤Ïľ¤é¤Ê¤¤¡©¡©¡©

2010ǯ1·î6Æü(¿åÍËÆü)

putty¤Ç°µ½Ì¤¬Í­¸ú¤Ë¤Ê¤é¤Ê¤¤

¥«¥Æ¥´¥ê¡¼: - watanabe @ 19»þ42ʬ52ÉÃ
ºÇ¶á¤Îsshd(openssh)¤Î¥Ç¥Õ¥©¥ë¥ÈÀßÄê¤Ç¤Ï¢­¤³¤¦¤Ê¤Ã¤Æ¤¤¤ë sshd_config
Compression delayed
¤³¤Îdelayed¤¬¤Ê¤Ë¤«¤È¤¤¤¦¤È SSHD_CONFIG (5)¤Ë¤è¤ë¤È
Compression (°µ½Ì)
    °µ½Ì¤òµö²Ä¤¹¤ë¤«¤É¤¦¤«¡¢¤¢¤ë¤¤¤ÏÃٱ䰵½Ì (¤½¤Î¥æ¡¼¥¶¤¬Ç§¾Ú¤µ¤ì¤Æ¤«¤é½é¤á¤Æ°µ½Ì¤òµö²Ä¤¹¤ë) ¤ò¤ª¤³¤Ê¤¦¤«¤É¤¦¤«¤ò»ØÄꤷ¤Þ¤¹¡£¤³¤Î°ú¿ô¤¬¤È¤ê¤¦¤ëÃͤÏ"yes ,""delayed"¤Þ¤¿¤Ï"no"¤Ç¤¹¡£¥Ç¥Õ¥©¥ë¥È¤Ç¤Ï"delayed (¥æ¡¼¥¶¤¬Ç§¾Ú¤µ¤ì¤Æ¤«¤é°µ½Ì¤òµö²Ä¤¹¤ë)"¤Ë¤Ê¤Ã¤Æ¤¤¤Þ¤¹¡£
¤ÇPuTTY wish zlib-openssh ¤ò¤ß¤ë¤È¤É¤¦¤âÂбþ¤·¤Æ¤Ê¤¤¤é¤·¤¤¡£ ¼Â¸³¤·¤Æ¤ß¤¿ * Compression delayed
>plink -v -load scp watanabe@remote_host pwd
Looking up host "remote_host"
Connecting to remote_host port 22
Server version: SSH-2.0-OpenSSH_5.1p1 FreeBSD-20080901
We claim version: SSH-2.0-PuTTY_Release_0.60_JP_Y_2007_05_10
Using SSH protocol version 2
Doing Diffie-Hellman group exchange
Doing Diffie-Hellman key exchange with hash SHA-256
Host key fingerprint is:
ssh-dss 1024 e8:9f:05:86:ca:e6:09:ae:b8:b7:7a:99:fb:1e:f0:90
Initialised Arcfour-256 client->server encryption
Initialised HMAC-SHA1 client->server MAC algorithm
Initialised Arcfour-256 server->client encryption
Initialised HMAC-SHA1 server->client MAC algorithm
Pageant is running. Requesting keys.
Pageant has 1 SSH-2 keys
Using username "watanabe".
Trying Pageant key #0
Authenticating with public key "dsa-key-20030802" from agent
Sending Pageant's response
Access granted
Opened channel for session
Started a shell/command
/home/watanabe
Server sent command exit status 0
Disconnected: All channels closed
* Compression yes
>plink -v -load scp watanabe@remote_host pwd
Looking up host "remote_host"
Connecting to remote_host port 22
Server version: SSH-2.0-OpenSSH_5.1p1 FreeBSD-20080901
We claim version: SSH-2.0-PuTTY_Release_0.60_JP_Y_2007_05_10
Using SSH protocol version 2
Doing Diffie-Hellman group exchange
Doing Diffie-Hellman key exchange with hash SHA-256
Host key fingerprint is:
ssh-dss 1024 e8:9f:05:86:ca:e6:09:ae:b8:b7:7a:99:fb:1e:f0:90
Initialised Arcfour-256 client->server encryption
Initialised HMAC-SHA1 client->server MAC algorithm
Initialised zlib (RFC1950) compression
Initialised Arcfour-256 server->client encryption
Initialised HMAC-SHA1 server->client MAC algorithm
Initialised zlib (RFC1950) decompression
Pageant is running. Requesting keys.
Pageant has 1 SSH-2 keys
Using username "watanabe".
Trying Pageant key #0
Authenticating with public key "dsa-key-20030802" from agent
Sending Pageant's response
Access granted
Opened channel for session
Started a shell/command
/home/watanabe
Server sent command exit status 0
Disconnected: All channels closed

34 queries. 0.041 sec.
Powered by WordPress Module based on WordPress ME & WordPress