The normal way to populate the jetspeed profile tables is to write psml files and then run the maven import task.
See "Converting from PSML files to a PSML Database" here http://portals.apache.org/jetspeed-1/psml_db.html Dan --- "Lukman W. Kusuma" <[EMAIL PROTECTED]> wrote: > One more thing, Peter. I observe populate-mysql.sql doesn't have any > record insert to jetspeed's related profile tables (JETSPEED_****). > Is this normal? > > Thanks > > Lukman > > 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] > > > > > > > > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
