db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-1387) Add JMX extensions to Derby
Date Tue, 05 Feb 2008 17:46:08 GMT

    [ https://issues.apache.org/jira/browse/DERBY-1387?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12565832#action_12565832

Rick Hillegas commented on DERBY-1387:

Thanks for the updated spec, John. I brought up a Derby server with the JMX beans enabled
and I ran JConsole against it. Here are some initial reactions:

1) I was pleased that the Sun JMX properties worked with my Apple VM.

2) I brought up the server with authentication enabled but I didn't have to supply credentials
in order to view the NetworkServer and System MBeans. That seems wrong to me. The Version
MBean was also viewable but that seems ok to me.

3) I was able to change properties in the NetworkServer MBean--at least my changes were accepted
on the screen. However, when I tried to change properties in the System MBean, I was slapped
with an "access denied (java.util.PropertyPermission * read,write)" diagnostic.

4) Using the System MBean, it seemed that I was able to boot an existing database and then
access its MBean. Again, without supplying credentials, this seemed wrong to me. Most of the
properties were listed as "Unavailable".

5) Using the System MBean, I tried to boot a nonexistent database. This gave me the following

Problem invoking bootDatabase: java.rmi.UnmarshalException: Error unmarshaling return: nested
exception is:
java.lang.ClassNotFoundException: org.apache.derby.impl.jdbc.EmbedSQLException (no security
manager: RMI class loader disabled)

6) I saw the same diagnostic when I used the System MBean to boot an encrypted database.

7) I saw a similar diagnostic when I tried to create a user via the MBean for the existing

8) When I invoked the shutdown operation on the System MBean, I saw the following diagnostic:

Problem invoking shutdown: java.rmi.UnmarshalException: Error unmarshaling return header;
nested exception is:

9) However, after dismissing the diagnostic windows, the MBeans disappeared from the screen
and I was presented with a blank JConsole window with only a "Connection" menu item in the
menu bar.  However, I was unable to connect via that menu item.

For the record, this is the startup command which I used to boot the server:

java -Dderby.connection.requireAuthentication=true \
  -Dderby.authentication.provider=BUILTIN \
  -Dderby.user.\"rick\"=rickspassword \
  -Dderby.database.sqlAuthorization=true \
  -Dcom.sun.management.jmxremote.port=1528 \
  -Dcom.sun.management.jmxremote.authenticate=false \
  -Dcom.sun.management.jmxremote.ssl=false \
  -Dderby.system.jmx=true \
  org.apache.derby.drda.NetworkServerControl start -p 8246

and this is the command which I used to boot JConsole:

jconsole 1735


> Add JMX extensions to Derby
> ---------------------------
>                 Key: DERBY-1387
>                 URL: https://issues.apache.org/jira/browse/DERBY-1387
>             Project: Derby
>          Issue Type: New Feature
>          Components: Services
>            Reporter: Sanket Sharma
>            Assignee: John H. Embretsen
>         Attachments: DERBY-1387-1.diff, DERBY-1387-1.stat, DERBY-1387-2.diff, DERBY-1387-2.stat,
DERBY-1387-3.diff, DERBY-1387-3.stat, DERBY-1387-4.diff, DERBY-1387-4.stat, DERBY-1387-5.diff,
DERBY-1387-5.stat, DERBY-1387-6.zip, DERBY-1387-7.zip, DERBY-1387-8.zip, DERBY-1387-9.diff,
DERBY-1387-9.stat, derbyjmx.patch, jmx.diff, jmx.stat, jmxFuncspec.html, jmxFuncspec.html,
jmxFuncspec.html, Requirements for JMX Updated.html, Requirements for JMX.html, Requirements
for JMX.zip
> This is a draft requirement specification for adding monitoring and management extensions
to Apache Derby using JMX. The requirements document has been uploaded on JIRA as well as
the Derby Wiki page at http://wiki.apache.org/db-derby/_Requirement_Specifications_for_Monitoring_%26_Management_Extensions_using_JMX
> Developers and Users are requested to please look at the document (feature list in particular)
and add their own rating to features by adding a coloumn to the table.
> Comments are welcome.

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message