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
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
