The exception results from the fact that the user info can't be extracted from the database. Make sure that the database exists and it is correctly populated. Make sure that the database name, user and pwd in the Torque.properties match with the MySQL settings. Check as well that the database (tables) in MySQL have the privileges set for the user you are using to connect.
What I do for deploying Jetspeed is the following: -> Build and deploy Jetspeed configured to use MySQL into a fresh tomcat distribution (MySQL connector in common/endorsed) -> create and populate the database on the build machine. -> Check that everything works. -> tar tomcat and copy it to the target server -> dump the database and restore it on the target server I hope it helps Roger -----Original Message----- From: [EMAIL PROTECTED] Sent: Aug 26, 2004 1:51 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: jetspeed 1.5 & mysql configuration problem Dear List, I am trying to configure Jetspeed 1.5 (Tomcat 5; SuSE Linux 9.1 pro) to work with mySQL 4.0.18 and am experiencing a problem. It started with me getting the same NullPointer error when trying to deploy my application, but I wanted to be sure it was Jetspeed-1.5 before I posted, so I used nothing but factory stuff to reproduce the problem. I beseech you gurus to help me to understand the folly of my ways, and if possible turn this document into a publicly available walkthrough for those who will follow in my footsteps. My approach was to go through this once, and then repeat it using cut/paste from this posting to my command shell, to ensure this would be an accurate recap of what I actually did. Thanks for your help, Charlie Hitselberger [EMAIL PROTECTED] ====== the procedure and resulting error message follow ===== First I downloaded ftp://apache.mirrors.redwire.net/pub/apache/jakarta/jetspeed/jetspeed-current-src.zip and used it to make a new jetspeed-1.5/ source tree: > mkdir ~/code/portal # tabula raza > mkdir ~/code/portal/zips/ > mkdir ~/code/portal/zips/mysqljetspeed > mkdir ~/code/portal/zips/factory I downloaded ftp://apache.mirrors.redwire.net/pub/apache/jakarta/jetspeed/jetspeed-current-src.zip into the factory subdirectory > cd ~/code/portal > unzip zips/factory/jetspeed-current-src.zip > cd jetspeed-1.5/ I made the following changes in these three files: > cat > ~/build.properties install.war=/usr/local/tomcat/webapps locale.default=en maven.home = /usr/local/maven maven.war.appserver.home = /usr/local/tomcat database = mysql > pico ./project.properties announcement = 1.5 ... ### database = hypersonic database = mysql ... ### torque.database.url = jdbc:hsqldb:hsql://localhost ### torque.database.driver = org.hsqldb.jdbcDriver ### torque.database.user = sa ### torque.database.password = torque.dsfactory.default.connection.driver = org.gjt.mm.mysql.Driver torque.database.url = jdbc:mysql://localhost:3306/jetspeed torque.database.user = root torque.database.password = > pico webapp/WEB-INF/conf/Torque.properties ### torque.database.default.adapter=hypersonic torque.database.default.adapter=mysql ... ## Using torque's old pool ### torque.dsfactory.default.connection.driver = org.hsqldb.jdbcDriver ### torque.dsfactory.default.connection.url = jdbc:hsqldb:${webappRoot}/WEB-INF/db/jetspeed ### torque.dsfactory.default.connection.user = sa ### torque.dsfactory.default.connection.password = ... ### MySQL torque.dsfactory.default.connection.driver = org.gjt.mm.mysql.Driver torque.dsfactory.default.connection.url = jdbc:mysql://localhost:3306/jetspeed torque.dsfactory.default.connection.user = root torque.dsfactory.default.connection.password = Next, I did > cd src/java/ > jar xvf /usr/local/lib/mysql-connector-java-3.0.14-production/mysql-connector-java-3.0.14-production-bin.jar org/gjt/mm/mysql/Driver.class (extracted: org/gjt/mm/mysql/Driver.class) > cd ../.. (that last part may not have been necessary) > alias maveno='maven -Dmaven.test.skip=true ' # this is actually in ~/.bashrc > maveno dist # BUILD SUCCESSFUL > cp -v target/distributions/jetspeed-1.5* ../zips/mysqljetspeed/ > cd .. > rm -rf jetspeed-1.5/ > unzip zips/mysqljetspeed/jetspeed-1.5-src.zip > cd jetspeed-1.5 > maveno clean war # BUILD SUCCESSFUL On the jetspeed-user list, in thread "How to change from hsqldb to mysql?" http://www.mail-archive.com/[EMAIL PROTECTED]/msg12681.html I read that there is a bogus turbine-mysql.sql in the jetspeed-1.5 release distribution, so I downloaded the right version of that script from the apache CVS head > cp -v ~/turbine-mysql.sql src/sql/external/ > mysql -u root mysql> create database jetspeed; mysql> use jetspeed; mysql> source src/sql/external/turbine-mysql.sql; mysql> source src/sql/external/populate-mysql.sql; mysql> create database torque; mysql> use torque; # belt and suspenders mysql> source src/sql/external/turbine-mysql.sql; mysql> source src/sql/external/populate-mysql.sql; mysql> create database turbine; mysql> use turbine; # more belt and suspenders mysql> source src/sql/external/turbine-mysql.sql; mysql> source src/sql/external/populate-mysql.sql; mysql> quit > su Password: yeahright # cp -v target/jetspeed.war $CATALINA_HOME/webapps/ # $CATALINA_HOME/bin/startup.sh # start up Tomcat # exit (wait for it) > lynx http://localhost:8080/jetspeed $data.profile.document.portlets.getMetaInfo().title (p1 of 3) Home [welcome.gif] Username: ____________________ Login Password: ____________________ Login Help Welcome to Jetspeed [leftnav_home.gif] [leftnav_docs.gif] [leftnav_api.gif] There has been an Error! Reason: org.apache.jetspeed.om.profile.ProfileException: java.lang.NullPointerException Get/Post Data: template = /html/ShowError.vm Stacktrace: org.apache.jetspeed.om.profile.ProfileException: java.lang.NullPointerException at org.apache.jetspeed.services.profiler.JetspeedProfilerService.fallbackProfile(JetspeedProfilerService.java:502) at org.apache.jetspeed.services.profiler.JetspeedProfilerService.getProfile(JetspeedProfilerService.java:245) at org.apache.jetspeed.services.profiler.JetspeedProfilerService.getProfile(JetspeedProfilerService.java:528) (NORMAL LINK) Use right-arrow or <return> to activate. Mozilla, of course shows the same thing but it looks a lot prettier. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
