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]
