From derby-user-return-14657-apmail-db-derby-user-archive=db.apache.org@db.apache.org Tue Oct 2 15:59:56 2012 Return-Path: X-Original-To: apmail-db-derby-user-archive@www.apache.org Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 2DF34922C for ; Tue, 2 Oct 2012 15:59:56 +0000 (UTC) Received: (qmail 49966 invoked by uid 500); 2 Oct 2012 15:59:55 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 49777 invoked by uid 500); 2 Oct 2012 15:59:55 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 49766 invoked by uid 99); 2 Oct 2012 15:59:54 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 02 Oct 2012 15:59:54 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [98.138.229.98] (HELO nm35-vm2.bullet.mail.ne1.yahoo.com) (98.138.229.98) by apache.org (qpsmtpd/0.29) with SMTP; Tue, 02 Oct 2012 15:59:45 +0000 Received: from [98.138.90.57] by nm35.bullet.mail.ne1.yahoo.com with NNFMP; 02 Oct 2012 15:59:24 -0000 Received: from [98.138.87.9] by tm10.bullet.mail.ne1.yahoo.com with NNFMP; 02 Oct 2012 15:59:24 -0000 Received: from [127.0.0.1] by omp1009.mail.ne1.yahoo.com with NNFMP; 02 Oct 2012 15:59:24 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 248302.6582.bm@omp1009.mail.ne1.yahoo.com Received: (qmail 10649 invoked by uid 60001); 2 Oct 2012 15:59:23 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1349193563; bh=OVVlXrFP4IUjFu6SXImHuVS3Ek6kTIP0Mywls4J0ehw=; h=X-YMail-OSG:Received:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=xwt32IE5Mmpce0sBdbE9FFw+B6QJA2ZL+6tVlFm8SrddmQpkSohMl6ikG/ZXg4ZLZO0sTv2N7vvqchiY2WQFy9Xxgvw9G3Qe3ctri81WhwqamB54o0w948rAtFSPkO5PoAa0H084gHLfShZiWHznzEqWfs2T7ljp2yfTbL1XD3o= DomainKey-Signature:a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=tL2UQ4If3CvzaprZKUN5K7S5QPHIXbu3yQFSEmf5XOrHLly9E5zGW30iqVR7b5U2sd3BkJ4NQODEdIRMIcs6ARgHQ3/r8vh7DTdQrnxmCnWr5440/2rEVC9DksSV6CTq6GFVlkirOPZXmOOs5xk0Vg8AmtbN3uqIDko8TIGzjKk=; X-YMail-OSG: j60XZu4VM1mDHVkK77KZqDsB7V61Gtmgcf8uHO6Re_gEQt2 Kmk569QVOevYCXWGtoVIMbTfbkPWnxKupV0qzuZwdaBqYhfW1ULCG1Hi1sNA Ogex.RQ0s7ZMW8UtJL5gz6GWcFUe5aE4XcaCr3J_COs2RsX9tCNG8ySP85vn YIr8Sjbk6E8jbbKgPce2mRhk_pCjSPMq8Ewr4vfnUFDRmQFqf0C.NSy0.BsI AnZzuxI5S5DHjSsaCeRcyB_oW4X8fFO4tRaIm5cwwLU2tuEOMQVwxmxQUFC8 cLqwhyrEmsh0tNG19PHX99Crx_Nk3PCd44CcAVZRUaI5IjnFtsCls1cLtDKa qtuT5AtLqYelPLTsXLagJV5AzZfmLv6O1mXMPpSO0FqUfrOaSB6QreRnrXlW b5.pmXdoz62rd5g6ngBzDZzKBgTP9kwDB1vGz.iCg5eFX2.jUM5PHwKlhSHd vCJ.kTSOtVlXxBUht4NVLtOaFQJ7rFjfoUvlExw.pH0yygnSbBaH.DHMt4LQ equnWPHVqhsRZ Received: from [129.33.1.37] by web124905.mail.ne1.yahoo.com via HTTP; Tue, 02 Oct 2012 08:59:23 PDT X-Mailer: YahooMailWebService/0.8.122.442 References: <506972D5.3010901@oracle.com> Message-ID: <1349193563.53011.YahooMailNeo@web124905.mail.ne1.yahoo.com> Date: Tue, 2 Oct 2012 08:59:23 -0700 (PDT) From: Tomcat Programmer Reply-To: Tomcat Programmer Subject: unable to take backup after derby upgrade To: Derby Discussion In-Reply-To: <506972D5.3010901@oracle.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-1514212066-167923362-1349193563=:53011" X-Virus-Checked: Checked by ClamAV on apache.org ---1514212066-167923362-1349193563=:53011 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable I was able to backup my derby database successfully using the previous vers= ion 10.8.2.2=A0=A0and the following command, running from ij:=0A=0Aij> CALL= SYSCS_UTIL.SYSCS_BACKUP_DATABASE('/usr/local/derby10/backups');=0A=0A=0A= =0AAfter upgrading to 10.9.1.0 the same exact command fails with the follow= ing error:=A0=0A=0A=0AERROR 38000: The exception 'java.security.AccessContr= olException: Access denied (java.io.FilePermission /usr/local/derby10/backu= ps/PRAT write)' was thrown while evaluating an expression.=A0ERROR XJ001: J= ava exception: 'Access denied (java.io.FilePermission /usr/local/derby10/ba= ckups/PRAT write): java.security.AccessControlException'.=0A=0A=0AI am usin= g the exact same copy of the java JRE, no changes. =A0After upgrading the d= erby version, the update process was run on the database and did not return= any errors. No changes have been made to the filesystem. =A0The directory = "/usr/local/derby10/" as well as all of its child directories are owned by = the same user id, which is used to run the database and do the backup. The = file permissions are setup so this user id has full control of all files an= d directories. =A0The operating system is 32-bit linux.=A0=0A=0AWhat has ch= anged in this release which is causing this problem? =A0 How do I fix it?= =A0=0A ---1514212066-167923362-1349193563=:53011 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
I was able to backup my derby d= atabase successfully using the previous version 10.8.2.2  and the= following command, running from ij:

ij> CALL SYSCS_UTIL.SYSCS_BACKUP_DATABASE('/usr/local/derby10/= backups');


After upgrading to 10.9.1.0 the same exact command fails with the following er= ror: 

ERR= OR 38000: The exception 'java.security.AccessControlException: Access denie= d (java.io.FilePermission /usr/local/derby10/backups/PRAT write)' was throw= n while evaluating an expression. ERROR XJ001: Java exception: 'Access denied (java.io.FilePe= rmission /usr/local/derby10/backups/PRAT write): java.security.AccessContro= lException'.


I am using the exact same copy of th= e java JRE, no changes.  After upgrading the derby version, the update= process was run on the database and did not return any errors. No changes = have been made to the filesystem.  The directory "/usr/local/derby10/" as well as all of its child directories are owned by the same user id, which is used to run the database and do th= e backup. The file permissions are setup so this user id has full control o= f all files and directories.  The operating system is 32-bit linux.&nb= sp;

What has changed in this release which is causing th= is problem?   How do I fix it? 

---1514212066-167923362-1349193563=:53011--