Hi, --- Indra Yana <[EMAIL PROTECTED]> wrote:
DISCLAIMER - I've not tried this with mysql myself - but with hsql and oracle... > 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 > Sounds like you are using the 1.3a2 release - is that correct? I can't remember if that works fine with dbpsml or not... you might want to try using the latest version of jetspeed from CVS. > 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 ? ) > This is not needed. > > 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 Which version? There are issues with TC4.0.2 and 4.0.3 - but then I presume you have a working Jetspeed installation without using dbpsml... > 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. > Sounds largely correct. Were there any errors/messages in the jetspeed.log file (in WEB-INF/log)? HTH, Chris ===== __________________________________________________ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
