User:yasuaki

Contributed document

[05 Oct 2008] create new guide for Deki 8.08 (Kilen Woods), and SAMP guide also updated to applicable to the latest Deki.

• Upgrading Jay Cooke (8.05/8.05.x) to Kilen Woods (8.08) for SPARC Solaris 10

[01 Aug 2008] update new Guide for 8.05.2b (Jay Cooke)

• Upgrading Jay Cooke 8.05/8.05.x to 8.05.2b for SPARC Solaris 10

[20 Jun 2008] create new guide for 8.0.5.1 (Jay Cooke) This is outdated, and replaced by above one

• Upgrading Jay Cooke 8.05 to 8.05.1 for SPARC Solaris 10

[18 May 2008] create new guide for Deki Wiki 8.05 (Jay Cooke)

• SPARC Solaris 10 (Deki Wiki 8.05 (Jay Cooke))
• SAMP (Solaris10,Apache2,MySQL5,PHP5) with Mono setup-guide for Deki Wiki

[29 Mar 2008] create new guide for Deki Wiki 1.9.0b (Itasca) with Sun SPARC Solaris 8

• Sun SPARC Solaris 8 (Itasca)

[02 Mar 2008] created new guide for Deki Wiki 1.8x (Hayes) with Sun SPARC Solaris 8

• Sun SPARC Solaris 8 (Hayes)

My plan for Deki

• End of October
  • Update "Killen Woods (8.08) for SPARC Solaris" guide to Deki 8.08.1a (if released)
  • Verification of Mono-2.0 on Solaris 10 for reliability scpect
• Someday
  • Summarize Mono-1.2.6 (and/or Mono-2.0) installation steps to Solaris 10
  • Update SAMP guide (Solaris 10) to comply to Solaris 10 8/07
  • Try to rewrite SAMP guide (Solaris 10) using http://cooltools.sunsource.net/ instead of "Solaris Companion" as freeware package
  • Create Oracle extension (Perl or PHP, not C#) like MySql extension
  • Bring Japanese page up to date

My Favorite

• Setup VM
  
  • change root password
  • set the local timezone using /usr/sbin/tzconfig
    set the system time using /bin/date -u MMDDhhmmYY
  • move "localhost" to the end of 127.0.0.1 in /etc/hosts to aviod Apache warning
  • How do I...Enable the new control panel?
  • How do I...Enable SSH?
  • don't forget commenting "checkdeki" out /etc/crontab
    
  • How do I..Setup_svc_at_behind_proxy
    (add following to /root/.subversion/servers)
    http-proxy-exceptions = *.example.com
    http-proxy-host = proxy.example.com
    http-proxy-port = 8080
  • How do I...Setup_a_apt-get_at_behind_proxy
    (add following to /etc/apt/apt.conf.d/70debconf)
    Acquire
    {
      http
      {
         Proxy "http://proxy.example.com:8080";
      };
      ftp
      {
         Proxy "http://proxy.example.com:8080";
      };
    };
  • Install some utilities
    
    apt-get install ftp
    apt-get install less
     
  • How do I...Setup a Deki VM with latest SVN code?
    
    To install mono-1.2.2.1 as a substitute for 1.9.x.
    apt-get update
    apt-get remove mono-common
    apt-get install mono
    apt-get install mono-gmcs
     

  • How do I...Access Deki Wiki through windows Explorer?

  • Install development tools for PHP
    
    apt-get install php-pear
    apt-get install php5-dev
    apt-get install libcurl3
    apt-get install libcurl3-openssl-dev
    
    # Extended HTTP Support (you may need environment variable for proxy as "# http_proxy=proxy.example.com:8080 pecl install pecl_http")
    pecl install pecl_http
    
    # You should add "extension=http.so" to php.ini
    vi /etc/php5/apache2/php.ini
    vi /etc/php5/cli/php.ini
     
  • Install Oracle Database Instant Client
    references
    - http://www.oracle.com/technology/tec...n-kubuntu.html
    - http://www.oestby.com/doc/php5_oci8.php
    
    Download "Oracle Database Instant Client ver. 10.2.0.4" of ZIP archive for Linux x86 platform from Oracle Technology Network.
    
    Oracle Database Instant Client
    - http://www.oracle.com/technology/tec...ent/index.html
    - http://download.oracle.com/docs/cd/B...int.htm#423364
    
    *Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OCI applications
    oracle-instantclient-basic-10.2.0.4-1.i386.zip
    
    *Instant Client Package - SQL*Plus: Additional libraries and executable for running SQL*Plus with Instant Client
    oracle-instantclient-sqlplus-10.2.0.4-1.i386.zip
    
    *Instant Client Package - SDK: Additional header files and an example makefile for developing Oracle applications with Instant Client
    oracle-instantclient-devel-10.2.0.4-1.i386.zip
    
    Installing "Oracle Database Instant Client"
    cd /
    unzip oracle-instantclient-basic-10.2.0.4-1.i386.zip
    Archive:  oracle-instantclient-basic-10.2.0.4-1.i386.zip
      inflating: instantclient_10_2/BASIC_README
      inflating: instantclient_10_2/classes12.jar
      inflating: instantclient_10_2/genezi
      inflating: instantclient_10_2/libclntsh.so.10.1
      inflating: instantclient_10_2/libnnz10.so
      inflating: instantclient_10_2/libocci.so.10.1
      inflating: instantclient_10_2/libociei.so
      inflating: instantclient_10_2/libocijdbc10.so
      inflating: instantclient_10_2/ojdbc14.jar
    
    unzip oracle-instantclient-devel-10.2.0.4-1.i386.zip
    Archive:  oracle-instantclient-devel-10.2.0.4-1.i386.zip
       creating: instantclient_10_2/sdk/
       creating: instantclient_10_2/sdk/include/
      inflating: instantclient_10_2/sdk/include/occi.h
      inflating: instantclient_10_2/sdk/include/occiCommon.h
      inflating: instantclient_10_2/sdk/include/occiControl.h
      inflating: instantclient_10_2/sdk/include/occiData.h
      inflating: instantclient_10_2/sdk/include/occiObjects.h
      inflating: instantclient_10_2/sdk/include/occiAQ.h
      inflating: instantclient_10_2/sdk/include/oci.h
      inflating: instantclient_10_2/sdk/include/oci1.h
      inflating: instantclient_10_2/sdk/include/oci8dp.h
      inflating: instantclient_10_2/sdk/include/ociap.h
      inflating: instantclient_10_2/sdk/include/ociapr.h
      inflating: instantclient_10_2/sdk/include/ocidef.h
      inflating: instantclient_10_2/sdk/include/ocidem.h
      inflating: instantclient_10_2/sdk/include/ocidfn.h
      inflating: instantclient_10_2/sdk/include/ociextp.h
      inflating: instantclient_10_2/sdk/include/ocikpr.h
      inflating: instantclient_10_2/sdk/include/ocixmldb.h
      inflating: instantclient_10_2/sdk/include/odci.h
      inflating: instantclient_10_2/sdk/include/oratypes.h
      inflating: instantclient_10_2/sdk/include/ori.h
      inflating: instantclient_10_2/sdk/include/orid.h
      inflating: instantclient_10_2/sdk/include/orl.h
      inflating: instantclient_10_2/sdk/include/oro.h
      inflating: instantclient_10_2/sdk/include/ort.h
      inflating: instantclient_10_2/sdk/include/xa.h
      inflating: instantclient_10_2/sdk/include/nzt.h
      inflating: instantclient_10_2/sdk/include/nzerror.h
       creating: instantclient_10_2/sdk/demo/
      inflating: instantclient_10_2/sdk/demo/demo.mk
      inflating: instantclient_10_2/sdk/demo/cdemo81.c
      inflating: instantclient_10_2/sdk/demo/occidemo.sql
      inflating: instantclient_10_2/sdk/demo/occidemod.sql
      inflating: instantclient_10_2/sdk/demo/occidml.cpp
      inflating: instantclient_10_2/sdk/demo/occiobj.cpp
      inflating: instantclient_10_2/sdk/demo/occiobj.typ
      inflating: instantclient_10_2/sdk/SDK_README
     extracting: instantclient_10_2/sdk/ottclasses.zip
      inflating: instantclient_10_2/sdk/ott
    
    unzip oracle-instantclient-sqlplus-10.2.0.4-1.i386.zip
    Archive:  oracle-instantclient-sqlplus-10.2.0.4-1.i386.zip
      inflating: instantclient_10_2/SQLPLUS_README
      inflating: instantclient_10_2/glogin.sql
      inflating: instantclient_10_2/libsqlplus.so
      inflating: instantclient_10_2/libsqlplusic.so
      inflating: instantclient_10_2/sqlplus
    
    ln -s instantclient_10_2/ instantclient
    export LD_LIBRARY_PATH=/instantclient
    export NLS_LANG=japanese_japan.utf8
    
    cd /instantclient/
    ln -s libclntsh.so.10.1 libclntsh.so
    
    Verify a connectivity to your Oracle database server via Oracle Net TCP/IP.
    /instantclient/sqlplus scott/tiger@//oracle_server:1521/service_name
    
     
  • Install Oracle OCI8 driver, MDB2 for PHP
    - http://pear.php.net/package/MDB2
    
    cd /
    pecl install oci8
    
    Please provide the path to the ORACLE_HOME directory if requested to proceed installation. Use 'instantclient,/path/to/instant/client/lib' if you're compiling with Oracle Instant Client [autodetect] : instantclient,/instantclient
    
    ls -la /usr/lib/php5/20060613+lfs/oci8.so
    -rwxr-xr-x 1 root root 393668 2008-11-16 09:49 /usr/lib/php5/20060613+lfs/oci8.so
    
    You should add "extension=oci8.so" to php.ini
    
    vi /etc/php5/apache2/php.ini
    vi /etc/php5/cli/php.ini
    
    pear install MDB2
    pear install MDB2#mysql
    pear install MDB2#oci8
    
    Testing access to Oracle database using MDB2
    cat /tmp/mdb2.php
    <?php
    // Create a valid MDB2 object named $mdb2
    // at the beginning of your program...
    require_once 'MDB2.php';
    
    $mdb2 =& MDB2::connect('oci8://scott:tiger@oracle_server/?se...=service_name');
    if (PEAR::isError($mdb2)) {
        die($mdb2->getMessage());
    }
    
    // Proceed with a query...
    $res =& $mdb2->query('SELECT * FROM emp');
    
    // Get each row of data on each iteration until
    // there are no more rows
    while (($row = $res->fetchRow(MDB2_FETCHMODE_ORDERED))) {
        echo $row[0] . "\t" . $row[1] . "\n";
    }
    
    // Always check that result is not an error
    if (PEAR::isError($res)) {
        die($res->getMessage());
    }
    
    // Disconnect
    $mdb2->disconnect();
    ?>
    
    Run a sample case (you may specify environment variables for national language support as : NLS_LANG=JAPANESE_JAPAN.JA16EUC php /tmp/mdb2.php)
    php /tmp/mdb2.php
    7369    SMITH
    (snip)
    
    
  • Preset Oracle releated environment variables to Apache server
    vi /etc/apache2/envvars
    (add there)
    export LD_LIBRARY_PATH=/instantclient:${LD_LIBRARY_PATH}
    export NLS_LANG=japanese_japan.utf8
    
     
• Writing a bug report
  • How do I...File bug reports about Deki Wiki?
• Deki FAQ
• Deki Specs
• DekiScript and Extensions
  • Writing Extensions with DekiScript
  • Create extension in other programming languages? 
  • DekiScript Remote Function Calls
  • FAQ
• Ldap authenticaiton
  
  • LDAP Authentication
  • Trusted Authentication
  • How do I...Enable single sign on with Active Directory?
  • How do I...Integrate my users with LDAP/MS Active Directory?
• Prince (PDF export)
  • How do I...Install Prince for PDF Export?
• Multi-Tenant
  • Multi-tenant_update-db.php 
• Source Code
• Mono
• Japanese resources
  • Consideration for Japanese attachment indexing (by RickCogley)
  • Enabling Support for Japanese PDF, DOC and XLS Indexing for Deki Wiki (by RickCogley)
  • Japanese Translation(RickCogley, Stanaka, and Mio)

Memorandum on the Forum

• feasibility of Deki Wiki on Solaris
  http://forums.opengarden.org/showthread.php?t=2359

        

Older document

Comleted Task

• Working : Install Deki 8.08 to Solaris 10 machine
  -> 8.08 RC1 worked great without PDF export
  -> Deki 8.08 RC1 and RC2 did not work on Solaris 10 box, license "INVALID" error occured. I don't understand what happend ...
  -> [04/Sep/08] Lisence issue described above was resolvd by r10431. (Thank you Max, Steve, and Pete)
  -> [05/Sep/08] There are another problem was found on my Solaris 10 box, "Edit" "New" "Print" buttons are disabled for Admin user (at least), so that I can't edit/modify Deki :(
  -> [09/Sep/08] this issue was filed to bug-db : http://bugs.developer.mindtouch.com/view.php?id=5030
  -> [13/Sep/08] I believe this issue originates out of Mono by reason that I added to bug db.
  -> [15/Sep/08] I addressed parameter passing bug for Mono runtime on SPARC Solaris 10. I will report it to Mono-project.
  -> [15/Sep/08] Mono-runtime issue filed : https://bugzilla.novell.com/show_bug.cgi?id=426264
  -> [21/Sep/08] I update Mono issue report, and "Found in Version" was changed from 1.9 to 2.0.
  -> [23/Sep/08] A patch was released from the Mono community. So I'll ensure whether this is effective.
  -> [23/Sep/08] I verified Mono's bug was fixed, and Deki seems to be work well. I want to update "Deki 8.08 guides for Solaris 10" aiming at 1st week of Oct.
  -> [28/Sep/08] Another problem found; "Register User" page was blank page. WHY ?
  -> [28/Sep/08] Deki 8.08 (Kilen Woods) on Solaris known problem created
  -> [05/Oct/08] Submit guide to the forum on MindTouch Development Center
• Update SAMP guide to Deki 8.08
  • Apache for new-cp
    -> new-cp is complete, except directory listings on "/new-cp" create a new page. This should be the same as VM.
    -> done
  • Prince
    -> does not work on my Solaris box
    -> Resolved by the latest Prince XML
• Update Deki Solaris guide (8.05x to 8.08)
  -> [08/Sep/08] uploaded under the my page : Upgrading Jay Cooke (8.05/8.05.x) to Kilen Woods (8.08) for SPARC Solaris 10
  -> Done