Re: Connection authentication failure occurred. Reason: Invalid authentication..

2017-05-30 Thread Peter Ondruška 
Dear Rick,

well, that is why it is strange because I am very certain I use correct
username and password to connect and the data from database can be
accessed. Yes, NATIVE credentials are stored in the database itself. There
are no other errors or warnings besides this one.

Peter

On 29 May 2017 at 19:26, Rick Hillegas  wrote:

> Hi Peter,
>
> This is the error which Derby raises when the user presents invalid
> credentials at connection time. Are you confident that correct credentials
> were given? Are the NATIVE credentials stored in the database being
> connected to? Or are they stored in a system-wide credentials database?
> What other errors appear in the diagnostic log prior to this error?
>
> Thanks,
> -Rick
>
>
> On 5/29/17 12:12 AM, Peter Ondruška wrote:
>
> Hello,
>
> I am facing strange situation with 10.13.1.1. This error is logged when
> load against Derby is higher than usuall:
>
> ***
> Mon May 29 08:31:10 CEST 2017 Thread[DRDAConnThread_27,5,main] (XID =
> 74907526), (SESSIONID = 22748), (DATABASE = /*removed*/), (DRDAID =
> .-43515881796
> 1723857{1069}), Cleanup action starting
> java.sql.SQLNonTransientConnectionException: Connection authentication
> failure occurred.  Reason: Invalid authentication..
> at 
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
> Source)
> at 
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown
> Source)
> at 
> org.apache.derby.impl.jdbc.EmbedConnection.checkUserCredentials(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.(Unknown
> Source)
> at org.apache.derby.jdbc.InternalDriver$1.run(Unknown Source)
> at org.apache.derby.jdbc.InternalDriver$1.run(Unknown Source)
> at java.security.AccessController.doPrivileged(
> AccessController.java:650)
> at org.apache.derby.jdbc.InternalDriver.getNewEmbedConnection(Unknown
> Source)
> at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
> at 
> org.apache.derby.jdbc.BasicEmbeddedDataSource40.getConnection(Unknown
> Source)
> at 
> org.apache.derby.jdbc.EmbedPooledConnection.openRealConnection(Unknown
> Source)
> at org.apache.derby.jdbc.EmbedXAConnection.getRealConnection(Unknown
> Source)
> at 
> org.apache.derby.iapi.jdbc.BrokeredConnection.getRealConnection(Unknown
> Source)
> at org.apache.derby.iapi.jdbc.BrokeredConnection.isClosed(Unknown
> Source)
> at 
> org.apache.derby.impl.drda.PiggyBackedSessionData.getInstance(Unknown
> Source)
> at 
> org.apache.derby.impl.drda.Database.getPiggyBackedSessionData(Unknown
> Source)
> at org.apache.derby.impl.drda.DRDAConnThread.writePBSD(Unknown
> Source)
> at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown
> Source)
> at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
> Caused by: ERROR 08004: Connection authentication failure occurred.
> Reason: Invalid authentication..
> at org.apache.derby.iapi.error.StandardException.newException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.SQLExceptionFactory.
> wrapArgsForTransportAcrossDRDA(Unknown Source)
> ... 22 more
> = begin nested exception, level (1) ===
> ERROR 08004: Connection authentication failure occurred.  Reason: Invalid
> authentication..
> at org.apache.derby.iapi.error.StandardException.newException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.SQLExceptionFactory.
> wrapArgsForTransportAcrossDRDA(Unknown Source)
> at 
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
> Source)
> at 
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown
> Source)
> at 
> org.apache.derby.impl.jdbc.EmbedConnection.checkUserCredentials(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.(Unknown
> Source)
> at org.apache.derby.jdbc.InternalDriver$1.run(Unknown Source)
> at org.apache.derby.jdbc.InternalDriver$1.run(Unknown Source)
> at java.security.AccessController.doPrivileged(
> AccessController.java:650)
> at org.apache.derby.jdbc.InternalDriver.getNewEmbedConnection(Unknown
> Source)
> at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
> at 
>

Re: Connection authentication failure occurred. Reason: Invalid authentication..

2017-05-29 Thread Rick Hillegas 

Hi Peter,

This is the error which Derby raises when the user presents invalid 
credentials at connection time. Are you confident that correct 
credentials were given? Are the NATIVE credentials stored in the 
database being connected to? Or are they stored in a system-wide 
credentials database? What other errors appear in the diagnostic log 
prior to this error?


Thanks,
-Rick

On 5/29/17 12:12 AM, Peter Ondruška wrote:

Hello,

I am facing strange situation with 10.13.1.1. This error is logged 
when load against Derby is higher than usuall:


***
Mon May 29 08:31:10 CEST 2017 Thread[DRDAConnThread_27,5,main] (XID = 
74907526), (SESSIONID = 22748), (DATABASE = /*removed*/), (DRDAID = 
.-43515881796

1723857{1069}), Cleanup action starting
java.sql.SQLNonTransientConnectionException: Connection authentication 
failure occurred.  Reason: Invalid authentication..
at 
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown 
Source)
at 
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown 
Source)
at 
org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at 
org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at 
org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)
at 
org.apache.derby.impl.jdbc.EmbedConnection.checkUserCredentials(Unknown 
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.(Unknown 
Source)

at org.apache.derby.jdbc.InternalDriver$1.run(Unknown Source)
at org.apache.derby.jdbc.InternalDriver$1.run(Unknown Source)
at 
java.security.AccessController.doPrivileged(AccessController.java:650)
at 
org.apache.derby.jdbc.InternalDriver.getNewEmbedConnection(Unknown Source)

at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
at 
org.apache.derby.jdbc.BasicEmbeddedDataSource40.getConnection(Unknown 
Source)
at 
org.apache.derby.jdbc.EmbedPooledConnection.openRealConnection(Unknown 
Source)
at 
org.apache.derby.jdbc.EmbedXAConnection.getRealConnection(Unknown Source)
at 
org.apache.derby.iapi.jdbc.BrokeredConnection.getRealConnection(Unknown 
Source)
at 
org.apache.derby.iapi.jdbc.BrokeredConnection.isClosed(Unknown Source)
at 
org.apache.derby.impl.drda.PiggyBackedSessionData.getInstance(Unknown 
Source)
at 
org.apache.derby.impl.drda.Database.getPiggyBackedSessionData(Unknown 
Source)
at org.apache.derby.impl.drda.DRDAConnThread.writePBSD(Unknown 
Source)
at 
org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Source)

at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
Caused by: ERROR 08004: Connection authentication failure occurred.  
Reason: Invalid authentication..
at 
org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at 
org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown 
Source)

... 22 more
= begin nested exception, level (1) ===
ERROR 08004: Connection authentication failure occurred. Reason: 
Invalid authentication..
at 
org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at 
org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown 
Source)
at 
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown 
Source)
at 
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown 
Source)
at 
org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at 
org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at 
org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)
at 
org.apache.derby.impl.jdbc.EmbedConnection.checkUserCredentials(Unknown 
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.(Unknown 
Source)

at org.apache.derby.jdbc.InternalDriver$1.run(Unknown Source)
at org.apache.derby.jdbc.InternalDriver$1.run(Unknown Source)
at 
java.security.AccessController.doPrivileged(AccessController.java:650)
at 
org.apache.derby.jdbc.InternalDriver.getNewEmbedConnection(Unknown Source)

at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
at 
org.apache.derby.jdbc.BasicEmbeddedDataSource40.getConnection(Unknown 
Source)
at 
org.apache.derby.jdbc.EmbedPooledConnection.openRealConnection(Unknown 
Source)
at 
org.apache.derby.jdbc.EmbedXAConnection.getRealConnection(Unknown Source)
at 
org.apache.derby.iapi.jdbc.BrokeredConnection.getRealConnection(Unknown 
Source)
at 
org.apache.derby.iapi.jdbc.BrokeredConnection.isClosed(Unknown Source)
at 
org.apache.derby.impl.drda.PiggyBackedSessionData.getInstance(Unknown 
Source)
at