Return-Path: Delivered-To: apmail-jakarta-turbine-user-archive@www.apache.org Received: (qmail 50713 invoked from network); 14 Jan 2004 16:59:26 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 14 Jan 2004 16:59:26 -0000 Received: (qmail 10575 invoked by uid 500); 14 Jan 2004 16:59:15 -0000 Delivered-To: apmail-jakarta-turbine-user-archive@jakarta.apache.org Received: (qmail 10546 invoked by uid 500); 14 Jan 2004 16:59:15 -0000 Mailing-List: contact turbine-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Turbine Users List" Reply-To: "Turbine Users List" Delivered-To: mailing list turbine-user@jakarta.apache.org Received: (qmail 10532 invoked from network); 14 Jan 2004 16:59:15 -0000 Received: from unknown (HELO castle.comp.uvic.ca) (142.104.5.97) by daedalus.apache.org with SMTP; 14 Jan 2004 16:59:15 -0000 Received: from uvic.ca (h24-68-105-35.gv.shawcable.net [24.68.105.35]) by castle.comp.uvic.ca (8.12.10/8.12.10) with ESMTP id i0EGxHkA3563704 for ; Wed, 14 Jan 2004 08:59:17 -0800 Message-ID: <40057841.8020201@uvic.ca> Date: Wed, 14 Jan 2004 09:11:29 -0800 From: Matt Hughes User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6b) Gecko/20031221 Thunderbird/0.4 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Turbine Users List Subject: Re: inserting user into mysql for use with turbine security References: <20040114163734.GA23404@unycom.com> In-Reply-To: <20040114163734.GA23404@unycom.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-UVic-Virus-Scanned: OK - Passed virus scan by Sophos (sophie) on castle X-UVic-Spam-Scan: castle.comp.uvic.ca Not_scanned_LOCAL X-Scanned-By: MIMEDefang 2.33 (www . roaringpenguin . com / mimedefang) X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N Chris Joelly wrote: > 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 > I found that I had to add new users to the turbine_root role (number 1) before they could log in to the app. Not sure why this is. insert into TURBINE_USER_GROUP_ROLE (USER_ID, GROUP_ID, ROLE_ID) values (1001, 1, 1); -- Matt Hughes + mhughe@uvic.ca + http://spacemonkeys.ca/ --------------------------------------------------------------------- To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org For additional commands, e-mail: turbine-user-help@jakarta.apache.org