From graffito-dev-return-928-apmail-incubator-graffito-dev-archive=www.apache.org@incubator.apache.org Tue Jan 31 14:30:41 2006 Return-Path: Delivered-To: apmail-incubator-graffito-dev-archive@www.apache.org Received: (qmail 29413 invoked from network); 31 Jan 2006 14:30:40 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 31 Jan 2006 14:30:40 -0000 Received: (qmail 46013 invoked by uid 500); 31 Jan 2006 14:30:38 -0000 Mailing-List: contact graffito-dev-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: graffito-dev@incubator.apache.org Delivered-To: mailing list graffito-dev@incubator.apache.org Received: (qmail 46002 invoked by uid 99); 31 Jan 2006 14:30:37 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 Jan 2006 06:30:37 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=HTML_MESSAGE,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of salvio@geneticmail.com designates 66.220.3.178 as permitted sender) Received: from [66.220.3.178] (HELO ns1.geneticmail.com) (66.220.3.178) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 Jan 2006 06:30:36 -0800 Received: from [192.168.1.100] (host13-14.pool873.interbusiness.it [87.3.14.13]) (authenticated bits=0) by ns1.geneticmail.com (8.13.1/8.13.1) with ESMTP id k0VETxYx007983 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Tue, 31 Jan 2006 06:30:05 -0800 Message-ID: <43DF7461.8080509@geneticmail.com> Date: Tue, 31 Jan 2006 15:29:53 +0100 From: Salvio User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: graffito-dev@incubator.apache.org Subject: Re: MySQL Build issues References: <43DE6047.5020509@geneticmail.com> <3b728ee90601301238h69852df4n56958f54d7f0fdaa@mail.gmail.com> In-Reply-To: <3b728ee90601301238h69852df4n56958f54d7f0fdaa@mail.gmail.com> Content-Type: multipart/alternative; boundary="------------070207070700080406040804" X-Scanned-By: MIMEDefang 2.54 on 66.220.3.178 X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N --------------070207070700080406040804 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Hi Christophe, I had two properties set to false in my build.properties: org.apache.portals.graffito.test.jetspeed org.apache.portals.graffito.production.jetspeed After changing them to true (as clearly stated on the build instructions page) I had a successful build and deploy. Thanks, Salvio Christophe Lombart wrote: >I'm also using InnoDB. Before executing the allClean & allBuild goals, >did clean-up the DB used for the Graffito test ? >I made some refactoring that maybe cause the problem. > >note: I just commited something but this is a bug fix for deploying >Graffito into Jetspeed. > > >On 1/30/06, Salvio wrote: > > >> Hi All, >> >>I'm having the same problem seen in this thread: >>http://www.mail-archive.com/graffito-dev@incubator.apache.org/msg00279.html >> >>What I have done is: >> >>1. upgraded mysql to 4.1.16 >>2. downloaded and installed jetspeed2 multi db using >>3. checked out the trunk of graffito >>4. run a maven allClean allBuild using the attached build properties >> >>I get this error message: >>db.create: >>db.execute: >> [echo] Execute SQL script : >>./target/src/sql/mysql/security-schema.sql -- ON ERROR = abort >> [sql] Executing file: >>C:\graffito\x\target\checkout\components\target\src\sql\mysql\security-schema.sql >> [sql] [ERROR] Failed to execute: # >>----------------------------------------------------------------------- >> # SECURITY_PRINCIPAL # >>----------------------------------------------------------------------- >> drop table if exists SECURITY_PRINCIPAL >> >>BUILD FAILED >>File...... C:\graffito\x\target\checkout\maven.xml >>Element... maven:reactor >>Line...... 88 >>Column.... 40 >>Unable to obtain goal [test:test] -- >>C:\graffito\x\target\checkout\components\maven.xml:286:38: >>java.sql.SQLException: Cannot delete or update a parent row: a foreign >>key constraint fails >> >>I have also tried using BDB instead of the default INNODB and in this >>case the build and deploy complete successfully. >>To complete the installation though I need to re-populate the following >>tables with the original data (before deploying graffito) and then run >>insert-j2-security.sql again. The tables are: principal_permission, >>security_credential, security_permission, security_principal, >>security_user_group, security_user_role. >> >>- Salvio >> >> >> >> >> > > >-- >Best regards, > >Christophe > > --------------070207070700080406040804--