Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <659278146.1219471004607.JavaMail.jira@brutus>
Date: Fri, 22 Aug 2008 22:56:44 -0700 (PDT)
From: =?utf-8?Q?Antonio_S=C3=A1nchez_=28JIRA=29?= <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Created: (DERBY-3848) dblook fails to connect an
 authenticated database
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

dblook fails to connect an authenticated database
-------------------------------------------------

                 Key: DERBY-3848
                 URL: https://issues.apache.org/jira/browse/DERBY-3848
             Project: Derby
          Issue Type: Bug
          Components: Tools
    Affects Versions: 10.4.1.3
         Environment: antonio@antonio-laptop:~/temp/derby$ sysinfo
----------------- Informaci=C3=B3n de Java ----------------
Versi=C3=B3n de Java:     1.6.0_06
Proveedor de Java:   Sun Microsystems Inc.
Inicio Java:         /usr/lib/jvm/java-6-sun-1.6.0.06/jre
Classpath de Java:   /usr/local/db-derby-10.4.1.3-bin/lib/derby.jar:/usr/lo=
cal/db-derby-10.4.1.3-bin/lib/derbynet.jar:/usr/local/db-derby-10.4.1.3-bin=
/lib/derbytools.jar:/usr/local/db-derby-10.4.1.3-bin/lib/derbyclient.jar
Nombre del SO:       Linux
Arquitectura del SO: i386
Versi=C3=B3n del SO:      2.6.24-19-generic
Nombre usuario Java: antonio
Dir. inicial usuario:/home/antonio
Dir. usuario:        /home/antonio/temp/derby
java.specification.name: Java Platform API Specification
java.specification.version: 1.6
--------- Informaci=C3=B3n de Derby --------
JRE - JDBC: Java SE 6 - JDBC 4.0
[/usr/local/db-derby-10.4.1.3-bin/lib/derby.jar] 10.4.1.3 - (648739)
[/usr/local/db-derby-10.4.1.3-bin/lib/derbytools.jar] 10.4.1.3 - (648739)
[/usr/local/db-derby-10.4.1.3-bin/lib/derbynet.jar] 10.4.1.3 - (648739)
[/usr/local/db-derby-10.4.1.3-bin/lib/derbyclient.jar] 10.4.1.3 - (648739)
------------------------------------------------------
-------------- Informaci=C3=B3n de entorno local ----------
Entorno local actual:  [espa=C3=B1ol/Espa=C3=B1a [es_ES]]
Se encontr=C3=B3 soporte para el entorno local: [cs]
=09 versi=C3=B3n: 10.4.1.3 - (648739)
Se encontr=C3=B3 soporte para el entorno local: [de_DE]
=09 versi=C3=B3n: 10.4.1.3 - (648739)
Se encontr=C3=B3 soporte para el entorno local: [es]
=09 versi=C3=B3n: 10.4.1.3 - (648739)
Se encontr=C3=B3 soporte para el entorno local: [fr]
=09 versi=C3=B3n: 10.4.1.3 - (648739)
Se encontr=C3=B3 soporte para el entorno local: [hu]
=09 versi=C3=B3n: 10.4.1.3 - (648739)
Se encontr=C3=B3 soporte para el entorno local: [it]
=09 versi=C3=B3n: 10.4.1.3 - (648739)
Se encontr=C3=B3 soporte para el entorno local: [ja_JP]
=09 versi=C3=B3n: 10.4.1.3 - (648739)
Se encontr=C3=B3 soporte para el entorno local: [ko_KR]
=09 versi=C3=B3n: 10.4.1.3 - (648739)
Se encontr=C3=B3 soporte para el entorno local: [pl]
=09 versi=C3=B3n: 10.4.1.3 - (648739)
Se encontr=C3=B3 soporte para el entorno local: [pt_BR]
=09 versi=C3=B3n: 10.4.1.3 - (648739)
Se encontr=C3=B3 soporte para el entorno local: [ru]
=09 versi=C3=B3n: 10.4.1.3 - (648739)
Se encontr=C3=B3 soporte para el entorno local: [zh_CN]
=09 versi=C3=B3n: 10.4.1.3 - (648739)
Se encontr=C3=B3 soporte para el entorno local: [zh_TW]
=09 versi=C3=B3n: 10.4.1.3 - (648739)
------------------------------------------------------

            Reporter: Antonio S=C3=A1nchez
            Priority: Minor


dblook is not connecting an authenticated database.

I create an authenticated database this way:

1. ij
2. connect 'jdbc:derby:dblooktest;create=3Dtrue;user=3Dtest;password=3Dtest=
';
3. CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.connection.requireAut=
hentication','true');
4. CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.user.test', 'test');
5. CREATE TABLE DBLOOKTESTTABLE(I INT NOT NULL PRIMARY KEY);
6. disconnect;
7. quit;

And use dblook this way:

8. dblook -d 'jdbc:derby:dblooktest;user=3Dtest;password=3Dtest';

Then an error is reported (dblook.log contents are at the end of this descr=
iption);

Nevertheless, if I do not require authentication:

9. CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.connection.requireAut=
hentication','false');

Then dblook works properly:

10. dblook -d 'jdbc:derby:dblooktest;user=3Dtest;password=3Dtest';=20
11. dblook -d 'jdbc:derby:dblooktest';=20

Thus, the same connection url that works in ij for an authenticated databas=
e does not in dblook.


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D dblook.log

java.sql.SQLNonTransientConnectionException: Se ha producido una anomal=C3=
=ADa de autenticaci=C3=B3n de conexi=C3=B3n.  Raz=C3=B3n: Autenticaci=C3=B3=
n no v=C3=A1lida..
=09at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unkn=
own Source)
=09at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
=09at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
=09at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source=
)
=09at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown So=
urce)
=09at org.apache.derby.impl.jdbc.EmbedConnection.checkUserCredentials(Unkno=
wn Source)
=09at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
=09at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
=09at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source)
=09at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)
=09at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
=09at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
=09at java.sql.DriverManager.getConnection(DriverManager.java:582)
=09at java.sql.DriverManager.getConnection(DriverManager.java:207)
=09at org.apache.derby.tools.dblook.go(Unknown Source)
=09at org.apache.derby.tools.dblook.<init>(Unknown Source)
=09at org.apache.derby.tools.dblook.main(Unknown Source)
Caused by: java.sql.SQLException: Se ha producido una anomal=C3=ADa de aute=
nticaci=C3=B3n de conexi=C3=B3n.  Raz=C3=B3n: Autenticaci=C3=B3n no v=C3=A1=
lida..
=09at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknow=
n Source)
=09at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransport=
AcrossDRDA(Unknown Source)
=09... 17 more
-- **--> DEBUG: Se ha producido una anomal=C3=ADa de autenticaci=C3=B3n de =
conexi=C3=B3n.  Raz=C3=B3n: Autenticaci=C3=B3n no v=C3=A1lida..


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