Added by Niels van Kampenhout, last edited by Bartosz Oudekerk on May 28, 2008  (view change)

Labels:

hippo hippo Delete
repository repository Delete
slide slide Delete
mysql mysql Delete
backend backend Delete
binary binary Delete
Enter labels to add to this page:
Wait Image 
Looking for a label? Just start typing.
  1. Download and install Hippo Repository (see Getting Started Tracks).
  2. Install MySQL 4.1 (if you have not done so already).
  3. Create a database, e.g. 'slide': 
    create database slide;
  4. Create a user, e.g. 'slide_user' (replace 'password' with a better one): 
    grant all privileges on slide.* to slide_user@'localhost' identified by 'password';
  5. Create the slide tables inside the database you just created, using the MySQL41_Schema.sql script. 
    mysql -u slide_user -p slide < server/src/config/slide/MySql41Schema.sql
_
  6. Inside the hippo-repository folder, open config/slide/definition.xml. Remove or comment out the default store ("default-tx") and enable the example SQL store which is commented out ("test-sql"). Make sure you edit the URI of the mysql database, and the username and password to reflect your situation. 
    <?xml version="1.0"?>
<definition>
  <!--
  <store name="default-tx">
    <nodestore classname="nl.hippo.slide.store.impl.ContextTxXMLFileDescriptorsStore">
      <parameter name="rootpath">slide/metadata</parameter>
      <parameter name="workpath">slide/metadata</parameter>
    </nodestore>
    <securitystore>
      <reference store="nodestore"/>
    </securitystore>
    <lockstore>
      <reference store="nodestore"/>
    </lockstore>
    <revisiondescriptorsstore>
      <reference store="nodestore"/>
    </revisiondescriptorsstore>
    <revisiondescriptorstore>
      <reference store="nodestore"/>
    </revisiondescriptorstore>
    <contentstore classname="nl.hippo.slide.store.impl.ContextTxFileContentStore">
      <parameter name="rootpath">slide/content</parameter>
      <parameter name="workpath">slide/content</parameter>
    </contentstore>
  </store>
  <scope match="/" store="default-tx"/>
  -->

  <store name="test-sql">
    <parameter name="tlock-timeout">120</parameter>
    <parameter name="cache-mode">full</parameter>
    <parameter name="object-cache-size">1000</parameter>
    <parameter name="permission-cache-size">1000</parameter>
    <parameter name="lock-cache-size">100</parameter>
    <parameter name="descriptors-cache-size">10000</parameter>
    <parameter name="descriptor-cache-size">10000</parameter>
    <parameter name="content-cache-size">10000</parameter>
    <parameter name="enable-content-caching">false</parameter>
    <parameter name="tx-content-cache-size">1000</parameter>
    <parameter name="content-cache-bytes">10000000</parameter>
    <parameter name="tx-content-cache-bytes">1000000</parameter>
    <parameter name="max-content-bytes-per-entry">50000</parameter>
    <nodestore classname="org.apache.slide.store.impl.rdbms.JDBCStore">
      <parameter name="adapter">org.apache.slide.store.impl.rdbms.MySql41RDBMSAdapter</parameter>
      <parameter name="driver">com.mysql.jdbc.Driver</parameter>
      <parameter name="url">jdbc:mysql://localhost/slide</parameter>
      <parameter name="user">slide_user</parameter>
      <parameter name="password">password</parameter>
      <parameter name="dbcpPooling">true</parameter>
      <parameter name="dbcp.testWhileIdle">true</parameter>
      <parameter name="dbcp.timeBetweenEvictionRunsMillis">900000</parameter>
      <parameter name="dbcp.validationQuery">SELECT 1 FROM DUAL</parameter>
      <parameter name="dbcp.maxActive">20</parameter>
      <parameter name="isolation">READ_COMMITTED</parameter>
      <parameter name="compress">false</parameter>
      <parameter name="use-rdbms-expression-factory">true</parameter>
      <parameter name="tlock-timeout">120</parameter>
    </nodestore>
    <contentstore>
      <reference store="nodestore" />
      <parameter name="tlock-timeout">120</parameter>
    </contentstore>
    <securitystore>
      <reference store="nodestore" />
    </securitystore>
    <lockstore>
      <reference store="nodestore" />
    </lockstore>
    <revisiondescriptorsstore>
      <reference store="nodestore" />
    </revisiondescriptorsstore>
    <revisiondescriptorstore>
      <reference store="nodestore" />
    </revisiondescriptorstore>
  </store>
  <scope match="/" store="test-sql"/>

</definition>
  7. Inside the hippo-repository folder, open config/slide/data.xml. Find the property element with name attribute 'password'. This is the default password, change it into something difficult.
  8. Run hippo repository, and open http://localhost:60000/default/ with a browser. Login with username 'root' and the password you just entered. You should see a directory listing.
  9. Before you can use the repository with Hippo CMS, you need to intialize it with the repository intitialization tool. See Initializing the Hippo Repository for instructions.