Any input on the issue guys? i'm still having a rough time with it.
On 4/24/07, mohamed felfel <[EMAIL PROTECTED]> wrote:
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
--
MoZey
