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