Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (herse.apache.org: local policy)
Date: Wed, 27 Jun 2007 08:32:16 -0700
From: Martin Zaun <Martin.Zaun@Sun.COM>
Subject: Re: How to shutdown with authentication
In-reply-to: <468208E6.9050001@Sun.COM>
Sender: Martin.Zaun@Sun.COM
To: Derby Discussion <derby-user@db.apache.org>
Message-id: <46828300.2060506@sun.com>
Organization: Sun Microsystems, Inc.
MIME-version: 1.0
Content-type: text/plain; format=flowed; charset=us-ascii
Content-transfer-encoding: 7BIT
References: <200706261042.02676.sitongia@ucar.edu> <468208E6.9050001@Sun.COM>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.13)
 Gecko/20060414


There's been a discussion of this topic on derby-dev.  Subject:
   NetworkServerControl shutdown w/ authentication failing?

My summary so far:
- 'NetworkServerControl shutdown' (stopNetworkServer) doesn't support
   authentication yet (warning during datbase shutdown); yet, it shuts
   down the server process (may need to run recovery upon next database
   boot).
- Shutdown from ij (shutdown property in URL), for example,
     connect 'jdbc:derby://localhost:1527/;shutdown=true;user=MARTIN;password=martinspassword';
   seems to support authentication and properly shuts down the engine
   but keeps the server process running.

We're about to open a JIRA on this for further discussion.
Martin

John Embretsen wrote:
> Leonard Sitongia wrote:
> 
>> Hello,
>>
>> I've enabled user connection authentication in my standalone network 
>> derby server on Linux.  I think that one of the manuals said that in 
>> this case the stopNetworkServer should be configured to use 
>> authentication.  But, I don't see how do to this.  Any, searching the 
>> documents mailing list seems to suggest that it cannot be done, but 
>> needs to be done in order to make the startup cleaner the next time.
> 
> 
> The only place I know of in the manuals that covers this is in the Derby 
> Server and Administration guide, in the section called "Shutting down 
> the Network Server", which says:
> 
> "If user authentication is enabled, you must explicitly shut down the 
> database before shutting down the Network Server by specifying a valid 
> Derby user name and password."
> 
> This means that one should shut down the database from a Java app or ij 
> before running the server shutdown command in order to do a clean shutdown.
> 
> If you have a reference to a place in the manuals saying that the 
> stopNetworkServer script should be configured in the case of user 
> authentication, please let me know.
> 
> Thanks,
> 
>