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 Jyothi Gangadharan <jg...@interchangedigital.com> on 2002/05/31 16:48:27 UTC
Fwd: Re(2): Help : Using jetspeed with MS Sql
Hello,
I was using the release version earlier so I tried with jetspeed src from
may 27 & later using version from may 28 & may 30
1) Built the turbine-schema.sql for mssql in Torque folder
2) created the db on MSSql server & ran the script from turbine-schema.sql
3) Built jetspeed war file( After some alteration of Java code in
org.Apache.jetspeed.om.dbpsml.BaseIdTablePeer.Java)
4) deployed it on war file on to tomcat4.0(copying it to webapps dir)
4) Copied the mssqlserver's jar files to app/web-inf/lib folder
5) Modified both torque.prop & TR.properties to use(Altering just the
Tr.properties doesn't work on these versions since it uses Torque
.properties file to talk to DB)
[ you can test which database the webApp uses by adding a new contact &
then check for the new user by Querying on table TURBINE_USER in your
local MSSql Database .
Let me know If you have any success. ]
database.default.driver=com.microsoft.jdbc.sqlserver.SQLServerDriver
database.default.URL=jdbc:microsoft:sqlserver://<hostname>:<port>;SelectMethod=cursor
database.default.username=sa
database.default.password=
database.adaptor=DBMSSQL
database.adaptor.DBMSSQL=com.microsoft.jdbc.sqlserver.SQLServerDriver
7)started tomcat
8)When I Log In using userName:turbine and passwd:turbine I still get a ig
nasty Error given Below
---------------
Horrible Exception: Java.lang.NoClassDefFoundError at
org.apache.turbine.services.security.db.DBUserManager.retrieve(DBUserManager.java:158)
at
org.apache.turbine.services.security.db.DBUserManager.retrieve(DBUserManager.java:246)
at
org.apache.turbine.services.security.BaseSecurityService.getAuthenticatedUser(BaseSecurityService.java:313)
at
org.apache.jetspeed.services.security.JetspeedDBSecurityService.getAuthenticatedUser(JetspeedDBSecurityService.java:472)
at
org.apache.turbine.services.security.TurbineSecurity.getAuthenticatedUser(TurbineSecurity.java:199)
at
org.apache.turbine.modules.actions.LoginUser.doPerform(LoginUser.java:111)
at org.apache.turbine.modules.Action.perform(Action.java:87) at
org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122) at
org.apache.jetspeed.modules.actions.JLoginUser.doPerform(JLoginUser.java:253)
at org.apache.turbine.modules.ActionEvent.perform(ActionEvent.java:148) at
org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122) at
org.apache.turbine.Turbine.doGet(Turbine.java:456) at
org.apache.turbine.Turbine.doPost(Turbine.java:616) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
rg.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
rg.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
at
---------------
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re(2): Fwd: Re(2): Help : Using jetspeed with MS Sql
Posted by Jyothi Gangadharan <jg...@interchangedigital.com>.
Yes, I have the MSsqlserver jdbc driver in lib folder.
Since the Exception I get is.
IS there a conf setting for using/not using a Trusted Connection??
---------------
Horrible Exception: java.lang.Error: Error in
BasePeer.initTableSchema(TURBINE_USER): [Microsoft][SQLServer 2000 Driver
for JDBC][SQLServer]Login failed for user '(null)'. Reason: Not associated
with a trusted SQL Server connection. at
org.apache.turbine.om.peer.BasePeer.initTableSchema(BasePeer.java:232) at
org.apache.turbine.om.peer.BasePeer.initTableSchema(BasePeer.java:194) at
org.apache.turbine.om.security.peer.TurbineUserPeer.(
--------------------------------------------
---------------
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Fwd: Re(2): Help : Using jetspeed with MS Sql
Posted by James Lee <j2...@yahoo.com>.
Another thing to check, is to make sure your JDBC
driver is in the right directory:
<jetspeed-root>/WEB-INF/lib/
sounds obvious, but i forgot the first time
james
--- Jyothi Gangadharan
<jg...@interchangedigital.com> wrote:
> Hello,
>
> I was using the release version earlier so I tried
> with jetspeed src from
> may 27 & later using version from may 28 & may 30
>
> 1) Built the turbine-schema.sql for mssql in Torque
> folder
> 2) created the db on MSSql server & ran the script
> from turbine-schema.sql
> 3) Built jetspeed war file( After some alteration of
> Java code in
> org.Apache.jetspeed.om.dbpsml.BaseIdTablePeer.Java)
> 4) deployed it on war file on to tomcat4.0(copying
> it to webapps dir)
> 4) Copied the mssqlserver's jar files to
> app/web-inf/lib folder
> 5) Modified both torque.prop & TR.properties to
> use(Altering just the
> Tr.properties doesn't work on these versions since
> it uses Torque
> .properties file to talk to DB)
>
> [ you can test which database the webApp uses by
> adding a new contact &
> then check for the new user by Querying on table
> TURBINE_USER in your
> local MSSql Database .
> Let me know If you have any success. ]
>
>
database.default.driver=com.microsoft.jdbc.sqlserver.SQLServerDriver
>
database.default.URL=jdbc:microsoft:sqlserver://<hostname>:<port>;SelectMethod=cursor
> database.default.username=sa
> database.default.password=
>
> database.adaptor=DBMSSQL
>
database.adaptor.DBMSSQL=com.microsoft.jdbc.sqlserver.SQLServerDriver
>
> 7)started tomcat
> 8)When I Log In using userName:turbine and
> passwd:turbine I still get a ig
> nasty Error given Below
>
> ---------------
> Horrible Exception: Java.lang.NoClassDefFoundError
> at
>
org.apache.turbine.services.security.db.DBUserManager.retrieve(DBUserManager.java:158)
> at
>
org.apache.turbine.services.security.db.DBUserManager.retrieve(DBUserManager.java:246)
> at
>
org.apache.turbine.services.security.BaseSecurityService.getAuthenticatedUser(BaseSecurityService.java:313)
> at
>
org.apache.jetspeed.services.security.JetspeedDBSecurityService.getAuthenticatedUser(JetspeedDBSecurityService.java:472)
> at
>
org.apache.turbine.services.security.TurbineSecurity.getAuthenticatedUser(TurbineSecurity.java:199)
> at
>
org.apache.turbine.modules.actions.LoginUser.doPerform(LoginUser.java:111)
> at
>
org.apache.turbine.modules.Action.perform(Action.java:87)
> at
>
org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122)
> at
>
org.apache.jetspeed.modules.actions.JLoginUser.doPerform(JLoginUser.java:253)
> at
>
org.apache.turbine.modules.ActionEvent.perform(ActionEvent.java:148)
> at
>
org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122)
> at
> org.apache.turbine.Turbine.doGet(Turbine.java:456)
> at
> org.apache.turbine.Turbine.doPost(Turbine.java:616)
> at
>
javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
> at
>
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
>
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
> at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
> at
>
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
> at
>
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
>
rg.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
> at
>
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
> at
>
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
>
rg.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343)
> at
>
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
> at
>
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
> at
>
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
> at
>
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
> at
>
> ---------------
>
>
> --
> To unsubscribe, e-mail:
>
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
> <ma...@jakarta.apache.org>
>
__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Fwd: Re(2): Help : Using jetspeed with MS Sql
Posted by James Lee <j2...@yahoo.com>.
Another thing to check, is to make sure your JDBC
driver is in the right directory:
<jets
sounds obvious, but i forgot
--- Jyothi Gangadharan
<jg...@interchangedigital.com> wrote:
> Hello,
>
> I was using the release version earlier so I tried
> with jetspeed src from
> may 27 & later using version from may 28 & may 30
>
> 1) Built the turbine-schema.sql for mssql in Torque
> folder
> 2) created the db on MSSql server & ran the script
> from turbine-schema.sql
> 3) Built jetspeed war file( After some alteration of
> Java code in
> org.Apache.jetspeed.om.dbpsml.BaseIdTablePeer.Java)
> 4) deployed it on war file on to tomcat4.0(copying
> it to webapps dir)
> 4) Copied the mssqlserver's jar files to
> app/web-inf/lib folder
> 5) Modified both torque.prop & TR.properties to
> use(Altering just the
> Tr.properties doesn't work on these versions since
> it uses Torque
> .properties file to talk to DB)
>
> [ you can test which database the webApp uses by
> adding a new contact &
> then check for the new user by Querying on table
> TURBINE_USER in your
> local MSSql Database .
> Let me know If you have any success. ]
>
>
database.default.driver=com.microsoft.jdbc.sqlserver.SQLServerDriver
>
database.default.URL=jdbc:microsoft:sqlserver://<hostname>:<port>;SelectMethod=cursor
> database.default.username=sa
> database.default.password=
>
> database.adaptor=DBMSSQL
>
database.adaptor.DBMSSQL=com.microsoft.jdbc.sqlserver.SQLServerDriver
>
> 7)started tomcat
> 8)When I Log In using userName:turbine and
> passwd:turbine I still get a ig
> nasty Error given Below
>
> ---------------
> Horrible Exception: Java.lang.NoClassDefFoundError
> at
>
org.apache.turbine.services.security.db.DBUserManager.retrieve(DBUserManager.java:158)
> at
>
org.apache.turbine.services.security.db.DBUserManager.retrieve(DBUserManager.java:246)
> at
>
org.apache.turbine.services.security.BaseSecurityService.getAuthenticatedUser(BaseSecurityService.java:313)
> at
>
org.apache.jetspeed.services.security.JetspeedDBSecurityService.getAuthenticatedUser(JetspeedDBSecurityService.java:472)
> at
>
org.apache.turbine.services.security.TurbineSecurity.getAuthenticatedUser(TurbineSecurity.java:199)
> at
>
org.apache.turbine.modules.actions.LoginUser.doPerform(LoginUser.java:111)
> at
>
org.apache.turbine.modules.Action.perform(Action.java:87)
> at
>
org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122)
> at
>
org.apache.jetspeed.modules.actions.JLoginUser.doPerform(JLoginUser.java:253)
> at
>
org.apache.turbine.modules.ActionEvent.perform(ActionEvent.java:148)
> at
>
org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122)
> at
> org.apache.turbine.Turbine.doGet(Turbine.java:456)
> at
> org.apache.turbine.Turbine.doPost(Turbine.java:616)
> at
>
javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
> at
>
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
>
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
> at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
> at
>
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
> at
>
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
>
rg.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
> at
>
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
> at
>
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
> at
>
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
>
rg.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343)
> at
>
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
> at
>
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
> at
>
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
> at
>
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
> at
>
> ---------------
>
>
> --
> To unsubscribe, e-mail:
>
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
> <ma...@jakarta.apache.org>
>
__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>