We have reffered to the roller installation wiki, i believe quetion #12, the
one that addresses
Cannot create JDBC driver of class '' for connect URL 'null'
and it was'nt of much help unfourtounatly.
ALSO:
I know that roller can only connect to a DB vai TCP, and we're good this
way.
$ netstat -an | grep 3306
tcp 0 0 127.0.0.1:3306 0.0.0.0:*
LISTEN
On 4/24/07, mohamed felfel <[EMAIL PROTECTED]> wrote:
Hello guys, i'm new to J2EE applications. So i will appreciate any help i
can get. I'm having issues installing roller. Here is my log as i stop/start
tomcat. And after that, i have outlined all steps which i did to install
it.
========================================================================
$ sudo ./doit.sh
Using CATALINA_BASE: /usr/java/tomcat-5.5
Using CATALINA_HOME: /usr/java/tomcat-5.5
Using CATALINA_TMPDIR: /usr/java/tomcat- 5.5/temp
Using JRE_HOME: /usr/java/jdk/jre
Using CATALINA_BASE: /usr/java/tomcat-5.5
Using CATALINA_HOME: /usr/java/tomcat-5.5
Using CATALINA_TMPDIR: /usr/java/tomcat-5.5/temp
Using JRE_HOME: /usr/java/jdk/jre
WARN 2007-04-24 11:09:34,933 RollerContext:upgradeDatabaseIfNeeded -
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver
of class '' f or connect URL 'null'
ERROR 2007-04-24 11:09:35,386 RollerFactory:getRoller - Error
instantiating org.apache.roller.business.hibernate.HibernateRollerImpl
ERROR 2007-04-24 11:09:35,450 RollerFactory:getRoller - Error
instantiating org.apache.roller.business.hibernate.HibernateRollerImpl
ERROR 2007-04-24 11:09:35,467 StandardContext:filterStart - Exception
starting filter securityFilter
ERROR 2007-04-24 11:09:35,646 RollerFactory:getRoller - Error
instantiating org.apache.roller.business.hibernate.HibernateRollerImpl
ERROR 2007-04-24 11:09:35,648 StandardContext:listenerStop - Exception
sending context destroyed event to listener instance of class
org.apache.roller.ui.cor e.RollerContext
WARN 2007-04-24 11:09:36,228 RollerContext:upgradeDatabaseIfNeeded -
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver
of class '' f or connect URL 'null'
ERROR 2007-04-24 11:09:36,350 RollerFactory:getRoller - Error
instantiating org.apache.roller.business.hibernate.HibernateRollerImpl
ERROR 2007-04-24 11:09:36,364 RollerFactory:getRoller - Error
instantiating org.apache.roller.business.hibernate.HibernateRollerImpl
ERROR 2007-04-24 11:09:36,377 StandardContext:filterStart - Exception
starting filter securityFilter
ERROR 2007-04-24 11:09:36,423 RollerFactory:getRoller - Error
instantiating org.apache.roller.business.hibernate.HibernateRollerImpl
ERROR 2007-04-24 11:09:36,426 StandardContext:listenerStop - Exception
sending context destroyed event to listener instance of class
org.apache.roller.ui.cor e.RollerContext
========================================================================
Where doit.sh is my restart/tail roller.log file script.
Now, here is how i installed roller, I have
1: Downloaded the latest roller 3.1.
2: Created my database as well as the schema.
3: Coppied the appropriate jars to common/lin, (see below).
4: Created roller-custom.properties (see below), and created the uploads,
seach-index dirs.
5: Roller.xml (check it out below)
6: Edited hibernate.cfg.xml, i know you dont need to do that!, but before
and after editing this yeild to the same error. (See below).
7: Edited security.xml accordingly.
8: Placed web.xml in WEB-INF/web.xml
9: added the appropriate <service> to server.xml (see below), <--- not too
confident about
$ ls common/lib/
activation.jar commons-el.jar jasper-compiler.jar jsp-api.jar
mysql-connector-java-3.0.17-ga-bin.jar readme.txt
asm-attrs.jar dom4j-1.6.1.jar jasper-compiler-jdt.jar jta.jar
naming-factory-dbcp.jar servlet-api.jar
asm.jar ehcache-1.1.jar jasper-runtime.jar
jta-spec1_0_1.jar naming-factory.jar
cglib-2.1.3.jar hibernate3.jar jdbc2_0-stdext.jar mail.jar
naming-resources.jar
$ cat common/classes/roller-custom.properties
# this is how you might do it for tomcat
JAVA_OPTS="-
Droller.custom.config=/usr/java/tomcat-5.5/common/classes/roller-custom.properties
"
export $JAVA_OPTS
$TOMCAT_HOME/bin/startup.sh
uploads.dir=$ROLLER/roller-files/uploads
search.index.dir=$ROLLER/roller-files/search-index
passwds.encryption.enabled=true
$ cat conf/Catalina/EXAMPLE.COM/roller.xml
<?xml version=" 1.0" encoding="UTF-8"?>
<Context
path="/roller"
docBase="roller"
debug="1"
workdir="/usr/java/tomcat-5.5/webapps/roller">
<Resource
name="jdbc/rollerdb"
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/ROLLERDB?autoReconnect=true&useUnicode=true&characterEncoding=utf-8&mysqlEncoding=utf8"
username="ROLLERUSERNAME"
password="ROLLERPASSWORD"
maxActive="20"
maxIdle="3"
removeAbandoned="true"
maxWait="3000"
/>
</Context>
$ cat webapps/roller/WEB-INF/classes/hibernate.cfg.xml
<?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>
<property name="connection.datasource
">java:comp/env/jdbc/rollerdb</property>
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="show_sql">false</property>
<property name="hibernate.current_session_context_class
">thread</property>
<property name=" hibernate.cache.provider_class">
org.hibernate.cache.EhCacheProvider</property>
<property name="hibernate.generate_statistics">true</property>
<property name=" hibernate.cache.use_structured_entries
">true</property>
<mapping
resource="org/apache/roller/pojos/RollerPropertyData.hbm.xml" />
<mapping resource="org/apache/roller/pojos/UserData.hbm.xml" />
<mapping resource="org/apache/roller/pojos/RoleData.hbm.xml" />
<mapping
resource="org/apache/roller/pojos/RollerConfigData.hbm.xml" />
<mapping resource="org/apache/roller/pojos/WebsiteData.hbm.xml" />
<mapping
resource="org/apache/roller/pojos/PermissionsData.hbm.xml" />
<mapping resource="org/apache/roller/pojos/BookmarkData.hbm.xml"
/>
<mapping resource="org/apache/roller/pojos/CommentData.hbm.xml" />
<mapping resource="org/apache/roller/pojos/FolderAssoc.hbm.xml" />
<mapping resource="org/apache/roller/pojos/FolderData.hbm.xml" />
<mapping resource="org/apache/roller/pojos/WeblogTemplate.hbm.xml"
/>
<mapping
resource="org/apache/roller/pojos/PingCategoryRestrictionData.hbm.xml" />
<mapping resource="org/apache/roller/pojos/AutoPingData.hbm.xml"
/>
<mapping
resource="org/apache/roller/pojos/PingQueueEntryData.hbm.xml" />
<mapping resource="org/apache/roller/pojos/PingTargetData.hbm.xml"
/>
<mapping resource="org/apache/roller/pojos/RefererData.hbm.xml" />
<mapping resource="org/apache/roller/pojos/TaskLockData.hbm.xml"
/>
<mapping resource="org/apache/roller/pojos/HitCountData.hbm.xml"
/>
<mapping
resource="org/apache/roller/pojos/WeblogEntryData.hbm.xml" />
<mapping
resource="org/apache/roller/pojos/WeblogEntryTagData.hbm.xml" />
<mapping
resource="org/apache/roller/pojos/WeblogEntryTagAggregateData.hbm.xml" />
<mapping
resource="org/apache/roller/pojos/EntryAttributeData.hbm.xml" />
<mapping
resource="org/apache/roller/pojos/WeblogCategoryData.hbm.xml" />
<mapping
resource="org/apache/roller/pojos/WeblogCategoryAssoc.hbm.xml" />
<mapping
resource="org/apache/roller/planet/pojos/PlanetConfigData.hbm.xml" />
<mapping
resource="org/apache/roller/planet/pojos/PlanetGroupData.hbm.xml" />
<mapping
resource="org/apache/roller/planet/pojos/PlanetEntryData.hbm.xml" />
<mapping
resource="org/apache/roller/planet/pojos/PlanetSubscriptionData.hbm.xml" />
</session-factory>
</hibernate-configuration>
$ cat conf/server.xml
<?xml version="1.0" encoding="UTF-8"?>
<Server>
<Listener className="org.apache.catalina.core.AprLifecycleListener "/>
<Listener className="
org.apache.catalina.mbeans.GlobalResourcesLifecycleListener"/>
<Listener className="
org.apache.catalina.storeconfig.StoreConfigLifecycleListener"/>
<Listener className="org.apache.catalina.mbeans.ServerLifecycleListener
"/>
<GlobalNamingResources>
<Environment
name="simpleValue"
type="java.lang.Integer "
value="30"/>
<Resource
auth="Container"
description="User database that can be updated and saved"
name="UserDatabase"
type=" org.apache.catalina.UserDatabase"
pathname="conf/tomcat-users.xml"
factory="org.apache.catalina.users.MemoryUserDatabaseFactory"/>
</GlobalNamingResources>
<Service
name="Catalina">
<Connector
port="9080"
redirectPort="9443"
minSpareThreads="25"
connectionTimeout="20000"
maxThreads="150"
maxSpareThreads="75">
</Connector>
<Connector
port="8009"
protocol="AJP/1.3">
</Connector>
<Engine
defaultHost="localhost"
name="Catalina">
<Realm className="org.apache.catalina.realm.UserDatabaseRealm"/>
<Host
appBase="webapps"
name="localhost">
</Host>
</Engine>
</Service>
<Service
name="EXAMPLE.COM">
<Connector
enableLookups="true"
port="8666"
redirectPort="9443"
URIEncoding="UTF-8"
debug="1"
acceptCount="10">
</Connector>
<Engine
defaultHost="EXAMPLE.COM"
name="EXAMPLE.COM">
<Realm className=" org.apache.catalina.realm.JAASRealm"
appName="gigs.fm"/>
<Host
appBase="webapps"
name=" gigs.fm">
</Host>
</Engine>
</Service>
</Server>
--
MoZey
--
MoZey
