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
