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 "Dalton, Michael D" <Mi...@nasa.gov> on 2004/04/21 17:19:16 UTC
PSML References Can't Be Removed or Deleted - MSSQL
We have a show stopper here that I hope one of you guys can help me on.
Configuration:
Using Microsoft SQL (MSSQL) database for users "and" PSML.
Jetspeed 1.4 release with a few custom modules being used.
Tomcat 5
Microsoft IIS 4 w/Tomcat JK2.0.2 Web Server Connector (IIS, Tomcat and
MSSQL on same machine)
We recently upgraded from mySQL.
Scenario:
We are using some special accounts such as "_help" to reference from
other accounts. We configured this based on a post by Boyd Fletcher
(see posts titled Mandatory Tab / Portlets). This worked under a "file
based" PSML system.
Once we upgraded to a database PSML system we started running into
problems. Here is an example of one big problem. We have a _newuser
account which has several referenced tabs that look like the following
in the framework:
Home News Headlines Search ... Help
Each of the tabs above have their own user account.
The problem we are running into now with the MSSQL database is that
"once a reference" is made it "cannot" be removed or deleted. For
example, if I try to delete the Search tab above under the "Customize:
HTML" link it appears to get removed until I apply the changes. It just
continues to show up. Very weird.
I thought it might have something to do with MSSQL setting so I set each
table to have all permission (e.g., read, write, delete, etc) but that
didn't work.
Also, the other problem we are experiencing is that the "Customize:
HTML" page does not always have all of the items it should. Clicking on
the X or up/down buttoms produces strange results.
Any ideas?????? All help appreciated.
Our PSML manager settings are as follows:
services.PsmlManager.root=/WEB-INF/psml
services.PsmlManager.ext=.psml
services.PsmlManager.mapping=/WEB-INF/conf/psml-mapping.xml
services.PsmlManager.caching-on=false
#services.PsmlManager.default-resource=default.psml
#services.PsmlManager.media-types=html:wml
#services.PsmlManager.admin=admin
## only used by Castor(File) PSML Manager
# scan rate in seconds (every 2 minutes)
#services.PsmlManager.scanRate=120
services.PsmlManager.scanRate=1
# cache size - number of PSML pages to cache
#services.PsmlManager.cacheSize=100
services.PsmlManager.cacheSize=0
Michael.D.Dalton@nasa.gov
Internet Business Manager
Computing Systems Services Branch
Information Technology Directorate
IT-D3-A
Kennedy Space Center, FL 32899
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
RE: PSML References Can't Be Removed or Deleted - MSSQL
Posted by Mark Orciuch <ma...@ngsltd.com>.
This known issue is documented in "References usage notes for release 1.4"
section of README. Yes, it should be logged in JIRA as well.
Best regards,
Mark C. Orciuch
Next Generation Solutions, Ltd.
e-Mail: mark_orciuch@ngsltd.com
web: http://www.ngsltd.com
> -----Original Message-----
> From: David Sean Taylor [mailto:david@bluesunrise.com]
> Sent: Wednesday, April 21, 2004 12:52 PM
> To: Jetspeed Users List
> Subject: Re: PSML References Can't Be Removed or Deleted - MSSQL
>
>
>
> On Apr 21, 2004, at 8:19 AM, Dalton, Michael D wrote:
>
> > We have a show stopper here that I hope one of you guys can help me on.
> >
> > Configuration:
> > Using Microsoft SQL (MSSQL) database for users "and" PSML.
> > Jetspeed 1.4 release with a few custom modules being used.
> > Tomcat 5
> > Microsoft IIS 4 w/Tomcat JK2.0.2 Web Server Connector (IIS, Tomcat and
> > MSSQL on same machine)
> > We recently upgraded from mySQL.
> >
> > Scenario:
> > We are using some special accounts such as "_help" to reference from
> > other accounts. We configured this based on a post by Boyd Fletcher
> > (see posts titled Mandatory Tab / Portlets). This worked under a "file
> > based" PSML system.
> >
> > Once we upgraded to a database PSML system we started running into
> > problems. Here is an example of one big problem. We have a _newuser
> > account which has several referenced tabs that look like the following
> > in the framework:
>
> >
> > Home News Headlines Search ... Help
> >
> > Each of the tabs above have their own user account.
> >
> > The problem we are running into now with the MSSQL database is that
> > "once a reference" is made it "cannot" be removed or deleted. For
> > example, if I try to delete the Search tab above under the "Customize:
> > HTML" link it appears to get removed until I apply the changes. It
> > just
> > continues to show up. Very weird.
> >
>
> Are you saying that this bug only happens with DBPSML, and not with
> PSML on the file system?
> I know there is an issue with deleting references and caching.
> Try restarting the server.
> When you restart the server, does the reference still appear?
>
> > I thought it might have something to do with MSSQL setting so I set
> > each
> > table to have all permission (e.g., read, write, delete, etc) but that
> > didn't work.
> >
> > Also, the other problem we are experiencing is that the "Customize:
> > HTML" page does not always have all of the items it should. Clicking
> > on
> > the X or up/down buttoms produces strange results.
> >
> > Any ideas?????? All help appreciated.
>
> Customizing with references is known to be buggy.
> I think Mark Orciuch has also experienced problems with customizing
> references.
> Suggest logging an issue in JIRA and hopefully someone will look into
> it.
> If you guys can clearly identify the problem I may have time to look at
> it later this week, although I wanted to release 1.5 on Thursday or
> Friday.
> We need to decide if this bug should stop the release or not.
> Be interested to hear Mark's opinion on this since he is more involved
> in 1.x that I am these days
>
> --
> David Sean Taylor
> Bluesunrise Software
> david@bluesunrise.com
> [office] +01 707 773-4646
> [mobile] +01 707 529 9194
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: 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
Re: PSML References Can't Be Removed or Deleted - MSSQL
Posted by David Sean Taylor <da...@bluesunrise.com>.
On Apr 21, 2004, at 8:19 AM, Dalton, Michael D wrote:
> We have a show stopper here that I hope one of you guys can help me on.
>
> Configuration:
> Using Microsoft SQL (MSSQL) database for users "and" PSML.
> Jetspeed 1.4 release with a few custom modules being used.
> Tomcat 5
> Microsoft IIS 4 w/Tomcat JK2.0.2 Web Server Connector (IIS, Tomcat and
> MSSQL on same machine)
> We recently upgraded from mySQL.
>
> Scenario:
> We are using some special accounts such as "_help" to reference from
> other accounts. We configured this based on a post by Boyd Fletcher
> (see posts titled Mandatory Tab / Portlets). This worked under a "file
> based" PSML system.
>
> Once we upgraded to a database PSML system we started running into
> problems. Here is an example of one big problem. We have a _newuser
> account which has several referenced tabs that look like the following
> in the framework:
>
> Home News Headlines Search ... Help
>
> Each of the tabs above have their own user account.
>
> The problem we are running into now with the MSSQL database is that
> "once a reference" is made it "cannot" be removed or deleted. For
> example, if I try to delete the Search tab above under the "Customize:
> HTML" link it appears to get removed until I apply the changes. It
> just
> continues to show up. Very weird.
>
Are you saying that this bug only happens with DBPSML, and not with
PSML on the file system?
I know there is an issue with deleting references and caching.
Try restarting the server.
When you restart the server, does the reference still appear?
> I thought it might have something to do with MSSQL setting so I set
> each
> table to have all permission (e.g., read, write, delete, etc) but that
> didn't work.
>
> Also, the other problem we are experiencing is that the "Customize:
> HTML" page does not always have all of the items it should. Clicking
> on
> the X or up/down buttoms produces strange results.
>
> Any ideas?????? All help appreciated.
Customizing with references is known to be buggy.
I think Mark Orciuch has also experienced problems with customizing
references.
Suggest logging an issue in JIRA and hopefully someone will look into
it.
If you guys can clearly identify the problem I may have time to look at
it later this week, although I wanted to release 1.5 on Thursday or
Friday.
We need to decide if this bug should stop the release or not.
Be interested to hear Mark's opinion on this since he is more involved
in 1.x that I am these days
--
David Sean Taylor
Bluesunrise Software
david@bluesunrise.com
[office] +01 707 773-4646
[mobile] +01 707 529 9194
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org