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 "Nishant Malviya (JIRA)" <je...@portals.apache.org> on 2009/09/25 13:10:16 UTC

[jira] Created: (JS2-1067) Jetspeed 2.1.1 with MSSQL Server

Jetspeed 2.1.1 with MSSQL Server
--------------------------------

                 Key: JS2-1067
                 URL: https://issues.apache.org/jira/browse/JS2-1067
             Project: Jetspeed 2
          Issue Type: Task
          Components: Deployment
    Affects Versions: 2.1.1-RC
         Environment: Windows 2003 Server
            Reporter: Nishant Malviya
            Priority: Critical
             Fix For: 2.1.1-RC


I am unable to configure jetspeed 2.1.1 with MS-SQL server 2000-3a database server.

I did the following steps to configure jetspeed: 

Step 1: I have created the database using the scripts given in the product.
 the script had to be modified little to remove ON DELETE CASCADE to ON DELETE NO ACTION in some the of the tables. after making that change the database got created. but don't know if this will impact jetspeed.

Step 2: I tried to modify the database.properties with MSSQl driver and database information but still its taking derby as database.

Can you tell me the steps needed to configure jetspeed with this database. I cannot modify maven file and generate jetspeed as this jetspeed is deployed on customer site.


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org


[jira] Closed: (JS2-1067) Jetspeed 2.1.1 with MSSQL Server

Posted by "Nishant Malviya (JIRA)" <je...@portals.apache.org>.
     [ https://issues.apache.org/jira/browse/JS2-1067?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Nishant Malviya closed JS2-1067.
--------------------------------

    Resolution: Fixed

some insert statements are also required to work jetspeed with mssql

> Jetspeed 2.1.1 with MSSQL Server
> --------------------------------
>
>                 Key: JS2-1067
>                 URL: https://issues.apache.org/jira/browse/JS2-1067
>             Project: Jetspeed 2
>          Issue Type: Bug
>          Components: Deployment
>    Affects Versions: 2.1.1-RC
>         Environment: Windows 2003 Server
>            Reporter: Nishant Malviya
>            Assignee: David Sean Taylor
>            Priority: Critical
>             Fix For: 2.1.1-RC
>
>         Attachments: schema.zip
>
>
> I am unable to configure jetspeed 2.1.1 with MS-SQL server 2000-3a database server.
> I did the following steps to configure jetspeed: 
> Step 1: I have created the database using the scripts given in the product.
>  the script had to be modified little to remove ON DELETE CASCADE to ON DELETE NO ACTION in some the of the tables. after making that change the database got created. but don't know if this will impact jetspeed.
> Step 2: I tried to modify the database.properties with MSSQl driver and database information but still its taking derby as database.
> Can you tell me the steps needed to configure jetspeed with this database. I cannot modify maven file and generate jetspeed as this jetspeed is deployed on customer site.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org


[jira] Commented: (JS2-1067) Jetspeed 2.1.1 with MSSQL Server

Posted by "Nishant Malviya (JIRA)" <je...@portals.apache.org>.
    [ https://issues.apache.org/jira/browse/JS2-1067?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12760663#action_12760663 ] 

Nishant Malviya commented on JS2-1067:
--------------------------------------

I used the sql file from the issue no 1024, but could not make jetspeed up. My jetspeed version is 2.1.1. following exception comes on the browser while accessing portal.

-------------------------------------------------------------------------------

HTTP Status 500 - 

--------------------------------------------------------------------------------

type Exception report

message 

description The server encountered an internal error () that prevented it from fulfilling this request.

exception 

javax.servlet.ServletException: Fatal error encountered while processing portal request: org.apache.jetspeed.pipeline.PipelineException: Falied to create capabilitied:  We were unable to build a capability map for the agent, Mozilla/4.0.  This might be an indiciation that the capability database has not been correctly initialized.
	org.apache.jetspeed.engine.JetspeedServlet.doGet(JetspeedServlet.java:251)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	org.apache.jetspeed.login.filter.PortalFilter.doFilter(PortalFilter.java:141)
	org.apache.jetspeed.engine.servlet.XXSUrlAttackFilter.doFilter(XXSUrlAttackFilter.java:52)


root cause 

org.apache.jetspeed.pipeline.PipelineException: Falied to create capabilitied:  We were unable to build a capability map for the agent, Mozilla/4.0.  This might be an indiciation that the capability database has not been correctly initialized.
	org.apache.jetspeed.capabilities.impl.CapabilityValveImpl.invoke(CapabilityValveImpl.java:69)
	org.apache.jetspeed.pipeline.JetspeedPipeline$Invocation.invokeNext(JetspeedPipeline.java:167)
	org.apache.jetspeed.pipeline.JetspeedPipeline.invoke(JetspeedPipeline.java:146)
	org.apache.jetspeed.engine.JetspeedEngine.service(JetspeedEngine.java:227)
	org.apache.jetspeed.engine.JetspeedServlet.doGet(JetspeedServlet.java:242)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	org.apache.jetspeed.login.filter.PortalFilter.doFilter(PortalFilter.java:141)
	org.apache.jetspeed.engine.servlet.XXSUrlAttackFilter.doFilter(XXSUrlAttackFilter.java:52)


note The full stack trace of the root cause is available in the Apache Tomcat/5.5.20 logs.



> Jetspeed 2.1.1 with MSSQL Server
> --------------------------------
>
>                 Key: JS2-1067
>                 URL: https://issues.apache.org/jira/browse/JS2-1067
>             Project: Jetspeed 2
>          Issue Type: Bug
>          Components: Deployment
>    Affects Versions: 2.1.1-RC
>         Environment: Windows 2003 Server
>            Reporter: Nishant Malviya
>            Assignee: David Sean Taylor
>            Priority: Critical
>             Fix For: 2.1.1-RC
>
>
> I am unable to configure jetspeed 2.1.1 with MS-SQL server 2000-3a database server.
> I did the following steps to configure jetspeed: 
> Step 1: I have created the database using the scripts given in the product.
>  the script had to be modified little to remove ON DELETE CASCADE to ON DELETE NO ACTION in some the of the tables. after making that change the database got created. but don't know if this will impact jetspeed.
> Step 2: I tried to modify the database.properties with MSSQl driver and database information but still its taking derby as database.
> Can you tell me the steps needed to configure jetspeed with this database. I cannot modify maven file and generate jetspeed as this jetspeed is deployed on customer site.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org


[jira] Commented: (JS2-1067) Jetspeed 2.1.1 with MSSQL Server

Posted by "David Sean Taylor (JIRA)" <je...@portals.apache.org>.
    [ https://issues.apache.org/jira/browse/JS2-1067?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12760622#action_12760622 ] 

David Sean Taylor commented on JS2-1067:
----------------------------------------

We have a fix for that, see the scripts attached to 

https://issues.apache.org/jira/browse/JS2-1024

Just replace the existing files with the two attached files

Let me know if that works and we can close this issue as a duplicate of 1024

> Jetspeed 2.1.1 with MSSQL Server
> --------------------------------
>
>                 Key: JS2-1067
>                 URL: https://issues.apache.org/jira/browse/JS2-1067
>             Project: Jetspeed 2
>          Issue Type: Bug
>          Components: Deployment
>    Affects Versions: 2.1.1-RC
>         Environment: Windows 2003 Server
>            Reporter: Nishant Malviya
>            Priority: Critical
>             Fix For: 2.1.1-RC
>
>
> I am unable to configure jetspeed 2.1.1 with MS-SQL server 2000-3a database server.
> I did the following steps to configure jetspeed: 
> Step 1: I have created the database using the scripts given in the product.
>  the script had to be modified little to remove ON DELETE CASCADE to ON DELETE NO ACTION in some the of the tables. after making that change the database got created. but don't know if this will impact jetspeed.
> Step 2: I tried to modify the database.properties with MSSQl driver and database information but still its taking derby as database.
> Can you tell me the steps needed to configure jetspeed with this database. I cannot modify maven file and generate jetspeed as this jetspeed is deployed on customer site.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org


[jira] Updated: (JS2-1067) Jetspeed 2.1.1 with MSSQL Server

Posted by "David Sean Taylor (JIRA)" <je...@portals.apache.org>.
     [ https://issues.apache.org/jira/browse/JS2-1067?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

David Sean Taylor updated JS2-1067:
-----------------------------------

    Attachment: schema.zip

> Jetspeed 2.1.1 with MSSQL Server
> --------------------------------
>
>                 Key: JS2-1067
>                 URL: https://issues.apache.org/jira/browse/JS2-1067
>             Project: Jetspeed 2
>          Issue Type: Bug
>          Components: Deployment
>    Affects Versions: 2.1.1-RC
>         Environment: Windows 2003 Server
>            Reporter: Nishant Malviya
>            Assignee: David Sean Taylor
>            Priority: Critical
>             Fix For: 2.1.1-RC
>
>         Attachments: schema.zip
>
>
> I am unable to configure jetspeed 2.1.1 with MS-SQL server 2000-3a database server.
> I did the following steps to configure jetspeed: 
> Step 1: I have created the database using the scripts given in the product.
>  the script had to be modified little to remove ON DELETE CASCADE to ON DELETE NO ACTION in some the of the tables. after making that change the database got created. but don't know if this will impact jetspeed.
> Step 2: I tried to modify the database.properties with MSSQl driver and database information but still its taking derby as database.
> Can you tell me the steps needed to configure jetspeed with this database. I cannot modify maven file and generate jetspeed as this jetspeed is deployed on customer site.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org


[jira] Updated: (JS2-1067) Jetspeed 2.1.1 with MSSQL Server

Posted by "Nishant Malviya (JIRA)" <je...@portals.apache.org>.
     [ https://issues.apache.org/jira/browse/JS2-1067?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Nishant Malviya updated JS2-1067:
---------------------------------

    Issue Type: Bug  (was: Task)

> Jetspeed 2.1.1 with MSSQL Server
> --------------------------------
>
>                 Key: JS2-1067
>                 URL: https://issues.apache.org/jira/browse/JS2-1067
>             Project: Jetspeed 2
>          Issue Type: Bug
>          Components: Deployment
>    Affects Versions: 2.1.1-RC
>         Environment: Windows 2003 Server
>            Reporter: Nishant Malviya
>            Priority: Critical
>             Fix For: 2.1.1-RC
>
>
> I am unable to configure jetspeed 2.1.1 with MS-SQL server 2000-3a database server.
> I did the following steps to configure jetspeed: 
> Step 1: I have created the database using the scripts given in the product.
>  the script had to be modified little to remove ON DELETE CASCADE to ON DELETE NO ACTION in some the of the tables. after making that change the database got created. but don't know if this will impact jetspeed.
> Step 2: I tried to modify the database.properties with MSSQl driver and database information but still its taking derby as database.
> Can you tell me the steps needed to configure jetspeed with this database. I cannot modify maven file and generate jetspeed as this jetspeed is deployed on customer site.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org


[jira] Commented: (JS2-1067) Jetspeed 2.1.1 with MSSQL Server

Posted by "David Sean Taylor (JIRA)" <je...@portals.apache.org>.
    [ https://issues.apache.org/jira/browse/JS2-1067?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12760670#action_12760670 ] 

David Sean Taylor commented on JS2-1067:
----------------------------------------

Ah, I read 2.2.1, sorry. You should grab the scripts from the 2.1.3 final release or 2.1.4 development head. I will attach them

> Jetspeed 2.1.1 with MSSQL Server
> --------------------------------
>
>                 Key: JS2-1067
>                 URL: https://issues.apache.org/jira/browse/JS2-1067
>             Project: Jetspeed 2
>          Issue Type: Bug
>          Components: Deployment
>    Affects Versions: 2.1.1-RC
>         Environment: Windows 2003 Server
>            Reporter: Nishant Malviya
>            Assignee: David Sean Taylor
>            Priority: Critical
>             Fix For: 2.1.1-RC
>
>
> I am unable to configure jetspeed 2.1.1 with MS-SQL server 2000-3a database server.
> I did the following steps to configure jetspeed: 
> Step 1: I have created the database using the scripts given in the product.
>  the script had to be modified little to remove ON DELETE CASCADE to ON DELETE NO ACTION in some the of the tables. after making that change the database got created. but don't know if this will impact jetspeed.
> Step 2: I tried to modify the database.properties with MSSQl driver and database information but still its taking derby as database.
> Can you tell me the steps needed to configure jetspeed with this database. I cannot modify maven file and generate jetspeed as this jetspeed is deployed on customer site.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org


[jira] Assigned: (JS2-1067) Jetspeed 2.1.1 with MSSQL Server

Posted by "David Sean Taylor (JIRA)" <je...@portals.apache.org>.
     [ https://issues.apache.org/jira/browse/JS2-1067?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

David Sean Taylor reassigned JS2-1067:
--------------------------------------

    Assignee: David Sean Taylor

> Jetspeed 2.1.1 with MSSQL Server
> --------------------------------
>
>                 Key: JS2-1067
>                 URL: https://issues.apache.org/jira/browse/JS2-1067
>             Project: Jetspeed 2
>          Issue Type: Bug
>          Components: Deployment
>    Affects Versions: 2.1.1-RC
>         Environment: Windows 2003 Server
>            Reporter: Nishant Malviya
>            Assignee: David Sean Taylor
>            Priority: Critical
>             Fix For: 2.1.1-RC
>
>
> I am unable to configure jetspeed 2.1.1 with MS-SQL server 2000-3a database server.
> I did the following steps to configure jetspeed: 
> Step 1: I have created the database using the scripts given in the product.
>  the script had to be modified little to remove ON DELETE CASCADE to ON DELETE NO ACTION in some the of the tables. after making that change the database got created. but don't know if this will impact jetspeed.
> Step 2: I tried to modify the database.properties with MSSQl driver and database information but still its taking derby as database.
> Can you tell me the steps needed to configure jetspeed with this database. I cannot modify maven file and generate jetspeed as this jetspeed is deployed on customer site.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org