You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by "Peter F." <Pe...@solutionstorent.com> on 2004/10/20 17:10:19 UTC
Re: [SPAM] Re: [SPAM] Error retrieving Portal Page: Profile not found.
Hello Lukman,
I don't use PSML-in-DB persistence.
I decided to use file-based PSML storage (just default option) for a while.
So I only needed to create and
populate TURBINE_* tables. And I had a problem with this, as
far as columns number doesn't match for some table in
turbine-mysql.sql and populate-mysql.sql .
If you need just to run as soon as possible, than you can try my way:
1. Downlolad binary distribution with ready jetspeed.war file
2. Manually unpack this WAR in \tomcat_home\webapps\jetspeed
3. Change configuration files to use MySQL (not for PSML, just for
users, groups etc.)
4. Download from CVS turbine-mysql.sql and populate-mysql.sql
5. Create and populate DB
6. Run Tomcat
Sorry, if this can't be useful for you.
Wednesday, October 20, 2004, 5:49:42 PM, you wrote:
LWK> One more thing, Peter. I observe populate-mysql.sql doesn't have any
LWK> record insert to jetspeed's related profile tables (JETSPEED_****).
LWK> Is this normal?
LWK> Thanks
LWK> Lukman
LWK> 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> jetspeed-user-unsubscribe@jakarta.apache.org
>>LWK> For additional commands, e-mail:
>>LWK> jetspeed-user-help@jakarta.apache.org
>>
>>
>>
>>
>>
>>
LWK> ---------------------------------------------------------------------
LWK> To unsubscribe, e-mail:
LWK> jetspeed-user-unsubscribe@jakarta.apache.org
LWK> For additional commands, e-mail:
LWK> jetspeed-user-help@jakarta.apache.org
--
Best regards,
Peter mailto:Peter.Fen@solutionstorent.com
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
Re: [SPAM] Re: [SPAM] Error retrieving Portal Page: Profile not found.
Posted by "Lukman W. Kusuma" <lu...@commverge.com>.
Yes, Peter. I still use the same copy of my existing CVS and re-run the
sql below.
Think will have to survive with this at the moment. Will come back to it
soon.
Thanks for the help.
Lukman
Peter F. wrote:
>Hello Lukman,
>
>I don't use PSML-in-DB persistence.
>I decided to use file-based PSML storage (just default option) for a while.
>So I only needed to create and
>populate TURBINE_* tables. And I had a problem with this, as
>far as columns number doesn't match for some table in
>turbine-mysql.sql and populate-mysql.sql .
>
>If you need just to run as soon as possible, than you can try my way:
>1. Downlolad binary distribution with ready jetspeed.war file
>2. Manually unpack this WAR in \tomcat_home\webapps\jetspeed
>3. Change configuration files to use MySQL (not for PSML, just for
> users, groups etc.)
>4. Download from CVS turbine-mysql.sql and populate-mysql.sql
>5. Create and populate DB
>6. Run Tomcat
>
>Sorry, if this can't be useful for you.
>
>
>Wednesday, October 20, 2004, 5:49:42 PM, you wrote:
>
>LWK> One more thing, Peter. I observe populate-mysql.sql doesn't have any
>LWK> record insert to jetspeed's related profile tables (JETSPEED_****).
>LWK> Is this normal?
>
>LWK> Thanks
>
>LWK> Lukman
>
>
>LWK> 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> jetspeed-user-unsubscribe@jakarta.apache.org
>>>LWK> For additional commands, e-mail:
>>>LWK> jetspeed-user-help@jakarta.apache.org
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>
>
>LWK> ---------------------------------------------------------------------
>LWK> To unsubscribe, e-mail:
>LWK> jetspeed-user-unsubscribe@jakarta.apache.org
>LWK> For additional commands, e-mail:
>LWK> jetspeed-user-help@jakarta.apache.org
>
>
>
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org