Re: Extending user in T2.3

Thu, 03 Jul 2003 06:24:08 -0700


I'm not sure what you mean by "yet they have the same columns and you have left the
cross tables as the TURBINE supplied ones" I assume you mean that the tables and columns are still named the same. I'm a newbie, but I have fiddled and researched and asked about users myself. The point of keeping TURBINE_USER as-is (without modifying it's name or columns) is so that you can still use the Security feature:
http://jakarta.apache.org/turbine/turbine-2.2.1/howto/security-howto.html

As seen in the Turbine-User how-to:
http://jakarta.apache.org/turbine/turbine-2.2.1/howto/extend-user-
howto.html (40% down the page, code block "public class TurbineUserAdapter extends TurbineUser")

The point of extending the user (instead of simply creating your own) is so that your "user" class is compatible with TurbineUser. If you alter/delete the table or columns, you'll have to mess with TurbineUser. If you really need a CUSTOM_USER table, I believe your options are:

a) add the columns you need to Turbine_User; following the extend-user how-to,
b) simply FK TURBINE_USER from your own CUSTOM_USER table... then you can have your cake and eat it too, or
c) throw away the Turbine-Security features altogether.

Hope that helps
Keith



On Thursday, July 3, 2003, at 09:01 AM, David Wynter wrote:

Hi Henning,

Just trying out your extended user approach below (while killing time until
I can get some advice on this unresolved 'category' generatino problem).

I have a question on the example. You replace the TURBINE_NNN for Group,
Permission and Role and yet they have the same columns and you have left the
cross tables as the TURBINE supplied ones. Is this because you have to or is
it just for the exercise? In other words, can I just replace TURBINE_USER
with my CUSTOM_USER and continue to use the torque generate TURBINE_NNN
tables for the others?

regards,

David

-----Original Message-----
From: Henning P. Schmiedehausen [mailto:[EMAIL PROTECTED]
Sent: 02 July 2003 14:16
To: [EMAIL PROTECTED]
Subject: Re: Extending user in T2.3


Zamek <[EMAIL PROTECTED]> writes:

I would like to get a working TR.props file or a part of TR.prop

for compensation, I will correct, and comment the documentation. 

Ok, the following is cut life out of the application running in the
window behind this one...

--- cut ---
services.SecurityService.classname=org.apache.turbine.services.security.torq
ue.TorqueSecurityService
[...]
# -------------------------------------------------------------------
#
#  S E C U R I T Y  S E R V I C E
#
# -------------------------------------------------------------------

# Default: org.apache.turbine.services.security.db.DBUserManager
services.SecurityService.user.manager =
org.apache.turbine.services.security.torque.TorqueUserManager

# This is the class that implements the ACL interface.
services.SecurityService.acl.class =
org.apache.turbine.util.security.TurbineAccessControlList

#
# Configure Object Classes in the Security Service
#

# Custom User
services.SecurityService.user.class = de.intermeta.myapp.security.MyAppUser

services.SecurityService.group.class =
org.apache.turbine.services.security.torque.TorqueGroup
services.SecurityService.permission.class =
org.apache.turbine.services.security.torque.TorquePermission
services.SecurityService.role.class =
org.apache.turbine.services.security.torque.TorqueRole

#
# Configure Peers for the Torque Security Service
#
services.SecurityService.torque.userPeer.class =
de.intermeta.myapp.security.om.MyappUserPeer
services.SecurityService.torque.groupPeer.class =
de.intermeta.myapp.security.om.MyappGroupPeer
services.SecurityService.torque.permissionPeer.class =
de.intermeta.myapp.security.om.MyappPermissionPeer
services.SecurityService.torque.rolePeer.class =
de.intermeta.myapp.security.om.MyappRolePeer

[...]

--- cut ---

--- cut --- myapp-schema.xml ---
<?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
<!DOCTYPE database SYSTEM
"http://jakarta.apache.org/turbine/dtd/database_3_1.dtd";>

<database name="myapp"
  defaultIdMethod="idbroker"
  defaultJavaType="primitive"
  defaultJavaNamingMethod="underscore"
  package="de.intermeta.myapp.security.om">

<table name="MYAPP_USER" idMethod="idbroker">
<column name="USER_ID" required="true" primaryKey="true"
type="INTEGER"/>
<column name="LOGIN_NAME" required="true" size="64" type="VARCHAR"
javaName="UserName"/>
<column name="PASSWORD_VALUE" required="true" size="16" type="VARCHAR"
javaName="Password"/>
<column name="FIRST_NAME" required="true" size="64" type="VARCHAR"/>
<column name="LAST_NAME" required="true" size="64" type="VARCHAR"/>
<column name="EMAIL" size="64" type="VARCHAR"/>
<column name="CONFIRM_VALUE" size="16" type="VARCHAR"
javaName="Confirmed"/>
<column name="MODIFIED" type="TIMESTAMP" size="0"/>
<column name="CREATED" type="TIMESTAMP" size="0" javaName="CreateDate"/>
<column name="LAST_LOGIN" type="TIMESTAMP" size="0"/>
<column name="OBJECTDATA" type="VARBINARY"/>

<!-- Myapp Erweiterungen -->

<!-- Aktuell ausgewaehlte Sprachversion -->
<column name="MYAPP_LANGUAGE_ID" type="INTEGER" javaName="LanguageId"/>
<!-- Aktuell ausgewaehlte Gruppe -->
<column name="MYAPP_GRUPPEN_ID" type="INTEGER" javaName="GruppenId"/>

    <unique>
        <unique-column name="LOGIN_NAME"/>
    </unique>

</table>

<table name="MYAPP_PERMISSION" idMethod="idbroker">
<column name="PERMISSION_ID" required="true" primaryKey="true"
type="INTEGER"/>
<column name="PERMISSION_NAME" required="true" size="64" type="VARCHAR"
javaName="Name"/>

    <unique>
      <unique-column name="PERMISSION_NAME"/>
    </unique>

</table>

  <table name="MYAPP_ROLE" idMethod="idbroker">
    <column name="ROLE_ID" required="true" primaryKey="true"
type="INTEGER"/>
    <column name="ROLE_NAME" required="true" size="64" type="VARCHAR"
javaName="Name"/>

    <unique>
        <unique-column name="ROLE_NAME"/>
    </unique>

</table>

  <table name="MYAPP_GROUP" idMethod="idbroker">
    <column name="GROUP_ID" required="true" primaryKey="true"
type="INTEGER"/>
    <column name="GROUP_NAME" required="true" type="VARCHAR" size="64"
javaName="Name"/>

    <unique>
        <unique-column name="GROUP_NAME"/>
    </unique>

</table>

  <table name="TURBINE_ROLE_PERMISSION">
    <column name="ROLE_ID" required="true" primaryKey="true"
type="INTEGER"/>
    <column name="PERMISSION_ID" required="true" primaryKey="true"
type="INTEGER"/>

    <foreign-key foreignTable="MYAPP_ROLE">
      <reference local="ROLE_ID" foreign="ROLE_ID"/>
    </foreign-key>

    <foreign-key foreignTable="MYAPP_PERMISSION">
      <reference local="PERMISSION_ID" foreign="PERMISSION_ID"/>
    </foreign-key>
  </table>

  <table name="TURBINE_USER_GROUP_ROLE">
    <column name="USER_ID" required="true" primaryKey="true"
type="INTEGER"/>
    <column name="GROUP_ID" required="true" primaryKey="true"
type="INTEGER"/>
    <column name="ROLE_ID" required="true" primaryKey="true"
type="INTEGER"/>

    <foreign-key foreignTable="MYAPP_USER">
      <reference local="USER_ID" foreign="USER_ID"/>
    </foreign-key>

    <foreign-key foreignTable="MYAPP_GROUP">
      <reference local="GROUP_ID" foreign="GROUP_ID"/>
    </foreign-key>

    <foreign-key foreignTable="MYAPP_ROLE">
      <reference local="ROLE_ID" foreign="ROLE_ID"/>
    </foreign-key>
  </table>

</database>
--- cut --- myapp-schema.xml ---


--- cut --- MyAppUser.java ---
package de.intermeta.myapp.security;

import org.apache.turbine.services.security.torque.TorqueUser;

import de.intermeta.myapp.security.om.MyappUser;

public class MyAppUser
        extends TorqueUser
{
    /**
     * Constructor.
     */
    public MyAppUser()
    {
        super();
    }

    /**
     * This Constructor is used when the UserPeerManager
     * has retrieved a list of Database Objects from the peer and
     * must 'wrap' them into TorqueRole Objects. You should not use it
directly!
     *
     * @param obj An Object from the peer
     */
    public MyAppUser(Persistent obj)
    {
        super(obj);
    }


    public int getLanguageId()
    {
        return ((MyappUser) getPersistentObj()).getLanguageId();
    }

    public void setLanguageId(int languageId)
    {
        ((MyappUser) getPersistentObj()).setLanguageId(languageId);
    }

    public int getGruppenId()
    {
        return ((MyappUser) getPersistentObj()).getGruppenId();
    }

    public void setGruppenId(int gruppenId)
    {
        ((MyappUser) getPersistentObj()).setGruppenId(gruppenId);
    }
}
--- cut --- MyAppUser.java ---

- Run the schema, you should get de.intermeta.myapp.security.om.<lots of
classes>
- add de.intermeta.maxpatch.myapp.security.MyAppUser.java
- configure Turbine as described above
- create the tables with maven torque:sql, put them into a database (I use
PostgreSQL).

Insert some data into the tables:

--- cut ---
INSERT INTO MYAPP_USER
(USER_ID,LOGIN_NAME,PASSWORD_VALUE,FIRST_NAME,LAST_NAME)
    VALUES (1,'turbine','turbine','Mr.','Turbine');

INSERT INTO MYAPP_PERMISSION (PERMISSION_ID,PERMISSION_NAME)
    VALUES (1,'Myapp');

INSERT INTO MYAPP_ROLE (ROLE_ID,ROLE_NAME)
    VALUES (1,'MyappAdmin');


INSERT INTO MYAPP_GROUP (GROUP_ID,GROUP_NAME)
    VALUES (1,'global');


INSERT INTO MYAPP_GROUP (GROUP_ID,GROUP_NAME)
    VALUES (2,'Myapp');


INSERT INTO TURBINE_ROLE_PERMISSION (ROLE_ID,PERMISSION_ID)
    VALUES (1,1);


INSERT INTO TURBINE_USER_GROUP_ROLE (USER_ID,GROUP_ID,ROLE_ID)
    VALUES (1,2,1);

--- cut ---

Now you should be able to log on with user "turbine" , pw "turbine".

        Regards
                Henning




--
Dipl.-Inf. (Univ.) Henning P. Schmiedehausen          INTERMETA GmbH
[EMAIL PROTECTED]        +49 9131 50 654 0   http://www.intermeta.de/

Java, perl, Solaris, Linux, xSP Consulting, Web Services
freelance consultant -- Jakarta Turbine Development  -- hero for hire

--- Quote of the week: "It is pointless to tell people anything when
you know that they won't process the message." --- Jonathan Revusky

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



___________________________________
Keith Seim • http://kjsdesigns.com

Reply via email to