[
https://issues.apache.org/jira/browse/DERBY-2375?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Myrna van Lunteren closed DERBY-2375.
-------------------------------------
Resolution: Fixed
removed users2 and secureUsers with revision 522923.
> 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
> Assigned To: Myrna van Lunteren
> 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.
