Mailing-List: contact user-help@roller.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@roller.apache.org
Received-SPF: pass (nike.apache.org: domain of henning.brune@googlemail.com
 designates 66.249.92.168 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=googlemail.com; s=gamma;
        h=mime-version:sender:in-reply-to:references:date
         :x-google-sender-auth:message-id:subject:from:to:content-type
         :content-transfer-encoding;
        b=FgAwHeN+8Cs2EApzx5Iy8h7EAqCgV4/8wvOd+tUhkoTxRx4NVPttJeM/n4jprcVG8A
         isY3riSDivV8EQh/g50kB4JXoSeMnSEukoef3m5he6sv8qT73F5TjGCKI3MmEMn2fcX/
         dKx5etzNGGAepNIe2bzKt9mqHvTPpbt4YdP78=
MIME-Version: 1.0
Sender: henning.brune@googlemail.com
In-Reply-To: <742308.69400.qm@web301.biz.mail.mud.yahoo.com>
References: <742308.69400.qm@web301.biz.mail.mud.yahoo.com>
Date: Tue, 24 Feb 2009 16:00:13 +0100
Message-ID: <f88f4f300902240700q12f31fa7wc9009982c9e940cc@mail.gmail.com>
Subject: Re: How to integrate JRoller in existing website.
From: Henning Brune <henning.brune@uni-bielefeld.de>
To: user@roller.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hello,

we made an integration of JRoller with our existing user management.
We filled the two tables David mentioned from our user management
which was not to difficult because jroller and our system live side by
side in the same oracle database. Now when we create a new user in our
system a similar account is created in jroller.

Then we made an integration with CAS. Seems to work though we did not
go into production yet.

Here are some further details on our implementation:

* in our user management it is possible to delete a username completly
and then to assign it again to a new user. In JRoller it seems this is
not intended. As far as I understand it you should only inactivate a
user. So we had to find a way to deal with this (we rename the roller
users).

* we don't care about changes a user makes to his profile through the
jroller interface.

* because we are using CAS authentication we don't propagate passwords
to jroller.

-Henning


On Tue, Feb 24, 2009 at 3:40 PM, (David) Ming Xia
<david.ming.xia@ibol.biz> wrote:
> Hi, Arun.
>
> =A0=A0 In creating accout in Apache Roller, you need to=A0insert a user p=
rofile including password into table ROLLERUSER and you also need to insert=
 one or two user role record into table USERROLE.=A0 You can take a look an=
d compare these two tables with the tables for JForum and OpenFire.
>
> =A0=A0 I feel it should be easier if you implement a UI and directly tran=
sact to=A0all the user profile tables=A0of JRoller, JForum and OpenFire.
>
>
> =A0=A0 By the way, I really like=A0JForum and OpenFire you mentioned, do =
you know any other Java open sources, for example,=A0 online inventory and =
shopping card?=A0=A0 Truly appreciate.
>
>
> Regards.
>
>
> David
>
> --- On Tue, 2/24/09, Arun Kumar <arun_kumar@persistent.co.in> wrote:
>
>
> From: Arun Kumar <arun_kumar@persistent.co.in>
> Subject: How to integrate JRoller in existing website.
> To: user@roller.apache.org
> Date: Tuesday, February 24, 2009, 1:46 AM
>
>
> Hi,
>
>
>
> I have a website that has integrated jForum and OpenFire for forum and
> community support.
>
> This website uses a database and tables needed by JForum and OpenFire and
> created in this database.
>
> Queries fired by JForum, etc were modified so that all thse can use the s=
ame
> User-information table that has username and password fields.
>
> Can the same be done with JRoller?
>
> I know that I can create the tables needed by JRoller in the existing
> database. What I want is that JRoller used the same User-information tabl=
e
> that others are using.
>
> So is this possible?
>
> Can the queries fired by JRoller be changed so that it mapps to the exist=
ing
> User-information table ?
>
> Is there some mapping mechanism available that will simplify this?
>
> Please help, I'm really new to JRoller and am stuck on this from a week.
>
>
>
> Thanks,
>
> -Arun
>
>


--=20
Dipl.-Inform. Henning Brune

http://ekvv.uni-bielefeld.de/pers_publ/publ/PersonDetail.jsp?personId=3D101=
85

Universit=E4t Bielefeld
Projekt BIS
Postfach 10 01 31
D-33501 Bielefeld

Die neue Homepage des BIS Projektes:
http://www.uni-bielefeld.de/bis/