db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sonny Laskar <sonny.las...@tcs.com>
Subject Re: ERROR 08004: Connection refused : Invalid authentication.
Date Mon, 29 Nov 2010 09:30:33 GMT
<FONT face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size=2>Dear Kristian,<br>I
am using 10.3.<br><div><br></div><div><br>Regards,<br>Sonny
Laskar<br>Tata Consultancy Services<br>Mailto: <a href="mailto:sonny.laskar@tcs.com">sonny.laskar@tcs.com</a><br>Website:
<a href="http://www.tcs.com">http://www.tcs.com</a><br>____________________________________________<br>Experience
certainty.	IT Services<br>			Business Solutions<br>			Outsourcing<br>____________________________________________<br><div><br></div><font
color="#990099">-----Kristian Waagan &lt;kristian.waagan@oracle.com&gt; wrote:
-----<br><br></font><blockquote style="padding-right: 0px; padding-left:
5px; margin-left: 5px; border-left: 2px solid #000000; margin-right: 0px;">To: derby-user@db.apache.org<br>From:
Kristian Waagan &lt;kristian.waagan@oracle.com&gt;<br>Date: 11/29/2010 02:54PM<br>Subject:
Re: ERROR 08004: Connection refused : Invalid authentication.<br><br><font
face="Courier New,Courier,monospace" size="3">&nbsp;&nbsp;On 29.11.10 09:32, Sonny
Laskar wrote:<br>&gt; Dear Thomas,<br>&gt; Thanks for your inputs.<br>&gt;
I am not much familiar with the APIs.<br>&gt;<br>&gt; Let me tell you
how I am proceeding:<br>&gt; 1. I have copied the database folder "hatterastc" from
the server to <br>&gt; my PC.(This database is embedded in 1 application.)<br>&gt;
2. I get the error when I execute the following command:<br>&gt; ij&gt; connect
'jdbc:derby:hatterastc';<br>&gt; ERROR 08004: Connection refused : Invalid authentication.<br>&gt;<br>&gt;
I suppose the CALL command can be executed only after connecting to a <br>&gt; database.<br>&gt;
I have a Windows System and using the ij prompt from the cmd.<br>&gt; Please let
me know how to reset the password from the ij prompt.<br><br>Hi Sonny,<br><br>Can
you please specify which version of Derby you are using? I.e., is it <br>10.1 or maybe
10.5?<br>(10.0 was released in 2004, 10.6 in 2010)<br><br>Now, resetting
the password isn't supposed to be easy, as it would <br>defeat the purpose of authentication.<br>Except
from connecting as the system user (which may very well be the <br>user you have forgotten
the credentials for), I'm not aware of any way <br>to reset the password for a user
for which you don't have the password.<br><br>Unless the system security has been
configured using derby.properties <br>(which isn't recommended because it is a weak
mechanism), I don't know <br>how to help.<br><br><br>Regards,<br>--
<br>Kristian<br><br>&gt;<br>&gt; Thanks again.<br>&gt;<br>&gt;
Regards,<br>&gt; Sonny Laskar<br>&gt; India<br>&gt; ____________________________________________<br>&gt;<br>&gt;
-----Thomas &lt;Thomas.K.Hill@t-online.de&gt; wrote: -----<br>&gt;<br>&gt;
&nbsp; &nbsp; To: derby-user@db.apache.org<br>&gt; &nbsp; &nbsp;
From: Thomas &lt;Thomas.K.Hill@t-online.de&gt;<br>&gt; &nbsp; &nbsp;
Date: 11/29/2010 01:23PM<br>&gt; &nbsp; &nbsp; Subject: Re: ERROR 08004:
Connection refused : Invalid authentication.<br>&gt;<br>&gt; &nbsp;
&nbsp; Sonny Laskar &lt;sonny.laskar@...&gt; writes:<br>&gt;<br>&gt;
&nbsp; &nbsp; &gt;<br>&gt; &nbsp; &nbsp; &gt;<br>&gt;
&nbsp; &nbsp; &gt; Dear All,I am new to Derby.I have forgotten the<br>&gt;
&nbsp; &nbsp; username/password set for<br>&gt; &nbsp; &nbsp; connecting
to my derby database.Now when I tried to connect , i<br>&gt; &nbsp; &nbsp;
get the invalid<br>&gt; &nbsp; &nbsp; authentication error (ERROR 08004:
Connection refused : Invalid<br>&gt; &nbsp; &nbsp; authentication.)Please
let me know if I can reset this password or<br>&gt; &nbsp; &nbsp; if I can<br>&gt;
&nbsp; &nbsp; create a new user.Also I want to know that if I want to create the<br>&gt;
&nbsp; &nbsp; clone of a<br>&gt; &nbsp; &nbsp; derby database ,
can I just copy the folder and use<br>&gt; &nbsp; &nbsp; it?Regards,Sonny
LaskarIndia<br>&gt; &nbsp; &nbsp; &gt; =====-----=====-----=====Notice:
The information contained in this<br>&gt; &nbsp; &nbsp; e-mailmessage and/or
attachments to it may contain confidential or<br>&gt; &nbsp; &nbsp; privileged<br>&gt;
&nbsp; &nbsp; information. If you are not the intended recipient, any<br>&gt;
&nbsp; &nbsp; dissemination, use,<br>&gt; &nbsp; &nbsp; review,
distribution, printing or copying of the information<br>&gt; &nbsp; &nbsp;
contained in this<br>&gt; &nbsp; &nbsp; e-mail message and/or attachments
to it are strictly prohibited.<br>&gt; &nbsp; &nbsp; If you have<br>&gt;
&nbsp; &nbsp; received this communication in error, please notify us by reply<br>&gt;
&nbsp; &nbsp; e-mail or<br>&gt; &nbsp; &nbsp; telephone and immediately
and permanently delete the message and any<br>&gt; &nbsp; &nbsp; attachments.
Thank you<br>&gt; &nbsp; &nbsp; &gt;<br>&gt;<br>&gt;
&nbsp; &nbsp; login in with your data base owner account you can reset the<br>&gt;
&nbsp; &nbsp; password of a user<br>&gt; &nbsp; &nbsp; by calling<br>&gt;
&nbsp; &nbsp; SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.user.&lt;username&gt;'
with<br>&gt; &nbsp; &nbsp; an empty password as the second parameter passed.
Assuming you are<br>&gt; &nbsp; &nbsp; using the<br>&gt; &nbsp;
&nbsp; builtin authentication provider. With the same stored procedure<br>&gt;
&nbsp; &nbsp; you can also<br>&gt; &nbsp; &nbsp; create new users.
(see reference guie on page 327 for details on<br>&gt; &nbsp; &nbsp; this
system<br>&gt; &nbsp; &nbsp; built-in stored procedure)<br>&gt;<br>&gt;
&nbsp; &nbsp; To your second question: Yes, to clone a database you can just<br>&gt;
&nbsp; &nbsp; copy the folder.<br>&gt;<br>&gt;<br>&gt;<br>&gt;
=====-----=====-----=====<br>&gt; Notice: The information contained in this e-mail<br>&gt;
message and/or attachments to it may contain<br>&gt; confidential or privileged
information. If you are<br>&gt; not the intended recipient, any dissemination, use,<br>&gt;
review, distribution, printing or copying of the<br>&gt; information contained in
this e-mail message<br>&gt; and/or attachments to it are strictly prohibited. If<br>&gt;
you have received this communication in error,<br>&gt; please notify us by reply
e-mail or telephone and<br>&gt; immediately and permanently delete the message<br>&gt;
and any attachments. Thank you<br>&gt;<br>&gt;<br><br></font>
</blockquote><br></div></FONT><pre style="white-space:normal">=====-----=====-----=====<br>Notice:
The information contained in this e-mail<br>message and/or attachments to it may contain
<br>confidential or privileged information. If you are <br>not the intended recipient,
any dissemination, use, <br>review, distribution, printing or copying of the <br>information
contained in this e-mail message <br>and/or attachments to it are strictly prohibited.
If <br>you have received this communication in error, <br>please notify us by
reply e-mail or telephone and <br>immediately and permanently delete the message <br>and
any attachments. Thank you<br><br><br></pre>

Mime
View raw message