Hi, The correct sequence for me (with oracle) was:
1. use src/sql/*.sql for everything but psml DDL, including populate script which populates turbine tables, etc. 2. use targets/sql/ psml script for psml DDL. 3. use maven import for psml data, from filesystem. Dan --- "Lukman W. Kusuma" <[EMAIL PROTECTED]> wrote: > > Dan Moore wrote: > > >Did you do this after running the sql scripts in target/classes/sql? > > > > > Yes. > > >I received a message like this when I ran the sql scripts in > >src/external/sql and then tried to import psml files. The database > was > >not set up correctly, nor were the Torque classes. > > > > > > > Noted. > > >After I ran the sql scripts in target/classes/sql (the psml script) > I > >was able to successfully import. > > > > > > > So, what's the right sequence ? src/external/sql -- > target/classes/sql > -- maven import ? > > Thanks > > Lukman > > >Dan > > > >--- "Lukman W. Kusuma" <[EMAIL PROTECTED]> wrote: > > > > > > > >>Dan, > >> > >>I tried this step too before. I thought it might look at the > default > >>files and export to database, but it shows 0 profiles instead. > >> > >>I really don't know what's missing now. > >> > >>Thanks > >> > >>Lukman > >> > >> > >>import: > >> [java] ***** PSML Importer ***** > >> [java] log4j:WARN No appenders could be found for logger > >>(org.apache.stratum.component.ComponentLoader). > >> [java] log4j:WARN Please initialize the log4j system properly. > >> [java] NOTICE: Finished initializing all services! > >> [ava] Running with Importer Service: class > >> > >> > >> > >org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService > > > > > >> [java] Running with Exporter Service: class > >>org.apache.jetspeed.services.psmlmanager.CastorPsmlManagerService > >> [java] PSMLImporter completed. Exported 0 profiles > >> [java] **** PSML Importer - completed > >> > >> > >>Dan Moore wrote: > >> > >> > >> > >>>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 > >> > >> > >>> > >>> > === message truncated === --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
