You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@roller.apache.org by Ben Avery <be...@youthnet.org> on 2006/01/05 16:28:34 UTC
another Oracle installation problem
After installing Roller 2.0, I also get no 'register user' type link in
the navigation bar.
The installation guide says that the first login is the initial admin
user, but I can't get this far, in order to allow new users to log in!
Details of setup:
Roller v2.0
Sparc Solaris 9 box
Java 1.5
Tomcat 5.5.12
Oracle 9i
viewed on Firefox 1.0.7 and Internet Exploder 6
I'm using ojdbc14.jar, rather than classes12.jar, which fixed some
earlier problems.
my hibernate.cfg.xml file is below. I've taken out the extraneous lines
out, as found in another list post.
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<!-- By default Roller uses a JNDI DataSource and the
MySQLDialect -->
<property name="show_sql">false</property>
<property
name="connection.datasource">java:comp/env/jdbc/rollerdb</property>
<property
name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
<mapping resource="org/roller/business/HitCountData.hbm.xml" />
<mapping resource="org/roller/pojos/BookmarkData.hbm.xml" />
<mapping resource="org/roller/pojos/CommentData.hbm.xml" />
<mapping resource="org/roller/pojos/EntryAttributeData.hbm.xml" />
<mapping resource="org/roller/pojos/FolderAssoc.hbm.xml" />
<mapping resource="org/roller/pojos/FolderData.hbm.xml" />
<mapping resource="org/roller/pojos/WeblogTemplate.hbm.xml" />
<mapping
resource="org/roller/pojos/PingCategoryRestrictionData.hbm.xml" />
<mapping resource="org/roller/pojos/AutoPingData.hbm.xml" />
<mapping resource="org/roller/pojos/PingQueueEntryData.hbm.xml" />
<mapping resource="org/roller/pojos/PingTargetData.hbm.xml" />
<mapping resource="org/roller/pojos/RefererData.hbm.xml" />
<mapping resource="org/roller/pojos/RoleData.hbm.xml" />
<mapping resource="org/roller/pojos/RollerConfigData.hbm.xml" />
<mapping resource="org/roller/pojos/UserData.hbm.xml" />
<mapping resource="org/roller/pojos/UserCookieData.hbm.xml" />
<mapping resource="org/roller/pojos/WeblogCategoryData.hbm.xml" />
<mapping resource="org/roller/pojos/WeblogCategoryAssoc.hbm.xml" />
<mapping resource="org/roller/pojos/WeblogEntryData.hbm.xml" />
<mapping resource="org/roller/pojos/WebsiteData.hbm.xml" />
<mapping resource="org/roller/pojos/RollerPropertyData.hbm.xml" />
<mapping resource="org/roller/pojos/PermissionsData.hbm.xml" />
<mapping resource="org/roller/pojos/PlanetConfigData.hbm.xml" />
<mapping resource="org/roller/pojos/PlanetGroupData.hbm.xml" />
<mapping resource="org/roller/pojos/PlanetEntryData.hbm.xml" />
<mapping
resource="org/roller/pojos/PlanetSubscriptionData.hbm.xml" />
<mapping
resource="org/roller/pojos/PlanetGroupSubscriptionAssoc.hbm.xml" />
</session-factory>
</hibernate-configuration>
~~
My roller.log shows the following, after startup. The only problem I can
see is the database version error. I've followed the advice of another
post in inserting 'roller.database.version', '200' as a row in the
roller_properties table, but this doesn't change or fix the problem.
INFO 2006-01-05 15:37:25,616 RollerConfig:<clinit> - successfully
loaded default properties.
INFO 2006-01-05 15:37:25,686 RollerConfig:<clinit> - no custom
properties file found in classpath
INFO 2006-01-05 15:37:25,689 RollerConfig:<clinit> - no custom
properties file specified via jvm option
ERROR 2006-01-05 15:37:26,471 UpgradeDatabase:upgradeDatabase - Couldn't
lookup current database version
java.lang.NumberFormatException: null
at java.lang.Integer.parseInt(Integer.java:415)
at java.lang.Integer.parseInt(Integer.java:497)
at
org.roller.business.utils.UpgradeDatabase.upgradeDatabase(UpgradeDatabase.java:68)
at
org.roller.presentation.RollerContext.upgradeDatabaseIfNeeded(RollerContext.java:304)
at
org.roller.presentation.RollerContext.contextInitialized(RollerContext.java:177)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3692)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4127)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
at
org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
at
org.apache.catalina.core.StandardService.start(StandardService.java:450)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:680)
at org.apache.catalina.startup.Catalina.start(Catalina.java:536)
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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:275)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
WARN 2006-01-05 15:37:31,326 Configurator:configure - No configuration
found. Configuring ehcache from ehcache-failsafe.xml found in the
classpath:
jar:file:/opt/roller/apache-tomcat-5.5.12/webapps/roller/WEB-INF/lib/ehcache-1.1.jar!/ehcache-failsafe.xml
INFO 2006-01-05 15:37:33,696 RollerFactory:setRoller - Using Roller
Impl: org.roller.business.hibernate.HibernateRollerImpl
INFO 2006-01-05 15:37:34,689 ThemeManagerImpl:<init> - Loaded 16 themes
from disk.
INFO 2006-01-05 15:37:37,562 IndexManagerImpl:<init> - search enabled: true
INFO 2006-01-05 15:37:37,565 IndexManagerImpl:<init> - index dir:
/opt/roller/roller_data/search-index
INFO 2006-01-05 15:37:38,046 RollerContext:setupPingQueueTask -
Scheduling ping queue task to run at 5 minute intervals.
INFO 2006-01-05 15:37:38,087 RollerContext:setupScheduledTasks -
Setting daily task: org.roller.presentation.TurnoverReferersTask
INFO 2006-01-05 15:37:38,132 BreadCrumbFilter:init - set breadcrumb
stack size to 3
INFO 2006-01-05 15:37:38,172 IfModifiedFilter:init - cache size is: 100
INFO 2006-01-05 15:37:38,173 IfModifiedFilter:init - cache timeout is: 1800
INFO 2006-01-05 15:37:38,207 LRUCacheHandler2:<init> - Initializing
for: PageCacheFilter
INFO 2006-01-05 15:37:38,209 LRUCacheHandler2:<init> - PageCacheFilter
size=100
INFO 2006-01-05 15:37:38,210 LRUCacheHandler2:<init> - PageCacheFilter
timeout=3600seconds
INFO 2006-01-05 15:37:38,211 LRUCacheHandler2:<init> - Initializing
for: RssCacheFilter
INFO 2006-01-05 15:37:38,213 LRUCacheHandler2:<init> - RssCacheFilter
size=100
INFO 2006-01-05 15:37:38,214 LRUCacheHandler2:<init> - RssCacheFilter
timeout=3600seconds
INFO 2006-01-05 15:37:38,220 LoginFilter:init - Remember Me enabled: true
INFO 2006-01-05 15:37:41,716 LoginServlet:init - secure login enabled:
false
INFO 2006-01-05 15:37:41,718 LoginServlet:init - secure login port: 443
~~~
my catalina.out log file is as follows. nothing seems to be up here.
Jan 5, 2006 3:37:21 PM org.apache.catalina.core.AprLifecycleListener
lifecycleEvent
INFO: The Apache Portable Runtime which allows optimal performance in
production environments was not found on the java.library.path:
/usr/jdk1.5.0_01/jre/lib/sparc/server:/usr/jdk1.5.0_01/jre/lib/sparc:/usr/jdk1.5.0_01/jre/../lib/sparc:/usr/lib
Jan 5, 2006 3:37:21 PM org.apache.coyote.http11.Http11BaseProtocol init
INFO: Initializing Coyote HTTP/1.1 on http-8765
Jan 5, 2006 3:37:21 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 2461 ms
Jan 5, 2006 3:37:22 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Jan 5, 2006 3:37:22 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.12
Jan 5, 2006 3:37:22 PM org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
Jan 5, 2006 3:37:22 PM java.util.jar.Attributes read
WARNING: Duplicate name in Manifest: Class-Path
AbandonedObjectPool is used
(org.apache.tomcat.dbcp.dbcp.AbandonedObjectPool@160877b)
LogAbandoned: false
RemoveAbandoned: true
RemoveAbandonedTimeout: 300
Jan 5, 2006 3:37:38 PM org.apache.catalina.core.ApplicationContext log
INFO: Use of the properties initialization parameter 'properties' has
been deprecated by 'org.apache.velocity.properties'
Jan 5, 2006 3:37:41 PM org.apache.catalina.core.ApplicationContext log
INFO: Use of the properties initialization parameter 'properties' has
been deprecated by 'org.apache.velocity.properties'
Jan 5, 2006 3:37:45 PM org.apache.coyote.http11.Http11BaseProtocol start
INFO: Starting Coyote HTTP/1.1 on http-8765
Jan 5, 2006 3:37:46 PM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:9009
Jan 5, 2006 3:37:46 PM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/196 config=null
Jan 5, 2006 3:37:46 PM org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
Jan 5, 2006 3:37:47 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 25608 ms
basically, I've followed all the advice of other posts with the same
problem in this list, which seem to be concerned with accessing the
database. the dstest.jsp gives a success message:
SUCCESS: Got datasource and connection, class is
org.apache.tomcat.dbcp.dbcp.BasicDataSource
Is there a way to set the allowNewUsers flag manually, in a
configuration file, or to insert a row into the database tables myself,
to create the admin user?
thanks in advance, this has got me tearing out what little hair I have left!
--
Ben Avery
Software Developer
Youthnet UK
email: ben.avery@youthnet.org
phone: 020 7288 7333
snail: 2-3 Upper Street
London N1 0PQ
Re: another Oracle installation problem
Posted by Brad Smith <bg...@bendcable.com>.
This is in general good advice for Oracle JDBC drivers. Always use the
current JDBC driver from Oracle even if using an older database (8.1.7
or newer for sure). Oracle has long recommended this practice.
Brad
On Thu, 2006-01-05 at 16:32 -0800, scionkirk (sent by Nabble.com) wrote:
> I registered just for you because there's no reason for anyone else to have to go through what I just did to figure this out.
>
> The Oracle solution - Go to the Oracle homepage - http://www.oracle.com - Downloads, Oracle JDBC Drivers, and even though you have 9i, download the latest 10g drivers. Somewhere below, someone does say to use the 10g drivers, but then he says make sure you are using ojdbc14.jar, not classes12.jar. The 9i driver is also called ojdbc14.jar so I was thinking 'okay, check, got right driver'. Nope. I'm having a problem now changing the site name, hopefully that will be easier than getting the damn Register button to appear.
Re: another Oracle installation problem
Posted by Ben Avery <be...@youthnet.org>.
woohoo! that did the trick perfectly :)
we were on the point of giving up on Roller, after days of frustration.
there's a beer waiting if you're ever in London!
thanks again
Ben
scionkirk (sent by Nabble.com) wrote:
> I registered just for you because there's no reason for anyone else to have to go through what I just did to figure this out.
>
> The Oracle solution - Go to the Oracle homepage - http://www.oracle.com - Downloads, Oracle JDBC Drivers, and even though you have 9i, download the latest 10g drivers. Somewhere below, someone does say to use the 10g drivers, but then he says make sure you are using ojdbc14.jar, not classes12.jar. The 9i driver is also called ojdbc14.jar so I was thinking 'okay, check, got right driver'. Nope. I'm having a problem now changing the site name, hopefully that will be easier than getting the damn Register button to appear.
> --
> View this message in context: http://www.nabble.com/another-Oracle-installation-problem-t857565c12275.html#a2231523
> Sent from the Roller - User forum at Nabble.com.
>
--
Ben Avery
Software Developer
Youthnet UK
email: ben.avery@youthnet.org
phone: 020 7288 7333
snail: 2-3 Upper Street
London N1 0PQ
Re: another Oracle installation problem
Posted by "scionkirk (sent by Nabble.com)" <li...@nabble.com>.
I registered just for you because there's no reason for anyone else to have to go through what I just did to figure this out.
The Oracle solution - Go to the Oracle homepage - http://www.oracle.com - Downloads, Oracle JDBC Drivers, and even though you have 9i, download the latest 10g drivers. Somewhere below, someone does say to use the 10g drivers, but then he says make sure you are using ojdbc14.jar, not classes12.jar. The 9i driver is also called ojdbc14.jar so I was thinking 'okay, check, got right driver'. Nope. I'm having a problem now changing the site name, hopefully that will be easier than getting the damn Register button to appear.
--
View this message in context: http://www.nabble.com/another-Oracle-installation-problem-t857565c12275.html#a2231523
Sent from the Roller - User forum at Nabble.com.