sorry,
a slight copy-n'-paste mistake..
the hibernate.properties file should read as follows
hibernate.connection.username=scott
hibernate.connection.password=tiger
hibernate.connection.url=jdbc:mysql://localhost/roller
hibernate.connection.driver_class=com.mysql.jdbc.Driver
hibernate.dialect=net.sf.hibernate.dialect.MySQLDialect
please help me,
thank you,
- eric
Eric Pramono wrote:
>
> dear all,
>
> it's been 3 days of trying, reading, searching, downloading.. and now i
> really need some help
>
> i had followed all the instructions as best as i could, here's my
> configuration:
>
> jakarta-tomcat-5.5.9:
> - copied mysql-connector-java-3.0.17-ga-bin.jar to
> {catalina.home}/common/lib
> - verified that naming-factory-dbcp.jar existed in
> {catalina.home}/common/lib
> - created roller.xml in the {catalina.home}/conf/Catalina/localhost, with
> the following contents
>
> <Context path="/roller" docBase="${catalina.home}/webapps/roller"
> debug="0">
> <Resource name="jdbc/rollerdb" auth="Container"
> type="javax.sql.DataSource"
> driverClassName="com.mysql.jdbc.Driver"
> url="jdbc:mysql://localhost:3306/roller?autoReconnect=true"
> username="scott"
> password="tiger"
> maxActive="20"
> maxIdle="3"
> removeAbandoned="true"
> maxWait="3000" />
> </Context>
>
> - verified that roller.log has been created by Tomcat in the
> {catalina.home}/logs
> - copied the roller folder into {catalina.home}/webapps
> - no changes are made to the web.xml, it still has the following JNDI
> resource definition:
>
> <resource-ref>
> <res-ref-name>jdbc/rollerdb</res-ref-name>
> <res-type>javax.sql.DataSource</res-type>
> <res-auth>Container</res-auth>
> </resource-ref>
>
> - downloaded the required-jars-roller-3.0-incubating.tar from
> roller.dev.java.net
> - copied all the jars from that tar into roller/WEB-INF/lib
> - modified the roller.properties, to include the following entries:
>
> uploads.dir=D:/rollerdata/uploads
> search.index.dir=D:/rollerdata/search-index
>
> - both directories have been created in the filesystem
> - modified the hibernate.cfg.xml to include the following:
>
> <property
> name="connection.datasource">java:comp/env/jdbc/rollerdb</property>
> <property name="show_sql">false</property>
> <property
> name="hibernate.current_session_context_class">thread</property>
> <property
> name="dialect">org.hibernate.dialect.MySQLDialect</property>
> <property
> name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
> <property name="hibernate.connection.url">
>
> jdbc:mysql://localhost:3306/roller?user=scott&password=tiger</property>
> <property name="hibernate.connection.username">scott</property>
> <property name="hibernate.connection.password">tiger</property>
> <property
> name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
>
> - modified the hibernate.properties to:
>
> hibernate.connection.username=scott
> hibernate.connection.password=tiger
> hibernate.connection.url=jdbc:mysql:/roller
> hibernate.connection.driver_class=com.mysql.jdbc.Driver
> hibernate.dialect=net.sf.hibernate.dialect.MySQLDialect
>
> mysql4.1
> - followed exactly what the installation guide says
>
> when i tried to run the application, here's what i got:
>
> Mar 12, 2007 10:35:39 PM org.apache.catalina.core.StandardContext start
> SEVERE: Error filterStart
> Mar 12, 2007 10:35:39 PM org.apache.catalina.core.StandardContext start
> SEVERE: Context [/roller] startup failed due to previous errors
> Mar 12, 2007 10:35:39 PM org.apache.catalina.loader.WebappClassLoader
> loadClass
> INFO: Illegal access: this web application instance has been stopped
> already. C
> ould not load
> org.apache.roller.business.hibernate.HibernateWeblogManagerImpl.
> The eventual following stack trace is caused by an error thrown for
> debugging pu
> rposes as well as to attempt to terminate the thread which caused the
> illegal ac
> cess, and has no functional impact.
>
> and this is what the roller.log says:
>
> INFO 2007-03-12 22:35:22,609 RollerConfig:<clinit> - successfully loaded
> default properties.
> ...
> INFO 2007-03-12 22:35:23,953 UpgradeDatabase:upgradeDatabase - Database
> is current, no upgrade needed
> INFO 2007-03-12 22:35:25,187 Environment:<clinit> - Hibernate 3.1.2
> INFO 2007-03-12 22:35:25,328 Environment:<clinit> - loaded properties
> from resource hibernate.properties: {hibernate.connection.username=scott,
> hibernate.connection.password=****,
> hibernate.cglib.use_reflection_optimizer=true,
> hibernate.dialect=net.sf.hibernate.dialect.MySQLDialect,
> hibernate.connection.url=jdbc:mysql:/roller,
> hibernate.connection.driver_class=com.mysql.jdbc.Driver}
> ...
> INFO 2007-03-12 22:35:26,781 Configuration:configure - configuring from
> resource: /hibernate.cfg.xml
> INFO 2007-03-12 22:35:26,796 Configuration:getConfigurationInputStream -
> Configuration resource: /hibernate.cfg.xml
> INFO 2007-03-12 22:35:27,515 Configuration:addResource - Reading mappings
> from resource: org/apache/roller/pojos/BookmarkData.hbm.xml
> INFO 2007-03-12 22:35:29,562
> HbmBinder:bindRootPersistentClassCommonValues - Mapping class:
> org.apache.roller.pojos.BookmarkData -> bookmark
> ...
> INFO 2007-03-12 22:35:31,484 Configuration:addResource - Reading mappings
> from resource:
> org/apache/roller/pojos/PlanetGroupSubscriptionAssoc.hbm.xml
> INFO 2007-03-12 22:35:31,500
> HbmBinder:bindRootPersistentClassCommonValues - Mapping class:
> org.apache.roller.pojos.PlanetGroupSubscriptionAssoc ->
> rag_group_subscription
> INFO 2007-03-12 22:35:31,500 Configuration:doConfigure - Configured
> SessionFactory: null
> INFO 2007-03-12 22:35:31,500 HbmBinder:bindCollectionSecondPass - Mapping
> collection: org.apache.roller.pojos.FolderData.bookmarks -> bookmark
> ...
> INFO 2007-03-12 22:35:31,515 HbmBinder:bindCollectionSecondPass - Mapping
> collection: org.apache.roller.pojos.PlanetSubscriptionData.entries ->
> rag_entry
> INFO 2007-03-12 22:35:31,562 NamingHelper:getInitialContext - JNDI
> InitialContext properties:{}
> INFO 2007-03-12 22:35:31,578 DatasourceConnectionProvider:configure -
> Using datasource: java:comp/env/jdbc/rollerdb
> INFO 2007-03-12 22:35:32,015 Dialect:<init> - Using dialect:
> org.hibernate.dialect.MySQLDialect
> INFO 2007-03-12 22:35:32,078
> TransactionFactoryFactory:buildTransactionFactory - Using default
> transaction strategy (direct JDBC transactions)
> INFO 2007-03-12 22:35:32,125
> TransactionManagerLookupFactory:getTransactionManagerLookup - No
> TransactionManagerLookup configured (in JTA environment, use of read-write
> or transactional second-level cache is not recommended)
> INFO 2007-03-12 22:35:32,140 SettingsFactory:buildSettings - Automatic
> flush during beforeCompletion(): disabled
> ...
> INFO 2007-03-12 22:35:32,562 SettingsFactory:buildSettings - Default
> entity-mode: pojo
> INFO 2007-03-12 22:35:33,218 SessionFactoryImpl:<init> - building session
> factory
> WARN 2007-03-12 22:35:33,734 EhCacheProvider:buildCache - Could not find
> configuration [org.apache.roller.pojos.BookmarkData]; using defaults.
> ...
> WARN 2007-03-12 22:35:36,765 EhCacheProvider:buildCache - Could not find
> configuration [org.apache.roller.pojos.FolderAssoc]; using defaults.
> INFO 2007-03-12 22:35:37,812 SessionFactoryObjectFactory:addInstance -
> Not binding factory to JNDI, no JNDI name configured
> INFO 2007-03-12 22:35:37,828 RollerFactory:setRoller - Using Roller Impl:
> org.apache.roller.business.hibernate.HibernateRollerImpl
> FATAL 2007-03-12 22:35:38,828 HibernatePropertiesManagerImpl:init - Failed
> to initialize runtime configuration properties.Please check that the
> database has been upgraded!
> java.lang.UnsupportedOperationException
> at
> org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:116)
> at
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:554)
> at
> org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:66)
> at
> org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:360)
> at
> org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:122)
> at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:125)
> at
> org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
> at
> org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1309)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> 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 $Proxy0.beginTransaction(Unknown Source)
> at
> org.apache.roller.business.hibernate.HibernatePersistenceStrategy.getSession(HibernatePersistenceStrategy.java:83)
> at
> org.apache.roller.business.hibernate.HibernatePropertiesManagerImpl.getProperties(HibernatePropertiesManagerImpl.java:98)
> at
> org.apache.roller.business.hibernate.HibernatePropertiesManagerImpl.init(HibernatePropertiesManagerImpl.java:147)
> at
> org.apache.roller.business.hibernate.HibernatePropertiesManagerImpl.<init>(HibernatePropertiesManagerImpl.java:70)
> at
> org.apache.roller.business.hibernate.HibernateRollerImpl.getPropertiesManager(HibernateRollerImpl.java:182)
> at
> org.apache.roller.ui.core.RollerContext.setupRollerProperties(RollerContext.java:237)
> at
> org.apache.roller.ui.core.RollerContext.contextInitialized(RollerContext.java:173)
> at
> org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3669)
> ...
> FATAL 2007-03-12 22:35:38,828 RollerContext:contextInitialized -
> RollerContext initialization failed
> java.lang.RuntimeException: java.lang.UnsupportedOperationException
> at
> org.apache.roller.business.hibernate.HibernatePropertiesManagerImpl.init(HibernatePropertiesManagerImpl.java:163)
> at
> org.apache.roller.business.hibernate.HibernatePropertiesManagerImpl.<init>(HibernatePropertiesManagerImpl.java:70)
> at
> org.apache.roller.business.hibernate.HibernateRollerImpl.getPropertiesManager(HibernateRollerImpl.java:182)
> at
> org.apache.roller.ui.core.RollerContext.setupRollerProperties(RollerContext.java:237)
> at
> org.apache.roller.ui.core.RollerContext.contextInitialized(RollerContext.java:173)
> at
> org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3669)
> ...
> Caused by: java.lang.UnsupportedOperationException
> at
> org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:116)
> at
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:554)
> at
> org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:66)
> at
> org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:360)
> at
> org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:122)
> at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:125)
> at
> org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
> at
> org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1309)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> 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 $Proxy0.beginTransaction(Unknown Source)
> at
> org.apache.roller.business.hibernate.HibernatePersistenceStrategy.getSession(HibernatePersistenceStrategy.java:83)
> at
> org.apache.roller.business.hibernate.HibernatePropertiesManagerImpl.getProperties(HibernatePropertiesManagerImpl.java:98)
> at
> org.apache.roller.business.hibernate.HibernatePropertiesManagerImpl.init(HibernatePropertiesManagerImpl.java:147)
> ... 28 more
> ERROR 2007-03-12 22:35:39,156 StandardContext:filterStart - Exception
> starting filter securityFilter
> java.lang.IllegalStateException: No WebApplicationContext found: no
> ContextLoaderListener registered?
> at
> org.springframework.web.context.support.WebApplicationContextUtils.getRequiredWebApplicationContext(WebApplicationContextUtils.java:84)
> at
> org.acegisecurity.util.FilterToBeanProxy.getContext(FilterToBeanProxy.java:169)
> at
> org.acegisecurity.util.FilterToBeanProxy.doInit(FilterToBeanProxy.java:111)
> at
> org.acegisecurity.util.FilterToBeanProxy.init(FilterToBeanProxy.java:181)
> at
> org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:225)
> ...
> INFO 2007-03-12 22:35:39,156 IPBanFilter:init - INIT IPBanFilter
> INFO 2007-03-12 22:35:39,203 CompressionFilter:init - Compressed Output
> ENABLED
> INFO 2007-03-12 22:35:39,500 RequestMappingFilter:init - Request mapping
> filter initialized, 1 mappers configured.
> INFO 2007-03-12 22:35:39,531 ReferrerQueueManagerImpl:<init> -
> Initializing Referrer Queue Manager
> INFO 2007-03-12 22:35:39,546 ReferrerQueueManagerImpl:<init> -
> Asynchronous referrer processing = false
> INFO 2007-03-12 22:35:39,546 CacheManager:<clinit> - Cache Manager
> Initialized.
> INFO 2007-03-12 22:35:39,546 CacheManager:<clinit> - Cache Factory =
> org.apache.roller.util.cache.ExpiringLRUCacheFactoryImpl
> INFO 2007-03-12 22:35:39,546 FuturePostingsInvalidationJob:input -
> Peeking 3 minutes into the future each pass
> INFO 2007-03-12 22:35:39,578 ContinuousWorkerThread:run - future
> invalidations thread Started.
> ERROR 2007-03-12 22:35:39,578 WorkerThread:run - Error executing job.
> Worker = future invalidations thread, Job =
> org.apache.roller.util.cache.FuturePostingsInvalidationJob
> java.lang.ThreadDeath
> at
> org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1221)
> at
> org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1181)
> at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
> at
> org.apache.roller.business.hibernate.HibernateRollerImpl.getWeblogManager(HibernateRollerImpl.java:152)
> at
> org.apache.roller.util.cache.FuturePostingsInvalidationJob.execute(FuturePostingsInvalidationJob.java:74)
> at
> org.apache.roller.business.runnable.WorkerThread.run(WorkerThread.java:73)
> at
> org.apache.roller.business.runnable.ContinuousWorkerThread.run(ContinuousWorkerThread.java:83)
> INFO 2007-03-12 22:35:39,578 ContinuousWorkerThread:run - future
> invalidations thread INTERRUPT: sleep interrupted
>
> i appreciate any help/guidance from you all,
> thank you,
>
> - eric
>
--
View this message in context:
http://www.nabble.com/roller-3.0-installation-problem%2C-please-help-tf3390293s12275.html#a9437096
Sent from the Roller - User mailing list archive at Nabble.com.
