I have been using blojsom for several years. First in SuSE 9.1, it always works once completely tuned. I recently migrated all my system to a newer machine with debian lenny 5.0 r2 installed.
The following are the software version:
mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (x86_64) using readline 5.2
Using CATALINA_BASE: /usr/share/tomcat5.5
Using CATALINA_HOME: /usr/share/tomcat5.5
Using CATALINA_TMPDIR: /usr/share/tomcat5.5/temp
Using JRE_HOME: /usr/lib/jvm/java-1.5.0-sun
Server version: Apache Tomcat/5.5
Server built: Oct 15 2008 12:57:44
Server number: 5.5.26.0
OS Name: Linux
OS Version: 2.6.26-2-amd64
Architecture: amd64
JVM Version: 1.5.0_17-b04
JVM Vendor: Sun Microsystems Inc.
Together with Java and JDBC set according to debian architecture, especially,
copy mysql-connector-java-5.1.6.jar to $TOMCAT_HOME/common/lib/.
Although I am migrating my database from SuSE 9.1 to Debian 5, I make sure everything is correct by checking the grants for user name:
mysql> show grants for zoublog;
+--------------------------------------------------------------------------------------------------------+
| Grants for zoublog@% |
+--------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'zoublog'@'%' IDENTIFIED BY PASSWORD '*encripted_passwd' |
| GRANT ALL PRIVILEGES ON `blojsom`.* TO 'zoublog'@'%' |
+--------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
Also for zoublog@'localhost', the same result. the passwd and blog ID match with:
$TOMCAT_HOME/webapps/blojsom/WEB-INF/classes/blojsom-helper-beans-include.xml
Tomcat5.5 is working fine, by looking at /var/log/tomcat55/.
However, I am still having "unable to load blog ID" error.
Here is the syslog:
Oct 31 22:24:39 ti jsvc.exec[5698]: jsom/WEB-INF/lib/mail-1.3.1.jar:/var/lib/tomcat5.5/webapps/blojsom/WEB-INF/lib/smtp-1.3.jar:/var/lib/tomcat5.5/webapps/blojsom/WEB-INF/lib/spring-2.0.jar:/var/lib/tomcat5.5/webapps/blojsom/WEB-INF/lib/spring-hibernate3.jar:/var/lib/tomcat5.5/webapps/blojsom/WEB-INF/lib/textile4j-1.20.jar:/var/lib/tomcat5.5/webapps/blojsom/WEB-INF/lib/velocity-1.4.jar:/var/lib/tomcat5.5/webapps/blojsom/WEB-INF/lib/xmlrpc-1.2-b1-blojsom.jar:/var/lib/tomcat5.5/shared/classes/:/usr/share/tomcat5.5/common/classes/:/usr/share/tomcat5.5/common/i18n/tomcat-i18n-fr.jar:/usr/share/tomcat5.5/common/i18n/tomcat-i18n-ja.jar:/usr/share/tomcat5.5/common/i18n/tomcat-i18n-en.jar:/usr/share/tomcat5.5/common/i18n/tomcat-i18n-es.jar:/usr/share/tomcat5.5/common/lib/naming-factory.jar:/usr/share/java/commons-pool-1.3.jar:/usr/share/java/commons-dbcp-1.2.1.jar:/usr/share/java/jsp-api-2.0.jar:/usr/share/tomcat5.5/common/lib/mysql-connector-java-5.1.6.jar:/usr/share/tomcat5.5/common/lib/jasper-compiler.jar:/usr/share/tomcat5.5/common/lib/jasper-runt
Oct 31 22:24:39 ti jsvc.exec[5698]: ime.jar:/usr/share/tomcat5.5/common/lib/naming-resources.jar:/usr/share/java/servlet-api-2.4.jar:/usr/share/java/commons-el-1.0.jar:/usr/share/java/commons-collections3-3.2.1.jar:/usr/share/java/eclipse-ecj.jar:/usr/share/java/commons-daemon-1.0.2.jar:/usr/share/tomcat5.5/bin/bootstrap.jar:/usr/lib/jvm/java-1.5.0-sun-1.5.0.17/jre/lib/ext/dnsns.jar:/usr/lib/jvm/java-1.5.0-sun-1.5.0.17/jre/lib/ext/sunjce_provider.jar:/usr/lib/jvm/java-1.5.0-sun-1.5.0.17/jre/lib/ext/sunpkcs11.jar:/usr/lib/jvm/java-1.5.0-sun-1.5.0.17/jre/lib/ext/localedata.jar
Oct 31 22:24:39 ti jsvc.exec[5698]: Oct 31 21:24:39 DEBUG [main] servlet.JspServlet - Scratch dir for the JSP engine is: /var/lib/tomcat5.5/work/Catalina/localhost/blojsom
Oct 31 22:24:39 ti jsvc.exec[5698]: Oct 31 21:24:39 DEBUG [main] servlet.JspServlet - IMPORTANT: Do not modify the generated servlets
Oct 31 22:24:39 ti jsvc.exec[5698]: Oct 31 21:24:39 ERROR [main] util.JDBCExceptionReporter - Cannot create PoolableConnectionFactory (User not found: ZOUBLOG)
Oct 31 22:24:39 ti jsvc.exec[5698]: Oct 31 21:24:39 DEBUG [main] event.SimpleEventBroadcaster - Using shared listeners map
Oct 31 22:24:39 ti jsvc.exec[5698]: Oct 31 21:24:39 DEBUG [main] event.SimpleEventBroadcaster - Using shared listener to handler map
Oct 31 22:24:39 ti jsvc.exec[5698]: Oct 31 21:24:39 DEBUG [main] event.SimpleEventBroadcaster - Initialized simple event broadcaster
Oct 31 22:24:39 ti jsvc.exec[5698]: Oct 31 21:24:39 DEBUG [main] database.DatabaseFetcher - Initialized database fetcher
Oct 31 22:24:39 ti jsvc.exec[5698]: Oct 31 21:24:39 DEBUG [main] comment.CommentAPIServlet - blojsom Comment API: All Your Blog Are Belong To Us
Oct 31 22:24:39 ti jsvc.exec[5698]: Oct 31, 2009 9:24:39 PM org.apache.coyote.http11.Http11BaseProtocol start#012INFO: Starting Coyote HTTP/1.1 on http-8180
Oct 31 22:24:39 ti jsvc.exec[5698]: Oct 31 21:24:39 DEBUG [http-8180-Processor25] filter.FeedFilter - Handling feed filter request: /
Oct 31 22:24:39 ti jsvc.exec[5698]: Oct 31 21:24:39 DEBUG [http-8180-Processor25] filter.PageFilter - Handling page filter request: /
Oct 31 22:24:39 ti jsvc.exec[5698]: Oct 31 21:24:39 DEBUG [http-8180-Processor25] filter.SkipEntriesFilter - Handling skip entries request: /
Oct 31 22:24:39 ti jsvc.exec[5698]: Oct 31 21:24:39 ERROR [http-8180-Processor25] util.JDBCExceptionReporter - Cannot create PoolableConnectionFactory (User not found: ZOUBLOG)
Oct 31 22:24:39 ti jsvc.exec[5698]: Oct 31 21:24:39 ERROR [http-8180-Processor25] util.JDBCExceptionReporter - Cannot create PoolableConnectionFactory (User not found: ZOUBLOG)
Oct 31 22:24:39 ti jsvc.exec[5698]: Oct 31 21:24:39 ERROR [http-8180-Processor25] database.DatabaseFetcher - org.hibernate.exception.GenericJDBCException: Cannot open connection
Oct 31 22:24:39 ti jsvc.exec[5698]: Oct 31 21:24:39 ERROR [http-8180-Processor25] servlet.BlojsomServlet - org.blojsom.fetcher.FetcherException: org.hibernate.exception.GenericJDBCException: Cannot open connection
Oct 31 22:24:39 ti jsvc.exec[5698]: Oct 31 21:24:39 ERROR [http-8180-Processor25] util.JDBCExceptionReporter - Cannot create PoolableConnectionFactory (User not found: ZOUBLOG)
Oct 31 22:24:39 ti jsvc.exec[5698]: Oct 31 21:24:39 ERROR [http-8180-Processor25] util.JDBCExceptionReporter - Cannot create PoolableConnectionFactory (User not found: ZOUBLOG)
Oct 31 22:24:40 ti jsvc.exec[5698]: Oct 31 21:24:40 ERROR [http-8180-Processor25] database.DatabaseFetcher - org.hibernate.exception.GenericJDBCException: Cannot open connection
Oct 31 22:24:40 ti jsvc.exec[5698]: Oct 31 21:24:40 ERROR [http-8180-Processor25] servlet.BlojsomServlet - org.blojsom.fetcher.FetcherException: org.hibernate.exception.GenericJDBCException: Cannot open connection
Oct 31 22:24:40 ti jsvc.exec[5698]: Oct 31, 2009 9:24:40 PM org.apache.jk.common.ChannelSocket init#012INFO: JK: ajp13 listening on /0.0.0.0:8009
Oct 31 22:24:40 ti jsvc.exec[5698]: Oct 31, 2009 9:24:40 PM org.apache.jk.server.JkMain start#012INFO: Jk running ID=0 time=0/175 config=null
Oct 31 22:24:40 ti jsvc.exec[5698]: Oct 31, 2009 9:24:40 PM org.apache.catalina.storeconfig.StoreLoader load#012INFO: Find registry server-registry.xml at classpath resource
I also try to create new blojsom database from scratch, and also use svn to check out version 3.3, and follow the instruction. I have the same error.
Could anyone point out a possible place where I could debug at!?
