Setup questions...

[John Nikolai <jn...@azika.com>]

Hi all,

I'm having some trouble getting slide up and running and need some help. I 
have setup slide using tomcat 3.2 on a linux box and can copy files into a 
directory using Internet Explorer 5 and the file -> open -> as Web Folder 
option. I also verified that the files are copied onto the server properly. 
Unfortunately when I shut down tomcat, restart it, and try to connect using 
IE5, the files directory is their but the files I copied over are not. I 
double checked and the files are still on the server in the proper 
directory. Why can't I see the files?

Seems the directory structure is stored in memory as well as the file 
objects. Once tomcat is shutdown all this information is lost. Does the 
FileContentStore class run through the rootpath during the initialization 
process and recreate the in memory directory structure and file objects? Is 
the JDBCContentStore the only sollution to this problem? Or am I missing 
something?

Thanks for your help,
   John

Re: Setup questions...MySQL

[Jason Harrop <jh...@bigpond.net.au>]

Remy Maucherat wrote:


> 
> Note : If someone could contribute SQL scripts for the database creation on
> DBs other than hSQL, I would appreciate it. Thanks !
> 

MySQL:

#drop database myDB;
create database myDB;
use myDB;
create table objects(uri blob not null, primary key uriIndex (uri(255)), 
classname blob);
create table children(uri blob, childuri blob);
create table links(link blob, linkto blob);
create table permissions(object blob, subject blob, action blob, 
inheritable int, negative int);
create table locks(id blob, object blob, subject blob, type blob, 
expirationdate varchar(15), inheritable int, xexclusive int);
create table revisions(uri blob not null, primary key uriIndex 
(uri(255)), isversioned int, initialrevision varchar(10) );
create table workingrevision(uri blob, baserevision varchar(20), xnumber 
varchar(20) );
create table latestrevisions(uri blob, branchname blob, xnumber 
varchar(20) );
create table branches(uri blob, xnumber varchar(20), childnumber 
varchar(20) );
create table revision(uri blob, xnumber varchar(20), branchname blob );
create table label(uri blob, xnumber varchar(20), label blob );
create table property(uri blob, xnumber varchar(20), name blob, value 
blob, namespace blob, type varchar(100), protected int );

Re: Setup questions...

[Remy Maucherat <re...@apache.org>]

> Thank you for the tip Remy, it worked like a champ... sort of. The files
> are now persisted after a restart of Tomcat, but there are some permission
> problems which still need to be resolved. I have seen several postings
> regarding questions about how to setup permissions with slide but nothing
> exists on the web site or in the slide documentation that explains the
> process in detail. That is, setting up permissions in the Domain.xml file
> as well as the web.xml and any tomcat configuration files. I don't know
the
> process myself but will have to look into it in order to get things
working
> properly. Basic question is... how to setup security given the following
tools:
>
>   - tomcat 3.2 and 4.0
>   - slide
>   - hsql

I feel like a broken record here ;-)

You need to :
- configure authentication in the web application
- add the appropriate users in the Tomcat realm, matching the users in the
Slide namespace
- then edit the ACLs (right now, there's only the manager servlet - and the
interface is terrible - but soon you'll be able to do that through the
WebDAV client using DAV ACL)

> The last question is, it looks like hsql is no longer being worked on. Are
> there any plans to convert to a different database (postgres, mysql, or
> oracle)?

The store should run reasonably well with Oracle and mySQL, but you'll have
to create the tables yourself (the types supported by each database can vary
a lot).

Note : If someone could contribute SQL scripts for the database creation on
DBs other than hSQL, I would appreciate it. Thanks !

Remy

Re: Setup questions...

[John Nikolai <jn...@azika.com>]

Thank you for the tip Remy, it worked like a champ... sort of. The files 
are now persisted after a restart of Tomcat, but there are some permission 
problems which still need to be resolved. I have seen several postings 
regarding questions about how to setup permissions with slide but nothing 
exists on the web site or in the slide documentation that explains the 
process in detail. That is, setting up permissions in the Domain.xml file 
as well as the web.xml and any tomcat configuration files. I don't know the 
process myself but will have to look into it in order to get things working 
properly. Basic question is... how to setup security given the following tools:

  - tomcat 3.2 and 4.0
  - slide
  - hsql

The last question is, it looks like hsql is no longer being worked on. Are 
there any plans to convert to a different database (postgres, mysql, or 
oracle)?

Thanks again for your help,
   - John

At 04:01 PM 3/2/2001 -0800, you wrote:
> > Hi all,
> >
> > I'm having some trouble getting slide up and running and need some help. I
> > have setup slide using tomcat 3.2 on a linux box and can copy files into a
> > directory using Internet Explorer 5 and the file -> open -> as Web Folder
> > option. I also verified that the files are copied onto the server
>properly.
> > Unfortunately when I shut down tomcat, restart it, and try to connect
>using
> > IE5, the files directory is their but the files I copied over are not. I
> > double checked and the files are still on the server in the proper
> > directory. Why can't I see the files?
> >
> > Seems the directory structure is stored in memory as well as the file
> > objects. Once tomcat is shutdown all this information is lost. Does the
> > FileContentStore class run through the rootpath during the initialization
> > process and recreate the in memory directory structure and file objects?
>Is
> > the JDBCContentStore the only sollution to this problem? Or am I missing
> > something?
>
>What is stored in memory in the default configuration is the namespace
>structure, file metadata, ACLs, locks ... Everything but the binary content
>of the resources, actually.
>You should uncomment that part in the config file to use it (with hSQL) :
>
>         <!--nodestore classname="slidestore.reference.JDBCDescriptorsStore">
>          <parameter name="driver">org.hsql.jdbcDriver</parameter>
>          <parameter name="url">HypersonicSQL:slide</parameter>
>          <parameter name="user">sa</parameter>
>          <parameter name="password"></parameter>
>         </nodestore>
>         <securitystore>
>           <reference store="nodestore" />
>         </securitystore>
>         <lockstore>
>           <reference store="nodestore" />
>         </lockstore>
>         <revisiondescriptorsstore>
>           <reference store="nodestore" />
>         </revisiondescriptorsstore>
>         <revisiondescriptorstore>
>           <reference store="nodestore" />
>         </revisiondescriptorstore-->
>
>Since configuring a database can be tricky, it's not enabled by default.
>
>There is work being done on an all filesystem store, which will eventually
>replace the memory store (which is still very useful for doing some quick
>testing).
>
>Remy

Re: Setup questions...

[Remy Maucherat <re...@apache.org>]

> Hi all,
>
> I'm having some trouble getting slide up and running and need some help. I
> have setup slide using tomcat 3.2 on a linux box and can copy files into a
> directory using Internet Explorer 5 and the file -> open -> as Web Folder
> option. I also verified that the files are copied onto the server
properly.
> Unfortunately when I shut down tomcat, restart it, and try to connect
using
> IE5, the files directory is their but the files I copied over are not. I
> double checked and the files are still on the server in the proper
> directory. Why can't I see the files?
>
> Seems the directory structure is stored in memory as well as the file
> objects. Once tomcat is shutdown all this information is lost. Does the
> FileContentStore class run through the rootpath during the initialization
> process and recreate the in memory directory structure and file objects?
Is
> the JDBCContentStore the only sollution to this problem? Or am I missing
> something?

What is stored in memory in the default configuration is the namespace
structure, file metadata, ACLs, locks ... Everything but the binary content
of the resources, actually.
You should uncomment that part in the config file to use it (with hSQL) :

        <!--nodestore classname="slidestore.reference.JDBCDescriptorsStore">
         <parameter name="driver">org.hsql.jdbcDriver</parameter>
         <parameter name="url">HypersonicSQL:slide</parameter>
         <parameter name="user">sa</parameter>
         <parameter name="password"></parameter>
        </nodestore>
        <securitystore>
          <reference store="nodestore" />
        </securitystore>
        <lockstore>
          <reference store="nodestore" />
        </lockstore>
        <revisiondescriptorsstore>
          <reference store="nodestore" />
        </revisiondescriptorsstore>
        <revisiondescriptorstore>
          <reference store="nodestore" />
        </revisiondescriptorstore-->

Since configuring a database can be tricky, it's not enabled by default.

There is work being done on an all filesystem store, which will eventually
replace the memory store (which is still very useful for doing some quick
testing).

Remy