I tried to make Jetspeed using PSML database instead of PSML file, I've read the mail 
related with my probles but I still can configure it out.

I've done :
1. create SQL script file by modifying 
   the /build/torque/build.properties
2. create user jetspeed with 'jetspeed' password on mysql
3. create the 'jetspeed' database on mysql
4. create tables on jetspeed using file script : dbpsml-schema.sql. It create : 
JETSPEED_USER_PROPERTIES , JETSPEED_ROLE_PROPERTIES , JETSPEED_GROUP_PROPERTIES, etc.
5. modify file turbine-resources.properties :
   
  database.default.driver=org.gjt.mm.mysql.Driver
  database.default.url=jdbc:mysql://localhost:3306/jetspeed
  database.default.username=jetspeed
  database.default.password=jetspeed

  database.adaptor=DBMM
  database.adaptor.DBMM=org.gjt.mm.mysql.Driver

6. modify file turbine-resource.velocity : (i modified it, just in case it also used 
by other jetspeed's program. But actually, should i modify it ? )

  database.default.driver=org.gjt.mm.mysql.Driver
  database.default.url=jdbc:mysql://localhost:3306/jetspeed
  database.default.username=jetspeed
  database.default.password=jetspeed

  database.adaptor=DBMM
  database.adaptor.DBMM=org.gjt.mm.mysql.Driver

7. modify the jetspeed-resources.properties. I comment the 1st line and uncomment the 
2nd and 3rd line
 
#services.PsmlManager.classname=org.apache.jetspeed.services.psmlmanager.CastorPsmlManagerService
services.PsmlImportManager.classname=org.apache.jetspeed.services.psmlmanager.CastorPsmlManagerService
services.PsmlManager.classname=org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService
    
8. put the mm.mysql-2.0.14-bin.jar in jetspeed/WEB-INF/lib dir
9. restart catalina
10. When I tried to browse the jetspeed, it keep try to connect to localhost for a 
long time. It didnt display anything.
11. It seems that the psml importer manager didnt work. Cause when i tried to query 
all tables on the 'jetspeed' database, they still empty. The importer manager didnt 
corvert the psml file to tables.

Do I had the right step ? Or is there something else that I miss or need to do ? Can 
somebody help me ? I really appreciate it.

Thanx

IkkI


_______________________________________________________
WIN a first class trip to Hawaii.  Live like the King of Rock and Roll
on the big Island. Enter Now!
http://r.lycos.com/r/sagel_mail/http://www.elvis.lycos.com/sweepstakes

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Reply via email to