Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <5019196.1173137367037.JavaMail.root@brutus>
Date: Mon, 5 Mar 2007 15:29:27 -0800 (PST)
From: "A B (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Commented: (DERBY-2375) jdbcapi/users2.sql and
 jdbcapi/secureUsers.sql fails on IBM weme 6.1
In-Reply-To: <9158500.1172278505677.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/DERBY-2375?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12478197 ] 

A B commented on DERBY-2375:
----------------------------

 - jdbcapi/users2.sql: Looks like a connection is being established when it is supposed to fail:

  --
  -- some negative cases
  --
  -- Invalid login's
  connect 'wombat';    <-- this apparently succeeds with weme6.1?

    - jdbcapi/secureUsers.sql (weme6.1): DERBY-2375 -- Shutdown supposed to fail but does not.

  205c205
  ij> -- Database shutdown - check user - should fail
  connect 'derbySchemeDB;shutdown=true';
  < ERROR 08004: Connection refused : Invalid authentication.
  ---
  > ERROR 08006: Database 'derbySchemeDB' shutdown.


> jdbcapi/users2.sql and jdbcapi/secureUsers.sql fails on IBM weme 6.1
> --------------------------------------------------------------------
>
>                 Key: DERBY-2375
>                 URL: https://issues.apache.org/jira/browse/DERBY-2375
>             Project: Derby
>          Issue Type: Bug
>          Components: Test
>    Affects Versions: 10.3.0.0
>         Environment: Windows
>            Reporter: Rajesh Kartha
>             Fix For: 10.3.0.0
>
>
> With :  10.3.0.0 alpha - (510766) I noticed the jdbcapi/users2.sql and jdbcapi/secureUsers.sql fails on IBM weme 6.1. The following are the diffs:
> *** Start: secureUsers jdkJ2ME Foundation Specification v1.1 derbyall:jdbcapi 2007-02-23 05:21:01 ***
> 204a205,221
> > ERROR 08006: Database 'derbySchemeDB' shutdown.
> > ij> show connections;
> > No connections available.
> > ij> -- Database shutdown - check user - should succeed
> > connect 'guestSchemeDB;user=kreg;password=IwasBornReady;shutdown=true';
> > ERROR 08006: Database 'guestSchemeDB' shutdown.
> > ij> -- Database shutdown - authenticated, so must use owner
> > connect 'wombat;user=system;password=manager;shutdown=true';
> > ERROR 08006: Database 'wombat' shutdown.
> > ij> connect 'derbySchemeDB;user=system;password=manager;shutdown=true';
> > ERROR XJ004: Database 'derbySchemeDB' not found.
> > ij> connect 'simpleSchemeDB;user=system;password=manager;shutdown=true';
> > ERROR 08006: Database 'simpleSchemeDB' shutdown.
> > ij> show connections;
> > No connections available.
> > ij> -- Derby system shutdown - check user - should fail
> > connect ';user=jamie;password=LetMeIn;shutdown=true';
> 206,222d222
> < ij> show connections;
> < No connections available.
> < ij> -- Database shutdown - check user - should succeed
> < connect 'guestSchemeDB;user=kreg;password=IwasBornReady;shutdown=true';
> < ERROR 08006: Database 'guestSchemeDB' shutdown.
> < ij> -- Database shutdown - authenticated, so must use owner
> < connect 'wombat;user=system;password=manager;shutdown=true';
> < ERROR 08006: Database 'wombat' shutdown.
> < ij> connect 'derbySchemeDB;user=system;password=manager;shutdown=true';
> < ERROR 08006: Database 'derbySchemeDB' shutdown.
> < ij> connect 'simpleSchemeDB;user=system;password=manager;shutdown=true';
> < ERROR 08006: Database 'simpleSchemeDB' shutdown.
> < ij> show connections;
> < No connections available.
> < ij> -- Derby system shutdown - check user - should fail
> < connect ';user=jamie;password=LetMeIn;shutdown=true';
> < ERROR 08004: Connection refused : Invalid authentication.
> Test Failed.
> *** End:   secureUsers jdkJ2ME Foundation Specification v1.1 derbyall:jdbcapi 2007-02-23 05:21:28 ***
> *** Start: users2 jdkJ2ME Foundation Specification v1.1 derbyall:jdbcapi 2007-02-23 05:20:46 ***
> 205a206
> > ij> connect 'wombat;user=badUser1;password=YeeHa!';
> 207,208d207
> < ij> connect 'wombat;user=badUser1;password=YeeHa!';
> < ERROR 08004: Connection refused : Invalid authentication.
> 223 del
> < ij> -- users only defined at system level; not allowed:
> 223a222
> > ij(CONNECTION1)> -- users only defined at system level; not allowed:
> 226 del
> < ij> connect 'wombat;user=mickey;password=mouse';
> 226a225
> > ij(CONNECTION1)> connect 'wombat;user=mickey;password=mouse';
> 227a227,245
> > ij(CONNECTION1)> show connections;
> > CONNECTION0
> > CONNECTION1*
> > * = current connection
> > ij(CONNECTION1)> connect 'wombat;user=francois;password=paceesalute';
> > ij(CONNECTION2)> connect 'myDB;user=jerry;password=SacreBleu';
> > ij(CONNECTION3)> -- Database shutdown - check user - should fail
> > connect 'myDB;shutdown=true';
> > ERROR 08006: Database 'myDB' shutdown.
> > ij(CONNECTION3)> connect 'myDB;user=jamie;password=LetMeIn;shutdown=true';
> > ERROR XJ004: Database 'myDB' not found.
> > ij(CONNECTION3)> connect 'wombat;user=jerry;password=SacreBleu;shutdown=true';
> > ERROR 08004: Connection refused : Invalid authentication.
> > ij(CONNECTION3)> show connections;
> > CONNECTION0
> > CONNECTION1
> > CONNECTION2
> > No current connection
> > ij> disconnect all;
> 229,246d246
> < CONNECTION0*
> < * = current connection
> < ij> connect 'wombat;user=francois;password=paceesalute';
> < ij(CONNECTION1)> connect 'myDB;user=jerry;password=SacreBleu';
> < ij(CONNECTION2)> -- Database shutdown - check user - should fail
> < connect 'myDB;shutdown=true';
> < ERROR 08004: Connection refused : Invalid authentication.
> < ij(CONNECTION2)> connect 'myDB;user=jamie;password=LetMeIn;shutdown=true';
> < ERROR 08004: Connection refused : Invalid authentication.
> < ij(CONNECTION2)> connect 'wombat;user=jerry;password=SacreBleu;shutdown=true';
> < ERROR 08004: Connection refused : Invalid authentication.
> < ij(CONNECTION2)> show connections;
> < CONNECTION0
> < CONNECTION1
> < CONNECTION2*
> < * = current connection
> < ij(CONNECTION2)> disconnect all;
> < ij> show connections;
> 258 del
> < ERROR 2850H: User 'JERRY' cannot shut down database 'myDB'. Only the database owner can perform this operation.
> 258a258
> > ERROR XJ004: Database 'myDB' not found.
> 261 del
> < ERROR 08006: Database 'myDB' shutdown.
> 261a261
> > ERROR XJ004: Database 'myDB' not found.
> Test Failed.
> *** End:   users2 jdkJ2ME Foundation Specification v1.1 derbyall:jdbcapi 2007-02-23 05:21:00 ***

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.