Hi,I am testing the GeoPortal 1.1. I have installed it on my PC. Here is what got installed so far:- JDK 6u26
- Apache Tomcat 6.0.32
- ArcGIS JS API 2.3
- Oracle client 10.2.0
- The Oracle server is running 11g (11.1.0.7.0)
My PC is running XP Pro SP3, IIS 5.1. I have selected "Simple Authentication" for our tests. After doing all the configuration in the Intastallation Guide, I started doing the "Smoketest". When I launched the geoportal, and logged in as administrator, I did get the Administrator tab, but not the Repositories tab. Therefore, I started looking in the Apache log files. in the gpt.2011-06-15.log, i found the following at the top of the file:
15-Jun-2011 9:08:02 AM com.sun.faces.config.ConfigureListener contextInitialized
INFO: Initializing Mojarra 2.0.3 (FCS b03) for context '/geoportal'
15-Jun-2011 9:08:04 AM org.apache.struts.action.ActionServlet initChain
INFO: Loading chain catalog from jar:file:/C:/Program%20Files/Apache%20Software%20Foundation/Tomcat%206.0/webapps/geoportal/WEB-INF/lib/struts-tiles-1.3.10.jar!/org/apache/struts/tiles/chain-config.xml
15-Jun-2011 9:08:04 AM org.apache.struts.tiles.TilesPlugin initDefinitionsFactory
INFO: Tiles definition factory loaded for module ''.
15-Jun-2011 9:08:04 AM com.esri.gpt.framework.context.InitializationServlet init
INFO: Initializing ApplicationContext...
15-Jun-2011 9:08:04 AM com.esri.gpt.framework.context.ApplicationConfigurationLoader load
FINE: Loading configuration file: gpt/config/gpt.xml
15-Jun-2011 9:08:05 AM com.esri.gpt.framework.sql.DatabaseReference testConnection
SEVERE: Connection test failed.
java.sql.SQLException: ORA-01017: invalid username/password; logon denied
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:406)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:799)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:368)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:508)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:275)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:206)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:156)
at com.esri.gpt.framework.sql.DatabaseReference.openJndiConnection(Unknown Source)
at com.esri.gpt.framework.sql.DatabaseReference.openConnection(Unknown Source)
at com.esri.gpt.framework.sql.DatabaseReference.testConnection(Unknown Source)
at com.esri.gpt.framework.sql.DatabaseReferences.add(Unknown Source)
at com.esri.gpt.framework.context.ApplicationConfigurationLoader.loadDatabase(Unknown Source)
at com.esri.gpt.framework.context.ApplicationConfigurationLoader.load(Unknown Source)
at com.esri.gpt.framework.context.ApplicationContext.loadConfiguration(Unknown Source)
at com.esri.gpt.framework.context.ApplicationContext.getInstance(Unknown Source)
at com.esri.gpt.framework.context.InitializationServlet.init(Unknown Source)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4420)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4733)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1315)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1061)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
at org.apache.catalina.core.StandardService.start(StandardService.java:525)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
This indicates a problem connecting to the database using JDBC. I know that the username/password I used is ok, because I can connect to the database using SQL Navigator which also indicates that the TNSNAME entry is good. Here is the content of "geoportal.xml", with username/password not shown:
<Context docBase="geoportal" path="/geoportal" debug="0" reloadable="true" crossContext="true">
<Resource name="jdbc/gpt" auth="Container"
type="oracle.jdbc.pool.OracleDataSource"
factory="oracle.jdbc.pool.OracleDataSourceFactory"
driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@mib-dev:1521:MIBDEV1"
username="xyz"
password="*******"
maxActive="20"
maxIdle="10"
maxWait="-1" />
</Context>
Can anyone help?Thanks,Paul