turbine-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "David Demner" <turb...@demner.com>
Subject RE: inserting user into mysql for use with turbine security
Date Wed, 14 Jan 2004 17:22:52 GMT
Hi,

Alternately, you can specify the users/roles/groups in your
turbine-security.xml conf file.  For example,

<TurbineUser UserId="1" LoginName="admin" PasswordValue="guessme"
FirstName="ad" LastName="min"/>
<TurbineGroup GroupId="1" GroupName="global"/>
<TurbinePermission PermissionId="1" PermissionName="user_admin"/>
<TurbineRole RoleId="1" RoleName="admin"/>
<TurbineRolePermission RoleId="1" PermissionId="1"/>
<TurbineUserGroupRole UserId="1" GroupId="1" RoleId="1"/>

Then, after a little monkeying around with the build.xml and
build-torque.xml files, you can import this into the database:

build.xml:

  <target
    name="security">
    <antcall target="schema-sql"/>
    <antcall target="security-sql"/>
    <ant
      antfile="${torque.buildFile}"
      target="insert-security-sql">
    </ant>
  </target>
  

build-torque.xml:

  <target
    name="insert-security-sql"
    description="==> inserts the generated sql ">

    <sql
      autocommit="true"
      driver="${torque.database.driver}"
      onerror="continue"
      password="${torque.database.password}"
      src="${torque.sql.dir}/turbine-schema.sql"
      url="${torque.database.buildUrl}"
      userid="${torque.database.user}">
      <classpath refid="torque-classpath"/>
    </sql>
    <sql
      autocommit="true"
      driver="${torque.database.driver}"
      onerror="continue"
      password="${torque.database.password}"
      src="${torque.sql.dir}/turbine-security.sql"
      url="${torque.database.buildUrl}"
      userid="${torque.database.user}">
      <classpath refid="torque-classpath"/>
    </sql>
  </target>

Then just run 'ant security' and it will refresh all your
users/groups/roles/etc.  But be careful since written like this, it will
blow away all the security that isn't in your xml file, so it probably most
useful in dev.  You can remove the first <sql> from the build-torque.xml
file and be prepared for a bunch of primary key errors if you just want to
add to your current users/groups/roles.

My reply turned out to be a lot longer than I expected.  And it doesn't
really answer your question since you wanted something you could run from
your application.  But the reply was so long, I didn't want to waste it so
I'm sending it anyway.

Good luck,

David

-----Original Message-----
From: Chris Joelly [mailto:chris.joelly@unycom.com] 
Sent: Wednesday, January 14, 2004 8:38 AM
To: turbine-user@jakarta.apache.org
Subject: inserting user into mysql for use with turbine security


Hello!

i want to insert/update an user from within my application for use with
turbine security. i looked at the datamodel and have inserted the user
with the following statements into TURBINE_USER and TURBINE_USER_GROUP_ROLE


insert into TURBINE_USER (USER_ID, LOGIN_NAME, PASSWORD_VALUE, FIRST_NAME,
LAST_NAME)
	values (1001, 'portal', 'portal', 'APortal', 'User');
	
insert into TURBINE_USER_GROUP_ROLE (USER_ID, GROUP_ID, ROLE_ID)
	values (1001, 1, 2);

are there any other tables to set? the group and role used in this
example does exist, but i can't login with this user ...

thx, Chris

-- 
mit freundlichen Grüßen / with kind regards
 
Ing. Christian Jölly @ Solutions
unycom  Information Technology Services GmbH
A-8042 Graz | Schmiedlstraße 1 / III

Tel: ++43 (0)316 / 818 828 - 30
Fax: ++43 (0)316 / 818 828 - 38
chris.joelly@unycom.com
http://www.unycom.com

Christel zu Oli (es ging um /etc/apt/sources.list):

"Unstable?!  Bist Du bescheuert?"

---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org


Mime
View raw message