Change system-database-plan.xml to specify userid and password on the
SystemDatasource and enhance installer to configure it
----------------------------------------------------------------------------------------------------------------------------
Key: GERONIMO-818
URL: http://issues.apache.org/jira/browse/GERONIMO-818
Project: Geronimo
Type: Improvement
Components: core
Versions: 1.0-M4, 1.0-M5
Reporter: John Sisson
Assigned to: John Sisson
Fix For: 1.0-M5
If a user creates a derby.properties file in geronimo/var/derby that enables
Authentication, e.g.
#
#Security settings
#
derby.connection.requireAuthentication=true
derby.authentication.provider=BUILTIN
#
# User and password list for Derby BUILTIN authentication provider
#
derby.user.geronimo=manager
derby.user.myapp=myapppswd
Then this causes problems with the system-database-plan processing.. e.g.
12:42:07,277 ERROR [GBeanInstanceState] Error while starting; GBean is now in
the FAILED state:
objectName="geronimo.server:J2EEApplication=null,J2EEModule=org/apache/geronimo/SystemDatabase
,J2EEServer=geronimo,j2eeType=GBean,name=JDBCNonTransactionalThreadPooledTimer"
SQL Exception: Connection refused : Invalid authentication.
Currently the tables created by Geronimo and ActiveMQ are created by default
under the APP schema. If we change the system-database-plan to use the userid
'geronimo', then the tables will be created under a schema of the same name. I
would prefer that we don't user a userid of system, as it may be confused with
Derby's SYS schema.
We need to allow users to configure authentication in Derby without breaking
Geronimo.
Need to investigate further.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira