Psml and MySql

Some additional hints to go with the document http://jakarta.apache.org/jetspeed/site/psml.html and http://jakarta.apache.org/jetspeed/site/psml_db.html

If you don't have a huge number of users, then you can probably continue keeping the user configurations stored in psml/xml files.

However, if you're going to have a lot of users, then the directories will quickly become overwhelmed (unless you stick with merged roles, which I'm having trouble doing :-(

You tell jetspeed to use the database rather than file system in this file: /webapps/jetspeed/WEB-INF/conf/JetspeedResources.properties

However, you will need to import the psml files into the database before this will work.

In the jakarta source tree, you'll find a build.xml which has a target called import - grep for "PSML Importer". If you set up the MySqlDriver, create the right DB in the database etc (the "jetspeed" DB), then when you "ant import", the PSML files will get imported into the database.

The DB stores the psml as blobs (see JdbcBlobs) which are the raw xml!


Note that to edit the default page (which is the anon) user, the quick and dirty way is to export the DB's stored psml back into files (you play with the build.xml and change the import definition to make the source be the DB and the destination be the psml - be warned, you'll probably end up trying to write to the root directory /WEB-INF/...!)

Create a dummy user called, e.g. anon2, get its pages right, and then stop tomcat, and copy the default.psml file from psml/users/anon2/html over the ones in psml/users/anon/html (and the sub dirs en/GB etc).

PsmlMySql (last edited 2009-09-20 23:32:27 by localhost)