Did you do this after running the sql scripts in target/classes/sql? 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.
After I ran the sql scripts in target/classes/sql (the psml script) I was able to successfully import. 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! > [java] 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 > > > > > >>>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] > > > > > > > > > === message truncated === --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
