NOTICE†

penguin factory がフリーでの公開をやめてしまいました・・
好きだったのに・・ 

pre install†

yum install postgresql
yum install postgresql-devel
yum install postgresql-server
yum install xpm-devel

install†

penguinoffice2.0.1
tar を解凍するとカレントディレクトリに解凍されるので注意
# mkdir penguin
# cp penguinxxx.tgz penguin
# cd penguin 
# tar xzfp penguinxxx.tgz

apache†

php†

mb_string がうまく動かなかったりするのでソースから入れる。

PHP

php.ini†

emacs /usr/local/lib/php.ini

     engine = On
    short_open_tag = On
    precision =  14
    y2k_compliance = Off
    output_buffering = Off
    output_handler =
    unserialize_callback_func=
    zlib.output_compression = Off
    implicit_flush = Off
    allow_call_time_pass_reference = On
    safe_mode = Off
    safe_mode_gid = Off
    disable_functions =
    highlight.string  = #CC0000
    highlight.comment = #FF9900
    highlight.keyword = #006600
    highlight.bg      = #FFFFFF
    highlight.default = #0000CC
    highlight.html    = #000000
    expose_php = On
    max_execution_time = 60
    memory_limit = 8M
    error_reporting  =  E_ALL & ~E_NOTICE
    display_errors = On
    display_startup_errors = Off
    log_errors = Off
    track_errors = Off
    warn_plus_overloading = Off
    variables_order = "EGPCS"
    register_globals = On
    register_argc_argv = On
    post_max_size = 200M
    gpc_order = "GPC"
    magic_quotes_gpc = On
    magic_quotes_runtime = Off
    magic_quotes_sybase = Off
    auto_prepend_file =
    auto_append_file =
    default_mimetype = "text/html"
    doc_root =
    user_dir =
    extension_dir = /usr/lib/php4
    enable_dl = On
    file_uploads = On
    upload_max_filesize = 210M
    allow_url_fopen = On
    extension=pgsql.so
    debugger.enabled = False
    debugger.profiler_enabled = True
    debugger.JIT_enabled = True
    debugger.JIT_port = 7869
    debugger.JIT_host = clienthost
    debugger.JIT_level = 3
    define_syslog_variables  = Off
    SMTP = localhost
    sendmail_from = me@localhost.com
    sendmail_path = /usr/sbin/sendmail -t -i
    sql.safe_mode = Off
    pgsql.allow_persistent = On
    pgsql.auto_reset_persistent = Off
    pgsql.max_persistent = -1
    pgsql.max_links = -1
    session.save_handler = files
    session.save_path = /tmp
    session.use_cookies = 1
    session.name = PHPSESSID
    session.auto_start = 0
    session.cookie_lifetime = 0
    session.cookie_path = /
    session.cookie_domain =
    session.serialize_handler = php
    session.gc_probability = 1
    session.gc_maxlifetime = 1440
    session.referer_check =
    session.entropy_length = 0
    session.entropy_file =
    session.cache_limiter = nocache
    session.cache_expire = 180
    session.use_trans_sid = 1
    url_rewriter.tags = "a=href,area=href,frame=src,input=src,form=fakeentry"
    sockets.use_system_read = On
    mbstring.internal_encoding = EUC-JP
    mbstring.http_input = auto
    mbstring.http_output = SJIS
    mbstring.detect_order = auto
    mbstring.substitute_character = none;
    mbstring.script.encoding = auto;

/etc/rc.d/init.d/postgresql start

DB initialize†

# su -s /bin/bash - postgres
$ createdb -E EUC-JP penguinoffice
$ psql penguinoffice
penguinoffice=# \i penguinoffice.db

config†

• html/config.inc.php

  $basedir 
  $server
  $port
  $user
  $pg_passwd
  $db
  $toppath

サーバ移植†

1. 旧サーバ

   pg_dump 【DBNAME】 > 【DBNAME】.dump

2. 新サーバ

   createdb -E EUC-JP 【DBNAME】
   psql -d 【DBNAME】 -f 【DBNAME】.dump

バグ対策とか†

メール送信の checked がウザいので消した。
行き先案内版がじゃまなので消した index.phtml

outlook†

basp21 で連携