Hi David, hi all! > Could you send the relevant properties from your > JetspeedResources.properties. Also, for Jetspeed-1, to switch databases > you have to change the Torque properties and rebuild. Did you do that?
Okay, here are the relevant properties from my JetspeedResources.properties (as far as I know which ARE relevant): # To use the File-based PSML service, select (uncomment) this service (this is the default setting): # services.PsmlManager.classname=org.apache.jetspeed.services.psmlmanager.Cast orPsmlManagerService # To use the DB-PSML service, select (uncomment) this service, and comment out the above service: services.PsmlManager.classname=org.apache.jetspeed.services.psmlmanager.db.D atabasePsmlManagerService # Select this service to import from File System to the Database (make sure that DatabasePsmlManagerService is selected above) services.PsmlImportManager.classname=org.apache.jetspeed.services.psmlmanage r.CastorPsmlManagerService # Select this service to import from the Database to the File System (make sure that CastorPsmlManagerService is selected above) # services.PsmlImportManager.classname=org.apache.jetspeed.services.psmlmanage r.db.DatabasePsmlManagerService And yes, I changed my Torque.properties and rebuild. I'm already using MySQL for users. Here are my settings for my db in my Torque.properties: torque.database.default=default torque.database.default.adapter=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 = jetspeed torque.dsfactory.default.connection.password = jetspeed > Finally, check the log files from the import. > Send any relevant stack traces to this list Actually there seem to be some problems with the MySQL driver. As I'm already using it for users, I thought anything would be fine with it. Where do I put the jar for the MySQL driver so that maven recognizes it? Excerpt from my jetspeedservices.log: 2005-02-15 21:16:26,722 [main] WARN DatabasePsmlManagerService - DatabasePsmlManagerService.getDbConnection: exception: org.apache.torque.TorqueException: java.sql.SQLException: No suitable driver 2005-02-15 21:16:27,243 [main] WARN DatabasePsmlManagerService - DatabasePsmlManagerService.createOrSaveDocument: profile: BaseProfile[user/admin/html/default.psml] tableName: JETSPEED_USER_PROFILE org.apache.torque.TorqueException: java.sql.SQLException: No suitable driver at org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:755) at org.apache.torque.Torque.getConnection(Torque.java:306) at org.apache.torque.util.Transaction.beginOptional(Transaction.java:118) at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:636) at org.apache.jetspeed.om.dbpsml.BaseJetspeedUserProfilePeer.doInsert(BaseJetsp eedUserProfilePeer.java:223) at org.apache.jetspeed.om.dbpsml.BaseJetspeedUserProfilePeer.doInsert(BaseJetsp eedUserProfilePeer.java:581) at org.apache.jetspeed.om.dbpsml.JetspeedUserProfilePeer.doInsertOrUpdate(Jetsp eedUserProfilePeer.java:108) at org.apache.jetspeed.om.dbpsml.JetspeedUserProfilePeer.insert(JetspeedUserPro filePeer.java:49) at org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService.creat eOrSaveDocument(DatabasePsmlManagerService.java:626) at org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService.creat eDocument(DatabasePsmlManagerService.java:586) at org.apache.jetspeed.services.psmlmanager.CastorPsmlManagerService.export(Cas torPsmlManagerService.java:1310) at org.apache.jetspeed.services.psmlmanager.PsmlImporter.run(PsmlImporter.java: 171) at org.apache.jetspeed.services.psmlmanager.PsmlImporter.main(PsmlImporter.java :140) Regards Daniel --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]