:thoughts => nil

Display part initial and Full list when mouse over

2009-01-02T21:54:00.008+09:00

If you mouse over the image:

To make port install org.macports.mysql5.plist in your /Library/LaunchDaemons

2008-09-10T15:53:00.001+09:00

To make port install org.macports.mysql5.plist in your /Library/LaunchDaemons

sudo port install mysql5 +server

Instead of

sudo port install mysql5

Install PostgreSQL 8.3.3 on Joyent OpenSolaris

2008-08-13T16:18:00.003+09:00

[gmg6p9aa:~/postgresql-8.3.3] root# ./configure --with-libraries=/opt/csw/lib:/opt/csw/libexec --with-includes=/opt/csw/include
    checking build system type... i386-pc-solaris2.11
    ......
    checking for syslog.h... yes
    checking for optreset... no
    checking for strtoll... yes
    checking for strtoull... yes
    checking for atexit... yes
    checking for LARGEFILESOURCE value needed for large files... no
    checking for fseeko... (cached) yes
    checking test program... failed
    configure: error:
    Could not execute a simple test program.  This may be a problem
    related to locating shared libraries.  Check the file 'config.log'
    for the exact reason.

http://www.pgcluster.org/svn/pgcluster-1.5/doc/FAQ_Solaris

[gmg6p9aa:~/postgresql-8.3.3] root# export LDFLAGS="-R/opt/csw/lib/:/usr/lib/"
[gmg6p9aa:~/postgresql-8.3.3] root#./configure --with-libraries=/opt/csw/lib/:/usr/lib/ --with-includes=/opt/csw/include/:/usr/include/
checking build system type... i386-pc-solaris2.11
......
checking for onsgmls... no
checking for nsgmls... no
checking for openjade... no
checking for jade... no
checking for DocBook V4.2... no
checking for DocBook stylesheets... no
checking for collateindex.pl... no
checking for sgmlspl... no
configure: creating ./config.status
config.status: creating GNUmakefile
config.status: creating src/Makefile.global
config.status: creating src/include/pg_config.h
config.status: creating src/interfaces/ecpg/include/ecpg_config.h
config.status: src/interfaces/ecpg/include/ecpg_config.h is unchanged
config.status: linking ./src/backend/port/tas/dummy.s to src/backend/port/tas.s
config.status: linking ./src/backend/port/dynloader/solaris.c to src/backend/port/dynloader.c
config.status: linking ./src/backend/port/sysv_sema.c to src/backend/port/pg_sema.c
config.status: linking ./src/backend/port/sysv_shmem.c to src/backend/port/pg_shmem.c
config.status: linking ./src/backend/port/dynloader/solaris.h to src/include/dynloader.h
config.status: linking ./src/include/port/solaris.h to src/include/pg_config_os.h
config.status: linking ./src/makefiles/Makefile.solaris to src/Makefile.port


make 
make install

[gmg6p9aa:~/postgresql-8.3.3] root# mkdir /usr/local/pgsql/data (as root)
[gmg6p9aa:~/postgresql-8.3.3] root# sudo chown postgres:postgres /usr/local/pgsql/data/
[gmg6p9aa:~/postgresql-8.3.3] root# sudo su postgres -c "/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data"
[gmg6p9aa:~/postgresql-8.3.3] root# sudo su postgres -c "/usr/local/pgsql/bin/postgres -p 9999 -D /usr/local/pgsql/data"

git-svn: Can't locate SVN/Core.pm

2008-07-17T19:39:00.001+09:00

To import subversion repository to git, I get the following problem

git-svn clone http://dev.com/code/example/trunk example
Can't locate SVN/Core.pm in @INC (@INC contains: /usr/local/lib/perl5/site_perl /opt/local/lib/perl5/5.8.8/darwin-2level /opt/local/lib/perl5/5.8.8 /opt/local/lib/perl5/site_perl/5.8.8/darwin-2level /opt/local/lib/perl5/site_perl/5.8.8 /opt/local/lib/perl5/site_perl /opt/local/lib/perl5/vendor_perl/5.8.8/darwin-2level /opt/local/lib/perl5/vendor_perl/5.8.8 /opt/local/lib/perl5/vendor_perl .) at /usr/local/bin/git-svn line 29.

Installing of the perl subversion binding solved this problem.

Felix:~/Developments sunfmin$ sudo port install p5-svn-simple
--->  Fetching subversion-perlbindings
--->  Attempting to fetch subversion-1.4.6.tar.bz2 from http://subversion.tigris.org//downloads/
--->  Verifying checksum(s) for subversion-perlbindings
--->  Extracting subversion-perlbindings
--->  Configuring subversion-perlbindings
--->  Building subversion-perlbindings with target swig-pl
--->  Staging subversion-perlbindings into destroot
--->  Installing subversion-perlbindings 1.4.6_0
--->  Activating subversion-perlbindings 1.4.6_0
--->  Cleaning subversion-perlbindings
--->  Fetching p5-svn-simple
--->  Attempting to fetch SVN-Simple-0.27.tar.gz from http://cpan.perl.org/authors/id/C/CL/CLKAO/
--->  Verifying checksum(s) for p5-svn-simple
--->  Extracting p5-svn-simple
--->  Configuring p5-svn-simple
--->  Building p5-svn-simple with target all
--->  Staging p5-svn-simple into destroot
--->  Installing p5-svn-simple 0.27_0
--->  Activating p5-svn-simple 0.27_0
--->  Cleaning p5-svn-simple
Felix:~/Developments sunfmin$

Install ruby-pg (PostgreSQL ruby driver) On Leopard

2008-07-04T21:12:00.001+09:00

It is not so easy to install ruby-pg in Leopard

Felix:~ sunfmin$ sudo gem install ruby-pg
Building native extensions.  This could take a while...
ERROR:  Error installing pg:
    ERROR: Failed to build gem native extension.

/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/bin/ruby extconf.rb install pg

        ===========   WARNING   ===========

        You are building this extension on OS X without setting the 
        ARCHFLAGS environment variable, and PostgreSQL does not appear 
        to have been built as a universal binary. If you are seeing this 
        message, that means that the build will probably fail.

        Try setting the environment variable ARCHFLAGS 
        to '-arch i386' before building.

        For example:
        (in bash) $ export ARCHFLAGS='-arch i386'
        (in tcsh) % setenv ARCHFLAGS '-arch i386'

        Then try building again.

        ===================================
        checking for main() in -lpq... yes
checking for libpq-fe.h... yes
checking for libpq/libpq-fs.h... yes
checking for PQconnectionUsedPassword()... no
checking for PQisthreadsafe()... no
checking for PQprepare()... no
checking for PQexecParams()... no
checking for PQescapeString()... no
checking for PQescapeStringConn()... no
checking for lo_create()... no
checking for pg_encoding_to_char()... no
checking for PQsetClientEncoding()... no
creating Makefile

make
gcc -I. -I. -I/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/universal-darwin9.0 -I. -DHAVE_LIBPQ_FE_H -DHAVE_LIBPQ_LIBPQ_FS_H -I/opt/local/include/postgresql82  -fno-common -arch ppc -arch i386 -Os -pipe -fno-common  -c compat.c
In file included from compat.c:16:
compat.h:38:2: error: #error PostgreSQL client version too old, requires 7.3 or later.
In file included from compat.c:16:
compat.h:121: error: redefinition of typedef 'PQnoticeReceiver'
/opt/local/include/postgresql82/libpq-fe.h:136: error: previous declaration of 'PQnoticeReceiver' was here
compat.h:125: error: redeclaration of enumerator 'PQERRORS_TERSE'
/opt/local/include/postgresql82/libpq-fe.h:97: error: previous definition of 'PQERRORS_TERSE' was here
compat.h:126: error: redeclaration of enumerator 'PQERRORS_DEFAULT'
/opt/local/include/postgresql82/libpq-fe.h:98: error: previous definition of 'PQERRORS_DEFAULT' was here
compat.h:128: error: redeclaration of enumerator 'PQERRORS_VERBOSE'
/opt/local/include/postgresql82/libpq-fe.h:100: error: previous definition of 'PQERRORS_VERBOSE' was here
compat.h:128: error: conflicting types for 'PGVerbosity'
/opt/local/include/postgresql82/libpq-fe.h:100: error: previous declaration of 'PGVerbosity' was here
compat.h:132: error: redeclaration of enumerator 'PQTRANS_IDLE'
/opt/local/include/postgresql82/libpq-fe.h:88: error: previous definition of 'PQTRANS_IDLE' was here
compat.h:133: error: redeclaration of enumerator 'PQTRANS_ACTIVE'
/opt/local/include/postgresql82/libpq-fe.h:89: error: previous definition of 'PQTRANS_ACTIVE' was here
compat.h:134: error: redeclaration of enumerator 'PQTRANS_INTRANS'
/opt/local/include/postgresql82/libpq-fe.h:90: error: previous definition of 'PQTRANS_INTRANS' was here
compat.h:135: error: redeclaration of enumerator 'PQTRANS_INERROR'
/opt/local/include/postgresql82/libpq-fe.h:91: error: previous definition of 'PQTRANS_INERROR' was here
compat.h:137: error: redeclaration of enumerator 'PQTRANS_UNKNOWN'
/opt/local/include/postgresql82/libpq-fe.h:93: error: previous definition of 'PQTRANS_UNKNOWN' was here
compat.h:137: error: conflicting types for 'PGTransactionStatusType'
/opt/local/include/postgresql82/libpq-fe.h:93: error: previous declaration of 'PGTransactionStatusType' was here
compat.h:142: error: conflicting types for 'PQtransactionStatus'
/opt/local/include/postgresql82/libpq-fe.h:258: error: previous declaration of 'PQtransactionStatus' was here
compat.h:143: error: conflicting types for 'PQparameterStatus'
/opt/local/include/postgresql82/libpq-fe.h:260: error: previous declaration of 'PQparameterStatus' was here
compat.h:157: error: conflicting types for 'PQsetErrorVerbosity'
/opt/local/include/postgresql82/libpq-fe.h:277: error: previous declaration of 'PQsetErrorVerbosity' was here
compat.h:169:2: error: #error unsupported postgresql version, requires 7.3 or later.
compat.c: In function 'PQsetClientEncoding':
compat.c:21: error: syntax error before '{' token
compat.c:282: error: storage class specified for parameter 'query'
compat.c:282: error: parameter 'query' is initialized
compat.c:286: error: syntax error before 'if'
compat.c:341: error: parameter 'target' is initialized
compat.c:341: error: 'to' undeclared (first use in this function)
compat.c:341: error: (Each undeclared identifier is reported only once
compat.c:341: error: for each function it appears in.)
compat.c:342: error: parameter 'remaining' is initialized
compat.c:342: error: 'length' undeclared (first use in this function)
compat.c:344: error: syntax error before 'while'
compat.c:396: error: syntax error before 'len'
compat.c:470: error: redefinition of parameter 'i'
compat.c:390: error: previous definition of 'i' was here
compat.c:473: error: syntax error before 'if'
In file included from compat.c:16:
compat.h:38:2: error: #error PostgreSQL client version too old, requires 7.3 or later.
In file included from compat.c:16:
compat.h:121: error: redefinition of typedef 'PQnoticeReceiver'
/opt/local/include/postgresql82/libpq-fe.h:136: error: previous declaration of 'PQnoticeReceiver' was here
compat.h:125: error: redeclaration of enumerator 'PQERRORS_TERSE'
/opt/local/include/postgresql82/libpq-fe.h:97: error: previous definition of 'PQERRORS_TERSE' was here
compat.h:126: error: redeclaration of enumerator 'PQERRORS_DEFAULT'
/opt/local/include/postgresql82/libpq-fe.h:98: error: previous definition of 'PQERRORS_DEFAULT' was here
compat.h:128: error: redeclaration of enumerator 'PQERRORS_VERBOSE'
/opt/local/include/postgresql82/libpq-fe.h:100: error: previous definition of 'PQERRORS_VERBOSE' was here
compat.h:128: error: conflicting types for 'PGVerbosity'
/opt/local/include/postgresql82/libpq-fe.h:100: error: previous declaration of 'PGVerbosity' was here
compat.h:132: error: redeclaration of enumerator 'PQTRANS_IDLE'
/opt/local/include/postgresql82/libpq-fe.h:88: error: previous definition of 'PQTRANS_IDLE' was here
compat.h:133: error: redeclaration of enumerator 'PQTRANS_ACTIVE'
/opt/local/include/postgresql82/libpq-fe.h:89: error: previous definition of 'PQTRANS_ACTIVE' was here
compat.h:134: error: redeclaration of enumerator 'PQTRANS_INTRANS'
/opt/local/include/postgresql82/libpq-fe.h:90: error: previous definition of 'PQTRANS_INTRANS' was here
compat.h:135: error: redeclaration of enumerator 'PQTRANS_INERROR'
/opt/local/include/postgresql82/libpq-fe.h:91: error: previous definition of 'PQTRANS_INERROR' was here
compat.h:137: error: redeclaration of enumerator 'PQTRANS_UNKNOWN'
/opt/local/include/postgresql82/libpq-fe.h:93: error: previous definition of 'PQTRANS_UNKNOWN' was here
compat.h:137: error: conflicting types for 'PGTransactionStatusType'
/opt/local/include/postgresql82/libpq-fe.h:93: error: previous declaration of 'PGTransactionStatusType' was here
compat.h:142: error: conflicting types for 'PQtransactionStatus'
/opt/local/include/postgresql82/libpq-fe.h:258: error: previous declaration of 'PQtransactionStatus' was here
compat.h:143: error: conflicting types for 'PQparameterStatus'
/opt/local/include/postgresql82/libpq-fe.h:260: error: previous declaration of 'PQparameterStatus' was here
compat.h:157: error: conflicting types for 'PQsetErrorVerbosity'
/opt/local/include/postgresql82/libpq-fe.h:277: error: previous declaration of 'PQsetErrorVerbosity' was here
compat.h:169:2: error: #error unsupported postgresql version, requires 7.3 or later.
compat.c: In function 'PQsetClientEncoding':
compat.c:21: error: syntax error before '{' token
compat.c:282: error: storage class specified for parameter 'query'
compat.c:282: error: parameter 'query' is initialized
compat.c:286: error: syntax error before 'if'
compat.c:341: error: parameter 'target' is initialized
compat.c:341: error: 'to' undeclared (first use in this function)
compat.c:341: error: (Each undeclared identifier is reported only once
compat.c:341: error: for each function it appears in.)
compat.c:342: error: parameter 'remaining' is initialized
compat.c:342: error: 'length' undeclared (first use in this function)
compat.c:344: error: syntax error before 'while'
compat.c:396: error: syntax error before 'len'
compat.c:470: error: redefinition of parameter 'i'
compat.c:390: error: previous definition of 'i' was here
compat.c:473: error: syntax error before 'if'
lipo: can't open input file: /var/tmp//ccxi5qM7.out (No such file or directory)
make: *** [compat.o] Error 1


Gem files will remain installed in /Library/Ruby/Gems/1.8/gems/pg-0.7.9.2008.03.18 for inspection.
Results logged to /Library/Ruby/Gems/1.8/gems/pg-0.7.9.2008.03.18/ext/gem_make.out
Felix:~ sunfmin$ 



Felix:~ sunfmin$ sudo env ARCHFLAGS="-arch i386" gem install --remote ruby-pg
Building native extensions.  This could take a while...
Successfully installed ruby-pg-0.7.9.2008.01.28
1 gem installed
Installing ri documentation for ruby-pg-0.7.9.2008.01.28...
Installing RDoc documentation for ruby-pg-0.7.9.2008.01.28...
Felix:~ sunfmin$

Tell postfix not to send email to local

2008-06-20T18:09:00.002+09:00

We want to config the server can only send emails, can NOT receive emails from local or remote. Because our domain is pointed to this server, But our email server is on Google Enterprise. So before If we want to send email from the server, It first looks up locally, and send to local directly, So emails never get reach to Google.

I tried: http://www.postfix.org/faq.html#null_client But I seems not work.

After check out the postfix log:

Jun 20 08:45:15 example.com postfix/pickup[21505]: [ID 197553 mail.info] 9EE3D43D17: uid=0 from=<root>
Jun 20 08:45:15 example.com postfix/cleanup[21511]: [ID 197553 mail.info] 9EE3D43D17: message-id=<20080620084515.9EE3D43D17@example.com>
Jun 20 08:45:15 example.com postfix/qmgr[21506]: [ID 197553 mail.info] 9EE3D43D17: from=<root@example.com>, size=294, nrcpt=1 (queue active)
Jun 20 08:45:15 example.com postfix/error[21509]: [ID 197553 mail.info] 9EE3D43D17: to=<theplant@example.com>, relay=none, delay=0, status=bounced (User unknown in virtual alias table)
Jun 20 08:45:15 example.com postfix/cleanup[21511]: [ID 197553 mail.info] 9FC7E43D19: message-id=<20080620084515.9FC7E43D19@example.com>
Jun 20 08:45:15 example.com postfix/qmgr[21506]: [ID 197553 mail.info] 9FC7E43D19: from=<>, size=1973, nrcpt=1 (queue active)
Jun 20 08:45:15 example.com postfix/error[21509]: [ID 197553 mail.info] 9FC7E43D19: to=<root@example.com>, relay=none, delay=0, status=bounced (User unknown in virtual alias table)
Jun 20 08:45:15 example.com postfix/qmgr[21506]: [ID 197553 mail.info] 9FC7E43D19: removed
Jun 20 08:45:15 example.com postfix/qmgr[21506]: [ID 197553 mail.info] 9EE3D43D17: removed

Even you set

 local_transport = error:local delivery is disabled

But when you have aliasmaps, aliasdatabase, virtualaliasmaps. Postfix will still try to find the alias name in local. So it fails when it can not find it.

main.cf

myorigin = example.com
#relayhost = example.com
inet_interfaces = 127.0.0.1
#local_transport = error:local delivery is disabled
## -- Maps
#alias_maps = dbm:/opt/csw/etc/postfix/aliases
#alias_database = dbm:/opt/csw/etc/postfix/aliases
canonical_maps = dbm:/opt/csw/etc/postfix/canonical
recipient_canonical_maps = dbm:/opt/csw/etc/postfix/recipient_canonical
sender_canonical_maps = dbm:/opt/csw/etc/postfix/sender_canonical
#virtual_alias_maps = dbm:/opt/csw/etc/postfix/virtual

master.cf

discard   unix  -       -       n       -       -       discard
#local     unix  -       n       n       -       -       local
virtual   unix  -       n       n       -       -       virtual

And Another thing, make sure your hostname is NOT your domain. because It will check hostname first and mx record? I guess.

Install SSL for apache

2008-03-03T15:31:00.001+09:00

Setup Certificate

# from: http://www.vanemery.com/Linux/Apache/apache-SSL.html
[root]# openssl genrsa -des3 -out my-ca.key 2048
[root]# openssl req -new -x509 -days 3650 -key my-ca.key -out my-ca.crt

# deleted -des3 to not using pass phrase
[root]# openssl genrsa -out mars-server.key 1024
[root]# openssl req -new -key mars-server.key -out mars-server.csr
[root]# openssl x509 -req -in mars-server.csr -out mars-server.crt -sha1 -CA my-ca.crt -CAkey my-ca.key -CAcreateserial -days 3650

Setup Apache

# For no ssl
-bash-3.00$ more /opt/csw/apache2/etc/virtualhosts/yourserver.conf
<VirtualHost 8.17.170.154:80>
  ServerName youserver.com
  ServerAlias *.youserver.com
  DocumentRoot /home/youserver.com/app/current/public

  <Directory "/home/youserver.com/app/current/public/">
  Options FollowSymLinks
  AllowOverride None
  Order allow,deny
  Allow from all
  </Directory>

  <Proxy balancer://yourserver-mongrels>
    BalancerMember http://127.0.0.1:8000
    BalancerMember http://127.0.0.1:8001
    BalancerMember http://127.0.0.1:8002
    BalancerMember http://127.0.0.1:8003
  </Proxy>

  ProxyPass /images !
  ProxyPass /javascripts !
  ProxyPass /stylesheets !
  ProxyPass / balancer://yourserver-mongrels/
  ProxyPassReverse / balancer://yourserver-mongrels/
  ProxyPreserveHost On
</VirtualHost>

# For ssl
-bash-3.00$ more /opt/csw/apache2/etc/virtualhosts/yourserver-ssl.conf

<VirtualHost 8.17.170.154:443>
ServerName youserver.com
ServerAlias *.youserver.com
DocumentRoot /home/youserver.com/app/current/public

<Directory "/home/youserver.com/app/current/public/">
Options FollowSymLinks
AllowOverride None
Order allow,deny
Allow from all
</Directory>

<Proxy balancer://yourserver-mongrels>
  BalancerMember http://127.0.0.1:8000
  BalancerMember http://127.0.0.1:8001
  BalancerMember http://127.0.0.1:8002
  BalancerMember http://127.0.0.1:8003
</Proxy>

ProxyPass /images !
ProxyPass /javascripts !
ProxyPass /stylesheets !
ProxyPass / balancer://yourserver-mongrels/
ProxyPassReverse / balancer://yourserver-mongrels/
ProxyPreserveHost On

SSLEngine On
SSLCertificateFile /home/youserver.com/ssl/mars-server.crt
SSLCertificateKeyFile /home/youserver.com/ssl/mars-server.key
</VirtualHost>

Merb Console

2008-03-01T18:08:00.001+09:00

Tried Merb Console

felix@Felix:~/Developments/kakei$ merb -i
 ~ loading gem 'activerecord' from config/init.rb:27 ...
 ~ loading gem 'merb_activerecord' from config/init.rb:27 ...
 ~ loading gem 'merb_rspec' from config/init.rb:36 ...
 ~ loading gem 'merb_helpers' from config/init.rb:39 ...
 ~ Loaded DEVELOPMENT Environment...
 ~ Connecting to database...
 ~ Compiling routes...
 ~ Using 'share-nothing' cookie sessions (4kb limit per client)
irb(main):035:0*
irb(main):036:0* merb
=> #<Merb::Rack::Console:0xb76f6604>
irb(main):037:0>
irb(main):038:0*
irb(main):039:0* merb.url(:payments)
=> "/payments"
irb(main):040:0> merb.url(:new_payment)
=> "/payments/new"
irb(main):041:0> merb.url(:delete_payment)
=> "/payments//delete"
irb(main):042:0> merb.url(:delete_payment, )
SyntaxError: compile error
(irb):42: syntax error, unexpected ')'
    from (irb):42
    from :0
irb(main):043:0> payment = Payment.find(1)
=> #<Payment id: 1, amount: 23423, paid_for: "34234", created_at: "2008-03-01 17:26:41">
irb(main):044:0> merb.url(:delete_payment, payment)
=> "/payments/1/delete"
irb(main):045:0> merb.url(:edit_payment, payment)
=> "/payments/1/edit"
irb(main):046:0> merb.url(:as_payment, payment)
RuntimeError: Named route not found: as_payment
    from /usr/lib/ruby/gems/1.8/gems/merb-core-0.9.1/lib/merb-core/dispatch/router.rb:90:in `generate'
    from /usr/lib/ruby/gems/1.8/gems/merb-core-0.9.1/lib/merb-core/rack/adapter/irb.rb:14:in `url'
    from (irb):46
    from :0
irb(main):047:0> merb.url(:payment, payment)
=> "/payments/1"
irb(main):003:0* merb.show_routes
Named Routes
  new_payment: /payments/new
  edit_payment: /payments/:id/edit
  payment: /payments/:id
  delete_payment: /payments/:id/delete
  payments: /payments
  custom_payment: /payments/:action/:id
Anonymous Routes
  /payments/?(\.:format)?
  /payments/index(\.:format)?
  /payments/new
  /payments/?(\.:format)?
  /payments/:id(\.:format)?
  /payments/:id[;/]edit
  /payments/:id[;/]delete
  /payments/:id(\.:format)?
  /payments/:id(\.:format)?
  /:controller(/:action(/:id)?)?(\.:format)?
=> nil

Keep all my bash history commands

2008-02-02T12:40:00.001+09:00

I like the bash history. because many command is difficult to remember when I want to use it next time.

felix@Felix:~$ cd
felix@Felix:~$ echo "export HISTSIZE=999999999" >> .profile

and then you can find you command by

felix@Felix:~$ history|grep git

Use Ruby language power in command line

2008-01-06T20:04:00.001+09:00

Task: Delete file that didn't added to subversion

svn st|grep ?

Then you can get all the files that not added to subversion but the list is with a ?, so It's not easy to delete it with rm

felix@Felix:~/Developments/joblet$ svn st|grep ?
?      aaa
?      bbb
?      ccc

Then I want to trim the ?, awk may simple do the task, but for those who don't know awk. and instead we use Ruby for day to day work.

Ruby gives you the way to do task on command line.

 felix@Felix:~/Developments/joblet$ svn st|grep ?|ruby -pe '$_ = $_[1..-1].strip + "\n"'
 aaa
 bbb
 ccc

felix@Felix:~/Developments/joblet$ rm `svn st|grep ?|ruby -pe '$_ = $_[1..-1].strip + "\n"'`

Give a ticket number to your subversion commit message when you are using trac

2007-12-13T13:25:00.001+09:00

If you give a number when you commit your changes to subversion

    svn commit -m "Fixed Ticket #456"

then Trac will connect the changeset to the Ticket, Wonderful feature, isn't it.

Migrate PostgreSQL 8.1 Data to PostgreSQL 8.2

2007-12-07T16:34:00.001+09:00

Install PSQL 8.2

Felix:~ sunfmin$ sudo port install postgresql82

Dump all the PSQL 8.1 Databases to a file

Using The new installed PSQL 8.2 's pg_dumpall to dump all the PSQL 8.1 databases

Felix:~ sunfmin$ /opt/local/lib/postgresql82/bin/pg_dumpall > ~/pg81_all_dump

Initialize PSQL 8.2 Database instance

Felix:~/Developments sunfmin$ sudo su postgres -c '/opt/local/lib/postgresql82/bin/initdb -D /opt/local/var/db/postgresql82/defaultdb'
Password:
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale C.

creating directory /opt/local/var/db/postgresql82/defaultdb ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers/max_fsm_pages ... 32MB/204800
creating configuration files ... ok
creating template1 database in /opt/local/var/db/postgresql82/defaultdb/base/1 ... ok
initializing pg_authid ... ok
initializing dependencies ... ok
creating system views ... ok
loading system objects' descriptions ... ok
creating conversions ... ok
setting privileges on built-in objects ... ok
creating information schema ... ok
vacuuming database template1 ... ok
copying template1 to template0 ... ok
copying template1 to postgres ... ok

WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the -A option the
next time you run initdb.

Success. You can now start the database server using:

    /opt/local/lib/postgresql82/bin/postgres -D /opt/local/var/db/postgresql82/defaultdb
or
    /opt/local/lib/postgresql82/bin/pg_ctl -D /opt/local/var/db/postgresql82/defaultdb -l logfile start

Start your database

Felix:~/Developments sunfmin$ sudo su postgres -c "/opt/local/lib/postgresql82/bin/pg_ctl -D /opt/local/var/db/postgresql82/defaultdb -l /opt/local/var/log/postgresql82/postgres.log start"
server starting

You may encounter some problem like this following

Felix:~/Developments sunfmin$ sudo su postgres /opt/local/lib/postgresql82/bin/postgres -D /opt/local/var/db/postgresql82/defaultdb
Password:
/opt/local/lib/postgresql82/bin/postgres: /opt/local/lib/postgresql82/bin/postgres: cannot execute binary file

Felix:~/Developments sunfmin$ sudo  /opt/local/lib/postgresql82/bin/postgres -D /opt/local/var/db/postgresql82/defaultdb
"root" execution of the PostgreSQL server is not permitted.
The server must be started under an unprivileged user ID to prevent
possible system security compromise.  See the documentation for
more information on how to properly start the server.


Felix:~/Developments sunfmin$ psql
psql: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

Restore all the data

Felix:~ sunfmin$ /opt/local/lib/postgresql82/bin/psql -f pg81_all_dump template1 -U postgres
You are now connected to database "postgres".
SET
SET
SET
CREATE ROLE
ALTER ROLE
CREATE ROLE
ALTER ROLE
CREATE ROLE
ALTER ROLE
CREATE ROLE
ALTER ROLE
CREATE ROLE
ALTER ROLE
CREATE DATABASE

Failed system call was shmget

2007-12-07T15:34:00.001+09:00

When I try to setup PostgreSQL 8.2 on Mac OS X 10.4 , I get the following error.

Felix:~ sunfmin$ sudo su postgres -c '/opt/local/lib/postgresql82/bin/initdb -D /opt/local/var/db/postgresql82/defaultdb'
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale C.

creating directory /opt/local/var/db/postgresql82/defaultdb ... ok
creating subdirectories ... ok
selecting default max_connections ... 10
selecting default shared_buffers/max_fsm_pages ... 400kB/20000
creating configuration files ... ok
creating template1 database in /opt/local/var/db/postgresql82/defaultdb/base/1 ... FATAL:  could not create shared memory segment: Cannot allocate memory
DETAIL:  Failed system call was shmget(key=1, size=1646592, 03600).
HINT:  This error usually means that PostgreSQL's request for a shared memory segment exceeded available memory or swap space. To reduce the request size (currently 1646592 bytes), reduce PostgreSQL's shared_buffers parameter (currently 50) and/or its max_connections parameter (currently 10).
The PostgreSQL documentation contains more information about shared memory configuration.
child process exited with exit code 1
initdb: removing data directory "/opt/local/var/db/postgresql82/defaultdb"

Following http://brilliantcorners.org/node/tag/osx

I changed: /etc/rc

sysctl -w kern.sysv.shmmax=4194304 kern.sysv.shmmin=1 kern.sysv.shmmni=32 kern.sysv.shmseg=8 kern.sysv.shmall=1024

sysctl -w kern.sysv.shmmax=167772160 kern.sysv.shmmin=1 kern.sysv.shmmni=32 kern.sysv.shmseg=8 kern.sysv.shmall=65536

And Then the problem solved.

Felix:~/Developments sunfmin$ sudo su postgres -c '/opt/local/lib/postgresql82/bin/initdb -D /opt/local/var/db/postgresql82/defaultdb'
Password:
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale C.

creating directory /opt/local/var/db/postgresql82/defaultdb ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers/max_fsm_pages ... 32MB/204800
creating configuration files ... ok
creating template1 database in /opt/local/var/db/postgresql82/defaultdb/base/1 ... ok
initializing pg_authid ... ok
initializing dependencies ... ok
creating system views ... ok
loading system objects' descriptions ... ok
creating conversions ... ok
setting privileges on built-in objects ... ok
creating information schema ... ok
vacuuming database template1 ... ok
copying template1 to template0 ... ok
copying template1 to postgres ... ok

WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the -A option the
next time you run initdb.

Success. You can now start the database server using:

    /opt/local/lib/postgresql82/bin/postgres -D /opt/local/var/db/postgresql82/defaultdb
or
    /opt/local/lib/postgresql82/bin/pg_ctl -D /opt/local/var/db/postgresql82/defaultdb -l logfile start

Update itself with single command

2007-12-03T16:10:00.001+09:00

It is cool that like gem and MacPorts could update itself with just a single command.

sudo gem update --system
sudo port selfupdate

and also when you can not find software you want in port, don't forget to do a


sudo port -d sync

Write your blog in Markdown with Emacs and post it directly to Google Blogger

2007-12-01T20:50:00.001+09:00

For those who using Emacs, Markdown and Blogger

You write your blog entry in Emacs and with Markdown format Then you issue a M-x blogger-post command in emacs, It convert the markdown to html and post it to your Blogger blog.

How to Install

See An Emacs Client For Blogger to install g-client (You'd better check it out from repository)
See Emacs markdown-mode to install Emacs markdown-mode
Put the following script to your emacs load path

The code

(require 'gblogger)

(defvar markdown-blogger-new-entry-template
  "<entry xmlns='http://www.w3.org/2005/Atom'>
  <generator url=\"%s\">%s</generator>
  <author> <name>%s </name> </author>
  <title mode=\"escaped\" type=\"text/html\">%s </title>
  <content type='xhtml'>
    <div xmlns=\"http://www.w3.org/1999/xhtml\">
%s
    </div>
  </content>
</entry>"
  "Template for new Blogger entries.")

(defun blogger-post()
  (interactive)

  (markdown)
  (set-buffer (get-buffer "*markdown-output*"))

  (setq post-url "http://www\.blogger\.com/feeds/7841127/posts/default")
  (setq markdown-buffer (current-buffer))
  (setq markdown-content (buffer-string))

  (setq title (read-string "Title: "))

  (setq buffer (get-buffer-create "*markdown-blogger-post*"))

  (declare (special gblogger-auth-handle markdown-blogger-new-entry-template
                    gblogger-generator-name ))

  (g-auth-ensure-token gblogger-auth-handle)




  (set-buffer buffer)
  (erase-buffer)
  (insert (format markdown-blogger-new-entry-template
                  gblogger-generator-name gblogger-generator-name
                  "Felix Sun" title markdown-content))
  (switch-to-buffer buffer)
  (g-app-mode)

  (setq g-app-this-url post-url
        g-app-auth-handle gblogger-auth-handle
        g-app-publish-action 'g-app-post-entry)


  (g-app-publish)
)

Posted from emacs

2007-12-01T13:55:00.001+09:00

You can do that also

http://emacspeak.blogspot.com/2007/03/emacs-client-for-google-services.html

Add code formatter to your blog

2007-11-30T00:29:00.000+09:00

see: http://code.google.com/p/syntaxhighlighter/

You could format ruby like this.


describe RSpec do
  before(:each) do
    @rspec = RSpec.new
  end

  describe "at release 1.0.8" do
    before(:each) do
      @rspec.version = "1.0.8" 
    end

    it "should not support nested example groups" do
      @rspec.should_not support_nested_example_groups
    end
  end

  describe "at release 1.1.0" do
    before(:each) do
      @rspec.version = "1.1.0" 
    end

    it "should support nested example groups" do
      @rspec.should support_nested_example_groups
    end
  end
end

Integrate your website with joblet seamlessly

2007-11-29T00:55:00.001+09:00

For most of website that integrated joblet like asoboo. right now just link to http://asoboo.joblet.jp

But you may not want your user go out of your own domain. If you want to do so, You need to create a subdomain for you website, because things like http://asoboo.com/jobs simple not very easy to work. (all inside url of joblet is begain with / )

So For Apache, create a virtual host

ServerName jobs.asoboo.com

<Directory proxy:http://asoboo.joblet.jp>
    Order Allow,Deny
    Allow from all
</Directory>

ProxyPass / http://asoboo.joblet.jp/
ProxyPassReverse  / http://asoboo.joblet.jp/

And Then you can point your browser to http://jobs.asoboo.com, :)

Different ps command in Solaris

2007-10-27T13:50:00.001+09:00

What I am interresting is:

why /usr/ucb/ps command is having out put differnet than

/usr/bin/ps

I CAN'T run /usr/bin/ps axuwwww

but I can under /usr/ucb/ps

Or /usr/ucb/ps -ef does not work, but

/usr/bin/ps -ef does work.

Put 503 page for your rails application

2007-10-24T15:02:00.001+09:00

Put

ErrorDocument 503 /503.html

in apache configuration for you rails application, because when you
deploy , mongrels may take some time to restart.

Fwd: warning: already initialized constant OPTIONS

2007-10-22T20:27:00.001+09:00

Something required can not be loaded in your environment file, or in plugins

=> Booting Mongrel (use 'script/server webrick' to force WEBrick)
=> Rails application starting on http://0.0.0.0:3000
=> Call with -d to detach
=> Ctrl-C to shutdown server
** Starting Mongrel listening at 0.0.0.0:3000
** Starting Rails with development environment...
Exiting
/usr/lib/ruby/gems/1.8/gems/rails-1.2.4/lib/commands/servers/mongrel.rb:15:
warning: already initialized constant OPTIONS
/usr/lib/ruby/gems/1.8/gems/rails-1.2.4/lib/commands/servers/mongrel.rb:18:
undefined method `options' for []:Array (NoMethodError)
from /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:32:in
`gem_original_require'
from /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:32:in
`require'
from /usr/lib/ruby/gems/1.8/gems/activesupport-1.4.3/lib/active_support/dependencies.rb:495:in
`require'
from /usr/lib/ruby/gems/1.8/gems/activesupport-
1.4.3/lib/active_support/dependencies.rb:342:in `new_constants_in'
from /usr/lib/ruby/gems/1.8/gems/activesupport-1.4.3/lib/active_support/dependencies.rb:495:in
`require'
from /usr/lib/ruby/gems/1.8/gems/rails- 1.2.4/lib/commands/server.rb:39
from /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:27:in
`gem_original_require'
from /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:27:in
`require'
from ./script/server:3

Merge a branch r123:569 to trunk subversion

2007-10-22T20:15:00.001+09:00

svn log --stop-on-copy http://svnserver/code/some_project/branches/release_12

to find out when the branch created, you know that at 942 revision, you created the branch

svn merge http://svnserver/code/some_project/branches/release_12 -r942:HEAD .

Run single test passed, but run all tests as a whole will fail that test

2007-10-21T12:23:00.001+09:00

In my situation

I didn't load required fixture on that failed test when run all tests as a whole
when I run that special single test, because you already run all tests before,
and in some tests It loaded the fixture that you special test needed, and didn't clear
test database when you only run that special test. So It pass.

Read Gmane mailing list with Emacs

2007-10-11T20:11:00.001+09:00

C-u M-x gnus # Start gnus and prompt for server

news.gmane.org # The Gmane nntp server

A A # List all groups

C-s scheme.chicken <RET> <RET> # Find the chicken Scheme list

from: http://dharmatech.onigirihouse.com/emacs-gnus-gmane

Using copy to combine binary file

2007-10-06T01:03:00.001+09:00

copy /B somefile.zip.aa+somefile.zip.ab somefile.zip

Outbound Port25 Blocking

2007-09-28T20:08:00.001+09:00

sudo postconf -e relayhost=mail.qb3.so-net.ne.jp

FInd slow actions in a Rails app

2007-09-20T18:29:00.001+09:00

# Show a list of actions sorted by time taken. Useful for finding slow actions.
cat log/development.log | awk '/Completed/ { print "[" $3 "] - " $0 }'
| sort -nr

from: http://snippets.dzone.com/posts/show/4440

Don't override to_json like this

2007-09-13T13:20:00.001+09:00

I don't know why our project override this method
class String
def to_json
"'#{self}'"
end
end

Because of this , The RJS totally don't work
and You get "unterminated string literal" because of not escaped javascript.

Show all files in the Finder

2007-09-12T12:45:00.001+09:00

Show all files in the Finder

Open Terminal, type this command, and press Enter:

defaults write com.apple.Finder AppleShowAllFiles YES

Ways to run ruby tests

2007-09-09T18:47:00.001+09:00

1. rake
2. rake -T test
3. ruby test/unit/product_test.rb
4. ruby test/unit/product_test.rb -v
5. ruby test/unit/product_test.rb -n /create/ -v
6. rake test:units TESTOPTS="-v -n/create/"

Possibility with scoped_proxy

2007-09-09T11:38:00.001+09:00

class User < ActiveRecord::Base
scoped_proxy :admins, :find => { :conditions => ['role = ?', 'super_user'] }
scoped_proxy :has_login do |login|
{ :find => { :conditions => ['login = ?', login] } }
end
scoped_proxy :no_op do
nil
end
end

# This gives you the first administrator of the system
User.admins.find(:first)
# This counts the administrators
User.admins.count

# All users with a given login
User.has_login('foo').count
User.has_login('foo').find(:all, :order => 'created_at desc')

# And finally, I give you the no op
User.no_op.find(:all) # => User.find(:all)

psql: FATAL: IDENT authentication failed for user

2007-09-06T22:43:00.001+09:00

Everytime I log in using normal user, I got this message:

$ psql -U gateadmin template1
psql: FATAL: IDENT authentication failed for user "gateadmin"

Why?

It looks like you would rather use password authentication than the
default IDENT-based auth (it's default in Debian distro of postgres
anyway). IDENT will only let you in when you do *not* use -U, ie,
your postgres user name is the same as your Unix user name. Change
this in pg_hba.conf, and don't forget to SIGHUP or restart the
postmaster afterwards.

regards, tom lane

Solution:

Just modify pg_hba.conf like this (change to trust)

local all trust
host all 127.0.0.1 255.255.255.255 trust

Unit test with transaction in rails

2007-07-31T10:37:00.001+09:00

uses_transaction :test_something_with_transaction
def test_something_with_transaction
...
end

missing key: categories: Cannot read the portsdb!

2007-07-24T17:53:00.001+09:00

[asoboo@turbine-02 /usr/local/sites/asoboo.com/current]$ sudo
portupgrade -a
[Updating the portsdb <format:bdb_btree> in /usr/ports ... - 17433
port entries found
.........1000.........2000.........3000.........4000.........5000.........6000.........7000.........8000.........9000.........10000.........11000.........12000.........13000.........14000.........15000.........16000.........17000....
..... done]
[missing key: categories] [Updating the portsdb <format:bdb_btree> in
/usr/ports ... - 17433 port entries found
.........1000.........2000.........3000.........4000.........5000.........6000.........7000.........8000.........9000.........10000.........11000.........12000.........13000.........14000.........15000.........16000.........17000....
..... done]
missing key: categories: Cannot read the portsdb!
/usr/local/lib/ruby/site_ruby/1.8/portsdb.rb:567:in `open_db':
database file error (PortsDB::DBError)
from /usr/local/lib/ruby/site_ruby/1.8/portsdb.rb:736:in `port'
from /usr/local/lib/ruby/site_ruby/1.8/portsdb.rb:924:in
`all_depends_list'
from /usr/local/lib/ruby/site_ruby/1.8/pkgdb.rb:915:in `tsort_build'
from /usr/local/lib/ruby/site_ruby/1.8/pkgdb.rb:907:in `each'
from /usr/local/lib/ruby/site_ruby/1.8/pkgdb.rb:907:in `tsort_build'
from /usr/local/lib/ruby/site_ruby/1.8/pkgdb.rb:929:in `sort_build'
from /usr/local/lib/ruby/site_ruby/1.8/pkgdb.rb:933:in `sort_build!'
from /usr/local/sbin/portupgrade:694:in `main'
from /usr/local/lib/ruby/1.8/optparse.rb:755:in `initialize'
from /usr/local/sbin/portupgrade:210:in `new'
from /usr/local/sbin/portupgrade:210:in `main'
from /usr/local/sbin/portupgrade:1981

portupgrade moved from /usr/ports/sysutils/portupgrade to
/usr/ports/ports-mgmt/portupgrade, one way to fix this is:

cd /usr/ports/ports-mgmt/portupgrade
make clean all install

Or I think portupgrade -f portupgrade might do.

spawn-fcgi.c.211: child exited with: 127, Unknown error: 127

2007-07-23T16:01:00.001+09:00

# ./script/process/spawner fcgi -e staging -p 7000 -i 5
=> Starting FCGI dispatchers
Checking if something is already running on 0.0.0.0:7000...NO
Starting dispatcher on port: 0.0.0.0:7000
exec: /usr/local/sites/somesite/releases/20070723060143/public/dispatch.fcgi:
not found
spawn-fcgi.c.211: child exited with: 127, Unknown error: 127

fixed by changing dispatch.fcgi

#!/opt/local/bin/ruby

#!/usr/local/bin/ruby

/tmp/502/nl.uu.phil.SSHAgent.socket (Errno::ENOENT)

2007-07-23T15:44:00.001+09:00

ssh login when Capistrano deployment failed with that message. Running
(on Mac OS):

$ ssh-agent bash
$ ssh-add
and then running cap tasks fixed the problem for now.

undefined method 'gem' for main:Object

2007-07-23T13:39:00.001+09:00

gem update --system

Kill all processes with full command name and args

2007-07-22T15:44:00.001+09:00

sunfmin@sunfmin-laptop:~$ pgrep -f "ssh -L 8080:google.com:80 sunfmin@localhost"
sunfmin@sunfmin-laptop:~$ pkill -f "ssh -L 8080:google.com:80 sunfmin@localhost"

link folder to external repository [ svn propedit svn:externals vendor ]

2007-07-12T19:03:00.001+09:00

export SVN_EDITOR="mate -w"
svn propedit svn:externals vendor

and input like the following to the popped editor

rails http://dev.rubyonrails.org/svn/rails/tags/rel_1-2-3
radiant http://dev.radiantcms.org/svn/radiant/tags/rel_0-6-2/radiant/

this would make the folder like this.
vendor
|--rails
|--radiant

The ownership of a file may only be altered by a super-user

2007-07-12T10:55:00.001+09:00

chown -R www:www sandbox/
chown: sandbox//conf/authz: Operation not permitted
chown: sandbox//conf/passwd: Operation not permitted
chown: sandbox//conf/svnserve.conf: Operation not permitted
chown: sandbox//conf: Operation not permitted
chown: sandbox//dav/activities.dir: Operation not permitted
chown: sandbox//dav/activities.pag: Operation not permitted

->

sudo chown -R www:www sandbox/

The ownership of a file may only be altered by a super-user for obvious
security reasons.

Let BitTorrent works on Ubuntu with Azureus Client.

2007-07-09T23:53:00.001+09:00

1. Set Local ASDL Router to allow NAT
Access 192.168.0.1 or something
2. Let Ubuntu to allow the port Azureus uses.
#iptables -I INPUT -p tcp --dport 57656 -j ACCEPT
#iptables -I INPUT -p udp --dport 57656 -j ACCEPT

Rails Development On Ubuntu

2007-07-07T17:40:00.001+09:00

h1. Installation

Switch to root user

h2. Install Ruby, Rails

apt-get install ruby rdoc irb libyaml-ruby libzlib-ruby ri
apt-get install rubygems
gem update --system
gem install rails -y

h2. Install Mongrel, MySQL

apt-get install mysql-server-5.0

apt-get install build-essential
apt-get install ruby1.8-dev
gem install mongrel
gem install mysql

h2. Install emacs(snapshot 22.0), ruby-mode, emacs-rails

gem install emacs-snapshot
cd $HOME/.emacs.d/
svn co http://svn.ruby-lang.org/repos/ruby/trunk/misc/ ruby
svn co svn://rubyforge.org/var/svn/emacs-rails/trunk rails

Add this code in $HOME/.emacs

(setq load-path (cons "~/.emacs.d/ruby" load-path))
(setq load-path (cons "~/.emacs.d/rails" load-path))
(require 'rails)

h2. Resources

Install Rails On Ubuntu
Rails On Emacs

Fix [ruby: no such file to load -- ubygems (LoadError)] in E-TextEditor

2007-06-11T11:35:00.001+09:00

Go to the cygwin bash prompt. If you don't know how to get there, use Start -> Run -> c:\cygwin\cygwin.bat.

Type:
echo unset RUBYOPT >> .bashrc

Type:
. .bashrc

Type:
irb

If you see:
irb(main):001:0>

Input Japanese with WATIR

2007-04-27T20:49:00.001+09:00

One more tip. You better use
   $ie.text_field(:name,'txtPcode').value = 'KANJI'
instead of 
   $ie.text_field(:name,'txtPcode').set('KANJI') 

TextField#set method fails on japanese characters.

Debug with Eclipse and Tomcat

2007-04-17T15:17:00.001+09:00

Add the following line to startup.bat

set CATALINA_OPTS=-server -Xdebug -Xnoagent -Djava.compiler=NONE -Xrunjdwp:transport=dt_socket,server=y,suspend=n,address=5005

Eclipse

Add <Remote Java Application>

Host:localhost, Port 5005

You have Office, You have Tools to Edit Database through ODBC - MSQRY32.EXE

2007-03-23T17:45:00.001+09:00

C:\Program Files\Microsoft Office\OFFICE11\MSQRY32.EXE

メニュー

レコード　−＞　編集の許可

Archive My Directory for Mediamax - Less than 10M per file ;-)

2007-03-02T14:02:00.001+09:00

winrar_path = "C:/sunfmin/Programs/WinRAR"
rar_root_path = "C:/sunfmin/Install/Books"
#Mb
split_size = 8 #Mb

#============================================

require 'find'

split_size_byte = split_size * 1024 * 1024
Find.find(rar_root_path) do |f|

    if File.file?(f) and File.size(f) > split_size_byte
        dirname = File.dirname(f)
        Dir.chdir(dirname)
        file_name = File.basename(f)

        rar_file_name = file_name[0, file_name.rindex('.')] + ".rar"

        winrar_exe = winrar_path + "/Rar.exe a -o+ -v#{split_size}m \"#{rar_file_name}\" \"#{file_name}\""
        puts "=========================================================="
        IO.popen(winrar_exe) do |out|
            puts "OOOOO======>>> #{rar_file_name}"
            puts out.readlines
        end

end
end

CSE＋PostgreSQL問題

2007-02-20T18:34:00.001+09:00

現象１：

DBエラー詳細：
FATAL: datamase ""test"" does not exist

回答１：

下記のURLで公開されている「日本語Windows版 libpq」入れなおしたところ
http://www.interwiz.koganei.tokyo.jp/software/PostgreSQL/libpq-6.5jp.zip

現象２：

fe_sendauth: authentication type 5 not supported

回答２：

install_dir\data\pg_hba.confを開いて

# IPv4 local connections:
host all all 127.0.0.1/32 md5

↓

# IPv4 local connections:
host all all 127.0.0.1/32 trust

移動またはコピーしようとしている数式またはシートには、移動またはコピー先のワークシートに既にある名前'●●●'が含まれています。この名前を使用しますか？……

2007-02-13T15:15:00.001+09:00

上記のような現象であるとしても、定義された名前が存在してこそ。

元となるブックで定義があるのではないかと推測します。覚えがなくても。まずは下記は確認されましたか？＞名前定義の確認は元のブックの全てのシートで使用状況も含めて行ってください。不都合の起こるほうのブックを調べても解決にはなりません。　確認のためにコピー（移動)元のブックで下記のプロシージャを実行してみるのも良いかもしれません。（アクティブなブックが対象になります) 　 Sub NameListPrint() Dim i As Long Dim Sh As Worksheet Set Sh = Worksheets.Add With ActiveWorkbook For i = 1 To .Names.Count Sh.Cells(i, 1).Value = .Names(i).Name Sh.Cells(i, 2).Value = "'" & .Names(i).RefersTo Next i End With End Sub 　名前定義があれば挿入されたシートに定義状況が列記されます。あとは、下記で一気に名前定義を削除。（これもアクティブなブックが対象) 　 Sub NamesDelete() Dim i As Long With ActiveWorkbook For i = .Names.Count To 1 Step -1 .Names(i).Delete Next i End With End Sub 　マクロを使う以外では、「問題となる名前が名前定義ダイアログボックスでも発見できないときは挿入＞名前＞定義　で一度名前を（適当でよいので）定義してみて、それを削除するとエラーが出なくなる」という情報もあったけど、現象そのものが再現ができないので未確認。

Install languages (Chinese, Japanese, Korean) on Fedora 6

2007-02-11T22:28:00.001+09:00

After you install finished, remeber to restart.

For Fedora Core 4, 5 and 6, the packages are fonts-Japanese, fonts-Chinese, and fonts-Korean. The command to enable these fonts is

yum install fonts-japanese fonts-chinese fonts-korean

Change my ip config between office and home

2007-01-04T20:57:00.001+09:00

Execute an bat is more convenient than open Internet Protocol(TCP/IP) Properties dialog to change ip config again and again.

SetOfficeIP.bat

netsh interface ip set address name="Local Area Connection" source=static addr= 172.16.96.158 mask=255.255.255.0
netsh interface ip set address name="Local Area Connection" gateway= 172.16.96.254 gwmetric=0
netsh interface ip set dns name="Local Area Connection" source=static addr= 172.16.8.3 register=PRIMARY
netsh interface ip add dns name="Local Area Connection" addr= 172.16.8.13 index=2
netsh interface ip set wins name="Local Area Connection" source=static addr=none

SetHomeIP.bat

netsh interface ip set address name="Local Area Connection" source=dhcp
netsh interface ip set dns name="Local Area Connection" source=dhcp register=PRIMARY
netsh interface ip set wins name="Local Area Connection" source=dhcp