You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@geronimo.apache.org by Paul McMahan <pa...@gmail.com> on 2007/03/01 16:24:38 UTC
Re: Runing Apache Roller 3.0 on Geronimo 1.1.1
Peter, Thanks for looking into this and please do let us know how
things turn out. I think it would be awesome to include Roller in
Geronimo's plugin repository so that users like yourself can add blog
functionality to Geronimo with just a few simple steps. In fact Roller
is on the wishlist at a Geronimo plugin community website. To make it
available as a plugin all we need is a WAR or EAR that can deploy into
Geronimo and then we can export it as a plugin using Geronimo's admin
console and add it to the plugin repo. If you get Roller working in
Geronimo and don't mind sharing your work then I can help with the
rest.
Best wishes,
Paul
On 3/1/07, Peter Petersson <pe...@pmb.mine.nu> wrote:
> Thanks for the info I will try it out but I am afraid there has been
> some changes in Roller 3.0 that may course my problems have you tried to
> install 3.0 ?
> When I get time to look at your information and apply fixes to my build
> I will post info here.
>
> Thanks
> Peter
>
> Tim McConnell wrote:
> > Here is the JUG/Webcast presentation that elaborates some on the
> > instructions in Jeff's article. It was pretty straightforward after I
> > got MySql working correctly...Let me know if you need additional
> > information
> >
> > Thanks,
> > Tim McConnell
> >
> >
> > Peter Petersson wrote:
> >> Hi
> >>
> >> I am trying to run Apache Roller
> >> <http://cwiki.apache.org/confluence/display/ROLLER> 3.0 on Geronimo
> >> 1.1.1 but soon after startup (during the initial configuration steps)
> >> hibernate is starting to throw
> >> org.hibernate.SessionException: Session is closed! exceptions (I am
> >> not sure this is the course of the problems).
> >>
> >> Dose anyone have a tutorial or a working configuration to share with
> >> the public available ?
> >> I have searched the web for it but have only come up with outdated
> >> information.
> >> Any help in resolving the problems is greatly appreciated.
> >>
> >> Roller configuration changes:
> >> As I am using MySql 5.0.35 with (J/Connector 3.1.12) I have changed
> >> the hibernate dialect accordingly
> >> hibernate.cfg.xml
> >> :
> >> <!-- For MySQL 5.X, use the MySQL5 dialect and J/Connector 3.1.X -->
> >> <property name="dialect">org.hibernate.dialect.MySQL5Dialect</property>
> >> :
> >>
> >> Geronimo/Roller configuration
> >>
> >> Created the mysql roller database and deployed the db plan
> >> Database plan:
> >> <?xml version="1.0" encoding="UTF-8"?>
> >> <connector xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector-1.1">
> >> <dep:environment
> >> xmlns:dep="http://geronimo.apache.org/xml/ns/deployment-1.1">
> >> <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>MySqlDB_roller</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">thename</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>
> >>
> >>
> >> geronimo-web.xml
> >>
> >> <?xml version="1.0" encoding="UTF-8"?>
> >> <web-app xmlns="http://geronimo.apache.org/xml/ns/j2ee/web-1.1"
> >> xmlns:nam="http://geronimo.apache.org/xml/ns/naming-1.1"
> >> xmlns:sec="http://geronimo.apache.org/xml/ns/security-1.1"
> >> xmlns:sys="http://geronimo.apache.org/xml/ns/deployment-1.1">
> >> <sys:environment>
> >> <sys:moduleId>
> >> <sys:groupId>m4u</sys:groupId>
> >> <sys:artifactId>roller</sys:artifactId>
> >> <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>
> >> <filter>org.springframework</filter>
> >> <filter>org.apache.xerces</filter>
> >> <filter>org.apache.commons.digester</filter>
> >> </hidden-classes>
> >> --> </sys:environment>
> >>
> >> <context-root>/roller</context-root>
> >> <sys:resource-ref>
> >> <sys:ref-name>jdbc/rollerdb</sys:ref-name>
> >> <sys:resource-link>MySqlDB_roller</sys:resource-link>
> >> </sys:resource-ref>
> >>
> >> </web-app>
> >>
> >> setenv.sh:
> >> JAVA_HOME=/usr/lib/jvm/java-1.5.0-sun
> >> JAVA_OPTS="-Djava.awt.headless=true -XX:MaxPermSize=128m -Xms128M
> >> -Xmx512M -server"
> >>
> >> What am I missing or doing wrong here ? (or is there any known issues
> >> running Roller on Geronimo)
> >>
> >> /Peter
> >>
> >>
>
>
Re: Runing Apache Roller 3.0 on Geronimo 1.1.1
Posted by Peter Petersson <pe...@pmb.mine.nu>.
A follow up.
I got some time and decided to download and build roller from source and
It may have given me a hint on what is causing the problem I am seeing
in the log messages (below). It turns out that it is not recommended to
build releases of roller 3.0 with java 1.5 (yet) well the ant target
"apache-release" wont let you build it with java 1.5 I don't know what
the reason is for it but I guess I am about to find out as I am going to
check it out ;).
/Peter
Peter Petersson wrote:
> If I get it working I will share the bits and pieces but at the moment
> it doesn't look good. Im back trying Roller out on G 1.1.1 and with
> Tim McConnell:s information (Thanks Tim) I got the authentication
> things right but despite a lot of testing (filters and other settings)
> I end up with the same exception as before (shown below), after some
> jumping around in the roller administration/registration phase It
> seems that hibernate "gives up" and for some reason closes the
> session. I will try to look future in to this but I am not that
> familiar with hibernate or spring for that mater. It wouldn't surprise
> me if it a simple configuration setting somewhere that I have
> overlooked, you never know.
> /Peter
>
> 20:43:50,193 WARN [LoggerListener] Authentication event
> AuthenticationSuccessEvent: Peter; details:
> org.acegisecurity.ui.WebAuthenticationDetails@0: RemoteIpAddress:
> 127.0.1.1; SessionId: E6E5C79D7638B1C3C7B948899842653A
> 20:43:50,208 WARN [LoggerListener] Authentication event
> InteractiveAuthenticationSuccessEvent: Peter; details:
> org.acegisecurity.ui.WebAuthenticationDetails@0: RemoteIpAddress:
> 127.0.1.1; SessionId: E6E5C79D7638B1C3C7B948899842653A
> 20:43:51,411 INFO [velocity] ResourceManager : found
> templates/menu/menu-tabbed.vm with loader
> org.apache.roller.ui.rendering.velocity.WebappResourceLoader
> 20:44:07,098 INFO [ReferrerQueueManagerImpl] Initializing Referrer
> Queue Manager
> 20:44:07,098 INFO [ReferrerQueueManagerImpl] Asynchronous referrer
> processing = false
> 20:44:07,142 ERROR [PageServlet] Error processing referrer
> org.hibernate.SessionException: Session is closed!
> at
> org.hibernate.impl.AbstractSessionImpl.errorIfClosed(AbstractSessionImpl.java:50)
>
> at
> org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1304)
> at sun.reflect.GeneratedMethodAccessor502.invoke(Unknown Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
> at java.lang.reflect.Method.invoke(Method.java:585)
> at
> org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:301)
>
> at $Proxy2.beginTransaction(Unknown Source)
> at
> org.apache.roller.business.hibernate.HibernatePersistenceStrategy.getSession(HibernatePersistenceStrategy.java:83)
>
> at
> org.apache.roller.business.hibernate.HibernatePersistenceStrategy.flush(HibernatePersistenceStrategy.java:91)
>
> at
> org.apache.roller.business.hibernate.HibernateRollerImpl.flush(HibernateRollerImpl.java:93)
>
> at
> org.apache.roller.business.referrers.ReferrerQueueManagerImpl.processReferrer(ReferrerQueueManagerImpl.java:163)
>
> at
> org.apache.roller.ui.rendering.servlets.PageServlet.processReferrer(PageServlet.java:535)
>
> at
> org.apache.roller.ui.rendering.servlets.PageServlet.doGet(PageServlet.java:129)
>
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>
> at
> org.apache.roller.ui.core.filters.CompressionFilter.doFilter(CompressionFilter.java:80)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>
> at
> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)
>
> at
> org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:97)
>
> at
> org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
>
>
> Paul McMahan wrote:
>> Peter, Thanks for looking into this and please do let us know how
>> things turn out. I think it would be awesome to include Roller in
>> Geronimo's plugin repository so that users like yourself can add blog
>> functionality to Geronimo with just a few simple steps. In fact Roller
>> is on the wishlist at a Geronimo plugin community website. To make it
>> available as a plugin all we need is a WAR or EAR that can deploy into
>> Geronimo and then we can export it as a plugin using Geronimo's admin
>> console and add it to the plugin repo. If you get Roller working in
>> Geronimo and don't mind sharing your work then I can help with the
>> rest.
>>
>> Best wishes,
>> Paul
>>
>> On 3/1/07, Peter Petersson <pe...@pmb.mine.nu> wrote:
>>> Thanks for the info I will try it out but I am afraid there has been
>>> some changes in Roller 3.0 that may course my problems have you
>>> tried to
>>> install 3.0 ?
>>> When I get time to look at your information and apply fixes to my build
>>> I will post info here.
>>>
>>> Thanks
>>> Peter
>>>
>>> Tim McConnell wrote:
>>> > Here is the JUG/Webcast presentation that elaborates some on the
>>> > instructions in Jeff's article. It was pretty straightforward after I
>>> > got MySql working correctly...Let me know if you need additional
>>> > information
>>> >
>>> > Thanks,
>>> > Tim McConnell
>>> >
>>> >
>>> > Peter Petersson wrote:
>>> >> Hi
>>> >>
>>> >> I am trying to run Apache Roller
>>> >> <http://cwiki.apache.org/confluence/display/ROLLER> 3.0 on Geronimo
>>> >> 1.1.1 but soon after startup (during the initial configuration
>>> steps)
>>> >> hibernate is starting to throw
>>> >> org.hibernate.SessionException: Session is closed! exceptions (I am
>>> >> not sure this is the course of the problems).
>>> >>
>>> >> Dose anyone have a tutorial or a working configuration to share with
>>> >> the public available ?
>>> >> I have searched the web for it but have only come up with outdated
>>> >> information.
>>> >> Any help in resolving the problems is greatly appreciated.
>>> >>
>>> >> Roller configuration changes:
>>> >> As I am using MySql 5.0.35 with (J/Connector 3.1.12) I have changed
>>> >> the hibernate dialect accordingly
>>> >> hibernate.cfg.xml
>>> >> :
>>> >> <!-- For MySQL 5.X, use the MySQL5 dialect and J/Connector 3.1.X
>>> -->
>>> >> <property
>>> name="dialect">org.hibernate.dialect.MySQL5Dialect</property>
>>> >> :
>>> >>
>>> >> Geronimo/Roller configuration
>>> >>
>>> >> Created the mysql roller database and deployed the db plan
>>> >> Database plan:
>>> >> <?xml version="1.0" encoding="UTF-8"?>
>>> >> <connector
>>> xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector-1.1">
>>> >> <dep:environment
>>> >> xmlns:dep="http://geronimo.apache.org/xml/ns/deployment-1.1">
>>> >> <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>MySqlDB_roller</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">thename</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>
>>> >>
>>> >>
>>> >> geronimo-web.xml
>>> >>
>>> >> <?xml version="1.0" encoding="UTF-8"?>
>>> >> <web-app xmlns="http://geronimo.apache.org/xml/ns/j2ee/web-1.1"
>>> >> xmlns:nam="http://geronimo.apache.org/xml/ns/naming-1.1"
>>> >> xmlns:sec="http://geronimo.apache.org/xml/ns/security-1.1"
>>> >> xmlns:sys="http://geronimo.apache.org/xml/ns/deployment-1.1">
>>> >> <sys:environment>
>>> >> <sys:moduleId>
>>> >> <sys:groupId>m4u</sys:groupId>
>>> >> <sys:artifactId>roller</sys:artifactId>
>>> >> <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>
>>> >> <filter>org.springframework</filter>
>>> >> <filter>org.apache.xerces</filter>
>>> >> <filter>org.apache.commons.digester</filter>
>>> >> </hidden-classes>
>>> >> --> </sys:environment>
>>> >>
>>> >> <context-root>/roller</context-root>
>>> >> <sys:resource-ref>
>>> >> <sys:ref-name>jdbc/rollerdb</sys:ref-name>
>>> >> <sys:resource-link>MySqlDB_roller</sys:resource-link>
>>> >> </sys:resource-ref>
>>> >>
>>> >> </web-app>
>>> >>
>>> >> setenv.sh:
>>> >> JAVA_HOME=/usr/lib/jvm/java-1.5.0-sun
>>> >> JAVA_OPTS="-Djava.awt.headless=true -XX:MaxPermSize=128m -Xms128M
>>> >> -Xmx512M -server"
>>> >>
>>> >> What am I missing or doing wrong here ? (or is there any known
>>> issues
>>> >> running Roller on Geronimo)
>>> >>
>>> >> /Peter
>>> >>
>>> >>
>>>
>>>
>
Re: Runing Apache Roller 3.0 on Geronimo 1.1.1
Posted by Peter Petersson <pe...@pmb.mine.nu>.
If I get it working I will share the bits and pieces but at the moment
it doesn't look good.
Im back trying Roller out on G 1.1.1 and with Tim McConnell:s
information (Thanks Tim) I got the authentication things right but
despite a lot of testing (filters and other settings) I end up with the
same exception as before (shown below), after some jumping around in the
roller administration/registration phase It seems that hibernate "gives
up" and for some reason closes the session. I will try to look future in
to this but I am not that familiar with hibernate or spring for that
mater. It wouldn't surprise me if it a simple configuration setting
somewhere that I have overlooked, you never know.
/Peter
20:43:50,193 WARN [LoggerListener] Authentication event
AuthenticationSuccessEvent: Peter; details:
org.acegisecurity.ui.WebAuthenticationDetails@0: RemoteIpAddress:
127.0.1.1; SessionId: E6E5C79D7638B1C3C7B948899842653A
20:43:50,208 WARN [LoggerListener] Authentication event
InteractiveAuthenticationSuccessEvent: Peter; details:
org.acegisecurity.ui.WebAuthenticationDetails@0: RemoteIpAddress:
127.0.1.1; SessionId: E6E5C79D7638B1C3C7B948899842653A
20:43:51,411 INFO [velocity] ResourceManager : found
templates/menu/menu-tabbed.vm with loader
org.apache.roller.ui.rendering.velocity.WebappResourceLoader
20:44:07,098 INFO [ReferrerQueueManagerImpl] Initializing Referrer
Queue Manager
20:44:07,098 INFO [ReferrerQueueManagerImpl] Asynchronous referrer
processing = false
20:44:07,142 ERROR [PageServlet] Error processing referrer
org.hibernate.SessionException: Session is closed!
at
org.hibernate.impl.AbstractSessionImpl.errorIfClosed(AbstractSessionImpl.java:50)
at
org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1304)
at sun.reflect.GeneratedMethodAccessor502.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:301)
at $Proxy2.beginTransaction(Unknown Source)
at
org.apache.roller.business.hibernate.HibernatePersistenceStrategy.getSession(HibernatePersistenceStrategy.java:83)
at
org.apache.roller.business.hibernate.HibernatePersistenceStrategy.flush(HibernatePersistenceStrategy.java:91)
at
org.apache.roller.business.hibernate.HibernateRollerImpl.flush(HibernateRollerImpl.java:93)
at
org.apache.roller.business.referrers.ReferrerQueueManagerImpl.processReferrer(ReferrerQueueManagerImpl.java:163)
at
org.apache.roller.ui.rendering.servlets.PageServlet.processReferrer(PageServlet.java:535)
at
org.apache.roller.ui.rendering.servlets.PageServlet.doGet(PageServlet.java:129)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.roller.ui.core.filters.CompressionFilter.doFilter(CompressionFilter.java:80)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)
at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:97)
at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
Paul McMahan wrote:
> Peter, Thanks for looking into this and please do let us know how
> things turn out. I think it would be awesome to include Roller in
> Geronimo's plugin repository so that users like yourself can add blog
> functionality to Geronimo with just a few simple steps. In fact Roller
> is on the wishlist at a Geronimo plugin community website. To make it
> available as a plugin all we need is a WAR or EAR that can deploy into
> Geronimo and then we can export it as a plugin using Geronimo's admin
> console and add it to the plugin repo. If you get Roller working in
> Geronimo and don't mind sharing your work then I can help with the
> rest.
>
> Best wishes,
> Paul
>
> On 3/1/07, Peter Petersson <pe...@pmb.mine.nu> wrote:
>> Thanks for the info I will try it out but I am afraid there has been
>> some changes in Roller 3.0 that may course my problems have you tried to
>> install 3.0 ?
>> When I get time to look at your information and apply fixes to my build
>> I will post info here.
>>
>> Thanks
>> Peter
>>
>> Tim McConnell wrote:
>> > Here is the JUG/Webcast presentation that elaborates some on the
>> > instructions in Jeff's article. It was pretty straightforward after I
>> > got MySql working correctly...Let me know if you need additional
>> > information
>> >
>> > Thanks,
>> > Tim McConnell
>> >
>> >
>> > Peter Petersson wrote:
>> >> Hi
>> >>
>> >> I am trying to run Apache Roller
>> >> <http://cwiki.apache.org/confluence/display/ROLLER> 3.0 on Geronimo
>> >> 1.1.1 but soon after startup (during the initial configuration steps)
>> >> hibernate is starting to throw
>> >> org.hibernate.SessionException: Session is closed! exceptions (I am
>> >> not sure this is the course of the problems).
>> >>
>> >> Dose anyone have a tutorial or a working configuration to share with
>> >> the public available ?
>> >> I have searched the web for it but have only come up with outdated
>> >> information.
>> >> Any help in resolving the problems is greatly appreciated.
>> >>
>> >> Roller configuration changes:
>> >> As I am using MySql 5.0.35 with (J/Connector 3.1.12) I have changed
>> >> the hibernate dialect accordingly
>> >> hibernate.cfg.xml
>> >> :
>> >> <!-- For MySQL 5.X, use the MySQL5 dialect and J/Connector 3.1.X -->
>> >> <property
>> name="dialect">org.hibernate.dialect.MySQL5Dialect</property>
>> >> :
>> >>
>> >> Geronimo/Roller configuration
>> >>
>> >> Created the mysql roller database and deployed the db plan
>> >> Database plan:
>> >> <?xml version="1.0" encoding="UTF-8"?>
>> >> <connector
>> xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector-1.1">
>> >> <dep:environment
>> >> xmlns:dep="http://geronimo.apache.org/xml/ns/deployment-1.1">
>> >> <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>MySqlDB_roller</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">thename</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>
>> >>
>> >>
>> >> geronimo-web.xml
>> >>
>> >> <?xml version="1.0" encoding="UTF-8"?>
>> >> <web-app xmlns="http://geronimo.apache.org/xml/ns/j2ee/web-1.1"
>> >> xmlns:nam="http://geronimo.apache.org/xml/ns/naming-1.1"
>> >> xmlns:sec="http://geronimo.apache.org/xml/ns/security-1.1"
>> >> xmlns:sys="http://geronimo.apache.org/xml/ns/deployment-1.1">
>> >> <sys:environment>
>> >> <sys:moduleId>
>> >> <sys:groupId>m4u</sys:groupId>
>> >> <sys:artifactId>roller</sys:artifactId>
>> >> <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>
>> >> <filter>org.springframework</filter>
>> >> <filter>org.apache.xerces</filter>
>> >> <filter>org.apache.commons.digester</filter>
>> >> </hidden-classes>
>> >> --> </sys:environment>
>> >>
>> >> <context-root>/roller</context-root>
>> >> <sys:resource-ref>
>> >> <sys:ref-name>jdbc/rollerdb</sys:ref-name>
>> >> <sys:resource-link>MySqlDB_roller</sys:resource-link>
>> >> </sys:resource-ref>
>> >>
>> >> </web-app>
>> >>
>> >> setenv.sh:
>> >> JAVA_HOME=/usr/lib/jvm/java-1.5.0-sun
>> >> JAVA_OPTS="-Djava.awt.headless=true -XX:MaxPermSize=128m -Xms128M
>> >> -Xmx512M -server"
>> >>
>> >> What am I missing or doing wrong here ? (or is there any known issues
>> >> running Roller on Geronimo)
>> >>
>> >> /Peter
>> >>
>> >>
>>
>>