On 29.11.10 09:32, Sonny Laskar wrote:
Dear Thomas,
Thanks for your inputs.
I am not much familiar with the APIs.
Let me tell you how I am proceeding:
1. I have copied the database folder "hatterastc" from the server to
my PC.(This database is embedded in 1 application.)
2. I get the error when I execute the following command:
ij> connect 'jdbc:derby:hatterastc';
ERROR 08004: Connection refused : Invalid authentication.
I suppose the CALL command can be executed only after connecting to a
database.
I have a Windows System and using the ij prompt from the cmd.
Please let me know how to reset the password from the ij prompt.
Hi Sonny,
Can you please specify which version of Derby you are using? I.e., is it
10.1 or maybe 10.5?
(10.0 was released in 2004, 10.6 in 2010)
Now, resetting the password isn't supposed to be easy, as it would
defeat the purpose of authentication.
Except from connecting as the system user (which may very well be the
user you have forgotten the credentials for), I'm not aware of any way
to reset the password for a user for which you don't have the password.
Unless the system security has been configured using derby.properties
(which isn't recommended because it is a weak mechanism), I don't know
how to help.
Regards,
--
Kristian
Thanks again.
Regards,
Sonny Laskar
India
____________________________________________
-----Thomas <thomas.k.h...@t-online.de> wrote: -----
To: derby-user@db.apache.org
From: Thomas <thomas.k.h...@t-online.de>
Date: 11/29/2010 01:23PM
Subject: Re: ERROR 08004: Connection refused : Invalid authentication.
Sonny Laskar <sonny.las...@...> writes:
>
>
> Dear All,I am new to Derby.I have forgotten the
username/password set for
connecting to my derby database.Now when I tried to connect , i
get the invalid
authentication error (ERROR 08004: Connection refused : Invalid
authentication.)Please let me know if I can reset this password or
if I can
create a new user.Also I want to know that if I want to create the
clone of a
derby database , can I just copy the folder and use
it?Regards,Sonny LaskarIndia
> =====-----=====-----=====Notice: The information contained in this
e-mailmessage and/or attachments to it may contain confidential or
privileged
information. If you are not the intended recipient, any
dissemination, use,
review, distribution, printing or copying of the information
contained in this
e-mail message and/or attachments to it are strictly prohibited.
If you have
received this communication in error, please notify us by reply
e-mail or
telephone and immediately and permanently delete the message and any
attachments. Thank you
>
login in with your data base owner account you can reset the
password of a user
by calling
SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.user.<username>' with
an empty password as the second parameter passed. Assuming you are
using the
builtin authentication provider. With the same stored procedure
you can also
create new users. (see reference guie on page 327 for details on
this system
built-in stored procedure)
To your second question: Yes, to clone a database you can just
copy the folder.
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you