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


    [ https://issues.apache.org/jira/browse/DERBY-3848?page=3Dcom.atlassian=
.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D1262=
6156#action_12626156 ]=20

antodasana edited comment on DERBY-3848 at 8/27/08 8:46 AM:
-----------------------------------------------------------------

Just tried at different system with same results, although they are both Ub=
untu 8.04.1 (2.6.24-19-generic). Not yet tried in Windows.

COMMENT UPDATE >>>>>

Works in Windows Home, java hotspot 1.6.0_04, derby 10.3.2.1 and 10.4.1.3.


      was (Author: antodasana):
    Just tried at different system with same results, although they are bot=
h Ubuntu 8.04.1 (2.6.24-19-generic). Not yet tried in Windows.
 =20
> 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/=
local/db-derby-10.4.1.3-bin/lib/derbynet.jar:/usr/local/db-derby-10.4.1.3-b=
in/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
>         Attachments: dblook.log, derby.log, test.sh
>
>
> 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=3Dte=
st';
> 3. CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.connection.requireA=
uthentication','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 des=
cription);
> Nevertheless, if I do not require authentication:
> 9. CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.connection.requireA=
uthentication','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 datab=
ase 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=
=B3n no v=C3=A1lida..
> =09at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Un=
known 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 Sour=
ce)
> =09at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown =
Source)
> =09at org.apache.derby.impl.jdbc.EmbedConnection.checkUserCredentials(Unk=
nown 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 au=
tenticaci=C3=B3n de conexi=C3=B3n.  Raz=C3=B3n: Autenticaci=C3=B3n no v=C3=
=A1lida..
> =09at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unkn=
own Source)
> =09at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTranspo=
rtAcrossDRDA(Unknown Source)
> =09... 17 more
> -- **--> DEBUG: Se ha producido una anomal=C3=ADa de autenticaci=C3=B3n d=
e 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.