The error is "java.lang.NoClassDefFoundError: org/apache/tomcat/dbcp/dbcp/BasicDataSource." That class should be in Tomcat's database connection pooling jar in your /tomcat5/common/lib directory.

As I recall, this is a Linux install.

Some questions:

• What version of Linux are you using?
• What version of Tomcat did you install? We strongly recommend 5.5.9, the version we use and test extensively here.
• Do you have a file called "naming-factory-dbcp.jar" in your /tomcat5/common/lib directory?

If the file doesn't exist it likely means your Tomcat installation doesn't include database connection pooling for some reason; you'll need to get that enabled for CPAS to work.

If it does exist, then something strange is going on…

To answer your questions

• Fedora Core 4
• Apache Tomcat/5.0
• I have just 'naming-factory.jar' in common/lib (If I upgrade to Tomcat 5.5.9, will it be included?)

We've never tested on Tomcat 5.0, so I'm sure that's the problem. Install 5.5.9 from the archive: http://archive.apache.org/dist/tomcat/tomcat-5/archive/v5.5.9/

5.5.9 release notes claim that naming-factory-dbcp.jar is included.

Thanks, Trying with 5.5.9

I'll post the results

That worked, new problem though!

I am able to partially load the first page (with CPAS logo and sign-in links at the top), but I get this error. (I found a tomcat-5.5.12 release on my machine that I've started using, had some issues getting the 5.5.9 to run. If that is the root of this problem, then I'll switch back)
------
A failure occurred during CPAS server startup:

java.sql.SQLException: ERROR: schema "core" does not exist
       at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1356)
       at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1151)
       at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:166)
       at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:363)
       at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:308)
       at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:223)
       at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
       at org.fhcrc.cpas.data.Table.internalExecuteQuery(Table.java:164)
       at org.fhcrc.cpas.data.Table.select(Table.java:978)
       at org.fhcrc.cpas.data.Table.internalSelect(Table.java:941)
       at org.fhcrc.cpas.data.Table.select(Table.java:916)
       at org.fhcrc.cpas.module.ModuleLoader.doInit(ModuleLoader.java:149)
       at org.fhcrc.cpas.module.ModuleLoader.init(ModuleLoader.java:88)
       at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:225)
       at org.apache.catalina.core.ApplicationFilterConfig.setFilterDef(ApplicationFilterConfig.java:308)
       at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:79)
       at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:3563)
       at org.apache.catalina.core.StandardContext.start(StandardContext.java:4133)
       at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
       at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
       at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
       at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:603)
       at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:535)
       at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:470)
       at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1118)
       at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
       at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
       at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1020)
       at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
       at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
       at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
       at org.apache.catalina.core.StandardService.start(StandardService.java:450)
       at org.apache.catalina.core.StandardServer.start(StandardServer.java:680)
       at org.apache.catalina.startup.Catalina.start(Catalina.java:536)
       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:585)
       at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:275)
       at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)

Please post your full cpas.log file.

attached

The first error in the log is "java.lang.ClassNotFoundException: org.postgresql.Driver"

Did you copy the four jar files from the CPAS distribution into your /tomcat5/common/lib directory? One of these jars is postgresql.jar, the PostgreSQL JDBC driver.

Yeah, I did. Unfortunately, I think I've suffeciently bungled my system with multiple versions of tomcat, postgres, etc, and I'm back to the original 500 Server error. I'm going to try to clean up and start over...

BTW, I was having a difficult time finding a mirror of Postgres-8.0.3. Seems like most of them were down. Is it possible to use a more current release?

I would like to say Thanks for the timely help in the matter! It's much appreciated, Jason

Not exactly what we like to hear, but okay. Good luck.

If you can't find PostgreSQL 8.0.3 then the most recent 8.0.x release, 8.0.6, should be okay. Do not install PostgreSQL 8.1 at this point… we have some known incompatibilities (which of course we're fixing in our next release).

I've

• installed tomcat 5.5.9, and PostgreSQL8.0.6
• created the cpas database while logged in as the postgres user (the admin, whose login info is in the cpas.xml file).
• copied all the CPAS/lib jar files over to tomcat/common/lib
• copied all the necessary .exe files to tomcat/bin

Upon starting tomcat (startup.sh), I get this in the cpas.log...(attached) It seems that I'm not able to get the admin postgres user to log in properly. Is there a way I can test this using tomcat?

You should just test your PostgreSQL login using a standard tool, for example:

• pgAdmin III (the PostgreSQL GUI admin tool)
• psql (the command line admin tool)
• PGTest (the simple command line script/app I posted on the support board)

Get a successful login using one of these tools, then put that admin user and password into cpas.xml.

Adam

We're connecting! I think had some leftover PostgreSQL artifacts that were thowing a wrench into things.

Now I'm getting this error (with the CPAS logo, and sign-in links at the top of the web page)
----
A failure occurred during CPAS server startup:

java.sql.SQLException: ERROR: schema "core" does not exist
       at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1356)
       at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1151)
       at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:166)
       at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:363)
       at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:308)
       at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:223)
       at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
       at org.fhcrc.cpas.data.Table.internalExecuteQuery(Table.java:164)
       at org.fhcrc.cpas.data.Table.select(Table.java:978)
       at org.fhcrc.cpas.data.Table.internalSelect(Table.java:941)
       at org.fhcrc.cpas.data.Table.select(Table.java:916)
       at org.fhcrc.cpas.module.ModuleLoader.doInit(ModuleLoader.java:149)
       at org.fhcrc.cpas.module.ModuleLoader.init(ModuleLoader.java:88)
       at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:225)
       at org.apache.catalina.core.ApplicationFilterConfig.setFilterDef(ApplicationFilterConfig.java:308)
       at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:79)
       at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:3540)
       at org.apache.catalina.core.StandardContext.start(StandardContext.java:4110)
       at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
       at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
       at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
       at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:589)
       at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:536)
       at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:471)
       at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1102)
       at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
       at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
       at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1020)
       at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
       at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
       at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
       at org.apache.catalina.core.StandardService.start(StandardService.java:450)
       at org.apache.catalina.core.StandardServer.start(StandardServer.java:683)
       at org.apache.catalina.startup.Catalina.start(Catalina.java:537)
       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:585)
       at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271)
       at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409)

----

My guess is that during one of the configuration iterations you managed to get a "cpas" database created but the "core" sql script failed to run. That left you in a state where CPAS thinks the core schema has been created, but it hasn't.

Use pgAdmin or psql to look at your cpas database. If I'm correct, it should only have a "public" schema, no "core" schema. Assuming that's the case, stop Tomcat (so it doesn't have a connection open to PostgreSQL) and drop the cpas database using pgAdmin or the dropdb command. Then restart Tomcat. That will force the creation and running of the core script.

Fixed! That was exactly the problem. Thanks so much for your patience!