Well, I finally got it working, but I had to a) upgrade to tomcat 5.0.28, b) go to the release version of jetspeed 2 rather than the version from CVS, c) make sure the mysql connection jar was in the right place (it was in 5.0.27, but I forgot it initially in 5.0.28), and d) undeploy and redeploy a few times. I'm still getting errors on the third party and test suite portlets, but at least I got logged in as admin finally.
-Jack On Sun, 2005-02-06 at 23:05 -0500, Jason Negrette wrote: > I'm actually getting this exact same problem. So please, if anyone else > knows or you yourself figure it out, pass the answer on to me. I would > be eternally grateful. Thank you! > > Jason > > Jack Lund wrote: > > >Okay, here's what I can figure out: > > > >My initial problem seemed to be because, although I thought I was using > >tomcat 5.0.28, I was actually using 5.0.27. Once I switched to tomcat > >5.0.28, it actually got worse. Now, I don't even get the welcome page, > >instead I get a 500 error: > > > >javax.servlet.ServletException: Failed to initalize jetspeed. > >org.apache.jetspeed.exception.JetspeedException: Unable to create Engine > > > > > > org.apache.jetspeed.engine.JetspeedServlet.doGet(JetspeedServlet.java:206) > > javax.servlet.http.HttpServlet.service(HttpServlet.java:689) > > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > > > > org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:670) > > > > org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:637) > > org.apache.jsp.index_jsp._jspService(index_jsp.java:44) > > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) > > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > > > > org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324) > > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292) > > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) > > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > > > > > >root cause > > > > > >org.apache.jetspeed.exception.JetspeedException: Unable to create Engine > > org.apache.jetspeed.Jetspeed.createEngine(Jetspeed.java:76) > > > > org.apache.jetspeed.engine.JetspeedServlet.init(JetspeedServlet.java:135) > > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > > > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > > java.lang.reflect.Method.invoke(Method.java:324) > > > > org.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:216) > > org.apache.commons.digester.SetNextRule.end(SetNextRule.java:256) > > org.apache.commons.digester.Rule.end(Rule.java:276) > > org.apache.commons.digester.Digester.endElement(Digester.java:1058) > > > > org.apache.catalina.util.CatalinaDigester.endElement(CatalinaDigester.java:76) > > org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source) > > > > org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown > > Source) > > > > org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown > > Source) > > > > org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown > > Source) > > org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) > > org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) > > org.apache.xerces.parsers.XMLParser.parse(Unknown Source) > > org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) > > org.apache.commons.digester.Digester.parse(Digester.java:1567) > > > > org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:483) > > org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:427) > > org.apache.catalina.startup.HostConfig.start(HostConfig.java:983) > > > > org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:349) > > > > org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) > > org.apache.catalina.startup.Catalina.start(Catalina.java:556) > > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > > > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > > java.lang.reflect.Method.invoke(Method.java:324) > > org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:287) > > org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:425) > > > >In the tomcat logs, I have a null pointer exception: > > > >2005-02-06 21:21:33 > >StandardContext[/balancer]org.apache.webapp.balancer.BalancerFilter: init(): > >ruleChain: [org.apache.webapp.balancer.RuleChain: > >[org.apache.webapp.balancer.rules.URLStringMatchRule: Target string: News / > >Redirect URL: http://www.cnn.com], > >[org.apache.webapp.balancer.rules.RequestParameterRule: Target param name: > >paramName / Target param value: paramValue / Redirect URL: > >http://www.yahoo.com], > >[org.apache.webapp.balancer.rules.AcceptEverythingRule: Redirect URL: > >http://jakarta.apache.org]] > >2005-02-06 21:21:38 StandardContext[/jetspeed]JetspeedContainerServlet: > >starting initialization of context Jetspeed-2 Enterprise Portal > >2005-02-06 21:21:38 StandardContext[/jetspeed]JetspeedContainerServlet: > >Initialization complete for context Jetspeed-2 Enterprise Portal > >2005-02-06 21:21:39 StandardContext[/jetspeed]StandardWrapper.Throwable > >java.lang.NullPointerException > > at > > org.apache.jetspeed.velocity.JetspeedVelocityViewServlet.init(JetspeedVelocityViewServlet.java:137) > > at > > org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1029) > > at > > org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:862) > > at > > org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4013) > > at > > org.apache.catalina.core.StandardContext.start(StandardContext.java:4357) > > at > > org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:823) > > at > > org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807) > > at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595) > > at > > org.apache.catalina.core.StandardHostDeployer.addChild(StandardHostDeployer.java:903) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > > at java.lang.reflect.Method.invoke(Method.java:324) > > at > > org.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:216) > > at org.apache.commons.digester.SetNextRule.end(SetNextRule.java:256) > > at org.apache.commons.digester.Rule.end(Rule.java:276) > > at org.apache.commons.digester.Digester.endElement(Digester.java:1058) > > at > > org.apache.catalina.util.CatalinaDigester.endElement(CatalinaDigester.java:76) > > at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown > > Source) > > at > > org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown > > Source) > > at > > org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown > > Source) > > at > > org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown > > Source) > > at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) > > at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) > > at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) > > at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) > > at org.apache.commons.digester.Digester.parse(Digester.java:1567) > > at > > org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:488) > > at org.apache.catalina.core.StandardHost.install(StandardHost.java:863) > > at > > org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:483) > > at > > org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:427) > > at org.apache.catalina.startup.HostConfig.start(HostConfig.java:983) > > at > > org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:349) > > at > > org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) > > at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1091) > > at org.apache.catalina.core.StandardHost.start(StandardHost.java:789) > > at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083) > > at > > org.apache.catalina.core.StandardEngine.start(StandardEngine.java:478) > > at > > org.apache.catalina.core.StandardService.start(StandardService.java:480) > > at > > org.apache.catalina.core.StandardServer.start(StandardServer.java:2313) > > at org.apache.catalina.startup.Catalina.start(Catalina.java:556) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > > at java.lang.reflect.Method.invoke(Method.java:324) > > at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:287) > > at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:425) > > > >2005-02-06 21:21:39 StandardContext[/jetspeed]Servlet /jetspeed threw load() > >exception > >javax.servlet.ServletException: Servlet.init() for servlet velocity threw > >exception > > at > > org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1071) > > at > > org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:862) > > at > > org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4013) > > at > > org.apache.catalina.core.StandardContext.start(StandardContext.java:4357) > > at > > org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:823) > > at > > org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807) > > at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595) > > at > > org.apache.catalina.core.StandardHostDeployer.addChild(StandardHostDeployer.java:903) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > > at java.lang.reflect.Method.invoke(Method.java:324) > > at > > org.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:216) > > at org.apache.commons.digester.SetNextRule.end(SetNextRule.java:256) > > at org.apache.commons.digester.Rule.end(Rule.java:276) > > at org.apache.commons.digester.Digester.endElement(Digester.java:1058) > > at > > org.apache.catalina.util.CatalinaDigester.endElement(CatalinaDigester.java:76) > > at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown > > Source) > > at > > org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown > > Source) > > at > > org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown > > Source) > > at > > org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown > > Source) > > at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) > > at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) > > at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) > > at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) > > at org.apache.commons.digester.Digester.parse(Digester.java:1567) > > at > > org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:488) > > at org.apache.catalina.core.StandardHost.install(StandardHost.java:863) > > at > > org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:483) > > at > > org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:427) > > at org.apache.catalina.startup.HostConfig.start(HostConfig.java:983) > > at > > org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:349) > > at > > org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) > > at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1091) > > at org.apache.catalina.core.StandardHost.start(StandardHost.java:789) > > at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083) > > at > > org.apache.catalina.core.StandardEngine.start(StandardEngine.java:478) > > at > > org.apache.catalina.core.StandardService.start(StandardService.java:480) > > at > > org.apache.catalina.core.StandardServer.start(StandardServer.java:2313) > > at org.apache.catalina.startup.Catalina.start(Catalina.java:556) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > > at java.lang.reflect.Method.invoke(Method.java:324) > > at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:287) > > at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:425) > >----- Root Cause ----- > >java.lang.NullPointerException > > at > > org.apache.jetspeed.velocity.JetspeedVelocityViewServlet.init(JetspeedVelocityViewServlet.java:137) > > at > > org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1029) > > at > > org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:862) > > at > > org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4013) > > at > > org.apache.catalina.core.StandardContext.start(StandardContext.java:4357) > > at > > org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:823) > > at > > org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807) > > at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595) > > at > > org.apache.catalina.core.StandardHostDeployer.addChild(StandardHostDeployer.java:903) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > > at java.lang.reflect.Method.invoke(Method.java:324) > > at > > org.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:216) > > at org.apache.commons.digester.SetNextRule.end(SetNextRule.java:256) > > at org.apache.commons.digester.Rule.end(Rule.java:276) > > at org.apache.commons.digester.Digester.endElement(Digester.java:1058) > > at > > org.apache.catalina.util.CatalinaDigester.endElement(CatalinaDigester.java:76) > > at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown > > Source) > > at > > org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown > > Source) > > at > > org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown > > Source) > > at > > org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown > > Source) > > at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) > > at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) > > at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) > > at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) > > at org.apache.commons.digester.Digester.parse(Digester.java:1567) > > at > > org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:488) > > at org.apache.catalina.core.StandardHost.install(StandardHost.java:863) > > at > > org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:483) > > at > > org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:427) > > at org.apache.catalina.startup.HostConfig.start(HostConfig.java:983) > > at > > org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:349) > > at > > org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) > > at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1091) > > at org.apache.catalina.core.StandardHost.start(StandardHost.java:789) > > at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083) > > at > > org.apache.catalina.core.StandardEngine.start(StandardEngine.java:478) > > at > > org.apache.catalina.core.StandardService.start(StandardService.java:480) > > at > > org.apache.catalina.core.StandardServer.start(StandardServer.java:2313) > > at org.apache.catalina.startup.Catalina.start(Catalina.java:556) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > > at java.lang.reflect.Method.invoke(Method.java:324) > > at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:287) > > at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:425) > > > >So, I switched from using the latest CVS source to using the 2.0M1 source. > >That also fails, giving me a different null pointer exception. > > > >It's getting late, so I'll pursue it later. If anyone has any ideas on > >what's going on, please let me know. > > > >Thanks. > > > >-Jack > > > > > > > >On Sun, 2005-02-06 at 16:58 -0600, Jack Lund wrote: > > > > > > > >>Okay, here's my jetspeed.xml file: > >> > >><Context path="/jetspeed" docBase="jetspeed" crossContext="true"> > >> > >> <Realm className="org.apache.catalina.realm.JAASRealm" > >> appName="Jetspeed" > >> > >>userClassNames="org.apache.jetspeed.security.impl.UserPrincipalImpl" > >> > >>roleClassNames="org.apache.jetspeed.security.impl.RolePrincipalImpl" > >> useContextClassLoader="false" > >> debug="3"/> > >> > >> <ResourceParams name="jdbc/jetspeed"> > >> <parameter> > >> <name>factory</name> > >> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> > >> </parameter> > >> > >> <!-- Maximum number of dB connections in pool. Make sure you > >> configure your mysqld max_connections large enough to handle > >> all of your db connections. Set to 0 for no limit. > >> --> > >> <parameter> > >> <name>maxActive</name> > >> <value>100</value> > >> </parameter> > >> > >> <!-- Maximum number of idle dB connections to retain in pool. > >> Set to 0 for no limit. > >> --> > >> <parameter> > >> <name>maxIdle</name> > >> <value>30</value> > >> </parameter> > >> > >> <!-- Maximum time to wait for a dB connection to become available > >> in ms, in this example 10 seconds. An Exception is thrown if > >> this timeout is exceeded. Set to -1 to wait indefinitely. > >> --> > >> <parameter> > >> <name>maxWait</name> > >> <value>10000</value> > >> </parameter> > >> > >> <!-- HSQL dB username and password for dB connections --> > >> <parameter> > >> <name>username</name> > >> <value>jetspeed2</value> > >> </parameter> > >> <parameter> > >> <name>password</name> > >> <value>jetspeed2</value> > >> </parameter> > >> > >> <!-- Class name for HSQL JDBC driver --> > >> <parameter> > >> <name>driverClassName</name> > >> <value>com.mysql.jdbc.Driver</value> > >> </parameter> > >> > >> <!-- The JDBC connection url for connecting to your HSQL dB. --> > >> <parameter> > >> <name>url</name> > >> <value>jdbc:mysql://localhost/j2</value> > >> </parameter> > >> </ResourceParams> > >> > >></Context> > >> > >>All the parameters seem to be correct for my mysql database. When I try > >>to access it, here's what I have: > >> > >>$ mysql -ujetspeed2 -pjetspeed2 j2 > >>Reading table information for completion of table and column names > >>You can turn off this feature to get a quicker startup with -A > >> > >>Welcome to the MySQL monitor. Commands end with ; or \g. > >>Your MySQL connection id is 56 to server version: 3.23.58 > >> > >>Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > >> > >>mysql> select * from SECURITY_CREDENTIAL; > >>+---------------+--------------+----------+------ > >>+--------------------------------------------------------------------- > >>+-----------------+------------+------------+--------------- > >>+------------+----------------+----------------+---------------- > >>+----------------+-----------------+ > >>| CREDENTIAL_ID | PRINCIPAL_ID | VALUE | TYPE | CLASSNAME > >>| UPDATE_REQUIRED | IS_ENCODED | IS_ENABLED | AUTH_FAILURES | IS_EXPIRED > >>| CREATION_DATE | MODIFIED_DATE | PREV_AUTH_DATE | LAST_AUTH_DATE | > >>EXPIRATION_DATE | > >>+---------------+--------------+----------+------ > >>+--------------------------------------------------------------------- > >>+-----------------+------------+------------+--------------- > >>+------------+----------------+----------------+---------------- > >>+----------------+-----------------+ > >>| 1 | 1 | admin | 0 | > >>org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl | > >>0 | 0 | 1 | 0 | 0 | 20040522162712 | > >>20040522162712 | 20050206144752 | 20050206144752 | NULL | > >>| 2 | 2 | manager | 0 | > >>org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl | > >>0 | 0 | 1 | 0 | 0 | 20040522162712 | > >>20040522162712 | 20050206144752 | 20050206144752 | NULL | > >>| 3 | 3 | user | 0 | > >>org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl | > >>0 | 0 | 1 | 0 | 0 | 20040522162712 | > >>20040522162712 | 20050206144752 | 20050206144752 | NULL | > >>| 4 | 4 | tomcat | 0 | > >>org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl | > >>0 | 0 | 1 | 0 | 0 | 20040522162712 | > >>20040522162712 | 20050206144752 | 20050206144752 | NULL | > >>| 5 | 5 | jetspeed | 0 | > >>org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl | > >>0 | 0 | 1 | 0 | 0 | 20040522162712 | > >>20040522162712 | 20050206144752 | 20050206144752 | NULL | > >>| 50 | 50 | subsite | 0 | > >>org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl | > >>0 | 0 | 1 | 0 | 0 | 20050101000000 | > >>20050101000000 | 20050206144752 | 20050206144752 | NULL | > >>| 51 | 51 | subsite2 | 0 | > >>org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl | > >>0 | 0 | 1 | 0 | 0 | 20050101000000 | > >>20050101000000 | 20050206144752 | 20050206144752 | NULL | > >>+---------------+--------------+----------+------ > >>+--------------------------------------------------------------------- > >>+-----------------+------------+------------+--------------- > >>+------------+----------------+----------------+---------------- > >>+----------------+-----------------+ > >>7 rows in set (0.02 sec) > >> > >>I've even tried restarting tomcat to make sure the connection parameters > >>are the ones being used. I guess I'm really confused now. > >> > >>-Jack > >> > >>On Sun, 2005-02-06 at 23:21 +0100, Ate Douma wrote: > >> > >> > >> > >>>Just to be clear: the correct (initial) password for the admin user *is* > >>>admin > >>>(as you can see from your own select results). > >>> > >>>Now, it doesn't look your passwords are yet encrypted. That means they > >>>haven't > >>>been accessed yet. At least, not from this table. As you don't seem to > >>>have other > >>>problems during startup (indicating your not connected to any database) I > >>>suspect > >>>you might be looking at the wrong one. > >>>You probably know already Jetspeed-2 uses two different database/schemas: > >>>one for > >>>building/tests and one for production. > >>> > >>>Is it possible you are using or looking at the wrong schema for the > >>>production database? > >>>Check the jetspeed.xml in $TOMCAT/conf/Catalina/localhost. > >>>The connection parameters used by the portal at runtime are stored in > >>>there. > >>> > >>>Jack Lund wrote: > >>> > >>> > >>>>I tried those first off. No luck. Strangely enough, I also looked at the > >>>>SECURITY_CREDENTIAL table for the password. I was figuring on seeing > >>>>encrypted passwords there. Instead, this is what is in mine: > >>>> > >>>>mysql> select * from SECURITY_CREDENTIAL; > >>>>+---------------+--------------+----------+------ > >>>>+--------------------------------------------------------------------- > >>>>+-----------------+------------+------------+--------------- > >>>>+------------+----------------+----------------+---------------- > >>>>+----------------+-----------------+ > >>>>| CREDENTIAL_ID | PRINCIPAL_ID | VALUE | TYPE | CLASSNAME > >>>>| UPDATE_REQUIRED | IS_ENCODED | IS_ENABLED | AUTH_FAILURES | IS_EXPIRED > >>>>| CREATION_DATE | MODIFIED_DATE | PREV_AUTH_DATE | LAST_AUTH_DATE | > >>>>EXPIRATION_DATE | > >>>>+---------------+--------------+----------+------ > >>>>+--------------------------------------------------------------------- > >>>>+-----------------+------------+------------+--------------- > >>>>+------------+----------------+----------------+---------------- > >>>>+----------------+-----------------+ > >>>>| 1 | 1 | admin | 0 | > >>>>org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl | > >>>>0 | 0 | 1 | 0 | 0 | > >>>>20040522162712 | 20040522162712 | 20050206144752 | 20050206144752 | NULL > >>>>| > >>>>| 2 | 2 | manager | 0 | > >>>>org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl | > >>>>0 | 0 | 1 | 0 | 0 | > >>>>20040522162712 | 20040522162712 | 20050206144752 | 20050206144752 | NULL > >>>>| > >>>>| 3 | 3 | user | 0 | > >>>>org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl | > >>>>0 | 0 | 1 | 0 | 0 | > >>>>20040522162712 | 20040522162712 | 20050206144752 | 20050206144752 | NULL > >>>>| > >>>>| 4 | 4 | tomcat | 0 | > >>>>org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl | > >>>>0 | 0 | 1 | 0 | 0 | > >>>>20040522162712 | 20040522162712 | 20050206144752 | 20050206144752 | NULL > >>>>| > >>>>| 5 | 5 | jetspeed | 0 | > >>>>org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl | > >>>>0 | 0 | 1 | 0 | 0 | > >>>>20040522162712 | 20040522162712 | 20050206144752 | 20050206144752 | NULL > >>>>| > >>>>| 50 | 50 | subsite | 0 | > >>>>org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl | > >>>>0 | 0 | 1 | 0 | 0 | > >>>>20050101000000 | 20050101000000 | 20050206144752 | 20050206144752 | NULL > >>>>| > >>>>| 51 | 51 | subsite2 | 0 | > >>>>org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl | > >>>>0 | 0 | 1 | 0 | 0 | > >>>>20050101000000 | 20050101000000 | 20050206144752 | 20050206144752 | NULL > >>>>| > >>>>+---------------+--------------+----------+------ > >>>>+--------------------------------------------------------------------- > >>>>+-----------------+------------+------------+--------------- > >>>>+------------+----------------+----------------+---------------- > >>>>+----------------+-----------------+ > >>>>7 rows in set (0.00 sec) > >>>> > >>>>I don't see any encrypted passwords there. I do see what might be > >>>>unencrypted passwords, in column 3, but I tried those and it didn't > >>>>work. Also, even though I have tried and failed several passwords, the > >>>>AUTH_FAILURES and IS_ENABLED columns haven't changed. Obviously, I'm > >>>>missing something, but I don't know what it is. > >>>> > >>>>Just for some background, I initially tried the default hypersonic > >>>>database, and couldn't get in using admin/admin, admin/jetspeed, or > >>>>anything else I could think of to try, and I figured it would be easier > >>>>for me to look at the DB tables from mysql, so I moved everything to > >>>>mysql (which wasn't too bad, really, thanks to the docs), and got it > >>>>going again. I don't have hypersonic running, so I'm pretty sure it's > >>>>not going against that DB, but I really can't explain why none of this > >>>>is working. > >>>> > >>>>Again, any help would be appreciated. > >>>> > >>>>-Jack > >>>> > >>>>On Sun, 2005-02-06 at 22:36 +0100, Ate Douma wrote: > >>>> > >>>> > >>>> > >>>> > >>>>>Jack, > >>>>> > >>>>>The default/demo user accounts are inserted in the database table > >>>>>SECURITY_CREDENTIAL > >>>>>by the database dependent populate-userinfo-for-default-psml.sql scripts > >>>>>which > >>>>>you can find under the src/sql folder. > >>>>>For all these accounts the (initial) password is the same as the user > >>>>>name: > >>>>> > >>>>> admin/admin > >>>>> jetspeed/jetspeed > >>>>> user/user > >>>>> > >>>>> et cetera > >>>>> > >>>>>Now, as you probably have tried more than 3 times different passwords > >>>>>for the > >>>>>admin user, you are in bad luck: the account will be locked out by now > >>>>>by the > >>>>>default configured security rules! > >>>>>You can re enable a user account by setting the IS_ENABLED column value > >>>>>for the > >>>>>admin user back to 1 (it will be 0 if the account is locked out). > >>>>> > >>>>>To determine which record actually is the one for the admin user, find > >>>>>the record with: > >>>>> SECURITY_CREDENTIAL.PRINCIPAL_ID = SECURITY_PRINCIPAL.PRINCIPAL_ID > >>>>> AND SECURITY_PRINCIPAL.FULL_PATH = '/user/admin' > >>>>>or just set them all back to value 1. > >>>>> > >>>>>The reason you couldn't find the correct password (anymore) for the > >>>>>admin user > >>>>>in the database is because it is encrypted by now. Initially, these > >>>>>aren't encrypted > >>>>>as you can find out from the populate scripts, but they will be at first > >>>>>access > >>>>>(with the default configured security rules that is). > >>>>> > >>>>>Once you have re enabled the admin user and can login with admin/admin, > >>>>>you can use > >>>>>the administrative UserManagement portlets to enable other user accounts > >>>>>which might > >>>>>have been locked out again. > >>>>> > >>>>>Note: at first login, you'll be required to change the password again ;-) > >>>>> > >>>>>And yes, you are right, we should document this more prominently I guess > >>>>>:-) > >>>>> > >>>>>Regards, > >>>>> > >>>>>ATe > >>>>> > >>>>>Jack Lund wrote: > >>>>> > >>>>> > >>>>> > >>>>>>Hi. I apologize if this is a newbie question, but I'm having a lot of > >>>>>>trouble logging in as admin with my jetspeed 2 installation. The > >>>>>>jetspeed 2 docs don't seem to have any indication (that I have seen) of > >>>>>>what the default admin password is, and I've tried the one listed in the > >>>>>>jetspeed 1 docs, plus any others I could think of. I've also tried > >>>>>>looking for docs on where the passwords are kept, with no luck. I've > >>>>>>also tried just looking through the DB tables, again with no luck. > >>>>>> > >>>>>>Please, any assistance would be greatly appreciated. > >>>>>> > >>>>>>Thanks. > >>>>>> > >>>>>> > >>>>>> > >>>>>--------------------------------------------------------------------- > >>>>>To unsubscribe, e-mail: [EMAIL PROTECTED] > >>>>>For additional commands, e-mail: [EMAIL PROTECTED] > >>>>> > >>>>> > >>>> > >>>> > >>>--------------------------------------------------------------------- > >>>To unsubscribe, e-mail: [EMAIL PROTECTED] > >>>For additional commands, e-mail: [EMAIL PROTECTED] > >>> > >>> > > > > > > -- Jack Lund <[EMAIL PROTECTED]> Geekheads
