Think will have to survive with this at the moment. Will come back to it soon.
Thanks for the help.
Lukman
Peter F. wrote:
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]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
