Yes I think I can manage to set up Roller with the derby DB, I will
check it out and report back here (when i get some time for it).
Thanks!
Peter
David Jencks wrote:
On Mar 13, 2007, at 5:37 PM, Peter Petersson wrote:
Okey I built a snapshot of the Geronimo 1.2 branch from svn and did
some minimal changes to the geronimo-web.xml file before testing
roller 3.1 rc4 out on this new build and I am sorry to say that I get
exactly the same error as I got with the December release of Geronomo
1.2 beta. As I reported in the "Runing Apache Roller 3.0 on Geronimo
1.1.1" thread Roller actually executed a bit future in G 1.1.1 than
in 1.2.
David : I did not quite understand what you meant by "calling the
database jdbc/rollerdb in the database plan" (to be able to skip the
mapping) where would I put It in the <name> tag ?
I think you could have 2 plans like this:
(I eliminated the resource-ref element by changing the name of the db
pool, and moved the realm gbean into the web app plan)
geronimo-web.xml
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://geronimo.apache.org/xml/ns/j2ee/web-1.2";
<http://geronimo.apache.org/xml/ns/j2ee/web-1.2>
xmlns:nam="http://geronimo.apache.org/xml/ns/naming-1.1";
<http://geronimo.apache.org/xml/ns/naming-1.1>
xmlns:sec="http://geronimo.apache.org/xml/ns/security-1.1";
<http://geronimo.apache.org/xml/ns/security-1.1>
xmlns:sys="http://geronimo.apache.org/xml/ns/deployment-1.1";
<http://geronimo.apache.org/xml/ns/deployment-1.1>>
<sys:environment>
<sys:moduleId>
<sys:groupId>roller</sys:groupId>
<sys:artifactId>roller</sys:artifactId>
<sys:version>3.1</sys:version>
<sys:type>war</sys:type>
</sys:moduleId>
<sys:dependencies>
<sys:dependency>
<sys:groupId>console.dbpool</sys:groupId>
<sys:artifactId>MySqlDB_roller</sys:artifactId>
</sys:dependency>
</sys:dependencies>
<hidden-classes>
<filter>antlr</filter>
</hidden-classes>
</sys:environment>
<context-root>/roller</context-root>
<gbean name="MySqlDB_roller"
class="org.apache.geronimo.security.realm.GenericSecurityRealm"
xsi:type="dep:gbeanType"
xmlns:dep="http://geronimo.apache.org/xml/ns/deployment-1.2";
<http://geronimo.apache.org/xml/ns/deployment-1.2>
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
<http://www.w3.org/2001/XMLSchema-instance>>
<attribute name="realmName">MySqlDB_roller</attribute>
<reference name="ServerInfo">
<name>ServerInfo</name>
</reference>
<reference name="LoginService">
<name>JaasLoginService</name>
</reference>
<xml-reference name="LoginModuleConfiguration">
<log:login-config
xmlns:log="http://geronimo.apache.org/xml/ns/loginconfig-1.2";
<http://geronimo.apache.org/xml/ns/loginconfig-1.2>>
<log:login-module control-flag="REQUIRED"
server-side="true" wrap-principals="false">
<log:login-domain-name>MySqlDB_roller</log:login-domain-name>
<log:login-module-class>org.apache.geronimo.security.realm.providers.SQLLoginModule</log:login-module-class>
<log:option name="userSelect">SELECT username,
passphrase FROM rolleruser WHERE username=?</log:option>
<log:option
name="dataSourceApplication">null</log:option>
<log:option name="groupSelect">SELECT username,
rolename FROM userrole WHERE username=?</log:option>
<log:option
name="dataSourceName">MySqlDB_roller</log:option>
</log:login-module>
</log:login-config>
</xml-reference>
</gbean>
</web-app>
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
roller_mysql_db_plan.xml
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<connector
xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector-1.2";
<http://geronimo.apache.org/xml/ns/j2ee/connector-1.2>>
<dep:environment
xmlns:dep="http://geronimo.apache.org/xml/ns/deployment-1.2";
<http://geronimo.apache.org/xml/ns/deployment-1.2>>
<dep:moduleId>
<dep:groupId>console.dbpool</dep:groupId>
<dep:artifactId>MySqlDB_roller</dep:artifactId>
<dep:version>1.0</dep:version>
<dep:type>rar</dep:type>
</dep:moduleId>
<dep:dependencies>
<dep:dependency>
<dep:groupId>mysql</dep:groupId>
<dep:artifactId>mysql-connector-java</dep:artifactId>
<dep:version>3.1.12</dep:version>
<dep:type>jar</dep:type>
</dep:dependency>
</dep:dependencies>
</dep:environment>
<resourceadapter>
<outbound-resourceadapter>
<connection-definition>
<connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface>
<connectiondefinition-instance>
<name>jdbc/rollerdb</name>
<config-property-setting
name="Password">thepw</config-property-setting>
<config-property-setting
name="Driver">com.mysql.jdbc.Driver</config-property-setting>
<config-property-setting
name="UserName">theuser</config-property-setting>
<config-property-setting
name="ConnectionURL">jdbc:mysql://localhost:3306/roller</config-property-setting>
<connectionmanager>
<local-transaction/>
<single-pool>
<max-size>10</max-size>
<min-size>0</min-size>
<match-one/>
</single-pool>
</connectionmanager>
</connectiondefinition-instance>
</connection-definition>
</outbound-resourceadapter>
</resourceadapter>
</connector>
Below is the configuration and the stack trace.
If anyone has any suggestions or notice anything I may have missed
plz let me (us) know It really would be great to have this app
running on G.
If you have any ideas on how to run roller on derby and get it to a
point where geronimo is complaining I'll try to find some time to take
a look
thanks
david jencks
Thanks
Peter
