From users-return-7409-apmail-continuum-users-archive=continuum.apache.org@continuum.apache.org Wed Jan 07 11:21:23 2009 Return-Path: Delivered-To: apmail-continuum-users-archive@www.apache.org Received: (qmail 37472 invoked from network); 7 Jan 2009 11:21:23 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 7 Jan 2009 11:21:23 -0000 Received: (qmail 26947 invoked by uid 500); 7 Jan 2009 11:21:22 -0000 Delivered-To: apmail-continuum-users-archive@continuum.apache.org Received: (qmail 26500 invoked by uid 500); 7 Jan 2009 11:21:21 -0000 Mailing-List: contact users-help@continuum.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@continuum.apache.org Delivered-To: mailing list users@continuum.apache.org Received: (qmail 26489 invoked by uid 99); 7 Jan 2009 11:21:21 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 07 Jan 2009 03:21:21 -0800 X-ASF-Spam-Status: No, hits=2.6 required=10.0 tests=DNS_FROM_OPENWHOIS,SPF_HELO_PASS,SPF_PASS,WHOIS_MYPRIVREG X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of lists@nabble.com designates 216.139.236.158 as permitted sender) Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 07 Jan 2009 11:21:13 +0000 Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1LKWSz-0005Ce-5S for users@continuum.apache.org; Wed, 07 Jan 2009 03:20:53 -0800 Message-ID: <21329384.post@talk.nabble.com> Date: Wed, 7 Jan 2009 03:20:53 -0800 (PST) From: tinne To: users@continuum.apache.org Subject: Re: Change a user role to build admin In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: tinnefeld@adesso.de References: X-Virus-Checked: Checked by ClamAV on apache.org anoopkumar wrote: > > Never mind - I figured this out. > > 8. ij> connect > 'jdbc:derby:/usr/local/continuum-1.0.3/apps/continuum/database'; > ij> select * from sa.continuumuser; > ij> UPDATE SA.CONTINUUMUSER set GROUP_ID_OID=1 where ACCOUNT_ID = 6; > 1 row inserted/updated/deleted > ij> commit; > This looks pretty outdated. As of continuum 1.2, the database has been split into a continuum and a users database (which can be found in the logs directory for some strange reason!). The following worked for me (under cygwin): 1.) export DERBY_HOME=`cygpath -wa /cygdrive/c/Programme/derby/10.4.2.0` 2.) export CLASSPATH=$DERBY_HOME\\lib\\derby.jar\;$DERBY_HOME\\lib\\derbytools.jar 3.) export PATH=`cygpath -ua $DERBY_HOME`/bin:$PATH 4.) ij.bat 4a.) connect 'jdbc:derby:C:\Programme\Continuum\1.2\logs\data\databases\users'; 4b.) select * from sa.jdouser; 4c.) update sa.jdouser set encoded_password = '' where username = 'admin'; 4d.) update sa.jdouser set count_failed_login_attempts = 0 where username = 'admin'; 4e.) commit; 4f.) exit; Please note that both the table and the database have changed. Also, my approach is to reset the password to the one of a normal user and to reset the failure count. On re-running continuum, simply login with the user's password and change it. -- View this message in context: http://www.nabble.com/Change-a-user-role-to-build-admin-tp8692812p21329384.html Sent from the Continuum - Users (old) mailing list archive at Nabble.com.