From derby-user-return-14659-apmail-db-derby-user-archive=db.apache.org@db.apache.org Wed Oct 3 09:13:20 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 7BC24D1F3 for ; Wed, 3 Oct 2012 09:13:20 +0000 (UTC) Received: (qmail 72235 invoked by uid 500); 3 Oct 2012 09:13:20 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 71897 invoked by uid 500); 3 Oct 2012 09:13:17 -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 71874 invoked by uid 99); 3 Oct 2012 09:13:16 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 03 Oct 2012 09:13:16 +0000 X-ASF-Spam-Status: No, hits=-2.8 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_HI,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of kristian.waagan@oracle.com designates 148.87.113.117 as permitted sender) Received: from [148.87.113.117] (HELO rcsinet15.oracle.com) (148.87.113.117) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 03 Oct 2012 09:13:07 +0000 Received: from ucsinet21.oracle.com (ucsinet21.oracle.com [156.151.31.93]) by rcsinet15.oracle.com (Sentrion-MTA-4.2.2/Sentrion-MTA-4.2.2) with ESMTP id q939Cj5S020383 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK) for ; Wed, 3 Oct 2012 09:12:46 GMT Received: from acsmt356.oracle.com (acsmt356.oracle.com [141.146.40.156]) by ucsinet21.oracle.com (8.14.4+Sun/8.14.4) with ESMTP id q939Cj96002904 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Wed, 3 Oct 2012 09:12:45 GMT Received: from abhmt113.oracle.com (abhmt113.oracle.com [141.146.116.65]) by acsmt356.oracle.com (8.12.11.20060308/8.12.11) with ESMTP id q939Cijb029258 for ; Wed, 3 Oct 2012 04:12:44 -0500 Received: from [192.168.1.114] (/84.215.229.154) by default (Oracle Beehive Gateway v4.0) with ESMTP ; Wed, 03 Oct 2012 02:12:44 -0700 Message-ID: <506C018C.4080701@oracle.com> Date: Wed, 03 Oct 2012 11:12:44 +0200 From: Kristian Waagan Organization: Oracle Corporation User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:10.0.1) Gecko/20120208 Thunderbird/10.0.1 MIME-Version: 1.0 To: derby-user@db.apache.org Subject: Re: unable to take backup after derby upgrade References: <506972D5.3010901@oracle.com> <1349193563.53011.YahooMailNeo@web124905.mail.ne1.yahoo.com> In-Reply-To: <1349193563.53011.YahooMailNeo@web124905.mail.ne1.yahoo.com> Content-Type: multipart/alternative; boundary="------------010308040602000302070405" X-Source-IP: ucsinet21.oracle.com [156.151.31.93] X-Virus-Checked: Checked by ClamAV on apache.org This is a multi-part message in MIME format. --------------010308040602000302070405 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit On 02.10.2012 17:59, Tomcat Programmer wrote: > I was able to backup my derby database 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 error: > > ERROR 38000: The exception 'java.security.AccessControlException: > Access denied (java.io.FilePermission /usr/local/derby10/backups/PRAT > write)' was thrown while evaluating an expression.ERROR XJ001: Java > exception: 'Access denied (java.io.FilePermission > /usr/local/derby10/backups/PRAT write): > java.security.AccessControlException'. It may also help if you post the stack trace relevant to Derby (i.e. you don't need to include anything from your own code). Regards, -- Kristian > > > I am using the exact same copy of the 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 the backup. The file permissions are setup so > this user id has full control of all files and directories. The > operating system is 32-bit linux. > > What has changed in this release which is causing this problem? How > do I fix it? > --------------010308040602000302070405 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit On 02.10.2012 17:59, Tomcat Programmer wrote:
I was able to backup my derby database 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 error: 

ERROR 38000: The exception 'java.security.AccessControlException: Access denied (java.io.FilePermission /usr/local/derby10/backups/PRAT write)' was thrown while evaluating an expression. ERROR XJ001: Java exception: 'Access denied (java.io.FilePermission /usr/local/derby10/backups/PRAT write): java.security.AccessControlException'.

It may also help if you post the stack trace relevant to Derby (i.e. you don't need to include anything from your own code).


Regards,
--
Kristian



I am using the exact same copy of the 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 the backup. The file permissions are setup so this user id has full control of all files and directories.  The operating system is 32-bit linux. 

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

--------------010308040602000302070405--