Thanks for the quick reply David and Henning. @David: We are just using JForum and Openfire. (Claros and Smack are also used when needed.) This is just initial project scope: Forum, Blog, Chatting, Event Tracking, etc. We are also thinking of providing OpenSocial support in this. Once we have a stable version of this, then we will look at what else can be done. Everything is to be done using Open Source, thats for sure.
I'm new to this project and am not fully aware of how the other modules are used. Blog module is assigned to me. The Website, as such, is already using Spring Security. So I think integrating JRoller will be easy. I just have to figure out how :) I think CAS fits my requirement. But then the existing site will also have to be modified a bit. Let's see how this goes. -----Original Message----- From: henning.br...@googlemail.com [mailto:henning.br...@googlemail.com] On Behalf Of Henning Brune Sent: Tuesday, February 24, 2009 8:30 PM To: user@roller.apache.org Subject: Re: How to integrate JRoller in existing website. 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....@ibol.biz> wrote: > Hi, Arun. > > In creating accout in Apache Roller, you need to insert a user profile including password into table ROLLERUSER and you also need to insert one or two user role record into table USERROLE. You can take a look and compare these two tables with the tables for JForum and OpenFire. > > I feel it should be easier if you implement a UI and directly transact to all the user profile tables of JRoller, JForum and OpenFire. > > > By the way, I really like JForum and OpenFire you mentioned, do you know any other Java open sources, for example, online inventory and shopping card? Truly appreciate. > > > Regards. > > > David > > --- On Tue, 2/24/09, Arun Kumar <arun_ku...@persistent.co.in> wrote: > > > From: Arun Kumar <arun_ku...@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 same > 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 table > that others are using. > > So is this possible? > > Can the queries fired by JRoller be changed so that it mapps to the existing > 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 > > -- Dipl.-Inform. Henning Brune http://ekvv.uni-bielefeld.de/pers_publ/publ/PersonDetail.jsp?personId=10185 Universität Bielefeld Projekt BIS Postfach 10 01 31 D-33501 Bielefeld Die neue Homepage des BIS Projektes: http://www.uni-bielefeld.de/bis/
