I figured it out!!! Duhhhhhhhh!
All that I was missing was the mySQL password in Torque.properties
torque.dsfactory.default.connection.user = root
torque.dsfactory.default.connection.password = [put password here]
Jetspeed came up with all my original users.
Thanks for all the replies. The reply below led me in the right direction.
Now -- I will tackle moving PSML to mySQL.
Michael Dalton
[EMAIL PROTECTED]
Internet Business Manager
Computing Systems Services Branch
Information Technology Directorate
IT-D3-A / CIF 394B
Kennedy Space Center, FL 32899
(W) 321-861-2207 (F) 321-867-7133
-----Original Message-----
From: Richard Berger [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 15, 2004 12:17 PM
To: Jetspeed Users List
Subject: RE: HSQL to mySQL configuration problem - ProfileException
Admittedly, I am a newbie at this, but I did move my user database from HSQL to SQL
Server (work system) and have also been worked through problems with mySql (home
system).
First, I believe that the answer to your FIRST QUESTION is "Yes" - as I have moved the
database users but never touched the PSML configuration. I think the key is to get the
DB configuration correct. I was able to populate the SQL Server database using the
scripts you referenced without quite the changes you needed, but the key thing is that
if the database tables are looking good, then you are past this stage.
The error you are seeing indicates users profiles can't be found. Are they in fact in
the database? (e.g. can you query the tables and see the users). If they are there,
and the format looks right, then it could very well be your connection to the database
as specified in the torque.properties files.
Is the root password on your mysql database blank? Does the root user have
permissions on the two tables that you created?
My best guess is that you are having connection problems, second guess is that your
tables didn't get set up quite correctly (or lack proper permissions).
Good luck!
RB
Twenty Years | One Mission | Accelerating Business Processes
Richard Berger
Action Technologies, Inc.
VP, Product Management
510.748.1017 (Office)
510.769.0596 (Fax)
www.actiontech.com
NOTE: The opinions expressed herein are those of the writer and not necessarily those
of Action Technologies, Inc. or its employees or its affiliates.
-----Original Message-----
From: Dalton, Michael D [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 15, 2004 9:05 AM
To: 'Jetspeed Users List'
Cc: Le, Vu X; Dalton, Michael D; Twadell, Daniel M (JBOSC)
Subject: HSQL to mySQL configuration problem - ProfileException
I am having problems converting our Jetspeed 1.4 test deployment from HSQL to mySQL -
on a Win2000 server. I've spent a week on this with no luck. Current configuration
has lots of users already set up. I want to "move" the user database from HSQL to
mySQL first. After I figure that out I will move the PSML file system over to mySQL.
The Jetspeed docs specifically state after configuring a new database, "If you would
also like to store your PSML resources in the database, see the instructions here".
This makes me believe I can use mySQL for the user database and leave the PSML in the
file structure. FIRST QUESTION - Is this true?
Anyway, here is what I have done:
- Using Jetspeed 1.4 final build (as-is war file with a couple of patches in modules)
- Running under Tomcat 4.1.
- Configured mySQL (latest stable build 4.0.17) as a Win 2000 service. Works OK!
- Modified Torque.properties per docs:
torque.database.default.adapter=mysql
torque.dsfactory.default.connection.driver = org.gjt.mm.mysql.Driver
torque.dsfactory.default.connection.url = jdbc:mysql://localhost:3306/portal
torque.dsfactory.default.connection.user = root
torque.dsfactory.default.connection.password =
QUESTION: Not sure about user and password above????
- Installed jdbc driver class files from mySQL.com into Jetspeed's WIN-INF/classes
directory
(e.g., com.mysql.jdbc.Driver)
- Create empty mySQL database called "portal" - referenced in Torque.properties.
- Copied WEB-INF/db/jetspeed.script (from HSQL) and renamed it populate-mysql.sql.
- Modified this populate-mysql.sql script to remove any HSQL specific commands and
references to ID_TABLE. Also needed to add ";" at end of each line.
QUESTION: Was this a good idea? Haven't seen this documented anywhere. Docs
simply say to use the default populate-mysql script which will set up 2 users. I've
tried that too with no luck.
- Use mySQL and run the turbine-mysql.sql script. No errors!
- Use mySQL and run the populate-mysql.sql script. No errors!
- Restart Tomcat with no problems.
- Attempt to run Jetspeed. See below:
- PROBLEM: Error occurs as follows:
Error processing navigation template:/html/top.vm using module:
VelocityNavigation There has been an Error! Reason:
org.apache.jetspeed.om.profile.ProfileException:
java.lang.NullPointerException
Stacktrace: org.apache.jetspeed.om.profile.ProfileException:
java.lang.NullPointerException
at org.apache.jetspeed.services.profiler.JetspeedProfilerService.fallbackPr
ofile(JetspeedProfilerService.java:544)
... ...
BIG QUESTION: What am I doing wrong? Will post "exact" steps for this when I figure
it out.
Any help would be appreciated.
Thanks,
Michael Dalton
[EMAIL PROTECTED]
Internet Business Manager
Computing Systems Services Branch
Information Technology Directorate
IT-D3-A
Kennedy Space Center, FL 32899
(W) 321-861-2207 (F) 321-867-7133
---------------------------------------------------------------------
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
