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]
