Hello Lukman, I don't use PSML-in-DB persistence. I decided to use file-based PSML storage (just default option) for a while. So I only needed to create and populate TURBINE_* tables. And I had a problem with this, as far as columns number doesn't match for some table in turbine-mysql.sql and populate-mysql.sql .
If you need just to run as soon as possible, than you can try my way: 1. Downlolad binary distribution with ready jetspeed.war file 2. Manually unpack this WAR in \tomcat_home\webapps\jetspeed 3. Change configuration files to use MySQL (not for PSML, just for users, groups etc.) 4. Download from CVS turbine-mysql.sql and populate-mysql.sql 5. Create and populate DB 6. Run Tomcat Sorry, if this can't be useful for you. Wednesday, October 20, 2004, 5:49:42 PM, you wrote: LWK> One more thing, Peter. I observe populate-mysql.sql doesn't have any LWK> record insert to jetspeed's related profile tables (JETSPEED_****). LWK> Is this normal? LWK> Thanks LWK> Lukman LWK> Peter F. wrote: >>Hello Lukman, >> >>Probably that's not exactly concerned your problem, but also keep in >>mind that you need to get latest SQL-scripts turbine-mysql.sql and >>populate-mysql.sql from CVS. >> >>I could not run Jetspeed on MySQL with scripts from downloaded >>Jetspeed package. >> >> >> >>Wednesday, October 20, 2004, 4:53:10 PM, you wrote: >> >>LWK> Hi, >> >>LWK> I am installed Jetspeed 1.5 with jakarta-tomcat-5.0.28 and got it >>LWK> working with standard procedure. Pretty interface. >>LWK> As I need to use MySQL and followed the following steps >> >>LWK> * http://portals.apache.org/jetspeed-1/install.html guideline. >>LWK> * run all the mysql related ..sql file src/sql/external >>LWK> (turbine-mysql.sql, and populate-mysql.sql) >>LWK> * I modified the project.properties, Torque.properties (both to >>LWK> relfect the mysql config), and >>LWK> JetspeedResources.properties as >>LWK> specified in the guideline page : >>LWK> http://portals.apache.org/jetspeed-1/psml_db.html >>LWK> o However, I am not able to get >>LWK> *target/classes/sql/dbpsml-schema.sql *and >>LWK> *target/classes/sql/security-schema.sql *as specified in >>LWK> >>LWK> >>http://portals.apache.org/jetspeed-1/psml_db.html#Creating_PSML_Database >> >>LWK> * mysql connection is okay, because I must login with the right >>LWK> username / password, and also tested it with mysql shutdown (got >>LWK> different errors) >> >>LWK> After following those steps, I am getting : "Error retrieving Portal >>LWK> Page: Profile not found" at the main page. >>LWK> Seems that jetspeed couldn't find the default profile from mysql >>LWK> database, but I also found the jetspeed's profile related tables are >>LWK> still empty. >> >>LWK> I am doing a proof of concept with jetspeed as the main portal >>LWK> framework. I feel the 3rd step above is the key point, but I can't get >>LWK> the .sql generated. >>LWK> Can anyone assist me if I missed anything here ? >> >>LWK> Thanks >> >>LWK> Lukman >> >>LWK> >>--------------------------------------------------------------------- >>LWK> To unsubscribe, e-mail: >>LWK> [EMAIL PROTECTED] >>LWK> For additional commands, e-mail: >>LWK> [EMAIL PROTECTED] >> >> >> >> >> >> LWK> --------------------------------------------------------------------- LWK> To unsubscribe, e-mail: LWK> [EMAIL PROTECTED] LWK> For additional commands, e-mail: LWK> [EMAIL PROTECTED] -- Best regards, Peter mailto:[EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
