using user database (mySQL) in slide

Hello Tarun and all,

> You can use a database realm in tomcat to authenticate
slide >URLs and 
> then
> have slide auto create users as they come in.

I downloaded the Tomcat bundle, so the authentication is set
by default. Now 
I want to integrate Slide into our system that already has
user list stored 
in mySQL (and may be dinamically changed). Basicly, what I
need is almost 
the same as Bart Spedden's
<---------------------quotes------------------------>
(I'm trying to configure the a "store" in the
Domain.xml so that the 
contentstore can be pointed at the file system and the
securitystore, 
lockstore, revisiondescriptorsstore, and
revisiondescriptorstore can be 
pointed at a database.

As of now I have configured a JDB Connection Pool in Tomcat
by adding the 
following to server.xml:

        <!-- Set up the Oracle JDBC Connection Pool
-->
        <Context path="/slide"
docBase="slide" debug="5"
reloadable="true" 
crossContext="true">
            <Resource
                name="jdbc/slideDataSource"
                auth="Container"
                type="javax.sql.DataSource"
               
driverClassName="oracle.jdbc.OracleDriver"
                url="jdbc:oracle:thin:devlabor:1521:opusdev"
                username="SLIDE"
                password="SLIDE"
                maxActive="20"
                maxIdle="10"
                maxWait="-1"/>
        </Context>

Then, in Slide's Domain.xml I have defined the following
for the "slide" 
namespace:

        <definition>
            <store name="j2ee">
                <nodestore 
classname="org.apache.slide.store.impl.rdbms.J2EEStore
">
                    <parameter 
name="datasource">jdbc/slideDataSource</pa
rameter>
                    <parameter 
name="adapter">org.apache.slide.store.impl.rd
bms.OracleRDBMSAdapter</parameter>
                    <parameter
name="compress">false</parameter>
                </nodestore>
                <securitystore>
                    <reference
store="nodestore"/>
                </securitystore>
                <lockstore>
                    <reference
store="nodestore"/>
                </lockstore>
                <revisiondescriptorsstore>
                    <reference
store="nodestore"/>
                </revisiondescriptorsstore>
                <revisiondescriptorstore>
                    <reference
store="nodestore"/>
                </revisiondescriptorstore>
                <contentstore>
                    <reference
store="nodestore"/>
                </contentstore>
            </store>
            <scope match="/"
store="j2ee"/>
        </definition>
Could someone explain to me how to configure the
contentstore to use the 
file system instead of placing the MIME encoded files in a
CLOB in oracle.)

<---------------------end
quotes------------------------>

but I need to store user info. in database and the content
(files) will be 
stored in file system.

Thank you,
Ha Pham

----- Original Message ----- 
From: "Tarun Upadhyay" <utarungmail.com>
To: "'Slide Users Mailing List'"
<slide-userjakarta.apache.org>
Sent: Tuesday, March 28, 2006 9:08 AM
Subject: RE: using user database (mySQL) in slide


> You can use a database realm in tomcat to authenticate
slide URLs and then
> have slide auto create users as they come in.
>
> This is not the best but simplest method to get user
accounts working with
> slide from a database.
>
> Tarun
>
>> -----Original Message-----
>> From: Ha Pham [mailto:haphamcs.utah.edu]
>> Sent: Monday, March 27, 2006 6:01 PM
>> To: slide-userjakarta.apache.org
>> Subject: using user database (mySQL) in slide
>>
>> Dear all,
>>
>> I have a user account database in mySQL and would
like to use
>> in Slide (to replace the user accounts set on
Domain.xml).
>> Please help me with the documents or the code.
>> Thank you,
>> HaPham
>>
>>
>
>
>
------------------------------------------------------------
---------
> To unsubscribe, e-mail: slide-user-unsubscribejakarta.apache.org
> For additional commands, e-mail: slide-user-helpjakarta.apache.org
>
> 


------------------------------------------------------------
---------
To unsubscribe, e-mail: slide-user-unsubscribejakarta.apache.org
For additional commands, e-mail: slide-user-helpjakarta.apache.org