As you said, you have to read the instructions on how to store the psml in DB, as it requires some more steps.
You'll have to build jetspeed from src, you can't just use the release war. The error you're getting is that your database doesn't contain the profiles needed by end-user, and you modified the js.pr to use dbpsml manager. Aurelien Dalton, Michael D a �crit : > 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. > fallbackProfile(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]
