You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by Jason Weiss <ja...@omnicoders.com> on 2003/07/30 04:42:06 UTC
RE: Converting from PSML files to a PSML Database failed.
You are getting the error you describe "profile not found" because you
failed to successfully populate the TURBINE_* tables-- this is the purpose
of ant import. Your DB should have two sets of tables -- 3 JETSPEED_*
tables and 6 TURBINE_* tables before you run ant import. When you run ant
import, it will populate and move all of the PSML stored in the .xml files
into the database. Until these tables are populated, when you attempt to
login, Turbine attempts to locate the profile for "anon" user and can't
find any rows with that data. Thus, you get the error you see.
HTH,
Jason
-----Original Message-----
From: Zufeng Huang [mailto:huangzufeng@sungoal.com]
Sent: Wednesday, July 30, 2003 8:39 AM
To: Jetspeed Developers List
Subject: Converting from PSML files to a PSML Database failed.
All,
According to the document:
http://jakarta.apache.org/jetspeed/site/psml_db.html,
I successfully setup Database supporting for Jetspeed, but I don't know
how to convert
from PSML files to PSML database.
1. I have already changed the configuration files as needed.
2. When I am going to run script* **src/sql/dbpsml-schema.sql**,*I found
that all tables have been
created, so I think it's not necessary to create them again. Skip this
operation.
3. I don't know the purpose of running #ant import, anyway I do it. Now,
error take place,
the error message is: "Error retrieving Portal Page: Profile not found."
4. I found that no PSML file store into any table in database, so I am
confused with the meaning of PSML database.
Does it really store PSML files into database? how to?
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org
RE: Converting from PSML files to a PSML Database failed.
Posted by Jason Weiss <ja...@omnicoders.com>.
The importer fails to get connected to the database properly, and thus
fails to populate the DATA in the tables.
Be sure to configure (sadly) THREE FILES with your DB information:
$JS/build/torque/build.properties
$JS/build/torque/dbpsml.properties
$JS/webapp/WEB-INF/conf/Torque.properties
Only after ALL THREE contain full database/driver/URL/user/password will
your tables be properly populated.
The details of getting all 3 of these files fully populated isn't present
on the web site! Once I configured all three completely, I was able to
get my Sybase ASA database working like a champ.
HTH,
Jason
-----Original Message-----
From: Zufeng Huang [mailto:huangzufeng@sungoal.com]
Sent: Wednesday, July 30, 2003 1:08 PM
To: Jetspeed Developers List
Subject: Re: Converting from PSML files to a PSML Database failed.
My configuration:
...
services.PsmlManager.classname=org.apache.jetspeed.services.psmlmanager.db
.DatabasePsmlManagerService
services.PsmlImportManager.classname=org.apache.jetspeed.services.psmlmana
ger.CastorPsmlManagerService
...
My database already has these tables:
| COFFEES |
| JETSPEED_GROUP_PROFILE |
| JETSPEED_ROLE_PROFILE |
| JETSPEED_USER_PROFILE |
| TURBINE_GROUP |
| TURBINE_PERMISSION |
| TURBINE_ROLE |
| TURBINE_ROLE_PERMISSION |
| TURBINE_USER |
| TURBINE_USER_GROUP_ROLE |
When #ant import, cause the following error:
import:
[java] ***** PSML Importer *****
[java] Exception in thread "main" java.lang.Error: Error in
BasePeer.initTableSchema(TURBINE_USER): There was no DataSourceFactory
configured for the connection default
...
My system environment: redhat Linux 9.0 + JDK1.4.1 + Jetspeed-1.4-b4 +
ant-1.5.x + MySQL-4.0.14
Jason Weiss wrote:
>You are getting the error you describe "profile not found" because you
>failed to successfully populate the TURBINE_* tables-- this is the
>purpose of ant import. Your DB should have two sets of tables -- 3
>JETSPEED_* tables and 6 TURBINE_* tables before you run ant import.
>When you run ant import, it will populate and move all of the PSML
>stored in the .xml files into the database. Until these tables are
>populated, when you attempt to login, Turbine attempts to locate the
>profile for "anon" user and can't find any rows with that data. Thus,
>you get the error you see.
>
>HTH,
>
>Jason
>
>-----Original Message-----
>From: Zufeng Huang [mailto:huangzufeng@sungoal.com]
>Sent: Wednesday, July 30, 2003 8:39 AM
>To: Jetspeed Developers List
>Subject: Converting from PSML files to a PSML Database failed.
>
>
>All,
>
>According to the document:
>http://jakarta.apache.org/jetspeed/site/psml_db.html,
>I successfully setup Database supporting for Jetspeed, but I don't know
>how to convert from PSML files to PSML database.
>
>1. I have already changed the configuration files as needed.
>
>2. When I am going to run script* **src/sql/dbpsml-schema.sql**,*I
>found that all tables have been created, so I think it's not necessary
>to create them again. Skip this operation.
>
>3. I don't know the purpose of running #ant import, anyway I do it.
>Now, error take place, the error message is: "Error retrieving Portal
>Page: Profile not found."
>
>4. I found that no PSML file store into any table in database, so I am
>confused with the meaning of PSML database. Does it really store PSML
>files into database? how to?
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org
Re: Converting from PSML files to a PSML Database failed.
Posted by Zufeng Huang <hu...@sungoal.com>.
My configuration:
...
services.PsmlManager.classname=org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService
services.PsmlImportManager.classname=org.apache.jetspeed.services.psmlmanager.CastorPsmlManagerService
...
My database already has these tables:
| COFFEES |
| JETSPEED_GROUP_PROFILE |
| JETSPEED_ROLE_PROFILE |
| JETSPEED_USER_PROFILE |
| TURBINE_GROUP |
| TURBINE_PERMISSION |
| TURBINE_ROLE |
| TURBINE_ROLE_PERMISSION |
| TURBINE_USER |
| TURBINE_USER_GROUP_ROLE |
When #ant import, cause the following error:
import:
[java] ***** PSML Importer *****
[java] Exception in thread "main" java.lang.Error: Error in
BasePeer.initTableSchema(TURBINE_USER): There was no DataSourceFactory
configured for the connection default
...
My system environment: redhat Linux 9.0 + JDK1.4.1 + Jetspeed-1.4-b4 +
ant-1.5.x + MySQL-4.0.14
Jason Weiss wrote:
>You are getting the error you describe "profile not found" because you
>failed to successfully populate the TURBINE_* tables-- this is the purpose
>of ant import. Your DB should have two sets of tables -- 3 JETSPEED_*
>tables and 6 TURBINE_* tables before you run ant import. When you run ant
>import, it will populate and move all of the PSML stored in the .xml files
>into the database. Until these tables are populated, when you attempt to
>login, Turbine attempts to locate the profile for "anon" user and can't
>find any rows with that data. Thus, you get the error you see.
>
>HTH,
>
>Jason
>
>-----Original Message-----
>From: Zufeng Huang [mailto:huangzufeng@sungoal.com]
>Sent: Wednesday, July 30, 2003 8:39 AM
>To: Jetspeed Developers List
>Subject: Converting from PSML files to a PSML Database failed.
>
>
>All,
>
>According to the document:
>http://jakarta.apache.org/jetspeed/site/psml_db.html,
>I successfully setup Database supporting for Jetspeed, but I don't know
>how to convert
>from PSML files to PSML database.
>
>1. I have already changed the configuration files as needed.
>
>2. When I am going to run script* **src/sql/dbpsml-schema.sql**,*I found
>that all tables have been
>created, so I think it's not necessary to create them again. Skip this
>operation.
>
>3. I don't know the purpose of running #ant import, anyway I do it. Now,
>error take place,
>the error message is: "Error retrieving Portal Page: Profile not found."
>
>4. I found that no PSML file store into any table in database, so I am
>confused with the meaning of PSML database.
>Does it really store PSML files into database? how to?
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org